Start oralce 92 manually on WinXP

hi,

I am switching my Oracle practice from Solaris to Windows. I'm wondering how to start up oracle server in command line?

So far, I use "net start OracleServiceDBNAME", it worked fine. But when I tried another way "sqlplus /nolog; conn sys/sys_pw as sysdba", it showed:
"ERROR: ORA-12560: TNS:protocol adapter error." It is supposed to be
"Connected to an idle instance". My tnsnames.ora is absolutely
correct. What is wrong?

Another thing is about shutting down Oracle in command line, similarly, I can use either "net stop OracleServiceDBName" or "sqlplus /nolog; conn sys/sys_pw as sysdba; shutdown", both work well, but the former releases all Oracle threads from memory completely, the latter leaves 3 Oracle threads taking about 23m. What are these remaining threads for?
Plus, with these remaing Oracle threads running, "sqlplus /nolog; conn sys/sys_pw as sysdba" will leads to "Connected to an idle instance", just like the way Unix does.

Any comments are welcome. Received on Fri Feb 06 2004 - 16:29:28 CST