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

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 - 00:00:00 CDT