Enterprise Manager Database Control URL

[huchen]

Hello,
I installed Personal Oracle Database 10g Release 10.2.0.1.0 to practice something.

after I install the database, I was able to open EM database control from this URL:

http://mymachine.COM:1158/em

But after I reboot my machine, I got "The page cannot be displayed" error.

The database is up because I can login to db from

http://mymachine.COM:5560/isqlplus

How can I open EM database control?

following is from install\readme.txt:

Enterprise Manager Database Control URL - (mydb2) :

http://mymachine.COM:1158/em

Your database configuration files have been installed in C:\oracle\product\10.2.0 while other components selected for installation have been installed in C:\oracle\product\10.2.0\db_2. Be cautious not to accidentally delete these configuration files.
The iSQL*Plus URL is:

http://mymachine.COM:5560/isqlplus

The iSQL*Plus DBA URL is:

http://mymachine.COM:5560/isqlplus/dba

Thank you!

 

[oradba101]

Hi, Hutchen

From rhe command line:

emctl start dbconsole

Regards,




William Chadbourne
Oracle DBA

 

[huchen]

Hi, William

I got following error from the command line:
C:\>emctl start dbconsole
Environment variable ORACLE_SID not defined. Please define it.

I check my registration file, and here is the section:

[HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\KEY_OraDb10g_home2]
"ORACLE_HOME"="C:\\oracle\\product\\10.2.0\\db_2"
"ORACLE_HOME_NAME"="OraDb10g_home2"
"ORACLE_GROUP_NAME"="Oracle - OraDb10g_home2"
"NLS_LANG"="AMERICAN_AMERICA.WE8MSWIN1252"
"ORACLE_BUNDLE_NAME"="Personal"
"OLEDB"="C:\\oracle\\product\\10.2.0\\db_2\\oledb\\mesg"
"StmtCacheSize"="0"
"StatementCacheSize"="0"
"ORACLE_SID"="shudb2"
"OO4O"="C:\\oracle\\product\\10.2.0\\db_2\\oo4o\\mesg"
"SQLPATH"="C:\\oracle\\product\\10.2.0\\db_2\\dbs"
"ORACLE_HOME_KEY"="SOFTWARE\\ORACLE\\KEY_OraDb10g_home2"
"MSHELP_TOOLS"="C:\\oracle\\product\\10.2.0\\db_2\\MSHELP"
"ORACLE_BASE"="C:\\oracle\\product\\10.2.0"
"RDBMS_CONTROL"="C:\\oracle\\product\\10.2.0\\db_2\\DATABASE"
"RDBMS_ARCHIVE"="C:\\oracle\\product\\10.2.0\\db_2\\DATABASE\\ARCHIVE"
"ORA_SHUDB2_AUTOSTART"=hex(2):54,00,52,00,55,00,45,00,00,00
"ORA_SHUDB2_SHUTDOWN"=hex(2):54,00,52,00,55,00,45,00,00,00


Could you tell me what I should do next?

Thank you!

 

[oradba101]

Hi, Huchen

How many times have you installed Oracle on your workstation?

Regards,

William Chadbourne
Oracle DBA

 

[huchen]

two times.

I could not open Database control URL from first install after reboot my machine, I thought I missed something during installation, so I deleted all files I could from db_1 folder(there is no way to uninstall). Then I installed again(which is db_2 folder). Then I still can not open the URL. That is why I am here asking for help.

the first one is this:
[HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\KEY_OraDb10g_home1]
"ORACLE_HOME"="C:\\oracle\\product\\10.2.0\\db_1"
"ORACLE_HOME_NAME"="OraDb10g_home1"
"ORACLE_GROUP_NAME"="Oracle - OraDb10g_home1"
"NLS_LANG"="AMERICAN_AMERICA.WE8MSWIN1252"
"ORACLE_BUNDLE_NAME"="Personal"
"OLEDB"="C:\\oracle\\product\\10.2.0\\db_1\\oledb\\mesg"
"StmtCacheSize"="0"
"StatementCacheSize"="0"
"ORACLE_SID"="shulocal"
"OO4O"="C:\\oracle\\product\\10.2.0\\db_1\\oo4o\\mesg"
"SQLPATH"="C:\\oracle\\product\\10.2.0\\db_1\\dbs"
"ORACLE_HOME_KEY"="SOFTWARE\\ORACLE\\KEY_OraDb10g_home1"
"MSHELP_TOOLS"="C:\\oracle\\product\\10.2.0\\db_1\\MSHELP"
"ORACLE_BASE"="C:\\oracle\\product\\10.2.0"
"RDBMS_CONTROL"="C:\\oracle\\product\\10.2.0\\db_1\\DATABASE"
"RDBMS_ARCHIVE"="C:\\oracle\\product\\10.2.0\\db_1\\DATABASE\\ARCHIVE"
"ORA_SHULOCAL_AUTOSTART"=hex(2):54,00,52,00,55,00,45,00,00,00
"ORA_SHULOCAL_SHUTDOWN"=hex(2):54,00,52,00,55,00,45,00,00,00
"ORA_SHULOCAL_SHUTDOWNTYPE"=hex(2):69,00,6d,00,6d,00,65,00,64,00,69,00,61,00,\
74,00,65,00,00,00
"ORA_SHULOCAL_SHUTDOWN_TIMEOUT"=hex(2):39,00,30,00,00,00

 

[oradba101]

Hi, Huchen

What I would recommend (having done it a number of times)

1. Use the Universal Installer to unistall Oracle
2. Delete the oracle directories (one is on c:\ the other on c:\program files)
3. Remove the Oracle entry in the software folder in the registry
4. Re-install Oracle.

If you are still having this issue. then please let us know and we shall go from there

Regards,

William Chadbourne
Oracle DBA

 

[huchen]

Thank you William. I will do it later.

 

[missOracle]

Hello everybody
i have had the same problem, i have installed personal Oracle then for some reasons i decided to re-install it.
i have remove all the traces of the first installation from the disk and the registry then i re-installed the personal oracle and i encountered the same problem.
but it was solved by adding two variables to the "environment variables" of my Computer.
1-variable ORACLE_SID, value 'your SID'
2- variable ORACLE_HOME, value 'your oracle home path'

then i reboot my computer and the em page worked.

 

[Thargy]

huchen,

ckeck the portlist.ini file in the install folder. If you've installed more than once, it might give the true current URL.

Regards

Tharg

Grinding away at things Oracular

 

[huchen]

Thanks to everybody for your help.
I tried all your suggestions and none of them worked for my case.

Then I read Oracle Database Installation Guide:
"2.4.1 Installing Oracle Database on DHCP Computers"

and installed Loopback Adapter

Now it works without any problem.

Thank you again.