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)