RE: urgent Help!! FYI
In your listener.ora file add the line logging_listener=off. Otherwise make sure $ORACLE_HOME/network/log exists and is writable by the Oracle user. Dick Goulet Senior Oracle DBA Oracle Certified 8i DBA -Original Message- Sent: Friday, July 18, 2003 4:10 PM To: Multiple recipients of list ORACLE-L Hi, I need somebody here to help me to start my Oracle listener for my Oracle server was power off this morning. Here, when I run the lsncrtl start, I get an error message. Please see the following message: # ./lsnrctl start LSNRCTL for Solaris: Version 9.2.0.1.0 - Production on 18-JUL-2003 15:20:10 Copyright (c) 1991, 2002, Oracle Corporation. All rights reserved. Starting /u01/app/oracle/product/9.2.0.1.0/bin/tnslsnr: please wait... TNSLSNR for Solaris: Version 9.2.0.1.0 - Production NL-00280: error creating log stream /u01/app/oracle/product/9.2.0.1.0/network/log/listener.log NL-00278: cannot open log file SNL-00016: snlfohd: error opening file Solaris Error: 13: Permission denied Listener failed to start. See the error message(s) above... Can somebody tell me how to start my Oracle listener? Any suggestion are highly appreciated! Many thanks! Don -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Don Yu 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: Goulet, Dick 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: urgent Help!! FYI
In OH/network/log is there a listener.log file? Who owns it? Who are you starting the listener as and does that ID have rights to write to the listener.log? -Original Message- To: Multiple recipients of list ORACLE-L Sent: 7/18/2003 3:09 PM Hi, I need somebody here to help me to start my Oracle listener for my Oracle server was power off this morning. Here, when I run the lsncrtl start, I get an error message. Please see the following message: # ./lsnrctl start LSNRCTL for Solaris: Version 9.2.0.1.0 - Production on 18-JUL-2003 15:20:10 Copyright (c) 1991, 2002, Oracle Corporation. All rights reserved. Starting /u01/app/oracle/product/9.2.0.1.0/bin/tnslsnr: please wait... TNSLSNR for Solaris: Version 9.2.0.1.0 - Production NL-00280: error creating log stream /u01/app/oracle/product/9.2.0.1.0/network/log/listener.log NL-00278: cannot open log file SNL-00016: snlfohd: error opening file Solaris Error: 13: Permission denied Listener failed to start. See the error message(s) above... Can somebody tell me how to start my Oracle listener? Any suggestion are highly appreciated! Many thanks! Don -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Don Yu 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: Freeman Robert - IL 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: urgent Help!! FYI
Also, it looks like you're starting the listener as root. Try doing it as oracle. Matt -- Matthew Zito GridApp Systems Email: [EMAIL PROTECTED] Cell: 646-220-3551 Phone: 212-358-8211 x 359 http://www.gridapp.com -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Goulet, Dick Sent: Friday, July 18, 2003 3:24 PM To: Multiple recipients of list ORACLE-L Subject: RE: urgent Help!! FYI In your listener.ora file add the line logging_listener=off. Otherwise make sure $ORACLE_HOME/network/log exists and is writable by the Oracle user. Dick Goulet Senior Oracle DBA Oracle Certified 8i DBA -Original Message- Sent: Friday, July 18, 2003 4:10 PM To: Multiple recipients of list ORACLE-L Hi, I need somebody here to help me to start my Oracle listener for my Oracle server was power off this morning. Here, when I run the lsncrtl start, I get an error message. Please see the following message: # ./lsnrctl start LSNRCTL for Solaris: Version 9.2.0.1.0 - Production on 18-JUL-2003 15:20:10 Copyright (c) 1991, 2002, Oracle Corporation. All rights reserved. Starting /u01/app/oracle/product/9.2.0.1.0/bin/tnslsnr: please wait... TNSLSNR for Solaris: Version 9.2.0.1.0 - Production NL-00280: error creating log stream /u01/app/oracle/product/9.2.0.1.0/network/log/listener.log NL-00278: cannot open log file SNL-00016: snlfohd: error opening file Solaris Error: 13: Permission denied Listener failed to start. See the error message(s) above... Can somebody tell me how to start my Oracle listener? Any suggestion are highly appreciated! Many thanks! Don -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Don Yu 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: Goulet, Dick 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: Matthew Zito 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: urgent Help!! FYI
Dick, Before this morning power off, everything is fine with my Oracle server. I think this might be something related to autostart because my solaris server is down. But I will try it. Thanks! Don Goulet, Dick wrote: In your listener.ora file add the line logging_listener=off. Otherwise make sure $ORACLE_HOME/network/log exists and is writable by the Oracle user. Dick Goulet Senior Oracle DBA Oracle Certified 8i DBA -Original Message- Sent: Friday, July 18, 2003 4:10 PM To: Multiple recipients of list ORACLE-L Hi, I need somebody here to help me to start my Oracle listener for my Oracle server was power off this morning. Here, when I run the lsncrtl start, I get an error message. Please see the following message: # ./lsnrctl start LSNRCTL for Solaris: Version 9.2.0.1.0 - Production on 18-JUL-2003 15:20:10 Copyright (c) 1991, 2002, Oracle Corporation. All rights reserved. Starting /u01/app/oracle/product/9.2.0.1.0/bin/tnslsnr: please wait... TNSLSNR for Solaris: Version 9.2.0.1.0 - Production NL-00280: error creating log stream /u01/app/oracle/product/9.2.0.1.0/network/log/listener.log NL-00278: cannot open log file SNL-00016: snlfohd: error opening file Solaris Error: 13: Permission denied Listener failed to start. See the error message(s) above... Can somebody tell me how to start my Oracle listener? Any suggestion are highly appreciated! Many thanks! Don -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Don Yu 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: Goulet, Dick 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: Don Yu 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: urgent Help!! FYI
Dick, It works now after I change the $ORACLE_HOME/network/log/listener.ora to like following: $ls -al listener.log -rw-rw-rw- 1 oracle oinstall 1732613 Jul 18 16:02 listener.log But before the parameter is like following: $ls -al listener.log -rw-rw-r-- 1 oracle oinstall 1732613 Jul 18 16:02 listener.log I just don't know is this file property changed or not? If changed, who changed it. But before power off, it works fine. Thank you very much again! Don Goulet, Dick wrote: In your listener.ora file add the line logging_listener=off. Otherwise make sure $ORACLE_HOME/network/log exists and is writable by the Oracle user. Dick Goulet Senior Oracle DBA Oracle Certified 8i DBA -Original Message- Sent: Friday, July 18, 2003 4:10 PM To: Multiple recipients of list ORACLE-L Hi, I need somebody here to help me to start my Oracle listener for my Oracle server was power off this morning. Here, when I run the lsncrtl start, I get an error message. Please see the following message: # ./lsnrctl start LSNRCTL for Solaris: Version 9.2.0.1.0 - Production on 18-JUL-2003 15:20:10 Copyright (c) 1991, 2002, Oracle Corporation. All rights reserved. Starting /u01/app/oracle/product/9.2.0.1.0/bin/tnslsnr: please wait... TNSLSNR for Solaris: Version 9.2.0.1.0 - Production NL-00280: error creating log stream /u01/app/oracle/product/9.2.0.1.0/network/log/listener.log NL-00278: cannot open log file SNL-00016: snlfohd: error opening file Solaris Error: 13: Permission denied Listener failed to start. See the error message(s) above... Can somebody tell me how to start my Oracle listener? Any suggestion are highly appreciated! Many thanks! Don -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Don Yu 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: Goulet, Dick 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: Don Yu 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: urgent Help!! FYI
Freeman, Before I change it, listener.ora property is like the following: $ls -al listener.ora -rw-rw-r-- 1 oracle oinstall 1732613 Jul 18 16:02 listener.log After I change it by the following steps, it works fine. $chmod 666 listener.ora lsnrctl start Now Oracle listener starts up. Thank you very much! Don Freeman Robert - IL wrote: In OH/network/log is there a listener.log file? Who owns it? Who are you starting the listener as and does that ID have rights to write to the listener.log? -Original Message- To: Multiple recipients of list ORACLE-L Sent: 7/18/2003 3:09 PM Hi, I need somebody here to help me to start my Oracle listener for my Oracle server was power off this morning. Here, when I run the lsncrtl start, I get an error message. Please see the following message: # ./lsnrctl start LSNRCTL for Solaris: Version 9.2.0.1.0 - Production on 18-JUL-2003 15:20:10 Copyright (c) 1991, 2002, Oracle Corporation. All rights reserved. Starting /u01/app/oracle/product/9.2.0.1.0/bin/tnslsnr: please wait... TNSLSNR for Solaris: Version 9.2.0.1.0 - Production NL-00280: error creating log stream /u01/app/oracle/product/9.2.0.1.0/network/log/listener.log NL-00278: cannot open log file SNL-00016: snlfohd: error opening file Solaris Error: 13: Permission denied Listener failed to start. See the error message(s) above... Can somebody tell me how to start my Oracle listener? Any suggestion are highly appreciated! Many thanks! Don -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Don Yu 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: Freeman Robert - IL 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: Don Yu 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: urgent Help!! FYI
Matthew, Yes. After I execute script as lsnrctl start by oracle, everything is the same to my original. But before I try to execute this script as root. I think that I make a big mistake. Many thanks! Don Matthew Zito wrote: Also, it looks like you're starting the listener as root. Try doing it as oracle. Matt -- Matthew Zito GridApp Systems Email: [EMAIL PROTECTED] Cell: 646-220-3551 Phone: 212-358-8211 x 359 http://www.gridapp.com -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Goulet, Dick Sent: Friday, July 18, 2003 3:24 PM To: Multiple recipients of list ORACLE-L Subject: RE: urgent Help!! FYI In your listener.ora file add the line logging_listener=off. Otherwise make sure $ORACLE_HOME/network/log exists and is writable by the Oracle user. Dick Goulet Senior Oracle DBA Oracle Certified 8i DBA -Original Message- Sent: Friday, July 18, 2003 4:10 PM To: Multiple recipients of list ORACLE-L Hi, I need somebody here to help me to start my Oracle listener for my Oracle server was power off this morning. Here, when I run the lsncrtl start, I get an error message. Please see the following message: # ./lsnrctl start LSNRCTL for Solaris: Version 9.2.0.1.0 - Production on 18-JUL-2003 15:20:10 Copyright (c) 1991, 2002, Oracle Corporation. All rights reserved. Starting /u01/app/oracle/product/9.2.0.1.0/bin/tnslsnr: please wait... TNSLSNR for Solaris: Version 9.2.0.1.0 - Production NL-00280: error creating log stream /u01/app/oracle/product/9.2.0.1.0/network/log/listener.log NL-00278: cannot open log file SNL-00016: snlfohd: error opening file Solaris Error: 13: Permission denied Listener failed to start. See the error message(s) above... Can somebody tell me how to start my Oracle listener? Any suggestion are highly appreciated! Many thanks! Don -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Don Yu 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: Goulet, Dick 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: Matthew Zito 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: Don Yu 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: urgent Help!! FYI
Issue a ps -ef|grep tns Command. Who owns the process? Root? RF -Original Message- To: Multiple recipients of list ORACLE-L Sent: 7/18/2003 4:09 PM Dick, It works now after I change the $ORACLE_HOME/network/log/listener.ora to like following: $ls -al listener.log -rw-rw-rw- 1 oracle oinstall 1732613 Jul 18 16:02 listener.log But before the parameter is like following: $ls -al listener.log -rw-rw-r-- 1 oracle oinstall 1732613 Jul 18 16:02 listener.log I just don't know is this file property changed or not? If changed, who changed it. But before power off, it works fine. Thank you very much again! Don Goulet, Dick wrote: In your listener.ora file add the line logging_listener=off. Otherwise make sure $ORACLE_HOME/network/log exists and is writable by the Oracle user. Dick Goulet Senior Oracle DBA Oracle Certified 8i DBA -Original Message- Sent: Friday, July 18, 2003 4:10 PM To: Multiple recipients of list ORACLE-L Hi, I need somebody here to help me to start my Oracle listener for my Oracle server was power off this morning. Here, when I run the lsncrtl start, I get an error message. Please see the following message: # ./lsnrctl start LSNRCTL for Solaris: Version 9.2.0.1.0 - Production on 18-JUL-2003 15:20:10 Copyright (c) 1991, 2002, Oracle Corporation. All rights reserved. Starting /u01/app/oracle/product/9.2.0.1.0/bin/tnslsnr: please wait... TNSLSNR for Solaris: Version 9.2.0.1.0 - Production NL-00280: error creating log stream /u01/app/oracle/product/9.2.0.1.0/network/log/listener.log NL-00278: cannot open log file SNL-00016: snlfohd: error opening file Solaris Error: 13: Permission denied Listener failed to start. See the error message(s) above... Can somebody tell me how to start my Oracle listener? Any suggestion are highly appreciated! Many thanks! Don -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Don Yu 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: Goulet, Dick 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: Don Yu 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: Freeman Robert - IL 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: Urgent - Help ....
(Since this is urgent, I'm probably a few days late.) But for future reference... I assume that no change in the software means no changing variables and such that can currently handle only a 9 digit number... Can your application can handle negative numbers? Is this really a surrogate key? If so you are in luck! Drop and recreate the sequence with: create sequence MY_SEQ increment by -1 start with 0 ... (Add whatever else is appropriate - cache 100, etc.) Don Granaman OraSaurus - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, February 20, 2003 2:58 AM Hi Gurus, I need a urgent help. I have a table e.g. USER_DETAILS with a column NUMBER(9), populated by a sequence. [ The column name is USERNO ] This table is quite heavy and the current situation is USERNO have reached it's maximum value i.e. 9. No more records can be inserted Problem !!! Can any one suggest a solution with NO change is the software and minor change in the software. TIA Regards, Harsh Agrawal The information contained in this message is proprietary of Amdocs, protected from disclosure, and may be privileged. The information is intended to be conveyed only to the designated recipient(s) of the message. If the reader of this message is not the intended recipient, you are hereby notified that any dissemination, use, distribution or copying of this communication is strictly prohibited and may be unlawful. If you have received this communication in error, please notify us immediately by replying to the message and deleting it from your computer. Thank you. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Don Granaman 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: Urgent - Help ....
ALTER TABLE user_details MODIFY (column_name NUMBER); Regards Naveen -Original Message- Sent: Thursday, February 20, 2003 2:29 PM To: Multiple recipients of list ORACLE-L Hi Gurus, I need a urgent help. I have a table e.g. USER_DETAILS with a column NUMBER(9), populated by a sequence. [ The column name is USERNO ] This table is quite heavy and the current situation is USERNO have reached it's maximum value i.e. 9. No more records can be inserted Problem !!! Can any one suggest a solution with NO change is the software and minor change in the software. TIA Regards, Harsh Agrawal DISCLAIMER: This message (including attachment if any) is confidential and may be privileged. Before opening attachments please check them for viruses and defects. MindTree Consulting Private Limited (MindTree) will not be responsible for any viruses or defects or any forwarded attachments emanating either from within MindTree or outside. If you have received this message by mistake please notify the sender by return e-mail and delete this message from your system. Any unauthorized use or dissemination of this message in whole or in part is strictly prohibited. Please note that e-mails are susceptible to change and MindTree shall not be liable for any improper, untimely or incomplete transmission. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Naveen Nahata 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: Urgent - Help ....
Hi Harsha, You can modify column length as done in second step below: SYSTEM@OHIL create table test121 (col1 number (5)) tablespace users ; Table created. SYSTEM@OHILalter table test121 modify col1 number(8) ; Table altered. SYSTEM@OHILdrop table test121 ; Table dropped. Cheers, Rajesh -Original Message- Sent: Thursday, February 20, 2003 12:59 PM To: Multiple recipients of list ORACLE-L Hi Gurus, I need a urgent help. I have a table e.g. USER_DETAILS with a column NUMBER(9), populated by a sequence. [ The column name is USERNO ] This table is quite heavy and the current situation is USERNO have reached it's maximum value i.e. 9. No more records can be inserted Problem !!! Can any one suggest a solution with NO change is the software and minor change in the software. TIA Regards, Harsh Agrawal -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Rajesh Dayal 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: Urgent - Help ....
i think altering the table will be the only solutionalter the size of the column to 10 or 11 depending on the requirement. santosh -Original Message- Agrawal Sent: Thursday, February 20, 2003 2:29 PM To: Multiple recipients of list ORACLE-L Hi Gurus, I need a urgent help. I have a table e.g. USER_DETAILS with a column NUMBER(9), populated by a sequence. [ The column name is USERNO ] This table is quite heavy and the current situation is USERNO have reached it's maximum value i.e. 9. No more records can be inserted Problem !!! Can any one suggest a solution with NO change is the software and minor change in the software. TIA Regards, Harsh Agrawal -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Santosh Varma 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: Urgent - Help ....
u need to increase the length of the field USERNO and make corresponding changes in the application where you are accessing this field. Syntax will be something like this Alter table table_name modify column_name; HTH Kranti Harsh Agrawal [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent by: cc: [EMAIL PROTECTED] Subject: Urgent - Help 02/20/2003 02:28 PM Please respond to ORACLE-L Hi Gurus, I need a urgent help. I have a table e.g. USER_DETAILS with a column NUMBER(9), populated by a sequence. [ The column name is USERNO ] This table is quite heavy and the current situation is USERNO have reached it's maximum value i.e. 9. No more records can be inserted Problem !!! Can any one suggest a solution with NO change is the software and minor change in the software. TIA Regards, Harsh Agrawal The information contained in this message is proprietary of Amdocs, protected from disclosure, and may be privileged. The information is intended to be conveyed only to the designated recipient(s) of the message. If the reader of this message is not the intended recipient, you are hereby notified that any dissemination, use, distribution or copying of this communication is strictly prohibited and may be unlawful. If you have received this communication in error, please notify us immediately by replying to the message and deleting it from your computer. Thank you. This message is for the designated recipient only and may contain privileged, proprietary, or otherwise private information. If you have received it in error, please notify the sender immediately and delete the original. Any other use of the email by you is prohibited. -- 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: Urgent - Help ....
Harsha, You may even have to drop and reacreate the sequence number (if it is at it's max too). Recreate it with the same name and start at its current value and increment by 1. What is running on top of the tables? You said no change or minor change to the software... Will making the column bigger cause you to have to make front end changes, as well? The table might be the easy part. April -Original Message- To: Multiple recipients of list ORACLE-L Sent: 2/20/2003 4:04 AM Hi Harsha, You can modify column length as done in second step below: SYSTEM@OHIL create table test121 (col1 number (5)) tablespace users ; Table created. SYSTEM@OHILalter table test121 modify col1 number(8) ; Table altered. SYSTEM@OHILdrop table test121 ; Table dropped. Cheers, Rajesh -Original Message- Sent: Thursday, February 20, 2003 12:59 PM To: Multiple recipients of list ORACLE-L Hi Gurus, I need a urgent help. I have a table e.g. USER_DETAILS with a column NUMBER(9), populated by a sequence. [ The column name is USERNO ] This table is quite heavy and the current situation is USERNO have reached it's maximum value i.e. 9. No more records can be inserted Problem !!! Can any one suggest a solution with NO change is the software and minor change in the software. TIA Regards, Harsh Agrawal -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Rajesh Dayal 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). The information contained in this communication, including attachments, is strictly confidential and for the intended use of the addressee only; it may also contain proprietary, price sensitive, or legally privileged information. Notice is hereby given that any disclosure, distribution, dissemination, use, or copying of the information by anyone other than the intended recipient is strictly prohibited and may be illegal. If you have received this communication in error, please notify the sender immediately by reply e-mail, delete this communication, and destroy all copies. Corporate Systems, Inc. has taken reasonable precautions to ensure that any attachment to this e-mail has been swept for viruses. We specifically disclaim all liability and will accept no responsibility for any damage sustained as a result of software viruses and advise you to carry out your own virus checks before opening any attachment. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: April Wells 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: Urgent - Help ....
Hi Harish, The only solution as per my understanding you have is to alter table and increase the size just by 1. That will give you 10 times more room than as of now. Then start looking at forms, reports, DB_Objects , Local scripts etc etc to make the possible changes.. In case your DB Objects are using %TYPE then they will work fine otherwise in forms, reports u have to change... Please revert back in case of any confusion. Cheers, Ajay Kumar -Original Message- Sent: 20 February 2003 08:59 To: Multiple recipients of list ORACLE-L Hi Gurus, I need a urgent help. I have a table e.g. USER_DETAILS with a column NUMBER(9), populated by a sequence. [ The column name is USERNO ] This table is quite heavy and the current situation is USERNO have reached it's maximum value i.e. 9. No more records can be inserted Problem !!! Can any one suggest a solution with NO change is the software and minor change in the software. TIA Regards, Harsh Agrawal This email and any attached to it are confidential and intended only for the individual or entity to which it is addressed. If you are not the intended recipient, please let us know by telephoning or emailing the sender. You should also delete the email and any attachment from your systems and should not copy the email or any attachment or disclose their content to any other person or entity. The views expressed here are not necessarily those of Churchill Insurance Group plc or its affiliates or subsidiaries. Thank you. Churchill Insurance Group plc. Company Registration Number - 2280426. England. Registered Office: Churchill Court, Westmoreland Road, Bromley, Kent BR1 1DP. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Kumar Ajay 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: Urgent - Help ....
Harsh, after altering the column (increasing the width) make sure u dont have any triggers/procedures associated with the table. altering the table will make those objects invalid. so make sure to compile those objects again. HTH !!! -Original Message- Agrawal Sent: Thursday, February 20, 2003 2:59 AM To: Multiple recipients of list ORACLE-L Hi Gurus, I need a urgent help. I have a table e.g. USER_DETAILS with a column NUMBER(9), populated by a sequence. [ The column name is USERNO ] This table is quite heavy and the current situation is USERNO have reached it's maximum value i.e. 9. No more records can be inserted Problem !!! Can any one suggest a solution with NO change is the software and minor change in the software. TIA Regards, Harsh Agrawal -- 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: Urgent help needed, gurus
Hi, I hope my response isn't too late... It may well be because when you do select function(x) from table the query can return after processing the first few rows only (ie: FIRST_ROWS) type execution. As soon as you ask for a count of those rows though it must process every row (ie: ALL_ROWS). If the table is very large then this is most likely your problem - although it's not a problem its just the way things go. Of course if you are running select function(x) from table through a product like SQL*Plus that will print all the rows to the screen and this is still much quicker then you might have a problem worth looking into. To be honest I'm not sure if sort area size has a big impact on a simply select count(*) but it might since a type of sort is used to count the rows. I also have a feeling that using a function on a table normally prevents parallel querying so perhaps there are some opportunities there - but I cannot offer any specific advice. Regards, Mark. mac mac@telequote To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] .netcc: Sent by: Subject: Urgent help needed, gurus [EMAIL PROTECTED] om 24/12/2002 20:03 Please respond to ORACLE-L Oracle 817 on W2k: SELECT FUNCTION(X) FROM TABLE works fine. SELECT COUNT (*) FROM (SELECT FUNCTION(X) FROM TABLE) where the function and the table are the same as above, takes hours and hours, without any result, and I have to stop it. There is NO ERROR MESSAGE. The same story (no result, no error message) it's happening when: INSERT INTO TABLE1 SELECT FUNCTION(X) FROM TABLE I need some help. Merry Christmas, Ciprian MAFTEI Systems Analyst Telequote Network Romania -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: mac 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). Privileged/Confidential information may be contained in this message. If you are not the addressee indicated in this message (or responsible for delivery of the message to such person), you may not copy or deliver this message to anyone. In such case, you should destroy this message and kindly notify the sender by reply e-mail or by telephone on (61 3) 9612-6999. Please advise immediately if you or your employer does not consent to Internet e-mail for messages of this kind. Opinions, conclusions and other information in this message that do not relate to the official business of Transurban City Link Ltd shall be understood as neither given nor endorsed by it. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mark Richard INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE
RE: Urgent help needed, gurus
What does the session statistics say when you are running the query? Do an explain plan of both the queries and see the difference. Check the session statistics for both the queries. Regards Naveen -Original Message- Sent: Tuesday, December 24, 2002 2:34 PM To: Multiple recipients of list ORACLE-L Oracle 817 on W2k: SELECT FUNCTION(X) FROM TABLE works fine. SELECT COUNT (*) FROM (SELECT FUNCTION(X) FROM TABLE) where the function and the table are the same as above, takes hours and hours, without any result, and I have to stop it. There is NO ERROR MESSAGE. The same story (no result, no error message) it's happening when: INSERT INTO TABLE1 SELECT FUNCTION(X) FROM TABLE I need some help. Merry Christmas, Ciprian MAFTEI Systems Analyst Telequote Network Romania -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: mac 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: Naveen Nahata 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: urgent help: replication, shareplex
Title: RE: urgent help: replication, shareplex I suggest you take a peek at the waits for the Shareplex process on the source system. We found that the sp_ordr processes query the source tables via the rowid mined out of the redo stream. Sp_ocap also issues queries as well as perform DML on the Shareplex rowid map table. I don't see how the single-row commits would have an impact on the replication. Shareplex doesn't wait for the source's commit before sending the update to the target so that activity remains the same. Upon encountering a commit in the redo stream, it then sends a message to the target so that it also does a commit. We do approximately 40 commits per second consisting of multiple DML operations and we don't any latency (when everything is working correctly.) HTH Tony Aponte -Original Message- From: Ji, Richard [mailto:[EMAIL PROTECTED]] Sent: Monday, September 30, 2002 1:09 PM To: Multiple recipients of list ORACLE-L Subject: urgent help: replication, shareplex Hi All, I needed some help here involving shareplex. We run two databases (an OLTP type, and a repository type) on the same E10K domain which has 8 CPUs and 8GB of RAM, using Hatachi SAN (RAID 5). Shareplex is being used to replicate a table from the OLTP type to the repository. The current volume we are getting is about 40 inserts per second to the OLTP. And at this rate shareplex is lagging behind doing the replication, for 24 hours now. And I see the shareplex process running at 10% while all Oracle processes are below 1% of the CPU. The situation is complicated, because it involves a hosting company. For instance, I would like to run the two databases on two separate domains but they chose not to. So they are blaming our application for doing commit on every insert being the problem. I agree that (and I will make the change) to commit every 1000 inserts or so. However, I don't believe that's the root of the problem. From what I understand, shareplex is log based replication and should not be as resource instensive. And 40 per/second isn't a huge volume per se and I am sure shareplex can handle a lot more than that. So any suggestions, feedbacks are welcome. Thanks Richard -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ji, Richard INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: URGENT Help on tracking unauthorized login to Oracle Database
Thanks a lot. Ashoke -Original Message- [mailto:[EMAIL PROTECTED]] Sent: Friday, February 15, 2002 1:03 AM To: Multiple recipients of list ORACLE-L Database Ashoke, In chapter 24, go through : Managing Audit Trail Information Setting Auditing Options Enabling Audit Options Enabling Statement Privilege Auditing You will see this text : To audit all successful and unsuccessful connections to and disconnections from the database, regardless of user, BY SESSION (the default and only value for this option), enter the following statement: AUDIT SESSION; I use this query to report failed login attempts from SYS.AUD$ : select os_username, username, userhost, terminal, timestamp, returncode from sys.dba_audit_session where returncode != 0 order by timestamp / (DBA_AUDIT_SESSION is a view on AUD$) Hemant K Chitale Principal DBA Chartered Semiconductor Manufacturing Ltd Mandal, Ashoke [EMAIL PROTECTED] 12/02/2002 01:18 PM Sent by: [EMAIL PROTECTED] Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: (bcc: CHITALE Hemant Krishnarao/IT/CHRT/ST Group) Subject: RE: URGENT Help on tracking unauthorized login to Oracle Database Hi Revaldi and Joe (Testa), I went through the following Administrator's guide. Oracle8i Administrator's Guide Release 2 (8.1.6) Part Number A76956-01 I could only see chapter 24 on 'Auditing database Use' and under that the following sub-sections. I went through these secition and could not find anything on unsuccessful login to oracle database. Could you please help me in ponting to the right chapter/section. Guidelines for Auditing Creating and Deleting the Database Audit Trail Views Managing Audit Trail Information Viewing Database Audit Trail Information Auditing Through Database Triggers Thanks, Ashoke -Original Message- From: Behar, Rivaldi [mailto:[EMAIL PROTECTED]] Sent: Friday, February 08, 2002 1:29 PM To: Multiple recipients of list ORACLE-L Subject: RE: URGENT Help on tracking unauthorized login to Oracle Database Administrators guide. Chapter on auditing. Audit session. Rivaldi -Original Message- From: Mandal, Ashoke [mailto:[EMAIL PROTECTED]] Sent: Friday, February 08, 2002 12:54 PM To: Multiple recipients of list ORACLE-L Subject: RE: URGENT Help on tracking unauthorized login to Oracle Database Joe, We referred the auditing option. My understanding is that you can track the oracle users using database auditing feature once the users are logged into the database. But my requirement is to track the users who tried to login to the database but could not login due to wrong password. For example, somebody may know the connect string for an oracle database and trying to login to the database as system user and with various combination of password. We like to know who are these users. Thanks, Ashoke -Original Message- Sent: Friday, February 08, 2002 11:54 AM To: Multiple recipients of list ORACLE-L Database Administrators guide chapter on auditing. joe Mandal, Ashoke wrote: Greetings, We have a database with very sensitive data. Our management wants me to find out the way to secure this data from unauthorized login and track these users who tried to login to this database. Is there any way we can track the unauthorized users, who try to login to an oracle database with invalid userid or password but with valid connect string. If there is no options under oracle then is there any 3rd party software for this purpose. Any help is appreciated Thanks, Ashoke -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joseph S Testa INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists
RE: URGENT Help on tracking unauthorized login to Oracle Database
Ashoke, In chapter 24, go through : Managing Audit Trail Information Setting Auditing Options Enabling Audit Options Enabling Statement Privilege Auditing You will see this text : To audit all successful and unsuccessful connections to and disconnections from the database, regardless of user, BY SESSION (the default and only value for this option), enter the following statement: AUDIT SESSION; I use this query to report failed login attempts from SYS.AUD$ : select os_username, username, userhost, terminal, timestamp, returncode from sys.dba_audit_session where returncode != 0 order by timestamp / (DBA_AUDIT_SESSION is a view on AUD$) Hemant K Chitale Principal DBA Chartered Semiconductor Manufacturing Ltd Mandal, Ashoke [EMAIL PROTECTED] 12/02/2002 01:18 PM Sent by: [EMAIL PROTECTED] Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: (bcc: CHITALE Hemant Krishnarao/IT/CHRT/ST Group) Subject: RE: URGENT Help on tracking unauthorized login to Oracle Database Hi Revaldi and Joe (Testa), I went through the following Administrator's guide. Oracle8i Administrator's Guide Release 2 (8.1.6) Part Number A76956-01 I could only see chapter 24 on 'Auditing database Use' and under that the following sub-sections. I went through these secition and could not find anything on unsuccessful login to oracle database. Could you please help me in ponting to the right chapter/section. Guidelines for Auditing Creating and Deleting the Database Audit Trail Views Managing Audit Trail Information Viewing Database Audit Trail Information Auditing Through Database Triggers Thanks, Ashoke -Original Message- From: Behar, Rivaldi [mailto:[EMAIL PROTECTED]] Sent: Friday, February 08, 2002 1:29 PM To: Multiple recipients of list ORACLE-L Subject: RE: URGENT Help on tracking unauthorized login to Oracle Database Administrators guide. Chapter on auditing. Audit session. Rivaldi -Original Message- From: Mandal, Ashoke [mailto:[EMAIL PROTECTED]] Sent: Friday, February 08, 2002 12:54 PM To: Multiple recipients of list ORACLE-L Subject: RE: URGENT Help on tracking unauthorized login to Oracle Database Joe, We referred the auditing option. My understanding is that you can track the oracle users using database auditing feature once the users are logged into the database. But my requirement is to track the users who tried to login to the database but could not login due to wrong password. For example, somebody may know the connect string for an oracle database and trying to login to the database as system user and with various combination of password. We like to know who are these users. Thanks, Ashoke -Original Message- Sent: Friday, February 08, 2002 11:54 AM To: Multiple recipients of list ORACLE-L Database Administrators guide chapter on auditing. joe Mandal, Ashoke wrote: Greetings, We have a database with very sensitive data. Our management wants me to find out the way to secure this data from unauthorized login and track these users who tried to login to this database. Is there any way we can track the unauthorized users, who try to login to an oracle database with invalid userid or password but with valid connect string. If there is no options under oracle then is there any 3rd party software for this purpose. Any help is appreciated Thanks, Ashoke -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joseph S Testa INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru
RE: URGENT Help on tracking unauthorized login to Oracle Database
Title: RE: URGENT Help on tracking unauthorized login to Oracle Database To track users who tried and logged into the database : SQL audit session; I don't know in which section you can find that in the Administrator Guide. Rivaldi -Original Message-From: Mandal, Ashoke [mailto:[EMAIL PROTECTED]]Sent: Monday, February 11, 2002 11:18 PMTo: Multiple recipients of list ORACLE-LSubject: RE: URGENT Help on tracking unauthorized login to Oracle Database Hi Revaldi and Joe (Testa), I went through the followingAdministrator's guide. Oracle8i Administrator's GuideRelease 2 (8.1.6)Part Number A76956-01 I could only see chapter 24 on 'Auditing database Use' and under that the following sub-sections. I went through these secition and could not find anything on unsuccessful login to oracle database. Could you please help me in ponting to the right chapter/section. Guidelines for Auditing Creating and Deleting the Database Audit Trail Views Managing Audit Trail Information Viewing Database Audit Trail Information Auditing Through Database Triggers Thanks, Ashoke -Original Message-From: Behar, Rivaldi [mailto:[EMAIL PROTECTED]]Sent: Friday, February 08, 2002 1:29 PMTo: Multiple recipients of list ORACLE-LSubject: RE: URGENT Help on tracking unauthorized login to Oracle Database Administrators guide. Chapter on auditing. Audit session. Rivaldi -Original Message- From: Mandal, Ashoke [mailto:[EMAIL PROTECTED]] Sent: Friday, February 08, 2002 12:54 PM To: Multiple recipients of list ORACLE-L Subject: RE: URGENT Help on tracking unauthorized login to Oracle Database Joe, We referred the auditing option. My understanding is that you can track the oracle users using database auditing feature once the users are logged into the database. But my requirement is to track the users who tried to login to the database but could not login due to wrong password. For example, somebody may know the connect string for an oracle database and trying to login to the database as system user and with various combination of password. We like to know who are these users. Thanks, Ashoke -Original Message- Sent: Friday, February 08, 2002 11:54 AM To: Multiple recipients of list ORACLE-L Database Administrators guide chapter on auditing. joe Mandal, Ashoke wrote: Greetings, We have a database with very sensitive data. Our management wants me to find out the way to secure this data from unauthorized login and track these users who tried to login to this database. Is there any way we can track the unauthorized users, who try to login to an oracle database with invalid userid or password but with valid connect string. If there is no options under oracle then is there any 3rd party software for this purpose. Any help is appreciated Thanks, Ashoke -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joseph S Testa INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Mandal, Ashoke INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: URGENT Help on tracking unauthorized login to Oracle Database
Title: RE: URGENT Help on tracking unauthorized login to Oracle Database The SQL reference has some information... http://docs.oracle.com/cd_database_generic_8.1.7/server.817/a85397/state10b.htm#2059074 HTH Tim -Original Message-From: Behar, Rivaldi [mailto:[EMAIL PROTECTED]]Sent: Tuesday, February 12, 2002 12:14 PMTo: Multiple recipients of list ORACLE-LSubject: RE: URGENT Help on tracking unauthorized login to Oracle Database To track users who tried and logged into the database : SQL audit session; I don't know in which section you can find that in the Administrator Guide. Rivaldi -Original Message-From: Mandal, Ashoke [mailto:[EMAIL PROTECTED]]Sent: Monday, February 11, 2002 11:18 PMTo: Multiple recipients of list ORACLE-LSubject: RE: URGENT Help on tracking unauthorized login to Oracle Database Hi Revaldi and Joe (Testa), I went through the followingAdministrator's guide. Oracle8i Administrator's GuideRelease 2 (8.1.6)Part Number A76956-01 I could only see chapter 24 on 'Auditing database Use' and under that the following sub-sections. I went through these secition and could not find anything on unsuccessful login to oracle database. Could you please help me in ponting to the right chapter/section. Guidelines for Auditing Creating and Deleting the Database Audit Trail Views Managing Audit Trail Information Viewing Database Audit Trail Information Auditing Through Database Triggers Thanks, Ashoke -Original Message-From: Behar, Rivaldi [mailto:[EMAIL PROTECTED]]Sent: Friday, February 08, 2002 1:29 PMTo: Multiple recipients of list ORACLE-LSubject: RE: URGENT Help on tracking unauthorized login to Oracle Database Administrators guide. Chapter on auditing. Audit session. Rivaldi -Original Message- From: Mandal, Ashoke [mailto:[EMAIL PROTECTED]] Sent: Friday, February 08, 2002 12:54 PM To: Multiple recipients of list ORACLE-L Subject: RE: URGENT Help on tracking unauthorized login to Oracle Database Joe, We referred the auditing option. My understanding is that you can track the oracle users using database auditing feature once the users are logged into the database. But my requirement is to track the users who tried to login to the database but could not login due to wrong password. For example, somebody may know the connect string for an oracle database and trying to login to the database as system user and with various combination of password. We like to know who are these users. Thanks, Ashoke -Original Message- Sent: Friday, February 08, 2002 11:54 AM To: Multiple recipients of list ORACLE-L Database Administrators guide chapter on auditing. joe Mandal, Ashoke wrote: Greetings, We have a database with very sensitive data. Our management wants me to find out the way to secure this data from unauthorized login and track these users who tried to login to this database. Is there any way we can track the unauthorized users, who try to login to an oracle database with invalid userid or password but with valid connect string. If there is no options under oracle then is there any 3rd party software for this purpose. Any help is appreciated Thanks, Ashoke -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joseph S Testa INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Mandal, Ashoke INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include
Re: URGENT Help on tracking unauthorized login to Oracle Database
Title: RE: URGENT Help on tracking unauthorized login to Oracle Database
Hi all,
I have never done this particular activity but by following the clues given
in this
thread AND BY reading the documentation I was able to make this work. The
steps I followed were.
1. change the initializaion parameter audit_trail to be:
audit_trail=db
shutdown and restart database
2. connect to the database as a user that has the privilege "AUDIT SYSTEM"
audit session whenever not successful
at this point you can see these unsuccessful logins by monitoring the
dba_audit_trail view.
John
[EMAIL PROTECTED] wrote:
The SQL reference has some information...
http://docs.oracle.com/cd_database_generic_8.1.7/server.817/a85397/state10b.htm#2059074
HTH
Tim
-Original Message-
From: Behar, Rivaldi[mailto:[EMAIL PROTECTED]]
Sent: Tuesday, February12, 2002 12:14 PM
To: Multiple recipients of listORACLE-L
Subject: RE: URGENT Help on tracking unauthorized login to
Oracle Database
Totrack users who tried and logged into the database :
SQL audit session;
Idon't know in which section you can find that in the Administrator
Guide.
Rivaldi
-Original Message-
From: Mandal, Ashoke [mailto:[EMAIL PROTECTED]]
Sent: Monday, February 11, 2002 11:18 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: URGENT Help on tracking unauthorized login
to Oracle Database
Hi Revaldi and Joe (Testa),
I went through the followingAdministrator's guide.
Oracle8i Administrator's Guide
Release 2 (8.1.6)
Part Number A76956-01
I could only see chapter 24 on 'Auditing database Use' and under that
the following sub-sections. I went through these secition and could
not find anything on unsuccessful login to oracle database.
Could you please help me in ponting to the right chapter/section.
Guidelines forAuditing
Creating andDeleting the Database Audit Trail Views
Managing AuditTrail Information
Viewing DatabaseAudit Trail Information
Auditing ThroughDatabase Triggers
Thanks,
Ashoke
-Original Message-
From: Behar, Rivaldi[mailto:[EMAIL PROTECTED]]
Sent: Friday, February08, 2002 1:29 PM
To: Multiple recipients of listORACLE-L
Subject: RE: URGENT Help on tracking unauthorized login
to Oracle Database
Administrators guide.
Chapter onauditing.
Audit session.
Rivaldi
-Original Message-
From:Mandal, Ashoke [
mailto:[EMAIL PROTECTED]
]
Sent: Friday, February 08, 2002 12:54 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: URGENT Help on tracking unauthorized
login toOracle
Database
Joe,
We referred the auditing option. My understanding
is thatyou can track the oracle users using database auditing feature
once theusers are logged into the database.
But my requirement is to track the users who tried
tologin to the database but could not login due to wrong password.
For example, somebody may know the connect string
for anoracle database and trying to login to the database as system
user andwith various combination of password. We like to know who
are theseusers.
Thanks,
Ashoke
-Original Message-
Sent:Friday, February 08, 2002 11:54 AM
To: Multiplerecipients of list ORACLE-L
Database
Administrators guide
chapter on auditing.
joe
Mandal, Ashoke wrote:
Greetings,
We have a database with very sensitive data.
Ourmanagement wants me to find out the way to secure this data from
unauthorized login and track these users who tried to login to this
database.
Is there any waywe can track the unauthorized
users, who try to login to an oracledatabase with invalid userid
or password but with valid connect string.
If there is nooptions under oracle
then is there any 3rd party software for thispurpose.
Any help is appreciated
Thanks,
Ashoke
--
Please see the officialORACLE-L FAQ:
http://www.orafaq.com
--
Author: Joseph S Testa
INET: [EMAIL PROTECTED]
Fat Ci
RE: URGENT Help on tracking unauthorized login to Oracle Database
Title: RE: URGENT Help on tracking unauthorized login to Oracle Database Hi Revaldi and Joe (Testa), I went through the followingAdministrator's guide. Oracle8i Administrator's GuideRelease 2 (8.1.6)Part Number A76956-01 I could only see chapter 24 on 'Auditing database Use' and under that the following sub-sections. I went through these secition and could not find anything on unsuccessful login to oracle database. Could you please help me in ponting to the right chapter/section. Guidelines for Auditing Creating and Deleting the Database Audit Trail Views Managing Audit Trail Information Viewing Database Audit Trail Information Auditing Through Database Triggers Thanks, Ashoke -Original Message-From: Behar, Rivaldi [mailto:[EMAIL PROTECTED]]Sent: Friday, February 08, 2002 1:29 PMTo: Multiple recipients of list ORACLE-LSubject: RE: URGENT Help on tracking unauthorized login to Oracle Database Administrators guide. Chapter on auditing. Audit session. Rivaldi -Original Message- From: Mandal, Ashoke [mailto:[EMAIL PROTECTED]] Sent: Friday, February 08, 2002 12:54 PM To: Multiple recipients of list ORACLE-L Subject: RE: URGENT Help on tracking unauthorized login to Oracle Database Joe, We referred the auditing option. My understanding is that you can track the oracle users using database auditing feature once the users are logged into the database. But my requirement is to track the users who tried to login to the database but could not login due to wrong password. For example, somebody may know the connect string for an oracle database and trying to login to the database as system user and with various combination of password. We like to know who are these users. Thanks, Ashoke -Original Message- Sent: Friday, February 08, 2002 11:54 AM To: Multiple recipients of list ORACLE-L Database Administrators guide chapter on auditing. joe Mandal, Ashoke wrote: Greetings, We have a database with very sensitive data. Our management wants me to find out the way to secure this data from unauthorized login and track these users who tried to login to this database. Is there any way we can track the unauthorized users, who try to login to an oracle database with invalid userid or password but with valid connect string. If there is no options under oracle then is there any 3rd party software for this purpose. Any help is appreciated Thanks, Ashoke -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joseph S Testa INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Mandal, Ashoke INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: URGENT Help on tracking unauthorized login to Oracle Database
Administrators guide chapter on auditing. joe Mandal, Ashoke wrote: Greetings, We have a database with very sensitive data. Our management wants me to find out the way to secure this data from unauthorized login and track these users who tried to login to this database. Is there any way we can track the unauthorized users, who try to login to an oracle database with invalid userid or password but with valid connect string. If there is no options under oracle then is there any 3rd party software for this purpose. Any help is appreciated Thanks, Ashoke -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joseph S Testa INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: URGENT Help on tracking unauthorized login to Oracle Database
Joe, We referred the auditing option. My understanding is that you can track the oracle users using database auditing feature once the users are logged into the database. But my requirement is to track the users who tried to login to the database but could not login due to wrong password. For example, somebody may know the connect string for an oracle database and trying to login to the database as system user and with various combination of password. We like to know who are these users. Thanks, Ashoke -Original Message- Sent: Friday, February 08, 2002 11:54 AM To: Multiple recipients of list ORACLE-L Database Administrators guide chapter on auditing. joe Mandal, Ashoke wrote: Greetings, We have a database with very sensitive data. Our management wants me to find out the way to secure this data from unauthorized login and track these users who tried to login to this database. Is there any way we can track the unauthorized users, who try to login to an oracle database with invalid userid or password but with valid connect string. If there is no options under oracle then is there any 3rd party software for this purpose. Any help is appreciated Thanks, Ashoke -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joseph S Testa INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Mandal, Ashoke INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: URGENT Help on tracking unauthorized login to Oracle Database
Title: RE: URGENT Help on tracking unauthorized login to Oracle Database I have an idea for a poor man's version of what you are looking for. Turn on listener logging to a level high enough where you can see the text of the net traffic. With some creativity or a copy of Sed Awk you'll be able to search for the invalid username/password text. A visual inspection of the surrounding log file lines will give you machine name, osuser, username, etc. Depending on your connection activity disk space may be an issue. We've implemented jobs to cycle the log every hour to reduce the disk consumption. I figure that you could do the same and delete any logs that don't have any violations in it. HTH Tony Aponte -Original Message- From: Mandal, Ashoke [mailto:[EMAIL PROTECTED]] Sent: Friday, February 08, 2002 1:54 PM To: Multiple recipients of list ORACLE-L Subject: RE: URGENT Help on tracking unauthorized login to Oracle Database Joe, We referred the auditing option. My understanding is that you can track the oracle users using database auditing feature once the users are logged into the database. But my requirement is to track the users who tried to login to the database but could not login due to wrong password. For example, somebody may know the connect string for an oracle database and trying to login to the database as system user and with various combination of password. We like to know who are these users. Thanks, Ashoke -Original Message- Sent: Friday, February 08, 2002 11:54 AM To: Multiple recipients of list ORACLE-L Database Administrators guide chapter on auditing. joe Mandal, Ashoke wrote: Greetings, We have a database with very sensitive data. Our management wants me to find out the way to secure this data from unauthorized login and track these users who tried to login to this database. Is there any way we can track the unauthorized users, who try to login to an oracle database with invalid userid or password but with valid connect string. If there is no options under oracle then is there any 3rd party software for this purpose. Any help is appreciated Thanks, Ashoke -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joseph S Testa INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Mandal, Ashoke INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: URGENT Help on tracking unauthorized login to Oracle Database
I stand by my original statement, look at auditing unsuccessful connections. joe Mandal, Ashoke wrote: Joe, We referred the auditing option. My understanding is that you can track the oracle users using database auditing feature once the users are logged into the database. But my requirement is to track the users who tried to login to the database but could not login due to wrong password. For example, somebody may know the connect string for an oracle database and trying to login to the database as system user and with various combination of password. We like to know who are these users. Thanks, Ashoke -Original Message- Sent: Friday, February 08, 2002 11:54 AM To: Multiple recipients of list ORACLE-L Database Administrators guide chapter on auditing. joe Mandal, Ashoke wrote: Greetings, We have a database with very sensitive data. Our management wants me to find out the way to secure this data from unauthorized login and track these users who tried to login to this database. Is there any way we can track the unauthorized users, who try to login to an oracle database with invalid userid or password but with valid connect string. If there is no options under oracle then is there any 3rd party software for this purpose. Any help is appreciated Thanks, Ashoke -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joseph S Testa INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: URGENT Help on tracking unauthorized login to Oracle Database
Title: RE: URGENT Help on tracking unauthorized login to Oracle Database Administrators guide. Chapter on auditing. Audit session. Rivaldi -Original Message- From: Mandal, Ashoke [mailto:[EMAIL PROTECTED]] Sent: Friday, February 08, 2002 12:54 PM To: Multiple recipients of list ORACLE-L Subject: RE: URGENT Help on tracking unauthorized login to Oracle Database Joe, We referred the auditing option. My understanding is that you can track the oracle users using database auditing feature once the users are logged into the database. But my requirement is to track the users who tried to login to the database but could not login due to wrong password. For example, somebody may know the connect string for an oracle database and trying to login to the database as system user and with various combination of password. We like to know who are these users. Thanks, Ashoke -Original Message- Sent: Friday, February 08, 2002 11:54 AM To: Multiple recipients of list ORACLE-L Database Administrators guide chapter on auditing. joe Mandal, Ashoke wrote: Greetings, We have a database with very sensitive data. Our management wants me to find out the way to secure this data from unauthorized login and track these users who tried to login to this database. Is there any way we can track the unauthorized users, who try to login to an oracle database with invalid userid or password but with valid connect string. If there is no options under oracle then is there any 3rd party software for this purpose. Any help is appreciated Thanks, Ashoke -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joseph S Testa INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Mandal, Ashoke INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: urgent help needed conversion
Jeroen it might indicate that your batch program is busy and doing stuff. the wait event you have mentioned is a idle wait event. In your next run, i would recommend that have breakpoints coded in the batch that writes into a error/log table about status and where the pgm has reached. also write a commit after u insert into the log table; are there any locking issues going on. take entire dump of wait/p1, p2, p3 from v$session_wait where wait=0(waiting) and post it Deepak --- Jeroen van Sluisdam [EMAIL PROTECTED] wrote: Hi, I'm in the middle of a conversion and something is holding the conversion program: v$session_wait: Enter value for sid: 285 SUBSTR(EVENT,1,20) SUBSTR(P1TEXT,1,30) SUBSTR(P2TEXT,1,20) -- SUBSTR(P3TEXT,1,30)STATE -- --- SQL*Net message from driver id #bytes WAITING This program is a batch program and not waiting for any user commands any ideas asap will be appreciated! Tia, Jeroen 7..3.4 hp ux 10.20 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jeroen van Sluisdam INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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!? Find a job, post your resume. http://careers.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Deepak Thapliyal INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: urgent help need please
Chark(sp?) - Is your listener running? David A. Barbour Oracle DBA, OCP AISD 512-414-1002 Sairlao, Chark SairlaoC@transfie To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] ld.com.au cc: Sent by: Subject: urgent help need please [EMAIL PROTECTED] 08/12/2001 10:30 PM Please respond to ORACLE-L all, our company just installed the virtual private network equipment (Enterasyss Network), then suddenly peoplesoft application can not login to the oracle database any more, came back with ora 12203, then I tries tnsping nothing works either, however I can do sqlplus user/password@tns and it lets me in ok. any idea please? Thanks And Regards Chark Sairlao -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sairlao, Chark INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Urgent - Help needed - Reports
Title: RE: Urgent - Help needed - Reports Hi, Thanks for ur reply. The printer drivers are installed on the server, is there any specific settings/configuration to be done on report server/builder? -Original Message- From: Dasko, Dan [SMTP:[EMAIL PROTECTED]] Sent: Friday, March 16, 2001 8:06 PM To: Multiple recipients of list ORACLE-L Subject: RE: Urgent - Help needed - Reports Is the printer driver for that printer installed on the machine with the reports server? That's the first thing I think of, but I've never actually had that problem. Dan -Original Message- From: Bathma Sivaraj [mailto:[EMAIL PROTECTED]] Sent: Friday, March 16, 2001 7:31 AM To: Multiple recipients of list ORACLE-L Subject: Urgent - Help needed - Reports C:\RWCLI60 REPORT=d:\oracle\oas408\report60\test.rdf [EMAIL PROTECTED] server=rep60_mp5main destype=Printer desname=\\RRSRV\RR_Printer,172.17.1.204: schedule=every_1_minute_from_now Jobname=testjob05 When i execute the above statement, i get the following error: Error is : REP-0713: Invalid printer name 'HP LaserJet 4050 PCL 6,LPT1:' specified by parameter DESNAME. Colud u please anyone help to resolve this problem, Thanks and Regards, Bathmasivaraj A, Software Engineer, Atos Origin India. Ltd., Email : mailto:[EMAIL PROTECTED] mailto:[EMAIL PROTECTED] _ This e-mail message has been scanned for the presence of all known computer viruses by the MessageLabs Virus Control Center. However, it is still recommended that you use local virus scanning software to monitor for the presence of viruses.
RE: Urgent - Help needed - Reports
Title: Urgent - Help needed - Reports I would agree with that, is it a networked PC that is being shared? If so, then the drivers need to be installed on the server. -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Dasko, DanSent: Friday, March 16, 2001 9:36 AMTo: Multiple recipients of list ORACLE-LSubject: RE: Urgent - Help needed - Reports Is the printer driver for that printer installed on the machine with the reports server? That's the first thing I think of, but I've never actually had that problem. Dan -Original Message-From: Bathma Sivaraj [mailto:[EMAIL PROTECTED]]Sent: Friday, March 16, 2001 7:31 AMTo: Multiple recipients of list ORACLE-LSubject: Urgent - Help needed - Reports C:\RWCLI60 REPORT=d:\oracle\oas408\report60\test.rdf [EMAIL PROTECTED] server=rep60_mp5main destype=Printer desname=\\RRSRV\RR_Printer,172.17.1.204: schedule=every_1_minute_from_now Jobname=testjob05 When i execute the above statement, i get the following error: "Error is : REP-0713: Invalid printer name 'HP LaserJet 4050 PCL 6,LPT1:' specified by parameter DESNAME." Colud u please anyone help to resolve this problem, Thanks and Regards, Bathmasivaraj A, Software Engineer, Atos Origin India. Ltd., Email : mailto:[EMAIL PROTECTED] mailto:[EMAIL PROTECTED] _This e-mail message has been scanned for the presence of all known computer viruses by the MessageLabs Virus Control Center. However, it is still recommended that you use local virus scanning software to monitor for the presence of viruses.
RE: ************Urgent Help me !!!**************
Negative . NO New database is Created . Recovery from a HOT or Cold Backup of Datafiles is Exactly Same . At The Time '2001-02-09:22:00:00' specified are you sure the Table Data Existed ? Else Recover to An EARLIER TIME -Original Message- From: Martin Kendall [SMTP:[EMAIL PROTECTED]] Sent: Tuesday, February 13, 2001 8:02 PM To: Multiple recipients of list ORACLE-L Subject: RE: Urgent Help me !!!** You will have to use your last Hot Backup file set and create a new database (use the alter database backup controlfile to trace for the create db statement). Then apply all the arch. redo files since THAT backup, UPTO the point before the Table was dropped. Then extract the Table data and insert it into your existing database. -Original Message- Sent: 13 February 2001 11:46 To: Multiple recipients of list ORACLE-L Dear All, In one of database the developer had deleted a table and commited it. database is in online backup but no export backup or table backup Please tell me how can I recover the the table . please guide me the exact detailed ed steps to recover the table . We have online backup .Archive log mode. We don`t have coldbackup.!!! I tried with shutdown the database. Strtup mount recover database until time '2001-02-09:22:00:00'; media recovery completed. alter database open it says noresetlogs or resetlogs. I tried with norestelog then no data found i that table. after that I tried with resetlogs. still then no rows select from that table. send me the possible way to recover the table.please send me thesteps to be done to recover the table. Regards, Saroj. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Dash, Saroj (CAP,CEF) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Martin Kendall INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: VIVEK_SHARMA INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: !!**** Urgent HELP (Table Deleted In Production )
When Attempting point in time recovery :- 1) Let Control File Online Redo Logfiles be the Latest ( Current ) Ensure that you have WRITE Permission to the Online Redo logfiles so that In case When the Database is Opened with RESETLOGS After Completion of Recovery , the Online Redo Logfiles will be Written to. 2) Extract ONLY the Datafiles from the Backup , NOT the Online Redo Logfiles from the Backup 3) The Database should be in MOUNT Condition (NOT Open) When Issuing the RECOVER DATABASE UNTIL TIME Command ? 4) After Completing the Roll forward by Applying the Archived ( Online Redo logs , if required ) Issue Command ALTER DATABASE OPEN RESETLOGS MISCELLANEOUS - Check v$backup to see if STATUS = ACTIVE for the respective Datafiles -Original Message- From: Rocky Welch [SMTP:[EMAIL PROTECTED]] Sent: Friday, February 09, 2001 11:19 PM To: Multiple recipients of list ORACLE-L Subject: Re: !! Urgent HELP (Table Deleted In Production ) Hi Saroj, If the table data isn't updated too often you can go back to an older export and import the table. If not, are you in archive log mode? Check your alert.log file for errors on the system datafile and let us know the status of your database to provide an accurate answer. -Rocky "Dash, Saroj (CAP,CEF)" [EMAIL PROTECTED] wrote: Dear Friends In product databace one of the developer had deleted a table and commited it , database is in online backup but no export backup or table backup Please tell me how can the table be recovered please guide me the exact detaied steps torecover the table After getting the reply i will start it Thanks and Best regards I tried this command recover database until time '2001-02-09:22:00:00' ; it gived the following error recovery session canceled due to errors ORA-01124: cannot recover data file 1 - file is in use or recovery ORA-01110: data file 1: '/db/oracle/oradata/tlisuser/system01.dbf' SVRMGR recover database ORA-00283: recovery session canceled due to errors ORA-01124: cannot recover data file 1 - file is in use or recovery ORA-01110: data file 1: '/db/oracle/oradata/tlisuser/system01.dbf' SVRMGR rec! ! over database until time '2001-02-09:22:00:00' ; ORA-00283: recovery session canceled due to errors ORA-01124: cannot recover data file 1 - file is in use or recovery ORA-01110: data file 1: '/db/oracle/oradata/tlisuser/system01.dbf' SVRMGR select * from v$backup ; then again i shut down the database then up it again i tried but same errors Plese reply soon saroj dash -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Dash, Saroj (CAP,CEF) INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or t! ! he 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 personalized email addresses from Yahoo! Mail Personal Address http://personal.mail.yahoo.com/ - only $35 a year! -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: VIVEK_SHARMA INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: ************Urgent Help me !!!**************
Hi, Try restoring an old backup first. Make sure that the newest datafile is older than the point you want to return to. Than do your PITR again. MAKE OFFLINE BACKUP FIRST BEFORE ANY CHANGES. ANother option is to restore on a different machine, export the table and import the table on the production machine. (NO other data lost) Jack "Dash, Saroj (CAP,CEF)" To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Saroj.Dash@geca cc: pital.com Subject: Urgent Help me !!!** Sent by: [EMAIL PROTECTED] 13-02-2001 12:45 Please respond to ORACLE-L Dear All, In one of database the developer had deleted a table and commited it. database is in online backup but no export backup or table backup Please tell me how can I recover the the table . please guide me the exact detailed ed steps to recover the table . We have online backup .Archive log mode. We don`t have coldbackup.!!! I tried with shutdown the database. Strtup mount recover database until time '2001-02-09:22:00:00'; media recovery completed. alter database open it says noresetlogs or resetlogs. I tried with norestelog then no data found i that table. after that I tried with resetlogs. still then no rows select from that table. send me the possible way to recover the table.please send me thesteps to be done to recover the table. Regards, Saroj. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Dash, Saroj (CAP,CEF) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). = De informatie verzonden in dit e-mailbericht is vertrouwelijk en is uitsluitend bestemd voor de geadresseerde. Openbaarmaking, vermenigvuldiging, verspreiding en/of verstrekking van deze informatie aan derden is, behoudens voorafgaande schriftelijke toestemming van Ernst Young, niet toegestaan. Ernst Young staat niet in voor de juiste en volledige overbrenging van de inhoud van een verzonden e-mailbericht, noch voor tijdige ontvangst daarvan. Ernst Young kan niet garanderen dat een verzonden e-mailbericht vrij is van virussen, noch dat e-mailberichten worden overgebracht zonder inbreuk of tussenkomst van onbevoegde derden. Indien bovenstaand e-mailbericht niet aan u is gericht, verzoeken wij u vriendelijk doch dringend het e-mailbericht te retourneren aan de verzender en het origineel en eventuele kopien te verwijderen en te vernietigen. Ernst Young hanteert bij de uitoefening van haar werkzaamheden algemene voorwaarden, waarin een beperking van aansprakelijkheid is opgenomen. De algemene voorwaarden worden u op verzoek kosteloos toegezonden. = The information contained in this communication is confidential and is intended solely for the use of the individual or entity to whom it is addressed. You should not copy, disclose or distribute this communication without the authority of Ernst Young. Ernst Young is neither liable for the proper and complete transmission of the information
Re: ************Urgent Help me !!!**************
Did you restore the data files from the last hot backup? Praveen "Dash, Saroj (CAP,CEF)" wrote: Dear All, In one of database the developer had deleted a table and commited it. database is in online backup but no export backup or table backup Please tell me how can I recover the the table . please guide me the exact detailed ed steps to recover the table . We have online backup .Archive log mode. We don`t have coldbackup.!!! I tried with shutdown the database. Strtup mount recover database until time '2001-02-09:22:00:00'; media recovery completed. alter database open it says noresetlogs or resetlogs. I tried with norestelog then no data found i that table. after that I tried with resetlogs. still then no rows select from that table. send me the possible way to recover the table.please send me thesteps to be done to recover the table. Regards, Saroj. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Dash, Saroj (CAP,CEF) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- +===+ | Praveen K. Gautam| | Tellabs, Inc.| +===+ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Praveen Gautam INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: ************Urgent Help me !!!**************
You will have to use your last Hot Backup file set and create a new database (use the alter database backup controlfile to trace for the create db statement). Then apply all the arch. redo files since THAT backup, UPTO the point before the Table was dropped. Then extract the Table data and insert it into your existing database. -Original Message- Sent: 13 February 2001 11:46 To: Multiple recipients of list ORACLE-L Dear All, In one of database the developer had deleted a table and commited it. database is in online backup but no export backup or table backup Please tell me how can I recover the the table . please guide me the exact detailed ed steps to recover the table . We have online backup .Archive log mode. We don`t have coldbackup.!!! I tried with shutdown the database. Strtup mount recover database until time '2001-02-09:22:00:00'; media recovery completed. alter database open it says noresetlogs or resetlogs. I tried with norestelog then no data found i that table. after that I tried with resetlogs. still then no rows select from that table. send me the possible way to recover the table.please send me thesteps to be done to recover the table. Regards, Saroj. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Dash, Saroj (CAP,CEF) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Martin Kendall INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: !!**** Urgent HELP (Table Deleted In Production )
Hi Saroj, If the table data isn't updated too often you can go back to an older export and import the table. If not, are you in archive log mode? Check your alert.log file for errors on the system datafile and let us know the status of your database to provide an accurate answer. -Rocky "Dash, Saroj (CAP,CEF)" [EMAIL PROTECTED] wrote: Dear Friends In product databace one of the developer had deleted a table and commited it,database is in online backup but no export backup or table backup Please tell me how can the table be recovered please guide me the exact detaied steps torecover the table After getting the reply i will start itThanks and Best regardsI tried this command recover database until time '2001-02-09:22:00:00' ;it gived the following error recovery session canceled due to errorsORA-01124: cannot recover data file 1 - file is in use or recoveryORA-01110: data file 1: '/db/oracle/oradata/tlisuser/system01.dbf'SVRMGR recover databaseORA-00283: recovery session canceled due to errorsORA-01124: cannot recover data file 1 - file is in use or recoveryORA-01110: data file 1: '/db/oracle/oradata/tlisuser/system01.dbf'SVRMGR rec! ! over database until time '2001-02-09:22:00:00' ;ORA-00283: recovery session canceled due to errorsORA-01124: cannot recover data file 1 - file is in use or recoveryORA-01110: data file 1: '/db/oracle/oradata/tlisuser/system01.dbf'SVRMGR select * from v$backup ;then again i shut down the database then up it again i tried but same errorsPlese reply soon saroj dash -- Please see the official ORACLE-L FAQ: http://www.orafaq.com-- Author: Dash, Saroj (CAP,CEF)INET: [EMAIL PROTECTED]Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051San Diego, California -- Public Internet access / Mailing ListsTo REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or t! ! he name of mailing list you want to be removed from). You mayalso send the HELP command for other information (like subscribing).Do You Yahoo!? - Get personalized email addresses from Yahoo! Mail Personal Address - only $35 a year!
