topic Re: Unable to connect to OEM by sys as sysdba in Operating System - HP-UX

Unable to connect to OEM by sys as sysdba

V.Tamilvanan — Fri, 15 Aug 2003 07:29:28 GMT

Hi all,
Recently i have created manually an oracle 9i database.I am able to connect to sqlplus as sys (as sysdba). But I couldn't through the gui oemapp dbastudio OEM.
I could able to connect as system to OEM but not as sys.
Can somebody throw some light on this.

TIA.

Re: Unable to connect to OEM by sys as sysdba

Alexander M. Ermes — Fri, 15 Aug 2003 07:53:46 GMT

Hi there.
Default user for Oracle Enterprise Manager is SYSMAN.
Default password is oem_temp.
Try to run OEM console.
If it works, it should ask you for new password.
Rgds
Alexander M. Ermes

Re: Unable to connect to OEM by sys as sysdba

V.Tamilvanan — Fri, 15 Aug 2003 08:02:15 GMT

Hi Alexander,
We don't have any oracle management server. I am trying to connect to the local oracle server only as sys.
I am able to connect through sqlplus the same with the same password.

Pls. help me to connect to the gui as sys.

TIA.

Re: Unable to connect to OEM by sys as sysdba

Massimo Bianchi — Mon, 18 Aug 2003 05:38:31 GMT

Hi Tamil,
which string do you use for connecting and which OEM are you using, the one that comes with the 9i or an older one ?

From your PC, are you able to connct to the oracledb?

Fron the CLI, can you connect as "sys@SID as sysdba" ?
I suspect that some grants are missing, like sysdba, and the remote_login_password_file is set to public and not to exclusive.

After setting the parameter to exclusive, rememebr to creare the password file with the command orapw.

Massimo

Re: Unable to connect to OEM by sys as sysdba

Indira Aramandla — Mon, 18 Aug 2003 05:40:57 GMT

Hi Tamil,

When logging into the OEM Console application, leave the default as "Connect as NORMAL". The SYSDBA or SYSOPER privileges can be set for each database from within the OEM console.

If you need to logon as SYSDBA, set the Preferred Credentials from within the OEM Console.

To set these privileges:

1. Select FILE->PREFERENCES from within the OEM Console.
2. Highlight the database and change the role from NORMAL to either SYSDBA or SYSOPER.
3. Click APPLY.

The next time you attempt to connect from the OEM applications, the application will connect as the role you selected.

Note: Before the SYSDBA role can be granted to a user, the init.ora file must have the parameter "REMOTE_LOGIN_PASSWORDFILE=EXCLUSIVE.

I hope this helps.

Re: Unable to connect to OEM by sys as sysdba

Yogeeraj_1 — Mon, 18 Aug 2003 09:06:57 GMT

hi TIA,

You need to grant the sysdba role to the user.

Note that, by default the internal user has the sysdba privilege. The system and sys do not.

hope this helps!
regards
Yogeeraj

Re: Unable to connect to OEM by sys as sysdba

V.Tamilvanan — Mon, 25 Aug 2003 05:25:18 GMT

Hi All,

Thanks for all the replies. Right now the parameter REMOTE_LOGIN_PASSWORDFILE=NONE is set in my init.ora file. So the authentication is done by the OS. But we cannot login as sys through gui if we set OS authentication.
As Massimo and indira told if I set
REMOTE_LOGIN_PASSWORDFILE=exclusive I should be able to connect as user sys as sysdba through gui.

Thanks.

Re: Unable to connect to OEM by sys as sysdba

T G Manikandan — Mon, 25 Aug 2003 05:37:28 GMT

yes,
It should be

REMOTE_LOGIN_PASSWORDFILE=exclusive
to login from DBA studio

That should resolve the problem.

Also query your v$pwfile_users

check whether the user has the sysdba privilege.

Thanks