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.
>
>NOTE: oracle processes are all up. tnsping works just fine, listener is
>up.

Do you have TWO_TASK set? That would overide ORACLE_SID. Manager is not the default password for SYS, but you probably shouldn't broadcast passwords to the world. You might also want to get into the habit of not naming things "test" on unix, or you will eventually run into the situation of conflict with shell syntax.

jg

>
>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.
>
>
>

--
These opinions are my own and not necessarily those of Information Quest or Pebble In The Sky http://www.informationquest.com mailto:jgarry@nospameiq.com http://ourworld.compuserve.com/homepages/joel_garry Remove nospam to reply. mailto:joel_garry_at_compuserve.nospam.com "See your DBA?" I AM the @#%*& DBA! Received on Thu Sep 03 1998 - 15:45:44 CDT