Oracle EM Configuration

Start Stop DBConsole Service for Oracle EM

emctl status dbconsole
emctl start dbconsole
emctl stop dbconsole

OC4J Configuration issue
If you get following error in starting dbconsole
OC4J_DBConsole__ not found

then drop and re-create OC4J configuration first drop existing configuration and then create new.

To drop existing configuration

emca -deconfig dbcontrol db -repos drop

To create configuration

emca -config dbcontrol db -repos create

If you get following error / exception in re-creating configuration

In console window
Exception in thread “main” oracle.sysman.emcp.exception.DatabaseUnavailableException: Database instance unavailable.

In log file
oracle.sysman.assistants.util.sqlEngine.SQLFatalErrorException: ORA-01031: insufficient privileges

Steps to resolve this issue (Steps 3 onward are optional)

  1. Ensure REMOTE_LOGIN_PASSWORDFILE=EXCLUSIVE is set in init.ora (located in %ORACLE_HOME%\dbs)
    confirm this by issuing command show paramter remote_login_passwordfile
  2. Create password file by using ORAPWD
    orapwd file=%ORACLE_HOME%/dbs/pwd.ora password= entries=5
  3. In listener.ora
    ADR_BASE_LISTENER = C:\Oracle\Oracle11g
  4. In sqlnet.ora
  5. Environment Variables
    ORACLE_HOSTNAME=<host name>

DBCA can also be used to re-configure Oracle EM Settings

Oracle Listener
Listener Start/Stop/Status

lsnrctl start
lsnrctl stop
lsnrctl status
lsnrctl service

Leave a Reply

Your email address will not be published.