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: Mike Dwyer <abc_at_iom.com>
Date: Mon, 19 Aug 2002 04:47:13 GMT
Message-ID: <3d607817.366051974@news.sf.sbcglobal.net>


Do I have to do this even though I'm using 9.2? I didn't see anything in the documentation for OEM regarding this. But I'll give it a whirl.

On Mon, 19 Aug 2002 11:34:20 +1000, Richard Foote <Richard.Foote_at_bigpond.com> wrote:

>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 - 23:47:13 CDT

Original text of this message

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