Re: Can do sqlplus sys/manager@oracle - CAN'T DO sqlplus sys/manager - why is that ?

sqlplus sys/manager didn't work. That's the problem. sqlplus sys/manager_at_test work just fine.

NOTE: oracle processes are all up. tnsping works just fine, listener is up.

Cheng-Jih Chen wrote:

> In article <35EEDADF.C32C4279_at_yahoo.com>,
> giau45_at_yahoo.com <giau45_at_yahoo.com> wrote:
> >I have my database started under svrmgrl. (then I went home)
> >The next day, I do ps -ef|grep oracle, it shows all the processes are
> >running.
> >
> >Yet I can't do sqlpus sys/manager -
> >
> >However, I can do sqlplus sys/manager_at_test
> >
> >(test is my ORACLE_SID)
>
> Well, it's actually system/manager for the default system password.
>
> Also, if you're using the "@" construction, then you have to have
> "test" defined in your tnsnames.ora file, and have the TNS listener up
> and running.
>
> If you set ORACLE_SID appropriately, as well as ORACLE_HOME, "sqlplus
> system/manager" should be able to get you in.
Received on Thu Sep 03 1998 - 14:22:51 CDT