Tuesday, April 1, 2014

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

No comments:

Post a Comment