Re: help with connecting to sqlplus
Just check for the Oracle services in Control Panel- Services. ur Instance,TNS should be started. if not start these services and try connecting. Regards, Sathyanarayanan |+--- || john | || john_g123_9@| || yahoo.com | || | || 23/11/2002 | || 22:43| || Please | || respond to | || ORACLE-L | || | |+--- --| | | | To: Multiple recipients of list ORACLE-L | | [EMAIL PROTECTED] | | cc: (bcc: Sathyanaryanan K/VGIL) | | Subject: help with connecting to sqlplus | --| ver 8i on windows NT4 chose the Typical install in 8i during installation hence i guess a starter db is created by the installation via svrmgrl did startup trying to connect to sqlplus both gui as well as command line (on the same server box itself) tried with just sqlplus and it challenges for Enter user-name: i entered sys / as sysdba asks for password: i entered change_on_install error ORA-01033: Oracle initialization in progress. waited for 20 minutes, same error. did a shutdown and startup again, same error --- other clues/messages shutdown, shutdown normal show this Error ORA-01507: database not mounted connected to sqlplus with nolog and creating a sample table with CREATE TABLE or do a DESCRIBE TABLE for this shows not connected __ Do you Yahoo!? Yahoo! Mail Plus ? Powerful. Affordable. Sign up now. http://mailplus.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: john INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: help with connecting to sqlplus
John, Try this, $ sqlplus / as sysdba HTH ...Ponnusamy At 09:13 AM 11/23/2002 -0800, john wrote: ver 8i on windows NT4 chose the Typical install in 8i during installation hence i guess a starter db is created by the installation via svrmgrl did startup trying to connect to sqlplus both gui as well as command line (on the same server box itself) tried with just sqlplus and it challenges for Enter user-name: i entered sys / as sysdba asks for password: i entered change_on_install error ORA-01033: Oracle initialization in progress. waited for 20 minutes, same error. did a shutdown and startup again, same error --- other clues/messages shutdown, shutdown normal show this Error ORA-01507: database not mounted connected to sqlplus with nolog and creating a sample table with CREATE TABLE or do a DESCRIBE TABLE for this shows not connected __ Do you Yahoo!? Yahoo! Mail Plus Powerful. Affordable. Sign up now. http://mailplus.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: john 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). __ *Ponnu Rangasamy* Database Administration IT Application Services Ext. -15739 pgr -858 494 3812 __ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ponnusamy 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).