Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: OEM: Can't connect to database as sysdba
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