Re: I/O EVENTS
So just looking at v$system_event is dangerous. Looking v$system_event and v$sysstat is much better but still not perfect. The third way is ... (mail me ;-)) Anjo, Jared has an even hand on the tiller. Go ahead an post an informative example of how the v$ views don't allow you to diagnose a specific problem, and how Precise products do. We wanna know, and I don't imagine he'll mind. These little hints, and half sentences that end with an ellipsis, are getting on my nerves! ;-) - Greg -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Greg Moore 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: 9i r2
just to mention: used Opera to download - Oracle 9.2.0.1.0 - for LINUX, SOLARIS and NT - as we have'm all three - there was NO problem. kr [EMAIL PROTECTED] 05/20/02 22:17 PM Someone at Oracle has modified the login procedures for download.oracle.com, as wget no longer works with -http-user and -http-password from this site. So, you get to do it from a browser. What fun. Jared JOE TESTA [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 05/20/2002 08:23 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:9i r2 2 of the files downloaded, will be loading it up today,. woohoo, can anyone say crash and burn, bwahahahahahaha joe -- 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: Markus Reger 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: 9i r2
just to mention: used Opera to download - Oracle 9.2.0.1.0 - for LINUX, SOLARIS and NT - as we have'm all three - there was NO problem. kr [EMAIL PROTECTED] 05/20/02 22:17 PM Someone at Oracle has modified the login procedures for download.oracle.com, as wget no longer works with -http-user and -http-password from this site. So, you get to do it from a browser. What fun. Jared JOE TESTA [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 05/20/2002 08:23 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:9i r2 2 of the files downloaded, will be loading it up today,. woohoo, can anyone say crash and burn, bwahahahahahaha joe -- 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: Markus Reger 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 find current ORACLE_HOME programmatically
Hi you should be able to find it under: HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE Harold -Original Message- Sent: Tuesday, May 21, 2002 01:08 To: Multiple recipients of list ORACLE-L Hi, guys. I need to find current value of ORACLE_HOME on the client from VB program, running on that client. I understand that it is in the registry somewhere. I have 2 client installations - one is 8.1.7 and another is 9 on the same client. Apparently EM from 9 installation knows that needed tsnames.ora is in 9 ORACLE_HOME and 8.1.7 EM knows that tsnames.ora in 8.1.7. installation. And my VB program select tsnames.ora from 8.1.7 installation Any ideas? Alex Hillman -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Alex Hillman 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: Leeraar, Harold 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: TEST
you've been ignored, forever RAJESH DAYAL wrote: TESTING .. PLS IGNORE . -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joe 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 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).
patching 8.1.7
Good morning all, They are finally going to let me install 8.1.7 and try it on my little database that hold my recovery catalog and OEM repository. I would like to know if I will have to apply a patch before using it. We are on AIX 4.3.3. Thanks in advance, Ruth -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ruth Gramolini 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).
How to enable Java
Hi folks: I'm installing IAS on our web server which is a DEC Alpha 800, one of the steps says that Java isn't enabled on the database that the IAS will work with. This database TEST is running on a DEC Alpha 4100, the TEST database is an 8.1.6 database. The IAS install says to use dbassist to turn on Java. Okay, I ran dbassist, checked change a database configuration selected TEST and clicked next. A new window pops up, stays blank and nothing happens. No status bar, no info, just the blank window. After 10 minutes I cancelled the process. I've tried this with the database down, and dbassist opens the database. I've tried it with the TEST database up in restricted and still same thing. Any ideas? Any way to enable Java by running a script? 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).
ORA-2085
Hi all. I have recently had to enable global_names in order to set up a replicated environment. The application uses a database link to reconnect to the database under a differant user id (I inheirited this, I had nothing to do with the design!). Appearantly, global_names has a prblem with this... SQL select * from [EMAIL PROTECTED]; select * from [EMAIL PROTECTED] * ERROR at line 1: ORA-02085: database link DONOT_TRIGGER.WORLD connects to DRL2.WORLD SQL !oerr ORA 2085 02085, 0, database link %s connects to %s // *Cause: a database link connected to a database with a different name. // The connection is rejected. // *Action: create a database link with the same name as the database it // connects to, or set global_names=false. So, does anybody have any work arounds or ideas how I can get this thing working again? TIA, John P Weatherman Database Administrator Replacements Ltd. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: John Weatherman 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 on (Ssshhh NT)
All, Anyone can point me in the direction of some excellent books re. the setup/admin/tuning of Oracle on NT in specific. I could google it but theres nothing better than personal recommendations. It would appear wehave a(nother !!)major client here who requires an Oracle/NT solution and although the first one was relatively small and easy to set up (purely for reporting), this one could potentially be a lot bigger and will use OLTP and batch type processing, therefore an all singing, all dancing database/setup will be needed. Regards Lee The information contained in this communication is confidential, is intended only for the use of the recipient named above, and may be legally privileged. If the reader of this message is not the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please re-send this communication to the sender and delete the original message or any copy of it from your computer system.
Re: How to enable Java
You can installed java with scripts. Check metalink note 156477.1 Use more space (10-20M more )than specified on the note for java_pool_size and shared_pool --- Joe LaCascio [EMAIL PROTECTED] a écrit : Hi folks: I'm installing IAS on our web server which is a DEC Alpha 800, one of the steps says that Java isn't enabled on the database that the IAS will work with. This database TEST is running on a DEC Alpha 4100, the TEST database is an 8.1.6 database. The IAS install says to use dbassist to turn on Java. Okay, I ran dbassist, checked change a database configuration selected TEST and clicked next. A new window pops up, stays blank and nothing happens. No status bar, no info, just the blank window. After 10 minutes I cancelled the process. I've tried this with the database down, and dbassist opens the database. I've tried it with the TEST database up in restricted and still same thing. Any ideas? Any way to enable Java by running a script? 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). = Stéphane Paquette DBA Oracle, consultant entrepôt de données Oracle DBA, datawarehouse consultant [EMAIL PROTECTED] ___ Do You Yahoo!? -- Une adresse @yahoo.fr gratuite et en français ! Yahoo! Mail : http://fr.mail.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?paquette=20stephane?= 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: 9i r2
I believe those check boxes are required by US export laws. Granted, it won't stop someone from those countries from downloading the software, but then I believe Oracle is not liable. And yes...seemingly pointless... -Original Message- Sent: Tuesday, May 21, 2002 1:23 AM To: Multiple recipients of list ORACLE-L On Mon, 20 May 2002 [EMAIL PROTECTED] wrote: as wget no longer works with -http-user and -http-password from this site. So, you get to do it from a browser. What fun. Yeah, I just noticed that too. Gotta make sure you're not from Cuba, Sudan, Iraq, Libya, NKorea, or Syria. Then again, what's to stop someone from any of those places lying on the license. Seemingly pointless... -- 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: 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).
RE: What makes Export slow ?
Using a large buffer size allows more data to be written via export (a C Program) from the database to a file. The buffer specifies the size of each write to the database. Direct=Y was added in Oracle7 and allows export to bypass the SQL communication layer and write data from the database to the export file. Generally this is used to speed up exports, however, there have been issues with constraints, etc. Large rollback segment option can only be used if you can really assure that no one is using the database and you can disable all other rollback segments. Otherwise, this option is useless. Thank You Stephen P. Karniotis Product Architect Compuware Corporation Direct: (248) 865-4350 Mobile: (248) 408-2918 Email: [EMAIL PROTECTED] Web:www.compuware.com -Original Message- Sent: Monday, May 20, 2002 2:04 PM To: Multiple recipients of list ORACLE-L Subject:RE: What makes Export slow ? On Mon, 20 May 2002, Reddy, Madhusudana wrote: Huge Buffer, commit=y, direct=y, assigning the big rollback segment should help you to have faster export , What do you mean assigning the big rollback segment? How do you do that to an export and what does it accomplish? What does COMMIT=Y do in an export? If I were the original poster, I'd just look at v$session_event for the export session after several minutes of slowness. -- Jeremiah Wilton http://www.speakeasy.net/~jwilton -Original Message- Sent: Monday, May 20, 2002 3:43 AM To: Multiple recipients of list ORACLE-L I moved my database from Solaris 7 to Solaris 8 box (Sun Fire 4800, faster processors and more memory space) I create the database with the same script that I used to for my database in the older machine, When I export my database from the older machine it was very fast and when I import to newer machine it was fast too, and when I export from new machine it is really slow (very slow), (I am using same export parameters in both servers) Can someone help with tuning tips or anything you have... : ( - The no of records are the same for both machines - v$session_wait.seconds_in_wait is more than 1 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jeremiah Wilton 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). The contents of this e-mail are intended for the named addressee only. It contains information that may be confidential. Unless you are the named addressee or an authorized designee, you may not copy or use it, or disclose it to anyone else. If you received it in error please notify us immediately and then destroy it. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Karniotis, Stephen 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: patching 8.1.7
I have patched up to 8.1.7.3 (on Tru64) but there quite a few noises coming from this list to say that this release is buggy and therefore I should have stopped at 8.1.7.2. HTH Lee -Original Message- Sent: 21 May 2002 13:48 To: Multiple recipients of list ORACLE-L Good morning all, They are finally going to let me install 8.1.7 and try it on my little database that hold my recovery catalog and OEM repository. I would like to know if I will have to apply a patch before using it. We are on AIX 4.3.3. Thanks in advance, Ruth -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ruth Gramolini 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). The information contained in this communication is confidential, is intended only for the use of the recipient named above, and may be legally privileged. If the reader of this message is not the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please re-send this communication to the sender and delete the original message or any copy of it from your computer system. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Robertson Lee - lerobe 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 enable Java
Joe, Log on to your server, and change your directory to : ORACLE_HOME/JAVAVM/INSTALL Start up Sqlplus, connecting as SYS and run the INITJVM.SQL file. Be sure hat Java_Pool_Size = 52428800 is in your init.ora file. This takes about 20 minutes to complete. This will install the Java engine within the database. Hope this helps Tom Mercadante Oracle Certified Professional -Original Message- Sent: Tuesday, May 21, 2002 9:18 AM To: Multiple recipients of list ORACLE-L Hi folks: I'm installing IAS on our web server which is a DEC Alpha 800, one of the steps says that Java isn't enabled on the database that the IAS will work with. This database TEST is running on a DEC Alpha 4100, the TEST database is an 8.1.6 database. The IAS install says to use dbassist to turn on Java. Okay, I ran dbassist, checked change a database configuration selected TEST and clicked next. A new window pops up, stays blank and nothing happens. No status bar, no info, just the blank window. After 10 minutes I cancelled the process. I've tried this with the database down, and dbassist opens the database. I've tried it with the TEST database up in restricted and still same thing. Any ideas? Any way to enable Java by running a script? 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: Mercadante, Thomas F 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: 9i r2
Hi, Were you able to untar and use the cpio command to extract the binaries successfully for Linux without any problems? Because, I was able to sucessfully download all the three files, but I was getting an error Unexpected end of file when using hte cpio command. Regards CP Markus Reger [EMAIL PROTECTED] wrote: just to mention: used Opera to download - Oracle 9.2.0.1.0 - for LINUX, SOLARIS and NT - as we have'm all three - there was NO problem. kr [EMAIL PROTECTED] 05/20/02 22:17 PM Someone at Oracle has modified the login procedures for download.oracle.com, as wget no longer works with -http-user and -http-password from this site. So, you get to do it from a browser. What fun. Jared JOE TESTA [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 05/20/2002 08:23 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject: 9i r2 2 of the files downloaded, will be loading it up today,. woohoo, can anyone say crash and burn, bwahahahahahaha joe -- 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: Markus Reger 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). __ Your favorite stores, helpful shopping tools and great gift ideas. Experience the convenience of buying online with Shop@Netscape! http://shopnow.netscape.com/ Get your own FREE, personal Netscape Mail account today at http://webmail.netscape.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).
Outstanding bugs in 8.1.7.2
I've been hunting around OTN and can't remember where to find this. I'd like to see a list of all outstanding bugs that are present in version 8.1.7.2 of EE. Is there one convenient place to find these or am I going to have to compile a list from multiple other versions. Thanks, Cherie Machler Oracle DBA Gelco Information Network -- 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).
PLS-00553
Can anyone tell me what this PL/SQL error actually means? The manual says An unrecognised name appears in the character set specification John -- 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).
Re: 9i r2
nothing stops anyone from lying... but it's CYA on Oracle's part, they ASKED --- [EMAIL PROTECTED] wrote: On Mon, 20 May 2002 [EMAIL PROTECTED] wrote: as wget no longer works with -http-user and -http-password from this site. So, you get to do it from a browser. What fun. Yeah, I just noticed that too. Gotta make sure you're not from Cuba, Sudan, Iraq, Libya, NKorea, or Syria. Then again, what's to stop someone from any of those places lying on the license. Seemingly pointless... -- 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!? LAUNCH - Your Yahoo! Music Experience http://launch.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).
Re: Export problem
[EMAIL PROTECTED] wrote: Hi! Can I export a 7.3.3 database with a 8.1.7 export utility? Theoretically it should work. EXP-8: ORACLE error 942 encountered ORA-00942: Tabelle oder View nicht vorhanden EXP-00024: Export views not installed, please notify your DBA EXP-0: Export terminated unsuccessfully But why am I getting these error messges? What scripts need to be run to solve this problem? This is 7.3.3 / 8.1.7 on Win NT. Thanks, Helmut i think you need to create the 8.1.7 views in the 7.3.3 database to have the 8.1.7 export work. but i'm not sure that can be done due to the differences in things like rowid and file numbering. but maybe i'm wrong. it should be the catexp[817?].sql script you need to run. -- -- 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. The generation of random numbers is too important to be left to chance. -- 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).
RE: 9i r2
Pointless until someone sues Oracle for allowing those products to be freely downloaded to a restricted country. It's free software and you're being asked to click in 4 check boxes. It's a tough life. Mike -Original Message- Sent: 21 May 2002 15:03 To: Multiple recipients of list ORACLE-L I believe those check boxes are required by US export laws. Granted, it won't stop someone from those countries from downloading the software, but then I believe Oracle is not liable. And yes...seemingly pointless... -Original Message- Sent: Tuesday, May 21, 2002 1:23 AM To: Multiple recipients of list ORACLE-L On Mon, 20 May 2002 [EMAIL PROTECTED] wrote: as wget no longer works with -http-user and -http-password from this site. So, you get to do it from a browser. What fun. Yeah, I just noticed that too. Gotta make sure you're not from Cuba, Sudan, Iraq, Libya, NKorea, or Syria. Then again, what's to stop someone from any of those places lying on the license. Seemingly pointless... -- 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: 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). This email and any attached to it are confidential and intended only for the individual or entity to which it is addressed. If you are not the intended recipient, please let us know by telephoning or emailing the sender. You should also delete the email and any attachment from your systems and should not copy the email or any attachment or disclose their content to any other person or entity. The views expressed here are not necessarily those of Churchill Insurance Group plc or its affiliates or subsidiaries. Thank you. Churchill Insurance Group plc. Company Registration Number - 2280426. England. Registered Office: Churchill Court, Westmoreland Road, Bromley, Kent BR1 1DP. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hately Mike 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 enable Java
Hi Joe, I think you need to run the following from the sys account /javavm/install/initjvm.sql -- setup database for running Hava and the ORB /rdbms/admin/initplsj.sql -- initializes java libraries for pl/sql There may be other scripts depending on your needs but I think these you must run. System requirements (these are just recommendations) SHARED_POOL_SIZE = 65 MB JAVA_POOL_SIZE = 50 mb 50 MB free in the system tablespace 250 MB of rollback segment space Rick Joe LaCascio jlacasci@whea To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] tonma.edu cc: Sent by: Subject: How to enable Java [EMAIL PROTECTED] om 05/21/2002 09:18 AM Please respond to ORACLE-L Hi folks: I'm installing IAS on our web server which is a DEC Alpha 800, one of the steps says that Java isn't enabled on the database that the IAS will work with. This database TEST is running on a DEC Alpha 4100, the TEST database is an 8.1.6 database. The IAS install says to use dbassist to turn on Java. Okay, I ran dbassist, checked change a database configuration selected TEST and clicked next. A new window pops up, stays blank and nothing happens. No status bar, no info, just the blank window. After 10 minutes I cancelled the process. I've tried this with the database down, and dbassist opens the database. I've tried it with the TEST database up in restricted and still same thing. Any ideas? Any way to enable Java by running a script? 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: patching 8.1.7
I just talked to OWS and they suggested to read the patch notes and if I need any of the fixes and if not, just install and don't patch until I have to. Ruth - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, May 21, 2002 9:38 AM I have patched up to 8.1.7.3 (on Tru64) but there quite a few noises coming from this list to say that this release is buggy and therefore I should have stopped at 8.1.7.2. HTH Lee -Original Message- Sent: 21 May 2002 13:48 To: Multiple recipients of list ORACLE-L Good morning all, They are finally going to let me install 8.1.7 and try it on my little database that hold my recovery catalog and OEM repository. I would like to know if I will have to apply a patch before using it. We are on AIX 4.3.3. Thanks in advance, Ruth -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ruth Gramolini 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). The information contained in this communication is confidential, is intended only for the use of the recipient named above, and may be legally privileged. If the reader of this message is not the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please re-send this communication to the sender and delete the original message or any copy of it from your computer system. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Robertson Lee - lerobe 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: Ruth Gramolini 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 enable Java
Hi Joe, Check out oracle document note:156477.1 JVM installation on 8.1.7 for details. Bryan -Original Message- Sent: Tuesday, May 21, 2002 10:18 AM To: Multiple recipients of list ORACLE-L Hi Joe, I think you need to run the following from the sys account /javavm/install/initjvm.sql -- setup database for running Hava and the ORB /rdbms/admin/initplsj.sql -- initializes java libraries for pl/sql There may be other scripts depending on your needs but I think these you must run. System requirements (these are just recommendations) SHARED_POOL_SIZE = 65 MB JAVA_POOL_SIZE = 50 mb 50 MB free in the system tablespace 250 MB of rollback segment space Rick Joe LaCascio jlacasci@whea To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] tonma.edu cc: Sent by: Subject: How to enable Java [EMAIL PROTECTED] om 05/21/2002 09:18 AM Please respond to ORACLE-L Hi folks: I'm installing IAS on our web server which is a DEC Alpha 800, one of the steps says that Java isn't enabled on the database that the IAS will work with. This database TEST is running on a DEC Alpha 4100, the TEST database is an 8.1.6 database. The IAS install says to use dbassist to turn on Java. Okay, I ran dbassist, checked change a database configuration selected TEST and clicked next. A new window pops up, stays blank and nothing happens. No status bar, no info, just the blank window. After 10 minutes I cancelled the process. I've tried this with the database down, and dbassist opens the database. I've tried it with the TEST database up in restricted and still same thing. Any ideas? Any way to enable Java by running a script? 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rodrigues, Bryan 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 on (Ssshhh NT)
Thanks Rachel, this will be (for this year anyway) on Oracle 8 (not even 8i, don't ask !!!) Regards Lee -Original Message- Sent: 21 May 2002 15:23 To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Oracle Press has two... Oracle9i for Windows(R) Handbook by Velpuri (should be good) and Oracle9i for Windows(R) 2000 Tips Techniques by Sale, Jesse ?? you can get a table of contents and sample chapter on the site: http://shop.osborne.com/cgi-bin/oraclepress/ (then click on Server Technologies) --- Robertson Lee - lerobe [EMAIL PROTECTED] wrote: All, Anyone can point me in the direction of some excellent books re. the setup/admin/tuning of Oracle on NT in specific. I could google it but theres nothing better than personal recommendations. It would appear we have a(nother !!) major client here who requires an Oracle/NT solution and although the first one was relatively small and easy to set up (purely for reporting), this one could potentially be a lot bigger and will use OLTP and batch type processing, therefore an all singing, all dancing database/setup will be needed. Regards Lee The information contained in this communication is confidential, is intended only for the use of the recipient named above, and may be legally privileged. If the reader of this message is not the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please re-send this communication to the sender and delete the original message or any copy of it from your computer system. __ Do You Yahoo!? LAUNCH - Your Yahoo! Music Experience http://launch.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Robertson Lee - lerobe 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: 9i r2
Have you had these bags under your control since you packed them? Has anyone unknown to you asked you to carry anything on this flight? ...same situation... - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, May 21, 2002 8:03 AM I believe those check boxes are required by US export laws. Granted, it won't stop someone from those countries from downloading the software, but then I believe Oracle is not liable. And yes...seemingly pointless... -Original Message- Sent: Tuesday, May 21, 2002 1:23 AM To: Multiple recipients of list ORACLE-L On Mon, 20 May 2002 [EMAIL PROTECTED] wrote: as wget no longer works with -http-user and -http-password from this site. So, you get to do it from a browser. What fun. Yeah, I just noticed that too. Gotta make sure you're not from Cuba, Sudan, Iraq, Libya, NKorea, or Syria. Then again, what's to stop someone from any of those places lying on the license. Seemingly pointless... -- 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: 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: Tim Gorman 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: ORA-2085
I think that this is one of the few Oracle error messages where the suggested action truly represents the solution. Far more helpful than Contact your Oracle Representative... :-) This might be a long shot, however... SQL create synonym [EMAIL PROTECTED] for sys.dual; Synonym created. SQL select count(*) from [EMAIL PROTECTED]; COUNT(*) -- 1 SQL select count(*) from [EMAIL PROTECTED]; select count(*) from [EMAIL PROTECTED] * ERROR at line 1: ORA-02019: connection description for remote database not found Naturally, you would not make the synonym reference SYS.DUAL, but DUAL@db-name instead, to avoid the ORA-02085 error and keep GLOBAL_NAMES enabled... Of course, this might mean changes to the application if you have to add quotation marks around each reference to a table or view, which is what I imagine you are trying to avoid. However, you might be in luck if this application is accessing Oracle via Oracle's own ODBC drivers. By a stroke of luck, the Oracle ODBC drivers (downloadable from otn.oracle.com) tend to wrap the names of all objects within quotation marks, at least in my limited experience... Hey, it might be worth a look-see. Sometimes you just get lucky... - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, May 21, 2002 7:23 AM Hi all. I have recently had to enable global_names in order to set up a replicated environment. The application uses a database link to reconnect to the database under a differant user id (I inheirited this, I had nothing to do with the design!). Appearantly, global_names has a prblem with this... SQL select * from [EMAIL PROTECTED]; select * from [EMAIL PROTECTED] * ERROR at line 1: ORA-02085: database link DONOT_TRIGGER.WORLD connects to DRL2.WORLD SQL !oerr ORA 2085 02085, 0, database link %s connects to %s // *Cause: a database link connected to a database with a different name. // The connection is rejected. // *Action: create a database link with the same name as the database it // connects to, or set global_names=false. So, does anybody have any work arounds or ideas how I can get this thing working again? TIA, John P Weatherman Database Administrator Replacements Ltd. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: John Weatherman 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: Tim Gorman 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 on (Ssshhh NT)
Do'h. Just shows how much notice/interest I have in the subject. I have just picked up my copy (apologies Gaja/Kirti) and went straight to the stuff you are talking about. Thanks to all for the help thus far. I will make more use of my existing library set before bothering you good people so quickly in future. I will have a thinklater in the weekabout your last line :-) Cheers Lee -Original Message-From: Farnsworth, Dave [mailto:[EMAIL PROTECTED]]Sent: 21 May 2002 16:34To: Multiple recipients of list ORACLE-LSubject: RE: Oracle on (Ssshhh NT) Oracle Performance Tuning 101 has NT and unix specific info in it. Most publications are geared to NT. I hate to say it but about the best one is in the FM. In the Oracle for NT docs is the Oracle Administrators Guide for NT. Waiting for your next recipe. :o) Dave -Original Message-From: Robertson Lee - lerobe [mailto:[EMAIL PROTECTED]]Sent: Tuesday, May 21, 2002 8:38 AMTo: Multiple recipients of list ORACLE-LSubject: Oracle on (Ssshhh NT) All, Anyone can point me in the direction of some excellent books re. the setup/admin/tuning of Oracle on NT in specific. I could google it but theres nothing better than personal recommendations. It would appear wehave a(nother !!)major client here who requires an Oracle/NT solution and although the first one was relatively small and easy to set up (purely for reporting), this one could potentially be a lot bigger and will use OLTP and batch type processing, therefore an all singing, all dancing database/setup will be needed. Regards Lee The information contained in this communication isconfidential, is intended only for the use of the recipientnamed above, and may be legally privileged. If the reader of this message is not the intended recipient, you arehereby notified that any dissemination, distribution orcopying of this communication is strictly prohibited. If you have received this communication in error, please re-send this communication to the sender and delete the original message or any copy of it from your computersystem.
Re: Oracle on (Ssshhh NT)
The question of Oracle and NT came up before. I had some papers (not mine) that I'd downloaded to my hard drive so I posted them where people could find them. This doesn't answer your question exactly and I'm not sure how useful the papers were to other people but they have been useful to me. I emphasize that these are not my work but the work of the authors whose names appear on the papers. I had three papers that pertain to Oracle and NT. They are at: This is about Oracle 9 on NT/2000 http://www.msnusers.com/torac/Documents/SQL-Ora/Maximizing%20Productivity%20.doc This is about Oracle 8 on NT http://www.msnusers.com/torac/Documents/SQL%2DOra/Oracle8%20on%20NT%2Edoc This is a pdf about configuration standards for Oracle on NT http://www.msnusers.com/torac/Documents/SQL%2DOra%2FORACLE%5FNT%5FCONFIG.pdf If you don't have hotmail userids I have also uploaded them to http://www.geocities.com/tomdaytwo/MaximizingProductivity.htm http://www.geocities.com/tomdaytwo/Oracle8onNT.htm http://www.geocities.com/tomdaytwo/ORACLE_NT_CONFIG.pdf You should be able to find them at one place or the other. Robertson Lee - lerobe To: Multiple recipients of list ORACLE-L lerobe [EMAIL PROTECTED] @acxiom.co.ukcc: Subject: Oracle on (Ssshhh NT) Sent by: root 05/21/2002 09:38 AM Please respond to ORACLE-L All, Anyone can point me in the direction of some excellent books re. the setup/admin/tuning of Oracle on NT in specific. I could google it but theres nothing better than personal recommendations. It would appear we have a(nother !!) major client here who requires an Oracle/NT solution and although the first one was relatively small and easy to set up (purely for reporting), this one could potentially be a lot bigger and will use OLTP and batch type processing, therefore an all singing, all dancing database/setup will be needed. Regards Lee The information contained in this communication is confidential, is intended only for the use of the recipient named above, and may be legally privileged. If the reader of this message is not the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please re-send this communication to the sender and delete the original message or any copy of it from your computer system. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Thomas Day 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).
Restoring archivelogs through RMAN
In running RMAN and restoring a database, the necessary archivelogs are not restored. I found that they have to be restored separately, unless its something we are doing incorrectly. My question is, I have attempted to use the 'restore archivelog like 'PROD_1_2%' but it fails with RMAN-06004: ORACLE error from recovery catalog database: RMAN-20242: specification does not match any archivelog in the recovery catalog What am I doing wrong? Only the 'restore archivelog all' seems to work, but I get back more than I need. Thanks in advance. begin:vcard n:Taylor;Belinda tel;fax:(703) 993-3403 tel;work:(703) 993-3346 x-mozilla-html:FALSE url:http://itu.gmu.edu org:George Mason University ;Information Technology Unit version:2.1 email;internet:[EMAIL PROTECTED] title:Database Analyst, Database Support adr;quoted-printable:;;Technology Systems Division=0D=0A4400 University Drive=0D=0AMSN 1B5;Fairfax;VA;22030;USA fn:Belinda Taylor end:vcard
RE: How to enable Java
I don't have an account with metalink, and I can't get to this article on technet. Anyplace else to get this. Also, I'm trying to do this in 8.1.6. Thanks, Joe On Tue, 21 May 2002, Rodrigues, Bryan wrote: Hi Joe, Check out oracle document note:156477.1 JVM installation on 8.1.7 for details. Bryan -Original Message- Sent: Tuesday, May 21, 2002 10:18 AM To: Multiple recipients of list ORACLE-L Hi Joe, I think you need to run the following from the sys account /javavm/install/initjvm.sql -- setup database for running Hava and the ORB /rdbms/admin/initplsj.sql -- initializes java libraries for pl/sql There may be other scripts depending on your needs but I think these you must run. System requirements (these are just recommendations) SHARED_POOL_SIZE = 65 MB JAVA_POOL_SIZE = 50 mb 50 MB free in the system tablespace 250 MB of rollback segment space Rick Joe LaCascio jlacasci@whea To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] tonma.edu cc: Sent by: Subject: How to enable Java [EMAIL PROTECTED] om 05/21/2002 09:18 AM Please respond to ORACLE-L Hi folks: I'm installing IAS on our web server which is a DEC Alpha 800, one of the steps says that Java isn't enabled on the database that the IAS will work with. This database TEST is running on a DEC Alpha 4100, the TEST database is an 8.1.6 database. The IAS install says to use dbassist to turn on Java. Okay, I ran dbassist, checked change a database configuration selected TEST and clicked next. A new window pops up, stays blank and nothing happens. No status bar, no info, just the blank window. After 10 minutes I cancelled the process. I've tried this with the database down, and dbassist opens the database. I've tried it with the TEST database up in restricted and still same thing. Any ideas? Any way to enable Java by running a script? 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rodrigues, Bryan 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: 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).
init.ora params for quick i/0
Hello, We have implemented quick i/o on a sun server running solaris 8 and Oracle 8173. I have set disk_asynch to true. I have verified using truss that dbwr is making kaio calls. Is there anything I am missing on the db side to make proper use of quick i/o ? Also, I am noticing heavy I/O related waits for a process (db file sequential read, db file parallel write etc..) and would like to involve our sys admin in tuning this particular process..If anyone has any idea what I can specifically ask the sys admin to look at, please do let me know.. I really appreciate any feedback I could get.. Thanks Mohammed Ahsanuddin Oracle DBA -- 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: ORA-2085
Yes, I inherited this, and I am setting up Multimaster Advanced Replication, setting global_names=false isn't an option. I have suggested moving the donotfiretrigger logic into the trigger, which has some initial support. For the moment, we are changing the code to point to a link with the same name as the service name (which has obvious limitations, so hopefully a real fix will get done). I was really hoping there might be another workaround bandaid though, as I really don't want the fix to end up permanent. Thanks, John P Weatherman Database Administrator Replacements Ltd. -Original Message- Sent: Tuesday, May 21, 2002 11:23 AM To: Multiple recipients of list ORACLE-L My guess is that you inherited an environment where the DB-Link was setup that way [link-name different from DB-name] . and then, sometime later, you set GLOBAL_NAMES=TRUE Well you have no choice : // *Action: create a database link with the same name as the database it // connects to, or set global_names=false. Are you setting up Advanced Replication [MultiMaster] or Simple Replication [Snapshots] ? I believe that Simple Replication does not mandate GLOBAL_NAMES=TRUE. Hemant K Chitale - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, 21 May, 2002 9:23 PM Hi all. I have recently had to enable global_names in order to set up a replicated environment. The application uses a database link to reconnect to the database under a differant user id (I inheirited this, I had nothing to do with the design!). Appearantly, global_names has a prblem with this... SQL select * from [EMAIL PROTECTED]; select * from [EMAIL PROTECTED] * ERROR at line 1: ORA-02085: database link DONOT_TRIGGER.WORLD connects to DRL2.WORLD SQL !oerr ORA 2085 02085, 0, database link %s connects to %s // *Cause: a database link connected to a database with a different name. // The connection is rejected. // *Action: create a database link with the same name as the database it // connects to, or set global_names=false. So, does anybody have any work arounds or ideas how I can get this thing working again? TIA, John P Weatherman Database Administrator Replacements Ltd. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: John Weatherman 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: Hemant K Chitale 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 Weatherman 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: SHARED POOL SIZE
NO, THERE IS NO WAY TO INCREASE THE SHARED_POOL_SIZE WITHOUT SHUT DOWN (sic) THE DATABASE below 9i. Please don't use All-Caps. I remember the first time I used All-Caps on a NewsGroup about 7 or 8 years ago, I was roundly berated. Hemant K Chitale - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, 21 May, 2002 3:05 AM HI, IS THERE ANY WAY TO INCREASE THE SHARED_POOL_SIZE WITHOUT SHUT DOWN THE DATABASE(8.1.6.2 ON SUN SOLARIS) Hamid Alavi Office 818 737-0526 Cell818 402-1987 === Confidentiality Statement === 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. = End Confidentiality Statement = -- 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: Hemant K Chitale 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).
How to populate many-to-many
I am designing a database our software/hardware inventory and there is a many-to-many relationship between 'server' and 'software' table. So I created an association table between them to resolve this. While I believe this is the right thing to do, I am wondering how we are going to populate this association table. It seems to me that we have to create a separate screen for this table to have the users manually enter the data. Right now this table has only three columns - ( server_software_id, server_id, software_id ). Bonus question - if we are going to use Access to manually enter data, is there any way we can avoid entering the raw numbers ( the association table columns are all numeric ). I remember with Oracle Forms you can set up some kind of drop down list where you pick the text value and the ids get populated behind the scene. I am not a fan of Access, can we do something similar? TIA Dennis Meng Database Administrator Focal Communications Corp. -- 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 on (Ssshhh NT)
Oracle Performance Tuning 101 has NT and unix specific info in it. Most publications are geared to NT. I hate to say it but about the best one is in the FM. In the Oracle for NT docs is the Oracle Administrators Guide for NT. Waiting for your next recipe. :o) Dave -Original Message-From: Robertson Lee - lerobe [mailto:[EMAIL PROTECTED]]Sent: Tuesday, May 21, 2002 8:38 AMTo: Multiple recipients of list ORACLE-LSubject: Oracle on (Ssshhh NT) All, Anyone can point me in the direction of some excellent books re. the setup/admin/tuning of Oracle on NT in specific. I could google it but theres nothing better than personal recommendations. It would appear wehave a(nother !!)major client here who requires an Oracle/NT solution and although the first one was relatively small and easy to set up (purely for reporting), this one could potentially be a lot bigger and will use OLTP and batch type processing, therefore an all singing, all dancing database/setup will be needed. Regards Lee The information contained in this communication isconfidential, is intended only for the use of the recipientnamed above, and may be legally privileged. If the reader of this message is not the intended recipient, you arehereby notified that any dissemination, distribution orcopying of this communication is strictly prohibited. If you have received this communication in error, please re-send this communication to the sender and delete the original message or any copy of it from your computersystem.
RE: Statspack Problem
-Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Reardon, Bruce (CALBBAY) Sent: Monday, May 20, 2002 10:08 PM To: Multiple recipients of list ORACLE-L Subject: RE: Statspack Problem Have you connected via BEQ or Net8 initially? Have you got oracle_sid set as an environment variable, as it looks like the connect perfstat/perfstat uses a BEQ connection. It does not look as though the SID_NAME parameter was set on the system I was trying to install too. Although it was set on my test system, maybe thats why it worked in test but not production. Anyway, I am off to try again. Thanks for the idea. After connecting as sys, can you now do a connect perfstat/perfstat (though maybe the scripts cleaned up on error and deleted the perfstat user. Yes, I can login as 'perfstat', and any other user as well, it looks like the script was able to create the user. HTH, Bruce Reardon -Original Message- Sent: Tuesday, 21 May 2002 11:39 I am running 8.1.6 on a Win2000 SP2 machine. When I try running 'statscre.sql' as SYS, the first script completes fine, but when the second script tries to connect perfstat/perfstat , I get the error, You are no longer connected to Oracle TNS:ORA-12154. Of course the system then proceeds to attempt to run the other two scripts returning about a hundred not connected error messages. The Perfstat user was created and I did not have the chance to intervene and change its password. Any ideas as to why the script would fail to connect? I connected as internal in the first place to run the script, so I don't think its TNS. Tom Schruefer - [EMAIL PROTECTED] 410-313-6825 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Reardon, Bruce (CALBBAY) 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: Tom Schruefer 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 enable Java
Thanks for the help folks. We are moving along with our IAS install now. It's funny, I've been using the command line with Oracle for so long, I didn't know that dbassist was even there. And once again, the GUI failed where good ole SQL prompt resolved the problem. 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).
Re: Restoring archivelogs through RMAN
Here is the corrent syntax: restore archivelog from logseq until logseq thread 1; You have to specify from logseq ...unt8il logseq even if you only want to restore 1 logfile. An easier way would be: restore logfile all; This will get any archivelogs in the backupset. HTH, Ruth - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, May 21, 2002 10:58 AM In running RMAN and restoring a database, the necessary archivelogs are not restored. I found that they have to be restored separately, unless its something we are doing incorrectly. My question is, I have attempted to use the 'restore archivelog like 'PROD_1_2%' but it fails with RMAN-06004: ORACLE error from recovery catalog database: RMAN-20242: specification does not match any archivelog in the recovery catalog What am I doing wrong? Only the 'restore archivelog all' seems to work, but I get back more than I need. Thanks in advance. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ruth Gramolini 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).
ORA_ENCRYPT_LOGIN
Title: SQL Server to Oracle DB Anyone using this and if so, do you know of a way to verify that the password is actually being encrypted? Thanks.
RE: SQL*Plus and DBMS_OUTPUT won't display extended charset?
Yup, as I mentioned in the export... statement, it is. Looks like an iTAR... sigh Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA -Original Message- From: Grabowy, Chris [mailto:[EMAIL PROTECTED]] Sent: Thursday, May 16, 2002 6:08 PM To: Multiple recipients of list ORACLE-L Subject: RE: SQL*Plus and DBMS_OUTPUT won't display extended charset? I'm not 100% sure, but don't you also have to set those NLS parms on your client??? Chris -Original Message- Sent: Thursday, May 16, 2002 6:28 PM To: Multiple recipients of list ORACLE-L Oracle 8.1.7.2.0 HP/UX 11.0 DB was converted from USASCII7 to UTF8 NLS_CHARACTERSET and NLS_NCHAR_CHARACTERSET are both UTF8 in DB. export NLS_LANG=AMERICAN_AMERICA.UTF8 in client environment (Korn shell). In SVRMGRL on the DB server, when I SELECT CHR(200) FROM DUAL, I get the character displayed properly (Latin capital E with grave accent). In SQL*Plus, however, the character does not appear. Also, when I use DBMS_OUTPUT.PUT_LINE to dump CHR(200) to the screen in either Server Manager or SQL*Plus, nothing shows up. Anyone know what's going on here? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jesse, Rich 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: Korn Shell Sqlplus
According to Oracle Support, in 8.1.6, this can cause processes and locks of the KILLed sessions to hang. And we've seen it. Even after 24 hours, the processes are still listed in V$SESSION, but they have no corresponding entry in V$PROCESS. At this point, the only fix is to bounce the instance. Yes, I don't like killing the processes server-side, either, but in this case we don't have a choice. Also, I haven't been able to find a Metaclink article on when this is supposedly fixed. It doesn't matter because our 3rd-party software vendor won't support anything but 8.1.6.0.0. sigh Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA -Original Message- From: Stephane Faroult [mailto:[EMAIL PROTECTED]] Sent: Monday, May 20, 2002 3:26 PM To: Multiple recipients of list ORACLE-L Subject: Re: Korn Shell Sqlplus Killing Oracle server processes is definitely bad manners. Especially if you are using MTS. Even if you are not, the proper way to kill an Oracle process is to use ALTER SYSTEM KILL SESSION. I think that you should use the DBMS_APPLICATION_INFO package to set something like 'Hey! Shoot me!' in your CLIENT_INFO column in V$PROCESS - it would make it easier to another process to log as DBA, spot the process and bang. Another thing that you might want to explore are profiles - you can define and set a profile with limits to suit your needs, and let Oracle do the dirty work. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jesse, Rich 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).
host from SQL prompt
Title: host from SQL prompt How can I prevent users from typing host to get to an OS prompt while logged into a DB account with an OS account? They can host to a prompt now, but they can't do anything useful from there, since $ORACLE_HOME is the only thing in their PATH...just wondered if there is an easy way to prevent the use of the host command all together. TIA!
RE: Outstanding bugs in 8.1.7.2
A good start would be to get the list of fixes in the README of the 8.1.7.3 bundle for your platform, but I don't know of any comprehensive list. If you find one, let me know! GL! Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 21, 2002 8:43 AM To: Multiple recipients of list ORACLE-L Subject: Outstanding bugs in 8.1.7.2 I've been hunting around OTN and can't remember where to find this. I'd like to see a list of all outstanding bugs that are present in version 8.1.7.2 of EE. Is there one convenient place to find these or am I going to have to compile a list from multiple other versions. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jesse, Rich 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 on (Ssshhh NT)
Lee, I am in the same boat...although I am going to be allowed to install 8.1.7 and use it for my own stuff. Our hired gums(consultants) won't let us more without permission. Take heart, ruth - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, May 21, 2002 11:43 AM Thanks Rachel, this will be (for this year anyway) on Oracle 8 (not even 8i, don't ask !!!) Regards Lee -Original Message- Sent: 21 May 2002 15:23 To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Oracle Press has two... Oracle9i for Windows(R) Handbook by Velpuri (should be good) and Oracle9i for Windows(R) 2000 Tips Techniques by Sale, Jesse ?? you can get a table of contents and sample chapter on the site: http://shop.osborne.com/cgi-bin/oraclepress/ (then click on Server Technologies) --- Robertson Lee - lerobe [EMAIL PROTECTED] wrote: All, Anyone can point me in the direction of some excellent books re. the setup/admin/tuning of Oracle on NT in specific. I could google it but theres nothing better than personal recommendations. It would appear we have a(nother !!) major client here who requires an Oracle/NT solution and although the first one was relatively small and easy to set up (purely for reporting), this one could potentially be a lot bigger and will use OLTP and batch type processing, therefore an all singing, all dancing database/setup will be needed. Regards Lee The information contained in this communication is confidential, is intended only for the use of the recipient named above, and may be legally privileged. If the reader of this message is not the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please re-send this communication to the sender and delete the original message or any copy of it from your computer system. __ Do You Yahoo!? LAUNCH - Your Yahoo! Music Experience http://launch.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Robertson Lee - lerobe 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: Ruth Gramolini 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: host from SQL prompt
Are they telnetting in to your server and then running SQLPlus at the command prompt or are they running SQLPlus from their client and connecting via SQLNet? If the first, then host will not give them anything that they won't get from the telnet session. If the second, they they'll most likely end up at the ORACLE_HOME\bin prompt of their workstation. Are your users really just trained monkeys in disguise and you don't want them to try to recreate the works of Shakespear via random keystrokes? What's the real issue here? Richard Huntley To: Multiple recipients of list ORACLE-L rhuntley[EMAIL PROTECTED] @mindleaders.cc: com Subject: host from SQL prompt Sent by: root 05/21/2002 12:38 PM Please respond to ORACLE-L How can I prevent users from typing host to get to an OS prompt while logged into a DB account with an OS account? They can host to a prompt now, but they can't do anything useful from there, since $ORACLE_HOME is the only thing in their PATH...just wondered if there is an easy way to prevent the use of the host command all together. TIA! -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Thomas Day 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).
UPDATE Results
Title: UPDATE Results Is there a way to access 'something' that would denote if any rows were updated? Feedback lets you set up how many rows will be effected before a count is returned, but WHERE is this number coming from? I have found a 'Returning' clause of the update statement, but I don't really want a value returned, just how many rows were affected. We have a situation where we want to know if an update statement actually updated any rows or in fact did not find a row that met the condition. SqlPlus will return '0 rows updated.' Does anyone know where 0 is coming from? Thanks you for your help. Laura
Re: ORA_ENCRYPT_LOGIN
[EMAIL PROTECTED] wrote: Anyone using this and if so, do you know of a way to verify that the password is actually being encrypted? Thanks. seems like you could put a sniffer on it and watch the data flow by. -- -- 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. The generation of random numbers is too important to be left to chance. -- 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).
RE: How to populate many-to-many
Title: RE: How to populate many-to-many Dennis, M2M's are ugly but a fact of life. I've done what you have suggested. I suggest that you make the combination of server_id and software_id a unique constraint to keep out dupes. In Access drop down lists are called combo boxes. You can base them on queries. Just make sure the server_id and software_id fields are first in their respective select statements that populate each of the two combo boxes. The actual verbiage should be in the second fields of these queries. If you want to show the verbiage instead of the id number, make the Column Count 2, Bound Column 1, and make the Column Widths something like 0; 2. Making the first column zero hides the id numbers. HTH, Jerry Whittle ACIFICS DBA NCI Information Systems Inc. [EMAIL PROTECTED] 618-622-4145 -Original Message- From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]] I am designing a database our software/hardware inventory and there is a many-to-many relationship between 'server' and 'software' table. So I created an association table between them to resolve this. While I believe this is the right thing to do, I am wondering how we are going to populate this association table. It seems to me that we have to create a separate screen for this table to have the users manually enter the data. Right now this table has only three columns - ( server_software_id, server_id, software_id ). Bonus question - if we are going to use Access to manually enter data, is there any way we can avoid entering the raw numbers ( the association table columns are all numeric ). I remember with Oracle Forms you can set up some kind of drop down list where you pick the text value and the ids get populated behind the scene. I am not a fan of Access, can we do something similar? TIA Dennis Meng Database Administrator Focal Communications Corp.
RE: host from SQL prompt
Title: host from SQL prompt Disable the command from the product profile by adding a row to table PRODUCT_PROFILE. Thank You Stephen P. Karniotis Product Architect Compuware Corporation Direct: (248) 865-4350 Mobile: (248) 408-2918 Email: [EMAIL PROTECTED] Web: www.compuware.com -Original Message- From: Richard Huntley [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 21, 2002 12:39 PM To: Multiple recipients of list ORACLE-L Subject: host from SQL prompt How can I prevent users from typing host to get to an OS prompt while logged into a DB account with an OS account? They can host to a prompt now, but they can't do anything useful from there, since $ORACLE_HOME is the only thing in their PATH...just wondered if there is an easy way to prevent the use of the host command all together. TIA! The contents of this e-mail are intended for the named addressee only. It contains information that may be confidential. Unless you are the named addressee or an authorized designee, you may not copy or use it, or disclose it to anyone else. If you received it in error please notify us immediately and then destroy it.
RE: UPDATE Results
Title: UPDATE Results using sql%rowcount innediately after update statement will give you that value. 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! -Original Message-From: Burton, Laura L. [mailto:[EMAIL PROTECTED]]Sent: Tuesday, May 21, 2002 1:27 PMTo: Multiple recipients of list ORACLE-LSubject: UPDATE Results Is there a way to access 'something' that would denote if any rows were updated? Feedback lets you set up how many rows will be effected before a count is returned, but WHERE is this number coming from? I have found a 'Returning' clause of the update statement, but I don't really want a value returned, just how many rows were affected. We have a situation where we want to know if an update statement actually updated any rows or in fact did not find a row that met the condition. SqlPlus will return '0 rows updated.' Does anyone know where 0 is coming from? Thanks you for your help. Laura *2 This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, attorney work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 and delete this e-mail message from your computer, Thank you. *2
RE: Outstanding bugs in 8.1.7.2
Is there anyway to download the readme file without downloading the whole product set for 8.1.7.3? Thanks, Cherie Jesse, Rich Rich.Jesse@qti To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] world.comcc: Sent by: Subject: RE: Outstanding bugs in 8.1.7.2 [EMAIL PROTECTED] m 05/21/02 11:38 AM Please respond to ORACLE-L A good start would be to get the list of fixes in the README of the 8.1.7.3 bundle for your platform, but I don't know of any comprehensive list. If you find one, let me know! GL! Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 21, 2002 8:43 AM To: Multiple recipients of list ORACLE-L Subject: Outstanding bugs in 8.1.7.2 I've been hunting around OTN and can't remember where to find this. I'd like to see a list of all outstanding bugs that are present in version 8.1.7.2 of EE. Is there one convenient place to find these or am I going to have to compile a list from multiple other versions. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jesse, Rich 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 populate many-to-many
I would follow the exact approach that Forms gives you with drop down lists. You would then have the actual table fields filled in with background/hidden fields within the application. Thank You Stephen P. Karniotis Product Architect Compuware Corporation Direct: (248) 865-4350 Mobile: (248) 408-2918 Email: [EMAIL PROTECTED] Web:www.compuware.com -Original Message- Sent: Tuesday, May 21, 2002 12:14 PM To: Multiple recipients of list ORACLE-L Subject:How to populate many-to-many I am designing a database our software/hardware inventory and there is a many-to-many relationship between 'server' and 'software' table. So I created an association table between them to resolve this. While I believe this is the right thing to do, I am wondering how we are going to populate this association table. It seems to me that we have to create a separate screen for this table to have the users manually enter the data. Right now this table has only three columns - ( server_software_id, server_id, software_id ). Bonus question - if we are going to use Access to manually enter data, is there any way we can avoid entering the raw numbers ( the association table columns are all numeric ). I remember with Oracle Forms you can set up some kind of drop down list where you pick the text value and the ids get populated behind the scene. I am not a fan of Access, can we do something similar? TIA Dennis Meng Database Administrator Focal Communications Corp. -- 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). The contents of this e-mail are intended for the named addressee only. It contains information that may be confidential. Unless you are the named addressee or an authorized designee, you may not copy or use it, or disclose it to anyone else. If you received it in error please notify us immediately and then destroy it. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Karniotis, Stephen 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: host from SQL prompt
See the following link http://soi3.mmtel.ru/books/oracle8-how-to/chap1_11.html http://soi3.mmtel.ru/books/oracle8-how-to/chap1_11.html which gives some details on using product_user_profile. I'm assuming it'll be the same for higher versions. Iain Nicoll -Original Message- Sent: Tuesday, May 21, 2002 5:39 PM To: Multiple recipients of list ORACLE-L How can I prevent users from typing host to get to an OS prompt while logged into a DB account with an OS account? They can host to a prompt now, but they can't do anything useful from there, since $ORACLE_HOME is the only thing in their PATH...just wondered if there is an easy way to prevent the use of the host command all together. TIA! -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Nicoll, Iain (Calanais) 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).
PLS-908
Can't see anything on metalink regarding this error over a database link. We have an 8.1.6 database trying to execute a package on a 7.3.2.3 database and it's giving the following error. Any solution other than upgrade? ORA-04052: error occurred when looking up remote object TEST1.TEST_PKG@SANDBOX ORA-06541: PL/SQL: compilation error - compilation aborted ORA-06553: PLS-908: The stored format of TEST1.TEST_PKG@SANDBOX is not supported by this release TIA Iain Nicoll Test and Release De-Regulated Services Internal : 700 2331 External : 0141 568 2331 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Nicoll, Iain (Calanais) 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: UPDATE Results
Title: UPDATE Results Thank you. This worked great!! -Original Message- From: Jamadagni, Rajendra [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 21, 2002 12:45 PM To: Multiple recipients of list ORACLE-L Subject: RE: UPDATE Results using sql%rowcount innediately after update statement will give you that value. 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! -Original Message- From: Burton, Laura L. [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 21, 2002 1:27 PM To: Multiple recipients of list ORACLE-L Subject: UPDATE Results Is there a way to access 'something' that would denote if any rows were updated? Feedback lets you set up how many rows will be effected before a count is returned, but WHERE is this number coming from? I have found a 'Returning' clause of the update statement, but I don't really want a value returned, just how many rows were affected. We have a situation where we want to know if an update statement actually updated any rows or in fact did not find a row that met the condition. SqlPlus will return '0 rows updated.' Does anyone know where 0 is coming from? Thanks you for your help. Laura
complementary Conference passes
we have received information on complementary registrations to odtug 2002. If you are interested, let me know and I will forward the email. Keith __ Do You Yahoo!? LAUNCH - Your Yahoo! Music Experience http://launch.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Keith Peterson 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: UPDATE Results
Title: UPDATE Results If you are within a C-type program, the SQLCA contains a field that contains the number of rows updated. Look at the Application Developers Guide for more information. Thank You Stephen P. Karniotis Product Architect Compuware Corporation Direct: (248) 865-4350 Mobile: (248) 408-2918 Email: [EMAIL PROTECTED] Web: www.compuware.com -Original Message- From: Burton, Laura L. [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 21, 2002 1:27 PM To: Multiple recipients of list ORACLE-L Subject: UPDATE Results Is there a way to access 'something' that would denote if any rows were updated? Feedback lets you set up how many rows will be effected before a count is returned, but WHERE is this number coming from? I have found a 'Returning' clause of the update statement, but I don't really want a value returned, just how many rows were affected. We have a situation where we want to know if an update statement actually updated any rows or in fact did not find a row that met the condition. SqlPlus will return '0 rows updated.' Does anyone know where 0 is coming from? Thanks you for your help. Laura The contents of this e-mail are intended for the named addressee only. It contains information that may be confidential. Unless you are the named addressee or an authorized designee, you may not copy or use it, or disclose it to anyone else. If you received it in error please notify us immediately and then destroy it.
Re: ORA_ENCRYPT_LOGIN
I'm not using it, but you can look at the packets too and from the client by setting these lines in the clients sqlnet.ora: TRACE_LEVEL_CLIENT = 16 TRACE_DIRECTORY_CLIENT = some directory TRACE_FILE_CLIENT = some file The output is pretty huge, so you don't want to do this for more than a trivial session before you turn the trace off. -rje R Anyone using this and if so, do you know of a way to verify that the R password is actually being encrypted? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Robert Eskridge 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: host from SQL prompt
Title: RE: host from SQL prompt I wish I could train them like monkeys, but no, it's an account for tech. support and they're ssh'ing into the production box, and I want to limit their access and give them no way to get to a command prompt, if I can avoid it. Would you believe that they were originally setup to get into the box as the owner of the oracle software..SCARY! -Original Message- From: Thomas Day [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 21, 2002 1:21 PM To: Multiple recipients of list ORACLE-L Subject: Re: host from SQL prompt Are they telnetting in to your server and then running SQLPlus at the command prompt or are they running SQLPlus from their client and connecting via SQLNet? If the first, then host will not give them anything that they won't get from the telnet session. If the second, they they'll most likely end up at the ORACLE_HOME\bin prompt of their workstation. Are your users really just trained monkeys in disguise and you don't want them to try to recreate the works of Shakespear via random keystrokes? What's the real issue here? Richard Huntley To: Multiple recipients of list ORACLE-L rhuntley [EMAIL PROTECTED] @mindleaders. cc: com Subject: host from SQL prompt Sent by: root 05/21/2002 12:38 PM Please respond to ORACLE-L How can I prevent users from typing host to get to an OS prompt while logged into a DB account with an OS account? They can host to a prompt now, but they can't do anything useful from there, since $ORACLE_HOME is the only thing in their PATH...just wondered if there is an easy way to prevent the use of the host command all together. TIA! -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Thomas Day 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: complementary Conference passes
Ops. Sorry list. -Original Message- Sent: Tuesday, May 21, 2002 2:01 PM To: Multiple recipients of list ORACLE-L we have received information on complementary registrations to odtug 2002. If you are interested, let me know and I will forward the email. Keith __ Do You Yahoo!? LAUNCH - Your Yahoo! Music Experience http://launch.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Keith Peterson 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).
RE: complementary Conference passes
I am interested. Thanks. [EMAIL PROTECTED] -Original Message- Sent: Tuesday, May 21, 2002 2:01 PM To: Multiple recipients of list ORACLE-L we have received information on complementary registrations to odtug 2002. If you are interested, let me know and I will forward the email. Keith __ Do You Yahoo!? LAUNCH - Your Yahoo! Music Experience http://launch.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Keith Peterson 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).
RE: host from SQL prompt --- LOL
The product profile is the way to go. Richard Huntley To: Multiple recipients of list ORACLE-L rhuntley[EMAIL PROTECTED] @mindleaders.cc: com Subject: RE: host from SQL prompt Sent by: root 05/21/2002 02:12 PM Please respond to ORACLE-L I wish I could train them like monkeys, but no, it's an account for tech. support and they're ssh'ing into the production box, and I want to limit their access and give them no way to get to a command prompt, if I can avoid it. Would you believe that they were originally setup to get into the box as the owner of the oracle software..SCARY! -Original Message- Sent: Tuesday, May 21, 2002 1:21 PM To: Multiple recipients of list ORACLE-L Are they telnetting in to your server and then running SQLPlus at the command prompt or are they running SQLPlus from their client and connecting via SQLNet? If the first, then host will not give them anything that they won't get from the telnet session. If the second, they they'll most likely end up at the ORACLE_HOME\bin prompt of their workstation. Are your users really just trained monkeys in disguise and you don't want them to try to recreate the works of Shakespear via random keystrokes? What's the real issue here? Richard Huntley To: Multiple recipients of list ORACLE-L rhuntley [EMAIL PROTECTED] @mindleaders. cc: com Subject: host from SQL prompt Sent by: root 05/21/2002 12:38 PM Please respond to ORACLE-L How can I prevent users from typing host to get to an OS prompt while logged into a DB account with an OS account? They can host to a prompt now, but they can't do anything useful from there, since $ORACLE_HOME is the only thing in their PATH...just wondered if there is an easy way to prevent the use of the host command all together. TIA! -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Thomas Day 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: Thomas Day 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: Outstanding bugs in 8.1.7.2
I've dumped the Solaris one to: http://www.westbend.net/~legoman/readme_solaris_8173.html HTH! GL! :) Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 21, 2002 12:45 PM To: Multiple recipients of list ORACLE-L Subject: RE: Outstanding bugs in 8.1.7.2 Is there anyway to download the readme file without downloading the whole product set for 8.1.7.3? Thanks, Cherie -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jesse, Rich 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).
Free ODTUG2002 registrations
Chris, the info. is at: https://www.odtug.com/ssl/2002_reg_iraje.asp Keith Date: Tue, 21 May 2002 10:29:45 -0800 To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] I am interested. Thanks. [EMAIL PROTECTED] -Original Message- Sent: Tuesday, May 21, 2002 2:01 PM To: Multiple recipients of list ORACLE-L we have received information on complementary registrations to odtug 2002. If you are interested, let me know and I will forward the email. Keith __ Do You Yahoo!? LAUNCH - Your Yahoo! Music Experience http://launch.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Keith Peterson 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).
OS patches required by Oracle
Hi. How do I find the list of OS patches that are required by Oracle 8.1.7 on DYNIX. I have looked at both melink and ibm.com sites, but couldn't find the info there. Am I looking at wrong places? thanks Gene __ Do You Yahoo!? LAUNCH - Your Yahoo! Music Experience http://launch.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gurelei 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: Export problem
But why would you want to? If you export using the 7.3.3 database using the 7.3.3 export utility you should be able to import it into your 8.1.7 database using the 8.1.7 import utility. It's backward compatible. You just can't go the other way (import an 8.1.7 export to 7.3.3). Jay Miller -Original Message- Sent: Tuesday, May 21, 2002 8:58 AM To: Multiple recipients of list ORACLE-L Hi! Can I export a 7.3.3 database with a 8.1.7 export utility? Theoretically it should work. EXP-8: ORACLE error 942 encountered ORA-00942: Tabelle oder View nicht vorhanden EXP-00024: Export views not installed, please notify your DBA EXP-0: Export terminated unsuccessfully But why am I getting these error messges? What scripts need to be run to solve this problem? This is 7.3.3 / 8.1.7 on Win NT. Thanks, Helmut -- 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).
RE: OS patches required by Oracle
Is Dynix still supported by Oracle? I thought they cancelled support for that OS. Thank You Stephen P. Karniotis Product Architect Compuware Corporation Direct: (248) 865-4350 Mobile: (248) 408-2918 Email: [EMAIL PROTECTED] Web:www.compuware.com -Original Message- Sent: Tuesday, May 21, 2002 2:55 PM To: Multiple recipients of list ORACLE-L Subject:OS patches required by Oracle Hi. How do I find the list of OS patches that are required by Oracle 8.1.7 on DYNIX. I have looked at both melink and ibm.com sites, but couldn't find the info there. Am I looking at wrong places? thanks Gene __ Do You Yahoo!? LAUNCH - Your Yahoo! Music Experience http://launch.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gurelei 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). The contents of this e-mail are intended for the named addressee only. It contains information that may be confidential. Unless you are the named addressee or an authorized designee, you may not copy or use it, or disclose it to anyone else. If you received it in error please notify us immediately and then destroy it. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Karniotis, Stephen 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: init.ora params for quick i/0
Silly question maybe, but have you verified that those kaio call are succeeding? Their mere appearance in the truss output only verifies async is being attempted. If the kaio calls fail, they fall back on standard io calls. Since you're on solaris, pick up Adrian Cockroft's Sun tuning book, you will find it invaluable. Jared [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 05/21/2002 09:13 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:init.ora params for quick i/0 Hello, We have implemented quick i/o on a sun server running solaris 8 and Oracle 8173. I have set disk_asynch to true. I have verified using truss that dbwr is making kaio calls. Is there anything I am missing on the db side to make proper use of quick i/o ? Also, I am noticing heavy I/O related waits for a process (db file sequential read, db file parallel write etc..) and would like to involve our sys admin in tuning this particular process..If anyone has any idea what I can specifically ask the sys admin to look at, please do let me know.. I really appreciate any feedback I could get.. Thanks Mohammed Ahsanuddin Oracle DBA -- 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: patching 8.1.7
Most of us on the list would probably recommend that you patch to 8.1.7.2.x, though you probably should check the patch readmes on MetaLink and check for RMAN bugs. Jared Ruth Gramolini [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 05/21/2002 05:48 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:patching 8.1.7 Good morning all, They are finally going to let me install 8.1.7 and try it on my little database that hold my recovery catalog and OEM repository. I would like to know if I will have to apply a patch before using it. We are on AIX 4.3.3. Thanks in advance, Ruth -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ruth Gramolini 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: Data Warehouse experts, a simple question for you
Yup, $60, and worth every penny.
It may be 4 years old, but the information is still pertinent.
Jared
Joe Testa [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
05/20/2002 05:53 PM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc:
Subject:Re: Data Warehouse experts, a simple question for you
looks like published aug of 98 for that book?, like $60?
joe
[EMAIL PROTECTED] wrote:
Joe,
Add a generated PK to the time dimension. The PK is stored
as an FK in the fact table.
That way you can select from the time dimension by year, day, qtr,
whatever,
and easily pick out the correct fact table rows.
The Data Warehouse Lifecycle Toolkit includes a spreadsheet to generate
the DDL/DML for a very robust time dimension. I think it has about 20
columns.
Very good book, can't recommend it enough.
Jared
Joe Testa [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
05/20/2002 04:08 PM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L
[EMAIL PROTECTED]
cc:
Subject:Data Warehouse experts, a simple question for you
Ok i'm messing with dimensions.
dm_time to be exact:
create table dm_time
( calendar_date date not null,
calendar_month number(2) not null,
calendar_qtr number(1) not null,
calendar_year number(4) not null);
insert into dm_time values(to_date('20020101','MMDD'), 1,1,2002);
insert into dm_time values(to_date('20030101','MMDD'), 1,1,2003);
2 rows nice and simple
trying to validate the dimension comes up with an error, my guess is
because of the design of the table
where basically calendar_date is child of
calendar_month is child of calendar_qtr is child of calendar_year,
wont validate.
- the question i have is this, should month really be like 2002-01 with
the year included, likewise with qtr, then it
will validate ok.
Was the design of dm_time just dont wrong or am i missing something here.
thanks, joe
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Joe 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 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: Korn Shell Sqlplus
Stephane Faroult wrote: Killing Oracle server processes is definitely bad manners. Especially if you are using MTS. Even if you are not, the proper way to kill an Oracle process is to use ALTER SYSTEM KILL SESSION. I think that you should use the DBMS_APPLICATION_INFO package to set something like 'Hey! Shoot me!' in your CLIENT_INFO column in V$PROCESS - it would make it easier to another process to log as DBA, spot the process and bang. - Stephane, We will certainly disagree on that. I contend that you should *always* kill the process first. The reason being that using 'ALTER SYSTEM KILL SESSION' has a nasty habit of hanging sessions that are holding locks. I've seen it happen on all versions from 7.0.16 - 8.1.6, on DG/UX, Windows NT 4.0 and Solaris 2.5 - 2.6. It has become my habit to always kill the process ( if dedicated server ) or NT thread first. If the session still appears in v$session, use ALTER SYSTEM KILL SESSION to finish it off. Works every time. Doing it Oracle's way has necessitated too many database bounces for my tastes. Jared -- 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: I/O EVENTS
Go ahead an post an informative example of how the v$ views don't allow you to diagnose a specific problem, and how Precise products do. We wanna know, and I don't imagine he'll mind. Indeed I won't mind. Go ahead, tell us. :) Jared Greg Moore [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 05/21/2002 12:13 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:Re: I/O EVENTS So just looking at v$system_event is dangerous. Looking v$system_event and v$sysstat is much better but still not perfect. The third way is ... (mail me ;-)) Anjo, Jared has an even hand on the tiller. Go ahead an post an informative example of how the v$ views don't allow you to diagnose a specific problem, and how Precise products do. We wanna know, and I don't imagine he'll mind. These little hints, and half sentences that end with an ellipsis, are getting on my nerves! ;-) - Greg -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Greg Moore 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).
Shared Pool Tuneup
Hi List, I have run some scripts for Tune up shared pool,here is the result of one script which i run : Script: SELECT name,sharable_mem FROM v$db_object_cache WHERE sharable_mem 1 AND (TYPE = 'PACKAGE' OR TYPE = 'PACKAGE BODY' OR TYPE = 'FUNCTION' OR TYPE = 'PROCEDURE') AND KEPT = 'NO' ORDER BY 2 DESC here is the result: NAMESHARABLE_MEM - -- DBMS_JAVA 56373 DBMS_STANDARD 24405 DBMS_UTILITY24212 DBMS_SPACE_ADMIN20832 DBMS_UTILITY20508 DBMS_JAVA 15189 DBMS_OUTPUT 13063 DBMS_APPLICATION_INFO 12461 DBMS_SHARED_POOL11148 DBMS_SHARED_POOL10648 Question is, do i have to pin all of these objects in my shared_pool or NOT? Thanks Hamid Alavi Office 818 737-0526 Cell818 402-1987 === Confidentiality Statement === 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. = End Confidentiality Statement = -- 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).
Re: Data Warehouse experts, a simple question for you
it's cheaper on bookpool :)
especially when Borders is out of stock
you guys are killing my credit card! I went out and bought Inmon's
Building the Data Warehouse, BOTH Kimball books and and considering the
Webhouse one as well geez, when do I have time to READ this stuff?
Rachel
--- [EMAIL PROTECTED] wrote:
Yup, $60, and worth every penny.
It may be 4 years old, but the information is still pertinent.
Jared
Joe Testa [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
05/20/2002 05:53 PM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L
[EMAIL PROTECTED]
cc:
Subject:Re: Data Warehouse experts, a simple question
for you
looks like published aug of 98 for that book?, like $60?
joe
[EMAIL PROTECTED] wrote:
Joe,
Add a generated PK to the time dimension. The PK is stored
as an FK in the fact table.
That way you can select from the time dimension by year, day, qtr,
whatever,
and easily pick out the correct fact table rows.
The Data Warehouse Lifecycle Toolkit includes a spreadsheet to
generate
the DDL/DML for a very robust time dimension. I think it has about
20
columns.
Very good book, can't recommend it enough.
Jared
Joe Testa [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
05/20/2002 04:08 PM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L
[EMAIL PROTECTED]
cc:
Subject:Data Warehouse experts, a simple question
for you
Ok i'm messing with dimensions.
dm_time to be exact:
create table dm_time
( calendar_date date not null,
calendar_month number(2) not null,
calendar_qtr number(1) not null,
calendar_year number(4) not null);
insert into dm_time values(to_date('20020101','MMDD'),
1,1,2002);
insert into dm_time values(to_date('20030101','MMDD'),
1,1,2003);
2 rows nice and simple
trying to validate the dimension comes up with an error, my guess
is
because of the design of the table
where basically calendar_date is child of
calendar_month is child of calendar_qtr is child of
calendar_year,
wont validate.
- the question i have is this, should month really be like 2002-01
with
the year included, likewise with qtr, then it
will validate ok.
Was the design of dm_time just dont wrong or am i missing something
here.
thanks, joe
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Joe 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 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).
__
Do You Yahoo!?
LAUNCH - Your Yahoo! Music Experience
http://launch.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).
Monitoring Oracle License
How does one monitor oracle license, is v$license the only option? Is this useful in case of processor based license? Thanks 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! ***1 This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, attorney work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify ESPN at (860) 766-2000 and delete this e-mail message from your computer, Thank you. ***1
DB Freeze
Last Friday, our 9012 database froze, I mean the only way we could get in was through sqlplus, no other tool would connect. We needed to bring the other side up as soon as possible so didn't spend any time running any queries to see what was the problem. The other side (of the cluster) wouldn't come up because it reported that some resource it needed was locked. So we had to shot the pmon process. When analyzing the situation later, we found that Oracle didn't dump a single useful trace file, so contacting OWS was pretty much useless. OS logs were clean, no alarms raised there. Has anyone encountered this situation that Oracle freezes and crashes without any trace files? How does one collect useful information in such cases? Are there any tools that we could use to gather at-lease some information before the DB crashes? Thanks in advance for any ideas and tips. 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! *2 This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, attorney work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 and delete this e-mail message from your computer, Thank you. *2
Re: Data Warehouse experts, a simple question for you
I second that emotion. the guy that wrote it is a PhD
and owns Red Brick or something. totally knows what he
is talking about. One of my top five books, best
warehousing book by far I have ever read.
/jack silvey
--- [EMAIL PROTECTED] wrote:
Yup, $60, and worth every penny.
It may be 4 years old, but the information is still
pertinent.
Jared
Joe Testa [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
05/20/2002 05:53 PM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L
[EMAIL PROTECTED]
cc:
Subject:Re: Data Warehouse experts,
a simple question for you
looks like published aug of 98 for that book?, like
$60?
joe
[EMAIL PROTECTED] wrote:
Joe,
Add a generated PK to the time dimension. The PK
is stored
as an FK in the fact table.
That way you can select from the time dimension by
year, day, qtr,
whatever,
and easily pick out the correct fact table rows.
The Data Warehouse Lifecycle Toolkit includes a
spreadsheet to generate
the DDL/DML for a very robust time dimension. I
think it has about 20
columns.
Very good book, can't recommend it enough.
Jared
Joe Testa [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
05/20/2002 04:08 PM
Please respond to ORACLE-L
To: Multiple recipients of list
ORACLE-L
[EMAIL PROTECTED]
cc:
Subject:Data Warehouse experts, a
simple question for you
Ok i'm messing with dimensions.
dm_time to be exact:
create table dm_time
( calendar_date date not null,
calendar_month number(2) not null,
calendar_qtr number(1) not null,
calendar_year number(4) not null);
insert into dm_time
values(to_date('20020101','MMDD'), 1,1,2002);
insert into dm_time
values(to_date('20030101','MMDD'), 1,1,2003);
2 rows nice and simple
trying to validate the dimension comes up with an
error, my guess is
because of the design of the table
where basically calendar_date is child of
calendar_month is child of calendar_qtr is
child of calendar_year,
wont validate.
- the question i have is this, should month really
be like 2002-01 with
the year included, likewise with qtr, then it
will validate ok.
Was the design of dm_time just dont wrong or am i
missing something here.
thanks, joe
--
Please see the official ORACLE-L FAQ:
http://www.orafaq.com
--
Author: Joe 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 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).
__
Do You Yahoo!?
LAUNCH - Your Yahoo! Music Experience
http://launch.yahoo.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Jack Silvey
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).
Export 7.3.4 / Import 8.1.7
I need a full export of a 7.3.4 database that will be imported into a 8.1.7 database. I know there are several ways to do this. I would like to import as much as I can, (grants, users, etc...) in one pass if I can. Will an import full ignore=y work or will it complain about the different versions? Any Suggestions? Ron Smith -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Smith, Ron L. 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:RE: OS patches required by Oracle
You be right!! Dick Goulet Reply Separator Author: Karniotis; Stephen [EMAIL PROTECTED] Date: 5/21/2002 11:22 AM Is Dynix still supported by Oracle? I thought they cancelled support for that OS. Thank You Stephen P. Karniotis Product Architect Compuware Corporation Direct: (248) 865-4350 Mobile: (248) 408-2918 Email: [EMAIL PROTECTED] Web:www.compuware.com -Original Message- Sent: Tuesday, May 21, 2002 2:55 PM To: Multiple recipients of list ORACLE-L Hi. How do I find the list of OS patches that are required by Oracle 8.1.7 on DYNIX. I have looked at both melink and ibm.com sites, but couldn't find the info there. Am I looking at wrong places? thanks Gene __ Do You Yahoo!? LAUNCH - Your Yahoo! Music Experience http://launch.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gurelei 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). The contents of this e-mail are intended for the named addressee only. It contains information that may be confidential. Unless you are the named addressee or an authorized designee, you may not copy or use it, or disclose it to anyone else. If you received it in error please notify us immediately and then destroy it. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Karniotis, Stephen 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: Data Warehouse experts, a simple question for you
I find that if I wrap my books in Saran Wrap, I can
read in the shower. And if you prop the book up on
your shoulder, you can read it backwards in the
rearview mirror during drive time. Also, if you learn
to read in your sleep, you can get LOADS of stuff
done.
;)
hth,
/jack silvey
--- Rachel Carmichael [EMAIL PROTECTED] wrote:
it's cheaper on bookpool :)
especially when Borders is out of stock
you guys are killing my credit card! I went out and
bought Inmon's
Building the Data Warehouse, BOTH Kimball books and
and considering the
Webhouse one as well geez, when do I have time
to READ this stuff?
Rachel
--- [EMAIL PROTECTED] wrote:
Yup, $60, and worth every penny.
It may be 4 years old, but the information is
still pertinent.
Jared
Joe Testa [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
05/20/2002 05:53 PM
Please respond to ORACLE-L
To: Multiple recipients of list
ORACLE-L
[EMAIL PROTECTED]
cc:
Subject:Re: Data Warehouse
experts, a simple question
for you
looks like published aug of 98 for that book?,
like $60?
joe
[EMAIL PROTECTED] wrote:
Joe,
Add a generated PK to the time dimension. The PK
is stored
as an FK in the fact table.
That way you can select from the time dimension
by year, day, qtr,
whatever,
and easily pick out the correct fact table rows.
The Data Warehouse Lifecycle Toolkit includes a
spreadsheet to
generate
the DDL/DML for a very robust time dimension. I
think it has about
20
columns.
Very good book, can't recommend it enough.
Jared
Joe Testa [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
05/20/2002 04:08 PM
Please respond to ORACLE-L
To: Multiple recipients of list
ORACLE-L
[EMAIL PROTECTED]
cc:
Subject:Data Warehouse experts, a
simple question
for you
Ok i'm messing with dimensions.
dm_time to be exact:
create table dm_time
( calendar_date date not null,
calendar_month number(2) not null,
calendar_qtr number(1) not null,
calendar_year number(4) not null);
insert into dm_time
values(to_date('20020101','MMDD'),
1,1,2002);
insert into dm_time
values(to_date('20030101','MMDD'),
1,1,2003);
2 rows nice and simple
trying to validate the dimension comes up with
an error, my guess
is
because of the design of the table
where basically calendar_date is child of
calendar_month is child of calendar_qtr is
child of
calendar_year,
wont validate.
- the question i have is this, should month
really be like 2002-01
with
the year included, likewise with qtr, then it
will validate ok.
Was the design of dm_time just dont wrong or am i
missing something
here.
thanks, joe
--
Please see the official ORACLE-L FAQ:
http://www.orafaq.com
--
Author: Joe 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 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).
__
Do You Yahoo!?
LAUNCH - Your Yahoo! Music Experience
http://launch.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)
=== message truncated ===
__
Do You Yahoo!?
LAUNCH - Your Yahoo! Music Experience
http://launch.yahoo.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Jack Silvey
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public
ITL Deadlock Example?
Can someone post an example of how to trigger a deadlock (ORA-0060) due to ITL shortage? This is for informational/fact-finding purposes. I've created a test table with MAXTRANS=1 and can cause the enqueue waits between two sessions contending for the same block but I can't seem to cause a deadlock to occur. Thanks. -w -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Walter K 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: patching 8.1.7
BTW, looks like 8.1.7.4 has been released for most platforms. Just downloaded HP-UX and linux today. Ron Thomas Hypercom, Inc [EMAIL PROTECTED] The problem with some people is that when they aren't drunk, they're sober. --William Butler Yeats. Jared.Still@radis ys.com To: [EMAIL PROTECTED] Sent by: cc: [EMAIL PROTECTED] Subject: Re: patching 8.1.7 05/21/02 12:29 PM Please respond to ORACLE-L Most of us on the list would probably recommend that you patch to 8.1.7.2.x, though you probably should check the patch readmes on MetaLink and check for RMAN bugs. Jared Ruth Gramolini [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 05/21/2002 05:48 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:patching 8.1.7 Good morning all, They are finally going to let me install 8.1.7 and try it on my little database that hold my recovery catalog and OEM repository. I would like to know if I will have to apply a patch before using it. We are on AIX 4.3.3. Thanks in advance, Ruth -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ruth Gramolini 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: Ron Thomas 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: Outstanding bugs in 8.1.7.2
Cherie, The majority of the documentation is available for download at http://docs.oracle.com click on database and then the version and OS you want. Ron ROR mô¿ôm [EMAIL PROTECTED] 05/21/02 02:39PM I've dumped the Solaris one to: http://www.westbend.net/~legoman/readme_solaris_8173.html HTH! GL! :) Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 21, 2002 12:45 PM To: Multiple recipients of list ORACLE-L Subject: RE: Outstanding bugs in 8.1.7.2 Is there anyway to download the readme file without downloading the whole product set for 8.1.7.3? Thanks, Cherie -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jesse, Rich 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 Rogers 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: UPDATE Results
Burton, Laura L. wrote: Is there a way to access 'something' that would denote if any rows were updated? Feedback lets you set up how many rows will be effected before a count is returned, but WHERE is this number coming from? I have found a 'Returning' clause of the update statement, but I don't really want a value returned, just how many rows were affected. We have a situation where we want to know if an update statement actually updated any rows or in fact did not find a row that met the condition. SqlPlus will return '0 rows updated.' Does anyone know where 0 is coming from? Thanks you for your help. Laura Anonymous PL/SQL block. Check SQL%ROWCOUNT and if needed use raise_application_error. You can then abort the process with WHENEVER SQLERROR at the SQL*Plus level. If you need to do something more subtle, stay inside the PL/SQL block. -- Regards, Stephane Faroult Oriole Software -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephane Faroult 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: Shared Pool Tuneup
Hamid, what happens , if an object is getting executed once in a while but takes huge sharable memory, we may not be getting full use of pinning it in the shared pool, except wasting the memory, So we need to consider the number of executions also. if the number of executions are high for any object/SQL, its good idea to keep it in shared pool. --Madhu -Original Message- Sent: Tuesday, May 21, 2002 2:47 PM To: Multiple recipients of list ORACLE-L Hi List, I have run some scripts for Tune up shared pool,here is the result of one script which i run : Script: SELECT name,sharable_mem FROM v$db_object_cache WHERE sharable_mem 1 AND (TYPE = 'PACKAGE' OR TYPE = 'PACKAGE BODY' OR TYPE = 'FUNCTION' OR TYPE = 'PROCEDURE') AND KEPT = 'NO' ORDER BY 2 DESC here is the result: NAMESHARABLE_MEM - -- DBMS_JAVA 56373 DBMS_STANDARD 24405 DBMS_UTILITY24212 DBMS_SPACE_ADMIN20832 DBMS_UTILITY20508 DBMS_JAVA 15189 DBMS_OUTPUT 13063 DBMS_APPLICATION_INFO 12461 DBMS_SHARED_POOL11148 DBMS_SHARED_POOL10648 Question is, do i have to pin all of these objects in my shared_pool or NOT? Thanks Hamid Alavi Office 818 737-0526 Cell818 402-1987 === Confidentiality Statement === 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. = End Confidentiality Statement = -- 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: Reddy, Madhusudana 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: Korn Shell Sqlplus
I must agree with Jared on this practice. By following this practice, you never bounce database to just get rid of hanging sessions holding locks as some listers are complaining about that they had to bounce database to get rid of hanging sessions becuase they killed process on database level first. Regards Rafiq Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Date: Tue, 21 May 2002 11:47:10 -0800 Stephane Faroult wrote: Killing Oracle server processes is definitely bad manners. Especially if you are using MTS. Even if you are not, the proper way to kill an Oracle process is to use ALTER SYSTEM KILL SESSION. I think that you should use the DBMS_APPLICATION_INFO package to set something like 'Hey! Shoot me!' in your CLIENT_INFO column in V$PROCESS - it would make it easier to another process to log as DBA, spot the process and bang. - Stephane, We will certainly disagree on that. I contend that you should *always* kill the process first. The reason being that using 'ALTER SYSTEM KILL SESSION' has a nasty habit of hanging sessions that are holding locks. I've seen it happen on all versions from 7.0.16 - 8.1.6, on DG/UX, Windows NT 4.0 and Solaris 2.5 - 2.6. It has become my habit to always kill the process ( if dedicated server ) or NT thread first. If the session still appears in v$session, use ALTER SYSTEM KILL SESSION to finish it off. Works every time. Doing it Oracle's way has necessitated too many database bounces for my tastes. Jared -- 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). MOHAMMAD RAFIQ _ Send and receive Hotmail on your mobile device: http://mobile.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mohammad Rafiq 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: host from SQL prompt
Richard Huntley wrote: How can I prevent users from typing host to get to an OS prompt while logged into a DB account with an OS account? They can host to a prompt now, but they can't do anything useful from there, since $ORACLE_HOME is the only thing in their PATH...just wondered if there is an easy way to prevent the use of the host command all together. TIA! Look for PRODUCT_USER_PROFILE in the SQL*Plus reference guide. -- Regards, Stephane Faroult Oriole Software -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephane Faroult 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).
ID This Wait stat
You know I could have all the documentation for Oracle printed on my brain, buy all the books ever written about the subject, but the primary wait problem that comes up will never be directly addressed. So, what exactly does 'Slave Wait' mean and what can I do about it? I am using DBWR Slaves, since it did not seem as though starting additional DBWR's was appropriate on a Win2000 system. Here are the Top 5 wait events as per Statpack and my shinny new 'Oracle Performance Tuning 101' book: Top 5 Wait Events ~ Wait % Total Event Waits Time (cs) Wt Time - -- slave wait 66,5936,793,939 88.85 PX Deq: Execution Msg 28,960 407,167 5.33 PX Deq: Table Q Normal 19,864 302,480 3.96 PX Deq Credit: send blkd3,685 123,671 1.62 PX Deq: Signal ACK 3,2145,294 .07 I have a pretty good idea that 2-5 are for parallel query option, although I still have to figure out just what they mean. Any help would be greatly appreciated. _ Tom Schruefer - [EMAIL PROTECTED] 410-313-6825 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Tom Schruefer 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: Statspack Problem
I ran 'statscre' again and got the same message again. It seemed to prevent SQL*Plus from logging into any account. So, I quit, re-started SQL*Plus and logged in as Perfstat and ran the remaining two scripts, which then completed without incident. I have been able to take a couple snapshots with statspack over the last 3 hours and now I have another question. But new question, new email. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Tom Schruefer Sent: Tuesday, May 21, 2002 11:53 AM To: Multiple recipients of list ORACLE-L Subject: RE: Statspack Problem -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Reardon, Bruce (CALBBAY) Sent: Monday, May 20, 2002 10:08 PM To: Multiple recipients of list ORACLE-L Subject: RE: Statspack Problem Have you connected via BEQ or Net8 initially? Have you got oracle_sid set as an environment variable, as it looks like the connect perfstat/perfstat uses a BEQ connection. It does not look as though the SID_NAME parameter was set on the system I was trying to install too. Although it was set on my test system, maybe thats why it worked in test but not production. Anyway, I am off to try again. Thanks for the idea. After connecting as sys, can you now do a connect perfstat/perfstat (though maybe the scripts cleaned up on error and deleted the perfstat user. Yes, I can login as 'perfstat', and any other user as well, it looks like the script was able to create the user. HTH, Bruce Reardon -Original Message- Sent: Tuesday, 21 May 2002 11:39 I am running 8.1.6 on a Win2000 SP2 machine. When I try running 'statscre.sql' as SYS, the first script completes fine, but when the second script tries to connect perfstat/perfstat , I get the error, You are no longer connected to Oracle TNS:ORA-12154. Of course the system then proceeds to attempt to run the other two scripts returning about a hundred not connected error messages. The Perfstat user was created and I did not have the chance to intervene and change its password. Any ideas as to why the script would fail to connect? I connected as internal in the first place to run the script, so I don't think its TNS. Tom Schruefer - [EMAIL PROTECTED] 410-313-6825 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Reardon, Bruce (CALBBAY) 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: Tom Schruefer 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: Tom Schruefer 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: Data Warehouse experts, a simple question for you
gee, and here I thought all I had to do was put the book under my
pillow and let the words seep in through osmosis :)
--- Jack Silvey [EMAIL PROTECTED] wrote:
I find that if I wrap my books in Saran Wrap, I can
read in the shower. And if you prop the book up on
your shoulder, you can read it backwards in the
rearview mirror during drive time. Also, if you learn
to read in your sleep, you can get LOADS of stuff
done.
;)
hth,
/jack silvey
--- Rachel Carmichael [EMAIL PROTECTED] wrote:
it's cheaper on bookpool :)
especially when Borders is out of stock
you guys are killing my credit card! I went out and
bought Inmon's
Building the Data Warehouse, BOTH Kimball books and
and considering the
Webhouse one as well geez, when do I have time
to READ this stuff?
Rachel
--- [EMAIL PROTECTED] wrote:
Yup, $60, and worth every penny.
It may be 4 years old, but the information is
still pertinent.
Jared
Joe Testa [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
05/20/2002 05:53 PM
Please respond to ORACLE-L
To: Multiple recipients of list
ORACLE-L
[EMAIL PROTECTED]
cc:
Subject:Re: Data Warehouse
experts, a simple question
for you
looks like published aug of 98 for that book?,
like $60?
joe
[EMAIL PROTECTED] wrote:
Joe,
Add a generated PK to the time dimension. The PK
is stored
as an FK in the fact table.
That way you can select from the time dimension
by year, day, qtr,
whatever,
and easily pick out the correct fact table rows.
The Data Warehouse Lifecycle Toolkit includes a
spreadsheet to
generate
the DDL/DML for a very robust time dimension. I
think it has about
20
columns.
Very good book, can't recommend it enough.
Jared
Joe Testa [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
05/20/2002 04:08 PM
Please respond to ORACLE-L
To: Multiple recipients of list
ORACLE-L
[EMAIL PROTECTED]
cc:
Subject:Data Warehouse experts, a
simple question
for you
Ok i'm messing with dimensions.
dm_time to be exact:
create table dm_time
( calendar_date date not null,
calendar_month number(2) not null,
calendar_qtr number(1) not null,
calendar_year number(4) not null);
insert into dm_time
values(to_date('20020101','MMDD'),
1,1,2002);
insert into dm_time
values(to_date('20030101','MMDD'),
1,1,2003);
2 rows nice and simple
trying to validate the dimension comes up with
an error, my guess
is
because of the design of the table
where basically calendar_date is child of
calendar_month is child of calendar_qtr is
child of
calendar_year,
wont validate.
- the question i have is this, should month
really be like 2002-01
with
the year included, likewise with qtr, then it
will validate ok.
Was the design of dm_time just dont wrong or am i
missing something
here.
thanks, joe
--
Please see the official ORACLE-L FAQ:
http://www.orafaq.com
--
Author: Joe 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 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
=== message truncated ===
__
Do You Yahoo!?
LAUNCH - Your Yahoo! Music Experience
http://launch.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
RE: DB Freeze
Raj: You can dump the SYSTEMSTATE/PROCESSSTATE using ORADEBUG dump and analyze the trace files. Best Regards, K Gopalakrishnan Bangalore, INDIA -Original Message- Rajendra Sent: Tuesday, May 21, 2002 1:00 PM To: Multiple recipients of list ORACLE-L Last Friday, our 9012 database froze, I mean the only way we could get in was through sqlplus, no other tool would connect. We needed to bring the other side up as soon as possible so didn't spend any time running any queries to see what was the problem. The other side (of the cluster) wouldn't come up because it reported that some resource it needed was locked. So we had to shot the pmon process. When analyzing the situation later, we found that Oracle didn't dump a single useful trace file, so contacting OWS was pretty much useless. OS logs were clean, no alarms raised there. Has anyone encountered this situation that Oracle freezes and crashes without any trace files? How does one collect useful information in such cases? Are there any tools that we could use to gather at-lease some information before the DB crashes? Thanks in advance for any ideas and tips. 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! -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: K Gopalakrishnan 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: Export 7.3.4 / Import 8.1.7
Ron, I'm doing the same thing; full export from 7.3.4, full import into 8.1.7.3. I used the 7.3.4 export binary and the 8.1.7 import binary. No complaints about different versions. Mark Stahlke DuhBA Denver Newspaper Agency -Original Message- From: Smith, Ron L. [SMTP:[EMAIL PROTECTED]] Sent: Tuesday, May 21, 2002 2:00 PM To: Multiple recipients of list ORACLE-L Subject:Export 7.3.4 / Import 8.1.7 I need a full export of a 7.3.4 database that will be imported into a 8.1.7 database. I know there are several ways to do this. I would like to import as much as I can, (grants, users, etc...) in one pass if I can. Will an import full ignore=y work or will it complain about the different versions? Any Suggestions? Ron Smith -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Smith, Ron L. 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: Stahlke, Mark 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: host from SQL prompt
Product profile has worked to stop this and others since version 6. It is very easy to create the table and add a row to disable certain types of commands. Don't you just love nosey users :) -Original Message- Sent: Tuesday, May 21, 2002 12:12 PM To: Multiple recipients of list ORACLE-L I wish I could train them like monkeys, but no, it's an account for tech. support and they're ssh'ing into the production box, and I want to limit their access and give them no way to get to a command prompt, if I can avoid it. Would you believe that they were originally setup to get into the box as the owner of the oracle software..SCARY! -Original Message- Sent: Tuesday, May 21, 2002 1:21 PM To: Multiple recipients of list ORACLE-L Are they telnetting in to your server and then running SQLPlus at the command prompt or are they running SQLPlus from their client and connecting via SQLNet? If the first, then host will not give them anything that they won't get from the telnet session. If the second, they they'll most likely end up at the ORACLE_HOME\bin prompt of their workstation. Are your users really just trained monkeys in disguise and you don't want them to try to recreate the works of Shakespear via random keystrokes? What's the real issue here? Richard Huntley To: Multiple recipients of list ORACLE-L rhuntley[EMAIL PROTECTED] @mindleaders.cc: com Subject: host from SQL prompt Sent by: root 05/21/2002 12:38 PM Please respond to ORACLE-L How can I prevent users from typing host to get to an OS prompt while logged into a DB account with an OS account? They can host to a prompt now, but they can't do anything useful from there, since $ORACLE_HOME is the only thing in their PATH...just wondered if there is an easy way to prevent the use of the host command all together. TIA! -- Please see the official ORACLE-L FAQ: http://www.orafaq.com http://www.orafaq.com -- Author: Thomas Day 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: Pass Stephanie 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 enable Java
You don't need this article if in 8.1.6. Java installations and upgrades became a lot more complicated as of 8.1.7. Jay Miller -Original Message- Sent: Tuesday, May 21, 2002 11:53 AM To: Multiple recipients of list ORACLE-L I don't have an account with metalink, and I can't get to this article on technet. Anyplace else to get this. Also, I'm trying to do this in 8.1.6. Thanks, Joe On Tue, 21 May 2002, Rodrigues, Bryan wrote: Hi Joe, Check out oracle document note:156477.1 JVM installation on 8.1.7 for details. Bryan -Original Message- Sent: Tuesday, May 21, 2002 10:18 AM To: Multiple recipients of list ORACLE-L Hi Joe, I think you need to run the following from the sys account /javavm/install/initjvm.sql -- setup database for running Hava and the ORB /rdbms/admin/initplsj.sql -- initializes java libraries for pl/sql There may be other scripts depending on your needs but I think these you must run. System requirements (these are just recommendations) SHARED_POOL_SIZE = 65 MB JAVA_POOL_SIZE = 50 mb 50 MB free in the system tablespace 250 MB of rollback segment space Rick Joe LaCascio jlacasci@whea To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] tonma.edu cc: Sent by: Subject: How to enable Java [EMAIL PROTECTED] om 05/21/2002 09:18 AM Please respond to ORACLE-L Hi folks: I'm installing IAS on our web server which is a DEC Alpha 800, one of the steps says that Java isn't enabled on the database that the IAS will work with. This database TEST is running on a DEC Alpha 4100, the TEST database is an 8.1.6 database. The IAS install says to use dbassist to turn on Java. Okay, I ran dbassist, checked change a database configuration selected TEST and clicked next. A new window pops up, stays blank and nothing happens. No status bar, no info, just the blank window. After 10 minutes I cancelled the process. I've tried this with the database down, and dbassist opens the database. I've tried it with the TEST database up in restricted and still same thing. Any ideas? Any way to enable Java by running a script? 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rodrigues, Bryan 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: 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
RE: DB Freeze
One way is to do a system state dump level 10. It is done either as svrmgrl or as sqlplus with sysdba privileges. You would use the command alter sesssion set events 'immediate trace name systemstate level 10'; (if you do not have a large user dump file capacity you can alter your session to increase it). This needs to be done on all nodes of the cluster while the cluster is hanging. The dump may take up to 10 minutes to complete, but Oracle will require this for their investigation of the issue. The dump files will be found in the udump directory. We are on 8.1.7.2.1 on HP-UX and we had a similar type of problem and Oracle had me do this when it happened. They were able to use the files in their investigation. Good luck with the issue, Bryan -Original Message- Sent: Tuesday, May 21, 2002 4:00 PM To: Multiple recipients of list ORACLE-L Last Friday, our 9012 database froze, I mean the only way we could get in was through sqlplus, no other tool would connect. We needed to bring the other side up as soon as possible so didn't spend any time running any queries to see what was the problem. The other side (of the cluster) wouldn't come up because it reported that some resource it needed was locked. So we had to shot the pmon process. When analyzing the situation later, we found that Oracle didn't dump a single useful trace file, so contacting OWS was pretty much useless. OS logs were clean, no alarms raised there. Has anyone encountered this situation that Oracle freezes and crashes without any trace files? How does one collect useful information in such cases? Are there any tools that we could use to gather at-lease some information before the DB crashes? Thanks in advance for any ideas and tips. 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! -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rodrigues, Bryan 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: Export 7.3.4 / Import 8.1.7
Thanks! -Original Message- Sent: Tuesday, May 21, 2002 3:27 PM To: Multiple recipients of list ORACLE-L Ron, I'm doing the same thing; full export from 7.3.4, full import into 8.1.7.3. I used the 7.3.4 export binary and the 8.1.7 import binary. No complaints about different versions. Mark Stahlke DuhBA Denver Newspaper Agency -Original Message- From: Smith, Ron L. [SMTP:[EMAIL PROTECTED]] Sent: Tuesday, May 21, 2002 2:00 PM To: Multiple recipients of list ORACLE-L Subject:Export 7.3.4 / Import 8.1.7 I need a full export of a 7.3.4 database that will be imported into a 8.1.7 database. I know there are several ways to do this. I would like to import as much as I can, (grants, users, etc...) in one pass if I can. Will an import full ignore=y work or will it complain about the different versions? Any Suggestions? Ron Smith -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Smith, Ron L. 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: Stahlke, Mark 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: Smith, Ron L. 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).
Tru64 Unix and Oracle
Hi all, I am new to the Tru64 flavor of Unix and would like to find out if there are kernal parameters that need to be set for Oracle (similar to the shm parameters on SUN)? Also, I would like to know if there are any other differences in terms of an Oracle installation on Tru64. TIA, Michele Armstrong -- 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).
Appending date to export file name in NT
Hi Everyone, I can easily append the date to my export file names in unix. Can anyone tell me how to do on NT. An example would be great! I've had very little NT experience. Thanks for any help. Shirley :-) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Taylor, Shirley 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: DB Freeze
Kevin, No it wasn't a problem with log_archive_dest or on-line redo logs, these locations have more than enough space allocated. As for redo, we weren't generating much, I mean there were only 2 baseball games going on at that time. We have managed 7 concurrent games and the DB doesn't even show any signs of stress. ps: By managing games, I mean managing updates to the games (baseball/basketball etc), the info, stories, events, player stats, and team stats etc. Thanks for the pointers though ... 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! -Original Message- Sent: Tuesday, May 21, 2002 4:49 PM To: Multiple recipients of list ORACLE-L Do you have archive logging turned on? Yes: Is your log_archive_dest full? Is the directory for your online redo logs full? ***1 This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, attorney work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify ESPN at (860) 766-2000 and delete this e-mail message from your computer, Thank you. ***1
RE: ITL Deadlock Example?
SET PCTFREE=0 and fill the rows in that data block. Then update two DIFFERENT rows in that block from DIFFERENT sessions. You will get the required deadlock !! Best Regards, K Gopalakrishnan Bangalore, INDIA -Original Message- Sent: Tuesday, May 21, 2002 1:14 PM To: Multiple recipients of list ORACLE-L Can someone post an example of how to trigger a deadlock (ORA-0060) due to ITL shortage? This is for informational/fact-finding purposes. I've created a test table with MAXTRANS=1 and can cause the enqueue waits between two sessions contending for the same block but I can't seem to cause a deadlock to occur. Thanks. -w -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Walter K 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: K Gopalakrishnan 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).
