Oracle-L: RE: Problem starting Oracle on W2K

From: BanarasiBabu Tippa <btippa_at_ORsoftware-india.com>
Date: Mon, 24 Feb 2003 21:58:55 -0800
Message-ID: <F001.00557F72.20030224215855@fatcity.com>

I remembered On Windows platforms, the OracleServiceSID service must be started before
connecting to the instance using SVRMGRL.

thanks
Banarasi Babu T
OCP, DBA -----Original Message-----
Sent: Tuesday, February 25, 2003 2:24 AM To: Multiple recipients of list ORACLE-L

Hi ...

oracle 817 ee
os - win2k sp3

since i dont want oracle to start always on my home pc, i have changed the services to manual. whenever i want oracle, i run the below batch file :

set ORACLE_HOME=d:\oracle\ora81
set ORACLE_SID=everest
lsnrctl start
svrmgrl @startora.sql

/* startora.sql */
connect internal
startup
exit

but when i start svrmgrl, i get the error "ORA-12560: TNS:protocol adapter error". but if i start oracle from the services, i can start svrmgrl without any error.

what wrong m i doing ?

thanks !

--

Please see the official ORACLE-L FAQ: http://www.orafaq.net
--

Author: <netmadcap_at_netzero.com
INET: netmadcap_at_netzero.com

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: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: BanarasiBabu Tippa
INET: btippa_at_ORsoftware-india.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------