RE: How to startup oracle9i without using windows services
- From: "Mercadante, Thomas F (LABOR)" <Thomas.Mercadante@xxxxxxxxxxxxxxxxx>
- To: <Vajrala.Madhusudana@xxxxxxxx>, "GBA-DBA " <gba.oraclel@xxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
- Date: Fri, 8 Jul 2005 10:55:35 -0400
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@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On
Behalf Of Vajrala, Madhusudana R.
Sent: Friday, July 08, 2005 10:43 AM
To: 'GBA-DBA '; 'oracle-l-bounce@xxxxxxxxxxxxx '; 'oracle-l@xxxxxxxxxxxxx '
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@xxxxxxxxxxxxx
To: oracle-l@xxxxxxxxxxxxx
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
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
Other related posts:
