SEVERE: Listener is not up or database service is not registered with it. Start the Listener and register database service and run EM Configuration Assistant again

I had an issue with this on Oracle Linux during the installation. This occurs when the database and listener are not started in the right sequence. If you run into this error, run through the following commands.

SEVERE: Listener is not up or database service is not registered with it. Start the Listener and register database service and run EM Configuration Assistant again.

For windows the problem looks like a hostname / host issue, which this does not address.

There are a few issues that can be a cause of this error. Below is how I resolved them.

Other issue this addresses:

  • Oracle 11g Listener Supports No services
  • oracle.sysman.assistants.util.sqlEngine.SQLFatalErrorException: ORA-20001: SYSMAN already exists..
  • SEVERE: Error creating the repository

Ensure you have your oracle environment settings and export them.

        • ORACLE_HOME_LISTENER=/home/oracle/app/oracle/product/11.2.0/dbhome_1
        • ORACLE_UNQNAME=orcl
        • ORACLE_SID=orcl
        • ORACLE_HOSTNAME=myhostname.mydomain
        • ORACLE_HOME=/home/oracle/app/oracle/product/11.2.0/dbhome_1

Add the following to listener.ora

SID_LIST_LISTENER =

(SID_LIST =
   (SID_DESC =
   (SID_NAME = orcl)
   (GLOBAL_DBNAME = orcl.yourdomain.com)
)

)

stop the listener:

./lsnrctl stop

./lsnrctl start

Tip: If you get an error like:

Message 1053 not found; No message file for product=network, facility=TNSMessage 1020 not found; No message file for product=network, facility=TNSMessage 1021 not found; No message file for product=network, facility=TNSMessage 1022 not found; No message file for product=network, facility=TNSMessage 1023 not found; No message file for product=network, facility=TNSMessage 1026 not found;

Then make sure to check to make sure ORACLE_HOME, ORACLE_SID and retry.

env | grep ORACLE

Check to make sure your SID is being listened for

./lsnrctl services

./lsnrctl status

You should see something like:

Services Summary…
Service “orcl.mydomaint” has 1 instance(s).
Instance “orcl”, status READY, has 1 handler(s) for this service…
Service “orclXDB.mydomain” has 1 instance(s).
Instance “orcl”, status READY, has 1 handler(s) for this service…
The command completed successfully

LSNRCTL for Linux: Version 11.2.0.1.0 –

Copyright (c) 1991, 2009, Oracle. All rights reserved.

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1522)))
Services Summary…
Service “orcl.mydomain” has 1 instance(s).
Instance “orcl”, status READY, has 1 handler(s) for this service…
Handler(s):
“DEDICATED” established:6767 refused:0 state:ready
LOCAL SERVER
Service “orclXDB.mydomain” has 1 instance(s).
Instance “orcl”, status READY, has 1 handler(s) for this service…
Handler(s):
The command completed successfully

Once confirmed, run the emca script and drop the old database. You will run into another error because the SYSMAN is already created

./emca -deconfig dbcontrol db -repos drop

Then rerun the installation with dbca or emca

./emca -config dbcontrol db -repos create

You can also use

./dbca

You should be up and running. If you still have errors with “uploading to the repo” check timezone settings.

If not change your TimeZone.. Check the error logs under

/home/oracle/app/oracle/cfgtoollogs/emca/orcl/emca_repos_config.

Caused by: java.sql.SQLException: ORA-00604: error occurred at recursive SQL level 1
ORA-01882: timezone region not found

Set timezone to local other than UTC and retry.