Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Once in OMS Console can't connect with SYSDBA Privileges
in init.ora : check REMOTE_LOGIN_PASSWORDFILE=
Gert
In article <053004AB42F0D31182EF009027FD33E51A8243_at_ktaemail01.villabosch.
de>,
Luca.Bernardi_at_eml.villa-bosch.de ("Bernardi, Luca") wrote:
> This message is in MIME format. Since your mail reader does not
understand
> this format, some or all of this message may not be legible.
>
> ------_=_NextPart_001_01C0611E.2C9E8BB8
> Content-Type: text/plain;
> charset="iso-8859-1"
>
> I have two databases. One is local and one is remote. The local one
contains
> the repository.
> The OMS runs locally and the OMS Console runs locally. In order to
avoid
> confusion, I didn't set any
> preferred credentials.
> 1) I enter the OMS Console with the OMS Console password.
> 2) I try to access the databases (with either SYS or SYSTEM and the
initial
> standard passwords, but if I choose the SYSDBA option, I get the
> "insufficient privileges" error.
> 3)I can only access with the NORMAL or SYSOPER option, but that's not
> enougth for some DBA operations.
>
> How do I fix this?
> Best,
>
> Luca
>
> ------_=_NextPart_001_01C0611E.2C9E8BB8
> Content-Type: text/html;
> charset="iso-8859-1"
> Content-Transfer-Encoding: quoted-printable
>
> <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
> <HTML>
> <HEAD>
> <META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; =
> charset=3Diso-8859-1">
> <META NAME=3D"Generator" CONTENT=3D"MS Exchange Server version =
> 5.5.2650.12">
> <TITLE>Once in OMS Console can't connect with SYSDBA
Privileges</TITLE>
> </HEAD>
> <BODY>
>
> <P><FONT SIZE=3D2 FACE=3D"Courier New">I have two databases. One is =
> local and one is remote. The local one contains the repository.</FONT>
> <BR><FONT SIZE=3D2 FACE=3D"Courier New">The OMS runs locally and the =
> OMS Console runs locally. In order to avoid confusion, I didn't set
any =
> </FONT>
> <BR><FONT SIZE=3D2 FACE=3D"Courier New">preferred credentials. </FONT>
> <BR><FONT SIZE=3D2 FACE=3D"Courier New">1) I enter the OMS Console
with =
> the OMS Console password.</FONT>
> <BR><FONT SIZE=3D2 FACE=3D"Courier New">2) I try to access the =
> databases (with either SYS or SYSTEM and the initial standard =
> passwords, but if I choose the SYSDBA option, I get the =
> "insufficient privileges" error. </FONT></P>
>
> <P><FONT SIZE=3D2 FACE=3D"Courier New">3)I can only access with the =
> NORMAL or SYSOPER option, but that's not enougth for some DBA =
> operations.</FONT>
> </P>
>
> <P><FONT SIZE=3D2 FACE=3D"Courier New">How do I fix this?</FONT>
> <BR><FONT SIZE=3D2 FACE=3D"Courier New">Best,</FONT>
> </P>
>
> <P><FONT SIZE=3D2 FACE=3D"Courier New">Luca</FONT>
> </P>
> <BR>
>
> </BODY>
> </HTML>
> ------_=_NextPart_001_01C0611E.2C9E8BB8--
>
> --
> Posted from tigershark.villa-bosch.de [195.185.79.56]
> via Mailgate.ORG Server - http://www.Mailgate.ORG
>
Sent via Deja.com http://www.deja.com/
Before you buy.
Received on Fri Dec 08 2000 - 14:34:13 CST