Home » RDBMS Server » Enterprise Manager » incorrect database name in OEM (Oracle 9i v9.2.0 - Windows XP)
incorrect database name in OEM [message #299281] Mon, 11 February 2008 03:26 Go to next message
Junior
Messages: 1
Registered: February 2008
Location: Belgium
Junior Member
Hello;

I am a junior Oracle dba.
I have created a test database to make some exercises.
The db is called "testdb", and it is installed on a Windows 2003 server.

The problem is: OEM can find the database, but instead of calling it "testdb", OEM gives it a name like
"testdb_<servername>_<domain>". Confused

This is not the standard here at the office,
so I'm trying to find out what is wrong.
I checked in listener.ora on the server, and I think it is correctly defined:
SID_LIST_LISTENER =
(SID_DESC =
(SID_NAME = TESTDB)
(ORACLE_HOME = E:\oracle\ora92)

So then I logged onto the server, and checked for the database name with the command "lsnrctl services".
Its response concerning the testdb is:
******
Service "TESTDB" has 1 instance(s).
Instance "TESTDB", status UNKNOWN, has 1 handler(s) for this service...
Handler(s):
"DEDICATED" established:0 refused:0
LOCAL SERVER
Service "testdb.<domain>.int" has 1 instance(s).
Instance "testdb", status READY, has 1 handler(s) for this service...
Handler(s):
"DEDICATED" established:1 refused:0 state:ready
LOCAL SERVER
******

Does anyone have an idea as to why OEM changes the database name into "testdb_<servername>_<domain>" ?
For the rest the db seems to run fine.

Many thanks in advance;
Carl
Re: incorrect database name in OEM [message #301995 is a reply to message #299281] Fri, 22 February 2008 11:10 Go to previous messageGo to next message
harshad.gohil
Messages: 157
Registered: April 2007
Location: USA
Senior Member
Cal, may be bug... but I would suggest to remove and add explicitly db with proper name.
Re: incorrect database name in OEM [message #302061 is a reply to message #301995] Fri, 22 February 2008 18:34 Go to previous messageGo to next message
DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland
Senior Member
I guess it gets information from your pfile/spfile in which you defined the name for

db_domain

check this parameter

SQL> show parameter db_domain

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
db_domain                            string      mybox.abc.com


SQL> show parameter service_names

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
service_names                        string      mydb.mybox.abc.com


Which discovered in OEM.Check these possibilities.
Re: incorrect database name in OEM [message #302462 is a reply to message #299281] Mon, 25 February 2008 18:28 Go to previous message
rhziaDBA
Messages: 17
Registered: February 2008
Location: Madrid
Junior Member
you must to check your hosts file that is placed in the c:\windows\system32\drivers\etc\hosts

Edit this file and add a entry (if this not exist) of this way:

IP_ADRESS HOSTNAME.DOMAIN HOSTNAME

Example

127.5.5.60 mydomain.com mydomain

Before this you must try to run the emctl start dbconsole in order to up your OEM

Regards
Previous Topic: Schedule Backup with OEM
Next Topic: No Data available on HOst CPu and Active Sessions
Goto Forum:
  


Current Time: Thu Mar 28 16:09:02 CDT 2024