RE: How to startup oracle9i without using windows services

I don't think this will work. Sqlplus will not work without the services running.

GBA, another way to do this:

When the database is up, do the following:

Net start | more

Look for the name of the Oracle service that is running. It will be something like OracleServiceSID.

>From the Dos prompt, you can:

Net start OracleServiceSID

You can also

Net stop OracleServiceSID.

Hope this helps.

Tom

-----Original Message-----
From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Vajrala, Madhusudana R. Sent: Friday, July 08, 2005 10:43 AM
To: 'GBA-DBA '; 'oracle-l-bounce_at_freelists.org '; 'oracle-l_at_freelists.org ' Subject: RE: How to startup oracle9i without using windows services

Hi,

1. Set ORACLE_SID and ORACLE_HOME on command prompt
2. sqlplus
3. startup pfile='/path/to/oracle/prameter/file.ora'

Its been a while i worked on windows database, but i guess this should allow you to start the database.

PS: Try "tnsping <tns-alias-to-your-oraclesid>" to see if your TNS setup is fine.

Regards,
Madhu

-----Original Message-----
From: oracle-l-bounce_at_freelists.org
To: oracle-l_at_freelists.org
Sent: 7/7/2005 11:56 PM
Subject: How to startup oracle9i without using windows services

Hi list, i would like to know how you guys do to startup oracle9i in winxp without using the windows services. I'm trying with a cmd window using:  

sqlplus / nolog -- That's ok  

connect / as sysdba -- Getting this error ERROR:
ORA-12560: TNS:protocol adapter error  

I've noticed that once the db is running (started with services) i can connect īn a cmd window using the above command.  

Any clues??  

Regards
GBA

--
http://www.freelists.org/webpage/oracle-l
--
http://www.freelists.org/webpage/oracle-l