| start oracle instance from command line [message #63473] |
Thu, 07 October 2004 23:29  |
zhebincong
Messages: 4
Registered: August 2004
|
Junior Member |
|
|
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!!!
|
|
|
|
| Re: start oracle instance from command line [message #63477 is a reply to message #63473] |
Fri, 08 October 2004 02:03  |
dilip kumar
Messages: 111
Registered: December 2003
|
Senior Member |
|
|
Hi
since you have even shutdown the service of your database then follow this at dos prompt
1)Oradim -startup -sid service_name(this should your service name)
Note: don't specify any spaces between after - sign
2)set oracle_sid=service_name
3)sqlplus
4)enter the username and pwd(connect as DBA user)
5)startup(type this at sql prompt)
if you want to shutdown the service then
say
Oradim -shutdown -sid service_name(this should ur service name)
this will work
Regards
D.Dilip
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
