Database 11gR2 Installation done successful with DB Console Start Error!!!

As salamualikum (islamic greetings), brothers and sisters. :)

Update: Bellow issues for Database release 11gR2 (11.2.0.3.0) BUT at release 11gR2 (11.2.0.4.0) fixed

Hope you are well with the grace of Almighty Allah (swt) but stuck in a place where your first installation of Database 11gR2 isn’t successful in total.

Why in total? When you at the end with the successful message but just before that you get a message that “Unable to start DB console”. You database functioning well without dbconsole. 

Don’t worry. Here are few tricks, which will help you to get it functioning.

First two steps of solution 1 for all the solution.

Solution 1

This is the simplest and quickest solution.

Steps

1.       Check the status of the console by opening the command prompt (windows)

a.  C:\> emctl status dbconsole

Most probably you will get error like (Environment variable ORACLE_UNQNAME not defined. Please set ORACLE_UNQNAME to database unique name.)

2.       Now set the ORACLE_UNQNAME and it will be the SID. How you can get it? Go to DB_Home directory and you will get a folder name HostName_SID. For example, your SID is ORCL the you may get “<path>\product\11.2.0\dbhome_1\localhost_ORCL”

a.  C:\>set ORACLE_HOSTNAME=localhost

b.  C:\>set ORACLE_UNQNAME=orcl

3.       Now Start the dbconsole by command

a.  C:\> emctl start dbconsole

Hope it works ;)

Now login to dbconsole via browser with url https://localhost:1158/em

If first solution doesn’t work the try,

Solution 2

Steps

1.       Follow steps 1 and 2 of solution 1.

2.       Check your system time zone from system or from database. From database follow

a.      Open sql*Plus and get the value of

b.      SQL> SELECT SESSIONTIMEZONE FROM DUAL;

SESSIONTIMEZONE

------------------

+06:00

3.       For +06:00, oracle time zone is Asia/Dacca

4.       Now open the emd.properties file from <home>\ product\11.2.0\dbhome_1\localhost_AIT\sysman\config and open it with notepad or notepad++

5.       Go to the last line and change the value of agentTZRegion to Asia/Dacca for example, agentTZRegion=Asia/Dacca

6.       Save and restart the dbconsole from windows service (administrative service) or restart the PC.

Hope it works ;)

Now login to dbconsole via browser with url https://localhost:1158/em

If it helps, leave your message.

Praise to Almighty Allah(swt).

Fi amanillah

java.lang.Exception: Exception in sending Request :: null (When try to start Oracle Database Console), What to do ?

As salamualikum (islamic greetings), brothers and sisters. :)

 Huhh, Post again after a long time. I'm passing very busy time. Lot's of change around me.

Come to the topic.

When you start the "Oracle Enterprise Manager, Database Control" knows as "DB Console"
you may see the topic error like as

 then how you solve this problem / get rid of this problem ?

Don't worry, it's simple. Assuming your are using oracle Database 10gR2 in windows enviornment.

Follow the following steps and get everything working.. 

1. Open the Command prompt
2. write cd C:\oracle\product\10.2.0\db_1\bin
3. write set oracle_sid=<SID_NAME> for example ORCL
4. write emctl stop dbconsole

You will get,

Oracle Enterprise Manager 10g Database Control Release 10.2.0.1.0
Copyright (c) 1996, 2006 Oracle Corporation.  All rights reserved.
http://SERVER:1158/em/console/aboutApplication
The OracleDBConsoleTT service is stopping.....
The OracleDBConsoleTT service was stopped successfully.

 Now double click the My Computer and go to

1. C:\oracle\product\10.2.0\db_1\sysman\admin

look for file name: "supportedtzs.lst"

2. Open it and look for your timezone. For example Asia/Dacca

3. Now go to " C:\oracle\product\10.2.0\db_1\PC_NAME_<SID_NAME>\sysman\config "

look for file name: "emd.properties"

4. At the end of this file add:-

agentTZRegion=Asia/Dacca

 and comment out if any like

 #agentTZRegion=-05:00




5. write emctl start dbconsole


Now, you are done... 

Open browser and logged in Enterprise Manager using sys/password as sysdba.

Click on Pending Status and logged in again, Now you will successfully use Enterprise Manager. 


Comments to share your thoughts..


End for the day....

Praise to Almighty Allah(swt).  :)

Fi amanillah