ERPstuff - Oracle EBS Community

Dear Members.

How do i connect 10g OEM with 9i Database (which is installed on other Server)

I want to access Oracle 9i Database with 10g Enterprise Manager

Is there No way that i can manage / Access 9i Database with 10g Enterprize Manager?????

The only solution of ur problem is enterprise manager grid control

Regards
Faisal Iqbal

Hi

You can connect with a single database at a time through any client browser that has access to that database server. All you need to do is find the exact URL and status if EM is running. You need to type command below on DB server to know the status and URL as well that you can use to connect from any client browser.

emctl status dbconsole

URL should be able to see something like this:

http://localhost:5500/em

Note: If you have several version of databases installed on the same DB server, each database must have different port numbers to connect.

Anytime you can start/stop the EM dbconsole with commands below. You have to set the ORACLE_SID enviroment variable before start/stop the dbconsole.

For Linux:
export ORACLE_SID=<database_sid>

For Windows:
SET ORACLE_SID=<database_sid>

emctl start dbconsole
emctl stop dbconsole

Tip: You can setup EM email notification to know database status if it goes down or comes up.

Thanks
Amir

Oracle 9i and Oracle 10g Both are installed on Seperate Servers,
Not on the Same Machine. is there still need to Set its Oracle SID enviroment variable

Hi

It depends on your OS, if it's Linux box then you have to specify ORACLE_SID once you are starting EM. However Windows installation always puts an entry in the registry (under: \HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\SYSMAN\OracleDBConsole<ORACLE_SID>).
So you just need to start the EM either typing command manully or though Services control.

Thanks
Amir