Re: Problem logging into Enterprise Manager in 10g

MichalF wrote:
> I have VERY strange problem logging into Enterprise Manager in 10
> rel.1:
> My environment: Linux RH ES3. Single server with simple database.
> I have set up EM using dbca
> When I try to log in through web borwser from the database server
> machine, I have to do the following: first try to log in as a normal
> user with no dba privileges - log on is denied because of insufficient
> privileges. Then I may log on as sysman. If I try to log in without the
> first attempt using normal user credentials I receive wrong login
> name/password error. Strange, isn't it?
> When I try to do the same trick from the other desktop on the network -
> it doesn't work at all! I can't log in anyhow - I got rejected with
> invalid username/password combination error.
> My suspision is that the server's hostname setup is invalid. On the
> server I use http://localhost:5501/em address to logon page, which is
> succesful (with peculiarities described above), on the desktop computer
> I use http://oraclepl:5501/em. After installation of EM there's a
> folder %ORAHOME%/localhost_dbname/ instead of oraclepl_dbname - maybe
> this is the problem why it behaves differently on server and other
> machine. But how to change it now?
> Where I should look for misconfiguration or error logs?
>

It's not clear (to me, anyway) if you are describing a problem logging on to EOM itself, or through OEM to a particular database. Be aware that it's not one and the same.

> Another strange thing that bothers me is that when I'm logged on as
> 'oracle' user I can log on to sqlplus as sysdba using any password
> except for empty one. Is it normal?

Yes, it is normal. Any os account that is a member of the os group 'dba' can connect as sysdba, and password checking is bypassed:

$> whoami
oracle
$> sqlplus foo/bar as sysdba

SQL*Plus: Release 10.2.0.1.0 - Production on Thu Sep 7 13:02:27 2006

Copyright (c) 1982, 2005, Oracle. All rights reserved.

Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 64bit Production Received on Thu Sep 07 2006 - 13:04:10 CDT