On Leave : 03-Dec to 17-Dec
Thank you for your email. I am sorry that I am not able to respond to you immediately as I am currently away. I am on Leave and out of Singapore 03-Dec to 17-Dec. Please resend Database action requests to my colleague Renga (Email : MUTHUKUMARASAMY Renga/IT/CHRT/ST Group, [EMAIL PROTECTED], Telephone 63604626] -- 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).
Intermedia Indexing
Hi, We have an Oracle iFS installation and have enabled Intermedia. Some documents fail indexing with Status 1 or Status 2 errors. The documents are PDF (pdf 1.3), Excel, World and HTM documents. I do have a TAR open with Support. Just would like to know from the field how successful is Intermedia in indexing documents ? Are there any gotchas ? Oracle8i 8.1.7.3 on Solaris for iFS9.0.1 Hemant K Chitale Principal DBA Chartered Semiconductor Manufacturing Ltd -- 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).
Experiences with 9iRAC (upgrading from 8.1.5OPS on Tru64)
We are considering an upgrade from 8.1.5OPS on Tru64 to 9iRAC for a mission-critical server in the next few months. I would like to know about any happy or painful experiences and if there are customers whom we can talk to directly. Hemant K Chitale Principal DBA Chartered Semiconductor Manufacturing Ltd [This e-mail is confidential and may also be privileged. If you are not the intended recipient, please delete it and notify us immediately; you should not copy or use it for any purpose, nor disclose its contents to any other person. Thank you.] -- 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).
Re: Favourite Urban Myth
Well, yes ! When installing Oracle, he needs to run root.sh or orainstRoot.sh as root ! Hemant K Chitale Principal DBA Chartered Semiconductor Manufacturing Ltd Dave Morgan [EMAIL PROTECTED] 05/04/2002 12:18 AM Sent by: [EMAIL PROTECTED] Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: (bcc: CHITALE Hemant Krishnarao/IT/CHRT/ST Group) Subject: Favourite Urban Myth The DBA needs root privileges on the server This is one of my interview questions. Dave -- Dave Morgan DBA, Cybersurf Office: 403 777 2000 ext 284 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Dave Morgan 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: 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: Off topic: Need ideas for 'Take your child to work' day 4/25
Point-and-Click GUI tools (like OEM) would be attractive but dangerous. How about showing them OEM on a Test Server (and ensure that OEM CANNOT connect to any other database) ? Show them the Tablespace Layout and draw an analogy with their cupboards/shelves at home. Show them the Instance Startup and Shutdown traffic signal. Hemant K Chitale Principal DBA Chartered Semiconductor Manufacturing Ltd Dungey, Barbara [EMAIL PROTECTED]05/04/2002 10:13 AM Sent by: [EMAIL PROTECTED] Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: (bcc: CHITALE Hemant Krishnarao/IT/CHRT/ST Group) Subject: Off topic: Need ideas for 'Take your child to work' day 4/25 Our office is doing 'Take your child to work' day and the plan is for an older child to shadow me for a little while as we do some simple Oracle dba or development work. I'd really like to make this meaningful by having the child do a task that's simpler (than optimizing all our procedures) but realistic (instead of being relegated to the lunchroom to watch tv) with me for an hour or so. Has anyone ever done this? I'd appreciate any lessons learned or suggestions. Thanks! Barbara -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Dungey, Barbara 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: 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: Oracle Step-by-Step Guide feedback
To quote Alan Paller in his email which included the document : Thanks for your note. The attached file has the problem set from the first draft of SANS new publication, Securing Oracle: Step by Step. If you have expertise in Oracle security and apply it to provide substantive feedback on the problem set, we'll include you in the next round that finalizes the actions that need to be taken to eliminate, as much as possible, the problems. The feedback deadline is the 29th of March. Send your comments here (the SANS Research Office at [EMAIL PROTECTED]). And thank you! Alan Alan Paller Director of Research The SANS Institute [EMAIL PROTECTED] My reading would be that feedback from experts was welcome. It doesn't say that feedback was mandatory. Hemant K Chitale Principal DBA Chartered Semiconductor Manufacturing Ltd John Kanagaraj [EMAIL PROTECTED] 30/03/2002 06:18 AM Sent by: [EMAIL PROTECTED] Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: (bcc: CHITALE Hemant Krishnarao/IT/CHRT/ST Group) Subject: RE: Oracle Step-by-Step Guide feedback List, SANS is a reputed non-profit organization dedicated to Security issues and I think Alan Paller is their director. They have done excellent work related to Computer Security and awareness over the last 6 years that I have known them. Understandably, they are senstive about dishing out security-related material to someone who agreed to provide feedback but didn't... I do remember that they requested that only those who agreed to provide feedback participate in the program. I didn't participate because I didn't have time, so I am not in the know about what was asked. I would re-read the terms on which they sent out the note. John Kanagaraj -Original Message- From: Koivu, Lisa [mailto:[EMAIL PROTECTED]] Sent: Friday, March 29, 2002 9:18 AM To: Multiple recipients of list ORACLE-L Subject: FW: Oracle Step-by-Step Guide feedback Anyone else get an email like this that sounded kinda threatening? -Original Message- From: SANS Research Office [SMTP:[EMAIL PROTECTED]] Sent: Friday, March 29, 2002 12:05 PM To: [EMAIL PROTECTED] Subject: Oracle Step-by-Step Guide feedback This is a note to the 167 people who promised to provide feedback on the Oracle problem list. First, great thanks to all who have sent feedback. I have read most of the response. They reflect real expertise and thoughtfulness. This project has taken on more meaning because the specifications of a safe Oracle installation we are producing are now being discussed as criteria in Oracle procurements at multiple federal agencies. In other words, we need to do it right the first time. So we especially appreciate teh feedback. If you provided substantive feedback on the problem set draft, we will also send you the actual draft of the problems and solutions. Others will be able to purchase the document later when it is published after several rounds of review. We're thinking about a special program for the people who made us go to the trouble of sending the draft and then did not provide feedback. Because of the holiday weekend, we'll extend the feedback deadline to Thursday April 4. Alan -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Koivu, Lisa 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: John Kanagaraj 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
Re: FW: Oracle Step-by-Step Guide feedback
Yup. I particularly dislike the ... We're thinking about a special program for the people who made us go to the trouble of sending the draft and then did not provide feedback. What special program ? Compulsory Military Service ? There really wasn't anything significant in the version 0.3 draft. Hemant K Chitale Principal DBA Chartered Semiconductor Manufacturing Ltd Koivu, Lisa [EMAIL PROTECTED] 30/03/2002 01:18 AM Sent by: [EMAIL PROTECTED] Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: (bcc: CHITALE Hemant Krishnarao/IT/CHRT/ST Group) Subject: FW: Oracle Step-by-Step Guide feedback Anyone else get an email like this that sounded kinda threatening? -Original Message- From: SANS Research Office [SMTP:[EMAIL PROTECTED]] Sent: Friday, March 29, 2002 12:05 PM To: [EMAIL PROTECTED] Subject: Oracle Step-by-Step Guide feedback This is a note to the 167 people who promised to provide feedback on the Oracle problem list. First, great thanks to all who have sent feedback. I have read most of the response. They reflect real expertise and thoughtfulness. This project has taken on more meaning because the specifications of a safe Oracle installation we are producing are now being discussed as criteria in Oracle procurements at multiple federal agencies. In other words, we need to do it right the first time. So we especially appreciate teh feedback. If you provided substantive feedback on the problem set draft, we will also send you the actual draft of the problems and solutions. Others will be able to purchase the document later when it is published after several rounds of review. We're thinking about a special program for the people who made us go to the trouble of sending the draft and then did not provide feedback. Because of the holiday weekend, we'll extend the feedback deadline to Thursday April 4. Alan -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Koivu, Lisa 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: 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: Cronjob misbehaving
Your CRON script should also define the ORACLE_HOME, ORACLE_SID and PATH. Why do you need a CRON job to recompile database objects every day ? Why are the being invalidated every day ? Hemant K Chitale Principal DBA Chartered Semiconductor Manufacturing Ltd Simon Waibale [EMAIL PROTECTED] 22/03/2002 04:18 PM Sent by: [EMAIL PROTECTED] Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: (bcc: CHITALE Hemant Krishnarao/IT/CHRT/ST Group) Subject: Cronjob misbehaving Hi all, Thanx for all the good work U R doing for Oracle. I have a misbehaving cronjob -Cron Entry 0 5 * * * /usr/scripts/recompile.sh /ops/scripts/recompile.log 21 -recompile.sh #!/bin/ksh ## Program name : recompile.sh ## Purpose : Recompile Invalid Database Objects for specified Shema in FLAG ## Author : C.S Waibale Simon ## Date written : 2002-03-19 #for i in FLAGPASS CALLSPASS FLAGPASS CH1PASS CH2PASS CH3PASS ; do #j:=1 #$i=${i:-$(crypt flag passwds |awk '{print $j}') #done SQLPLUS=/ops/product/817/bin/sqlplus #Do not export the password variables ! FLAGPASS=${FLAGPASS:-$(crypt flag /usr/scripts/passwds |awk '{print $1}')} CALLS_PASS=${CALLS_PASS:-$(crypt flag /usr/scripts/passwds |awk '{print $2}')} WHPASS=${WHPASS:-$(crypt flag /usr/scripts/passwds |awk '{print $3}')} echo Recompiling Invalid Database Objects in the FLAG instance #This can be sustitued with generic code $SQLPLUS flag_calls/$[EMAIL PROTECTED] @/ops/rom/recompile.sql $SQLPLUS flag/$[EMAIL PROTECTED] @/ops/rom/recompile.sql $SQLPLUS flag_wh/$[EMAIL PROTECTED] @/ops/rom/recompile.sql -recompile.log Recompiling Invalid Database Objects in the FLAG instance Message file sp1lang.msb not found Error 6 initializing SQL*Plus Message file sp1lang.msb not found Error 6 initializing SQL*Plus Message file sp1lang.msb not found Error 6 initializing SQL*Plus What could be broken ?? The script runs correctly from comand prompt. --- +---+ C.S Waibale Simon MTN-Uganda, 8th Floor UDB Building Cell: +256 77-212655,http://mtn.co.ug +---+ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Simon Waibale 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: 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: iFS - storing XML via Windows Explorer
Have you tried FTPing the file into iFS ? There should be a quote parsemodeoff in FTP. Hemant K Chitale Principal DBA Chartered Semiconductor Manufacturing Ltd Szecsy Tamas [EMAIL PROTECTED] 22/03/2002 12:28 AM Sent by: [EMAIL PROTECTED] Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: (bcc: CHITALE Hemant Krishnarao/IT/CHRT/ST Group) Subject: iFS - storing XML via Windows Explorer Hi, we have a iFS instance. iFS lets you update an attribute of a file by copying a proper XML file into a directory and iFS interprets it as a command. If something is not O.K. with the file, it spits out an error file into the same directory. Now my problem is that I would like to store an XML file in an iFS direcotry by draging the XML file into the iFS directory in Windows Explorer. The result is that I get a error file. Does someone know of a way to override this feature? TIA, Tamas Szecsy -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Szecsy Tamas 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: 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: iFS - storing XML via Windows Explorer
No can do. Quoting the iFS 1.1.9 [ie the one with 8.1.7] Setup and Administration Guide, Chapter 6, Task 3: Load Files into Oracle iFS : The Four Ways to Load Files into Oracle iFS This section discusses the four possible ways of loading documents into Oracle iFS. Remember to set the default ACL on your user ID to ensure that loaded files have the correct security. Drag and Drop in the Windows and Web Interfaces In both theWindows Explorer and the Web interface, you can drag and drop files into Oracle iFS. When you load files using either SMB or drag and drop in the Web interface, the XML files are parsed by default. If you do not want the XML files to be parsed, you must use another protocol to load your files. Use FTP to Load Files While running the FTP server, you can use any FTP client to load files into Oracle iFS. Using the FTP protocol is the most efficient way to performbulk file loading. When you load files using FTP, XML files are parsed by default. You can turn off the parsing mode by using a quote command. Browse and Upload Using the Web Interface Using the Web, choose Upload by Browse and select the file to upload. You can select to parse the file and apply an ACL. This is an efficient tool because it can be used from any machine and does not require any client installation except for a browser. Use the Command Line Utilities You can use the Command Line Utilities to load files into Oracle iFS by using the ifsmv command or the ifsput command.When you load files into Oracle iFS using the Command Line Utilities, XML files are parsed by default. You can turn off the parsing mode by using the ifsmode parse off command. Hemant K Chitale Principal DBA Chartered Semiconductor Manufacturing Ltd Szecsy Tamas [EMAIL PROTECTED] 22/03/2002 09:18 PM Sent by: [EMAIL PROTECTED] Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: (bcc: CHITALE Hemant Krishnarao/IT/CHRT/ST Group) Subject: RE: iFS - storing XML via Windows Explorer No, because the user would like to use copy / paste. Tamas -Original Message- [mailto:[EMAIL PROTECTED]] Sent: Friday, March 22, 2002 10:09 To: Multiple recipients of list ORACLE-L Have you tried FTPing the file into iFS ? There should be a quote parsemodeoff in FTP. Hemant K Chitale Principal DBA Chartered Semiconductor Manufacturing Ltd Szecsy Tamas [EMAIL PROTECTED] 22/03/2002 12:28 AM Sent by: [EMAIL PROTECTED] Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: (bcc: CHITALE Hemant Krishnarao/IT/CHRT/ST Group) Subject: iFS - storing XML via Windows Explorer Hi, we have a iFS instance. iFS lets you update an attribute of a file by copying a proper XML file into a directory and iFS interprets it as a command. If something is not O.K. with the file, it spits out an error file into the same directory. Now my problem is that I would like to store an XML file in an iFS direcotry by draging the XML file into the iFS directory in Windows Explorer. The result is that I get a error file. Does someone know of a way to override this feature? TIA, Tamas Szecsy -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Szecsy Tamas 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: 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
Re: diag.cmd script
Patrice, That you're running diag.cmd and not diag.csh, I assume you are on NT. What version of iAS and Portal are you using. I have used diag.csh (on Solaris, iAS 1.0.2.2, Portal 3.0.9) when we had issues cloning a portal environment some months ago and had learnt to ignore some messages. Could you post the output that you're getting when running the diag command ? Hemant K Chitale Principal DBA Chartered Semiconductor Manufacturing Ltd Boivin, Patrice J [EMAIL PROTECTED]22/03/2002 10:18 AM Sent by: [EMAIL PROTECTED] Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: (bcc: CHITALE Hemant Krishnarao/IT/CHRT/ST Group) Subject: diag.cmd script Something strange has happened. This utility, supplied with iAS to test portals, tells me there may be something wrong with my portal. In fact, it can't find the server name for the portal. Meanwhile we can access the portal no problem from a Web browser. I logged a TAR with Oracle to ask them about this little utility that tests portals... Regards, Patrice Boivin Systems Analyst (Oracle Certified DBA) Systems Admin Operations | Admin. et Exploit. des syst¨¨mes Technology Services| Services technologiques Informatics Branch | Direction de l'informatique Maritimes Region, DFO | R¨¦gion des Maritimes, MPO E-Mail: [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Boivin, Patrice J 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). [This e-mail is confidential and may also be privileged. If you are not the intended recipient, please delete it and notify us immediately; you should not copy or use it for any purpose, nor disclose its contents to any other person. Thank you.]åy«±ç ê~'jS Ä,PÛiÿü0ÂÚ}ª¢`.¶+ Ñ é×!Ö¥yÈZ®×«yÛ'(V +r5ëp¢¹z»âqëçÎwó9ÔPó9ßÎtçT8'è®xæåÂ'µêçzÖqë,üÆ¢)à.+-±:Ã*.®Ç¥}úèØb²f¢)à+-±éÝjq +j)fzËëh.+-êî}«\Ü¢ièµá $ì¥éex(|¸¬´k«¹©Ý{azg¬±¨àØw%¹×)Þríj)â +I@ND º+¶§jg¨~f¢)à+-Ê°j{m¡·«zj/y×ë¢f(ºf²j[(±éݶ³Ü¢i×è®az¸§~æjبX¤z˱Êân)à
Re: ORACLE 9i Database and Oracle9ias application
Actually, there are a number of InterOperability patches for 9iAS 1.0.2.2 with the 9iDB. I'm only running 9iAS 1.0.2.2 against 8.1.7 yet. BTW, if you check the Certification Matrix on Metalink, do not select the product Application Server (9iAS) This contains incomplete certification for 9iAS 9.0.2 on Solaris. Select Internet Products and then Oracle9i Application Server Enterprise Edition Quoting the certification : Oracle9iAS Rel1 (V1.0.2.2.x) is certified to run against a Oracle9i Database 9.0.1 (on all supported platforms) in RAC configuration. 9iAS 1.0.2.2 can run against any certified 9.0.1 (9i) backend database, with exceptions and limitations: Oracle9iAS Database Cache and Oracle Enterprise Manager functionality are NOT supported in this configuration. In order to run in this configuration, Oracle9iAS Forms Services users should apply Oracle Forms Patch 5. Oracle9iAS Portal - Apply patches for bugs1794996 and 1806057. Apply workaround (07_DICTIONARY_ACCESSIBILITY =true) for bug 1554423 Users connecting from Oracle9iAS v1022 to Oracle9i database through jdbc thin drivers - Apply patch for bug 1725012 9iAS Wireless, J2EE (OC4J), iFS, Unified Messaging and eMail Server are, surpringly, listed seperately in the certification. Hemant K Chitale Principal DBA Chartered Semiconductor Manufacturing Ltd Charlie Mengler [EMAIL PROTECTED] 22/03/2002 06:23 AM Sent by: [EMAIL PROTECTED] Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: (bcc: CHITALE Hemant Krishnarao/IT/CHRT/ST Group) Subject: Re: ORACLE 9i Database and Oracle9ias application Seema Singh wrote: Hi If I want to install oracle 9i Database and oracle 9iAS on same box. Is it necessary to have diffrent home for both or same? use DIFFERENT home directories If I use oracle as unix loginname for oracle9i database then can I use same unix loginname for Oracle 9iAS or not? Yes, you can use oracle for both, but will need a way to change ORACLE_HOME. FWIW - I don't believe that all pieces of 9iAS are actually certified to run with 9i DB. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Charlie Mengler 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). [This e-mail is confidential and may also be privileged. If you are not the intended recipient, please delete it and notify us immediately; you should not copy or use it for any purpose, nor disclose its contents to any other person. Thank you.] -- 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).
Re: Express Server -- Oracle Financial Analyzer Question
Is the OFA instance an Express Server 6.x database ? Then, it is not an RDBMS issue until 9i when Express server is merged with the RDBMS. I haven't worked with Express Server but... maybe someone who has worked with Express Server can help. Hemant K Chitale Principal DBA Chartered Semiconductor Manufacturing Ltd Jamadagni, Rajendra [EMAIL PROTECTED] 21/03/2002 12:41 AM Sent by: [EMAIL PROTECTED] Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: (bcc: CHITALE Hemant Krishnarao/IT/CHRT/ST Group) Subject: Oracle Financial Analyzer Question Hi all, just a basic question it was mentioned in a meeting that our OFA instance gets so much fragmented that it needs to be rebuilt every week. Is that true with everyone ?? BTW this is on NT (please don't ask me why). Are there any ways to get around this fragmentation? The DB size seems to increase because of all the scenarios they run, so when it is rebuilt, the size goes down considerably. I don't work on that, so I don't know all the intricate details. Any ideas are greatly appreciated. Raj __ Rajendra Jamadagni MIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot com Any opinion expressed here is personal and doesn't reflect that of ESPN Inc. QOTD: Any clod can have facts, but having an opinion is an art! Attachment Removed : ESPN_Disclaimer.txt [This e-mail is confidential and may also be privileged. If you are not the intended recipient, please delete it and notify us immediately; you should not copy or use it for any purpose, nor disclose its contents to any other person. Thank you.] -- 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).
RE: Oracle CERT Advisory
Check http://otn.oracle.com/deploy/security/alerts.htm Hemant K Chitale Principal DBA Chartered Semiconductor Manufacturing Ltd [This e-mail is confidential and may also be privileged. If you are not the intended recipient, please delete it and notify us immediately; you should not copy or use it for any purpose, nor disclose its contents to any other person. Thank you.] -- 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).
RE: Oracle Gold Support/ iTARs
On advantage with the iTAR is that you CAN precisely define your problem -- you write in the 15 line problem description yourself not some Analyst who writes a curt single line description. You can then keep following up with additonal details and questions which certainly get logged as you type them in. A disavantage is that you can't be sure which Analyst is handling your call. With telephonic support you would get to know the Analysts at your local support centre over a period of time -- now they are virtual analysts. Hemant K Chitale Principal DBA Chartered Semiconductor Manufacturing Ltd Kimberly Smith [EMAIL PROTECTED]19/03/2002 10:23 AM Sent by: [EMAIL PROTECTED] Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: (bcc: CHITALE Hemant Krishnarao/IT/CHRT/ST Group) Subject: RE: Oracle Gold Support Report the rude dude. However, I have gotten really good response from using Metalink (also Gold support) for level 1 tars. The good thing is, since you are putting it in it gets in correctly. I actually think Oracle has greatly improved their support. Are they perfect? No, but I do believe they are working on it. Complaining to us though will get you no where (other then venting:-) Complain to those who can do something about it even if you think they won't. They may just surprise you someday. -Original Message- Robert Sent: Monday, March 18, 2002 11:43 AM To: Multiple recipients of list ORACLE-L Anyone else just slightly irritated with the level of customer support offered for phone callers to Oracle now days? Used to be, that if you were a gold customer as we are, you could almost count on instant first line support. Last week I called and was told that a phone call would result in at least a one hour delay in an analyst call back, whereas an iTar (lie tars I call em) will get me about 30 minute response. The representative was rude and snarly to me at the same time. Is this how Larry wants to save that second billion, crappy customer service? RF Robert G. Freeman - Oracle8i OCP Oracle DBA Technical Lead CSX Midtier Database Administration The Cigarette Smoking Man: Anyone who can appease a man's conscience can take his freedom away from him. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Freeman, Robert 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: Kimberly Smith 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: 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: how to know ,the tables which are accessed via FTS?
I've rewritten the query as : select usr.name oowner, ob.name oname from ( select obj from x$bh where to_number(bitand(flag, power(2,19))) 0 group by obj ) bh, obj$ ob, user$ usr where ob.dataobj# = bh.obj and ob.owner# = usr.user# order by usr.name, ob.name / This query runs successsfully consistently. I've also given credit to Jonathan in my update on the TAR. The Support Analyst might be writing a note on Metalink on the query. Hemant K Chitale Principal DBA Chartered Semiconductor Manufacturing Ltd CHITALE Hemant Krishnarao/IT/CHRT/ST Group@ST Domain14/03/2002 11:48 AM Sent by: [EMAIL PROTECTED] Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: (bcc: CHITALE Hemant Krishnarao/IT/CHRT/ST Group) Subject: Re: how to know ,the tables which are accessed via FTS? Jonathan, I just saw your email. I'll try your suggestions. To report more on the query crashing I had logged a TAR on discovering ORA-7445 errors in my alert.log [For those who have access to Oracle Internal networks, the TAR# is 2220560.999]. The analyst was of t he opinion was that the trace was similar to Bug #1571059 with a suggested workaround of event 10933 level 4096. However, he wanted further investigation by me. I then found tested different queries and found that this particular query was causing the ORA-7445 and creating a 33MB user_dump (of course, this is a busy database -- session dumps would be larger). The analyst is working on it again with the new trace file. I've retested my original script against less-busy (Datawarehouse, Portal, iFS) databases running 8.1.7.0.0 on Solaris. As you've pointed out it could be happening in my Apps instance because of the in-flux nature of queries on X$BH [it shouldn't be because of 8.1.7.0.0 Solaris v 8.1.7.2.1 Tru64]. Coming back to your suggestion, I'll retry the query as you've suggested. Hemant K Chitale Principal DBA Chartered Semiconductor Manufacturing Ltd Jonathan Lewis [EMAIL PROTECTED] 12/03/2002 05:53 PM Sent by: [EMAIL PROTECTED] Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: (bcc: CHITALE Hemant Krishnarao/IT/CHRT/ST Group) Subject: Re: how to know ,the tables which are accessed via FTS? Whilst your query really ought not to crash, bear in mind that X$ objects are not subject to any form of normal read consistency, so you may be hitting some strange side-effect of in-flux blocks. You may do better to reduce the run-time of the query by doing the select and group by on x$bh only as an inline view, and then joining to dba_objects - and since you are joining to x$bh why not join to obj$ ? Something like: select from ( select obj from x$bh where to_number(bitand(flag, power(2,19))) = 1 group by obj ) bh, obj$ ob where ob.dataobj# = bh.obj ; By restricting the object_type to TABLE you will be missing index fast full scans, of course. And won't you also miss scans on partitioned objects and clustered objects. Jonathan Lewis http://www.jlcomp.demon.co.uk Next Seminar - UK, April 3rd - 5th http://www.jlcomp.demon.co.uk/seminar.html Host to The Co-Operative Oracle Users' FAQ http://www.jlcomp.demon.co.uk/faq/ind_faq.html Author of: Practical Oracle 8i: Building Efficient Databases -Original Message- [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Date: 12 March 2002 07:46 | | |Oracle8i 8.1.7.2 on Tru64. | |I've been using the query : |SELECT o.owner oowner, o.object_name oname | FROM dba_objects o,x$bh x | WHERE x.obj=o.data_object_id | AND o.object_type='TABLE' | AND standard.bitand(x.flag,524288)0 | AND o.owner'SYS' | group by owner, object_name | order by owner, object_name |/ | |This ends in ORA-03113: end-of-file on communication channel 3 out of 4 |times |(but 1 out of 4 times I DO get the list of tables). |If I remember correctly it used to work in 8.0.5, except that I was joining |x.obj against o.object_id. | |However, on another 8.1.7.0 on Solaris 8 database I consistently |get the list of Tables. The difference is that this database is less |busy. The Tru64 database is my Oracle Applications Database. | |Any ideas why I get the ORA-3113 on my Oracle Applications Tru64 database ? |[other than that this is
Re: how to know ,the tables which are accessed via FTS?
Jonathan, I just saw your email. I'll try your suggestions. To report more on the query crashing I had logged a TAR on discovering ORA-7445 errors in my alert.log [For those who have access to Oracle Internal networks, the TAR# is 2220560.999]. The analyst was of t he opinion was that the trace was similar to Bug #1571059 with a suggested workaround of event 10933 level 4096. However, he wanted further investigation by me. I then found tested different queries and found that this particular query was causing the ORA-7445 and creating a 33MB user_dump (of course, this is a busy database -- session dumps would be larger). The analyst is working on it again with the new trace file. I've retested my original script against less-busy (Datawarehouse, Portal, iFS) databases running 8.1.7.0.0 on Solaris. As you've pointed out it could be happening in my Apps instance because of the in-flux nature of queries on X$BH [it shouldn't be because of 8.1.7.0.0 Solaris v 8.1.7.2.1 Tru64]. Coming back to your suggestion, I'll retry the query as you've suggested. Hemant K Chitale Principal DBA Chartered Semiconductor Manufacturing Ltd Jonathan Lewis [EMAIL PROTECTED] 12/03/2002 05:53 PM Sent by: [EMAIL PROTECTED] Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: (bcc: CHITALE Hemant Krishnarao/IT/CHRT/ST Group) Subject: Re: how to know ,the tables which are accessed via FTS? Whilst your query really ought not to crash, bear in mind that X$ objects are not subject to any form of normal read consistency, so you may be hitting some strange side-effect of in-flux blocks. You may do better to reduce the run-time of the query by doing the select and group by on x$bh only as an inline view, and then joining to dba_objects - and since you are joining to x$bh why not join to obj$ ? Something like: select from ( select obj from x$bh where to_number(bitand(flag, power(2,19))) = 1 group by obj ) bh, obj$ ob where ob.dataobj# = bh.obj ; By restricting the object_type to TABLE you will be missing index fast full scans, of course. And won't you also miss scans on partitioned objects and clustered objects. Jonathan Lewis http://www.jlcomp.demon.co.uk Next Seminar - UK, April 3rd - 5th http://www.jlcomp.demon.co.uk/seminar.html Host to The Co-Operative Oracle Users' FAQ http://www.jlcomp.demon.co.uk/faq/ind_faq.html Author of: Practical Oracle 8i: Building Efficient Databases -Original Message- [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Date: 12 March 2002 07:46 | | |Oracle8i 8.1.7.2 on Tru64. | |I've been using the query : |SELECT o.owner oowner, o.object_name oname | FROM dba_objects o,x$bh x | WHERE x.obj=o.data_object_id | AND o.object_type='TABLE' | AND standard.bitand(x.flag,524288)0 | AND o.owner'SYS' | group by owner, object_name | order by owner, object_name |/ | |This ends in ORA-03113: end-of-file on communication channel 3 out of 4 |times |(but 1 out of 4 times I DO get the list of tables). |If I remember correctly it used to work in 8.0.5, except that I was joining |x.obj against o.object_id. | |However, on another 8.1.7.0 on Solaris 8 database I consistently |get the list of Tables. The difference is that this database is less |busy. The Tru64 database is my Oracle Applications Database. | |Any ideas why I get the ORA-3113 on my Oracle Applications Tru64 database ? |[other than that this is a really busy database]. | |Hemant K Chitale |Principal DBA |Chartered Semiconductor Manufacturing Ltd | -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jonathan Lewis 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: INET: [EMAIL PROTECTED] Fat City Network Services--
RE: database clone:
On the I have heard that in version 9i, you can, in fact create a standby database it it is not possible in the current release of 9i. This is called a Logical Standby. 9iRel1 provides only a Physical Standby. 9iRel2 (due in May/June) might provide Logical Standby. However, of course, this option is not available for Mitchell's requirement as it would not work against an 8.0.5 source database. Hemant K Chitale Principal DBA Chartered Semiconductor Manufacturing Ltd Ron Yount [EMAIL PROTECTED] 12/03/2002 10:28 AM Sent by: [EMAIL PROTECTED] Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: (bcc: CHITALE Hemant Krishnarao/IT/CHRT/ST Group) Subject: RE: database clone: Mitchell, I have not been following the thread, but nonetheless, I will attempt to add some information. It is accurate to state that imp/exp is your only option in 8.0.5 when you are trying to move a database from one platform (AIX) to another (Solaris). Other options all up through version 8.1.7 only apply when the platform is not changing: e.g. Transportable tablespace Standby database or RMAN Hot Backup/Recover from disk or tape. I have heard that in version 9i, you can, in fact create a standby database on a different platform because it actually converts the redo logs into SQL type DML/DDL statements and applies them, but even this is no way to re-create a 300 Meg database. Of course, your option of imp/exp would be VERY time and resource intensive. HTH, -Ron- -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of mitchell Sent: Monday, March 11, 2002 11:09 AM To: Multiple recipients of list ORACLE-L Subject: Re: database clone: Hi DBAs. Thanks all your reply. I am still thinking it is possible to use backup file or cp files. It is hard to exp/imp on a large system with 300GB. Mitchell - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Monday, March 11, 2002 11:53 AM [EMAIL PROTECTED] wrote: Hi DBAs: What is the best way to clone large oracle database ( 8.0.5, 300g) from aix 4.3 o to Sun Soloris (2.8). Any idea, articles, experience? thanks in advance. Mitchell exp from aix, install, create the database and the tablespaces on sun, then imp. -- -- Bill Shrek Thater ORACLE DBA [EMAIL PROTECTED] You gotta program like you don't need the money, You gotta compile like you'll never get hurt, You gotta run like there's nobody watching, It's gotta come from the heart if you want it to work. Books won't stay banned - Ideas won't go to jail. - Alfred Whitney Griswold -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: bill thater 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: mitchell 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: Ron Yount INET: [EMAIL PROTECTED] Fat City
Re: how to know ,the tables which are accessed via FTS?
Oracle8i 8.1.7.2 on Tru64. I've been using the query : SELECT o.owner oowner, o.object_name oname FROM dba_objects o,x$bh x WHERE x.obj=o.data_object_id AND o.object_type='TABLE' AND standard.bitand(x.flag,524288)0 AND o.owner'SYS' group by owner, object_name order by owner, object_name / This ends in ORA-03113: end-of-file on communication channel 3 out of 4 times (but 1 out of 4 times I DO get the list of tables). If I remember correctly it used to work in 8.0.5, except that I was joining x.obj against o.object_id. However, on another 8.1.7.0 on Solaris 8 database I consistently get the list of Tables. The difference is that this database is less busy. The Tru64 database is my Oracle Applications Database. Any ideas why I get the ORA-3113 on my Oracle Applications Tru64 database ? [other than that this is a really busy database]. Hemant K Chitale Principal DBA Chartered Semiconductor Manufacturing Ltd Alex Feinstein [EMAIL PROTECTED] 12/03/2002 01:58 PM Sent by: [EMAIL PROTECTED] Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: (bcc: CHITALE Hemant Krishnarao/IT/CHRT/ST Group) Subject: Re: how to know ,the tables which are accessed via FTS? Gopal, Ganesh, ... Small correction: 1. v$session_event does not have file#, block# and blocks. They are in v$session_wait, which may be hard to catch. 2. Absolute best methode. But field name is flag. not class, you can use bitand(flag,power(2,19) 0 as a condition. When join to dba_objects(user_objects) one should use field data_object_id, not object_id. Take care about clusters, as all object in cluster share the same data_object_id. Anothe (but slower) way is join with dba_extents(user_extents). 4. This give accurate info to the file level, not segment level. Alex. - Original Message - From: K Gopalakrishnan To: Multiple recipients of list ORACLE-L Sent: Monday, March 11, 2002 11:07 AM Subject: RE: how to know ,the tables which are accessed via FTS? Ganesh, You can find FTS in the following methods: 1. THe existence of the 'db file scattered read' in the V$session_event. From this we can find the file#, Block# and #of Blocks. Using this info we can get the segment name from the dictionary. 2. ANy block read using Sequential Scan (Full Table Scan) will be flagged as 0x8 in the X$BH.CLASS. So existence of i0x8 in X$.BH tells there is an FTS in the buffer cache. So from X$BH we can get the object name from the user_object by joining X$.BH.OBJ 3. THen the normal SQL Trace with TKPROF 4. If the KCFIOPBRKCFIOPYRin the X$KCFIO (exposed as V$FILESTAT as PHYSICAL READS and PHYSICAL BLOCK READS) then some of the segments in that datafile is read by FTS. (THis may not give 100% accurate info) 5.. Any other thoughts? Best Regards, K Gopalakrishnan Bangalore, INDIA -Original Message- From: Ganesh Raja [mailto:[EMAIL PROTECTED]] Sent: Monday, March 11, 2002 1:12 AM To: LazyDBA.com Discussion Subject: RE: how to know ,the tables which are accessed via FTS? What will that Acheive... this will not give u Tables that have FTS Done on them. Best Regards, Ganesh R Tel : +971 (4) 397 3337 Ext 420 Fax : +971 (4) 397 6262 HP : +971 (50) 7456019 -Original Message- From: vipin jain [mailto:[EMAIL PROTECTED]] Sent: Monday, March 11, 2002 1:02 PM To: LazyDBA.com Discussion Subject: Re: how to know ,the tables which are accessed via FTS? USE analyze table with compute statistcs Thanks and regards, Vipin Jain - Original Message - From: Atul Gupta To: LazyDBA.com Discussion Sent: Monday, March 11, 2002 2:20 PM Subject: how to know ,the tables which are accessed via FTS? Hi Gurus , One little question how will i get to know what all tables are accessed via full table scan ? any help will be highly appreciated Thnax in advance Atul Gupta [This e-mail is confidential and may also be privileged. If you are not the intended recipient, please delete it and notify us immediately; you should not copy or use it for any purpose, nor
Any Asset/License Management Package
I am looking for information on an Asset / License Management package which could be used to keep track of Servers (by OS, Configuration, Vendor, Maintenance Contract, Downtime logs) and/or Licenses (OS, Database, Applications, Support Contract). The package could be an Off-the-Shelf package, based on Oracle or other database but must have reporting facilities. Hemant K Chitale Principal DBA Chartered Semiconductor Manufacturing Ltd -- 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).
Re: Oracle Migration 7.3.4.5 to 8.1.6.3
Why 8.1.6.3 ? Go to 8.1.7.2 or 8.1.7.3. 8.1.6 has been desupported. What is the OS version ? Solaris 2.5.1 ? 32-bit 8.1.7 is certified on 2.6 and above. 64-bit 8.1.7 is on Solaris 8 (2.8) of course. That you have a Cluster -- is it OPS or single-instance database which fails over to the second node ? If you use the MIGrate utility, you should have very low downtime. 1. Install 8.1.7 + Patchset 2 or 3 : 1.5 hours max. Install into a seperate ORACLE_HOME. 2. MIG database 1 hour ?? (depends on the size of the SYSTEM Tablespace, not the full database) -- I suggest you use the command-line MIG utility, I've been more comfortable with it than ODMA. 3. Configure init.ora, copy convSID.ora, ALTER DATABASE CONVERT and catalog and catproc in 81.7 : 1.5 hours max. 4. Recompile Invalid Objects : Depends on how many you have. Don't waste time installing the JVM into the database -- you are not currently using it. You'd have to practice the migrate a couple of times on another server. Hemant K Chitale Principal DBA Chartered Semiconductor Manufacturing Ltd Mark Cilia [EMAIL PROTECTED] 07/03/2002 02:13 PM Sent by: [EMAIL PROTECTED] Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: (bcc: CHITALE Hemant Krishnarao/IT/CHRT/ST Group) Subject: Oracle Migration 7.3.4.5 to 8.1.6.3 Hi All We are in the process of migrating our database from 7.3.4.5 to 8.1.6.3. We are using a Sun Cluster (2 E4000 each with 4x480Mhx processors and 4gb Ram) for our system which is almost 24x7. This whole operation must be performed (ideally) within a maximum of 24 hour period (during say a national holdiday). Our database is approx 100Gb large. Any suggestions on how to do this operation? Any past experience? TIA mark -- 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).
Re: Upgrade OS for database 8.1.6
Catherine, Check if the /etc/system file has been configured correctly. e.g I have the following set on my Solaris 2.8 server : * settings for Oracle Hemant, 26-Jun-01 set shmsys:shminfo_shmmax=4294967295 set shmsys:shminfo_shmmin=1 set shmsys:shminfo_shmmni=100 set shmsys:shminfo_shmseg=256 set semsys:seminfo_semmns=2048 set semsys:seminfo_semmni=64 set semsys:seminfo_semmsl=100 You need to reboot the server for these to take effect. Hemant K Chitale Principal DBA Chartered Semiconductor Manufacturing Ltd CHAN Chor Ling Catherine (CSC) [EMAIL PROTECTED]07/03/2002 10:28 AM Sent by: [EMAIL PROTECTED] Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: (bcc: CHITALE Hemant Krishnarao/IT/CHRT/ST Group) Subject: Upgrade OS for database 8.1.6 Hi Gurus, My test database 8.1.6 resides in Unix machine. We are supposed to upgrade the Unix OS from 5.6 to 5.8 for our Oracle HRMS V11.5.1. There are some problems with the OS upgrade and for some reasons, the Unix administrator cannot restore back the OS. He has tried to install a new copy of the OS 5.8 and now I cannot start up my database. The error message is below $ /dg5/app/oracle/testcomn/admin/scripts/addbctl.sh start You are running addbctl.sh version 115.0 Starting the database TEST ... SQL*Plus: Release 8.1.6.0.0 - Production on Thu Mar 7 10:14:23 2002 (c) Copyright 1999 Oracle Corporation. All rights reserved. Connected to an idle instance. ORA-27102: out of memory SVR4 Error: 22: Invalid argument Disconnected addbctl.sh: exiting with status 0 I am thinking of asking him to install a fresh copy of the OS 5.6 ? Any advice ? Please help. Thanks. Regds, New Bee -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: CHAN Chor Ling Catherine (CSC) 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: 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).
Forms6i (6.0.8 ?) on Motif Mode
We have a number of Forms 4.5 environments (against 7.3.4/8.1.6/8.1.7) where the clients are Unix workstations. Therefore, the Forms they are are Motif-mode. We are looking at upgrading to 6i. Has anyone upgraded to 6i Motif (ie convert, develop and run in Motif) ? Hemant K Chitale Principal DBA Chartered Semiconductor Manufacturing Ltd [This e-mail is confidential and may also be privileged. If you are not the intended recipient, please delete it and notify us immediately; you should not copy or use it for any purpose, nor disclose its contents to any other person. Thank you.] -- 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).
RE: Sun Cluster and VCS failover
I would think 12 to 15 minutes still too high. Damagement would generally specify a max of 5 minutes. Have you found out why it takes 12 to 15 minutes ? Do the File Systems take so long or does the Instance Recovery take so long ? Do you have to put a sleep in the startup scripts [when I setup a failover cluster for Oracle Apps with Oracle Web Application Server 3.0.2, I put in a sleep of 30seconds for the Web server -- WAS302 has to have the physical host-name hardcoded in the wrb.app file so I maintained two copies of the file and the startup script would copy in the correct one, depending on the hostname, as wrb.app but sometimes it wouldn't startup immediately ; I had to put a sleep after the file copy]. Hemant K Chitale Principal DBA Chartered Semiconductor Manufacturing Ltd Baker, Barbara [EMAIL PROTECTED] 05/03/2002 05:58 AM Sent by: [EMAIL PROTECTED] Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: (bcc: CHITALE Hemant Krishnarao/IT/CHRT/ST Group) Subject: RE: Sun Cluster and VCS failover Nick: On our SunCluster 2-node E4500's with 8 CPU's (Oracle 8.0.5) it takes us around 12 to 15 minutes. HTH. Barb -- From: Nick Wagner[SMTP:[EMAIL PROTECTED]] Reply To: [EMAIL PROTECTED] Sent: Monday, March 04, 2002 2:23 PM To: Multiple recipients of list ORACLE-L Subject: Sun Cluster and VCS failover Situation: Sun Cluster, or VERITAS Cluster. Oracle 8, 8i, or 9i 2 node Sun E6500s w/ 8 CPUs If the primary node fails, how long does it take before a user is able to connect to the secondary node, and continue their activity? I'm sure reality, and marketing times are different... I'm really interested in reality times, but at this point either would be nice. Thanks!! Nick -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Baker, Barbara 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: 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: SSL and non-SSL requests on same Apache server in 9iAS?
Read section 2.2 of Note 123718.1. Hemant K Chitale Principal DBA Chartered Semiconductor Manufacturing Ltd Ben Poels [EMAIL PROTECTED] 05/03/2002 06:03 AM Sent by: [EMAIL PROTECTED] Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: (bcc: CHITALE Hemant Krishnarao/IT/CHRT/ST Group) Subject: SSL and non-SSL requests on same Apache server in 9iAS? Hi, I want to host SSL and non-SSL requests on one physical server running one 9iAS. After installing 9iAS the httpd.conf file specifies by default that it is listening on port . Later on in httpd.conf it has an SSL directive that says it's listening on port 80 and 443. Does this mean that this one Apache server can service non-SSL requests on and SSL requests on 443 at the same time? There is a document on Metalink(135231.1) that describes how to run two Apache servers in one 9iAS home. Again what is not clear to me is whether or not one could be handling SSL and the other non-SSL. Anyone have any recommendations on how to do this? I may also be asked to host 40-bit and 128-bit encryption on the same web site. Again any recommendations? Thanks. == Ben Poels - Senior Technical Analyst - Queen's University at Kingston Phone: 613.533.2449 Fax: 613.533.2168 Email: [EMAIL PROTECTED] == -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ben Poels 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). [This e-mail is confidential and may also be privileged. If you are not the intended recipient, please delete it and notify us immediately; you should not copy or use it for any purpose, nor disclose its contents to any other person. Thank you.] -- 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).
RE: Does Oracle 9iAS only run on Apache?
Well. you could look at Note 134284.1 on MetaLink. I've never tried iAS with anything other than Oracle's Apache distribution so I can't say if this document suffices. [You could also look at Note 132466.1 on the Oracle Plug-In for IIS to run Oracle PLSQL applications through IIS. Again, I've not done it]. Hemant K Chitale Principal DBA Chartered Semiconductor Manufacturing Ltd [EMAIL PROTECTED] 02/03/2002 03:08 AM Sent by: [EMAIL PROTECTED] Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: (bcc: CHITALE Hemant Krishnarao/IT/CHRT/ST Group) Subject: RE: Does Oracle 9iAS only run on Apache? What does Hear, hear. mean? Do you have a constructive(note the 1st 3 letters CON) reply to the original question? The employer uses IIS and does not want to support other servers. If Oracle 9iAS is not supported then this is the end of the question and end of thread. Rick Boivin, Patrice J To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] [EMAIL PROTECTED]cc: mpo.gc.ca Subject: RE: Does Oracle 9iAS only run on Apache? Sent by: [EMAIL PROTECTED] 03/01/2002 01:18 PM Please respond to ORACLE-L Hear, hear. Regards, Patrice Boivin Systems Analyst (Oracle Certified DBA) Systems Admin Operations | Admin. et Exploit. des syst¨¨mes Technology Services| Services technologiques Informatics Branch | Direction de l'informatique Maritimes Region, DFO | R¨¦gion des Maritimes, MPO E-Mail: [EMAIL PROTECTED] -Original Message- Sent: Friday, March 01, 2002 12:30 PM To:Multiple recipients of list ORACLE-L Rick, Why do you ask? At a former employer, we were being pressured to use a different webserver for entirely different reasons. We eventually concluded that the ones asking the question were technically impaired and began ignoring them. While I believe that you can do this, Oracle won't support your iAS installation if you do. It's a fair amount of work to iAS setup and running the way you want without trying to give it a heart transplant in the process. Doing so will likely also require regular infusions anti-rejection drugs ( your time ). Jared [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 03/01/02 07:03 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:Does Oracle 9iAS only run on Apache? Hi All, Will Oracle 9iAS run on other servers other than Apache? If so which ones and are they supported by Oracle? Does anyone have any experience running on other servers? success/failure stories. Thanks Rick -- 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: 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
Re: Error in relinking executables after Upgrade Unix OS from 2.6 TO
The relink expects to use the linker from /usr/ccs/bin. /usr/ucb and /usr/ccs/bin are different. /usr/ccs* contains the SVR4 distribution. /usr/ucb* contain the BSD distribution. In fact, /usr/ucb/ld [on my machine] is a shell-script which sets the LD_RUN_PATH and defines /usr/ucblib first, ie it changes the order of the libraries. If you have copied /usr/ucb/ld over to /usr/ccs/bin/ld you will see that the program is calling itself --- it would be forking multiple processes till it runs out of swap space. You should be using /usr/ccs/bin/ld. Oracle requires the SVR4 linker. Ask your Solaris vendor to install it. Hemant K Chitale Principal DBA Chartered Semiconductor Manufacturing Ltd CHAN Chor Ling Catherine (CSC) [EMAIL PROTECTED]04/03/2002 10:48 AM Sent by: [EMAIL PROTECTED] Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: (bcc: CHITALE Hemant Krishnarao/IT/CHRT/ST Group) Subject: Error in relinking executables after Upgrade Unix OS from 2.6 TO Hi Gurus, I upgraded my UNIX OS from 2.6 to 5.8 for our HRMS 11I V11.5.1 and now encountered problem when I relink my executables. The instructions from Oracle support for Upgrade is = run the environment file ($ . $APPL_TOP/APPSORA.env) = OK = relink adadmin using adrelink ($ adrelink.sh force=y ad adadmin) = ERROR ENCOUNTERED = use adadmin to relink all executables ($ adadmin-Relink Applications Programs) = ERROR ENCOUNTERED 1st error encountered Adrelink: the directory containing the make command must be in your path. SolutionFor Solaris 2.6, the default directory for ld and make is in /usr/ccs/bin. Since the OS has been upgraded to 5.8, the ld program is only found in /usr/ucb directory and make program in /usr/local/bin directory. I've copied the make and ld programs to the directory /usr/ccs/bin. 2nd error encountered /usr/ccs/bin/ld: cannot fork: no swap space See error messages above (also recorded in log file) for possible reasons for the failure. Also, please check that the Unix userid running adrelink has read, write, and execute permissions on the directory /dg5/app/oracle/testappl/ad/11.5.0/bin, and that there is sufficient space remaining on the disk partition containing your Oracle Applications installation. I've 1.5GB swap space and I've read,write and execute permission on the directory /dg5/app/oracle/testappl/ad/11.5.0/bin My physical memory is $ df -k Filesystem kbytes used avail capacity Mounted on /dev/dsk/c0t1d0s0 1302231 929196 320946 75% / /proc 0 0 0 0% /proc fd 0 0 0 0% /dev/fd mnttab 0 0 0 0% /etc/mnttab /dev/dsk/c0t1d0s6 1326439 88963 1184419 7% /var /dev/dsk/c0t0d0s0 26255015 23017221 2975244 89% /dg1 /dev/dsk/c1t0d0s0 1322803 53282 1216609 5% /opt /dev/dsk/c1t0d0s1 30122920 3018192 26803499 11% /dg4 /dev/dsk/c1t1d0s0 35292880 15626245 19313707 45% /dg5 /dev/dsk/c1t2d0s0 35292880 24654450 10285502 71% /dg6 /dev/dsk/c1t3d0s0 35292880 19057633 15882319 55% /dg7 swap 1517552 24 1517528 1% /tmp /dev/dsk/c0t1d0s7 9975 46 8932 1% /export/home Qn: Has anyone upgraded his/her OS from 2.6 to 5.8 before for HRMS V11.5.1 ? How much swap space is needed for the program to compile ? I am really at my wits' end. Please help. Oracle support has not given me any solution yet. Thanks. Regds, New Bee -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: CHAN Chor Ling Catherine (CSC) 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: 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
OTN Service Network
A survey : How many of you have used the OTN Service Network for Pay Per Incident Support, on Oracle Databases and Tools ? What level of support have you received ? How comfortable are you with it ? Hemant K Chitale Principal DBA Chartered Semiconductor Manufacturing Ltd [This e-mail is confidential and may also be privileged. If you are not the intended recipient, please delete it and notify us immediately; you should not copy or use it for any purpose, nor disclose its contents to any other person. Thank you.] -- 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).
Re: Old Chestnut: Tablespace Fragmentation
If you have only 1 Table in that Tablespace and only 1 File on that disk, even if you had multiple extents, you might expect them to be contiguous. Then, the only issue would be that the extent size should be a proper multiple of db_block_size*db_file_multiblock_read_count (or max_io_size). Hemant K Chitale Principal DBA Chartered Semiconductor Manufacturing Ltd Bill Buchan [EMAIL PROTECTED] 27/02/2002 08:43 PM Sent by: [EMAIL PROTECTED] Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: (bcc: CHITALE Hemant Krishnarao/IT/CHRT/ST Group) Subject: Old Chestnut: Tablespace Fragmentation I know this one has been done to death: use uniform extents to avoid fragmentation; multiple extents don't hurt (within limits). But what if: Data Warehouse, one big table on a single disk, full table (batch) scan, no concurrent transactions on the database (so no contention for the disk), no fragmentation at the file system level, initially empty buffer cache (startup), read-only operation so DBWR isn't doing anything on this disk. Basically I want to read one data file from end to end. Surely it would make sense to have the disk read moving smoothly from one end of the disk to the other rather than bouncing about all over the place as it may do with multiple extents randomly allocated. Any thoughts? Thanks - Bill. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Bill Buchan 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: 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: HP-UX Oracle Install
Can you explain the An old sys admin trick is to put a file named -i in the directory that you don't want touched. Does this prevent deletions of the files or rebooting or unmounting the file system ? Hemant K Chitale Principal DBA Chartered Semiconductor Manufacturing Ltd [EMAIL PROTECTED] 28/02/2002 02:23 PM Sent by: [EMAIL PROTECTED] Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: (bcc: CHITALE Hemant Krishnarao/IT/CHRT/ST Group) Subject: Re: HP-UX Oracle Install Hi As long as you don't have issues with having data files mounted remotely ie you have a pretty robust network between the server this shouldn't be a problem just clearly mark/document the directories that you use on the server that you mount file systems from as sometimes clever sysadmins delete directories that they cant find owners of files. One issue that you can have a little problem but it is mostly cosmetic and that is if you don't use common UID's in Unix. I always did consider remotely mounting datafiles as not a bright idea but apparently NFS 3 alleviates most of those concerns. Still you cant help someone rebooting the remote server. An old sys admin trick is to put a file named -i in the directory that you don't want touched. HTH -- = Peter McLarty E-mail: [EMAIL PROTECTED] Technical ConsultantWWW: http://www.mincom.com APAC Technical Services Phone: +61 (0)7 3303 3461 Brisbane, AustraliaMobile: +61 (0)402 094 238 Facsimile: +61 (0)7 3303 3048 = A great pleasure in life is doing what people say you cannot do. - Walter Bagehot (1826-1877 British Economist) = Mincom The People, The Experience, The Vision = Sujatha Madan [EMAIL PROTECTED] To:Multiple recipients Sent by: [EMAIL PROTECTED] of list ORACLE-L [EMAIL PROTECTED] cc: 28/02/2002 12:13 PM Fax to: Please respond to ORACLE-L Subject:HP-UX Oracle Install Hi, This may be more of a UNIX question, so please bear with me. We have a test server that has 1GB free space. We need to test our Oracle and application upgrade and there are no other servers other than this test server. Obviously there is not enough space. The powers above want to use two spare disks that are on our production system. Unfortunately they are part of a disk array and we can't remove them seperately and install them onto the test system. So what they want is to remotely mount these partitions (which are from the production server) onto the test system. That way I have more space and should be able to install Oracle. Does anyone know if this would cause a problem when installing Oracle? The production server already has two Oracle installations on seperate partitions. Could there be a conflict? I have a feeling there won't be a problem, but I just wanted to make sure. Thanks Sujatha --- Sujatha Madan Database
RE: Problem running a report
If the report was creating a large output file on the client (remote) PC, that would explain the waits on SQL*Net message from client. [the client would be SQL*Plus or Reports on the PC]. Depending on the network latency, the perceived runtime of the report can vary between sites. Does the report file have to be created on the client PCs ? Can you run it as a server process, ZIP the output file on the server and then FTP it to the clients ? If the report has to run from the PC, try tuning SQLNet (SDU, TDU) and the Buffer size. If you are using SQL*Plus, just doing a SET TERMOUT OFF with a SPOOL myoutputfile will make a big difference. Hemant K Chitale Principal DBA Chartered Semiconductor Manufacturing Ltd Babich , Sergey [EMAIL PROTECTED]27/02/2002 04:30 AM Sent by: [EMAIL PROTECTED] Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: (bcc: CHITALE Hemant Krishnarao/IT/CHRT/ST Group) Subject: RE: Problem running a report Thanks to everyone who responded. The database is centralized. Yesterday I PINGed some machines in different offices (and TRACERTed, too) right from the server, and the response time was under 100 msec. However, some offices reported it to have run normally. That particular report creates a big file on C: (local machine) which raises the question if the machine had enough space on that drive and how fragmented it was... Oh, users Best regards to everyone, Sergey -Original Message- Sent: Tuesday, February 26, 2002 2:54 PM To: Multiple recipients of list ORACLE-L Are you using remote connections to a centralized database, or does each office have its own database? Tracert and netstat commands should help you figure out if its a network issue. Regards Raj Babich , Sergey To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] SBabich@handecc: xmail.comSubject: Problem running a report Sent by: [EMAIL PROTECTED] om February 26, 2002 02:18 PM Please respond to ORACLE-L Hi, ladies and gentlemen, Here is a good one. We have 25 offices nation wide, running similar reports. At the headquarters the one in consideration takes 12 min to complete. Any other office (WAN) it gets stuck and takes a few hours if it completes at all. Here is the output from V$SESSION_WAIT for the session: SID SEQ# EVENT P1TEXT P1 P1RAW P2TEXT P2 P2RAW P3TEXT P3 P3RAW WAIT_TIME SEC_WT STATE - - - -- - -- - -- - - -- - 82 31384 SQL*Net message from clie driver id 675562835 28444553 #bytes 1 0001 0 00 0 0 WAITING After some time: SID SEQ# EVENT P1TEXT P1 P1RAW P2TEXT P2 P2RAW P3TEXT P3 P3RAW WAIT_TIME SEC_WT STATE - - - -- - -- - -- - - -- 82 33799 SQL*Net message from clie driver id 675562835 28444553 #bytes 1 0001 0 00 0 0 WAITING and so on.(SEQ# increases and then resets). At the headquarters (LAN) it shows the same event after scattered read and it is done. Could that be a SQL*Net issue between LAN and WAN? Any ideas are appreciated as always. TIA, Sergey -- 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
Re: ORA-27072
Is anybody running a copy command or a backup program which is locking the file ? Hemant K Chitale Principal DBA Chartered Semiconductor Manufacturing Ltd Shibu [EMAIL PROTECTED] 25/02/2002 07:43 PM Sent by: [EMAIL PROTECTED] Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: (bcc: CHITALE Hemant Krishnarao/IT/CHRT/ST Group) Subject: Re: ORA-27072 Hi abhijit when i restart the database it goes fine and again it goes down after 10-12 hours of working continiously .. Is this a bug ?? The version is as given below . BANNER Oracle8i Enterprise Edition Release 8.1.7.0.0 - Production PL/SQL Release 8.1.7.0.0 - Production CORE8.1.7.0.0 Production TNS for 32-bit Windows: Version 8.1.7.0.0 - Production NLSRTL Version 3.4.1.0.0 - Production regards, shibu - Original Message - From: Abhijit To: Multiple recipients of list ORACLE-L Sent: Monday, February 25, 2002 3:58 PM Subject: Re: ORA-27072 I think It's hitting the bug of 8.1.7.2. Is the database gets opened normally after it goes down intermittantly ? or does it gives the error whilt opening also ? What 's the exact verion/release of 8.1.7 ? try applying the latest patch . Hallas John wrote: Have a word with your sysadmin. See if I can find out what/who is using that fileAre all datafiles/control files and redo log etc owned by the same user (Oracle) and with the same permissionsSeems odd that it appears to be random across a number of filesHTH John -Original Message- From: Shibu [mailto:[EMAIL PROTECTED]] Sent: 23 February 2002 06:18 To: Multiple recipients of list ORACLE-L Subject: ORA-27072 Hi all.. My database is going down frequently showing this error in alertfile . This is happening to different datafiles and controlfiles.What are the possibilities that cause this error ? How can i avoid this error ? oracle 8.1.7 in win2k Errors in file C:\oracle\admin\acusis\bdump\acusisCKPT.TRC: ORA-00206: error in writing (block 3, # blocks 1) of controlfile ORA-00202: controlfile: 'D:\ORADATA\CONTROL01.CTL' ORA-27072: skgfdisp: I/O error OSD-04008: WriteFile() failure, unable to write to file O/S-Error: (OS 33) The process cannot access the file because another process has locked a portion of the file. regards, shibu = This electronic message contains information from the mmO2 plc Group which may be privileged or confidential. The information is intended to be for the use of the individual(s) or entity named above. If you are not the intended recipient be aware that any disclosure, copying, distribution or use of the contents of this information is prohibited. If you have received this electronic message in error, please notify us by telephone or email (to the numbers or address above) immediately. = * Disclaimer This message (including any attachments) contains confidential information intended for a specific individual and purpose, and is protected by law. If you are not the intended recipient, you should delete this message and are hereby notified that any disclosure, copying, or distribution of this message, or the taking of any action based on it, is strictly prohibited. * Visit us at http://www.mahindrabt.com -- 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
RE: Oracle8i - Oracle9i issue??????
Well, yes, I do understand that C# is MS's new-fangled language. My question C# ? actually meant There already are applications out there that use C# against an Oracle Database ? Do they use MS ODBC to connect ? Could the SQL command not properly ended error be because of the ODBC drivers ?. I forgot the reference to windows in the original email and was thinking more of Pro*C or Pro*C++ applications against Oracle. Hemant K Chitale Principal DBA Chartered Semiconductor Manufacturing Ltd Pardee, Roy E [EMAIL PROTECTED] 22/02/2002 11:38 PM Sent by: [EMAIL PROTECTED] Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: (bcc: CHITALE Hemant Krishnarao/IT/CHRT/ST Group) Subject: RE: Oracle8i - Oracle9i issue?? C# is ms' we-can't-run-away-with-the-java-standard-so-here's-our-own-'c-like' -language language for .Net. There's a good bit of foofaraw over whether or not it is better/faster than/will kill java etc. in the dev community. Not to be confused with the latest version of visual C++ (which is mostly the same as old C++, but includes extensions for coding against the .net virtual machine) or J#, which is supposedly yet still more Java-like than C#. Interested readers can get the party line at http://www.msdn.microsoft.com/msdnmag/issues/0900/csharp/csharp.asp. Cheers, -Roy Roy Pardee Programmer/Analyst SWFPAC Lockheed Martin IT Extension 8487 -Original Message- Sent: Friday, February 22, 2002 12:38 AM To: Multiple recipients of list ORACLE-L Yeah they refer to it as C Sharp as in the music # symbol. It is Microsoft's C.Net - I think. -Original Message- [mailto:[EMAIL PROTECTED]] Sent: Friday, February 22, 2002 10:08 AM To: Multiple recipients of list ORACLE-L C# ? Hemant K Chitale Principal DBA Chartered Semiconductor Manufacturing Ltd Denham Eva [EMAIL PROTECTED] 22/02/2002 03:13 PM Sent by: [EMAIL PROTECTED] Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: (bcc: CHITALE Hemant Krishnarao/IT/CHRT/ST Group) Subject: Oracle8i - Oracle9i issue?? Hello Guru's I wonder if any of you have had this problem, we have a external company developing a software package in C#. On their Oracle9i test system, the software works fine, however once brought accross to our systems, which is an Oracle8i ( 817) system the software gives a (ORA - 00933 SQL command not properly ended) error, but funny enough only on the one window. I am told by them that they do straight select from a table, saving the returned columns in variables etc. The only difference is they don't have any semi-colons (;) at the end of the their queries. But catch 22 it works on the other screens(windows). Hope you folks can help TIA Denham This e-mail message has been scanned for Viruses and Content and cleared by MailMarshal - For more information please visit www.marshalsoftware.com -- 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). This e-mail message has been scanned for Viruses and Content and cleared by MailMarshal - For more information please visit www.marshalsoftware.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Pardee, Roy E 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
Re: Oracle8i - Oracle9i issue??????
C# ? Hemant K Chitale Principal DBA Chartered Semiconductor Manufacturing Ltd Denham Eva [EMAIL PROTECTED] 22/02/2002 03:13 PM Sent by: [EMAIL PROTECTED] Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: (bcc: CHITALE Hemant Krishnarao/IT/CHRT/ST Group) Subject: Oracle8i - Oracle9i issue?? Hello Guru's I wonder if any of you have had this problem, we have a external company developing a software package in C#. On their Oracle9i test system, the software works fine, however once brought accross to our systems, which is an Oracle8i ( 817) system the software gives a (ORA - 00933 SQL command not properly ended) error, but funny enough only on the one window. I am told by them that they do straight select from a table, saving the returned columns in variables etc. The only difference is they don't have any semi-colons (;) at the end of the their queries. But catch 22 it works on the other screens(windows). Hope you folks can help TIA Denham This e-mail message has been scanned for Viruses and Content and cleared by MailMarshal - For more information please visit www.marshalsoftware.com -- 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).
Re: password question
Sameer, The obvious answer you can't decrypt the password. Else a number of people would think harder about buying Oracle. It's a one-way hash -- you can't get the original value back. It is possible to temporarily reset a user's password to something else, become the user with your own password and reset the password back to the original value, without knowing what the original password was. e.g. suppose a user's encrypted password string is 'ABCDEFGHIJKLMNOP', read this string from DBA_USERS, store it someplace (a variable, a table ;), execute ALTER USER username identified by mypassword, login as the user CONNECT username/mypassword, do your SQLs as that user, reset the user's password ALTER USER username identified by values 'ABCDEFGHIJKLMNOP' Hemant K Chitale Principal DBA Chartered Semiconductor Manufacturing Ltd Ghadge,Sameer [EMAIL PROTECTED] 22/02/2002 11:38 AM Sent by: [EMAIL PROTECTED] Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: (bcc: CHITALE Hemant Krishnarao/IT/CHRT/ST Group) Subject: password question Hi, Oracle stores password in encrypted format, is it possible (suppose i have access to dba_users table) to retrieve and descrypt the password. thx Sameer -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ghadge,Sameer 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: 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: sql question
Rich, Are you sure that that is what you want ? Suppose your range values were something like : begin end 1 9 1519 2329 ie, the RANGE table shows that 10-14 and 20-22 are invalid (not allowed) values. Your problem statement and the SQL that Paul provides for the problem statement would return numbers like 10, 11, 20,21 which are, actually, invalid. You'd have to write a cursor to loop through the valid ranges ?? Hemant K Chitale Principal DBA Chartered Semiconductor Manufacturing Ltd Paul Baumgartel [EMAIL PROTECTED] 22/02/2002 12:43 PM Sent by: [EMAIL PROTECTED] Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: (bcc: CHITALE Hemant Krishnarao/IT/CHRT/ST Group) Subject: Re: sql question To use your example column names: select num from numbers where num between (select min(begin) from range) and (select max(end) from range); --- oracle dba [EMAIL PROTECTED] wrote: Hi all, I have a SQL question. Suppose I have a table called RANGE looks like this: begin end 1 9 1019 2029 Then I have a table NUMBERS that's full of bunch of numbers like this: num 1 2 3 4 ... 98 99 100 I want to write a SQL that returns the number that are within the ranges defined in the RANGE table. So number 1 through 29 should be returned. Can someone help me with this? Thanks. Rich _ Send and receive Hotmail on your mobile device: http://mobile.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: oracle dba 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). __ Do You Yahoo!? Yahoo! Sports - Coverage of the 2002 Olympic Games http://sports.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Paul Baumgartel 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: 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: password question
But where do you get the known or captured hash ? Only a DBA can query DBA_USERS for PASSWORD. A regular user cannot query DBA_USERS and cannot see PASSWORD in ALL_USERS. If you are already a DBA on the target database you really don't need to find out the password for another user. Supposing you grab a site's FULL Export dump. I guess you can then do a FULL Import and get the captured hash. But why do you need it now that you have the FULL Database with you anyway ? Hemant K Chitale Principal DBA Chartered Semiconductor Manufacturing Ltd Jon Baker [EMAIL PROTECTED]22/02/2002 02:08 PM Sent by: [EMAIL PROTECTED] Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: (bcc: CHITALE Hemant Krishnarao/IT/CHRT/ST Group) Subject: RE: password question One way hash, yes, but can use username to forceably crack the password (same idea as unix CRACK password cracking program). Hash is consistent which is why you can pick up the password string and drop it to another database (same username) and have the password work on the new machine. A non Oracle example would be to perform the following at the unix prompt: echo 'some test string' | md5 With the hash, you could create several variations and test against the known or 'captured' hash. Again, brute force method. Jon Baker Database Architect [EMAIL PROTECTED] www.netsec.net -Original Message- [mailto:[EMAIL PROTECTED]] Sent: Friday, February 22, 2002 12:18 AM To: Multiple recipients of list ORACLE-L Sameer, The obvious answer you can't decrypt the password. Else a number of people would think harder about buying Oracle. It's a one-way hash -- you can't get the original value back. It is possible to temporarily reset a user's password to something else, become the user with your own password and reset the password back to the original value, without knowing what the original password was. e.g. suppose a user's encrypted password string is 'ABCDEFGHIJKLMNOP', read this string from DBA_USERS, store it someplace (a variable, a table ;), execute ALTER USER username identified by mypassword, login as the user CONNECT username/mypassword, do your SQLs as that user, reset the user's password ALTER USER username identified by values 'ABCDEFGHIJKLMNOP' Hemant K Chitale Principal DBA Chartered Semiconductor Manufacturing Ltd Ghadge,Sameer [EMAIL PROTECTED] 22/02/2002 11:38 AM Sent by: [EMAIL PROTECTED] Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: (bcc: CHITALE Hemant Krishnarao/IT/CHRT/ST Group) Subject: password question Hi, Oracle stores password in encrypted format, is it possible (suppose i have access to dba_users table) to retrieve and descrypt the password. thx Sameer -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ghadge,Sameer 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: 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: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San
RE: Disable certain users from login to database while applying H
Catherine Which database accounts will you lock ? You can't lock APPS, APPLSYS and APPLSYSPUB as APPLSYSPUB and APPS will be used by all users and APPS and APPLSYS will be used by the patch. Hemant K Chitale Principal DBA Chartered Semiconductor Manufacturing Ltd CHAN Chor Ling Catherine (CSC) [EMAIL PROTECTED]19/02/2002 05:23 PM Sent by: [EMAIL PROTECTED] Hi Gurus, Thanks for replying to my qn. Startup Database in Restricted mode will not work (for more details, pls refer to the email below). The following solutions : 1. Database ON LOGON Trigger = don't know whether it will work 2. Lock Database Account = I am going to use this solution. 3. Change Database Account Password = I believe it will work In our Oracle HR, we also support oracle client-server forms/reports, so I've to disable their accounts so that they do not access the HR database using sqlplus/forms/reports while I am applying patches. Regds, Catherine -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Tuesday, February 19, 2002 2:13 PM To: Multiple recipients of list ORACLE-L Subject: Re: Disable certain users from login to database while applying Human As you are talking of Oracle Apps, NONE of the suggested solutions : 1. Database ON LOGON Trigger 2. Lock Database Account 3. Change Database Account Password 4. Startup Database in Restricted mode would work. The users connect to the Database in the APPS schema -- this is the universal schema that Oracle Apps uses. The Patch requires APPS so Restricted doesn't help (unless you grant Restricted to APPS in which case all the users can logon). Ditto about locking, changing password or writing a trigger on the APPS schema. What you can do are : 1. Shutdown the Apache server for the Self-Service Modules 2. Shutdown the Forms server for the Forms Module 3. Shutdown the Concurrent Managers. All of the above would affect ALL users. Alternatively, login to the Application as the System Administrator user and change the Application User Passwords for the users whom you want disabled. Change the passwords back to a default (WELCOME) later. However, what you SHOULD do, per Oracle Support, is 1. Shutdown 2. Shutdown 3. Shutdown as I have listed above. If you are familiar with Oracle Applications Patching and are comfortable with reading the Patch drivers, you can figure out what database objects are being modified/updated/created and what Forms/Reports/HTML etc files are being modified/created by the patch. Then you can take an intelligent decision should you allow users to logon when applying the patch ? Hemant K Chitale Principal DBA Chartered Semiconductor Manufacturing Ltd CHAN Chor Ling Catherine (CSC) [EMAIL PROTECTED] 18/02/2002 03:28 PM Sent by: [EMAIL PROTECTED] Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: (bcc: CHITALE Hemant Krishnarao/IT/CHRT/ST Group) Subject: Disable certain users from login to database while applying Human Hi Gurus, I need to disable certain users from login to database while I apply the Human Resources Patches for our Oracle HR 11i Applications. Which is the best way to do it ? Should I write on-logon trigger to disable or should I take away their privileges to logon to report/forms/sqlplus ? What about the rest of the DBA Applications administrator ? What do U guys do to solve the dead-lock problem (If my users access the HR tables while I apply the patches, I will encounter dead-lock problem) ? Please advise. Thanks. Regds, New Bee -- Please see the
Re: Web DB 2.5 listener always hung for Oracle HRMS applications V11.
Catherine, Why don't you migrate from WebDB to Apache ?. There is excellent documentation on migrating from WebDB to Apache for 11i. Your WebDB listener could be hung if it is running in the wrong shell -- eg if you logout of the telnet session where the WebDB listener was started, you will see subsequents requests to the listener failing. This is because the parent shell has died. If you are starting it from the Bourne shell, try switching to Korn shell before starting it (or vice versa). Check whether the startup script calls nohup wdblsnr hostname portnumber . Hemant K Chitale Principal DBA Chartered Semiconductor Manufacturing Ltd CHAN Chor Ling Catherine (CSC) [EMAIL PROTECTED]21/02/2002 10:13 AM Sent by: [EMAIL PROTECTED] Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: (bcc: CHITALE Hemant Krishnarao/IT/CHRT/ST Group) Subject: Web DB 2.5 listener always hung for Oracle HRMS applications V11. Hi Gurus, We are running Oracle HRMS Applications 11I (V11.5.1) in two E450 sun servers. OS is Solaris 2.6 1st server contains the database, concurrent manager and report server. 2nd server contains the apache listener, TCF SERVER, Web DB 2.5 listener, Web DB 2.2 Listener and Form server listener. Qn : The Web DB 2.5 listener always hung. Is there a way to solve the problem ? Is anyone having the same configurations as me with no problem ? Please help. Thanks I've checked the network roundtrip between the 2 servers using tnsping=fast, no bottlenecks I've checked the number of processes in the database : it's only 26 concurrent users (26processes in the init.ora)=ok I've checked the 1st and 2nd server resources using vmstat and iostat : There are enough memory = no bottlenecks Oracle consultants claim that there is bug in the Web DB 2.5 listener (Version is adwdbctl.sh.UNIX 115.1 2000/05/01 17:35:52). The only solution is to bounce the web listener when the problem arises. We even schedule a job to bounce the listener at 7am and 1pm but that does not solve the problem. Sometimes, I still have to bounce the web listener manually when user reports the problem. Regds, New Bee -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: CHAN Chor Ling Catherine (CSC) 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: 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: Web DB 2.5 listener always hung for Oracle HRMS applications V11.
Catherine, You have the wrong note. Look up Note 119873.1 titled Apache Single Listener Configuration for Applications 11.5.1 I don't know how you are using the at command to startup the servers. I didn't suggest that the forms server and reports server die. I was talking of the WebDB listener specifically ! WebDB2.2 handles forms sign-ons while 2.5 handles online help and personal home page and self-service modules. Note 113254.1 refers to the Forms Server/Reports Server/ WebDB 2.2 dying because of the wrong shell. You need to check the shell your WebDB 2.5 runs from. Note 144400.1 covers WebDB 2.5 as well. Do a ps -ef to see if the process is running. Remember that WebDB 2.2 and 2.5 have different startup scripts and process names. I do remember seeing WebDB 2.5 die by itself occassionally. We had a cron job running the webdb startup script periodically. Hemant K Chitale Principal DBA Chartered Semiconductor Manufacturing Ltd CHAN Chor Ling Catherine (CSC) [EMAIL PROTECTED]21/02/2002 12:14 PM To: CHITALE Hemant Krishnarao/IT/CHRT/ST Group@ST Domain, '[EMAIL PROTECTED]' [EMAIL PROTECTED] cc: Subject: RE: Web DB 2.5 listener always hung for Oracle HRMS applications V11. Hi Hemant, Please ignore my earlier email. We use the at command to startup all our form server/report server/webdb listener etc so that even if we were to logout of the telnet session where the WebDB listener is started. The form server/report server/listener will not hung/died because the parent shell has died. Why don't you migrate from WebDB to Apache ? I've found the document in metalink Note:154666.1 = Moving virtual directory mappings from WebDB to iAS. Thanks. Qn : Has anyone using Oracle HRMS V11.5.1 migrated from WebDB to Apache before ? How's the performance ? Does the apache listener hung ? Please advise. Thank you. Regds, Catherine -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 21, 2002 11:08 AM To: Multiple recipients of list ORACLE-L Subject: Re: Web DB 2.5 listener always hung for Oracle HRMS applications V11. Catherine, Why don't you migrate from WebDB to Apache ?. There is excellent documentation on migrating from WebDB to Apache for 11i. Your WebDB listener could be hung if it is running in the wrong shell -- eg if you logout of the telnet session where the WebDB listener was started, you will see subsequents requests to the listener failing. This is because the parent shell has died. If you are starting it from the Bourne shell, try switching to Korn shell before starting it (or vice versa). Check whether the startup script calls nohup wdblsnr hostname portnumber . Hemant K Chitale Principal DBA Chartered Semiconductor Manufacturing Ltd CHAN Chor Ling Catherine (CSC) [EMAIL PROTECTED] 21/02/2002 10:13 AM Sent by: [EMAIL PROTECTED] Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: (bcc: CHITALE Hemant Krishnarao/IT/CHRT/ST Group) Subject: Web DB 2.5 listener always hung for Oracle HRMS applications V11. Hi Gurus, We are running Oracle HRMS Applications 11I (V11.5.1) in two E450 sun servers. OS is Solaris 2.6 1st server contains the database, concurrent manager and report server. 2nd server contains the apache listener, TCF SERVER, Web DB
Re: Rollback Segments
iag/iap, rpt and sql*menu were for the duhvelopers!. I wouldn't remember these product ; Hemant K Chitale Principal DBA Chartered Semiconductor Manufacturing Ltd Anjo Kolk [EMAIL PROTECTED] 19/02/2002 03:43 PM Sent by: [EMAIL PROTECTED] Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: (bcc: CHITALE Hemant Krishnarao/IT/CHRT/ST Group) Subject: Re: Rollback Segments How about iag/iap ? And rpt ? Oh and SQL*Menu ? And there were about 14 enqueue/locks in Oracle Version 5 as far as I can remember. Anjo Kolk Brings back memories of joining Oracle Europe in 1985 ;-) - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, February 19, 2002 6:43 AM I remember the BI.ORA (Before-Image) file, IOR and ODS in Oracle 5. Hemant K Chitale Principal DBA Chartered Semiconductor Manufacturing Ltd Rachel Carmichael [EMAIL PROTECTED] 19/02/2002 06:18 AM Sent by: [EMAIL PROTECTED] Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: (bcc: CHITALE Hemant Krishnarao/IT/CHRT/ST Group) Subject: RE: Rollback Segments UFI no, but the rest... that's where I started in Oracle -- version 5 --- Conboy, Jim [EMAIL PROTECTED] wrote: Holy cow Mladen, what a memory! Does anybody else remember (or admit to) using UFI? Jim ** ...does anybody still remember VAX/VMS, ORACLE$BI, IOR and ODT?... -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Conboy, Jim 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). __ Do You Yahoo!? Yahoo! Sports - Coverage of the 2002 Olympic Games http://sports.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 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: 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: Anjo Kolk 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
Re: Oracle 8i patch installation
If you install an additional option/product back from the 8.1.7 CDs later, you should reapply the 8.1.7.3 Patch. However, you would not need to rerun the sql scripts (catalog.sql, catproc.sql) unless the new option requires it -- e.g. if you install Advanced Replication later, you would need to run catrep.sql Hemant K Chitale Principal DBA Chartered Semiconductor Manufacturing Ltd [EMAIL PROTECTED] 19/02/2002 10:53 AM Sent by: [EMAIL PROTECTED] Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: (bcc: CHITALE Hemant Krishnarao/IT/CHRT/ST Group) Subject: Oracle 8i patch installation Hi, At my site I normally install Oracle Server EE using custom installation, i.e. I install only the products that I need. Now an Oracle 8i patchset (e.g. 8.1.7.3 patchset) contains patches for many products (RDBMS, PL/SQL, Networking, Intermedia etc). If I install say 8.1.7.3 on top of my current 8.1.7.0 it will install not only patches for products that I have in my current 8.1.7.0 installation, but also extra patches as well. This is fine for now I can foresee a problem in future when I install additional products from the 8.1.7.0 CD. Should I reapply the 8.1.7.3 patchset then to ensure that all products are properly patches? Do you see any problem with installing the same patchset more than once for an Oracle server? Thanks Long -- 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: 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: Rollback Segments
I remember the BI.ORA (Before-Image) file, IOR and ODS in Oracle 5. Hemant K Chitale Principal DBA Chartered Semiconductor Manufacturing Ltd Rachel Carmichael [EMAIL PROTECTED] 19/02/2002 06:18 AM Sent by: [EMAIL PROTECTED] Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: (bcc: CHITALE Hemant Krishnarao/IT/CHRT/ST Group) Subject: RE: Rollback Segments UFI no, but the rest... that's where I started in Oracle -- version 5 --- Conboy, Jim [EMAIL PROTECTED] wrote: Holy cow Mladen, what a memory! Does anybody else remember (or admit to) using UFI? Jim ** ...does anybody still remember VAX/VMS, ORACLE$BI, IOR and ODT?... -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Conboy, Jim 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). __ Do You Yahoo!? Yahoo! Sports - Coverage of the 2002 Olympic Games http://sports.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 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: 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: Disable certain users from login to database while applying Human
As you are talking of Oracle Apps, NONE of the suggested solutions : 1. Database ON LOGON Trigger 2. Lock Database Account 3. Change Database Account Password 4. Startup Database in Restricted mode would work. The users connect to the Database in the APPS schema -- this is the universal schema that Oracle Apps uses. The Patch requires APPS so Restricted doesn't help (unless you grant Restricted to APPS in which case all the users can logon). Ditto about locking, changing password or writing a trigger on the APPS schema. What you can do are : 1. Shutdown the Apache server for the Self-Service Modules 2. Shutdown the Forms server for the Forms Module 3. Shutdown the Concurrent Managers. All of the above would affect ALL users. Alternatively, login to the Application as the System Administrator user and change the Application User Passwords for the users whom you want disabled. Change the passwords back to a default (WELCOME) later. However, what you SHOULD do, per Oracle Support, is 1. Shutdown 2. Shutdown 3. Shutdown as I have listed above. If you are familiar with Oracle Applications Patching and are comfortable with reading the Patch drivers, you can figure out what database objects are being modified/updated/created and what Forms/Reports/HTML etc files are being modified/created by the patch. Then you can take an intelligent decision should you allow users to logon when applying the patch ? Hemant K Chitale Principal DBA Chartered Semiconductor Manufacturing Ltd CHAN Chor Ling Catherine (CSC) [EMAIL PROTECTED]18/02/2002 03:28 PM Sent by: [EMAIL PROTECTED] Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: (bcc: CHITALE Hemant Krishnarao/IT/CHRT/ST Group) Subject: Disable certain users from login to database while applying Human Hi Gurus, I need to disable certain users from login to database while I apply the Human Resources Patches for our Oracle HR 11i Applications. Which is the best way to do it ? Should I write on-logon trigger to disable or should I take away their privileges to logon to report/forms/sqlplus ? What about the rest of the DBA Applications administrator ? What do U guys do to solve the dead-lock problem (If my users access the HR tables while I apply the patches, I will encounter dead-lock problem) ? Please advise. Thanks. Regds, New Bee -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: CHAN Chor Ling Catherine (CSC) 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: 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: Changing dump destinations in init.ora
No, you do not have to. Dump_File_Dest information is not stored in the control-file -- it is read afresh at every instance startup. You can change the destinations in the initSID.ora and restart the instance for the new destinations to take effect. Hemant K Chitale Principal DBA Chartered Semiconductor Manufacturing Ltd Browett, Darren [EMAIL PROTECTED] 14/02/2002 04:18 AM Sent by: [EMAIL PROTECTED] Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: (bcc: CHITALE Hemant Krishnarao/IT/CHRT/ST Group) Subject: Changing dump destinations in init.ora Do I have to rebuild the controlfiles if I change any of the dump destinations in my oracle init.ora files. Thanks Darren -- Darren Browett P.Eng This message was transmitted Data Administrator using 100% recycled electrons Information and Communication Technology City of Coquitlam P:(604)927 - 3614 E:[EMAIL PROTECTED] --- -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Browett, Darren 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: 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: Oracle Migration Utility
Fred, There are a two different issues here .. 1. You seem to be on OPS currently ? Will you be migrating to OPS or non-OPS ? 2. You are moving from SGI to Sun. As it is a change of platform, the ONLY migration option you have is Export-Create_new_Database-Import. The new Database can be either OPS or non-OPS -- that does not matter. You must create the same Tablespace Names before you Import -- else the import will try to create the tablespaces with the datafile names as in the original (source) database. Hemant K Chitale Principal DBA Chartered Semiconductor Manufacturing Ltd Fred Collington [EMAIL PROTECTED] 12/02/2002 11:28 PM Sent by: [EMAIL PROTECTED] Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: (bcc: CHITALE Hemant Krishnarao/IT/CHRT/ST Group) Subject: Oracle Migration Utility Can anyone advise me on using the migration utility? We are finally moving from 7.3.4 to 8.1.7. Has the utility worked well for you? Known bugs? Any info greatly appreciated. THe history, if you want to know. We have been stuck at 7.3.4 due to a lack of migration path for OPS on SGI equipment. We are now installing a Sun 4800, and will be ready to start testing the migration in March. Cheers, Fred = Fred Collington Oracle DBA Naval Air Warfare Center, Training Systems Division __ Do You Yahoo!? Send FREE Valentine eCards with Yahoo! Greetings! http://greetings.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Fred Collington 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: 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: URGENT Help on tracking unauthorized login to Oracle Database
Ashoke, In chapter 24, go through : Managing Audit Trail Information Setting Auditing Options Enabling Audit Options Enabling Statement Privilege Auditing You will see this text : To audit all successful and unsuccessful connections to and disconnections from the database, regardless of user, BY SESSION (the default and only value for this option), enter the following statement: AUDIT SESSION; I use this query to report failed login attempts from SYS.AUD$ : select os_username, username, userhost, terminal, timestamp, returncode from sys.dba_audit_session where returncode != 0 order by timestamp / (DBA_AUDIT_SESSION is a view on AUD$) Hemant K Chitale Principal DBA Chartered Semiconductor Manufacturing Ltd Mandal, Ashoke [EMAIL PROTECTED] 12/02/2002 01:18 PM Sent by: [EMAIL PROTECTED] Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: (bcc: CHITALE Hemant Krishnarao/IT/CHRT/ST Group) Subject: RE: URGENT Help on tracking unauthorized login to Oracle Database Hi Revaldi and Joe (Testa), I went through the following Administrator's guide. Oracle8i Administrator's Guide Release 2 (8.1.6) Part Number A76956-01 I could only see chapter 24 on 'Auditing database Use' and under that the following sub-sections. I went through these secition and could not find anything on unsuccessful login to oracle database. Could you please help me in ponting to the right chapter/section. Guidelines for Auditing Creating and Deleting the Database Audit Trail Views Managing Audit Trail Information Viewing Database Audit Trail Information Auditing Through Database Triggers Thanks, Ashoke -Original Message- From: Behar, Rivaldi [mailto:[EMAIL PROTECTED]] Sent: Friday, February 08, 2002 1:29 PM To: Multiple recipients of list ORACLE-L Subject: RE: URGENT Help on tracking unauthorized login to Oracle Database Administrators guide. Chapter on auditing. Audit session. Rivaldi -Original Message- From: Mandal, Ashoke [mailto:[EMAIL PROTECTED]] Sent: Friday, February 08, 2002 12:54 PM To: Multiple recipients of list ORACLE-L Subject: RE: URGENT Help on tracking unauthorized login to Oracle Database Joe, We referred the auditing option. My understanding is that you can track the oracle users using database auditing feature once the users are logged into the database. But my requirement is to track the users who tried to login to the database but could not login due to wrong password. For example, somebody may know the connect string for an oracle database and trying to login to the database as system user and with various combination of password. We like to know who are these users. Thanks, Ashoke -Original Message- Sent: Friday, February 08, 2002 11:54 AM To: Multiple recipients of list ORACLE-L Database Administrators guide chapter on auditing. joe Mandal, Ashoke wrote: Greetings, We have a database with very sensitive data. Our management wants me to find out the way to secure this data from unauthorized login and track these users who tried to login to this database. Is there any way we can track the unauthorized users, who try to login to an oracle database with invalid userid or password but with valid connect string. If there is no options under oracle then is there any 3rd party software for this purpose. Any help is appreciated Thanks, Ashoke -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joseph S Testa 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
Re: lock problem
What sort of a terminal is TERMINAL A. Does the server-side process get killed when you power off the terminal ? Or is it just the display that on the TERMINAL that goes ? If the server side process is still hanging around, it wouldn't release the locks until it is killed or dies (e.g. by sqlnet Dead Connection Detection for a SQLNet connection or SIGHUP-kill -1 -- for a serial port terminal). Another i Hemant K Chitale Principal DBA Chartered Semiconductor Manufacturing Ltd Ali TOYGAR [EMAIL PROTECTED] 11/02/2002 03:33 AM Sent by: [EMAIL PROTECTED] Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: (bcc: CHITALE Hemant Krishnarao/IT/CHRT/ST Group) Subject: lock problem Hi , I have a problem. I wrote an sql : in TERMINAL A select col1,col2 from tableX where col1 = ... for update I wrot same sql , in other terminal TERMINAL B select col1,col2 from tableX where col1 = ... for update Then , I immidiately power off Terminal A. In other words connection is closed without rollback or commit. But , terminal B waits.. what is the problem ? TABLE ROW LOCK is not AUTOMATICALLY killed. I used , KILL SESSION to kill session. But in my oppinion ORACLE must do it. Because connection is closed. I want , oracle kill this type of lock. How can I set Oracle to kill this kind of LOCK problems ? please help me.. -- 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).
RE: ADI Warning
Just to add some more information on ADI. ADI sets up ODBC to connect to the database. When you define the database connection in the ADI setup screens, you can't find the information saved anwhere in the files the ADI Home on the PC. Therefore you cannot copy this information from one PC to another -- you have to manually set-up the database connect on each PC. We have enabled Database Session Audit and I have found that when a user used ADI and Excel to do a Journal Import from Excel to Oracle GL for 48 Journal Lines, the client made 21 connections to the database as APPLYSPUB and 26 connections as APPS between 14:46:00 and 14:50:18 (in the space of 4 minutes). Just think -- 47 distinct database sessions (connect-disconnect-connect-disconnect) from one client in 4 minutes (and only for 48 journal lines). The users are happy with ADI as it allows them to use Excel ;). I am not happy with the way it connects to the database -- quite expensive : Hemant K Chitale Principal DBA Chartered Semiconductor Manufacturing Ltd DENNIS WILLIAMS [EMAIL PROTECTED] 07/02/2002 05:15 AM Sent by: [EMAIL PROTECTED] Please respond to ORACLE-L Bambi - Obviously you've gone in so deep you forgot how dumb some of us are. To stem a tide of questions what the heck is ADI, here it is. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] ORACLE APPLICATIONS DESKTOP INTEGRATOR 11i Oracle® ADI is a spreadsheet-based extension to Oracle Applications that offers full cycle accounting and asset management within the comfort and familiarity of a spreadsheet. ADI combines a spreadsheet's ease of use with the power of Oracle Applications to provide true desktop integration during every phase of the accounting cycle. You can create budgets, record transactions, add assets, reconcile inventory, define and publish reports from any application to the web, a spreadsheet, or standard text output, and you can even perform account drilldown and analysis-all without leaving the desktop. -Original Message- Sent: Wednesday, February 06, 2002 2:33 PM To: Multiple recipients of list ORACLE-L Friends -- Lately I've been relegated to the deepest recesses of the dark murky depths of Oracle's product line. I see you blithely exchanging DBA mail and look on longingly, pining for the fjords, as it were. But I digress. If you every have to install ADI on a PC, make sure it doesn't have any Oracle products installed on it. Make sure there are no Oracle directories either in C: or in C:\Program Files. If you do, you will not be able to install ADI, and must deinstall all existing Oracle products before installing ADI, which, graciously, comes with SQL*Plus and SQL*Net. Everything else needs to be reinstalled. Oh, and that old TNSNAMES.ora file you have hanging around, it don't mean anything to ADI. I just can't fathom why Oracle would do this to itself. I hope its foot starts feeling better soon. Bambi. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Bellows, Bambi 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: DENNIS WILLIAMS 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: 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: Unix permissions
oracle will be writing to the directories ... so add the Oracle RDBMS owner in the group owning the directory OR let the owner of the directory be the application user but change the group to dba. In either case, you would need chmod g+w on the directory. Hemant K Chitale Principal DBA Chartered Semiconductor Manufacturing Ltd John Dunn [EMAIL PROTECTED] 07/02/2002 05:53 PM Sent by: [EMAIL PROTECTED] Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: (bcc: CHITALE Hemant Krishnarao/IT/CHRT/ST Group) Subject: Unix permissions Since we use utl_file to read/write files from our application directories(which are not owned by oracle), we need to set the permissions on these directories so that Oracle has permission to read and write to them. However we run into problems because Systems Admin guys do not like : 1. setting 777 permissions on the directories 2. making our application user a member of the oracle group Anyone had the same problems? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: John Dunn 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: 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: svrmgrl
Well oracle IS the owner of the database. oracle has connected to the database as SYS. This is similar to connecting as INTERNAL. Go back to any database you have running the earlier versions of Oracle, connect as INTERNAL in svrmgrl and ask the same question again. Hemant K Chitale Principal DBA Chartered Semiconductor Manufacturing Ltd àãø éçéàì [EMAIL PROTECTED] 07/02/2002 09:09 PM Sent by: [EMAIL PROTECTED] Hello Rachel All Tested it and it worked. it worked so well that I could access any table (tested some). ? Where is the security? Yechiel Adar, Mehish Computer Services [EMAIL PROTECTED] -Original Message- From: Rachel Carmichael [SMTP:[EMAIL PROTECTED]] Sent: Wed, February 06, 2002 9:44 PM To: Multiple recipients of list ORACLE-L Subject: Re: svrmgrl that's because, as Oracle has been promising, they no longer support svrmgrl in 9i. It does not exist, you will need to use sqlplus: sqlplus /nolog connect / as sysdba --- [EMAIL PROTECTED] wrote: Hi, Where can I find svrmgrl in 9i. It is not in the same place as 8i. Thanks -- 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). __ Do You Yahoo!? Send FREE Valentine eCards with Yahoo! Greetings! http://greetings.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 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). -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- This e-mail was scanned by the eSafe Mail Gateway -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-8?Q?=E0=E3=F8_=E9=E7=E9=E0=EC?= 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). æ¬zǶ¨}ø©ND ±@Bm§ÿðà +iöªrºØh¬DN¦j{\+Zç!j»^çlzh¢aZ´(È×ÂäIêïǬó9ßÎtçQ@_Î|ç9ÓRjpâz jX¢¹âhû'׫ëZqǬ³óX§¸¬¶ÄèDCTL¨º»÷ë¢kaÉX§X¬¶Ç§u©Ä1¨¥ë,j ¸¬´k«¹ör+rr§¢×\ ²¥)à¡òâ²Ñ®®æ§v)í é²Æ xb)Üç^jX§yÊ'µ¨§x5%9,Bè®Ø^©¡ùX§X¬·*.Á©í¶Þ騽ç_®¢éÉ©l¢Ç§vØ^BÏr¦jw_¢º- êâú+«b¢ybë.nÇ+¸§
Re: About Temporary tablespaces and temporary segments allocation
Imma, A database when created, by default, has all tablespaces as of type PERMANENT. A sort which exceeds the sort_area_size allocated in memory goes to the user's TEMPORARY_TABLESPACE which, btw, CAN be a PERMANENT tablespace. Thus, sorts would allocate Temporary Segments in the tablespace named TEMP. The issue with having a PERMANENT TEMPORARY_TABLESPACE is that you would have frequent segments being created and dropped and extents being allocated and dropped within each segment whenever users do large sorts. This could be a performance hit and can fragment the Tablespace. If there are no segments in the tablespace, you could just do an ALTER TABLESPACE temp TEMPORARY and a single sort segment would be created on the first sort/usage of the tablespace. Note that once the tablespace is TEMPORARY, you cannot create any other objects (Tables/Indexes) in it. You can segments and extents in PERMANENT tablespaces in DBA_SEGMENTS and DBA_EXTENTS. For TEMPORARY tablespaces, query V$SORT_SEGMENT and V$SORT_USAGE. If you do have other segments already present in the tablespace, you would have to move them out (Export-Drop-Create_in_new_TBS-Import OR Copy-Drop-Rename) OR create another tablespace of type TEMPORARY and set that as the user's temporary tablespace CREATE TABLESPACE temp2 datafile 'adfa' TEMPORARY; ALTER USER username TEMPORARY TABLESPACE temp2; Hemant K Chitale Principal DBA Chartered Semiconductor Manufacturing Ltd Imma C. Rocco [EMAIL PROTECTED] 01/02/2002 04:35 AM Sent by: [EMAIL PROTECTED] Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: (bcc: CHITALE Hemant Krishnarao/IT/CHRT/ST Group) Subject: About Temporary tablespaces and temporary segments allocation Hi, I have probably to beg you pardon for my question but I have a very short experince as an Oracle dba and it is the first time I found a situation like the one I'm going to describe to you. Working on an existing Oracle database I found that all users had been defined with an associated temporary tablespace named TEMP but selecting from dba_tablespaces the TEMP tablespace resulted to be PERMANET not TEMPORARY - problably because it had been turned from TEMPORARY to PERMANENT in a later time. I would like to know what happens in case the SORT_AREA_SIZE in not large enough to manage with sort opererations - are temporary segments still allocated on the TEMP tablespace (despite the fact that it is not TEMPORARY but PERMANET) or a temporary segment could be allocated only on a temporary tablespace? Thanks in advance Imma -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Imma C. Rocco 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: 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: Rename a datafile
A tablespace is a logical concept. Tablespace names are available only from the Data Dictionary --- when the Database is OPEN. DataFiles are physical. DataFile names are in the ControlFile. If you want to move a datafile when the database is OPEN, you must take the Tablespace Offline and move and then rename the file. If you can afford to MOUNT but not OPEN the database, you can do an ALTER DATABASE RENAME FILE old TO new. Note that in both cases you must actually move or copy the file to the new location yourself, using the OS's move or copy command before you execute the Rename in Oracle. Oracle will NOT move the file for you. Hemant K Chitale Principal DBA Chartered Semiconductor Manufacturing Ltd Joe LaCascio [EMAIL PROTECTED]31/01/2002 09:05 AM Sent by: [EMAIL PROTECTED] Okay, I don't have the manuals with me and can't for the life of me remember the correct syntax to do this... Is it: shutdown database startup no noumt (or startup mount) alter tablesapce evisions rename datafile '/full_path/file_name' to '/full_path/new_name'; I'm on 8.1.6 and this complains saying the database isn't open. It can't be open to rename a datafile... Thanks, Joe -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joe LaCascio 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: 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: adpatch question
How many people have really tried the other options in adctrl. Quite rare that you have to attempt them : 3.Tell worker to shutdown/quit 4.Tell manager that a worker failed its job 5.Tell manager that a worker acknowledges quit 6.Tell manager to start a worker that has shutdown Hemant K Chitale Principal DBA Chartered Semiconductor Manufacturing Ltd Bellows, Bambi [EMAIL PROTECTED] 30/01/2002 05:56 AM Sent by: [EMAIL PROTECTED] Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: (bcc: CHITALE Hemant Krishnarao/IT/CHRT/ST Group) Subject: RE: adpatch question Matt (and any others who are interested) - My adpatch went fine after tinkering under the hood except for one place where Oracle created a table, populated it and blew away its max extents. Amusing, but lame. I can't speak for Oracle on this one, but it looks to me that if you wind up in the position I was (that is to say screwed) that is the way to fix it. Another thing to bear in mind is that the hidden option (8) in adctrl should NOT be selected unless the workers are actively working. If ps -ef worker does not show any workers, do NOT quit an active process. You are better off, at that point, to rerun adpatch without killing anything and letting adpatch attempt to clean up after itself. HTH, Bambi (head under the hood gal). -Original Message- From: Adams, Matthew (GEA, 088130) [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 29, 2002 3:28 PM To: Multiple recipients of list ORACLE-L Subject: RE: adpatch question If he's not interested, I am. Please post a summary upon completion. Matt Matt Adams - GE Appliances - [EMAIL PROTECTED] Discussing a black rectangle silhouetted on a martian landscape That is the top of the calibration target, that is NOT in fact a monolith - NASA TV Commentator - 7/5/1997 -Original Message- From: Bellows, Bambi [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 29, 2002 2:53 PM To: Multiple recipients of list ORACLE-L Subject: RE: adpatch question John -- Thanks for the email back. Apps suck, and going under the hood is not for the weak of stomach. Of course, I'm not... and, at this point, fighting a fire is more fun than watching a heap of smoldering ashes. So, I did it. I went under the hood, and found that the fnd_install_processes table has one entry for each worker plus one for worker 0, which, I assume, is the driver. The status for 0 was W, 1-3 was R and 4 was J. I changed 4 to R and re-ran and, so far, at least, everything is fine. 650 jobs have run, so, I think that if anything dangerous would have happened it would have happened by now. It's just irritating. I'm off to explore how to run a .jlt file manually... maybe I could find an FM somewhere to R. I'll let you know how this finishes if you're interested... Bambi. -Original Message- Sent: Tuesday, January 29, 2002 1:15 PM To: Multiple recipients of list ORACLE-L Bambi, I wouldn't touch *anything* under the hood as far as Apps goes, esp. 11i. Raise a TAR and let Oracle Support come back to you on this. I assume that you are testing the upgrade and not actually doing it. These sort of things should have been ironed out prior to the upgrade with lots of iterations on lots of clones. A 11i upgrade is NOT for the faint of heart. Sorry - but that's what I would recommend! John Kanagaraj Oracle Applications DBA DBSoft Inc (W): 408-970-7002 Fear is the darkroom where Evil develops your negatives. Wanna break free of fear? Click on 'http://www.needhim.org' ** The opinions and statements above are entirely my own and not those of my employer or clients ** -Original Message- From: Bellows, Bambi [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 29, 2002 10:21 AM To: Multiple recipients of list
RE: adpatch question
Way to go ! I've updated FND_INSTALL_PROCESSES, played around (updated) the restart files in $APPL_TOP/admin/envname/restart etc. Hemant K Chitale Principal DBA Chartered Semiconductor Manufacturing Ltd Bellows, Bambi [EMAIL PROTECTED] 30/01/2002 03:53 AM Sent by: [EMAIL PROTECTED] Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: (bcc: CHITALE Hemant Krishnarao/IT/CHRT/ST Group) Subject: RE: adpatch question John -- Thanks for the email back. Apps suck, and going under the hood is not for the weak of stomach. Of course, I'm not... and, at this point, fighting a fire is more fun than watching a heap of smoldering ashes. So, I did it. I went under the hood, and found that the fnd_install_processes table has one entry for each worker plus one for worker 0, which, I assume, is the driver. The status for 0 was W, 1-3 was R and 4 was J. I changed 4 to R and re-ran and, so far, at least, everything is fine. 650 jobs have run, so, I think that if anything dangerous would have happened it would have happened by now. It's just irritating. I'm off to explore how to run a .jlt file manually... maybe I could find an FM somewhere to R. I'll let you know how this finishes if you're interested... Bambi. -Original Message- Sent: Tuesday, January 29, 2002 1:15 PM To: Multiple recipients of list ORACLE-L Bambi, I wouldn't touch *anything* under the hood as far as Apps goes, esp. 11i. Raise a TAR and let Oracle Support come back to you on this. I assume that you are testing the upgrade and not actually doing it. These sort of things should have been ironed out prior to the upgrade with lots of iterations on lots of clones. A 11i upgrade is NOT for the faint of heart. Sorry - but that's what I would recommend! John Kanagaraj Oracle Applications DBA DBSoft Inc (W): 408-970-7002 Fear is the darkroom where Evil develops your negatives. Wanna break free of fear? Click on 'http://www.needhim.org' ** The opinions and statements above are entirely my own and not those of my employer or clients ** -Original Message- From: Bellows, Bambi [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 29, 2002 10:21 AM To: Multiple recipients of list ORACLE-L Subject: adpatch question Hi Folks! I'm in the middle of an 11.5.5 upgrade. Now, if you've done that type of thing before, you know those suckers just run forever, and if you leave it running overnight, you generally come in the next day to find that things failed overnight. Well, that's where I was. I left this sucker to run overnight, and, when I came in, sure enough, worker 4 had crapped out with a java error. I checked metalink, and it said skip it, and when you're done with 1808429 (the 11.5.5 upgrade patch), just run asfakreg.jlt manually. Fine. No big deal. I went into adctrl and everything was in a wait state except for ol number 4 which crapped out. I chose hidden option 8 (skip this thing) and the status changed to Skip restart. Great. Except it didn't. Evidently, having no response for X amount of time, all my workers stopped. Again, no big deal, just re-run adpatch and let it start where it crapped out. Well, now we run into a big deal, because it can't change the status from Skip restart to anything that will allow adpatch to start again (like, maybe, failed where it was before I fixed it). I'm thinking of going under the sheets, finding the $%^* table and updating the status myself. Anyone have any reason why that's not such a great idea? Anyone have any other sneaky ways to change the status? Anyone have a list of the hidden options that Oracle doesn't tell you about (like ol number 8 there?)? aTdHvAaNnKcSe! Bambi. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Bellows, Bambi 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
Re: multiple extents are OK, dagnabbit!
I wonder why the upgrade scripts were rebuilding the FET$, UET$ tables. When you mention sql.bsq -- that applies only when you CREATE the database. Did you CREATE and IMPORT to do the upgrade ? IMPORT would certainly be active on FET$ and UET$. Hemant K Chitale Principal DBA Chartered Semiconductor Manufacturing Ltd Dave Morgan [EMAIL PROTECTED] 23/01/2002 12:55 AM Sent by: [EMAIL PROTECTED] Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: (bcc: CHITALE Hemant Krishnarao/Prin DBA/CSM/ST Group) Subject: Re: multiple extents are OK, dagnabbit! Hi Jeremiah, The problem arose in the catalog upgrade script. It would never return. My diary says we let one attempt run for 36 hours. The process showed CPU usage and I/O but nothing happened. Some of the Oracle guys figured the problem was with the $fet (or whatever tables hold the extent info, I never bother with the internals of the data dictionary) having problems while being restructured. Once the tables were changed from 40K to 500M extents the upgrade took less than 2 hours. One of the suggestions I did not use was to edit sql.bsq to provide much larger extents for the table holding the extent info. Even though I do this for the SOURCE$ table I am a big fan of the KISS principle and rebuilding the tables needed to be done anyways. HTH Dave Can you elaborate on exactly what happened? 8.1.5 to 8.1.6 is just a catalog script and a binary change. What error did you encounter, and at which step in the upgrade? Extents should not matter in an upgrade. -- Dave Morgan DBA, Cybersurf Office: 403 777 2000 ext 284 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Dave Morgan 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: 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: DBA Experiences with Oracle and RAID 0+1
How about Singapore for both Oracle OpenWorld and Miracle Master Class ? ;) I'd even take leave-without-pay and pay for the registration charges myself to attend, if necessary. ;) ;) Hemant K Chitale Principal DBA Chartered Semiconductor Manufacturing Ltd Boivin, Patrice J [EMAIL PROTECTED]22/01/2002 01:12 AM Sent by: [EMAIL PROTECTED] Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: (bcc: CHITALE Hemant Krishnarao/Prin DBA/CSM/ST Group) Subject: RE: DBA Experiences with Oracle and RAID 0+1 As a cost-cutting measure: They could combine the U.S. and European conventions, all they have to do is hold them in Halifax ... Regards, Patrice Boivin Systems Analyst (Oracle Certified DBA) -Original Message- Sent: Monday, January 21, 2002 11:56 AM To:Multiple recipients of list ORACLE-L Oracle OpenWorld in the Americas will never leave the West Coast and is highly unlikely to leave San Francisco. Too convenient to Headquarters If Miracle gave that class in Halifax, I'd go! --- Boivin, Patrice J [EMAIL PROTECTED] wrote: May I suggest Halifax, Canada as a great location for this course??? StilL waiting for Oracle OpenWorld to come here, somehow they never do. : ) Regards, Patrice Boivin Systems Analyst (Oracle Certified DBA) Systems Admin Operations | Admin. et Exploit. des systèmes Technology Services| Services technologiques Informatics Branch | Direction de l'informatique Maritimes Region, DFO | Région des Maritimes, MPO E-Mail: [EMAIL PROTECTED] -Original Message- Sent: Monday, January 21, 2002 8:06 AM To: Multiple recipients of list ORACLE-L Subject: Re: DBA Experiences with Oracle and RAID 0+1 you have no idea how badly most of us now want to come to that class. Not that I'd understand most of what was said, but just to listen :) --- Mogens Nørgaard [EMAIL PROTECTED] wrote: Jared, Good thought! We're running our annual Miracle Master Class (this year with Jonathan Lewis) this week and Cary Millsap (and his gang), Jonathan and James will arrive tomorrow (Monday), while Steve Adams, Lex de Haan, Stephan Haisley and a bunch of other guys will arrive on Tuesday. I'll keep this message and throw it up for discussion on the Oak Table (see Cary's wonderful article on www.Undskyld.Org)... Jared Still wrote: Mogens, In regard to the number of spindles issue: James Morle has some excellent discussion on that in 'Scaling Oracle 8i'. ( I think it's that book ) When some of the newer larges drives are used in a given configuration, they mabe be able to outperform older drives in a similar configuration with a larger number of spindles. I say 'older' since smaller drives usually aren't using the latest technology and the newer ones have sufficiently higher throughput to match the capability of a larger number of drives in given configuration. Food for thought, anyway. Jared On Sunday 20 January 2002 06:50, Mogens Nørgaard wrote: Diego, I agree with you 100% and didn't express myself correctly in my email. The more spindles the better. What I meant to say was that you must never buy disks by taking your total needed amount of space and divide by the number of big disks you can get hold on :). It's the number of IO's required by the disk system that matters, not the size... Thanks for making this clear to everyone. Mogens Diego Cutrone wrote: Mogens: Just let me disagree with you at only one point. According to my experience, I think that the size of the disks in an array does matter sometimes. It's not the same to have 24 9GB disks that to have only 3 of 73GB. You have 24 spindles againts 3, the first option (in a well configured system of course) will give you better performance in enviroments where you have a lot of concurrency and many users. However I think that what I've written above might not be correct (may be it should be tested) if the 73GB outstands for a long way the 9GB disks in terms of seek time and transfer rate. Take a look at an extract of Gaja's paper Implementing RAID on Oracle: 5) Procure the smallest drive money can buy, keeping in mind
Re: Alias Table Error...why?
Check the a.pc_session_user_name = 'tsokol' There is no alias a. Hemant K Chitale Principal DBA Chartered Semiconductor Manufacturing Ltd Lance Prais [EMAIL PROTECTED] 22/01/2002 08:15 AM Sent by: [EMAIL PROTECTED] Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: (bcc: CHITALE Hemant Krishnarao/Prin DBA/CSM/ST Group) Subject: Alias Table Error...why? I have the following SQL Statement but am getting and ORA-00904 Invalid Column Error. What Could I be doing wrong? SELECT Launch.oc_session_id FROM pt_client_eventdetails launch, pt_client_eventdetails logout WHERE a.pc_session_user_name = 'tsokol' and (logout.pc_event_op = 'LAUNCH' and logout.pc_event_op 'LOGOUT' and logout.pc_event_op 'SOLUTION_VIEWED') and launch.pc_session_id = logout.pc_session_id -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Lance Prais 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: 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: Standby Instance questions and HA
AFAIK, TAF does not support Forms. Refer to Note 114548.1 and 97926.1 (quoting from 114548.1 : Developer applications do not support TAF as there is no great advantage in using it. and from 97926.1: At the time of writing only a limited number of client environments are 'failover aware'. These include: Sql*Plus 8.1 OCI8 and clients built using OCI8 Hemant K Chitale Principal DBA Chartered Semiconductor Manufacturing Ltd Jamadagni, Rajendra [EMAIL PROTECTED] 18/01/2002 11:50 PM Sent by: [EMAIL PROTECTED] Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: (bcc: CHITALE Hemant Krishnarao/Prin DBA/CSM/ST Group) Subject: RE: Standby Instance questions and HA Speaking of TAF, Does anyone know (or have tested/implemented/explored) TAF with Forms application? Does this work?? We have another JAVA application that connects using JDBC and looks for certain errors and whenever it detects an error (appropriate one), it reconnects to the other side. Both sides are 9i instances. __ Rajendra Jamadagni MIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot com Any opinion expressed here is personal and doesn't reflect that of ESPN Inc. QOTD: Any clod can have facts, but having an opinion is an art! -Original Message- Sent: Friday, January 18, 2002 8:31 AM To: Multiple recipients of list ORACLE-L Ah but with 9i, RAC and TAF you can have the users reconnected automagically and they will resume their transactions inflight. Attachment Removed : ESPN_Disclaimer.txt -- 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).
RE: [resend] multiple extents are OK,
- Forwarded by CHITALE Hemant Krishnarao/Prin DBA/CSM/ST Group on 18/01/2002 11:36 AM - CHITALE Hemant Krishnarao/Prin DBA/CSM/ST Group18/01/2002 11:21 AM Jerry, Multiple extents is not a problem, true. But you could put in some consulting effort to resize the extents --- recreate the tablespaces (or at least those tables which suffer full-table scans) with uniform-sized extents where the extent size is a proper multiple of the max_io size -- that way you can reduce the I/O calls for FTSs, do some export/import/rebuilding, keep your client happy (tell them about extent-sizes rather than number of extents) and earn some $$. Hemant K Chitale Principal DBA Chartered Semiconductor Manufacturing Ltd DENNIS WILLIAMS [EMAIL PROTECTED] 18/01/2002 09:55 AM Sent by: [EMAIL PROTECTED] Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: (bcc: CHITALE Hemant Krishnarao/Prin DBA/CSM/ST Group) Subject: RE: multiple extents are OK, dagnabbit! Jerry - Maybe I'm missing something here. Since you refer to them as a client, you must have a consulting relationship with them - right? So if you rebuild the tables, you get more money - right? So you rebuild the tables, the client is happy, and you are a little wealthier - right? Or maybe you are too wealthy as it is, with more work than you can handle. Then you solicit help from others on this list to be your trusted assistant that will rebuild the tables, explaining to the client that you are overqualified for such a mundane task. I'm teasing you, but the older I get, the more I see that sometimes we computer folk are our own worst enemy. There is such a thing as being technically right but losing the client anyway. By the way, I totally agree with you on the multiple extents issue, but since Oracle was nice enough to post the paper Stop Defragmenting . . on their web site, that seems to have convinced the manager that wanted to hear something from the vendor before he would believe it. In my case I'm an employee, so it would just cut into my weekends. Good luck, but don't forget the softer skills. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Thursday, January 17, 2002 3:46 PM To: Multiple recipients of list ORACLE-L Hi there - I'm trying to convince a client that multiple extents for a table will not hurt their performance. It's a PeopleSoft app, and PeopleSoft is telling them that they need to reorg any object with greater than 10 extents (even indexes). This Oracle 8.1.6. I've referenced the How to Stop Defragmenting and Start Living: The Definitive Word on Fragmentation white paper by Bhaskar Himatsingka and Juan Loaiza of Oracle. That didn't convince them. I tried to explain that Oracle reads BUFFERS and not extents, etc., but that didn't work. I'm about to open a vein. Does anybody have any references that they can point me to? (Something from PeopleSoft would be ideal, though I would be suprised if it existed.) I read a rant on somebody's web site a while back that was really good, but alas I cannot remember his name or URL. (I blame my kids for my failing memory). Thanks! - Jerry -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: DENNIS WILLIAMS 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: 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
Re: Lookup Table Usage
Try using V$DB_OBJECT_CACHE , I think it does exist in 7.3.4 Hemant K Chitale Principal DBA Chartered Semiconductor Manufacturing Ltd [EMAIL PROTECTED] 17/01/2002 07:07 AM Sent by: [EMAIL PROTECTED] Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: (bcc: CHITALE Hemant Krishnarao/Prin DBA/CSM/ST Group) Subject: Re: Lookup Table Usage Use database auditing. Lookup 'audit' in the SQL manual. Jared Whittle Jerome Contr NCITo: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Jerome.Whittle@sco cc: tt.af.milSubject: Lookup Table Usage Sent by: [EMAIL PROTECTED] 01/16/02 01:20 PM Please respond to ORACLE-L Hi, Oracle 7.3.4 on Unix. The database has dozens of little lookup tables. I'd like to cache those used the most. Is there a way to see how often a table is queried? Thanks, Jerry Whittle ACIFICS DBA NCI Information Systems Inc. [EMAIL PROTECTED] 618-622-4145 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Whittle Jerome Contr NCI 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: 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: 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: dynamic views in 8.1.6
$)CYes. Look at the list of required init.ora settings to be applied after migrating/upgrading an Apps 10.7/11 database to 8.1.7 when upgrading to Apps 11i ! [pasting from the Apps 11i Upgrade manual] Set init.ora file parameters In your init.ora file, set the following parameters to the values indicated. Restart your database for the new parameters to take effect. _complex_view_merging = true _fast_full_scan_enabled = false _like_with_bind_as_equality = true _new_initial_join_orders = true _optimizer_mode_force = true _optimizer_undo_changes = false _or_expand_nvl_predicate = true _ordered_nested_loop = true _push_join_predicate = true _push_join_union_view = true _sort_elimination_cost_ratio = 5 _table_scan_cost_plus_one = true _trace_files_public = true _use_column_stats_for_function = true _sqlexec_progression_cost = 0 aq_tm_processes = 1 always_anti_join = NESTED_LOOPS always_semi_join = NESTED_LOOPS db_block_buffers = 5000 db_files = 500 db_file_multiblock_read_count = 8 dml_locks = 500 enqueue_resources = 5000 log_buffer = 1048576 log_checkpoint_interval = 10 log_checkpoint_timeout = 72000 max_enabled_roles = 40 nls_date_format = DD-MON-RR nls_language = american nls_numeric_characters = ., nls_sort = binary nls_territory = america open_cursors = 500 optimizer_features_enable = 8.1.7 optimizer_max_permutations = 2000 optimizer_mode = rule optimizer_percent_parallel = 0 parallel_min_servers = 0 processes = 75 query_rewrite_enabled = true row_locking = always shared_pool_reserved_size = 3000 shared_pool_size = 3 sort_area_size = 256000 timed_statistics = true Hemant K Chitale Principal DBA Chartered Semiconductor Manufacturing Ltd Mogens N)*rgaard [EMAIL PROTECTED] 16/01/2002 09:15 AM Sent by: [EMAIL PROTECTED] Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: (bcc: CHITALE Hemant Krishnarao/Prin DBA/CSM/ST Group) Subject: Re: dynamic views in 8.1.6 _might_be_running_apps = true commit; Mogens Stephane Faroult wrote: Oracle DBA wrote: we have added these parameters in the init.ORA file . query_rewrite_enabled=true _complex_view_merging=true _push_join_predicate=true optimizer_max_permutations=79000 _use_column_stats_for_function=true _like_with_bind_as_equality=true _push_join_union_view=true _ordered_nested_loop=true _or_expand_nvl_predicate=true after these changes all the dynamic views created by developers have stopped working . our database is running on aix 4.3.3 and its in MTS mode . Will appreciate quick response. thanks in advance . brajesh jaiswal _stop_messing_with_undocumented_parameters=TRUE -- 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).
Re: Recovery scenario query
If you don't have enough disk space to backup all the datafiles in one run . create alternate backup sets. On Mondays, Wednesdays,Fridays : Backup the Active tablespaces On Tuesdays, Thursdays : Backup the Inactive tablespaces [You could break this down further if you still don't have enough disk space.. but I guess you get the idea]. In case you lose the Inactive tablespace on Thursday evening, you need Tuesday night's backups + All the Archived Redo Logs from Tuesday night onwards --- therefore you cannot delete Archived Logs daily (ie, when you run your Wednesday backup you cannot delete all the archive logs -- you must keep those from Tuesday night onwards). [note the keep those from Tuesday night onwards means keep at least those generated from the point-in-time when Tuesday night's backup *BEGAN* not when it _ended_]. Normally, I wouldn't keep only the last two days archive logs. I'd probably keep at least a week's archive logs on-disk. [so ... if you backup the Inactive tablespaces only once a month, you need the archive logs -- either on disk or from tape -- going back to one month]. Hemant K Chitale Principal DBA Chartered Semiconductor Manufacturing Ltd O'Neill, Sean [EMAIL PROTECTED] 10/01/2002 08:05 PM Sent by: [EMAIL PROTECTED] Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: (bcc: CHITALE Hemant Krishnarao/Prin DBA/CSM/ST Group) Subject: Recovery scenario query We perform disk-to-disk offline backups on a nighlty basis. Database is running in archived log mode. Due to space contraints (don't ask =:-[ ) we are currently forced to backup only some of the data files. The data files excluded belong to specific schema owners and are not being updated, or so I'm informed =:-0. I'm trying to get my head around what the recovery implications are if some of the data files not backed up have being updated and a recovery is required?. I expect it depends on what the recovery scenario is. So whats worst case scenario and what would my options, if any be?. Oracle 7.3.3, 8.0.5, 8.1.7 NT4, W2K - Se¨¢n O' Neill Organon (Ireland) Ltd. [subscribed: digest mode] This message, including attached files, may contain confidential information and is intended only for the use by the individual and/or the entity to which it is addressed. Any unauthorized use, dissemination of, or copying of the information contained herein is not allowed and may lead to irreparable harm and damage for which you may be held liable. If you receive this message in error or if it is intended for someone else please notify the sender by returning this e-mail immediately and delete the message. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: O'Neill, Sean 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). åy«±ç ê~'jS Ä,PÛiÿü0ÂÚ}ª¢`.¶+ Ñ é×!Ö¥yÈZ®×«yÛ'(V +r5ëp¢¹z»âqëçÎwó9ÔPó9ßÎtçT8'è®xæåÂ'µêçzÖqë,üÆ¢)à.+-±:Ã*.®Ç¥}úèØb²f¢)à+-±éÝjq +j)fzËëh.+-êî}«\Ü¢ièµá $ì¥éex(|¸¬´k«¹©Ý{azg¬±¨àØw%¹×)Þríj)â +I@ND º+¶§jg¨~f¢)à+-Ê°j{m¡·«zj/y×ë¢f(ºf²j[(±éݶ³Ü¢i×è®az¸§~æjبX¤z˱Êân)à
RE: US7ASCII, UTF8, characters sets, conversions.....agghhhhHH!!!
Look at 1. Note 139654.1 Oracle Applications Release 11i with UTF8 FAQ 2. Note 124721.1 Migrating an Application Installation to a new character-set [UTF8] 3. Note 134375.1 Using UTF8 Character Set with Applications Release 11i Even if you are not running Oracle Apps, I suggest you read these notes. [I haven't done a conversion -- I am running US7ASCII and WE8ISO8859P1 databases ony :( ] Hemant K Chitale Principal DBA Chartered Semiconductor Manufacturing Ltd [EMAIL PROTECTED] 10/01/2002 10:05 PM Sent by: [EMAIL PROTECTED] Chris, We have started using UTF8 on our new databases as a standard. All of our old, existing databases use US7ASCII. We need to convert a couple of existing databases such as our 200Gig data warehouse from US7ASCII to UTF8. I am concerned about conversion problems. I asked a few weeks ago if anyone had successfully converted from US7ASCII to UTF8 but got no response. I've searched on Metalink for the topic and didn't find much. If you get any responses, could you forward them on to me or post to the list. Thanks much, Cherie Machler Oracle DBA Gelco Information Network Grabowy, Chris To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cgrabowy@fcg. cc: com Subject: RE: US7ASCII, UTF8, characters sets, Sent by: conversions.aggHH!!! [EMAIL PROTECTED] om 01/10/02 07:35 AM Please respond to ORACLE-L Ok, so to get a better feel for what's going on, is everyone still using US7ASCII?? Have sites started switching over to UTF8?? Have there been any conversion problems?? Do the websites(like Amazon, Yahoo, BN, etc) that have an Oracle backend enforce UTF8 as a standard, so that they can store any type of character that a user enters??? -Original Message- Sent: Tuesday, January 08, 2002 4:05 PM To: Multiple recipients of list ORACLE-L So we stumbled upon the white paper... WHY WE ARE MOVING OUR DATABASES TO THE UTF8 CHARACTER SET By David F. Pennington, GlaxoSmithKline This white paper raises a potential issue that DBAs might need to be aware of. Basically, it has to do with certain characters not storing correctly in the database because of different character sets being used between the database, client and how the user enters data into the application. Has this issue been raised on the list before? Basically, were wondering how other DBAs/sites are handling/approaching this issue. Many TIA!! Chris I believe the below link will get you to the white paper on the IOUG website. http://www.ioug.org/ioug_s/REPOSITORY_PKG.REPOSITORY_BUILD_VIEW_FORM?v_tech_ content_phy_Id=5310v_trx=784353 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Grabowy, Chris 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: Grabowy, Chris 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: 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: INET: [EMAIL PROTECTED] Fat City Network Services--
RE: Import Characterset problem
Nirmal, Don't try updating SYS.PROPS$. 1. It is not supported. 2. If you make a mistake (an extra space, a mis-spelled value) you will NOT be able to start the database at all. 3. I seriously doubt you can convert US7ASCII to AR8MSWIN1256. 4. The ALTER DATABASE CONVERT CHARACTERSET would also not work. Log a TAR with Oracle Support. You would most probably have to recreate your US7ASCII database as an AR8MSWIN1256 Database. Hemant K Chitale Principal DBA Chartered Semiconductor Manufacturing Ltd Ahmed Gholam Hussain [EMAIL PROTECTED]08/01/2002 02:30 PM Sent by: [EMAIL PROTECTED] Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: (bcc: CHITALE Hemant Krishnarao/Prin DBA/CSM/ST Group) Subject: RE: Import Characterset problem Hi Nirmal, What u have to do is a normal update statement on PROPS$...I remember doing that while there was a need to enter Arabic characters on our DB Be careful not to enter any spaces between the character set value AR8MSWIN1256 ..It may crash your target DB.. I do not recall another way of doing that HTH Regards Gholam -Original Message- From: Nirmal Kumar Muthu Kumaran [SMTP:[EMAIL PROTECTED]] Sent: Tuesday, January 08, 2002 9:20 AM To: Multiple recipients of list ORACLE-L Subject: RE: Import Characterset problem Hi gholam, Thanks for ur help, by the way let me know how to change the character set of DB using props$? Just you want me to update this props$ for nls_characterset with the new value?... is it recommanded one?... The exp dump file is of character set AR8MSWIN1256, now the target db is with characterset US7ASCII. Thanks. Nirmal. -Original Message- From: Ahmed Gholam Hussain [SMTP:[EMAIL PROTECTED]] Sent: 23 ÔæÇá, 1422 10:15 AM To: Multiple recipients of list ORACLE-L Subject: RE: Import Characterset problem Hi Nirmal , While importing u have to consider that the source and target databases character sets should be matching U can change the character set of your target database using props$ data dictionary view HTH Gholam -Original Message- From: Nirmal Kumar Muthu Kumaran [SMTP:[EMAIL PROTECTED]] Sent: Monday, January 07, 2002 10:05 AM To: Multiple recipients of list ORACLE-L Subject: Import Characterset problem Helo gurus, I exported on schema from the old datatabase and then i created new database in my PC. Now i want to import it, but it's saying that characterset is not match error. How can i rectify it Thanks. Nirmal. File: ATT18366.ATT -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ahmed Gholam Hussain 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). File: ATT19805.ATT -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ahmed Gholam Hussain 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: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists
Re: A Simple Rollback Segment Question
Personally I never create one. First thing I do though is create the rbs tablespace with a couple of rollback seg's before all other create scripts. Yes, but in the pre-historic days, you couldn't create the rbs tablespace without first creating a non-system rollback segment in the system tablespace ! Hemant K Chitale Principal DBA Chartered Semiconductor Manufacturing Ltd [EMAIL PROTECTED] 08/01/2002 07:10 PM Sent by: [EMAIL PROTECTED] Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: (bcc: CHITALE Hemant Krishnarao/Prin DBA/CSM/ST Group) Subject: Re: A Simple Rollback Segment Question Hi AFAIK this is a prehistoric requirement (Pre 7.3 I believe, No offense meant :-)). Oracle needed it to create the tablespaces etc. Since 7.3 this is no longer required (anyone know exactly when?). Personally I never create one. First thing I do though is create the rbs tablespace with a couple of rollback seg's before all other create scripts. Jack Naveen Nahata [EMAIL PROTECTED]@fatcity.com on 08-01-2002 10:50:21 Please respond to [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc:(bcc: Jack van Zanen/nlzanen1/External/MEY/NL) Hello people, This one is from Oracle Manual: In general, after database creation, you should create at least one additional rollback segment in the SYSTEM tablespace. I can understand that you should create one additional rollback segment after database creation b'coz otherwise oracle will use the SYSTEM rollback segment and this may lead to fragmentation in the SYSTEM tablespace and also a performance degradation. But why is one additional rollback segment needed in SYSTEM TABLESPACE? TIA \\\|/// \\ - - // ( @ @ ) +--oOOo-(_)-oOOo--+ |Naveen Nahata | Off: Churhcill SSI | 89 SVR Complex | Hosur Road | Madiwala,Bangalore - 560068 | INDIA. | Work: (9180) 5535005 |! n! ! bsp; Ext - 111 | Home: (9180) 6685754 | E-mail: [EMAIL PROTECTED] +-Oooo---+ oooO( ) ( )) / \ ((_/ \_) Do You Yahoo!? Send FREE video emails in Yahoo! Mail. === De informatie verzonden met dit E-mail bericht is uitsluitend bestemd voor de geadresseerde. Gebruik van deze informatie door anderen dan de geadresseerde is verboden. Openbaarmaking, vermenigvuldiging, verspreiding en/of verstrekking van deze informatie aan derden is niet toegestaan. Ernst Young staat niet in voor de juiste en volledige overbrenging van de inhoud van een verzonden E-mail, noch voor tijdige ontvangst daarvan. === The information contained in this communication is confidential and may be legally privileged. It is intended solely for the use of the individual or entity to whom it is addressed and others authorised to receive it. If you are not the intended recipient you are hereby notified that any disclosure, copying, distribution or taking any action in reliance on the contents of this information is strictly prohibited and may be unlawful. Ernst Young is neither liable for the proper and complete transmission of the information contained in this communication nor for any delay in its receipt. === -- 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: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
Re: exp error
You cannot use the exp program of a higher RDBMS version against a lower database. [You can do it the other way round, exp from a lower version against a higher database, provided you have run the appropriate catexp?.sql script]. See Note 132904.1 on MetaLink. Hemant K Chitale Principal DBA Chartered Semiconductor Manufacturing Ltd RAYMOND [EMAIL PROTECTED] 08/01/2002 12:20 PM Sent by: [EMAIL PROTECTED] Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: (bcc: CHITALE Hemant Krishnarao/Prin DBA/CSM/ST Group) Subject: exp error I run exp from my local db client 8.1.7 to exp an oracle 8.1.6 db USERS to my database... but this error come out ?? I just issue an command : exp sks/sks@prod1 .. ..but this error message come out for all the tables I going to export... I try in the prod1 database workstation and issue the same command..exp [EMAIL PROTECTED] go smooth .no error come out ?? Why is this happen ?? EXP-8: ORACLE error 904 encountered ORA-00904: invalid column name . . exporting table AD01MAST -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: RAYMOND 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: 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: Why metastink {or fetidstink !} ??
I am currently satisfied with MetaLink 2.0 -- I use it generally to search for information. I hope the upgrade with Oracle's own CRM products would not be as non-working as the first few maintenance releases of 11i were supposed to be. Wonder what feedback prompted Oracle to decide upgrade (or rewrite !!) MetaLink -- and why we cannot provide ratings in the upgraded version. Hemant K Chitale Principal DBA Chartered Semiconductor Manufacturing Ltd Orr, Steve [EMAIL PROTECTED] 04/01/2002 11:35 PM Sent by: [EMAIL PROTECTED] Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: (bcc: CHITALE Hemant Krishnarao/Prin DBA/CSM/ST Group) Subject: RE: Why metastink {or fetidstink !} ?? Well soon you'll have to make up a new term because Oracle is re-writing it and renaming it to something like eSupport and TAR's will become SR's. Supposedly Oracle is going to use their own CRM product for support. I asked if we the end users will be able to rate the answers and the analysts like other CRM software does and was told that that feature wasn't planned until the second release of the product. :-( Still it's comforting to know that we will be able to rate or berate the support analysts (not Anita) in about 1-2+ years. Steve Orr -Original Message- Sent: Thursday, January 03, 2002 9:25 PM To: Multiple recipients of list ORACLE-L feel free to use the correct term, and i'll feel free to use metalstink :) joe [EMAIL PROTECTED] wrote: Why do a large number of postings refer to MetaLink as MetaStink (or fetidstink) ? The only problem I have with MetaLink is that patch downloads fail mid-way [yes, this is a stink problem particularly when I have downtime on the server but don't have a patch ready !]. Let's be gracious and use the proper name MetaLink. [yeah, Larry could be God Larry or King Larry]. Comments / brickbats [/boquets] anyone ? Hemant K Chitale Principal DBA Chartered Semiconductor Manufacturing Ltd -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Orr, Steve 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: 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).
Why metastink {or fetidstink !} ??
Why do a large number of postings refer to MetaLink as MetaStink (or fetidstink) ? The only problem I have with MetaLink is that patch downloads fail mid-way [yes, this is a stink problem particularly when I have downtime on the server but don't have a patch ready !]. Let's be gracious and use the proper name MetaLink. [yeah, Larry could be God Larry or King Larry]. Comments / brickbats [/boquets] anyone ? Hemant K Chitale Principal DBA Chartered Semiconductor Manufacturing Ltd -- 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).
RE: oracle not available ???
A Cold Backup is always a Full backup --- all datafiles (and, highly recommended, all control files and redo log files). Did you shutdown the database twice but only backup 6 files each time ? How many log switches occurred between the first backup and the second ? If the transactions are still in the online redo logs, you might try a recovery. Hemant K Chitale Principal DBA Chartered Semiconductor Manufacturing Ltd Nagaraj Panyam [EMAIL PROTECTED] 02/01/2002 03:55 AM Sent by: [EMAIL PROTECTED] Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: (bcc: CHITALE Hemant Krishnarao/Prin DBA/CSM/ST Group) Subject: RE: oracle not available ??? Hi list I have a database recovery problem. The scenario is like this a) My database is not in archive mode. b) I have taken a cold back up on two different times. 6 data files in the morning and 6 in the evening. In between the database was started and again Was shutdown before taking back up in the evening. I want to recover the database completely but I don't mind losing the data of the period between the back ups. Can any one have solution. Thanks in advance NAGARAJ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Nagaraj Panyam 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: 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: Exp problem
If your database is 8.1.5, you need to use the 8.1.5 exp client. Run exp from an 8.1.5 ORACLE_HOME (you could use the same ORACLE_HOME as the database itself). Hemant K Chitale Principal DBA Chartered Semiconductor Manufacturing Ltd Raymond [EMAIL PROTECTED] 24/12/2001 10:20 AM Sent by: [EMAIL PROTECTED] Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: (bcc: CHITALE Hemant Krishnarao/Prin DBA/CSM/ST Group) Subject: Re: Exp problem EXP-00037- export views not compatible with database version .. ? How can I resolve it ? Currently I'm using Oracle 8.1.7...the database I wanted to exp is on 8.1.5... I try to trigger the compatiable parameter in the init.ora to 8.1.1.but still don't work ..??? Any advice ? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Raymond 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: 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: Help
The Patch for 1967363 on 8.1.7.2/8.1.7.2.1 has been out for some time now. (the patch will not be released for 8.1.7.1 or 8.1.7.0) I do have an 8.1.7.1 instance running and am waiting for scheduled downtime to upgrade to 8.1.7.2.1 + 1967363 on Tru64. This instance is only a test environment and, yet, I see high wait-time ratios for cache buffer chains latch in the PerfStat reports. (On Solaris it is only 8.1.7.2 -- 8.1.7.2.1 was released only on certain platforms to replace a defective 8.1.7.2 which would not upgrade 8.1.7.1 to 8.1.7.2). Hemant K Chitale Principal DBA Chartered Semiconductor Manufacturing Ltd Sherman, Paul R. [EMAIL PROTECTED] 21/12/2001 01:55 AM Sent by: [EMAIL PROTECTED] FYI Thank you, Paul Sherman DBA voice - 781-501-4143 (office) fax- 781-278-8341 (office) email - [EMAIL PROTECTED] -Original Message- Sent: Thursday, December 20, 2001 11:22 AM To: '[EMAIL PROTECTED]' Scott, The cache buffer chains issue, I'm pretty sure that I've seen that on some of our 8.1.6.2 and 8.1.6.3 systems. But I do not recall if the issue was damaging or not. So, 8.1.7.2.1 does not have this resolved, and I need to go to 8.1.7.3 ? Thank you, Paul Sherman DBA voice - 781-501-4143 (office) fax- 781-278-8341 (office) email - [EMAIL PROTECTED] -Original Message- Sent: Wednesday, December 19, 2001 10:25 PM To: Multiple recipients of list ORACLE-L I heard that! We got bit on 8.1.7.1 by a 'Cache Buffer Chains' latch contention bug (bug 1967363) that is not fixed until 8.1.7.3 or 9.0.2. The releases are supposed to be out in January, IIRC. --Scott - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, December 19, 2001 10:26 AM I am still waiting for Oracle 8.1.7.3 final release for 8.1. Then start looking at 9.1, when it comes out. [EMAIL PROTECTED] 12/19/01 10:35AM Hello, FYI, my understanding is that 8.1.7.2.0 has problems, and that 8.1.7.2.1 is the way to go. Thank you, Paul Sherman DBA voice - 781-501-4143 (office) fax- 781-278-8341 (office) email - [EMAIL PROTECTED] -Original Message- Sent: Tuesday, December 18, 2001 10:40 PM To: Multiple recipients of list ORACLE-L If you are running 8.1.7.1, it has memory leak problem. Need to upgrade to 8.1.7.2.0. -Original Message- To: Multiple recipients of list ORACLE-L Sent: 12/18/01 5:50 PM Your SGA has become fragmented. You would not per chance be running 8.1.7 would you? If so I would go and do some searching on Metalink. I see an upgrade in your future. You could try flushing the SGA but if its what I think it is it won't help. A restart will for a while. -Original Message- Sent: Tuesday, December 18, 2001 4:30 PM To: Multiple recipients of list ORACLE-L Any idea what this means ? Error accessing package DBMS_APPLICATION_INFO ERROR: ORA-04031: unable to allocate 4096 bytes of shared memory (shared pool,BEGIN DBMS_APPLICATION_INFO,PL/SQL MPCODE,BAMIMA: Bam Buffer) Begin * ERROR at line 1: ORA-04031: unable to allocate 4096 bytes of shared memory (shared pool,OLWEAREPORTS,PL/SQL MPCODE,BAMIMA: Bam Buffer) ORA-06508: PL/SQL: could not find program unit being called ORA-06512: at line 3 PasswordNotification12172001.txt: No such file or directory PasswordNotification12172001.err: No such file or directory Hamid Alavi Office 818 737-0526 Cell818 402-1987 The information contained in this message and any attachments is intended only for the use of the individual or entity to which it is addressed, and may contain information that is PRIVILEGED, CONFIDENTIAL and exempt from disclosure under applicable law. If you have received this message in error, you are prohibited from copying, distributing, or using the information. Please contact the sender immediately by return e-mail and delete the original message from your system. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hamid Alavi 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: Kimberly Smith 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
Re: Revert from 8.1.6 to 8.0.5
Check out the Chapter on downgrading in the 8i Migration manual The 8.1.6 manual pages are still online at http://otn.oracle.com/doc/oracle8i_816/server.816/a76957/migdowng.htm#15124 You need to remove whatever 8i features you may have implemented that are not available in 8.0.5 Depending on what changes you may have made, you may or may not be able to downgrade. Try the downgrade on reviewing the doc. It would be faster than rebuilding the database (unless the upgrade from 8.0.5 to 8.1.6 was itself a rebuild !!). Hemant K Chitale Principal DBA Chartered Semiconductor Manufacturing Ltd Ed [EMAIL PROTECTED] 19/12/2001 05:30 AM Sent by: [EMAIL PROTECTED] Looks like we have to revert an 8.1.6 database that was upgraded over the weekend back to 8.0.5, but we need to export/import so we don't lose data from the last 2 days. Anything I need to know? The plan is to export using the 8.0.5 export utility before importing back into 8.0.5. Does this make sense? Thanks, Ed -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ed INET: [EMAIL PROTECTED] -- 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).
RE: hard disk configuration question
Resending the email (it bounced back with a locking problem) at fatcity. Hemant K Chitale Principal DBA Chartered Semiconductor Manufacturing Ltd - Forwarded by CHITALE Hemant Krishnarao/Prin DBA/CSM/ST Group on 19/12/2001 11:48 AM - CHITALE Hemant Krishnarao/Prin DBA/CSM/ST Group19/12/2001 11:07 AM Where are you putting the RDBMS and application code ? Best mirror the two internal disks and put the RDBMS and application code there. You could also consider putting your Redo Logs --- particularly if you have a RAID-5 array, it would definitely be better to put your Redo Logs on mirrored disks seperate from the database files. How naive and honest the engineer was Hemant K Chitale Principal DBA Chartered Semiconductor Manufacturing Ltd Steve McClure [EMAIL PROTECTED] 19/12/2001 10:25 AM Sent by: [EMAIL PROTECTED] Well we had our meeting with the Hitachi Sales critter, and engineer. I discovered that they were trying to push a 5 disk raid array and one hot spare at us, because my IT director was really trying to squeeze them on the price of my 10 18GB disk configuration. After the sales guy and engineer went on about how their 4 separate IO paths would make our raid 5 perform as well as any mirrored pair, I got to ask a few questions. Well it turns out that their RAID performs that well with extra large database block sizes. When I pointed out that we currently have a block size of 2k(I didn't build the db), and would be rebuilding the database on the new platform with 8k blocks, he said that with a small block size like 8k you will really get the best performance out of mirrors or a 1+0. I am sure the sales guy kicked him under the table ;-). The end result is this. We will probably go with the 6 36 GB DISKS. It flat out comes down to the cost of the whole system is just a little over budget, and the drives are where the adjustment gets made. I suspect that I will have much less trouble getting a few extra disks once the system is in the building. I may also mess with things a bit and configure a 1+0 and a mirrored pair. So after that discussion, and all your helpful input I still have two questions. First what use are the two internal drives that aren't in the disk array? Someone suggested to WRT them, and I am not familiar with that term. Again I am not sure I want to mirror them, and if they aren't redundant how useful can they really be? Second. If an 8k database block size is tiny, what is a large database block size? 8k is as large as I can go without raw file systems, isn't it? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Steve McClure INET: [EMAIL PROTECTED] -- 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).
Re: Different clocks for different instances.
Resending. Hemant K Chitale Principal DBA Chartered Semiconductor Manufacturing Ltd - Forwarded by CHITALE Hemant Krishnarao/Prin DBA/CSM/ST Group on 19/12/2001 11:49 AM - Change the TZ variable in the Unix environment and restart the instance. My guess is that it should work. Hemant K Chitale Principal DBA Chartered Semiconductor Manufacturing Ltd Kevin Pollard [EMAIL PROTECTED] 19/12/2001 10:50 AM Sent by: [EMAIL PROTECTED] Gooday Oraclers, is it possible to have different instances, on the same dB server, operating with different clocks - ie different date/times? Environment: Compaq-Digital Tru64 Unix, Oracle 8.0.6, DS20 --- Kevin Pollard | PODBA (Pretend Oracle DBA) mailto:[EMAIL PROTECTED] | Administrative Systems Unit Phone:+61 (02) 6620 3969 | Southern Cross University FAX:+61 (02) 6626 9122 | P.O. Box 157 Room: R1-40a | Lismore NSW 2480, Australia http://staff.scu.edu.au/asu/index.html -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kevin Pollard INET: [EMAIL PROTECTED] -- 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).
Oracle 8.1.7 desupport date
Oracle has announced ECS ends on 31-December-2003 for 8.1.7 I had expected 8.1.7 to continue to mid-2004 (it was released early/mid 2000 ? and is the terminal 8i release). Is there any possibility that the ECS date would be extended ? We are just beginning to upgrade a few 7.3.4 and many 8.0.5/8.1.5/8.1.6 databases to 8.1.7 and are not yet looking at 9.0.1 Hemant -- 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).
Oracle 8.1.7 desupport date -- announced as Dec 2003
Oracle has announced ECS ends on 31-December-2003 for 8.1.7 I had expected 8.1.7 to continue to mid-2004 (it was released early/mid 2000 ? and is the terminal 8i release). Is there any possibility that the ECS date would be extended ? What's your feel / experience with previous desupport notices ? We are just beginning to upgrade a few 7.3.4 and many 8.0.5/8.1.5/8.1.6 databases to 8.1.7 and are not yet looking at 9.0.1 Hemant -- 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).
Re: how delete myfile* in unix
Use the \ character. rm myfile\* See : apptest cat myfile* here is the data in the file ! apptest ls -l my* -rw-r--r-- 1 apptest system31 Dec 13 12:08 myfile* apptest cat myfile1 this is a good file apptest ls -l my* -rw-r--r-- 1 apptest system31 Dec 13 12:08 myfile* -rw-r--r-- 1 apptest system20 Dec 13 12:08 myfile1 apptest rm myfile\* apptest ls -l my* -rw-r--r-- 1 apptest system20 Dec 13 12:08 myfile1 apptest Hemant Sinard Xing [EMAIL PROTECTED]13/12/2001 10:30 AM Sent by: [EMAIL PROTECTED] Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: (bcc: CHITALE Hemant Krishnarao/Prin DBA/CSM/ST Group) Subject: how delete myfile* in unix Hi, I accitentaly create a file with * $ myfile* $ ls myfile1 myfile2 myfile3 myfile* how to delete myfile* without delete the rest of the file * here is not a wildcard but system see this as a wildcard Thank you -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sinard Xing 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: 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: Serial# changes when rolling back
Check this Oracle Note : Doc ID: Note:1020545.102 Subject: ORA-00026: CANNOT KILL SESSION; SERIAL# KEEPS CHANGING Type: PROBLEM Status: PUBLISHED Content Type: TEXT/PLAIN Creation Date: 23-NOV-1999 Last Revision Date: 24-AUG-2000 Problem Description --- You have killed a process at the operating system level that was running a long-running transaction. Now, you are trying to issue the command: alter system kill session 'sid, serial#'; To kill the associated Oracle session, but you can't kill it. You may receive the following error: ORA-00026: missing or
Re: Serial# changes when rolling back
One explanation I had heard for the combination of Sid+Serial# goes something like this ... say you identify a particular session to monitor ... you then decide to kill it. However, it could so happen that that user logged out between the time you decided to kill the session and the time you actually killed the session (even if you have scripted the kill command). When a user logs out, the Sid is available to the next user who logs in. Since another user might be holding the same Sid at the time you come around to kill the Sid, you might actually kill the wrong user-session. To avoid this, the next user, getting the same Sid gets a different Serial# and your kill must be on Sid+Serial# together. That still does not explain why pmon increments the Serial#, though. Hemant Deepak Thapliyal [EMAIL PROTECTED] 12/12/2001 06:26 AM Sent by: [EMAIL PROTECTED] Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: (bcc: CHITALE Hemant Krishnarao/Prin DBA/CSM/ST Group) Subject: Re: Serial# changes when rolling back yeah i did read this thread but still wonder why oracle needs to use serial# column at all. Does the SID not gaurentee uniqueness for a session ... damn the name says so atleast (session identifier).. or maybe they just coded it like that and make some use of the serial # Deepak --- [EMAIL PROTECTED] wrote: Check this Oracle Note : Doc ID: Note:1020545.102 Subject: ORA-00026: CANNOT KILL SESSION; SERIAL# KEEPS CHANGING Type: PROBLEM Status: PUBLISHED Content Type: TEXT/PLAIN Creation Date: 23-NOV-1999 Last Revision Date: 24-AUG-2000 Problem Description --- You have killed a process at the operating system level that was running a long-running transaction. Now, you are trying to issue the command: alter system kill session 'sid, serial#'; To kill the associated Oracle session, but you can't kill it. You may receive the following error: ORA-00026: missing or invalid session id Cause: The session ID string specified in the ALTER SYSTEM KILL SESSION command was invalid, or no string was specified. Action: Retry the command with a valid session ID. In v$session, you notice that the serial# for the session keeps changing. Also, pmon may be creating a trace file that keeps growing. Solution Description It is best to let pmon roll back the changes. If you shutdown at this point, this work will still have to be done at the next startup. pmon is rolling back changes and will let the session die when it is finished. To verify that work is being done, select used_urec from v$transaction. If the value for this column keeps going down, then work is being done. When used_urec reaches zero, then the rollback will be done, and the session will die. With Oracle8, you can list dead transactions by issuing the following query: select * from x$ktuxe where ktuxecfl='DEAD'; Explanation --- pmon has control of the session and is rolling back all of the work that has been done so far. Search Words
Re: Set Time Zone
Can't , not in 8i. 9i has introduced a TIMEZONE datatype where time can be reported offset by the UTC+/- offset. You'd have to build the logic in your application to increment/decrement the sysdate, depending on the user/client location (use a lookup table for location and timezone-offset) when fetching the sysdate. SYSDATE would always return the date on the server where the database instance is running. Hemant Mike T [EMAIL PROTECTED]12/12/2001 10:50 AM Sent by: [EMAIL PROTECTED] Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: (bcc: CHITALE Hemant Krishnarao/Prin DBA/CSM/ST Group) Subject: Set Time Zone Hi Gurus, How can I set up a time zone for each region that connect on SAME Database 8i Case: Database in NewYork. Clients in San Franciso, Paris .. When they use select sysdate from dual ; ( on Client or server side ) They should see their local time .?? Thanks in advance Tran -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mike T 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). [This e-mail is confidential and may also be privileged. If you are not the intended recipient, please delete it and notify us immediately; you should not copy or use it for any purpose, nor disclose its contents to any other person. Thank you.] -- 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).
Re: Upgrade OS from Unix 2.6 to Unix 2.8 for Oracle HRMS Applications
Quoting from the Oracle Applications Installation Update Notes Release 11i for Sun SPARC Solaris : This release of Oracle Applications is compatible with both Solaris 2.6 and Solaris 2.8 operating system software. If you are using Solaris 2.8, we recommend that after you run Rapid Install you relink all Oracle Applications executables by choosing this option from the Maintain Applications Files menu in AD Administration. The Oracle Database can certainly run as is even after you upgrade from Solaris 2.6 to 2.8. However, it is recommended that you relink the Database, Forms Server and Reports Server as well. Hemant CHAN Chor Ling Catherine (CSC) [EMAIL PROTECTED]10/12/2001 05:20 PM Sent by: [EMAIL PROTECTED] Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: (bcc: CHITALE Hemant Krishnarao/Prin DBA/CSM/ST Group) Subject: Upgrade OS from Unix 2.6 to Unix 2.8 for Oracle HRMS Applications Hi Gurus, I need to update the OS from Unix 2.6 to 2.8 on my database and form servers. We are running Oracle HRMS Applications 11I Version 11.5.1. Has anyone done it before ? Any advice ? Please help. Thanks. Regds, New Bee -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: CHAN Chor Ling Catherine (CSC) 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). [This e-mail is confidential and may also be privileged. If you are not the intended recipient, please delete it and notify us immediately; you should not copy or use it for any purpose, nor disclose its contents to any other person. Thank you.] -- 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).
Re: buffer busy wait latch free ( cache buffer chain )
I could find bug#1467575 which relates to Parallel DML hanging on executing an ALTER SYSTEM FLUSH SHARED_POOL. However, as per the README of the 8.1.7.2 PatchSet, this *is* fixed in 8.1.7.2 Did you log a TAR with Oracle Support for this situation where you could only fix it by restarting the database ? Hemant Edward Shevtsov [EMAIL PROTECTED] 06/12/2001 05:25 AM Sent by: [EMAIL PROTECTED] Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: (bcc: CHITALE Hemant Krishnarao/Prin DBA/CSM/ST Group) Subject: Re: buffer busy wait latch free ( cache buffer chain ) Hi, it seems we have similar situation today. Our production db hangs suddenly. We couldn't even login into the db. Before aborting oracle we found a process like svrmgrl @/tmp/sql. The body includes single command 'alter system flush shared_pool'. It seems it was generated by db agent according to our job timetable in the OEM. We recently patched db up to 8.1.7.2 (Linux) in order to get rid of memory leak in the shared pool... Regards, Ed One way I can say there are bunch of patches which has to be applied on 8.1.7.2,We had nightmares out when we migrated to 8.1.7.2,There are lot of work arounds which you will have to get from oracle for library cache,cache buffer chains,ora 7445 errors etc etc etc.. We had an issue like if I give the command alter system flush shared pool the system got hung and all you can see is library cache pin and latch free waits and only option was to bring the database was bring it down. God I can say they have royally messed up in 8.1.7.2. From: [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: buffer busy wait latch free ( cache buffer chain ) Date: Tue, 04 Dec 2001 23:05:19 -0800 Your statement there are several bugs relating to waiting for latch-free on cache-buffer-chains, and the possibility of the instance hanging. has me nervous. I am aware of 1967363 and have obtained the standalone patch for this to be applied on top of 8.1.7.2 I have seen significant wait times for cache buffer chains latch in my 8.1.7.1 test environment and am waiting for the environment to be released to me so that I can upgrade it to 8.1.7.2.1+1967363 (our production is still 8.0.5 !!). What other bugs are you talking off ? Hemant Binley Lim [EMAIL PROTECTED]05/12/2001 06:10 AM Sent by: [EMAIL PROTECTED] Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: (bcc: CHITALE Hemant Krishnarao/Prin DBA/CSM/ST Group) Subject: RE: buffer busy wait latch free ( cache buffer chain ) If on 8.1.7, there are several bugs relating to waiting for latch-free on cache-buffer-chains, and the possibility of the instance hanging. One is 1967363, and at least two others are still open after applying that patch. Changing cache buffer latches/buckets is not mentioned in those bugs, and since they are underscored, I would approach with caution. [EMAIL PROTECTED] 12/05/01 08:30AM Vivek: To combat the latch free- cache buffer chain problem, I would first check in v$latch_children if the contention is even across all cache buffer chain latches. If this is the case case (most of the time it is not) , I would add more cache buffer latches. If this is not the case, as ARUN suggested, I would find out which buffers are hot and I would investigate WHY they are hot. (Ussually because of a bad SQL-- you should fix them! ) According to BBW problem, try to identify the segment involved and the cause (p1=file , p2=block and p3=cause from a 10046 trace) and then according to p3 there are some changes that can be done. HTH Diego - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, December 04, 2001 9:35 AM What are u seeing the buffer busy waits on is it for the read intensivity and latch free is showing that there are hot blocks why dont you find out the hot blocks and find what can be done about it From: VIVEK_SHARMA [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: buffer busy wait latch free ( cache buffer chain
RE: simple sql problem
If you are running it on Unix, you must escape the $ in v$instance. thus, you would do echo select * from v\$instance; | sqlplus system/manager Note the \ key before the $. Hemant Viraj Luthra [EMAIL PROTECTED] 04/12/2001 02:50 PM Sent by: [EMAIL PROTECTED] Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: (bcc: CHITALE Hemant Krishnarao/Prin DBA/CSM/ST Group) Subject: RE: simple sql problem Even using like this:- echo select * from v$instance; | sqlplus system/manager gives me the error :- SQL select * from v * ERROR at line 1: ORA-00942: table or view does not exist Though I can do the same sql statement from inside sqlplus with ease, so why does it give table or view does not exist? I am confused .. rgds, -- On Mon, 03 Dec 2001 21:50:17 Ross Collado wrote: I don't believe SQLPlus will let you run a SQL statement in the command line itself. As you can see in Usage:, it doesn't have an option for this. However, if you insist on running SQL statements in the command line itself, you can probably do something like (only in Unix): sqlplus -s scott/tiger ! select * from emp; ! or save your select * from emp; to a sql file and do : sqlplus -s scott/tiger @myfile.sql hth Ross -Original Message- From: Viraj Luthra [mailto:[EMAIL PROTECTED]] Sent: Tuesday, 4 December 2001 16:11 To: Multiple recipients of list ORACLE-L Subject: simple sql problem Hello all, Why cannot I do :- sqlplus -s scott/tiger select * from emp; or sqlplus -s scott/tiger select * from emp; Both the cases I get :- Usage: SQLPLUS [option] [user[/password] [@host]] [@startfile [parm1] [parm2] ...] where option ::= { -s | -? } -s for silent mode and -? to obtain version number What is wrong above? I need to run the query from command line. How do I modify this :- sqlplus -s scott/tiger select * from emp; Rgds, -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Viraj Luthra 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: Ross Collado 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: Viraj Luthra 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: 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
RE: buffer busy wait latch free ( cache buffer chain )
Your statement there are several bugs relating to waiting for latch-free on cache-buffer-chains, and the possibility of the instance hanging. has me nervous. I am aware of 1967363 and have obtained the standalone patch for this to be applied on top of 8.1.7.2 I have seen significant wait times for cache buffer chains latch in my 8.1.7.1 test environment and am waiting for the environment to be released to me so that I can upgrade it to 8.1.7.2.1+1967363 (our production is still 8.0.5 !!). What other bugs are you talking off ? Hemant Binley Lim [EMAIL PROTECTED]05/12/2001 06:10 AM Sent by: [EMAIL PROTECTED] Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: (bcc: CHITALE Hemant Krishnarao/Prin DBA/CSM/ST Group) Subject: RE: buffer busy wait latch free ( cache buffer chain ) If on 8.1.7, there are several bugs relating to waiting for latch-free on cache-buffer-chains, and the possibility of the instance hanging. One is 1967363, and at least two others are still open after applying that patch. Changing cache buffer latches/buckets is not mentioned in those bugs, and since they are underscored, I would approach with caution. [EMAIL PROTECTED] 12/05/01 08:30AM Vivek: To combat the latch free- cache buffer chain problem, I would first check in v$latch_children if the contention is even across all cache buffer chain latches. If this is the case case (most of the time it is not) , I would add more cache buffer latches. If this is not the case, as ARUN suggested, I would find out which buffers are hot and I would investigate WHY they are hot. (Ussually because of a bad SQL-- you should fix them! ) According to BBW problem, try to identify the segment involved and the cause (p1=file , p2=block and p3=cause from a 10046 trace) and then according to p3 there are some changes that can be done. HTH Diego - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, December 04, 2001 9:35 AM What are u seeing the buffer busy waits on is it for the read intensivity and latch free is showing that there are hot blocks why dont you find out the hot blocks and find what can be done about it From: VIVEK_SHARMA [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: buffer busy wait latch free ( cache buffer chain ) Date: Tue, 04 Dec 2001 01:55:19 -0800 In report.txt we are getting the wait buffer busy wait _ wait on latch free for cache buffer chain Could an excessively Large db_block_buffer cause this ? NOTE - Transaction OLTP in nature NOTE - freelists is set = 2* cpu_count Any oher advice ? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Binley Lim 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: 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: simple sql problem
You can't have the SQL statements on the command line. You must put them in a script file (eg myscript.sql) and execute it with the @ sign. Thus, sqlplus -s scott/tiger @myscript[note the SPACE between the tiger and the @]. Hemant Viraj Luthra [EMAIL PROTECTED] 04/12/2001 01:10 PM Sent by: [EMAIL PROTECTED] Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: (bcc: CHITALE Hemant Krishnarao/Prin DBA/CSM/ST Group) Subject: simple sql problem Hello all, Why cannot I do :- sqlplus -s scott/tiger select * from emp; or sqlplus -s scott/tiger select * from emp; Both the cases I get :- Usage: SQLPLUS [option] [user[/password] [@host]] [@startfile [parm1] [parm2] ...] where option ::= { -s | -? } -s for silent mode and -? to obtain version number What is wrong above? I need to run the query from command line. How do I modify this :- sqlplus -s scott/tiger select * from emp; Rgds, -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Viraj Luthra 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). [This e-mail is confidential and may also be privileged. If you are not the intended recipient, please delete it and notify us immediately; you should not copy or use it for any purpose, nor disclose its contents to any other person. Thank you.] -- 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).
Oracle Portal Questions
A couple of questions for two alternative scenarios we are looking at : 1. One iAS f or Two Portal DBs with the same initial URL OR 2. Two iAS installs for two Portal DBs with the same initial URL We are looking at seperate Portal databases for the Employees Portal and the Customers Portal. To make them visible from the Internet, we would like to have the same initial URL. Has anyone attempted anything like this ? Is it doable ? Hemant -- 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).
RE: Has anyone heard of Mirror Accessible?
AFAIK, 9iDataGuard in the current release is only a Physical Standby database (not logical standby database). This is similar to 8i except for the fact that, if you ensure that you do a clean failover-and-failback (ie have the controlfiles and online redo log files available) you can actually switch to and from the standby. Never tried it and wouldn't try it till 9.0.2 (at the minimum) Hemant Miller, Jay [EMAIL PROTECTED]01/12/2001 05:45 AM Sent by: [EMAIL PROTECTED] Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: (bcc: CHITALE Hemant Krishnarao/Prin DBA/CSM/ST Group) Subject: RE: Has anyone heard of Mirror Accessible? Can anyone confirm this? I've been searching technet and metalink and can't turn up any details. -Original Message- Sent: Friday, November 30, 2001 3:01 PM To: Multiple recipients of list ORACLE-L Isn't that just in release 2 though? My understanding is that its not out yet. -Original Message- Sent: Friday, November 30, 2001 11:36 AM To: Multiple recipients of list ORACLE-L Ah, this sounds likely. And it might explain why they were keen on having us upgrade to 9i. That's the problem with receiving the request filtered through two additional levels of people. Jay Miller -Original Message- Sent: Friday, November 30, 2001 1:56 PM To: Multiple recipients of list ORACLE-L 9i has a new feature on standby databases that let's you run reports in read only while continuing the managed recovery. I think they call it a logical standby database. See the 9i DataGuard manual for more information. (I just happened to be looking into this lately). This might be what they are talking about. Best, Ed - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, November 30, 2001 12:05 PM Only thing I can think of off the top of my head is a standby database opened in read only mode. Its one of the purposes totted for that -Original Message- Sent: Friday, November 30, 2001 9:47 AM To: Multiple recipients of list ORACLE-L My CIO woes continue. My manager has been told by the CIO that Oracle has a product called mirror accessible which allows the database to be mirrored for reporting purposes. He wants us to use this product. Now I'm familiar with the EMC solution, Quest's Shareplex, Oracle Standby and Oracle Replication but he says it isn't any of these. Any idea what he might be talking about? Jay Miller -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Miller, Jay 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: Kimberly Smith 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: Ed 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