Re: can't shutdown oracle server using enterprise manager

Hi Pedro,

Check the init<sid>.ora parameter remote_password_file. This should be set to exclusive. Otherwise the sysdba and sysoper privileges will not be recognised.

You should have a passwordfile defined. You can verify which users are in the passwordfile by select * from v$pwd_file_users (there may be more or less _ in the tablename).

The password file usually is defined using the orapwd utility. On NT the Oracle Instance Manager is also capable of creating a password file.

BTW: connect internal should work always in svrmgr. If that also doesn't work, there is a registrykey in the Oracle subtree (don't remember exactly which one) which should be set to BYPASS. The Oracle docs will have details about this

Hth,

Sybrand Bakker, Oracle DBA

Pedro Tavares wrote:

> Somehow I'm just not abble of shutingdown or starting an Oracle 7.3 server
> using the Enterprise Manager.
> I am connected as sys - sysoper and I always get the same message:
> MGR-03524: unable to shutdown the database.
> ORA-01031: insufficient privileges
> If someone could give me a sugestion I would appreciate.
> Thanks in advance
>
> Pedro Tavares

Received on Thu Nov 19 1998 - 12:07:27 CST