Total Pageviews

Tuesday 14 May 2013

OC4J Configuration issue - EM not working


[oracle@testmachine ~]$ emctl status dbconsole
Environment variable ORACLE_UNQNAME not defined. Please set ORACLE_UNQNAME to database unique name.
[oracle@testmachine ~]$ export ORACLE_UNQNAME=orcldb
[oracle@testmachine ~]$ emctl status dbconsole
OC4J Configuration issue. /home/oracle/11.2.0/product/db_1/oc4j/j2ee/OC4J_DBConsole_testmachine_orcldb not found.

To check if EM is installed/configured properly and running :

cd /home/oracle/11.2.0/product/db_1/oc4j/j2ee/
ls -l 

" In our case the folder shown in Red was missing" .If it is present in ur case check the permission 

-rw-r--r--  1 oracle oinstall  985 Mar 22 10:50 deploy_db_wf.ini
drwxr-xr-x 14 oracle oinstall 4096 Mar 22 10:49 home
drwxr-xr-x  3 oracle oinstall 4096 Mar 22 10:48 oc4j_applications
drwxr-x---  6 oracle oinstall 4096 Mar 22 10:48 OC4J_DBConsole
drwxr-xr-x 10 oracle oinstall 4096 May 14 15:49 OC4J_DBConsole_gnoctest_orcldb
drwxr-xr-x  5 oracle oinstall 4096 Mar 22 10:48 OC4J_Workflow_Component_Container
drwxr-xr-x  5 oracle oinstall 4096 Mar 22 10:48 OC4J_Workflow_Management_Container
drwxr-xr-x  2 oracle oinstall 4096 Mar 22 10:49 utilities

To check the port 1158 on which Em runs :


 > netstat -an| grep 1158

If your configuration is ok it will LISTEN on the port 1158 else it will give blank output.

Solution:

Warning: Below command puts the database in Quiesce Mode for the DB Control Releases 10.x to 11.1.x. Starting with DB Control Release 11.2.x, the database is no longer put in quiesce mode. The following note can be consulted for further details: 

Note 375946.1 Running EMCA Results in Database quiesce And No New Connections or Operations Can Be Performed During the DB Control Repository Creation

IMPORTANT: When dropping the repository with EMCA or RepManager on an 11.2 database, this warning will be displayed:
WARNING : While repository is dropped the database will be put in quiesce mode.

This warning can be safely ignored (only on 11.2 databases).


[oracle@testmachine ~]$ $ORACLE_HOME/bin/emca -config dbcontrol db -repos recreate

STARTED EMCA at May 14, 2013 3:37:52 PM
EM Configuration Assistant, Version 11.2.0.0.2 Production
Copyright (c) 2003, 2005, Oracle.  All rights reserved.

Enter the following information:
Database SID: orcldb
Listener port number: 1522
Listener ORACLE_HOME [ /home/oracle/11.2.0/product/db_1 ]: /home/oracle/11.2.0/product/db_1
Password for SYS user:
Password for DBSNMP user:
Password for SYSMAN user:
Email address for notifications (optional):
Outgoing Mail (SMTP) server for notifications (optional):
-----------------------------------------------------------------

You have specified the following settings

Database ORACLE_HOME ................ /home/oracle/11.2.0/product/db_1

Local hostname ................ testmachine
Listener ORACLE_HOME ................ /home/oracle/11.2.0/product/db_1
Listener port number ................ 1522
Database SID ................ orcldb
Email address for notifications ...............
Outgoing Mail (SMTP) server for notifications ...............

-----------------------------------------------------------------
Do you wish to continue? [yes(Y)/no(N)]: y
May 14, 2013 3:38:18 PM oracle.sysman.emcp.EMConfig perform
INFO: This operation is being logged at /home/oracle/11.2.0/product/cfgtoollogs/emca/orcldb/emca_2013_05_14_15_37_51.log.
May 14, 2013 3:38:20 PM oracle.sysman.emcp.EMReposConfig invoke

Management Repository has been placed in secure mode wherein Enterprise Manager data will be encrypted.  The encryption key has been placed in the file: /home/oracle/11.2.0/product/db_1/testmachine_orcldb/sysman/config/emkey.ora.   Please ensure this file is backed up as the encrypted data will become unusable if this file is lost.

***********************************************************
Enterprise Manager configuration completed successfully
FINISHED EMCA at May 14, 2013 3:52:44 PM

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

[oracle@testmachine ~]$ netstat -an|grep 1158
tcp        0      0 0.0.0.0:1158                0.0.0.0:*                   LISTEN


[oracle@testmachine ~]$ emctl status dbconsole
Oracle Enterprise Manager 11g Database Control Release 11.2.0.1.0
Copyright (c) 1996, 2009 Oracle Corporation.  All rights reserved.
https://testmachine:1158/em/console/aboutApplication
Oracle Enterprise Manager 11g is running.
------------------------------------------------------------------
Logs are generated in directory /home/oracle/11.2.0/product/db_1/testmachine_orcldb/sysman/log


For more details follow the oracle documentation on oracle support :

How To Drop, Create And Recreate the Database Control (DB Control) Release 10g and 11g [ID 278100.1]





1 comment:

  1. Jadwal Arena Sabung Ayam SV388 28 Februari 2019 - Kamis, Maluku 28 Februari 2019 – Pada Hari Tersebut Akan Di Laksanakan Berbagai Pertandingan Sabung Ayam Secara Live di Arena Sabung Ayam Thailand.

    Situs Judi Sabung Ayam Online SV388 Merupakan Situs Judi Asal Thailand Yang Sangat Terkenal Dengan Permainan Sabung Ayam Yang Fair dan Menghibur Para Penonton Judi Sabung Ayam.

    Untuk Info Lebih Lanjut Bisa Hub kami Di :
    wechat : bolavita
    line : cs_bolavita
    whatsapp : +628122222995
    BBM: BOLAVITA

    ReplyDelete