RE: Problem starting Oracle on W2K

Thanks Chip !

well then if the service is started, i dont need the startora.sql !!!

-----Original Message-----
Sent: Tuesday, February 25, 2003 12:34 AM To: Multiple recipients of list ORACLE-L

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

The windows service has to be started before connect internal works.

Have Fun :)

netmadcap_at_netzero.com wrote:

>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: Chip
  INET: ocp-dba_at_earthlink.net

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: <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).