Database Install/Upgrade/Opatch (MOSC)

MOSC Banner

how to configure ORA_DBA?

as described in Doc ID 2552927.1, The step it is hanging is when creating and starting the Oracle Instance.

CAUSE

Configuration error.

 SOLUTION

1) Make sure the SQLNET.ORA has the setting below:


SQLNET.AUTHENTICATION_SERVICES= (NTS)


2) Add a new SID_DESC entry to the SID_LIST_LISTENER in the listener.ora file


SID_LIST_LISTENER =

  (SID_LIST =

  (SID_DESC =

  (SID_NAME = CLRExtProc)

  (ORACLE_HOME = E:\app\oracle\product\18.3.0\dbhome_1)

  (PROGRAM = extproc)

  (ENVS = "EXTPROC_DLLS=ONLY:E:\app\oracle\product\18.3.0\dbhome_1\bin\oraclr18.dll")

  )

  (SID_DESC =

  (GLOBAL_DBNAME = oemsmc.<domain_name_removed>)

  (ORACLE_HOME = E:\app\oracle\product\18.3.0\dbhome_1)

  (SID_NAME = oemsmc)

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center