| incorrect database name in OEM [message #299281] |
Mon, 11 February 2008 03:26  |
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>". 
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 #302061 is a reply to message #301995] |
Fri, 22 February 2008 18:34  |
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 |
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
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
