ORA-12157 during dbca on 10.2.0.4 under SLES 10 SP2
47107Jul 22 2008 — edited Jul 22 2008Dear all,
I would like to set up two DBs each in its own ORACLE_HOME running under ASM.
Software installation and ASM setup worked (after some trouble with the multipath storage / ASMLIB). Now I have three separate ORACLE_HOMEs:
/ocfs/oracle/product/10.2/ASM,
/ocfs/oracle/product/10.2/SEQ,
/ocfs/oracle/product/10.2/RESNET.
I can connect to each of them using sqlplus. ASM is up and running.
Now I want ot set up an empty DB in SEQ and RESNET using dbca (or the scripts created by it, if need be).
This worked for SEQ but for RESNET I get ORA-12157 at the last step.
ORACLE_HOME, ORACLE_SID, PATH, LD_LIBRARY_PATH, TNS_ADMIN were all set to point to RESNET. TEMP and TMPDIR are set to /tmp which has several GB free space.
In the trace file ($ORACLE_HOME/cfgtoollogs/dbca/trace.log) I find
...
[Thread-14] [9:37:4:254] [BasicStep.execute:202] Executing Step : CLONE_DB_CREATION_RMAN_RESTORE
[Thread-14] [9:37:4:255] [StepErrorHandler.setFatalErrors:322] setting Fatal Error: ORA-01092
[Thread-14] [9:37:4:255] [StepErrorHandler.setFatalErrors:322] setting Fatal Error: ORA-01034
[Thread-14] [9:37:4:255] [StepErrorHandler.setFatalErrors:322] setting Fatal Error: ORA-03114
[Thread-14] [9:37:4:255] [StepErrorHandler.setFatalErrors:322] setting Fatal Error: ORA-12560
...
and
...
[Thread-18] [9:37:7:496] [BasicStep.handleNonIgnorableError:431] ORA-12157: TNS:internal network communication error
:msg
[Thread-20] [9:37:15:913] [SQLEngine.done:1958] Done called
oracle.sysman.assistants.util.sqlEngine.SQLFatalErrorException: ORA-12157: TNS:internal network communication error
at oracle.sysman.assistants.util.sqlEngine.SQLEngine.executeImpl(SQLEngine.java:1474)
at oracle.sysman.assistants.util.sqlEngine.SQLEngine.connect(SQLEngine.java:821)
at oracle.sysman.assistants.dbca.backend.CloneRmanRestoreStep.executeImpl(CloneRmanRestoreStep.java:244)
at oracle.sysman.assistants.util.step.BasicStep.execute(BasicStep.java:210)
at oracle.sysman.assistants.util.step.Step.execute(Step.java:140)
at oracle.sysman.assistants.util.step.StepContext$ModeRunner.run(StepContext.java:2488)
at java.lang.Thread.run(Thread.java:534)
...
Can you suggest a solution or a hint on where to look for the cause of this error?
Multi-eye-ringed, gray-haired greetings!