Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: OEM: Can't connect to database as sysdba

Re: OEM: Can't connect to database as sysdba

From: Richard Foote <Richard.Foote_at_bigpond.com>
Date: Mon, 19 Aug 2002 11:34:20 +1000
Message-ID: <3D604B1C.76803C04@bigpond.com>


Hi ABC,

Have you created a password file (orapwd utility) ?

Have you granted to user sysdba privileges (grant sysdba to scott)

Is your parameter remote_login_passwordfile=exclusive (or is it none) ?

Do the above and you should be hunky dory.

Cheers

Richard

abc_at_iom.com wrote:
>
> I'm using Oracle 9.2 on NT. I have OEM installed and am unable to
> connect up to databases as sysdba. I log into OEM as systman. I can
> see my nodes and the databases on those nodes. I can connect to these
> databases and look at the objects but I cannot connect as sysdba. For
> example, I can log in to a database as SYSTEM/manager using the
> setting "Normal". If I change it to SYSDBA, I get the message
> "Insufficient Privileges". I have set the prefered credentials for
> the node as well as the databases and set them to the proper
> passwords. I've set them to log in as sysdba, but to no avail.
>
> Any thoughts on this problem?
Received on Sun Aug 18 2002 - 20:34:20 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US