Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

12560- TNS Protocol adapter error in DBCA

Rajeev24May 18 2016 — edited May 20 2016

Hello all,

I successfully installed the 12c server software on a Win 10 VM. The host is a Mac if that matters. But when I try to install a database, it fails almost immediately with a 12560 error. I have been reading the message boards here but haven't really found a resolution. I am getting the same error when I try to login to sqlplus as sysdba.

Under the environment variables, the path is set correctly with the first entry being the Oracle Home. I also manually added an entry for ORACLE_HOME and TNS_ADMIN.

ORACLE_HOME=C:\app\username\product\12.1.0\dbhome_1

TNS_ADMIN=C:\app\username\product\12.1.0\dbhome_1\NETWORK\ADMIN.

I can also see that the service OracleOraDB12Home1TNSListener is running.

Here is a snippet of the trace file from the dbca directory under cfgtoollogs. Any help is appreciated.

[Thread-34] [ 2016-05-18 16:12:02.837 PDT ] [CommonUtils.getPasswordFileCreateCmd:1182] for new orapwd for 11.1 or higher

[Thread-34] [ 2016-05-18 16:12:02.838 PDT ] [OracleHome.getVersion:994] OracleHome.getVersion called. Current Version: 12.1.0.2.0

[Thread-34] [ 2016-05-18 16:12:02.838 PDT ] [OracleHome.getVersion:1062] Current Version From Inventory: 12.1.0.2.0

[Thread-34] [ 2016-05-18 16:12:02.838 PDT ] [OracleHome.getVersion:994] OracleHome.getVersion called. Current Version: 12.1.0.2.0

[Thread-34] [ 2016-05-18 16:12:02.838 PDT ] [OracleHome.getVersion:1062] Current Version From Inventory: 12.1.0.2.0

[Thread-34] [ 2016-05-18 16:12:02.839 PDT ] [CommonUtils.getPasswordFileCreateCmd:1213] C:\app\username\product\12.1.0\dbhome_1\bin\orapwd.exe

[Thread-34] [ 2016-05-18 16:12:02.839 PDT ] [CommonUtils.getPasswordFileCreateCmd:1213] file=C:\app\username\product\12.1.0\dbhome_1\database\PWDora10.ora

[Thread-34] [ 2016-05-18 16:12:02.839 PDT ] [CommonUtils.getPasswordFileCreateCmd:1213] force=y

[Thread-34] [ 2016-05-18 16:12:02.839 PDT ] [CommonUtils.getPasswordFileCreateCmd:1213] format=12

[Thread-34] [ 2016-05-18 16:12:02.839 PDT ] [OsUtilsBase.execProg:2123] beginning execProg with input array.

[Thread-34] [ 2016-05-18 16:12:02.940 PDT ] [OsUtilsBase.execProg:2160] finished execProg with input array. Status:0

[Thread-34] [ 2016-05-18 16:12:02.940 PDT ] [InstanceStep.setASMAdminGID:373] isWindows: true Storage Type: 0

[Thread-34] [ 2016-05-18 16:12:02.942 PDT ] [BasicStep.configureSettings:353] messageHandler being set=oracle.sysman.assistants.util.InteractiveMessageHandler@d50112d

[Thread-34] [ 2016-05-18 16:12:02.942 PDT ] [CloneRmanRestoreStep.executeImpl:270] Instance Creation went fine..........

[Thread-34] [ 2016-05-18 16:12:02.942 PDT ] [CloneRmanRestoreStep.executeImpl:277] db_recovery_file_dest="C:\app\username\fast_recovery_area"

[Thread-34] [ 2016-05-18 16:12:02.942 PDT ] [CloneRmanRestoreStep.executeImpl:280] db_recovery_file_dest_size=6420m

[Thread-34] [ 2016-05-18 16:12:02.942 PDT ] [InitParameterFile.getLongValue:687] May have unit. Stripping unit and trying with 6420

[Thread-34] [ 2016-05-18 16:12:02.942 PDT ] [CloneRmanRestoreStep.executeImpl:297] Setting NLS_LANG to AMERICA.AL32UTF8

[Thread-34] [ 2016-05-18 16:12:02.943 PDT ] [SQLEngine.done:2278] Done called

[Thread-34] [ 2016-05-18 16:12:02.948 PDT ] [SQLEngine.reInitialize:785] Reinitializing SQLEngine...

[Thread-34] [ 2016-05-18 16:12:02.948 PDT ] [OracleHome.getVersion:994] OracleHome.getVersion called. Current Version: 12.1.0.2.0

[Thread-34] [ 2016-05-18 16:12:02.948 PDT ] [OracleHome.getVersion:1062] Current Version From Inventory: 12.1.0.2.0

[Thread-34] [ 2016-05-18 16:12:02.948 PDT ] [OracleHome.getVersion:994] OracleHome.getVersion called. Current Version: 12.1.0.2.0

[Thread-34] [ 2016-05-18 16:12:02.949 PDT ] [OracleHome.getVersion:1062] Current Version From Inventory: 12.1.0.2.0

[Thread-34] [ 2016-05-18 16:12:02.949 PDT ] [OracleHome.getVersion:994] OracleHome.getVersion called. Current Version: 12.1.0.2.0

[Thread-34] [ 2016-05-18 16:12:02.949 PDT ] [OracleHome.getVersion:1062] Current Version From Inventory: 12.1.0.2.0

[Thread-34] [ 2016-05-18 16:12:02.949 PDT ] [SQLPlusEngine.getCmmdParams:225] m_home 12.1.0.2.0

[Thread-34] [ 2016-05-18 16:12:02.949 PDT ] [SQLPlusEngine.getCmmdParams:226] version > 112 true

[Thread-34] [ 2016-05-18 16:12:02.949 PDT ] [OsUtilsBase.getBaseFromOrabase:659] oraBaseUtility C:\app\username\product\12.1.0\dbhome_1\bin\orabase.exe

[Thread-34] [ 2016-05-18 16:12:02.949 PDT ] [OsUtilsBase.getBaseFromOrabase:668] cmds: C:\app\username\product\12.1.0\dbhome_1\bin\orabase.exe

[Thread-34] [ 2016-05-18 16:12:02.949 PDT ] [OsUtilsBase.getBaseFromOrabase:672] envs: ORACLE_HOME=C:\app\username\product\12.1.0\dbhome_1

[Thread-34] [ 2016-05-18 16:12:03.008 PDT ] [OsUtilsBase.getBaseFromOrabase:682] baseLocation from orabase

C:\app\username

[Thread-34] [ 2016-05-18 16:12:03.008 PDT ] [OsUtilsBase.getBaseFromOrabase:707] orabaseLocation= C:\app\username

[Thread-34] [ 2016-05-18 16:12:03.008 PDT ] [SQLEngine.getEnvParams:612] NLS_LANG: AMERICAN_AMERICA.AL32UTF8

[Thread-34] [ 2016-05-18 16:12:03.008 PDT ] [SQLEngine.initialize:358] Execing SQLPLUS/SVRMGR process...

[Thread-34] [ 2016-05-18 16:12:03.010 PDT ] [SQLEngine.initialize:395] m_bReaderStarted: false

[Thread-34] [ 2016-05-18 16:12:03.010 PDT ] [SQLEngine.initialize:399] Starting Reader Thread...

[Thread-34] [ 2016-05-18 16:12:03.011 PDT ] [SQLEngine.initialize:448] Waiting for m_bReaderStarted to be true

[Thread-34] [ 2016-05-18 16:12:05.356 PDT ] [SQLEngine.done:2278] Done called

[Thread-34] [ 2016-05-18 16:12:05.374 PDT ] [CloneRmanRestoreStep.executeImpl:522] ORA-12560: TNS:protocol adapter error

[Thread-34] [ 2016-05-18 16:12:05.374 PDT ] [CloneRmanRestoreStep.executeImpl:523] ORA-12560: TNS:protocol adapter error

oracle.sysman.assistants.util.sqlEngine.SQLEngine.executeImpl(SQLEngine.java:1739)
oracle.sysman.assistants.util.sqlEngine.SQLEngine.connect(SQLEngine.java:987)
oracle.sysman.assistants.dbca.backend.CloneRmanRestoreStep.executeImpl(CloneRmanRestoreStep.java:305)
oracle.sysman.assistants.util.step.BasicStep.execute(BasicStep.java:259)
oracle.sysman.assistants.util.step.Step.execute(Step.java:135)
oracle.sysman.assistants.util.step.StepContext$ModeRunner.run(StepContext.java:2883)

java.lang.Thread.run(Thread.java:682)

[Thread-34] [ 2016-05-18 16:12:05.374 PDT ] [BasicStep.configureSettings:353] messageHandler being set=oracle.sysman.assistants.util.InteractiveMessageHandler@d50112d

[Thread-34] [ 2016-05-18 16:12:05.374 PDT ] [StepContext$ModeRunner.run:2899] ORA-12560: TNS:protocol adapter error

oracle.sysman.assistants.dbca.backend.CloneRmanRestoreStep.executeImpl(CloneRmanRestoreStep.java:524)
oracle.sysman.assistants.util.step.BasicStep.execute(BasicStep.java:259)
oracle.sysman.assistants.util.step.Step.execute(Step.java:135)
oracle.sysman.assistants.util.step.StepContext$ModeRunner.run(StepContext.java:2883)

java.lang.Thread.run(Thread.java:682)

[Thread-34] [ 2016-05-18 16:12:06.184 PDT ] [SQLEngine.done:2278] Done called

[Thread-34] [ 2016-05-18 16:12:06.184 PDT ] [Host.createStepSQLInterface:8610] sid =ora10

[Thread-34] [ 2016-05-18 16:12:06.184 PDT ] [Host.createStepSQLInterface:8611] sidOrConnectString ora10

[Thread-34] [ 2016-05-18 16:12:06.184 PDT ] [OracleHome.getVersion:994] OracleHome.getVersion called. Current Version: null

[Thread-34] [ 2016-05-18 16:12:06.184 PDT ] [InventoryUtil.getOUIInvSession:349] setting OUI READ level to ACCESSLEVEL_READ_LOCKLESS

[Thread-34] [ 2016-05-18 16:12:06.184 PDT ] [OracleHome.getVersion:1013] Homeinfo C:\app\username\product\12.1.0\dbhome_1,1

[Thread-34] [ 2016-05-18 16:12:06.316 PDT ] [OracleHome.getVersion:1041] OracleHome.server.getVersion Version: 12.1.0.2.0

[Thread-34] [ 2016-05-18 16:12:06.316 PDT ] [OracleHome.getVersion:1062] Current Version From Inventory: 12.1.0.2.0

[Thread-34] [ 2016-05-18 16:12:06.317 PDT ] [OracleHome.getVersion:994] OracleHome.getVersion called. Current Version: 12.1.0.2.0

[Thread-34] [ 2016-05-18 16:12:06.317 PDT ] [OracleHome.getVersion:1062] Current Version From Inventory: 12.1.0.2.0

[Thread-34] [ 2016-05-18 16:12:06.317 PDT ] [OracleHome.getVersion:994] OracleHome.getVersion called. Current Version: 12.1.0.2.0

[Thread-34] [ 2016-05-18 16:12:06.317 PDT ] [OracleHome.getVersion:1062] Current Version From Inventory: 12.1.0.2.0

[Thread-34] [ 2016-05-18 16:12:06.317 PDT ] [SQLPlusEngine.getCmmdParams:225] m_home 12.1.0.2.0

[Thread-34] [ 2016-05-18 16:12:06.317 PDT ] [SQLPlusEngine.getCmmdParams:226] version > 112 true

[Thread-34] [ 2016-05-18 16:12:06.317 PDT ] [OsUtilsBase.getBaseFromOrabase:659] oraBaseUtility C:\app\username\product\12.1.0\dbhome_1\bin\orabase.exe

[Thread-34] [ 2016-05-18 16:12:06.317 PDT ] [OsUtilsBase.getBaseFromOrabase:668] cmds: C:\app\username\product\12.1.0\dbhome_1\bin\orabase.exe

[Thread-34] [ 2016-05-18 16:12:06.317 PDT ] [OsUtilsBase.getBaseFromOrabase:672] envs: ORACLE_HOME=C:\app\username\product\12.1.0\dbhome_1

[Thread-34] [ 2016-05-18 16:12:06.371 PDT ] [OsUtilsBase.getBaseFromOrabase:682] baseLocation from orabase

C:\app\username

[Thread-34] [ 2016-05-18 16:12:06.371 PDT ] [OsUtilsBase.getBaseFromOrabase:707] orabaseLocation= C:\app\username

[Thread-34] [ 2016-05-18 16:12:06.371 PDT ] [SQLEngine.getEnvParams:612] NLS_LANG: AMERICAN_AMERICA.AL32UTF8

[Thread-34] [ 2016-05-18 16:12:06.372 PDT ] [SQLEngine.initialize:358] Execing SQLPLUS/SVRMGR process...

[Thread-34] [ 2016-05-18 16:12:06.374 PDT ] [SQLEngine.initialize:395] m_bReaderStarted: false

[Thread-34] [ 2016-05-18 16:12:06.374 PDT ] [SQLEngine.initialize:399] Starting Reader Thread...

[Thread-34] [ 2016-05-18 16:12:06.375 PDT ] [SQLEngine.initialize:448] Waiting for m_bReaderStarted to be true

[Thread-34] [ 2016-05-18 16:12:06.425 PDT ] [CloneRmanRestoreStep.cancel:722] Cleaning up partially extracted files failed

[Thread-34] [ 2016-05-18 16:12:06.574 PDT ] [SQLEngine.done:2278] Done called

[Thread-34] [ 2016-05-18 16:12:06.579 PDT ] [CloneRmanRestoreStep.cancel:737] RMAN cleanup failed

[Thread-34] [ 2016-05-18 16:12:06.579 PDT ] [CloneRmanRestoreStep.cancel:738] ORA-12560: TNS:protocol adapter error

oracle.sysman.assistants.util.sqlEngine.SQLEngine.executeImpl(SQLEngine.java:1739)
oracle.sysman.assistants.util.sqlEngine.SQLEngine.connect(SQLEngine.java:987)
oracle.sysman.assistants.dbca.backend.CloneRmanRestoreStep.cancel(CloneRmanRestoreStep.java:725)
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)

[Thread-34] [ 2016-05-18 16:12:06.579 PDT ] [CloneDBCreationStep.cancel:1178] CloneDBCreationStep.cancel(): nodeList= null

[Thread-34] [ 2016-05-18 16:12:06.579 PDT ] [SQLEngine.reInitialize:785] Reinitializing SQLEngine...

[Thread-34] [ 2016-05-18 16:12:06.579 PDT ] [OracleHome.getVersion:994] OracleHome.getVersion called. Current Version: 12.1.0.2.0

[Thread-34] [ 2016-05-18 16:12:06.580 PDT ] [OracleHome.getVersion:1062] Current Version From Inventory: 12.1.0.2.0

[Thread-34] [ 2016-05-18 16:12:06.580 PDT ] [OracleHome.getVersion:994] OracleHome.getVersion called. Current Version: 12.1.0.2.0

[Thread-34] [ 2016-05-18 16:12:06.580 PDT ] [OracleHome.getVersion:1062] Current Version From Inventory: 12.1.0.2.0

[Thread-34] [ 2016-05-18 16:12:06.580 PDT ] [OracleHome.getVersion:994] OracleHome.getVersion called. Current Version: 12.1.0.2.0

[Thread-34] [ 2016-05-18 16:12:06.580 PDT ] [OracleHome.getVersion:1062] Current Version From Inventory: 12.1.0.2.0

[Thread-34] [ 2016-05-18 16:12:06.580 PDT ] [SQLPlusEngine.getCmmdParams:225] m_home 12.1.0.2.0

[Thread-34] [ 2016-05-18 16:12:06.580 PDT ] [SQLPlusEngine.getCmmdParams:226] version > 112 true

[Thread-34] [ 2016-05-18 16:12:06.580 PDT ] [OsUtilsBase.getBaseFromOrabase:659] oraBaseUtility C:\app\username\product\12.1.0\dbhome_1\bin\orabase.exe

[Thread-34] [ 2016-05-18 16:12:06.580 PDT ] [OsUtilsBase.getBaseFromOrabase:668] cmds: C:\app\username\product\12.1.0\dbhome_1\bin\orabase.exe

[Thread-34] [ 2016-05-18 16:12:06.580 PDT ] [OsUtilsBase.getBaseFromOrabase:672] envs: ORACLE_HOME=C:\app\username\product\12.1.0\dbhome_1

[Thread-34] [ 2016-05-18 16:12:06.638 PDT ] [OsUtilsBase.getBaseFromOrabase:682] baseLocation from orabase

C:\app\username

[Thread-34] [ 2016-05-18 16:12:06.638 PDT ] [OsUtilsBase.getBaseFromOrabase:707] orabaseLocation= C:\app\username

[Thread-34] [ 2016-05-18 16:12:06.638 PDT ] [SQLEngine.getEnvParams:612] NLS_LANG: AMERICAN_AMERICA.AL32UTF8

[Thread-34] [ 2016-05-18 16:12:06.638 PDT ] [SQLEngine.initialize:358] Execing SQLPLUS/SVRMGR process...

[Thread-34] [ 2016-05-18 16:12:06.646 PDT ] [SQLEngine.initialize:395] m_bReaderStarted: false

[Thread-34] [ 2016-05-18 16:12:06.646 PDT ] [SQLEngine.initialize:399] Starting Reader Thread...

[Thread-34] [ 2016-05-18 16:12:06.646 PDT ] [SQLEngine.initialize:448] Waiting for m_bReaderStarted to be true

[Thread-34] [ 2016-05-18 16:12:06.801 PDT ] [SQLEngine.done:2278] Done called

[Thread-34] [ 2016-05-18 16:12:06.804 PDT ] [Oradim.getRemoveEntryCommand:506] Execing C:\app\username\product\12.1.0\dbhome_1\bin\oradim.exe -delete -sid ORA10

[Thread-34] [ 2016-05-18 16:12:09.028 PDT ] [InventoryUtil.getOUIInvSession:349] setting OUI READ level to ACCESSLEVEL_READ_LOCKLESS

[Thread-34] [ 2016-05-18 16:12:09.028 PDT ] [InventoryUtil.getHomeName:113] homeName = OraDB12Home1

[Thread-34] [ 2016-05-18 16:12:09.028 PDT ] [OsUtilsBase.getOracleHomeKeyImpl:992] getting home key for home name: OraDB12Home1

[Thread-34] [ 2016-05-18 16:12:09.028 PDT ] [OsUtilsBase.getRegistryEntry:1026] hklmKey while getting registry entryHKEY_LOCAL_MACHINE

[Thread-34] [ 2016-05-18 16:12:09.028 PDT ] [OsUtilsBase.getRegistryEntry:1027] keyToSet while getting registry entrySOFTWARE\ORACLE\KEY_OraDB12Home1

[Thread-34] [ 2016-05-18 16:12:09.028 PDT ] [OsUtilsBase.removeRegistryEntry:1054] Deleting entry

[Thread-34] [ 2016-05-18 16:12:09.028 PDT ] [OsUtilsBase.removeRegistryEntry:1060] Exception while adding registry value InvalidKey

[Thread-34] [ 2016-05-18 16:12:09.028 PDT ] [OsUtilsBase.deleteFile:1803] OsUtilsBase.deleteFile: C:\app\username\product\12.1.0\dbhome_1\database\PWDora10.ora

[Thread-34] [ 2016-05-18 16:12:09.028 PDT ] [OsUtilsBase.deleteFile:1803] OsUtilsBase.deleteFile: C:\app\username\product\12.1.0\dbhome_1\database\initora10.ora

[Thread-34] [ 2016-05-18 16:12:09.028 PDT ] [OsUtilsBase.deleteFile:1803] OsUtilsBase.deleteFile: C:\app\username\admin\ora10\pfile\init.ora

[Thread-34] [ 2016-05-18 16:12:09.028 PDT ] [CloneDBCreationStep.cancel:1225] CloneDBCreationStep.cancel(): bRaw=false

[Thread-34] [ 2016-05-18 16:12:09.028 PDT ] [OsUtilsBase.deleteFile:1803] OsUtilsBase.deleteFile: C:\app\username\oradata\ora10\SYSAUX01.DBF

[Thread-34] [ 2016-05-18 16:12:09.028 PDT ] [OsUtilsBase.deleteFile:1803] OsUtilsBase.deleteFile: C:\app\username\oradata\ora10\SYSTEM01.DBF

[Thread-34] [ 2016-05-18 16:12:09.028 PDT ] [OsUtilsBase.deleteFile:1803] OsUtilsBase.deleteFile: C:\app\username\oradata\ora10\UNDOTBS01.DBF

[Thread-34] [ 2016-05-18 16:12:09.028 PDT ] [OsUtilsBase.deleteFile:1803] OsUtilsBase.deleteFile: C:\app\username\oradata\ora10\USERS01.DBF

[Thread-34] [ 2016-05-18 16:12:09.028 PDT ] [CommonAttributes.replaceVariables:1402] var2 C:\app\username