how to start oracle from command line

[zb cong]

hello
i download and install oracle10g in my laptop computer(windows xp),and works well.in order to save the resource of my machine,i modify all the oracle services in the windows service console to MANUAL,when i need,i can start it from the service console.

but sometimes,i need to start the oracle from the dos windows,i execute following command sequence:

1 lsnrctl start
the tns listener can be started successfully.
2 set oracle_sid=mydb
mydb is my oracle instance name.
3 sqlplus /nolog
i can enter the sqlplus prompt.
4 connect /as sysdba
failed,"ORA-12560: TNS: protocol adapter error".
if i start my oracle instance FIRST from the windows service console,then the "connect /as sysdba" works.


but i want to start oracle COMPLETELY from the command line,how?

thank for any helps!!!

[Stefan Wagner]

Don't you have to define the SID before starting lsnctrl?

[Nicholas Cheung]

Have you checked for the configuration files?

Nick

[Paul creamer]

I had a problem and tried to totally reinstall version 9.
I got this error previous to the resinstall and now continue to get same error. Oracle said to re-install XP, which isnt gonna happen.
I hate when phone techs, say reinstall OS...when it isnt really the reason or the fault. I dont plan to reinstall this pc's os just for oracle.
When I did the reinstall it was fresh install in that I removed all site of ORACLE anything from registry and from the HD.
The windows eror at the end tells me its external to oracle and maybe something else, and maybe a windows problem but I wont reinstall XP on this computer just to fix oracle....or at least not till Im ready to.


LSNRCTL for 32-bit Windows: Version 9.0.1.1.1 - Production on 03-DEC-2004 22:32:19

Copyright (c) 1991, 2001, Oracle Corporation. All rights reserved.

Starting tnslsnr: please wait...

TNSLSNR for 32-bit Windows: Version 9.0.1.1.1 - Production
System parameter file is D:\oracle\ora90\network\admin\listener.ora
Log messages written to D:\oracle\ora90\network\log\listener.log
Error listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=pjc-office)(PORT=1521)))
TNS-12546: TNS ermission denied
TNS-12560: TNS rotocol adapter error
TNS-00516: Permission denied
32-bit Windows Error: 13: Permission denied

Listener failed to start. See the error message(s) above...

[email protected]
[ December 03, 2004: Message edited by: Paul creamer ]