1 Reply Latest reply: Nov 24, 2013 5:00 AM by hqt200475 RSS

    dbca & Error: ORA-12547: TNS: lost contact

    hqt200475

      Hi

       

      I installed Oracle 11.2.0.4 software on Oracle Linux 6.4/64-Bit  as user oracle!

      Now I tried to execute dbca to create a database as user oracle (primary group=oinstall, sec. group=dba), it started fine without any error !

       

      But when I started dbca as other user xxx (primary group=oinstall, sec. group=dba), dbca started but It has the following output:

       

      [main] [ 2013-11-23 15:56:03.187 CET ] [Host.<init>:863]  Trace: error creating file /u01/app/oracle/cfgtoollogs/dbca/trace.log_OraDb11g_home1_2013-11-23_03-56-03-PM. All further file output is terminated

      [main] [ 2013-11-23 15:56:03.188 CET ] [Host.<init>:864]  Trace: error creating file /u01/app/oracle/cfgtoollogs/dbca/trace.log_OraDb11g_home1_2013-11-23_03-56-03-PM. All further file output is terminated

      [main] [ 2013-11-23 15:56:03.470 CET ] [DBCAWizard.<init>:455]  listeners.length 0

      [main] [ 2013-11-23 15:56:03.470 CET ] [DBCAWizard.<init>:459]  Inside disable loop

      [main] [ 2013-11-23 15:56:03.471 CET ] [DBCAWizard.removePageFromList:1238]  DBCAWizard->removePageFromList: The page to be removed = NetworkConfPage

      [main] [ 2013-11-23 15:56:03.471 CET ] [DBCAWizard.removePageFromList:1238]  DBCAWizard->removePageFromList: The page to be removed = NetworkConfPage

      [main] [ 2013-11-23 15:56:03.471 CET ] [DBCAWizard.removePageFromList:1238]  DBCAWizard->removePageFromList: The page to be removed = NetworkConfPage

      [main] [ 2013-11-23 15:56:03.472 CET ] [DBCAWizard.removePageFromList:1238]  DBCAWizard->removePageFromList: The page to be removed = NetworkConfPage

      [main] [ 2013-11-23 15:56:03.472 CET ] [DBCAWizard.removePageFromList:1238]  DBCAWizard->removePageFromList: The page to be removed = NetworkConfPage

      [main] [ 2013-11-23 15:56:03.472 CET ] [DBCAWizard.removePageFromList:1238]  DBCAWizard->removePageFromList: The page to be removed = NetworkConfPage

      [main] [ 2013-11-23 15:56:03.618 CET ] [OracleHome.getVersion:892]  OracleHome.getVersion called.  Current Version: null

      [main] [ 2013-11-23 15:56:03.621 CET ] [InventoryUtil.getOUIInvSession:347]  setting OUI READ level to ACCESSLEVEL_READ_LOCKLESS

      [main] [ 2013-11-23 15:56:03.621 CET ] [OracleHome.getVersion:911]  Homeinfo /u01/app/oracle/product/11.2.0.4/db_1,1

      [main] [ 2013-11-23 15:56:04.291 CET ] [OracleHome.getVersion:939]  OracleHome.server.getVersion Version: 11.2.0.4.0

      [main] [ 2013-11-23 15:56:04.292 CET ] [OracleHome.getVersion:960]  Current Version From Inventory: 11.2.0.4.0

      [main] [ 2013-11-23 15:56:04.292 CET ] [OracleHome.getVersion:892]  OracleHome.getVersion called.  Current Version: 11.2.0.4.0

      [main] [ 2013-11-23 15:56:04.293 CET ] [OracleHome.getVersion:960]  Current Version From Inventory: 11.2.0.4.0

      [main] [ 2013-11-23 15:56:04.293 CET ] [CommonUtils.createPasswordFile:609]  calling new orapwd for 11.1 or higher

      [main] [ 2013-11-23 15:56:04.300 CET ] [OsUtilsBase.execProg:2183]  beginning execProg with input array.

      [main] [ 2013-11-23 15:56:04.344 CET ] [OsUtilsBase.execProg:2220]  finished execProg with input array. Status:0

      [main] [ 2013-11-23 15:56:04.345 CET ] [OracleHome.initOptions:1239]  Initializing Database Options with  for dummy sid=DBUA5603601 using initfile=/u01/app/oracle/product/11.2.0.4/db_1/dbs/initDBUA5603601.ora using pwdfile=/u01/app/oracle/product/11.2.0.4/db_1/dbs/orapwDBUA5603601

      [main] [ 2013-11-23 15:56:04.349 CET ] [OracleHome.getVersion:892]  OracleHome.getVersion called.  Current Version: 11.2.0.4.0

      [main] [ 2013-11-23 15:56:04.349 CET ] [OracleHome.getVersion:960]  Current Version From Inventory: 11.2.0.4.0

      [main] [ 2013-11-23 15:56:04.349 CET ] [OracleHome.getVersion:892]  OracleHome.getVersion called.  Current Version: 11.2.0.4.0

      [main] [ 2013-11-23 15:56:04.350 CET ] [OracleHome.getVersion:960]  Current Version From Inventory: 11.2.0.4.0

      [main] [ 2013-11-23 15:56:04.350 CET ] [OracleHome.getVersion:892]  OracleHome.getVersion called.  Current Version: 11.2.0.4.0

      [main] [ 2013-11-23 15:56:04.351 CET ] [OracleHome.getVersion:960]  Current Version From Inventory: 11.2.0.4.0

      [main] [ 2013-11-23 15:56:04.352 CET ] [SQLPlusEngine.getCmmdParams:222]  m_home 11.2.0.4.0

      [main] [ 2013-11-23 15:56:04.352 CET ] [SQLPlusEngine.getCmmdParams:223]  version > 112 true

      [main] [ 2013-11-23 15:56:04.354 CET ] [SQLEngine.getEnvParams:555]  Default NLS_LANG: AMERICAN_AMERICA.AL32UTF8

      [main] [ 2013-11-23 15:56:04.354 CET ] [SQLEngine.getEnvParams:565]  NLS_LANG: AMERICAN_AMERICA.AL32UTF8

      [main] [ 2013-11-23 15:56:04.357 CET ] [SQLEngine.initialize:325]  Execing SQLPLUS/SVRMGR process...

      [main] [ 2013-11-23 15:56:04.372 CET ] [SQLEngine.initialize:362]  m_bReaderStarted: false

      [main] [ 2013-11-23 15:56:04.373 CET ] [SQLEngine.initialize:366]  Starting Reader Thread...

      [main] [ 2013-11-23 15:56:04.635 CET ] [SQLEngine.done:2189]  Done called

      [main] [ 2013-11-23 15:56:04.636 CET ] [OracleHome.initOptions:1291]  ORA-12547: TNS:lost contact

       

       

      oracle.sysman.assistants.util.sqlEngine.SQLFatalErrorException: ORA-12547: TNS:lost contact

       

       

              at oracle.sysman.assistants.util.sqlEngine.SQLEngine.executeImpl(SQLEngine.java:1658)

              at oracle.sysman.assistants.util.sqlEngine.SQLEngine.connect(SQLEngine.java:981)

              at oracle.sysman.assistants.util.OracleHome.initOptions(OracleHome.java:1245)

              at oracle.sysman.assistants.dbca.ui.UIHost.initialize(UIHost.java:305)

              at oracle.sysman.assistants.dbca.Dbca.execute(Dbca.java:117)

              at oracle.sysman.assistants.dbca.Dbca.main(Dbca.java:189)

      [main] [ 2013-11-23 15:56:04.638 CET ] [OracleHome.initOptions:1300]  shutting down dummy instance

      [main] [ 2013-11-23 15:56:04.639 CET ] [SQLEngine.reInitialize:738]  Reinitializing SQLEngine...

      [main] [ 2013-11-23 15:56:04.639 CET ] [OracleHome.getVersion:892]  OracleHome.getVersion called.  Current Version: 11.2.0.4.0

      [main] [ 2013-11-23 15:56:04.640 CET ] [OracleHome.getVersion:960]  Current Version From Inventory: 11.2.0.4.0

      [main] [ 2013-11-23 15:56:04.641 CET ] [OracleHome.getVersion:892]  OracleHome.getVersion called.  Current Version: 11.2.0.4.0

      [main] [ 2013-11-23 15:56:04.642 CET ] [OracleHome.getVersion:960]  Current Version From Inventory: 11.2.0.4.0

      [main] [ 2013-11-23 15:56:04.644 CET ] [OracleHome.getVersion:892]  OracleHome.getVersion called.  Current Version: 11.2.0.4.0

      [main] [ 2013-11-23 15:56:04.645 CET ] [OracleHome.getVersion:960]  Current Version From Inventory: 11.2.0.4.0

      [main] [ 2013-11-23 15:56:04.646 CET ] [SQLPlusEngine.getCmmdParams:222]  m_home 11.2.0.4.0

      [main] [ 2013-11-23 15:56:04.646 CET ] [SQLPlusEngine.getCmmdParams:223]  version > 112 true

      [main] [ 2013-11-23 15:56:04.647 CET ] [SQLEngine.getEnvParams:555]  Default NLS_LANG: AMERICAN_AMERICA.AL32UTF8

      [main] [ 2013-11-23 15:56:04.647 CET ] [SQLEngine.getEnvParams:565]  NLS_LANG: AMERICAN_AMERICA.AL32UTF8

      [main] [ 2013-11-23 15:56:04.648 CET ] [SQLEngine.initialize:325]  Execing SQLPLUS/SVRMGR process...

      [main] [ 2013-11-23 15:56:04.660 CET ] [SQLEngine.initialize:362]  m_bReaderStarted: false

      [main] [ 2013-11-23 15:56:04.662 CET ] [SQLEngine.initialize:366]  Starting Reader Thread...

      [main] [ 2013-11-23 15:56:04.664 CET ] [SQLEngine.initialize:415]  Waiting for m_bReaderStarted to be true

      [main] [ 2013-11-23 15:56:05.032 CET ] [SQLEngine.done:2189]  Done called

      [main] [ 2013-11-23 15:56:05.033 CET ] [OracleHome.initOptions:1307]  shutting down dummy instance failed

      [main] [ 2013-11-23 15:56:05.033 CET ] [OracleHome.initOptions:1332]  Database Options queried: 0

      [main] [ 2013-11-23 15:56:05.194 CET ] [Host.checkOPS:2603]  Inside checkOPS

      [main] [ 2013-11-23 15:56:05.194 CET ] [Host.checkOPS:2615]  Trying to check cluster existence

      [main] [ 2013-11-23 15:56:05.200 CET ] [Version.isPre:583]  version to be checked 11.2.0.4.0 major version to check against10

      [main] [ 2013-11-23 15:56:05.200 CET ] [Version.isPre:594]  isPre.java: Returning FALSE

      [main] [ 2013-11-23 15:56:05.200 CET ] [OCR.loadLibrary:312]

      Inside constructor of OCR

      [main] [ 2013-11-23 15:56:05.200 CET ] [OCR.isCluster:952]  Calling OCRNative for isCluster()

      [main] [ 2013-11-23 15:56:05.201 CET ] [OCR.isCluster:956]  OCR Result status = true

      [main] [ 2013-11-23 15:56:05.201 CET ] [OCR.isCluster:968]  Bolean result = false

      [main] [ 2013-11-23 15:56:05.201 CET ] [Host.checkOPS:2621]  cluster existence:false

      [main] [ 2013-11-23 15:56:05.201 CET ] [Host.checkOPS:2663]  Cluster installed=false

      [main] [ 2013-11-23 15:56:05.621 CET ] [Host.cleanup:3682]  Dbca exit status is: 0

      [main] [ 2013-11-23 15:56:05.621 CET ] [Host.cleanup:3685]  check point context null

      [main] [ 2013-11-23 15:56:05.624 CET ] [InventoryUtil.getOUIInvSession:347]  setting OUI READ level to ACCESSLEVEL_READ_LOCKLESS

      [main] [ 2013-11-23 15:56:05.625 CET ] [InventoryUtil.getHomeName:111]  homeName = OraDb11g_home1

       

      Can anyone tell me why? And do you know a solution?

       

      Thanks & regards

       

      hqt200475

        • 1. Re: dbca & Error: ORA-12547: TNS: lost contact
          hqt200475

          chmod -R 775  /u01/app/oracle/cfgtoollogs


          let write /u01/app/oracle/cfgtoollogs/dbca/trace.log..... in /u01/app/oracle/cfgtoollogs/trace.log_OraDb11g_home1_2013-11-24_11-37-42-AM


          but ORA-12547: TNS:lost contact remains :



           

          main] [ 2013-11-24 11:37:43.628 CET ] [DBCAWizard.<init>:455]  listeners.length 0

          [main] [ 2013-11-24 11:37:43.636 CET ] [DBCAWizard.<init>:459]  Inside disable loop

          [main] [ 2013-11-24 11:37:43.638 CET ] [DBCAWizard.removePageFromList:1238]  DBCAWizard->removePageFromList: The page to be removed = NetworkConfPage

          [main] [ 2013-11-24 11:37:43.639 CET ] [DBCAWizard.removePageFromList:1238]  DBCAWizard->removePageFromList: The page to be removed = NetworkConfPage

          [main] [ 2013-11-24 11:37:43.640 CET ] [DBCAWizard.removePageFromList:1238]  DBCAWizard->removePageFromList: The page to be removed = NetworkConfPage

          [main] [ 2013-11-24 11:37:43.641 CET ] [DBCAWizard.removePageFromList:1238]  DBCAWizard->removePageFromList: The page to be removed = NetworkConfPage

          [main] [ 2013-11-24 11:37:43.643 CET ] [DBCAWizard.removePageFromList:1238]  DBCAWizard->removePageFromList: The page to be removed = NetworkConfPage

          [main] [ 2013-11-24 11:37:43.644 CET ] [DBCAWizard.removePageFromList:1238]  DBCAWizard->removePageFromList: The page to be removed = NetworkConfPage

          [main] [ 2013-11-24 11:37:44.029 CET ] [OracleHome.getVersion:892]  OracleHome.getVersion called.  Current Version: null

          [main] [ 2013-11-24 11:37:44.031 CET ] [InventoryUtil.getOUIInvSession:347]  setting OUI READ level to ACCESSLEVEL_READ_LOCKLESS

          [main] [ 2013-11-24 11:37:44.032 CET ] [OracleHome.getVersion:911]  Homeinfo /u01/app/oracle/product/11.2.0.4/db_1,1

          [main] [ 2013-11-24 11:37:44.553 CET ] [OracleHome.getVersion:939]  OracleHome.server.getVersion Version: 11.2.0.4.0

          [main] [ 2013-11-24 11:37:44.555 CET ] [OracleHome.getVersion:960]  Current Version From Inventory: 11.2.0.4.0

          [main] [ 2013-11-24 11:37:44.555 CET ] [OracleHome.getVersion:892]  OracleHome.getVersion called.  Current Version: 11.2.0.4.0

          [main] [ 2013-11-24 11:37:44.555 CET ] [OracleHome.getVersion:960]  Current Version From Inventory: 11.2.0.4.0

          [main] [ 2013-11-24 11:37:44.555 CET ] [CommonUtils.createPasswordFile:609]  calling new orapwd for 11.1 or higher

          [main] [ 2013-11-24 11:37:44.559 CET ] [OsUtilsBase.execProg:2183]  beginning execProg with input array.

          [main] [ 2013-11-24 11:37:44.670 CET ] [OsUtilsBase.execProg:2220]  finished execProg with input array. Status:0

          [main] [ 2013-11-24 11:37:44.671 CET ] [OracleHome.initOptions:1239]  Initializing Database Options with  for dummy sid=DBUA3743990 using initfile=/u01/app/oracle/product/11.2.0.4/db_1/dbs/initDBUA3743990.ora using pwdfile=/u01/app/oracle/product/11.2.0.4/db_1/dbs/orapwDBUA3743990

          [main] [ 2013-11-24 11:37:44.680 CET ] [OracleHome.getVersion:892]  OracleHome.getVersion called.  Current Version: 11.2.0.4.0

          [main] [ 2013-11-24 11:37:44.681 CET ] [OracleHome.getVersion:960]  Current Version From Inventory: 11.2.0.4.0

          [main] [ 2013-11-24 11:37:44.681 CET ] [OracleHome.getVersion:892]  OracleHome.getVersion called.  Current Version: 11.2.0.4.0

          [main] [ 2013-11-24 11:37:44.681 CET ] [OracleHome.getVersion:960]  Current Version From Inventory: 11.2.0.4.0

          [main] [ 2013-11-24 11:37:44.681 CET ] [OracleHome.getVersion:892]  OracleHome.getVersion called.  Current Version: 11.2.0.4.0

          [main] [ 2013-11-24 11:37:44.682 CET ] [OracleHome.getVersion:960]  Current Version From Inventory: 11.2.0.4.0

          [main] [ 2013-11-24 11:37:44.682 CET ] [SQLPlusEngine.getCmmdParams:222]  m_home 11.2.0.4.0

          [main] [ 2013-11-24 11:37:44.682 CET ] [SQLPlusEngine.getCmmdParams:223]  version > 112 true

          [main] [ 2013-11-24 11:37:44.683 CET ] [SQLEngine.getEnvParams:555]  Default NLS_LANG: AMERICAN_AMERICA.AL32UTF8

          [main] [ 2013-11-24 11:37:44.683 CET ] [SQLEngine.getEnvParams:565]  NLS_LANG: AMERICAN_AMERICA.AL32UTF8

          [main] [ 2013-11-24 11:37:44.693 CET ] [SQLEngine.initialize:325]  Execing SQLPLUS/SVRMGR process...

          [main] [ 2013-11-24 11:37:44.746 CET ] [SQLEngine.initialize:362]  m_bReaderStarted: false

          [main] [ 2013-11-24 11:37:44.747 CET ] [SQLEngine.initialize:366]  Starting Reader Thread...

          [main] [ 2013-11-24 11:37:47.278 CET ] [SQLEngine.done:2189]  Done called

          [main] [ 2013-11-24 11:37:47.279 CET ] [OracleHome.initOptions:1291]  ORA-12547: TNS:lost contact

           

           

          oracle.sysman.assistants.util.sqlEngine.SQLFatalErrorException: ORA-12547: TNS:lost contact

           

           

            at oracle.sysman.assistants.util.sqlEngine.SQLEngine.executeImpl(SQLEngine.java:1658)

            at oracle.sysman.assistants.util.sqlEngine.SQLEngine.connect(SQLEngine.java:981)

            at oracle.sysman.assistants.util.OracleHome.initOptions(OracleHome.java:1245)

            at oracle.sysman.assistants.dbca.ui.UIHost.initialize(UIHost.java:305)

            at oracle.sysman.assistants.dbca.Dbca.execute(Dbca.java:117)

            at oracle.sysman.assistants.dbca.Dbca.main(Dbca.java:189)

          [main] [ 2013-11-24 11:37:47.281 CET ] [OracleHome.initOptions:1300]  shutting down dummy instance

          [main] [ 2013-11-24 11:37:47.282 CET ] [SQLEngine.reInitialize:738]  Reinitializing SQLEngine...

          [main] [ 2013-11-24 11:37:47.282 CET ] [OracleHome.getVersion:892]  OracleHome.getVersion called.  Current Version: 11.2.0.4.0

          [main] [ 2013-11-24 11:37:47.283 CET ] [OracleHome.getVersion:960]  Current Version From Inventory: 11.2.0.4.0

          [main] [ 2013-11-24 11:37:47.284 CET ] [OracleHome.getVersion:892]  OracleHome.getVersion called.  Current Version: 11.2.0.4.0

          [main] [ 2013-11-24 11:37:47.285 CET ] [OracleHome.getVersion:960]  Current Version From Inventory: 11.2.0.4.0

          [main] [ 2013-11-24 11:37:47.286 CET ] [OracleHome.getVersion:892]  OracleHome.getVersion called.  Current Version: 11.2.0.4.0

          [main] [ 2013-11-24 11:37:47.287 CET ] [OracleHome.getVersion:960]  Current Version From Inventory: 11.2.0.4.0

          [main] [ 2013-11-24 11:37:47.287 CET ] [SQLPlusEngine.getCmmdParams:222]  m_home 11.2.0.4.0

          [main] [ 2013-11-24 11:37:47.287 CET ] [SQLPlusEngine.getCmmdParams:223]  version > 112 true

          [main] [ 2013-11-24 11:37:47.288 CET ] [SQLEngine.getEnvParams:555]  Default NLS_LANG: AMERICAN_AMERICA.AL32UTF8

          [main] [ 2013-11-24 11:37:47.288 CET ] [SQLEngine.getEnvParams:565]  NLS_LANG: AMERICAN_AMERICA.AL32UTF8

          [main] [ 2013-11-24 11:37:47.289 CET ] [SQLEngine.initialize:325]  Execing SQLPLUS/SVRMGR process...

          [main] [ 2013-11-24 11:37:47.299 CET ] [SQLEngine.initialize:362]  m_bReaderStarted: false

          [main] [ 2013-11-24 11:37:47.299 CET ] [SQLEngine.initialize:366]  Starting Reader Thread...

          [main] [ 2013-11-24 11:37:47.300 CET ] [SQLEngine.initialize:415]  Waiting for m_bReaderStarted to be true

          [main] [ 2013-11-24 11:37:47.676 CET ] [SQLEngine.done:2189]  Done called

          [main] [ 2013-11-24 11:37:47.677 CET ] [OracleHome.initOptions:1307]  shutting down dummy instance failed

          [main] [ 2013-11-24 11:37:47.678 CET ] [OracleHome.initOptions:1332]  Database Options queried: 0

          [main] [ 2013-11-24 11:37:48.058 CET ] [Host.checkOPS:2603]  Inside checkOPS

          [main] [ 2013-11-24 11:37:48.058 CET ] [Host.checkOPS:2615]  Trying to check cluster existence

          [main] [ 2013-11-24 11:37:48.080 CET ] [Version.isPre:583]  version to be checked 11.2.0.4.0 major version to check against10

          [main] [ 2013-11-24 11:37:48.080 CET ] [Version.isPre:594]  isPre.java: Returning FALSE

          [main] [ 2013-11-24 11:37:48.081 CET ] [OCR.loadLibrary:312]

          Inside constructor of OCR

          [main] [ 2013-11-24 11:37:48.081 CET ] [OCR.isCluster:952]  Calling OCRNative for isCluster()

          [main] [ 2013-11-24 11:37:48.081 CET ] [OCR.isCluster:956]  OCR Result status = true

          [main] [ 2013-11-24 11:37:48.081 CET ] [OCR.isCluster:968]  Bolean result = false

          [main] [ 2013-11-24 11:37:48.082 CET ] [Host.checkOPS:2621]  cluster existence:false

          [main] [ 2013-11-24 11:37:48.082 CET ] [Host.checkOPS:2663]  Cluster installed=false

          [main] [ 2013-11-24 11:37:48.614 CET ] [Host.cleanup:3682]  Dbca exit status is: 0

          [main] [ 2013-11-24 11:37:48.616 CET ] [Host.cleanup:3685]  check point context null

          [main] [ 2013-11-24 11:37:48.618 CET ] [InventoryUtil.getOUIInvSession:347]  setting OUI READ level to ACCESSLEVEL_READ_LOCKLESS

          [main] [ 2013-11-24 11:37:48.619 CET ] [InventoryUtil.getHomeName:111]  homeName = OraDb11g_home1

          [AWT-EventQueue-0] [ 2013-11-24 11:37:59.377 CET ] [Host.cleanup:3682]  Dbca exit status is: -1

          [AWT-EventQueue-0] [ 2013-11-24 11:37:59.378 CET ] [Host.cleanup:3685]  check point context null

          [AWT-EventQueue-0] [ 2013-11-24 11:37:59.379 CET ] [InventoryUtil.getOUIInvSession:347]  setting OUI READ level to ACCESSLEVEL_READ_LOCKLESS

          [AWT-EventQueue-0] [ 2013-11-24 11:37:59.380 CET ] [InventoryUtil.getHomeName:111]  homeName = OraDb11g_home1

          [Thread-3] [ 2013-11-24 11:37:59.380 CET ] [DbcaCleanupHook.run:44]  Cleanup started

          [Thread-3] [ 2013-11-24 11:37:59.380 CET ] [OracleHome.cleanupDBOptionsIntance:1482]  DB Options dummy instance sid=null

          [Thread-3] [ 2013-11-24 11:37:59.381 CET ] [DbcaCleanupHook.run:49]  Cleanup ended

           

          Please help

           

          regards

           

          hqt200475