Re: Start oralce 92 manually on WinXP

"Oracle4Unix" <lazyoracle_at_yahoo.com> wrote in message news:d8a63e05.0402061429.35b6ed2d_at_posting.google.com...
> 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.

when you dont supply a sid your tnsnames or listener isnt touched. So is your Oracle SiD set before you run sql plus? Received on Fri Feb 06 2004 - 17:18:39 CST