Re: Cannot log in as SYSDBA or SYSOPER - why?

Hi John,

On your database server you have to create a password file and you must add a parameter in your init<sid>.ora:

Enter the following line at the UNIX operating system prompt: orapwd file=$ORACLE_HOME/dbs/orapw$ORACLE_SID password=manager

Then add to your init<sid>.ora:
REMOTE_LOGIN_PASSWORDFILE=EXCLUSIVE restart database

To remotely shutdown the database you need to have the SYSDBA role, To startup also but you also must have a locally saved init<sid>.ora otherwise you won't be able to start an instance.

Regards,

John van der Steen

John Haskins wrote:

> I'm setting up Oracle Enterprise Manager to control three servers under my
> pervue. I have them "found" in OEM, but cannot execute shutdown/startup
> because I cannot log in using the SYSDBA or SYSOPER role. When I try to do
> so, it tells me that the user/pw combination is invalid, even though it is
> the same one I use when loggin in for standard DBA duties.
>
> How do I make this work? Being able to bounce an instance without having to
> go into the server room would be handy.
Received on Tue Aug 31 1999 - 13:28:08 CDT