DBCA fails with ORA-01012 "not logged on" Error in a RAC (Doc ID 2227887.1)

Last updated on MARCH 17, 2017

Applies to:

Oracle Database - Enterprise Edition - Version 12.1.0.2 and later
Information in this document applies to any platform.

Symptoms

Environment:

GI : 12.1.0.2 

Database : 12.1.0.2

While running dbca to create a new database, after cloning the binaries from the working environment, it failed with "ORA-01012: not logged on".

[Thread-975] [ 2017-01-13 12:26:41.609 PST ] [CloneRmanRestoreStep.cancel:722] Cleaning up partially extracted files failed
[Thread-975] [ 2017-01-13 12:26:42.904 PST ] [SQLEngine.done:2278] Done called
[Thread-975] [ 2017-01-13 12:26:42.904 PST ] [CloneRmanRestoreStep.cancel:737] RMAN cleanup failed
[Thread-975] [ 2017-01-13 12:26:42.904 PST ] [CloneRmanRestoreStep.cancel:738] ORA-01012: not logged on <<<<<<<<<<<<<<<<<<<  Here 

oracle.sysman.assistants.util.sqlEngine.SQLEngine.executeImpl(SQLEngine.java:1739)
oracle.sysman.assistants.util.sqlEngine.SQLEngine.executeQuery(SQLEngine.java:878)
oracle.sysman.assistants.dbca.backend.CloneRmanRestoreStep.generateCancelScript(CloneRmanRestoreStep.java:772)
oracle.sysman.assistants.dbca.backend.CloneRmanRestoreStep.cancel(CloneRmanRestoreStep.java:732)
oracle.sysman.assistants.util.step.StepContext$ModeRunner.cancel(StepContext.java:2979)
oracle.sysman.assistants.util.step.StepContext$ModeRunner.run(StepContext.java:2940)
java.lang.Thread.run(Thread.java:682)

Changes

 RDBMS Home cloning

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms