RE: sqlplus prompt question in 9i
Title: RE: sqlplus prompt question in 9i
It could be your sql
Here is the prompt I have been using for a while with no problems at all
If the db is down you get a prompt of
Nolog
set termout off
define new_prompt='nolog'
column value new_value new_prompt
select SYS_CONTEXT('USERENV', 'SESSION_USER') || ':' ||SYS_CONTEXT('USERENV', 'DB_NAME') value
from dual;
set sqlprompt new_prompt
set termout on
-Original Message-
From: Joan Hsieh [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, October 29, 2003 6:19 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: sqlplus prompt question in 9i
Guang,
You don't need to do it manually, you just type what it prompt you, it will
connect to database without any problem. It had problem in crontab batch job
only.
Joan
Quoting Guang Mei [EMAIL PROTECTED]:
Joan:
Thanks for the reply. This would work if dbstart is called when starting
instance. But if I do it manually (although not often I would say), I need
to remember this and do it by hand.
Also I think you only need to do it with dbstart script, not dbshut.
Guang
-Original Message-
Joan Hsieh
Sent: Wednesday, October 29, 2003 3:55 PM
To: Multiple recipients of list ORACLE-L
I had same problem with 9i, what I did is at the begining of the
dbstarup or stop script, I mv the glogin.sql to _old, at end of scripts
I mv back to the original name.
Joan
Guang Mei wrote:
Hi:
With Oracle 8i, I always modified $ORACLE_HOME/sqlplus/admin/glogin.sql,
and
added
set termout off
col site_name noprint new_value site_name_new
select 'SQL ' site_name from dual;
select user
|| substr(proc.program, instr(proc.program,'@'),
instr(proc.program,' ') - instr(proc.program,'@'))
|| '-SQL ' site_name
from v$process proc
where proc.pid = 2;
set sqlprompt 'site_name_new'
set termout on
so that when a user launches sqlplus, it would show something at prompt
like
[EMAIL PROTECTED]
instead of
SQL
I found that doing this in 9i will prevent me starting up my instance,
when
I use
sqlplus '/as sysdba'
In 8i, I always used svrmgrl to bounce db so there was no problem with
modified glogin.sql.
Has anyone found a work-around in 9i so that sqlplus prompt displays
username and hostname when launched? I know there is a new
_CONNECT_IDENTIFIER in 9i, but that's not good enough.
TIA.
Guang
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Guang Mei
INET: [EMAIL PROTECTED]
Fat City Network Services -- 858-538-5051 http://www.fatcity.com
San Diego, California -- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Joan Hsieh
INET: [EMAIL PROTECTED]
Fat City Network Services -- 858-538-5051 http://www.fatcity.com
San Diego, California -- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Guang Mei
INET: [EMAIL PROTECTED]
Fat City Network Services -- 858-538-5051 http://www.fatcity.com
San Diego, California -- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Joan Hsieh
INET: [EMAIL PROTECTED]
Fat City Network Services -- 858-538-5051 http://www.fatcity.com
San Diego, California -- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for
RE: Oracle 9i Rel. 2 on Red Hat Advanced Server 2.1
Title: RE: Oracle 9i Rel. 2 on Red Hat Advanced Server 2.1 1 Important Difference RHAS 2.1 is the only certified version if you are using 9.2 -Original Message- From: Kulev, Milen [mailto:[EMAIL PROTECTED]] Sent: Thursday, September 04, 2003 4:59 AM To: Multiple recipients of list ORACLE-L Subject: AW: Oracle 9i Rel. 2 on Red Hat Advanced Server 2.1 Hi Helmut , I think the papers below should give you fast start about what is so special in RHAS 2.1. http://otn.oracle.com/tech/linux/pdf/1_linuxVM_v2_accepted.pdf http://otn.oracle.com/tech/linux/pdf/9iR2-on-Linux-Tech-WP-Final.PDF HTH. Milen -Ursprüngliche Nachricht- Von: Jack van Zanen [mailto:[EMAIL PROTECTED]] Gesendet: Donnerstag, 4. September 2003 10:19 An: Multiple recipients of list ORACLE-L Betreff: RE: Oracle 9i Rel. 2 on Red Hat Advanced Server 2.1 I have been led to believe that AS2.1 has been optimized on for instance I/O and is therefore a lot faster on the I/O side (I believe it is async I/O that was worked on) Probably some other issues as well but this one stuck. I have no experience with it though. -Original Message- Sent: Thursday, September 04, 2003 10:04 AM To: Multiple recipients of list ORACLE-L Hi! Is anybody using Oracle 9i on Red Hat Advanced Server? I just installed RAS 2.1 and did not notice much difference to a regular Red Hat Installation... What is the beig difference between Advanced Server and regular Red Har Linux? Thanks, Helmut -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jack van Zanen INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Kulev, Milen INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Oracle Licences Req on Intel Xeon CPU
Title: RE: Oracle Licences Req on Intel Xeon CPU Yes Redhat Advanced Server 2.1 does support hyperthreading. Its not to bad either. I ran some tests and we get about a 15% increase in performance with hyperthreading turned on. -Original Message- From: Michael Brown [mailto:[EMAIL PROTECTED]] Sent: Wednesday, March 26, 2003 8:09 AM To: Multiple recipients of list ORACLE-L Subject: RE: Oracle Licences Req on Intel Xeon CPU 2000 only shows 2 CPUs because it cannot take advantage hyperthreading. From what I have read (Intel's website, some others), hyperthreading requires both BIOS and OS support to be utilized. Currently, XP and the newer Linux releases are all that I have seen that will take advantage of it. My research on this was fairly light since I was just after can Redhat Advanced Server support it, but I do remember seeing that W2K would not. -- Michael BrownGlen Raven, Inc./Info Services Senior Oracle DBA 1831 N. Park Ave Phone: (336)586-1146 Glen Raven, NC 27217 Fax: (336)586-1382 [EMAIL PROTECTED] -Original Message- Sent: Wednesday, March 26, 2003 3:44 AM To: Multiple recipients of list ORACLE-L Depending on the OS, Microsoft has different CPU counts. The Windows 2000 family counts each hyper thread as 1 CPU. In contrast, Windows XP and Windows 2003 Server count each CPU instead of each hyper thread. Thus, the task manager in Windows XP Professional show 4 CPU's (on a dual XEON CPU computer with hyper threading enabled) while Windows 2000 Professional only shows 2 CPU's in the task manager. Have Fun :) [EMAIL PROTECTED] wrote: Hi all For those that are running or intending on running Oracle on Intel's Xeon CPU, the following information may be of interest to you. The Xeon CPU has a feature called Hyper Threading with double the number of registers. This feature when turned will present to the Operating Systems an additional virtual CPU. As far as the O/S is concern, it looks like there are _two_ CPUs. What does this mean to your software licensing? Microsoft says that it is one CPU. What does Oracle say? Well, it depends on who you speak to and what day of the week it is. Seriously, you will need to get some confirmation in writing from your account manager the next time you purchase Oracle S/w for Intel's Xeon ta tony _ / |Tony Jambu, DatabaseWeb Consultant /_ _ /_ __ / |Wizard Consulting Pty Ltd /(_)/ )(_/ \_/(///(/_)/_( |IOUG's Select Asia-Pacific Tech. Editor \___/ |EMAIL: TJambu @ wizard.cx (REMOVE Spaces from email ) |PHONE: +61-419-TJAMBU(852628) -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Chip INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Script to check for errors
Here a fast little script I wrote that can be ran every minute Emails only when it finds a new message And pages if it finds a new message between 6pm and 5am FPATH=/prod/dba/scr autoload f_xmail logfile=/prod/dba/logs/`cat /prod/dba/sys_data/newpath`/misc_logs/chk_alerts.log echo $(date +%y-%m-%d_%H:%M) BOK - $$ $logfile for i in DB1 DB2; do typeset -l sub=$(echo $i |cut -c1) alert_log=/prod/dump/$sub/alert_$i.log if [ -f $alert_log ]; then #if you don't find an alert log its ok just exit line_file=/prod/dump/$sub/ora_line if [ ! -f $line_file ]; then echo 0 $line_file fi last_line=$(cat $line_file) new_line=$(cat $alert_log |wc -l) if [ $new_line -lt $last_line ]; then #then the alter log must have been deleted and recreated last_line=0 fi if [ $(tail +$((last_line + 1)) $alert_log |grep ORA- |wc -l) -gt 0 ]; then echo $(date +%y-%m-%d_%H:%M) NEW ORA Messages Found $logfile (echo From: chk_alerts.ksh echo Subject: ORA messages found for $i \n cat $alert_log ) |mail dba@lechateau.ca #mail the entire log when new messages are found if [[ $(date +%H%M) -lt 0600 || $(date +%H%M) -gt 1800 || $(date +%u) -gt 5 ]]; then #nobody is around page also echo $(date +%y-%m-%d_%H:%M) Nobody is at work so paging also $logfile f_xmail pager ORA messages found for $i fi fi echo $new_line $line_file else echo $(date +%y-%m-%d_%H:%M) NO alert_log found to scan $logfile fi done -Original Message- From: Michael Kline [mailto:[EMAIL PROTECTED] Sent: Friday, March 21, 2003 1:40 PM To: Multiple recipients of list ORACLE-L Subject: Script to check for errors Anyone have a simple script to scan an alert log for errors and email a report if found? Customer wants something to run often, but only email when an error is found. I've got something that does a bit of that and runs twice a day, but always sends out. Thanks. Maks.
Gather_system_stats
Title: Gather_system_stats Hi everyone I was trying to migrate one of our applications to 9.2 and put in cost at the same time I came across Gather_system_stats and was wondering if anyone had used it? Did it improve the executions plan choice at all? Thanks David Hill DBA
RE: HPUX SCSI Performance
Title: RE: HPUX SCSI Performance It turns out it's a bug with vxfs on all Itanium system's HP is starting to work on a patch for it hopefully it'll be out soon Thanks for the input though. David Hill -Original Message- From: Rich Holland [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 20, 2003 9:39 PM To: Multiple recipients of list ORACLE-L Subject: RE: HPUX SCSI Performance Have you checked the queue depths? There are several parameters your admin can use to tune SCSI performance, but this is typically the first place to start with OLTP systems. You might also look at your buffer cache settings (HP-UX ships with these set at 10-20% I believe; in an Oracle environment, smaller cache often makes sense (anything from 2-10 depending on your I/O patterns). Rich -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On Behalf Of david hill Sent: Wednesday, February 05, 2003 2:09 PM To: Multiple recipients of list ORACLE-L Subject: RE: HPUX SCSI Performance HPUX 11i version 1.6 for itanium on vxfs -Original Message- From: Jesse, Rich [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 05, 2003 12:14 PM To: Multiple recipients of list ORACLE-L Subject: RE: HPUX SCSI Performance What OS? What filesystem? Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA -Original Message- Sent: Wednesday, February 05, 2003 10:39 AM To: Multiple recipients of list ORACLE-L Hi Guys I'm hoping there is sysadmin in the list that can help me. We just received a brand new Itanium Server to play with It has 2 U320 disk not striped or mirrored or anything Doing test and monitoring them through glance, is giving me a transfer rate of about 15Megs a sec These should be up around 60 - 80 megs right? My sysadmin says there is nothing he can do. Can someone tell if there is some sort setting he hasn't set or a config somewhere? Thanks. David Hill -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jesse, Rich INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
OT: HPUX SCSI Performance
Title: Which rollback segment is currently active? Hi Guys I'm hoping there is sysadmin in the list that can help me. We just received a brand new Itanium Server to play with It has 2 U320 disk not striped or mirrored or anything Doing test and monitoring them through glance, is giving me a transfer rate of about 15Megs a sec These should be up around 60 - 80 megs right? My sysadmin says there is nothing he can do. Can someone tell if there is some sort setting he hasn't set or a config somewhere? Thanks. David Hill
RE: HPUX SCSI Performance
Title: RE: HPUX SCSI Performance HPUX 11i version 1.6 for itanium on vxfs -Original Message- From: Jesse, Rich [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 05, 2003 12:14 PM To: Multiple recipients of list ORACLE-L Subject: RE: HPUX SCSI Performance What OS? What filesystem? Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA -Original Message- Sent: Wednesday, February 05, 2003 10:39 AM To: Multiple recipients of list ORACLE-L Hi Guys I'm hoping there is sysadmin in the list that can help me. We just received a brand new Itanium Server to play with It has 2 U320 disk not striped or mirrored or anything Doing test and monitoring them through glance, is giving me a transfer rate of about 15Megs a sec These should be up around 60 - 80 megs right? My sysadmin says there is nothing he can do. Can someone tell if there is some sort setting he hasn't set or a config somewhere? Thanks. David Hill -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jesse, Rich INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: AUTORAID and VA7100 disk arrays for rp7400
Title: RE: AUTORAID and VA7100 disk arrays for rp7400 Yep I have same thing to say We have a HP N class with 3 HP AutoRaid's I recently did a test to import our 50 gig database On the HP it took 4 hours to do a Full export of DB and 12+ hours to import I then proceeded to import the exact same dump file on a little Linux Xeon test box with IDE HD's just 2 120 Gig mirrored yes that right IDE. And to import the full DB took 4 Hours!!! Those IDE HD's cost $300 each And those AutoRaids are costing us $1000 a month in support alone. So we will soon changing out IO subsystem that cost's a lot less, has more storage, and better performance. -Original Message- From: Vergara, Michael (TEM) [mailto:[EMAIL PROTECTED]] Sent: Thursday, January 23, 2003 4:40 PM To: Multiple recipients of list ORACLE-L Subject: RE: AUTORAID and VA7100 disk arrays for rp7400 I'm not sure what a VA7100 is, so I don't want to tell you to avoid it. The AutoRaid I used just said AutoRaid on the front. It had 12 disks...I think they were 9G or 18G each. It had only 96M of cache, not expandable. Only 2 SCSI channels - not expandable. What happened was that our whole database was on this array. Yes, even on-line and archived redo logs. The array did so much internal thrashing that the disk response times were abysmal. RANT The boss got it cause he didn't want to pay the extra $$$ for a 'real' array from EMC, Hitachi, or IBM. It had the magic word 'Raid' in the name so he went for it, and then was all over me because the system was so slow. I should'a known what was up when a JBOD D-370 2-way did stuff faster than our K570 6-way and the AutoRaid. /RANT Take my advice - don't go with an AutoRaid. Cheers, Mike -Original Message- Sent: Thursday, January 23, 2003 12:45 PM To: Multiple recipients of list ORACLE-L Michael, a dumb question. does this stops me from using VA7100 with 0+1 or are u talking about going some other disk array product? Thanks Mandar -Original Message- From: Vergara, Michael (TEM) [mailto:[EMAIL PROTECTED]] Sent: Thursday, January 23, 2003 12:00 PM To: Multiple recipients of list ORACLE-L Subject: RE: AUTORAID and VA7100 disk arrays for rp7400 Apologies to all for shouting, but ... DO NOT USE AUTORAID! ** *** *** * I used an AutoRaid system when I was at Petco. Performance was el-sucko. There was more I/Os happening in the disk array (by observing the disk lights) than was being caused by the application and database. Plus, when the AR system Raid 0+1/5 mode, where some blocks are kept in a RAID 0+1 area and some are kept in a RAID 5 area, the array got so busy swapping one for another that it was virtually useless. Fiber channel (FC-10) works ok, Clariion (by EMC) works Ok, heck, even JBOD works better than AutoRaid. Just my 2¢ worth. Cheers, Mike -Original Message- Sent: Thursday, January 23, 2003 11:35 AM To: Multiple recipients of list ORACLE-L Hi, i am in the process of defining the specs for a rp7400. a lil overwhelmed by the storage offerings from HP. i wanted to know if any of ull hv any inputs regarding a disk array. we currently hv a Model 30/FC disk array with 9gig drives. I am looking for a similar or the next higher configuration disk array from HP. Any inputs regarding VA7100 disk array or corresponding competetive disk aray from HP/competitor? cache size 256/512/1024 MB? dont know which to go. thinking of going for 18GB 15k rpm rather than 36GB 15K rpm. faster smaller drives. the va7100 product specs on HP site mention more about AutoRAID (which is dynamic 0+1 or 5 configuration on the fly). any inputs on AutoRAID for Oracle database files. hv ull used 0+1 h/w configuration on VA7100? am i talking sense? a good article to read, especially page 4 http://www.hp.com/products1/storage/products/disk_arrays/infol ibrary/hp_va_and_san_virtualization.pdf any inputs related to configuring a rp7400 are invited. my initial specs based on my current k570 is below. current k570 (7.3.4) 4 * 200Mhz 2 gn ram specs for rp7400 (8i/9i) 4 * 550MHz 6 Gb ram and i thought it was easy. take a few procs add ram add few disks, (Baaam!) make sound and license and u hv a server. but look into a detailed partlist and configuration options at https://www.e-solutions.hp.com/shop/cgi-bin/sweetspot.cgi Thanks Mandar -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Vergara, Michael (TEM) INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed
RE: Out of topic -Unx question
Title: RE: Out of topic -Unx question The cheap easy way Is to have a cron job that runs at midnight and echo's today's date to a file called today.date But before that it copies that file to yesterday.date Then all you have to do is cat yesterday.date to get the date. It may not be the prettiest way but it works. -Original Message- From: Richard Ji [mailto:[EMAIL PROTECTED]] Sent: Monday, December 23, 2002 1:04 AM To: Multiple recipients of list ORACLE-L Subject: RE: Out of topic -Unx question Search the archive of this list. This has been discussed before. You can use a trick such as this: yesterday=$(TZ=EST26EDT date +%a) but beaware that this is not a portable solution. You can write your own script. E-mail me off line and I can send you mine yesterday script. -Original Message- Sent: Monday, December 23, 2002 12:09 AM To: Multiple recipients of list ORACLE-L Not easily done in Unix. However, if you've got an Oracle db running on the same server you might want to get yesterday's date from Oracle (within a shell script). ... ... YESTERDAY=`sqlplus -s / -EOF set head off feed off pages 0 select trunc(sysdate - 1) from dual; exit EOF` echo YESTERDAY is $YESTERDAY ... ... hth, Ross -Original Message- Sent: Saturday, 21 December 2002 7:51 To: Multiple recipients of list ORACLE-L Hi All, I want to get previous date from today's date.Is there any cmd for this. Thanks Manoj -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ross Collado INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Richard Ji INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
OT: Logitech Give Away
Title: OT: Logitech Give Away Just to let everybody know to try and visit www.logitech.com They are giving away 20,000 mice and keyboards today Hopefully it'll make somebody's holiday's Merry Christmas David Hill Oracle DBA Le Chateau
RE: Oracle bug 2316137
Title: RE: Oracle bug 2316137 You could always install oracle in another oracle home, Patch that home Then all you need is 1 min down time to shutdown the db and bring it up with the other patched oracle. -Original Message- From: Glenn Stauffer [mailto:[EMAIL PROTECTED]] Sent: Wednesday, December 18, 2002 10:20 AM To: Multiple recipients of list ORACLE-L Subject: Oracle bug 2316137 We've just started experiencing a problem where a client-server Forms 4.5 application hangs and then produces this error: ORA-00600: internal error code, arguments: [kksscl-inf-inl-loop], [1500], [0], [1], [41], [41], [], [] Our database is version 9.2 and we found reference to a bug on metalink, 2316137, though we can't see the details. We are planning an off-hours upgrade to 9.2.0.2 which is said to fix this problem; in the meantime, we can clear up the condition causing this error by bouncing the instance. Then things work for a while until the error starts to occur again (last time it cleared up for about a week). Since it is several weeks before I can get the downtime to apply the upgrade, I'm wondering if anyone has had experience with this problem and whether there is a temporary fix short of updating the Oracle software. Thanks -- Glenn Stauffer [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Glenn Stauffer INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Itanium 2
Title: Itanium 2 Has anybody out there tried and Itanium 2 system? I read that oracle is supposed to certify 9i on it at the end of the month. But I was wondering if anybody had installed one of the Developer Release's. If so what kind of performance did it give you? Anywhere close to what Intel is claiming?
RE: password
Title: RE: password I created a user test identified by test on 2 separate systems in db's with different names The password value was the same Can someone verify if it is the same on their system Create user test identified by test; select password from dba_users where username = 'TEST'; PASSWORD -- 7A0F2B316C212D67 -Original Message- From: Rachel Carmichael [mailto:[EMAIL PROTECTED]] Sent: Tuesday, December 17, 2002 3:15 PM To: Multiple recipients of list ORACLE-L Subject: RE: password how does trying a password on your own private database help crack a password on a different database? I vaguely recall a conversation (I *think* it was with Kevin Loney) that part of the encryption key is the database name as well. --- Ari Kaplan [EMAIL PROTECTED] wrote: This program allows you to attemp password guesses on a different database. So, the program gets around the x invalid tries and the account locks by enabling the user to try passwords on their own private database. That's what their documentation said, anyway. -Ari -Original Message- Carmichael Sent: Tuesday, December 17, 2002 1:16 PM To: Multiple recipients of list ORACLE-L it's definitely a one-way encryption on the password, I forget where I read it but I do know that's true. I think that in addition to a strong password, if you lock an account after x failed attempts then they'd have to be REALLY lucky to guess it on the first few tries. Rachel --- John Kanagaraj [EMAIL PROTECTED] wrote: Jared, This seems to be a 'brute force' dictionary based attack, as I believe the Oracle password is a one-way trapdoor (just as UNIX). I don't think this will be able to crack a strong password created from say a combination of the first characters of an arbitrary sentence. John Kanagaraj Oracle Applications DBA DBSoft Inc (W): 408-970-7002 So WHO is the Reason for the Season?! Write me for details! ** The opinions and statements above are entirely my own and not those of my employer or clients ** -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Tuesday, December 17, 2002 9:09 AM To: Multiple recipients of list ORACLE-L Subject: RE: password Hmm... Well maybe you *can* crack oracle passwords. I've just ordered the full version of this product. ( $4, I don't think I need to bother the purchasing department ). I'll let you know how it works. Jared -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: John Kanagaraj INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ Do you Yahoo!? Yahoo! Mail Plus - Powerful. Affordable. Sign up now. http://mailplus.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ari Kaplan INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ Do you Yahoo!? Yahoo! Mail Plus - Powerful. Affordable. Sign up now. http://mailplus.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services --
RE: password
Title: RE: password This works too A password calculator http://lastbit.com/pswcalc.asp -Original Message- From: Paul Heely [mailto:[EMAIL PROTECTED]] Sent: Tuesday, December 17, 2002 4:19 PM To: Multiple recipients of list ORACLE-L Subject: RE: password UGH! Should have been 26^6 possible passwords NOT 6^26! So... Ignore my previous math. Have to go now. Hanging head in mathematical shame. Correct times for all uppercase: 3 seconds Correct times for upper and lower: 3.2 minutes Now if I can only find the machine to do 100,000,000 attacks/s. -- Paul -Original Message- Sent: Tuesday, December 17, 2002 3:20 PM To: Multiple recipients of list ORACLE-L I used to work as a Unix security admin and would frequently run password cracking programs against our password files. We found that the really weak passwords were found in the first 5 minutes, ones derived from info in the gecos fields. Better ones, using number/letter substitutions in common dictionary words, would be found in the next day or so. We stopped running after 48 hours. We never found that brute force iteration was worthwhile. Consider the following if you are thinking of using a totally brute force approach and trying all possible combinations. I needed a break this afternoon... Assumptions: All passwords are 6 characters long and all characters are upper case. There are 6^26=170,581,728,179,578,208,256 possible passwords If you can attack 100,000,000 passwords per second you will need (6^26)/100,000,000 = 1,705,817,281,795 seconds. 1,705,817,281,795s * 1h/3600s = 473,838,133 hours 473,838,133,832h * 1d/24h = 19,743,255 days 19,743,255,576d * 1y/365d = 54,091 years If we add the condition that passwords can be upper and lower case then there are 6^26 possible passwords and the time to attack all possible combinations becomes: 9.226E24 years. Back to work now :) -- Paul -Original Message- Waleed Sent: Tuesday, December 17, 2002 2:16 PM To: Multiple recipients of list ORACLE-L It's one way encryption. So you can loop on all the permutation for AA to ZZ and apply the encryption code and compare the output to the dictionary content. If it matches, then you got the password. I thought about doing this five years ago, but decided against it. I thought I will be under the hackers, virus developers groups. Regards, Waleed -Original Message- Sent: Tuesday, December 17, 2002 12:04 PM To: Multiple recipients of list ORACLE-L How, Oracle does not publish the password encryption algorithm, and I don't believe anyone has cracked it. Jared Paulo Gomes [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 12/17/2002 04:38 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject: RE: password nope u can get the encripted password from the oracle dictionáry -Original Message- Sent: terça-feira, 17 de Dezembro de 2002 11:34 To: Multiple recipients of list ORACLE-L Check the post-it note on their monitor? :) -Original Message- Sent: 17 December 2002 10:55 To: Multiple recipients of list ORACLE-L he can't but he can change it to a new one and then put the old back on -Original Message- Sent: terça-feira, 17 de Dezembro de 2002 4:09 To: Multiple recipients of list ORACLE-L how can a dba see the password of a user. The new MSN 8: smart spam protection and 2 months FREE* -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: faisal ahmad INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Khedr, Waleed INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services
RE: Ltrim?
Title: RE: Ltrim? Should be something like this 0 6 * * 1 ksh myscript.ksh -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Friday, November 22, 2002 9:19 AM To: Multiple recipients of list ORACLE-L Subject: Ltrim? Hallo, Anyone whom could help me how to write in cron when scheduling the start of a unixprogram. I would like that the unix script will run every monday on 6 am. I have tried but it fails. Any suggestions, please help Roland -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Dynamic views
Title: Dynamic views Hi Guys I'm trying to see if I can get around paying oracle $50,000 for partitioning I have a huge table and I want to partition it on date so I created 12 tables _JAN _FEB And so on But I want to create a view that will be used for inserting so it always Points to the current month without having to recreate the view every month. Is there anyway anybody can think of doing this? Thanks David Hill DBA Le Chateau
RE: How to zip a file on From Unix shell script
Try doing a google on pkzip for unix We have it our HP-UX box it works fine -Original Message- From: WLSH [mailto:[EMAIL PROTECTED]] Sent: Thursday, October 17, 2002 11:35 AM To: Multiple recipients of list ORACLE-L Subject: Re: How to zip a file on >From Unix shell script Thanks, all: We have compress available currently, but not gzip or zip. We will try compress. Mark Richard [EMAIL PROTECTED] wrote: RWB is correct - and the good news is that WinZip (a likely program at the destination of your email) handles tar-ed and compress-ed files fine. Of course it may pay to add the .zip extension to the filename so that the mail client knows what to do with it. Reginald.W.Bailey@jp morgan.com To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>Sent by: cc: [EMAIL PROTECTED] Subject: Re: How to zip a file on From Unix shell script 17/10/02 09:38 Please respond to ORACLE-L You can use compress or gzip to compress a file. compress -v [filename] should compress the file and tell you the percentage as well. Gzip is a GNU utility that may be on your system. These utilities may not be in your current path. RWB WLSH <[EMAIL PROTECTED]>@fatcity.com on 10/16/2002 0! ! 5:43:33 PM Please respond to [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>cc: Hello, list: We have a unix nightly job which will send an email to a user. However, the file size is very large, so we need to zip the file before we send it out. Does anyone know the syntax or command of zipping a file from UNIX ? Regards, [EMAIL PROTECTED] Do you Yahoo!? Faith Hill - Exclusive Performances, Videos, more faith.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services - To REMOVE yourself from this mai! ! ling list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Privileged/Confidential information may be contained in this message. If you are not the addressee indicated in this message (or responsible for delivery of the message to such person), you may not copy or deliver this message to anyone. In such case, you should destroy this message and kindly notify the sender by reply e-mail or by tele! ! phone on (61 3) 9612-6999. Please advise immediately if you or your employer does not consent to Internet e-mail for messages of this kind. Opinions, conclusions and other information in this message that do not relate to the official business of Transurban City Link Ltd shall be understood as neither given nor endorsed by it. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mark Richard INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --! ! --- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Regards, [EMAIL PROTECTED] Do you Yahoo!? Faith Hill - Exclusive Performances, Videos, more faith.yahoo.com
RE: How to zip a file on From Unix shell script
You have to use uuencode Something like this (echo TEST uuencode file1 file1 ) |mail dba -Original Message- From: Markham, Richard [mailto:[EMAIL PROTECTED]] Sent: Thursday, October 17, 2002 12:34 PM To: Multiple recipients of list ORACLE-L Subject: RE: How to zip a file on >From Unix shell script I'm curious how you get sendmail/mailx to send a file as an attachment? I suppose it can be done. -Original Message- From: Tim Gorman [mailto:[EMAIL PROTECTED]] Sent: Thursday, October 17, 2002 11:59 AM To: Multiple recipients of list ORACLE-L Subject: Re: How to zip a file on >From Unix shell script you can download it at http://www.gnu.org/software/gzip/gzip.html... - Original Message - From: WLSH To: Multiple recipients of list ORACLE-L Sent: Thursday, October 17, 2002 9:34 AM Subject: Re: How to zip a file on From Unix shell script Thanks, all: We have compress available currently, but not gzip or zip. We will try compress. Mark Richard [EMAIL PROTECTED] wrote: RWB is correct - and the good news is that WinZip (a likely program at the destination of your email) handles tar-ed and compress-ed files fine. Of course it may pay to add the .zip extension to the filename so that the mail client knows what to do with it. Reginald.W.Bailey@jp morgan.com To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>Sent by: cc: [EMAIL PROTECTED] Subject: Re: How to zip a file on From Unix shell script 17/10/02 09:38 Please respond to ORACLE-L You can use compress or gzip to compress a file. compress -v [filename] should compress the file and tell you the percentage as well. Gzip is a GNU utility that may be on your system. These utilities may not be in your current path. RWB WLSH <[EMAIL PROTECTED]>@fatcity.com on 10/16/2002 0! ! 5:43:33 PM Please respond to [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>cc: Hello, list: We have a unix nightly job which will send an email to a user. However, the file size is very large, so we need to zip the file before we send it out. Does anyone know the syntax or command of zipping a file from UNIX ? Regards, [EMAIL PROTECTED] Do you Yahoo!? Faith Hill - Exclusive Performances, Videos, more faith.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services - To REMOVE yourself from this mai! ! ling list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Privileged/Confidential information may be contained in this message. If you are not the addressee indicated in this message (or responsible for delivery of the message to such person), you may not copy or deliver this message to anyone. In such case, you should destroy this message and kindly notify the sender by reply e-mail or by tele! ! phone on (61 3) 9612-6999. Please advise immediately if you or your employer does not consent to Internet e-mail for messages of this kind. Opinions, conclusions and other information in this message that do not relate to the official business of Transurban City Link Ltd shall be understood as neither given nor endorsed by it. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mark Richard INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --! ! --- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Regards, [EMAIL PROTECTED] Do you Yahoo!? Faith Hill - Exclusive Performances, Videos, more faith.yahoo.com
Server Performance
Title: Server Performance Hi everybody We were have some Oracle licensing Issues They have just changed their Minimum licenses from 10/cpu to 25/cpu Anywayz I was debating whether or not my HP 6-way 220 mhz machine would be faster than a 2-way intel 2.4 XEON machine Any ideas anybody?
OT: Looking for Contacts in GTA
Hi Guys I was just wondering if anybody could help me and send me some contacts or head hunter's in GTA. I'm currently Working in Montreal and am looking to move to Toronto. I'm a DBA with 3 years experience and am in desperate need of a new challenge. Any help would be greatly appreciated. Thanks David Hill DBA -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: David Hill INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: DUAL revisited
Just wondering here but has anyone tried doing that select from something like v$database; Statistics -- 0 recursive calls 0 db block gets 0 consistent gets 0 physical reads 0 redo size 187 bytes sent via SQL*Net to client 248 bytes received via SQL*Net from client 2 SQL*Net roundtrips to/from client 0 sorts (memory) 0 sorts (disk) 1 rows processed that looks pretty good to me!! -Original Message- Sent: Friday, August 02, 2002 11:13 AM To: Multiple recipients of list ORACLE-L I've been reading the thread on DUAL vs X$DUAL, read the referenced article and tried some testing on our system. I do a simple select from DUAL and I get the same statistics as were in the article, but sometimes I also get 1 memory sort. Does anyone know why this would be? And if this is true, that really makes me want to change over to X$DUAL. Also, what is the consensus about creating a view for DUAL that references X$DUAL? I'm running the Oracle Application and cannot change all of their code to use something other than DUAL, and there is a lot of it. Here are the statistics on the select. Notice the difference between the first vs repeat of the same seelct. Connected to: Oracle8i Enterprise Edition Release 8.1.7.1.1 - Production With the Partitioning option JServer Release 8.1.7.1.1 - Production SQL set autotrace traceonly SQL select 'y' from dual; Execution Plan -- 0 SELECT STATEMENT Optimizer=CHOOSE (Cost=2 Card=1) 10 TABLE ACCESS (FULL) OF 'DUAL' (Cost=2 Card=1) Statistics -- 0 recursive calls 4 db block gets 1 consistent gets 0 physical reads 0 redo size 361 bytes sent via SQL*Net to client 425 bytes received via SQL*Net from client 2 SQL*Net roundtrips to/from client 1 sorts (memory) 0 sorts (disk) 1 rows processed SQL / Execution Plan -- 0 SELECT STATEMENT Optimizer=CHOOSE (Cost=2 Card=1) 10 TABLE ACCESS (FULL) OF 'DUAL' (Cost=2 Card=1) Statistics -- 0 recursive calls 4 db block gets 1 consistent gets 0 physical reads 0 redo size 361 bytes sent via SQL*Net to client 425 bytes received via SQL*Net from client 2 SQL*Net roundtrips to/from client 0 sorts (memory) 0 sorts (disk) 1 rows processed SQL Thanks for your input. John Zoltak North American Mfg Co 4455 East 71st Street Cleveland Ohio 44105 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: John Zoltak INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: david hill INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Patch a Patch
I was just wondering if I'm allowed to apply a new patch after I have already installed patch. Say from 8.1.7.3 to 8.1.7.4. Do I have to uninstall the .3 patch and then install the .4 or what? Thanks -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: david hill INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
PREVIOUS SQL statement
Hi Guys, I was wondering if someone could
help me
I'm trying to create an AFTER
SERVERERROR trigger that will log all errors and the SQL that caused the error.
Here's what I have so far
CREATE OR REPLACE TRIGGER server_error_trig
AFTER SERVERERROR ON DATABASE
DECLARE text varchar2(1000);
BEGIN
select sql_text into text
from v$session
a , v$sql b
where a.audsid
= sys_context('USERENV','SESSIONID')
and a.prev_sql_addr
= b.address;
INSERT INTO server_error_log
VALUES(ora_sysevent, ora_login_user, SYS_CONTEXT('USERENV','OS_USER'), SYS_CONTEXT('USERENV','CLIENT_INFO'),
sysdate, ora_server_error(1), dbms_utility.format_error_stack, text);
END;
my problem seems to be if I select * from v$session
I can see my prev_sql_addr.
BUT
If I do this
select prev_sql_addr from v$session where
AUDSID = sys_context('USERENV','SESSIONID');
it returns 00
could someone try the sql above and tell
me if works for you.
I'm running 8.1.7.3
RE: Ftp command
when you connnect through ftp i always use ftp -inv servername that stop you from having to enter Y after each file -Original Message- Sent: Monday, January 21, 2002 9:55 AM To: Multiple recipients of list ORACLE-L Hallo, anyone whom can tell me how to write the ftp command if I want to receive all files in the unix directory to the hard drive without to need reply yes for each file. using the command mget I suppose but ar ethere any options I might use. The same question if i want to copy files from harddrive to the unix library, using th ecommand mput Thanks in advance Roland S -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: david hill INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: sniped sessions
here is a little script i wrote
simpliefied a little
it first kills the session within oracle then generates the unix commands to
kill the session
so there can never a mistake about killing the wrong pid
and i also insert into an oracle table all killed sessions so you can query
them a litlle easier
---kill_sniped_session.ksh---
#!/bin/sh
#CREATE TABLE killed_sessions
# (
# SID NUMBER,
# SERIAL# NUMBER,
# SPID VARCHAR2(9),
# USERNAME VARCHAR2(30),
# TIMESTAMP DATE
# ) tablespace DBA
# STORAGE ( INITIAL 1M NEXT 1M PCTINCREASE 0);
tmpfile=/tmp/kill_sniped.$$
su - superman -c sqlplus -s /@mer 'EOF'
whenever sqlerror exit 1
whenever oserror exit 1
set serveroutput on
set feedback off
spool $tmpfile
DECLARE
Stmt_StrVARCHAR2(200);
v_Sid v\$session.sid%TYPE;
v_Serialv\$session.serial#%TYPE;
v_Username v\$session.username%TYPE;
v_spid v\$process.spid%TYPE;
CURSOR c_list IS
select a.SID, a.SERIAL#, a.USERNAME, b.SPID
from v\$session a, v\$process b
where a.paddr = b.addr
and a.STATUS = 'SNIPED';
BEGIN
FOR user in c_list
LOOP
v_sid := user.sid;
v_serial := user.serial#;
v_username := user.username;
v_spid := user.spid;
stmt_str := 'alter system kill session ''' || v_sid || ',' ||
v_serial || ;
insert into sys.killed_sessions values(v_sid, v_serial, v_spid,
v_username, sysdate);
DBMS_OUTPUT.PUT_LINE('kill -9 '|| v_spid);
Execute Immediate(stmt_str);
END LOOP;
END;
/
EOF /dev/null 21
cat $tmpfile |while read line ; do
cmd=$line
eval $cmd
done
rm -f $tmpfile
Thanks
David Hill
DBA
Le Chateau Stores
-Original Message-
Sent: Tuesday, January 15, 2002 10:06 AM
To: Multiple recipients of list ORACLE-L
Attached are the scripts we use to kill sniped sessions. This is part of a
series of monitoring scripts we developed for our Oracle databases. The
scripts are scheduled through Cron and run every 15 minutes. A logonid or
an email address is passed to the scripts for either paging or email. In
this case an accum of sniped sessions is maintained on a 'flat' file just so
we can go back and check to see how many sniped sessions are being killed.
I will attach a zip file. If that doesn't get through I will also list the
scripts below.
Ron Smith
Kerr-McGee Corp
SNIPED.SH
#! /bin/sh
# DBA MONITORING SCRIPTS
# **
#
# Author: Ron Smith
# Date: 06/18/98
# Funtion:Checks for sessions that have been Sniped.
#
# **
#
# CHANGE HISTORY
#
# DATEWHO Reason for Change
# 03/03/00Ron Smith New Prog
#
# **
#
# FUNCTION
#
# This script calls sniped.sql.
# The function of this script is to report sessions that have
# been sniped by Oracle through the use of resource limits.
#
# If the id of the DBA is a Zid, a page will be sent. If the
# id of the DBA is an email address (determined by looking for
# an @ ) , an EMAIL will be sent.
#
# **
#
# PREREQUISITES
#
# The OPS$ORACLE user must exist in the instance. This can be
# created by running the opsuer.sql script in SQLPLUS while
# logged on as SYSTEM.
#
# The cdmonitoring script must exist in the home/oracle
# directory.
#
# **
#
# RUN SYNTAX
#
# sniped.sh (sid) (oncall dba)
#
#
# **
# cd to the monitoring script directory
. $HOME/cdmonitoring.sh
ORACLE_SID=$1
export ORACLE_SID
DBA=$2
export DBA
echo $DBA
ATCNT=`echo $DBA | grep @ | wc -l`
export ATCNT
ORACLE_HOME=`grep ^$ORACLE_SID: /etc/oratab | head -1 | cut -d: -f2`
export ORACLE_HOME
PATH=$ORACLE_HOME/bin:/usr/local/bin:$PATH:.
export PATH
# Delete the old list file if it exists
if [ -e sniped_$ORACLE_SID.lst ]
then rm sniped_$ORACLE_SID.lst
fi
# Delete the old error file if it exists
if [ -e sniped_$ORACLE_SID.err ]
then rm sniped_$ORACLE_SID.err
fi
# Delete the old kill file if it exists
if [ -e sniped_kill_$ORACLE_SID.sh ]
then rm sniped_kill_$ORACLE_SID.sh
fi
# If sending to EMAIL address, run sql with headings on else run with
headings off
if [ $ATCNT -gt 0 ]
then
sqlplus / @sniped.sql on
else
sqlplus / @sniped.sql off
fi
# If there is anything in the lst file
RE: found dead multi-threaded server
I encountered some problems also when we moved over from dedicated to MTS all of my problems it seem were being caused by the idle_time parameter in the profile when it was set to anything like 60mins or 120 mins, I would frequently get dead MTS-servers after disabling that no more problems I'm on 8.1.7.2 now on HP-UX 11.0 64 bit -Original Message- Sent: Tuesday, December 18, 2001 5:05 PM To: Multiple recipients of list ORACLE-L I've gotten these errors (most notably 16365) on numerous occasions and I'm running 8.1.7.0 I've also gotten this error on 8.1.6 with and without the patchset. The main cause of this error is a half-duplex protocol error and, according to Oracle, tends to be application related.See notes 155513.1, 300867.999 on metalink for more information. Since the upgrade has not fixed this for us, my guess is that it is an application problem (perl in our case). We only occasionally get them, but if you get them all the time, you may want to check your app. HTH, -Brian On Mon, 17 Dec 2001, prashast gujrati wrote: Hi Gurus, We have recently upgraded our DBs from old 7.3.2 version to 8.1.6.0 and have moved from dedicated to MTS. since then we are getting ORA-600s in alert.log of all the DBs with various first arguments some of which I'll list here : 15429, 15439, 16365, 16375, 17034, 17182, 17280, 17281, 17285, kohlnm120, kohcpi298 etc. These are the most frequent ones. Though the DBs are up and running these errors are being consistently logged in alert. None of the instances have crashed ever since we have upgraded. I've opened up a TAR on metalink and have been told that 8.1.6.3 patchset is to be applied. Now what I want to know is if others have also encountered these errors and if applying this patchset has solved the problems. If not then what are the other things to be done (I mean does moving to 8.1.7.3 will necessarily solve the problem ? We are reluctant as this will mean another period of downtime for the users...) Also what is the source of these errors ? Will moving into dedicated arch solve our problems ? (I somehow tend to trust this list more than Metalink !!) TIA, -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Brian Haas INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: david hill INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Corruption Problem
Hi Guys I Have a funny problem in my alert log i got the following errors for about 15mins *** Corrupt block relative dba: 0x0a877fd8 (file 42, block 491480) Bad header found during buffer read Data in bad block - type: 6 format: 2 rdba: 0x0b801ea2 last change scn: 0x.17a9d140 seq: 0x1 flg: 0x02 consistency value in tail: 0xd1400601 check value in block header: 0x0, block checksum disabled spare1: 0x0, spare2: 0x0, spare3: 0x0 *** now i found which table was at that block analyzed that table with cascade, no errors were reported i then didi a full table scan, no errors, then i did an export of that table no errors were reported ??? what could cause this? I'm running on HP-UX 64 bit and i did apply the 8.1.7.2.1 patch yesterday, could it be related? all Oracle tells me is to keep an eye it. I was hoping someone could give me a little more insight into this or if you have experienced any similiar kind of problems with corruption that wasn't there Thanks for any Help David Hill DBA LeChateau -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: david hill INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Diff between local and network connection
I have a unix server and when i connect to a db i can make a connection by doing sqlplus /@db and connect through the listener or sqlplus / without a connect string and it takes my current Oracle sid and makes a local connection my question is what is the difference between the 2 types of connections, should i be using 1 over the other, are there performance benefits from making a local connection? David Hill DBA Le Chateau -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: david hill INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Advanced Korn Question
I was hoping someone in the list might be able to help me understand why this happens. i have a script a.ksh that looks like this a.ksh -- ksh b.ksh -- b.ksh --- su - updater -c "/prod/exe/pos2100" 21 $log1 su - updater -c "/prod/exe/pos2100" 21 $log2 su - updater -c "/prod/exe/pos2100" 21 $log3 su - updater -c "/prod/exe/pos2100" 21 $log4 wait --- when i run this only 1 of the background runs and the other 3 hang but if i change a.ksh to this -- ksh b.ksh 21 /dev/null -- everything works ok and all 4 jobs go into background and run fine coudl someone tell me why this happens -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: david hill INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
System Tablespace
Uhoh just noticed that someone here had created some users wiht their temporary tablespace as the system tablespace and now i have some big chunks of free space in there. Is it a good idea for me to defrag my sytem tablespace now? if so could i just run the catproc.sql and the other sql's or would i have to do an export import. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: david hill INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
