"DJ" <nospamplease_at_goaway.com> wrote in message news:<ohVUb.530$vo1.255_at_newsfep4-winn.server.ntli.net>...
> "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?
did you mean to set an environment variable called "ORACLE_SID"? I
don't think so. Anyway, I gave a try with same error.
Received on Sat Feb 07 2004 - 01:37:32 CST
