Database Control Underlying Link

[Duke02]

I have inherited an Oracle 10g system and I am not a DBA. I was asked to create a new instance of a db which I was successful. Looking at the last person's work who I can not contact, he set up a link in Start-Program-Oracle 10g-Database Control <dbname>. There is an underlying link to that option that opens the db -

http://<machine

name>.dtada.net:5501/em
I made a dup of that entry in the same folder renamed to my new db but obviously, that underlying link to the other db still exists. How can I find the link that applies to the new database that I created? Many thanks to all!!

 

[pete91z]

on the server where you have created the new database try this command:

emctl status dbconsole

 

[pete91z]

Sorry forgot to mention, set ORACLE_SID to the new database and then try the emctl command.

 

[Duke02]

i did:
set oracle_sid=usclus4

got no error

then
emctl status dbconsole

and got

OC4J Configuration issue. D:\oracle\product\10.2.0\db_1/oc4j/j2ee/OC4J_DBConsole_DTOR53.dtada.net_US not found.

did i do the set correctly?

 

[pete91z]

Hi,

Didn't realise you were using windows. I'm not totally sure how you set the oracle_sid, whether set oracle_sid=usclus4 does it or not. However, that error appears to be down to dbconsole not being set up. You can use the following command:

emca -config dbcontrol db -repos create

You'll be required to enter some passwords and email addresses. Once complete, try emctl status dbconsole again.