DBCA Fails To Create Oracle 19c Database On AIX [DBT-05509] (Doc ID 2663388.1)

---

In this Document Symptoms Changes Cause Solution References APPLIES TO: Oracle Database Configuration Assistant - Version 19.3.0.0.0 and later Information in this document applies to any platform. SYMPTOMS DBCA fails to create Oracle 19c database on AIX platform Problem Description --------------------------------------------------- [DBT-05509] Failed to connect to the specified database (<database>). Cause - OS Authentication might be disabled for this database (<database>). Action - Specify a valid sysdba user name and password to connect to the database. DBCA Log showing following error Refer associated stacktrace #oracle.assistants.common.lib.db.DBInfo:5174 [pool-1-thread-1] [ 2020-04-01 07:18:17.496 EDT ] [AssistantLogHandler.publish:465] ---# Begin Stacktrace #--------------------------- ID: oracle.assistants.common.lib.db.DBInfo:5174 java.io.IOException: There is an error in creating the following process: /<ORACLE_HOME_PATH>/bin/sqlplus -S -N /NOLOG The error is: at oracle.sysman.assistants.util.sqlEngine.SQLEngine.setDefaultEngineSettings(SQLEngine.java:2527) at oracle.sysman.assistants.util.sqlEngine.SQLEngine.initialize(SQLEngine.java:477) at oracle.sysman.assistants.util.sqlEngine.SQLEngine.<init>(SQLEngine.java:338) at oracle.sysman.assistants.util.sqlEngine.SQLPlusEngine.<init>(SQLPlusEngine.java:141) at oracle.sysman.assistants.util.step.StepSQLPlusEngine.<init>(StepSQLPlusEngine.java:68) at oracle.assistants.common.lib.db.DBInfo.createStepSQLInterface(DBInfo.java:311) at oracle.assistants.common.lib.db.DBInfo.checkConnection(DBInfo.java:1250) at oracle.assistants.common.lib.db.DBInfo.checkConnection(DBInfo.java:1213) at oracle.assistants.common.validator.GenericValidator.validateConnection(GenericValidator.java:454) at oracle.assistants.dbca.validator.TypicalModeDBCreationValidator.validate(TypicalModeDBCreationValidator.java:85) at oracle.install.commons.flow.validation.ValidationHelper.validateState(ValidationHelper.java:194) at oracle.install.commons.flow.AbstractFlowExecutor.validate(AbstractFlowExecutor.java:527) at oracle.install.commons.flow.AbstractFlowExecutor.leaveVertex(AbstractFlowExecutor.java:835) at oracle.install.commons.flow.AbstractFlowExecutor.transition(AbstractFlowExecutor.java:434) at oracle.install.commons.flow.AbstractFlowExecutor.nextState(AbstractFlowExecutor.java:360) at oracle.install.commons.flow.AbstractFlowExecutor.nextViewState(AbstractFlowExecutor.java:315) at oracle.install.commons.flow.DefaultFlowNavigator.goForward(DefaultFlowNavigator.java:58) at oracle.install.commons.flow.jewt.FlowWizard$1.run(FlowWizard.java:190) at oracle.install.commons.flow.jewt.FlowWizard$TransitionManager$1.run(FlowWizard.java:160) at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:522) at java.util.concurrent.FutureTask.run(FutureTask.java:277) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1160) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:635) at java.lang.Thread.run(Thread.java:812) ---# End Stacktrace #----------------------------- SEVERE: Apr 01, 2020 7:18:17 AM oracle.install.commons.util.exception.AbstractErrorAdvisor getDetailedMessage SEVERE: [FATAL] [DBT-05509] Failed to connect to the specified database (<DBNAME>). CAUSE: OS Authentication might be disabled for this database (<DBNAME>). ACTION: Specify a valid sysdba user name and password to connect to the database. sqlplus or lsnrctl command generating coredump  $ORACLE_HOME/bin>sqlplus -S -N /NOLOG Illegal instruction(coredump) $ORACLE_HOME>lsnrctl start LISTENER Illegal instruction(coredump)  Stack extraction from coredump is showing following function $ stackx <corefile>    Illegal instruction (illegal opcode) in sslnxadd at 0x100161f10 ($t1) Instruction is valid on: 0x100161f10 (sslnxadd+0x170) 7c004e99 Invalid opcode. </status> <stackinfo> <threads> </threads> <current_thread> sslnxadd(??, ??, ??, ??, ??, ??) at 0x100161f10 lnxadd__larch_dydiini(??, ??, ??, ??, ??, ??) at 0x10015fed0 slnx2.lnxadd(??, ??, ??, ??, ??, ??) at 0x10015ff74 LdiInterToNumberi(0xfffffffffffb948, 0xfffffffffffb978, 0xfffffffffffb934, 0x600000006) at 0x10015c2c4 LdiInterToNumber(0xfffffffffffb948, 0xfffffffffffb978, 0xfffffffffffb934, 0x600000006) at 0x10015c528 kgstmLdiToEpochTs(0x110517c30, 0x110526fe0, 0x110526f60, 0xfffffffffffba38) at 0x102c2cc68 kgstmComputeTranslation(0x110517c30, 0x11051c250, 0x110526fe0, 0x110526f60) at 0x102c2c880 kgstmRefreshTranslation(0x110517c30, 0x0, 0x0, 0x11051c250) at 0x102c2cf84 kgstmNotify(0x110517c30, 0x0) at 0x102c2dc60 CHANGES CAUSE Caused due to Bug 29591343 : GRIDSETUP.SH GUI CRASHES UNHANDLED EXCEPTION TYPE=ILLEGAL INSTRUCTION VMSTATE=0X00040000 J9GENERIC_SIGNAL_NUMBER   SOLUTION Download and apply patch 29591343 available to your version After applying patch relink binary $ORACLE_HOME/bin/relink   REFERENCES NOTE:362791.1 - STACKX User Guide NOTE:2621030.1 - AIX: 18c/19c Installed successfully ,but sqlplus,lsnrctl fails with "Illegal Instruction"