ADMIN: Status of list server systems (and update about missing messages)
Folks -- I have good news and bad news. ;-) First the good news: Several people had mentioned that they've sent messages to some lists but have not seen the posts arrive back to them. These messages DID appear in the archives though. This started roughly 12-Jan-2004. I had previously researched this issue but could find no reason for it happening, nor a solution. Up until today, that is. The cuplrit was one of my load balancers for mailing list traffic. It was handling traffic correctly on some of the machines, but squirreling away messages sent to one specific server. I'd estimate about 1/8th of the messages sent to mailing lists since 12-Jan-2004 were not redistributed properly. I have since found and fixed the problem, so this shouldn't happen in the future. I suspect I was only able to re-send a portion of the missing messages, so my apologies for anyone who posted a message that didn't make it to a list. Also, my apologies to everyone who has to deal with the increased traffic of the old messages, plus current messages, plus the inevitable onslaught of re-posts that will occur in the next few days. Please be patient with each other. So the good news was: problem found, problem fixed, some catch up done, shouldn't happen again. The bad news is that this morning (roughly 7am PST), a construction crew near Fat City cut through a section of telecom cable that was critical for our connection to the net. They've been working feverishly on it all day, but Fat City was off the net most of the day. Until about 3pm PST. I believe things are about back to normal right now, but there's always a ramp-up time to truly get back to normal. My apologies to anyone who was affected by our downtime. If you have any questions or concerns about anything, please let me know. Thanks, Bruce Bergman ListMaster, Fat City Hosting -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Bruce A. Bergman INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: What do these error messages indicate and how to subscribe to developer mailgroup?
Developer is saying that applying patchset 9.2.0.4 broke dbms_sql or changed it so that they cannot compile their procs referencing dbms_sql. Help? -Original Message- Sent: Monday, January 12, 2004 4:27 PM To: '[EMAIL PROTECTED]' to developer mailgroup? 1) Please tell me how to subscribe to Developer mailgroup? 2) Any ideas? Compiling function FUN_CHANGE_PASSWORD... Compilation error on function FUN_CHANGE_PASSWORD: PL/SQL ERROR 801 at line 1, column 1 internal error [1907] PL/SQL ERROR 0 at line 23, column 7 Statement ignored PL/SQL ERROR 801 at line 1, column 1 internal error [1907] PL/SQL ERROR 0 at line 24, column 7 Statement ignored PL/SQL ERROR 801 at line 1, column 1 internal error [1907] PL/SQL ERROR 0 at line 25, column 7 Statement ignored PL/SQL ERROR 801 at line 1, column 1 internal error [1907] PL/SQL ERROR 0 at line 26, column 7 Statement ignored -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: What do these error messages indicate and how to subscribe to developer mailgroup?
Paula, did you try re-running catproc? Did your duhveloper follow the installation instructions to the letter, or creatively, skipping the parts he didn't like? On 01/12/2004 04:34:25 PM, [EMAIL PROTECTED] wrote: Developer is saying that applying patchset 9.2.0.4 broke dbms_sql or changed it so that they cannot compile their procs referencing dbms_sql. Help? -Original Message- Sent: Monday, January 12, 2004 4:27 PM To: '[EMAIL PROTECTED]' to developer mailgroup? 1) Please tell me how to subscribe to Developer mailgroup? 2) Any ideas? Compiling function FUN_CHANGE_PASSWORD... Compilation error on function FUN_CHANGE_PASSWORD: PL/SQL ERROR 801 at line 1, column 1 internal error [1907] PL/SQL ERROR 0 at line 23, column 7 Statement ignored PL/SQL ERROR 801 at line 1, column 1 internal error [1907] PL/SQL ERROR 0 at line 24, column 7 Statement ignored PL/SQL ERROR 801 at line 1, column 1 internal error [1907] PL/SQL ERROR 0 at line 25, column 7 Statement ignored PL/SQL ERROR 801 at line 1, column 1 internal error [1907] PL/SQL ERROR 0 at line 26, column 7 Statement ignored -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Mladen Gogala Oracle DBA -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mladen Gogala INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
messages
Hello list, I am using 9.2.0.1.0 enterprise edition on windows. Earlier when I use to specify nls_lang=French_France.US7ASCII in 9i release 1 I would get the following messages in French c: sqlplus Entrez le nom utilisateur : But now when I specify nls_lang=French_France.US7ASCII , sqlplus sticks to english c: sqlplus Enter user-name: Any ideas ? I tried out the following but to no avail : 1. I specified ora_nls33 to point to D:\OracleXP\Ora92\ocommon\nls\ADMIN\DATA where D:\OracleXP\Ora92\ is my %oracle_home% 2. I set nls_lang=French_France.US7ASCII , log in as a user, checked NLS_SESSION_PARAMETERS. It shows that NLS_LANGUAGE is FRENCH and NLS_TERRITORY is FRANCE. When I select from a column containing dates , the months are in French. sysdate also gives the month in french 3. Same behaviour with nls_lang=French_France.WE8MSWIN1252 and nls_lang=nls_lang=French_France.UTF8 (although this is an incorrect specification since there are no utf8 windows clients ) 4. Similarly when I specify nls_lang=ENGLISH_INDIA.WE8MSWIN1252 my queries pick up the correct local currency symbol. and nls_language and nls_territory values in nls_session_parameters are correct. 5. Alert log doesn't show any errors. My database character set is AL32UTF8 , did not specify an nchar characterset while creating the database. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
messages
Hello list, I am using 9.2.0.1.0 enterprise edition on windows. Earlier when I use to specify nls_lang=French_France.US7ASCII in 9i release 1 I would get the following messages in French c: sqlplus Entrez le nom utilisateur : But now when I specify nls_lang=French_France.US7ASCII , sqlplus sticks to english c: sqlplus Enter user-name: Any ideas ? I tried out the following but to no avail : 1. I specified ora_nls33 to point to D:\OracleXP\Ora92\ocommon\nls\ADMIN\DATA where D:\OracleXP\Ora92\ is my %oracle_home% 2. I set nls_lang=French_France.US7ASCII , log in as a user, checked NLS_SESSION_PARAMETERS. It shows that NLS_LANGUAGE is FRENCH and NLS_TERRITORY is FRANCE. When I select from a column containing dates , the months are in French. sysdate also gives the month in french 3. Same behaviour with nls_lang=French_France.WE8MSWIN1252 and nls_lang=nls_lang=French_France.UTF8 (although this is an incorrect specification since there are no utf8 windows clients ) 4. Similarly when I specify nls_lang=ENGLISH_INDIA.WE8MSWIN1252 my queries pick up the correct local currency symbol. and nls_language and nls_territory values in nls_session_parameters are correct. 5. Alert log doesn't show any errors. My database character set is AL32UTF8 , did not specify an nchar characterset while creating the database. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: how to send messages to other users
Isn't the wall utility used to send a message to everyone in Unix/Linux? i.e wall This Database will Self Destruct in 5 seconds (although the utility has been removed from some systems due to some security problems a.k.a root exploit) p.d : What's Outlook Express??? ;) -Original Message- Mladen Gogala Sent: Tuesday, November 25, 2003 6:39 PM To: Multiple recipients of list ORACLE-L BOFH On unix, there is a utility called init. You should log in as root and type the following: init 0 please log off the oracle database and everybody will get the message. /BOFH Other then that, you could use an exotic utiity called Outlook Express to schedule a database shutdown a week in advance and put the maintenance times on your internal web page. The chosen times should be offpeak so that the normal business can continue. When you inform everybody and schedule downtime in advance, then you simply shut the database down, say, on Saturday, 18:00 hours. In other words, your problem is organizational, not technical. If you need to shut the database down immediately for whatever reason there is a gadget called a telephone. It works like this: every company has a person called CIO (stands for Career Is Over). When you need to shut down a database that is critical for business during the working hours then you tell your boss to call the CIO, and if he's not around, you tell your boss/director to page him (they usually cary beepers). He will then either inform his peers in the business process or schedule a conference call to pass the good news to the business. You are probably going to be on that conference call so better be prepared to argue why is shutting down the database critical or you will be in a very bad predicament. After that, no further information is necessary. You just do what needs to be done. In other words, shutting down an important database is not a DBA decision but a decision made by people who manage the normal business process. Those people are sometimes referred to as management. They are the ones who make decisions and define schedule. On 2003.11.25 20:49, [EMAIL PROTECTED] wrote: hi, I need to send messages like 'system shutting down in 1 min' to all users currently login. How can i do this in oracle or a third party software that i can use? users are connected using web browser. Messages are send over the wan. thanks. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Mladen Gogala Oracle DBA -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mladen Gogala INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: nelson flores INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: how to send messages to other users
Well, init takes one numeric argument (level) and ignores everything else. That means that the command init 0 Please log off the database has the same effect as init 0. Trust me, users will get the message. Did you see the BOFH/BOFH flags? On 11/26/2003 02:09:24 AM, nelson flores wrote: Isn't the wall utility used to send a message to everyone in Unix/Linux? i.e wall This Database will Self Destruct in 5 seconds (although the utility has been removed from some systems due to some security problems a.k.a root exploit) p.d : What's Outlook Express??? ;) -Original Message- Mladen Gogala Sent: Tuesday, November 25, 2003 6:39 PM To: Multiple recipients of list ORACLE-L BOFH On unix, there is a utility called init. You should log in as root and type the following: init 0 please log off the oracle database and everybody will get the message. /BOFH Other then that, you could use an exotic utiity called Outlook Express to schedule a database shutdown a week in advance and put the maintenance times on your internal web page. The chosen times should be offpeak so that the normal business can continue. When you inform everybody and schedule downtime in advance, then you simply shut the database down, say, on Saturday, 18:00 hours. In other words, your problem is organizational, not technical. If you need to shut the database down immediately for whatever reason there is a gadget called a telephone. It works like this: every company has a person called CIO (stands for Career Is Over). When you need to shut down a database that is critical for business during the working hours then you tell your boss to call the CIO, and if he's not around, you tell your boss/director to page him (they usually cary beepers). He will then either inform his peers in the business process or schedule a conference call to pass the good news to the business. You are probably going to be on that conference call so better be prepared to argue why is shutting down the database critical or you will be in a very bad predicament. After that, no further information is necessary. You just do what needs to be done. In other words, shutting down an important database is not a DBA decision but a decision made by people who manage the normal business process. Those people are sometimes referred to as management. They are the ones who make decisions and define schedule. On 2003.11.25 20:49, [EMAIL PROTECTED] wrote: hi, I need to send messages like 'system shutting down in 1 min' to all users currently login. How can i do this in oracle or a third party software that i can use? users are connected using web browser. Messages are send over the wan. thanks. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Mladen Gogala Oracle DBA -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mladen Gogala INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: nelson flores INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Mladen Gogala Oracle DBA Note: This message is for the named person's use only. It may contain confidential, proprietary or legally privileged information
RE: how to send messages to other users
if the messages are sent over WAN, don't you think 1 minute is inadequate time? There is no built in utility in oracle to do what you need. You can however design something using a small java applet that uses dbms_alert and display the message. Raj Rajendra dot Jamadagni at nospamespn dot com All Views expressed in this email are strictly personal. QOTD: Any clod can have facts, having an opinion is an art ! ** 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. **5 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jamadagni, Rajendra INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: how to send messages to other users
If your users are part of your local network, you can use the Windoze NET SEND command. I have recently found that to be useful. UNIX/Linux utilities like 'wall' only send a message to users who are telnet'ed or rlogin'ed to the system. To send a message to a browser is not something I know how to do. However, if it can be done by pop-up windows from folks like X-10, I'm sure it can be done for a useful purpose as well. You need to talk to a web programmer for that, though, not Oracle DBAs. Cheers, Mike -Original Message- Sent: Tuesday, November 25, 2003 5:49 PM To: Multiple recipients of list ORACLE-L hi, I need to send messages like 'system shutting down in 1 min' to all users currently login. How can i do this in oracle or a third party software that i can use? users are connected using web browser. Messages are send over the wan. thanks. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Vergara, Michael (TEM) INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: how to send messages to other users
i can't use net send since not all users in the same local network. i can't also wall since all users are using win98. do u know any 3rd party software like winpop(forlocal network) that can send messages across the network? -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: how to send messages to other users
I think that you're going to have to take Mladen's advice and send an Email to everyone -Original Message- [EMAIL PROTECTED] Sent: Wednesday, November 26, 2003 5:14 PM To: Multiple recipients of list ORACLE-L i can't use net send since not all users in the same local network. i can't also wall since all users are using win98. do u know any 3rd party software like winpop(forlocal network) that can send messages across the network? -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: nelson flores INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
how to send messages to other users
hi, I need to send messages like 'system shutting down in 1 min' to all users currently login. How can i do this in oracle or a third party software that i can use? users are connected using web browser. Messages are send over the wan. thanks. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: how to send messages to other users
BOFH On unix, there is a utility called init. You should log in as root and type the following: init 0 please log off the oracle database and everybody will get the message. /BOFH Other then that, you could use an exotic utiity called Outlook Express to schedule a database shutdown a week in advance and put the maintenance times on your internal web page. The chosen times should be offpeak so that the normal business can continue. When you inform everybody and schedule downtime in advance, then you simply shut the database down, say, on Saturday, 18:00 hours. In other words, your problem is organizational, not technical. If you need to shut the database down immediately for whatever reason there is a gadget called a telephone. It works like this: every company has a person called CIO (stands for Career Is Over). When you need to shut down a database that is critical for business during the working hours then you tell your boss to call the CIO, and if he's not around, you tell your boss/director to page him (they usually cary beepers). He will then either inform his peers in the business process or schedule a conference call to pass the good news to the business. You are probably going to be on that conference call so better be prepared to argue why is shutting down the database critical or you will be in a very bad predicament. After that, no further information is necessary. You just do what needs to be done. In other words, shutting down an important database is not a DBA decision but a decision made by people who manage the normal business process. Those people are sometimes referred to as management. They are the ones who make decisions and define schedule. On 2003.11.25 20:49, [EMAIL PROTECTED] wrote: hi, I need to send messages like 'system shutting down in 1 min' to all users currently login. How can i do this in oracle or a third party software that i can use? users are connected using web browser. Messages are send over the wan. thanks. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Mladen Gogala Oracle DBA -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mladen Gogala INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Sun=/var/messages HP-UX=???
Actually /var/adm/messages on hpux is the message file, which my solaris 8(2.8) machine is also using /var/adm/messages, maybe I changed this, I don't remember. /var/adm/syslog/ is the default syslog directory equivalent to /var/log/ on solaris. -Original Message- From: Nelson, Allan [mailto:[EMAIL PROTECTED] Sent: Thursday, March 13, 2003 9:20 AM To: Multiple recipients of list ORACLE-L Subject: RE: Sun=/var/messages HP-UX=??? /var/adm/syslog/syslog.log is the hp-ux equivelant. -Original Message- Sent: Thursday, March 13, 2003 12:59 AM To: Multiple recipients of list ORACLE-L I monitor /var/messages on my Sun boxes, does HP-UX have anytype of OS log files worth monitoring? Thanks, Ethan -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Anderson, Brian INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Sun=/var/messages HP-UX=???
What version of HP-UX? Here is what I get on HP-UX 11.0: df2hp105 [IWHA]: ll /var/adm/me* /var/adm/me* not found - Kirti -Original Message- Sent: Friday, March 14, 2003 10:44 AM To: Multiple recipients of list ORACLE-L Actually /var/adm/messages on hpux is the message file, which my solaris 8(2.8) machine is also using /var/adm/messages, maybe I changed this, I don't remember. /var/adm/syslog/ is the default syslog directory equivalent to /var/log/ on solaris. -Original Message- From: Nelson, Allan [mailto:[EMAIL PROTECTED] Sent: Thursday, March 13, 2003 9:20 AM To: Multiple recipients of list ORACLE-L Subject: RE: Sun=/var/messages HP-UX=??? /var/adm/syslog/syslog.log is the hp-ux equivelant. -Original Message- Sent: Thursday, March 13, 2003 12:59 AM To: Multiple recipients of list ORACLE-L I monitor /var/messages on my Sun boxes, does HP-UX have anytype of OS log files worth monitoring? Thanks, Ethan -- -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Deshpande, Kirti INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Sun=/var/messages HP-UX=???
Thanks, I looked through both files (they are both here) and the information in syslog seems more meaningfull on the HP-UX than what I see in the messages file, it is just the opposite on the Sun box. - Ethan -Original Message- Sent: Friday, March 14, 2003 10:44 AM To: Multiple recipients of list ORACLE-L Actually /var/adm/messages on hpux is the message file, which my solaris 8(2.8) machine is also using /var/adm/messages, maybe I changed this, I don't remember. /var/adm/syslog/ is the default syslog directory equivalent to /var/log/ on solaris. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Post, Ethan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Sun=/var/messages HP-UX=???
hpux 11.0 man dmesg shows the standard setup using /var/adm/messages. dmesg looks in a system buffer for recently printed diagnostic messages and prints them on the standard output. The messages are those printed by the system when unusual events occur (such as when system tables overflow or the system crashes). If the - argument is specified, dmesg computes (incrementally) the new messages since the last time it was run and places these on the standard output. This is typically used with cron (see cron(1)) to produce the error log /var/adm/messages by running the command: /usr/sbin/dmesg - /var/adm/messages every 10 minutes. The arguments core and system allow substitution for the defaults /dev/kmem and /stand/vmunix respectively, where core should be a file containing the image of the kernel virtual memory saved by the savecore(1M) command and system should be the corresponding kernel. If the system is booted with a kernel other than /stand/vmunix say /stand/vmunix_new, dmesg must be passed this name, the command must be, /usr/sbin/dmesg [-] /dev/kmem /stand/vmunix_new WARNINGS The system error message buffer is of small, finite size. dmesg is run only every few minutes, so there is no guarantee that all error messages will be logged. AUTHOR dmesg was developed by the University of California, Berkeley. FILES /var/adm/messageserror log (conventional location) /var/adm/msgbuf memory scratch file for - option /dev/kmemspecial file containing the image of kernel virtual memory /stand/vmunixthe kernel, system name list -Original Message- From: Deshpande, Kirti [mailto:[EMAIL PROTECTED] Sent: Friday, March 14, 2003 3:41 PM To: Multiple recipients of list ORACLE-L Subject: RE: Sun=/var/messages HP-UX=??? What version of HP-UX? Here is what I get on HP-UX 11.0: df2hp105 [IWHA]: ll /var/adm/me* /var/adm/me* not found - Kirti -Original Message- Sent: Friday, March 14, 2003 10:44 AM To: Multiple recipients of list ORACLE-L Actually /var/adm/messages on hpux is the message file, which my solaris 8(2.8) machine is also using /var/adm/messages, maybe I changed this, I don't remember. /var/adm/syslog/ is the default syslog directory equivalent to /var/log/ on solaris. -Original Message- From: Nelson, Allan [mailto:[EMAIL PROTECTED] Sent: Thursday, March 13, 2003 9:20 AM To: Multiple recipients of list ORACLE-L Subject: RE: Sun=/var/messages HP-UX=??? /var/adm/syslog/syslog.log is the hp-ux equivelant. -Original Message- Sent: Thursday, March 13, 2003 12:59 AM To: Multiple recipients of list ORACLE-L I monitor /var/messages on my Sun boxes, does HP-UX have anytype of OS log files worth monitoring? Thanks, Ethan -- -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Deshpande, Kirti INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Anderson, Brian INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Sun=/var/messages HP-UX=???
dmesg... now, that, I know. It needs root privs to use. And unless it is run via some automated setup (cron, as you mentioned) to create a public accessible report, we are stuck with syslog.log. At least, on most systems, it is public readable... Thanks.. - Kirti -Original Message- Sent: Friday, March 14, 2003 3:29 PM To: Multiple recipients of list ORACLE-L hpux 11.0 man dmesg shows the standard setup using /var/adm/messages. dmesg looks in a system buffer for recently printed diagnostic messages and prints them on the standard output. The messages are those printed by the system when unusual events occur (such as when system tables overflow or the system crashes). If the - argument is specified, dmesg computes (incrementally) the new messages since the last time it was run and places these on the standard output. This is typically used with cron (see cron(1)) to produce the error log /var/adm/messages by running the command: /usr/sbin/dmesg - /var/adm/messages every 10 minutes. The arguments core and system allow substitution for the defaults /dev/kmem and /stand/vmunix respectively, where core should be a file containing the image of the kernel virtual memory saved by the savecore(1M) command and system should be the corresponding kernel. If the system is booted with a kernel other than /stand/vmunix say /stand/vmunix_new, dmesg must be passed this name, the command must be, /usr/sbin/dmesg [-] /dev/kmem /stand/vmunix_new WARNINGS The system error message buffer is of small, finite size. dmesg is run only every few minutes, so there is no guarantee that all error messages will be logged. AUTHOR dmesg was developed by the University of California, Berkeley. FILES /var/adm/messageserror log (conventional location) /var/adm/msgbuf memory scratch file for - option /dev/kmemspecial file containing the image of kernel virtual memory /stand/vmunixthe kernel, system name list -Original Message- From: Deshpande, Kirti [mailto:[EMAIL PROTECTED] Sent: Friday, March 14, 2003 3:41 PM To: Multiple recipients of list ORACLE-L Subject: RE: Sun=/var/messages HP-UX=??? What version of HP-UX? Here is what I get on HP-UX 11.0: df2hp105 [IWHA]: ll /var/adm/me* /var/adm/me* not found - Kirti -Original Message- Sent: Friday, March 14, 2003 10:44 AM To: Multiple recipients of list ORACLE-L Actually /var/adm/messages on hpux is the message file, which my solaris 8(2.8) machine is also using /var/adm/messages, maybe I changed this, I don't remember. /var/adm/syslog/ is the default syslog directory equivalent to /var/log/ on solaris. -Original Message- From: Nelson, Allan [mailto:[EMAIL PROTECTED] Sent: Thursday, March 13, 2003 9:20 AM To: Multiple recipients of list ORACLE-L Subject: RE: Sun=/var/messages HP-UX=??? /var/adm/syslog/syslog.log is the hp-ux equivelant. -Original Message- Sent: Thursday, March 13, 2003 12:59 AM To: Multiple recipients of list ORACLE-L I monitor /var/messages on my Sun boxes, does HP-UX have anytype of OS log files worth monitoring? Thanks, Ethan -- -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Deshpande, Kirti INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Sun=/var/messages HP-UX=???
I'm not sure if this is the default or standard location, but one file of importance on HP is /var/adm/syslog/syslog.log. Darrell [EMAIL PROTECTED] 03/13/03 12:58AM I monitor /var/messages on my Sun boxes, does HP-UX have anytype of OS log files worth monitoring? Thanks, Ethan -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Post, Ethan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Darrell Landrum INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Sun=/var/messages HP-UX=???
Ethan, Check /var/adm/syslog/syslog.log - Kirti -Original Message- Sent: Thursday, March 13, 2003 12:59 AM To: Multiple recipients of list ORACLE-L I monitor /var/messages on my Sun boxes, does HP-UX have anytype of OS log files worth monitoring? Thanks, Ethan -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Post, Ethan INET: [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Deshpande, Kirti INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Sun=/var/messages HP-UX=???
/var/adm/syslog/syslog.log is the hp-ux equivelant. -Original Message- Sent: Thursday, March 13, 2003 12:59 AM To: Multiple recipients of list ORACLE-L I monitor /var/messages on my Sun boxes, does HP-UX have anytype of OS log files worth monitoring? Thanks, Ethan -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Post, Ethan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ This email is intended solely for the person or entity to which it is addressed and may contain confidential and/or privileged information. Copying, forwarding or distributing this message by persons or entities other than the addressee is prohibited. If you have received this email in error, please contact the sender immediately and delete the material from any computer. This email may have been monitored for policy compliance. [021216] -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Nelson, Allan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Sun=/var/messages HP-UX=???
I monitor /var/messages on my Sun boxes, does HP-UX have anytype of OS log files worth monitoring? Thanks, Ethan -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Post, Ethan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: ODBC and password expire messages
If you are using VB (VBA/VB.Net or enve C#) using oo4o (Oracle Objects For OLE). This will five you more funcationalty and an increase in speed. - Original Message - From: Chip To: Multiple recipients of list ORACLE-L Sent: Thursday, February 27, 2003 2:09 AM Subject: Re: ODBC and password expire messages The Oracle ODBC 8.1.7.2 driver added a button (when adding or configuring a DSN) to test the database connection. If a password has expired, the "Test Connection" will pop-up another dialog box so the password can be changed. Oracle 9i clients do not include the "Oracle ODBC Test" (c) 1996, which could also issue SQL statements.Note: the "Oracle Call Interface Programmer's Guide" describes the OCIPasswordChange() function, but I do not know how to call OCI functions from VB.Have Fun :)When adding or configuring ODBC usMartin, Alan (Contractor) (DLIS) wrote: Hi listers: In another moment you'll be able to tell I'm not ODBC literate. I can query a UNIX 9i DB using SQL*Plus from my PC using a Oracle9i client, and get ORA-28002: the password will expire within 10 days. The 8i client (to a 9i DB) does not show these messages. Neither does the 8i Oracle ODBC Test. I'd like to test a 9i ODBC connection from the PC client. I don't see an Oracle ODBC Test for the 9i client ORACLE_HOME. Is it still available? Should the ORA-28002 be passed back via ODBC? How does one check for it in VB? Thanx, Alan Martin Defense Logistics Information Service Battle Creek, MI
ODBC and password expire messages
Title: ODBC and password expire messages Hi listers: In another moment you'll be able to tell I'm not ODBC literate. I can query a UNIX 9i DB using SQL*Plus from my PC using a Oracle9i client, and get ORA-28002: the password will expire within 10 days. The 8i client (to a 9i DB) does not show these messages. Neither does the 8i Oracle ODBC Test. I'd like to test a 9i ODBC connection from the PC client. I don't see an Oracle ODBC Test for the 9i client ORACLE_HOME. Is it still available? Should the ORA-28002 be passed back via ODBC? How does one check for it in VB? Thanx, Alan Martin Defense Logistics Information Service Battle Creek, MI
Re: ODBC and password expire messages
The Oracle ODBC 8.1.7.2 driver added a button (when adding or configuring a DSN) to test the database connection. If a password has expired, the "Test Connection" will pop-up another dialog box so the password can be changed. Oracle 9i clients do not include the "Oracle ODBC Test" (c) 1996, which could also issue SQL statements. Note: the "Oracle Call Interface Programmer's Guide" describes the OCIPasswordChange() function, but I do not know how to call OCI functions from VB. Have Fun :) When adding or configuring ODBC us Martin, Alan (Contractor) (DLIS) wrote: ODBC and password expire messages Hi listers: In another moment you'll be able to tell I'm not ODBC literate. I can query a UNIX 9i DB using SQL*Plus from my PC using a Oracle9i client, and get ORA-28002: the password will expire within 10 days. The 8i client (to a 9i DB) does not show these messages. Neither does the 8i Oracle ODBC Test. I'd like to test a 9i ODBC connection from the PC client. I don't see an Oracle ODBC Test for the 9i client ORACLE_HOME. Is it still available? Should the ORA-28002 be passed back via ODBC? How does one check for it in VB? Thanx, Alan Martin Defense Logistics Information Service Battle Creek, MI
what's the exact meaning of those messages?
Hi, I found the following message from the alert.log: Sun Dec 29 22:35:42 2002 ARC0: Beginning to archive log# 3 seq# 126 ARC0: Failed to archive log# 3 seq# 126 Sun Dec 29 22:35:42 2002 ARCH: Completed archiving log# 3 seq# 126 It seemed the ARC didn't work in the begining of archive, but worked finally after a while, I got lots of those messages from alert.log file. what's the exact meaning of those messages? My Oracle is 8.1.7.3.0. and OS is aix 5.1 Thanks in advance. Jim [EMAIL PROTECTED] 2002-12-30 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jim INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: what's the exact meaning of those messages?
It's just that it couldn't complete archiving immediately, so it will do it asap. That delay (which seems very small from the numbers you show) can be decreased by either making archiving faster (faster disks? network? whatever...) or by archiving less (yeah, right, that sounds easy to do!). Mogens Jim wrote: Hi, I found the following message from the alert.log: Sun Dec 29 22:35:42 2002 ARC0: Beginning to archive log# 3 seq# 126 ARC0: Failed to archive log# 3 seq# 126 Sun Dec 29 22:35:42 2002 ARCH: Completed archiving log# 3 seq# 126 It seemed the ARC didn't work in the begining of archive, but worked finally after a while, I got lots of those messages from alert.log file. what's the exact meaning of those messages? My Oracle is 8.1.7.3.0. and OS is aix 5.1 Thanks in advance. Jim [EMAIL PROTECTED] 2002-12-30 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: =?ISO-8859-1?Q?Mogens_N=F8rgaard?= INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: what's the exact meaning of those messages?
Check your backup script to see if it forces log switches (alter system archive log). If it does, you may be hitting bug 1377090. See note 119547.1. It is a message that you can ignore if it occurs during the alter system.. command. Jay Hostetter Oracle DBA D. E. Communications Ephrata, PA USA [EMAIL PROTECTED] 12/30/02 02:33AM Hi, I found the following message from the alert.log: Sun Dec 29 22:35:42 2002 ARC0: Beginning to archive log# 3 seq# 126 ARC0: Failed to archive log# 3 seq# 126 Sun Dec 29 22:35:42 2002 ARCH: Completed archiving log# 3 seq# 126 It seemed the ARC didn't work in the begining of archive, but worked finally after a while, I got lots of those messages from alert.log file. what's the exact meaning of those messages? My Oracle is 8.1.7.3.0. and OS is aix 5.1 Thanks in advance. Jim [EMAIL PROTECTED] 2002-12-30 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jim INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). **DISCLAIMER This e-mail message and any files transmitted with it are intended for the use of the individual or entity to which they are addressed and may contain information that is privileged, proprietary and confidential. If you are not the intended recipient, you may not use, copy or disclose to anyone the message or any information contained in the message. If you have received this communication in error, please notify the sender and delete this e-mail message. The contents do not represent the opinion of DE except to the extent that it relates to their official business. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jay Hostetter INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
my messages are not getting to list. trying to testeom
Re: my messages are not getting to list. trying to testeom
Your message was received by the list. At 10:41 AM 11/25/02 -0800, you wrote: ** Scott Stefick UNIX Systems Administrator Oracle Certified Professional DBA Wm. Rainey Harper College 847.925.6130 ** -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Scott Stefick INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Wait Event queue messages
Qs Is Wait Event queue messages any Cause for Concern ? Qs If so What is the Resolution for the Same ? Qs Any Links , Docs for the Same ? Top 5 Wait Events ~ Wait % Total Event Waits Time (cs) Wt Time --- queue messages 1,0631,066,954 58.16 db file scattered read 1,937,704 408,204 22.25 latch free 66,364 212,801 11.60 buffer busy waits 57,849 98,8345.39 db file sequential read 1,531,718 25,0791.37 - Thanks -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: VIVEK_SHARMA INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Wait Event queue messages
This is related to the AQ mechanism and can be ignored. Oracle posts this wait while waiting to dequeue a message from AQ queue. To remove it from the 'Top 5' list in statspack report, you can add a row to perfstat.stats$idle_event table. And while at it, you may want to review what other waits statspack considers as idle waits and doesn't report in the Top 5 list. But, you may want to know about some of those... Check Oracle8i Reference Guide for this and all other wait events and more.. :) - Kirti -Original Message- Sent: Friday, October 04, 2002 6:08 AM To: Multiple recipients of list ORACLE-L Qs Is Wait Event queue messages any Cause for Concern ? Qs If so What is the Resolution for the Same ? Qs Any Links , Docs for the Same ? Top 5 Wait Events ~ Wait % Total Event Waits Time (cs) Wt Time --- queue messages 1,0631,066,954 58.16 db file scattered read 1,937,704 408,204 22.25 latch free 66,364 212,801 11.60 buffer busy waits 57,849 98,834 5.39 db file sequential read 1,531,718 25,079 1.37 - Thanks -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: VIVEK_SHARMA INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Deshpande, Kirti INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
I'm getting old messages. I'm also getting messages where the header
Sounds like a database issue, so it's not OT. -- 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).
I'm getting many old messages
-Original Message- Sent: Thursday, March 14, 2002 4:59 PM To: Multiple recipients of list ORACLE-L Oracle 8.0.5.0.0 Tru64 4.0f We have a process running here and without going into the detail of it we have a Pro C program that is taking ages to run updates and selects (2 hours to do 1 records). The program was changed to PL/SQL and we suddenly were seeing 5 million records processed in 1 hour. Is PL/SQL that much faster than Pro C. Can somone more in the know give me some hints ?? TIA Lee -Original Message- From: Lawlor Michael - mlawlo Sent: 05 March 2002 17:17 To: Robertson Lee - lerobe; Fremaux Ian - ifrema; Khiroya Asit - akhiro Cc: Richardson Phil - pricha; Mathew Varghese - vmathe; Peters Roy - ropete Subject: RE: Roy's extract job Dunno, was hoping it might spark an idea. From the dark recesses of my mind, do I recall that if you have TWO_TASK, you always connect through the listener, even from the same box. Is it possible that it could have a bottleneck of some sort? Maybe that's impossible - I don't know Mick -Original Message- From: Robertson Lee - lerobe Sent: Tuesday, March 05, 2002 5:17 PM To: Lawlor Michael - mlawlo; Fremaux Ian - ifrema; Khiroya Asit - akhiro Cc: Richardson Phil - pricha; Mathew Varghese - vmathe; Peters Roy - ropete Subject:RE: Roy's extract job erm how ?? -Original Message- From: Lawlor Michael - mlawlo Sent: 05 March 2002 17:11 To: Fremaux Ian - ifrema; Robertson Lee - lerobe; Khiroya Asit - akhiro Cc: Richardson Phil - pricha; Mathew Varghese - vmathe; Peters Roy - ropete Subject:RE: Roy's extract job Something to do with the Oracle listener? M -Original Message- From: Fremaux Ian - ifrema Sent: Tuesday, March 05, 2002 5:04 PM To: Robertson Lee - lerobe; Khiroya Asit - akhiro Cc: Richardson Phil - pricha; Mathew Varghese - vmathe; Peters Roy - ropete; Lawlor Michael - mlawlo Subject: RE: Roy's extract job Chaps, We have some information that may be of interest. We had this problem (discussed below) last week where a Pro-C program was running very slowly but when Lee monitored the database response time (SELECTs UPDATEs) it was performing very quickly. We converted the code to PL-SQL and ran it yesterday and it flew along and processed 5 million records in 1 hour. This morning we tried the Pro-C version of the program again and after two hours it had processed less than 10K records. So we executed the PL-SQL again this afternoon and it has almost completed the 5 million rows in about 2 hours again. Any thoughts on the implications of this? Regards, Ian. -Original Message- From: Fremaux Ian - ifrema Sent: Friday, March 01, 2002 12:04 PM To: Robertson Lee - lerobe; Khiroya Asit - akhiro Cc: Richardson Phil - pricha; Mathew Varghese - vmathe; Peters Roy - ropete Subject:RE: Roy's extract job Yesterday it was executing the same code but without the UPDATE statement. I'd agree that the performance would be affected by having to do the UPDATEs but from the figures you observed it was executing the UPDATE statement over 1000 times per second. It is performing a commit every 10K records although I don't know how long this is taking, but from what I can see in Toad the rate of increase in the number of times the UPDATE is executing indicates that the COMMIT is probably not the problem. -Original Message- From: Robertson Lee - lerobe Sent: Friday, March 01, 2002 11:57 AM To: Fremaux Ian - ifrema; Khiroya Asit - akhiro Cc: Richardson Phil - pricha; Mathew Varghese - vmathe; Peters Roy - ropete Subject:RE: Roy's extract job Erm...couldn't see the wood for the trees time. Why are you doing single updates per record. Were you doing this in batches yesterday ? If this is the case and unless I am mistaken, then a severe degradation in performance is the sort of thing I would expect -Original Message- From: Fremaux Ian - ifrema Sent: 01 March 2002 10:00 To: Khiroya Asit - akhiro Cc: Robertson Lee - lerobe; Richardson Phil - pricha; Mathew Varghese - vmathe; Peters Roy - ropete
RE: repeat messages
Naw, it's not just you. Looks like all the messages that got re-posted have an attachment that says winmail.dat Odd -- From: Orr, Steve[SMTP:[EMAIL PROTECTED]] Reply To: [EMAIL PROTECTED] Sent: Wednesday, March 13, 2002 7:28 AM To: Multiple recipients of list ORACLE-L Subject: RE: Anyone use V$SESSION_LONGOPS ??? No... it's Deja vu all over again. Yogi Berra -Original Message- Sent: Wednesday, March 13, 2002 5:53 AM To: Multiple recipients of list ORACLE-L Is it just me, or am I having a slight case of de ja vu here ;P -Original Message- Lewis Sent: 13 March 2002 11:34 To: Multiple recipients of list ORACLE-L No version numbers, and no O/S details. Cary Millsap mentioned to me a little while ago that on one of his linux platforms the values you got from timed_statistics seemed to be a very good random number generator ;) Possibly this is just a 32-bit/64-bit misalignment in code - I've seem similar silly numbers appearing for that reason. Jonathan Lewis http://www.jlcomp.demon.co.uk Next Seminar - UK, April 3rd - 5th http://www.jlcomp.demon.co.uk/seminar.html Host to The Co-Operative Oracle Users' FAQ http://www.jlcomp.demon.co.uk/faq/ind_faq.html Author of: Practical Oracle 8i: Building Efficient Databases -Original Message- To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Date: 07 March 2002 21:36 |Well here's what's curious... |Notice the changing SID-serial# with the same sql address and hash. |Notice how elapsed seconds gyrates. Elapsed seconds goes from zero to |447,507,719 yet there were only a few seconds between the queries. How can a | |session with 447,507,719 seconds of elapsed time suddenly appear??? Why are |there sessions going back to November when the computer hasn't even been up |that long? None of the sessions in V$SESSION_LONGOPS are in V$SESSION. The |sql |address and hash is not extant in V$SQL, V$SQLAREA, etc. Is this view |supposed to behave this way? | -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jonathan Lewis INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mark Leith INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Orr, Steve INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Baker, Barbara INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Formatting of listserv messages
Sometimes listservers wrap lines after 80 characters is this something that Bruce can tweak ?? 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
Re: Formatting of listserv messages
[EMAIL PROTECTED] wrote: It looked fine with MS lookout .. :) unformatted in netscape 6. -- -- 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. Never put off till run-time what you can do at compile-time. - D. Gries -- 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: Formatting of listserv messages
Don't know, not going to ask. I think formatting mail with reasonable line lengths and sending it as text is probably more appropriate. Jared Jamadagni, Rajendra [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 02/04/02 04:30 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:RE: Formatting of listserv messages Sometimes listservers wrap lines after 80 characters is this something that Bruce can tweak ?? 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
RE: Formatting of listserv messages
If you look on http://www.w3.org, you'll see that the XMP tag was deprecated in HTML 3.2 and dropped completely in HTML 4.0. I'm guessing that most HTML clients (browsers, e-mail, etc) these days at least *claim* to be HTML 4.0-compliant -- MS products for one are NOT -- they may look all goofy. My $.02 :) Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA -Original Message- Sent: Saturday, February 02, 2002 12:15 PM To: Multiple recipients of list ORACLE-L the mail is quite strange - the text/html part of it does not contain valid HTML but something like: XMPHi all,/XMP XMP... ...which is most probably problem of the sender configuration the text/plain is hardly readable (that's what u've seen) -- 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).
Formatting of listserv messages
Naveen and others, Does this email appear to be completely unformatted to anyone else? Just wondering if it was formatted when sent, or if this happened along the way, or is it just me? I'm not likely to respond to something this difficult to read, and I'm just wondering if there's a remedy to this. I've noticed at times that I may send a carefully formatted post only to have it appear rather messy on the list. This most often happens to email I send from work using Lotus Notes. Here at home I use KDE Kmail, which is much easier to configure than Lotus. Sorry for the intrusion, but this appeared to be an interesting topic, and it's rather tedious to format these so I can read them. I can't be the only one that recieves mail looking like this. Thanks, Jared On Saturday 02 February 2002 02:50, Naveen Nahata wrote: Type - - CDL_CDL_ID NOT NULL NUMBER(10) DESCRIPTION NOT NULL VARCHAR2(50) DOCUMENT_LINE NOT NULL NUMBER(2) DATE_RECEIVED NOT NULL DATE DATE_RETURNED DATE INSERTED_BY NOT NULL VARCHAR2(30) INSERT_DATE NOT NULL DATE LAST_CHANGED_BY NOT NULL VARCHAR2(30) LAST_CHANGE_DATE NOT NULL DATEDESCRIPTION column will have relatively few distinct values compared to the number of rows so a Bitmap Index will be considered.Following are the 3 queries which immediately come to my mind ...Query 1:SELECT DISTINCT cdl.description FROM cdl_documents cdl WHERE description NOT IN (SELECT description FROM cdl_documents WHERE cdl_cdl_id = 5);Query 2:SELECT DISTINCT cdl.description FROM cdl_documents cdl WHERE NOT EXISTS (SELECT 1 FROM cdl_documentsWHERE cdl_cdl_id = 5 AND cdl.description = description);Query 3:SELECT DISTINCT description FROM cdl_documentsMINUSSELECT DISTINCT description FROM cdl_documents WHERE cdl_cdl_id = 5;One more thing -It is generally not advisable to use a NOT IN or NOT EQUAL TO clause for an indexed column bcoz the optimizer will go for FULL TABLE SCAN rather than INDEX SCAN. But what if i have a Bitmap Index? Will an INDEX SCAN still be avoided? If yes, why?Regards, Naveen - Do You Yahoo!? Yahoo! Auctions Great stuff seeking new owners! Bid now! Content-Type: text/html; charset=us-ascii; name=Attachment: 1 Content-Transfer-Encoding: 7bit Content-Description: -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Formatting of listserv messages
It looked fine with MS lookout .. :) -Original Message- Sent: Saturday, February 02, 2002 10:50 AM To: Multiple recipients of list ORACLE-L Naveen and others, Does this email appear to be completely unformatted to anyone else? Just wondering if it was formatted when sent, or if this happened along the way, or is it just me? I'm not likely to respond to something this difficult to read, and I'm just wondering if there's a remedy to this. I've noticed at times that I may send a carefully formatted post only to have it appear rather messy on the list. This most often happens to email I send from work using Lotus Notes. Here at home I use KDE Kmail, which is much easier to configure than Lotus. Sorry for the intrusion, but this appeared to be an interesting topic, and it's rather tedious to format these so I can read them. I can't be the only one that recieves mail looking like this. Thanks, Jared On Saturday 02 February 2002 02:50, Naveen Nahata wrote: Type - - CDL_CDL_ID NOT NULL NUMBER(10) DESCRIPTION NOT NULL VARCHAR2(50) DOCUMENT_LINE NOT NULL NUMBER(2) DATE_RECEIVED NOT NULL DATE DATE_RETURNED DATE INSERTED_BY NOT NULL VARCHAR2(30) INSERT_DATE NOT NULL DATE LAST_CHANGED_BY NOT NULL VARCHAR2(30) LAST_CHANGE_DATE NOT NULL DATEDESCRIPTION column will have relatively few distinct values compared to the number of rows so a Bitmap Index will be considered.Following are the 3 queries which immediately come to my mind ...Query 1:SELECT DISTINCT cdl.description FROM cdl_documents cdl WHERE description NOT IN (SELECT description FROM cdl_documents WHERE cdl_cdl_id = 5);Query 2:SELECT DISTINCT cdl.description FROM cdl_documents cdl WHERE NOT EXISTS (SELECT 1 FROM cdl_documentsWHERE cdl_cdl_id = 5 AND cdl.description = description);Query 3:SELECT DISTINCT description FROM cdl_documentsMINUSSELECT DISTINCT description FROM cdl_documents WHERE cdl_cdl_id = 5;One more thing -It is generally not advisable to use a NOT IN or NOT EQUAL TO clause for an indexed column bcoz the optimizer will go for FULL TABLE SCAN rather than INDEX SCAN. But what if i have a Bitmap Index? Will an INDEX SCAN still be avoided? If yes, why?Regards, Naveen - -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Deshpande, Kirti INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Formatting of listserv messages
Um... Something must be messed up... Mine came through ok... Work email using Outlook/Exchange... I just looked at the fatcity history page for this messages and there is a bunch of tags in the message... But, it is formatted... Using IE5.5 at least... Tim -Original Message- Sent: Saturday, February 02, 2002 11:50 AM To: Multiple recipients of list ORACLE-L Naveen and others, Does this email appear to be completely unformatted to anyone else? Just wondering if it was formatted when sent, or if this happened along the way, or is it just me? I'm not likely to respond to something this difficult to read, and I'm just wondering if there's a remedy to this. I've noticed at times that I may send a carefully formatted post only to have it appear rather messy on the list. This most often happens to email I send from work using Lotus Notes. Here at home I use KDE Kmail, which is much easier to configure than Lotus. Sorry for the intrusion, but this appeared to be an interesting topic, and it's rather tedious to format these so I can read them. I can't be the only one that recieves mail looking like this. Thanks, Jared On Saturday 02 February 2002 02:50, Naveen Nahata wrote: Type - - CDL_CDL_ID NOT NULL NUMBER(10) DESCRIPTION NOT NULL VARCHAR2(50) DOCUMENT_LINE NOT NULL NUMBER(2) DATE_RECEIVED NOT NULL DATE DATE_RETURNED DATE INSERTED_BY NOT NULL VARCHAR2(30) INSERT_DATE NOT NULL DATE LAST_CHANGED_BY NOT NULL VARCHAR2(30) LAST_CHANGE_DATE NOT NULL DATEDESCRIPTION column will have relatively few distinct values compared to the number of rows so a Bitmap Index will be considered.Following are the 3 queries which immediately come to my mind ...Query 1:SELECT DISTINCT cdl.description FROM cdl_documents cdl WHERE description NOT IN (SELECT description FROM cdl_documents WHERE cdl_cdl_id = 5);Query 2:SELECT DISTINCT cdl.description FROM cdl_documents cdl WHERE NOT EXISTS (SELECT 1 FROM cdl_documentsWHERE cdl_cdl_id = 5 AND cdl.description = description);Query 3:SELECT DISTINCT description FROM cdl_documentsMINUSSELECT DISTINCT description FROM cdl_documents WHERE cdl_cdl_id = 5;One more thing -It is generally not advisable to use a NOT IN or NOT EQUAL TO clause for an indexed column bcoz the optimizer will go for FULL TABLE SCAN rather than INDEX SCAN. But what if i have a Bitmap Index? Will an INDEX SCAN still be avoided? If yes, why?Regards, Naveen - Do You Yahoo!? Yahoo! Auctions Great stuff seeking new owners! Bid now! Content-Type: text/html; charset=us-ascii; name=Attachment: 1 Content-Transfer-Encoding: 7bit Content-Description: -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Johnston, Tim INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Formatting of listserv messages
Comes over unformated for me and I generally don't even try to read things like that as with completely html messages - I just don't have the time. Pat Naveen and others, Does this email appear to be completely unformatted to anyone else? Just wondering if it was formatted when sent, or if this happened along the way, or is it just me? I'm not likely to respond to something this difficult to read, and I'm just wondering if there's a remedy to this. I've noticed at times that I may send a carefully formatted post only to have it appear rather messy on the list. This most often happens to email I send from work using Lotus Notes. Here at home I use KDE Kmail, which is much easier to configure than Lotus. Sorry for the intrusion, but this appeared to be an interesting topic, and it's rather tedious to format these so I can read them. I can't be the only one that recieves mail looking like this. Thanks, Jared On Saturday 02 February 2002 02:50, Naveen Nahata wrote: Type - - CDL_CDL_ID NOT NULL NUMBER(10) DESCRIPTION NOT NULL VARCHAR2(50) DOCUMENT_LINE NOT NULL NUMBER(2) DATE_RECEIVED NOT NULL DATE DATE_RETURNED DATE INSERTED_BY NOT NULL VARCHAR2(30) INSERT_DATE NOT NULL DATE LAST_CHANGED_BY NOT NULL VARCHAR2(30) LAST_CHANGE_DATE NOT NULL DATEDESCRIPTION column will have relatively few distinct values compared to the number of rows so a Bitmap Index will be considered.Following are the 3 queries which immediately come to my mind ...Query 1:SELECT DISTINCT cdl.description FROM cdl_documents cdl WHERE description NOT IN (SELECT description FROM cdl_documents WHERE cdl_cdl_id = 5);Query 2:SELECT DISTINCT cdl.description FROM cdl_documents cdl WHERE NOT EXISTS (SELECT 1 FROM cdl_documents WHERE cdl_cdl_id = 5 AND cdl.description = description);Query 3:SELECT DISTINCT description FROM cdl_documentsMINUSSELECT DISTINCT description FROM cdl_documents WHERE cdl_cdl_id = 5;One more thing -It is generally not advisable to use a NOT IN or NOT EQUAL TO clause for an indexed column bcoz the optimizer will go for FULL TABLE SCAN rather than INDEX SCAN. But what if i have a Bitmap Index? Will an INDEX SCAN still be avoided? If yes, why?Regards, Naveen - Do You Yahoo!? Yahoo! Auctions Great stuff seeking new owners! Bid now! Content-Type: text/html; charset=us-ascii; name=Attachment: 1 Content-Transfer-Encoding: 7bit Content-Description: -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Pat Hildebrand INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Formatting of listserv messages
Naveen and others, Does this email appear to be completely unformatted to anyone else? Just wondering if it was formatted when sent, or if this happened along the way, or is it just me? Type - - CDL_CDL_ID NOT NULL NUMBER(10) DESCRIPTION NOT NULL VARCHAR2(50) DOCUMENT_LINE NOT NULL NUMBER(2) DATE_RECEIVED NOT NULL DATE DATE_RETURNED DATE INSERTED_BY NOT NULL VARCHAR2(30) INSERT_DATE NOT NULL DATE LAST_CHANGED_BY NOT NULL VARCHAR2(30) the mail is quite strange - the text/html part of it does not contain valid HTML but something like: XMPHi all,/XMP XMP... ...which is most probably problem of the sender configuration the text/plain is hardly readable (that's what u've seen) Marin ...what you brought from your past, is of no use in your present. When you must choose a new path, do not bring old experiences with you. Those who strike out afresh, but who attempt to retain a little of the old life, end up torn apart by their own memories. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Marin Dimitrov INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Web site of messages
- Original Message - Hi, Is there a website, which keeps all the messages posted to this forum, which can be accessed without subscribing to the forum? try http://www.fatcity.com/ListGuru/my.php and http://www.mail-archive.com/oracle-l%40fatcity.com/ hth, Marin ...what you brought from your past, is of no use in your present. When you must choose a new path, do not bring old experiences with you. Those who strike out afresh, but who attempt to retain a little of the old life, end up torn apart by their own memories. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Marin Dimitrov INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Web site of messages
Title: RE: Web site of messages I also found this site by searching Google for Oracle-L http://faqchest.dynhost.com/prgm/oracle-l/ -Original Message- From: Marin Dimitrov [mailto:[EMAIL PROTECTED]] Sent: 30 January 2002 08:00 To: Multiple recipients of list ORACLE-L Subject: Re: Web site of messages - Original Message - Hi, Is there a website, which keeps all the messages posted to this forum, which can be accessed without subscribing to the forum? try http://www.fatcity.com/ListGuru/my.php and http://www.mail-archive.com/oracle-l%40fatcity.com/ hth, Marin ...what you brought from your past, is of no use in your present. When you must choose a new path, do not bring old experiences with you. Those who strike out afresh, but who attempt to retain a little of the old life, end up torn apart by their own memories. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Marin Dimitrov INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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 electronic message contains information from the mmO2 plc Group which may be privileged or confidential. The information is intended to be for the use of the individual(s) or entity named above. If you are not the intended recipient be aware that any disclosure, copying, distribution or use of the contents of this information is prohibited. If you have received this electronic message in error, please notify us by telephone or email (to the numbers or address above) immediately. =
Web site of messages
Hi, Is there a website, which keeps all the messages posted to this forum, which can be accessed without subscribing to the forum? Thanks Shiv -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: PRASAD, SHIV INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
why no DBMS OUTPUT messages ?
Hi all: I have SET SERVEROUTPUT ON SIZE 9; at the beginning, and when the script runs, I can see DBMS output messages. However, there is only in one database when script runs nothing will show up, no DBMS output messages and no error message. Why? Where should I check for the problem? Thanks for the help Wendy __ Do You Yahoo!? Find the one for you at Yahoo! Personals http://personals.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Wendy Y INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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[2]: How to change error messages?
Yeah, it's in ORACLE_HOME/rdbmsversion. It's a plain text file with lots of comments, some of which look very interesting. Oh, this could be real fun!! Dick Goulet Reply Separator Author: Scott Shafer [EMAIL PROTECTED] Date: 9/6/2001 3:35 PM Trying to remember here, but isn't there a file called oraus.mesg or something similiar somewhere under your $oracle_home that contains all the messages and events? Edit the message you want. Do not tell Oracle Corp. you did this. I have not done and definitely do not recommend doing it unless its on a play system. This has fun possibilities when I think about certain duhvelopers... Hmmm... Scott Shafer San Antonio, TX - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, September 06, 2001 4:18 PM I don't know about SQLPLUS, but you sure can do it in pl/sql. You can manipulate it in EXCEPTION clause. HTH Raj _ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Scott Shafer INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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 change error messages?
can be done by changing the contents of the files under '$ORACLE_HOME/sqlplus/mesg', BUT not recommended. Don't know exactly as never tried. Suren -Original Message- Sent: Thursday, September 06, 2001 4:59 PM To: Multiple recipients of list ORACLE-L Does anyone know how to change the message that Oracle displays when an error occurs. For example: SQL select * from fjfjfjfjf; select * from fjfjfjfjf * ERROR at line 1: ORA-00942: table or view does not exist I am sure that Oracle Corp. will really frown on this, but can I change table or view does not exist to something else? Tom Terrian Oracle DBA WPAFB - DAASC [EMAIL PROTECTED] 937-656-3844 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Terrian, Tom INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Tirumala, Surendra INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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 change error messages?
Sure you can, but its kinda tricky... There are .msb files in ORACLE_HOME for different Oracle utilities. I guess oraus.msb is one for ORA msgs. I had changed it such that the number of characters in the message remained same... It worked :) Shailesh -Original Message- Sent: Thursday, September 06, 2001 4:59 PM To: Multiple recipients of list ORACLE-L Does anyone know how to change the message that Oracle displays when an error occurs. For example: SQL select * from fjfjfjfjf; select * from fjfjfjfjf * ERROR at line 1: ORA-00942: table or view does not exist I am sure that Oracle Corp. will really frown on this, but can I change table or view does not exist to something else? Tom Terrian Oracle DBA WPAFB - DAASC [EMAIL PROTECTED] 937-656-3844 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Terrian, Tom INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Yadav, Shailesh INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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[2]: How to change error messages?
Scott, I believe Oracle uses the binary version of the message file (*.msb) so changing the text file won't be of any use. but then again I might be wrong. 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 corporate MIS at (860) 766-2000 and delete this e-mail message from your computer, Thank you. *1 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jamadagni, Rajendra INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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[2]: How to change error messages?
Hi All, THis message file is used only by OERR utility and kernel has its own error messages built-ins. SO the changes in the oraus.msg will not be actually used by the kernel. Best Regards, K Gopalakrishnan -Original Message- [EMAIL PROTECTED] Sent: Friday, September 07, 2001 5:52 AM To: Multiple recipients of list ORACLE-L Yeah, it's in ORACLE_HOME/rdbmsversion. It's a plain text file with lots of comments, some of which look very interesting. Oh, this could be real fun!! Dick Goulet Reply Separator Author: Scott Shafer [EMAIL PROTECTED] Date: 9/6/2001 3:35 PM Trying to remember here, but isn't there a file called oraus.mesg or something similiar somewhere under your $oracle_home that contains all the messages and events? Edit the message you want. Do not tell Oracle Corp. you did this. I have not done and definitely do not recommend doing it unless its on a play system. This has fun possibilities when I think about certain duhvelopers... Hmmm... Scott Shafer San Antonio, TX - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, September 06, 2001 4:18 PM I don't know about SQLPLUS, but you sure can do it in pl/sql. You can manipulate it in EXCEPTION clause. HTH Raj _ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Scott Shafer INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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!? Get your free @yahoo.com address at http://mail.yahoo.com -- 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: How to change error messages?
The file oraus.msg is in ORACLE_HOME/rdbms/mesg/ The message should be limited to a maximum of 76 characters. That's all. Happy typing. :-] JP Dne pá 7. zá?í 2001 15:17 jste napsal(a): Sure you can, but its kinda tricky... There are .msb files in ORACLE_HOME for different Oracle utilities. I guess oraus.msb is one for ORA msgs. I had changed it such that the number of characters in the message remained same... It worked :) Shailesh -Original Message- Sent: Thursday, September 06, 2001 4:59 PM To: Multiple recipients of list ORACLE-L Does anyone know how to change the message that Oracle displays when an error occurs. For example: SQL select * from fjfjfjfjf; select * from fjfjfjfjf * ERROR at line 1: ORA-00942: table or view does not exist I am sure that Oracle Corp. will really frown on this, but can I change table or view does not exist to something else? Tom Terrian Oracle DBA WPAFB - DAASC [EMAIL PROTECTED] 937-656-3844 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jan Pruner INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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 change error messages?
The oerr script will use the oraus.msg file. However, Oracle kernel will still use oraus.msb file that is a binay version of the msg file. Oracle does not give you any tool to convert your customized msg to msb. But, that's where the fun begins ;) ( I have played with this thing in my own TEST database. Yes, I said... TEST ) Here is how : SQL select * from mytable; select * from mytable * ERROR at line 1: ORA-00942: table or view does not exist SQL !oerr ora 942 00942, 0, Do you think this table or view exists? // *Cause: It could be a typo. // *Action: Learn to type correctly. TGIF... :) Cheers! - Kirti -Original Message- From: Adams, Matthew (GEA, 088130) [SMTP:[EMAIL PROTECTED]] Sent: Friday, September 07, 2001 9:56 AM To: Multiple recipients of list ORACLE-L Subject: RE: How to change error messages? under $ORACLE_HOME/rdbms/mesg there are many error messages files. the ones your looking for here are oraus.msg oraus.msb The extention msg files are ascii text that you can edit if you like (I used to do this a lot on Oracle 6 and 7), but unless they have changed things since then, these files are used only by the oerr utility. The msb files are binary files that are used by the executables to look up error messages. BTW, the 'us' in the file name indicates us english. If you are working with some other language, it will be oraXX.msg, where XX indicates the language of the file. -Original Message- From: Scott Shafer [ mailto:[EMAIL PROTECTED]] Sent: Thursday, September 06, 2001 7:36 PM To: Multiple recipients of list ORACLE-L Subject: Re: How to change error messages? Trying to remember here, but isn't there a file called oraus.mesg or something similiar somewhere under your $oracle_home that contains all the messages and events? Edit the message you want. Do not tell Oracle Corp. you did this. I have not done and definitely do not recommend doing it unless its on a play system. This has fun possibilities when I think about certain duhvelopers... Hmmm... Scott Shafer San Antonio, TX - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, September 06, 2001 4:18 PM I don't know about SQLPLUS, but you sure can do it in pl/sql. You can manipulate it in EXCEPTION clause. HTH Raj _ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Scott Shafer INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Deshpande, Kirti INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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[2]: How to change error messages?
Errr...I beg to differ. I just tried it for fun this morning, and it worked. I have 8.1.7 installed on my NT laptop. -Original Message- Sent: Friday, September 07, 2001 9:36 AM To: Multiple recipients of list ORACLE-L Hi All, THis message file is used only by OERR utility and kernel has its own error messages built-ins. SO the changes in the oraus.msg will not be actually used by the kernel. Best Regards, K Gopalakrishnan -Original Message- [EMAIL PROTECTED] Sent: Friday, September 07, 2001 5:52 AM To: Multiple recipients of list ORACLE-L Yeah, it's in ORACLE_HOME/rdbmsversion. It's a plain text file with lots of comments, some of which look very interesting. Oh, this could be real fun!! Dick Goulet Reply Separator Author: Scott Shafer [EMAIL PROTECTED] Date: 9/6/2001 3:35 PM Trying to remember here, but isn't there a file called oraus.mesg or something similiar somewhere under your $oracle_home that contains all the messages and events? Edit the message you want. Do not tell Oracle Corp. you did this. I have not done and definitely do not recommend doing it unless its on a play system. This has fun possibilities when I think about certain duhvelopers... Hmmm... Scott Shafer San Antonio, TX - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, September 06, 2001 4:18 PM I don't know about SQLPLUS, but you sure can do it in pl/sql. You can manipulate it in EXCEPTION clause. HTH Raj _ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Scott Shafer INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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!? Get your free @yahoo.com address at http://mail.yahoo.com -- 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). -- 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: Re[2]: How to change error messages?
correct. years ago, when the Galaxy was young, somebody posted a C util that allowed the ..er...safe modification of oraus.msb. Is that person still here? LISTening? You wanna talk about *fun*...whoo-boy. Ross Mohan -Original Message- Sent: Friday, September 07, 2001 9:36 AM To: Multiple recipients of list ORACLE-L Hi All, THis message file is used only by OERR utility and kernel has its own error messages built-ins. SO the changes in the oraus.msg will not be actually used by the kernel. Best Regards, K Gopalakrishnan -Original Message- [EMAIL PROTECTED] Sent: Friday, September 07, 2001 5:52 AM To: Multiple recipients of list ORACLE-L Yeah, it's in ORACLE_HOME/rdbmsversion. It's a plain text file with lots of comments, some of which look very interesting. Oh, this could be real fun!! Dick Goulet Reply Separator Author: Scott Shafer [EMAIL PROTECTED] Date: 9/6/2001 3:35 PM Trying to remember here, but isn't there a file called oraus.mesg or something similiar somewhere under your $oracle_home that contains all the messages and events? Edit the message you want. Do not tell Oracle Corp. you did this. I have not done and definitely do not recommend doing it unless its on a play system. This has fun possibilities when I think about certain duhvelopers... Hmmm... Scott Shafer San Antonio, TX - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, September 06, 2001 4:18 PM I don't know about SQLPLUS, but you sure can do it in pl/sql. You can manipulate it in EXCEPTION clause. HTH Raj _ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Scott Shafer INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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!? Get your free @yahoo.com address at http://mail.yahoo.com -- 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mohan, Ross INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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 change error messages?
Thanks. I didn't have database access when I sent the original message. Maybe if I can dig up a binary editor - this has too much fun potential to leave alone... --Scott Jamadagni, Rajendra wrote: Scott, I believe Oracle uses the binary version of the message file (*.msb) so changing the text file won't be of any use. but then again I might be wrong. Raj _ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Scott Shafer INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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 change error messages?
LOL! Kirti. I'm thinking of trying out a binary editor on a TEST COPY of the oraus.msb file. It will at least be educational, whether successful or not. --Scott Deshpande, Kirti wrote: The oerr script will use the oraus.msg file. However, Oracle kernel will still use oraus.msb file that is a binay version of the msg file. Oracle does not give you any tool to convert your customized msg to msb. But, that's where the fun begins ;) ( I have played with this thing in my own TEST database. Yes, I said... TEST ) Here is how : SQL select * from mytable; select * from mytable * ERROR at line 1: ORA-00942: table or view does not exist SQL !oerr ora 942 00942, 0, Do you think this table or view exists? // *Cause: It could be a typo. // *Action: Learn to type correctly. TGIF... :) Cheers! - Kirti -Original Message- From: Adams, Matthew (GEA, 088130) [SMTP:[EMAIL PROTECTED]] Sent: Friday, September 07, 2001 9:56 AM To: Multiple recipients of list ORACLE-L Subject: RE: How to change error messages? under $ORACLE_HOME/rdbms/mesg there are many error messages files. the ones your looking for here are oraus.msg oraus.msb The extention msg files are ascii text that you can edit if you like (I used to do this a lot on Oracle 6 and 7), but unless they have changed things since then, these files are used only by the oerr utility. The msb files are binary files that are used by the executables to look up error messages. BTW, the 'us' in the file name indicates us english. If you are working with some other language, it will be oraXX.msg, where XX indicates the language of the file. _ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Scott Shafer INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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[2]: How to change error messages?
I want it, I need it, I gotta have it. Pleeeaase. Henry -Original Message- Sent: Friday, September 07, 2001 1:06 PM To: Multiple recipients of list ORACLE-L correct. years ago, when the Galaxy was young, somebody posted a C util that allowed the ..er...safe modification of oraus.msb. Is that person still here? LISTening? You wanna talk about *fun*...whoo-boy. Ross Mohan -Original Message- Sent: Friday, September 07, 2001 9:36 AM To: Multiple recipients of list ORACLE-L Hi All, THis message file is used only by OERR utility and kernel has its own error messages built-ins. SO the changes in the oraus.msg will not be actually used by the kernel. Best Regards, K Gopalakrishnan -Original Message- [EMAIL PROTECTED] Sent: Friday, September 07, 2001 5:52 AM To: Multiple recipients of list ORACLE-L Yeah, it's in ORACLE_HOME/rdbmsversion. It's a plain text file with lots of comments, some of which look very interesting. Oh, this could be real fun!! Dick Goulet Reply Separator Author: Scott Shafer [EMAIL PROTECTED] Date: 9/6/2001 3:35 PM Trying to remember here, but isn't there a file called oraus.mesg or something similiar somewhere under your $oracle_home that contains all the messages and events? Edit the message you want. Do not tell Oracle Corp. you did this. I have not done and definitely do not recommend doing it unless its on a play system. This has fun possibilities when I think about certain duhvelopers... Hmmm... Scott Shafer San Antonio, TX - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, September 06, 2001 4:18 PM I don't know about SQLPLUS, but you sure can do it in pl/sql. You can manipulate it in EXCEPTION clause. HTH Raj _ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Scott Shafer INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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!? Get your free @yahoo.com address at http://mail.yahoo.com -- 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mohan, Ross INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Henry Poras INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists
RE: Re[2]: How to change error messages?
How about... ORA-00942: table or view does not exist... neither should you! -Original Message- Sent: Friday, September 07, 2001 2:56 PM To: Multiple recipients of list ORACLE-L Oh, I really want to do this. Someone must know how to get it to work. I do not have enough excitement in my day. -Original Message- Sent: Friday, September 07, 2001 10:06 AM To: Multiple recipients of list ORACLE-L correct. years ago, when the Galaxy was young, somebody posted a C util that allowed the ..er...safe modification of oraus.msb. Is that person still here? LISTening? You wanna talk about *fun*...whoo-boy. Ross Mohan -Original Message- Sent: Friday, September 07, 2001 9:36 AM To: Multiple recipients of list ORACLE-L Hi All, THis message file is used only by OERR utility and kernel has its own error messages built-ins. SO the changes in the oraus.msg will not be actually used by the kernel. Best Regards, K Gopalakrishnan -Original Message- [EMAIL PROTECTED] Sent: Friday, September 07, 2001 5:52 AM To: Multiple recipients of list ORACLE-L Yeah, it's in ORACLE_HOME/rdbmsversion. It's a plain text file with lots of comments, some of which look very interesting. Oh, this could be real fun!! Dick Goulet Reply Separator Author: Scott Shafer [EMAIL PROTECTED] Date: 9/6/2001 3:35 PM Trying to remember here, but isn't there a file called oraus.mesg or something similiar somewhere under your $oracle_home that contains all the messages and events? Edit the message you want. Do not tell Oracle Corp. you did this. I have not done and definitely do not recommend doing it unless its on a play system. This has fun possibilities when I think about certain duhvelopers... Hmmm... Scott Shafer San Antonio, TX - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, September 06, 2001 4:18 PM I don't know about SQLPLUS, but you sure can do it in pl/sql. You can manipulate it in EXCEPTION clause. HTH Raj _ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Scott Shafer INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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!? Get your free @yahoo.com address at http://mail.yahoo.com -- 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mohan, Ross INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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
RE: Re[2]: How to change error messages?
Steve This brings back the good old memories of Apple C Compiler messages ... from my archive files ... start here These are some of the error messages produced by Apple's MPW C compiler. These are all real. (If you must know I was bored one afternoon and decompiled the String resources for the compiler.) The compiler is 324k in size so these are just an excerpt I hope. I'm not sure where I stand on the copyright issue. -Tony Cunningham * String literal too long (I let you have 512 characters, that's 3 more than ANSI said I should) * ...And the lord said, 'lo, there shall only be case or default labels inside a switch statement' * a typedef name was a complete surprise to me at this point in your program * 'Volatile' and 'Register' are not miscible * You can't modify a constant, float upstream, win an argument with the IRS, or satisfy this compiler * This struct already has a perfectly good definition * type in (cast) must be scalar; ANSI 3.3.4; page 39, lines 10-11 (I know you don't care, I'm just trying to annoy you) * Can't cast a void type to type void (because the ANSI spec. says so, that's why) * Huh ? * can't go mucking with a 'void *' * we already did this function * This label is the target of a goto from outside of the block containing this label AND this block has an automatic variable with an initializer AND your window wasn't wide enough to read this whole error message * Call me paranoid but finding '/*' inside this comment makes me suspicious * Too many errors on one line (make fewer) *Symbol table full - fatal heap error; please go buy a RAM upgrade from your local Apple dealer end here TGIF 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: Friday, September 07, 2001 5:28 PM To: Multiple recipients of list ORACLE-L How about... ORA-00942: table or view does not exist... neither should you! *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 corporate MIS at (860) 766-2000 and delete this e-mail message from your computer, Thank you. *1 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jamadagni, Rajendra INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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 change error messages?
Imagine changing the errors to one: Exception Error and give no more information, perhaps just a core dump in hexadecimal. Wow, how useless would that be to anyone who wants to understand what's going on!!! : ) Patrice Boivin Systems Analyst (Oracle Certified DBA) Acting Head Systems Admin Operations | Admin. et Exploit. des systèmes Technology Services| Services technologiques Informatics Branch | Direction de l'informatique Maritimes Region, DFO | Région des Maritimes, MPO E-Mail: [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Boivin, Patrice J INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: How to change error messages?
yea kinda like ora-600 :) joe Boivin, Patrice J wrote: Imagine changing the errors to one: Exception Error and give no more information, perhaps just a core dump in hexadecimal. Wow, how useless would that be to anyone who wants to understand what's going on!!! : ) Patrice Boivin Systems Analyst (Oracle Certified DBA) Acting Head Systems Admin Operations | Admin. et Exploit. des systèmes Technology Services| Services technologiques Informatics Branch | Direction de l'informatique Maritimes Region, DFO | Région des Maritimes, MPO E-Mail: [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] -- Joe Testa Performing Remote DBA Services, need some backup DBA support? For Sale: Oracle-dba.com domain, its not going cheap but feel free to ask :) IM: n8xcthome or joen8xct -- 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).
How to change error messages?
Does anyone know how to change the message that Oracle displays when an error occurs. For example: SQL select * from fjfjfjfjf; select * from fjfjfjfjf * ERROR at line 1: ORA-00942: table or view does not exist I am sure that Oracle Corp. will really frown on this, but can I change table or view does not exist to something else? Tom Terrian Oracle DBA WPAFB - DAASC [EMAIL PROTECTED] 937-656-3844 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Terrian, Tom INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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 change error messages?
I don't know about SQLPLUS, but you sure can do it in pl/sql. You can manipulate it in EXCEPTION clause. HTH 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 corporate MIS at (860) 766-2000 and delete this e-mail message from your computer, Thank you. *1 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jamadagni, Rajendra INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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 change error messages?
Trying to remember here, but isn't there a file called oraus.mesg or something similiar somewhere under your $oracle_home that contains all the messages and events? Edit the message you want. Do not tell Oracle Corp. you did this. I have not done and definitely do not recommend doing it unless its on a play system. This has fun possibilities when I think about certain duhvelopers... Hmmm... Scott Shafer San Antonio, TX - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, September 06, 2001 4:18 PM I don't know about SQLPLUS, but you sure can do it in pl/sql. You can manipulate it in EXCEPTION clause. HTH Raj _ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Scott Shafer INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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 change error messages?
Title: RE: How to change error messages? -Original Message- From: Terrian, Tom [mailto:[EMAIL PROTECTED]] Does anyone know how to change the message that Oracle displays when an error occurs. For example: SQL select * from fjfjfjfjf; select * from fjfjfjfjf * ERROR at line 1: ORA-00942: table or view does not exist I am sure that Oracle Corp. will really frown on this, but can I change table or view does not exist to something else? If you're bored with seeing the same old error messages, have you tried spicing up your life by installing Oracle in a different language? SQL select * from fjfjfjfjf; select * from fjfjfjfjf * ERREUR à la ligne 1 : ORA-00942: Table ou vue inexistante Otherwise, like someone else suggested, you can have a EXCEPTION clause in a PL/SQL block to catch the error and display a different message, but that won't change the default error message.
Not receiving messages from the list but able to send it
Hi List, My messages are received by list members but I am not receiving messages from the list since past 3 days. I am wondering as to what might be the problem? Can anybody shed light on this? Thanks and Regards, Ranganath DISCLAIMER: This correspondence is confidential and intended for the named recipient(s) only. If you are not the named recipient and receive this correspondence in error, you must not copy, distribute or take any action in reliance on it and you should delete it from your system and notify the sender immediately. Unless otherwise stated, any views or opinions expressed are solely those of the author and do not represent those of Subex Systems Limited. www.subexgroup.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ranganath 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).
No messages since yesterday evening
Hi all, I have not received any messages since yesterday evening. Is it the same with all or any of you? Regards, Ranganath DISCLAIMER: This correspondence is confidential and intended for the named recipient(s) only. If you are not the named recipient and receive this correspondence in error, you must not copy, distribute or take any action in reliance on it and you should delete it from your system and notify the sender immediately. Unless otherwise stated, any views or opinions expressed are solely those of the author and do not represent those of Subex Systems Limited. www.subexgroup.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ranganath 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).
immediate shutdown messages- when nothing being shutdown
Users are complaining of getting the following messages Oracle PL/SQL Error Code : -1089 Error Description : Error in sleep - ORA-01089: immediate shutdown in progress - no operations are permitted ..even when there is no shutdown in progress...nothing in the alert log? Then the messages go away Whats going on? Oracle 8.1.6.2 on Solaris? -- 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: immediate shutdown messages- when nothing being shutdown
Another instance (a standby, maybe?) is registering with the same SID/service name with your listener (via MTS or dedicated service registration). Do a lsnrctl services on your listener, and find out which host/instance the unwanted registered instance is on, and eliminate references to the production host's listener address from the init.ora on that host. -- Jeremiah Wilton http://www.speakeasy.net/~jwilton On Thu, 19 Jul 2001, John Dunn wrote: Users are complaining of getting the following messages Oracle PL/SQL Error Code : -1089 Error Description : Error in sleep - ORA-01089: immediate shutdown in progress - no operations are permitted ..even when there is no shutdown in progress...nothing in the alert log? Then the messages go away Whats going on? Oracle 8.1.6.2 on Solaris? -- 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).
can we create our own error messages ?
Hi guys, Can I create my own error message in create profile mypasswordprofile limit failed_login_attempts 3 - if error Prompt Call ext 127, 128, 129 to unlock your account password_life_time - same as above but diffrent message ; Do I have to replace failed_login_attempts password_life_time password_reuse_time ... ... ... ... WITH password_verify_function all_in_this_function so that I can insert all if .. raise_application_error(-20002, 'You got error'); end if; Thank you, Sinardy -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sinardy Xing INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
OFF TOPIC - FW: Sony Vaio Japanese error messages
Very funny In Japan, Sony Vaio machines have replaced the impersonal and unhelpful Microsoft error messages with their own Japanese haiku poetry, each only 17 syllables. --- A file that big? It might be very useful. But now it is gone. The Web site you seek Cannot be located but Countless more exist. Chaos reigns within. Reflect, repent, and reboot. Order shall return. ABORTED effort: Close all that you have worked on. You ask way too much. --- Windows 98 crashed. I am the Blue Screen of Death. No one hears your screams. --- Yesterday it worked. Today it is not working. Windows is like that. First snow, then silence. This thousand dollar screen dies So beautifully. With searching comes loss And the presence of absence: ""My Novel"" not found. The Tao that is seen Is not the true Tao, until You bring fresh toner. Stay the patient course. Of little worth is your ire. The network is down. A crash reduces Your expensive computer To a simple stone. Three things are certain: Death, taxes, and lost data. Guess which has occurred. You step in the stream, But the water has moved on. This page is not here. Out of memory. We wish to hold the whole sky, But we never will. Having been erased, The document you're seeking Must now be retyped. 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: lerobe - Lee Robertson INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).