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

On Thu, 03 Sep 1998 12:22:51 -0700, "giau45_at_yahoo.com" <giau45_at_yahoo.com> wrote:

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

But you ignored the answer at the bottom of his reply. Make sure that your ORACLE_HOME and ORACLE_SID environment variables are setup correctly. They should match the setting for the tnsalias in your listener.ora file as that connection is apparently working.

By "isn't working" I take it you get an error message - probably ORA1034?
>
>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.

David
(opinions are mine and do not necessarily reflect those of my employer etc.) Received on Thu Sep 03 1998 - 18:34:36 CDT