7 Replies Latest reply: Jul 24, 2012 10:19 AM by CowTown_dba RSS

    Error message "ORA-12547: TNS:lost contact" during dbca

    CowTown_dba
      Background info: I am building a new test 11.2.0.3 RAC cluster running on IBM pSeries hardware with AIX 6.1 OS level. I need to practice building a cluster and then adding a new node later. Because of limited hardware availability, my inital cluster will have 1 node and I will add the additional node later.

      I installed Grid Infrastructure successfully. GI and ASM are online and appear to be working normally. Today I installed the 11.2.0.3 database software. I am now trying to create a test database using DBCA. After entering all of the database information (SID information, where db files should reside, memory sizing, etc.) the database creation begins, then immediately issues the error message "ORA-12547: TNS:lost contact".

      I have searched MOS (Metalink) and also reviewed a few sites using Google. All of the information indicates this problem occurs most often when trying to log into an existing database using sqlplus. I haven't found anything related to this error message during database creation.

      Does anyone have advice on how to troubleshoot where the problem is coming from? Can you point me to some documentation that would help with this issue?

      Any and all help is appreciated. Thank you!
        • 1. Re: Error message "ORA-12547: TNS:lost contact" during dbca
          Srini Chavali-Oracle
          Search MOS for "dbca ORA-12547" and you will get a few hits - see if those help.

          Pl also past the last 100 lines from the install log - http://docs.oracle.com/cd/E11882_01/install.112/e24332/app_ts.htm#i1090466

          HTH
          Srini
          • 2. Re: Error message "ORA-12547: TNS:lost contact" during dbca
            CowTown_dba
            Thank you. I'll check the MOS documents and post the install log. Are you referring to the Grid Infrastructure install log?
            • 3. Re: Error message "ORA-12547: TNS:lost contact" during dbca
              Srini Chavali-Oracle
              DBCA is invoked from the database software installer, not the grid installer.

              HTH
              Srini
              • 4. Re: Error message "ORA-12547: TNS:lost contact" during dbca
                CowTown_dba
                Srini,

                I was verifying that I understood your request. The last install log relates to the Oracle db software installation and was created by OUI. The DBCA utility has not created any actual install logs. DBCA issues the error less than 10 seconds after I choose the "Finish" button to begin the database creation process. I also reviewed 4 notes on MOS and unfortunately they do not seem to apply. The permissions settings appear correct on all directories for both the database software owner and the grid infrastructure owner as well.

                Here are the last 200 lines from the OUI install log. Thank you again for all of your help!

                $ tail -200 installActions2012-07-16_10-20-11AM.log
                INFO: This variable s_caHelpPtBRJar is not added to the global context map
                INFO: This variable s_caHelpKoJar is not added to the global context map
                INFO: This variable s_caHelpJar is not added to the global context map
                INFO: This variable s_caHelpJaJar is not added to the global context map
                INFO: This variable s_caHelpItJar is not added to the global context map
                INFO: This variable s_caHelpFrJar is not added to the global context map
                INFO: This variable s_caHelpEsJar is not added to the global context map
                INFO: This variable s_caHelpDeJar is not added to the global context map
                INFO: This variable s_authAdaptors is not added to the global context map
                INFO: This variable ps_netCA_Args_OverRide is not added to the global context map
                INFO: This variable b_net8ServerInstalling is not added to the global context map
                INFO: This variable b_javavmIsInstalling is not added to the global context map
                INFO: This variable b_isWindows is not added to the global context map
                INFO: This variable b_isUNIX is not added to the global context map
                INFO: This variable b_cmanIsInstalling is not added to the global context map
                INFO: This variable b_anoIsInstalling is not added to the global context map
                INFO: This variable s_xmlparservLoc is not added to the global context map
                INFO: This variable s_skipharegistrationFlag is not added to the global context map
                INFO: This variable s_ouiJlibDir is not added to the global context map
                INFO: This variable s_opsmJlib is not added to the global context map
                INFO: This variable s_ntwkTools is not added to the global context map
                INFO: This variable s_netjlibDir is not added to the global context map
                INFO: This variable s_netcahelpLocation is not added to the global context map
                INFO: This variable s_netcaJlibDir is not added to the global context map
                INFO: This variable s_netcaDocDir is not added to the global context map
                INFO: This variable s_netPropertiesFile is not added to the global context map
                INFO: This variable s_netCA is not added to the global context map
                INFO: This variable s_net8caFileToInstantiate is not added to the global context map
                INFO: This variable s_jre15Location is not added to the global context map
                INFO: This variable s_jlibDir is not added to the global context map
                INFO: This variable s_inventoryPrereqOui is not added to the global context map
                INFO: This variable s_emdwLibDir is not added to the global context map
                INFO: This variable s_caHelpDir is not added to the global context map
                INFO: This variable s_assistantJlibDir is not added to the global context map
                INFO: This variable s_JavaFlag is not added to the global context map
                INFO: This variable b_isOPS is not added to the global context map
                INFO: This variable s_windowsCommandLine is not added to the global context map
                INFO: This variable s_srcOracleHome is not added to the global context map
                INFO: This variable s_net8caExecutable is not added to the global context map
                INFO: This variable s_netcaUserDirArg is not added to the global context map
                INFO: This variable s_installTypeForNetCA is not added to the global context map
                INFO: This variable s_netcaSilentFlag is not added to the global context map
                INFO: This variable s_netCAInstalledProducts is not added to the global context map
                INFO: This variable s_netcaClasspath is not added to the global context map
                INFO: This variable PROD_HOME is not added to the global context map
                INFO: ORACLE_HOME is not settable, hence not setting the value
                INFO: Handling the storing of variables for aggr name oracle.assistants.server
                INFO: This variable s_operatingSystem is not added to the global context map
                INFO: This variable s_jreLocation is not added to the global context map
                INFO: This variable pn_dboffset is not added to the global context map
                INFO: This variable cs_swingName is not added to the global context map
                INFO: This variable cs_komodoName is not added to the global context map
                INFO: This variable cs_kodiakName is not added to the global context map
                INFO: This variable cs_jewtName is not added to the global context map
                INFO: This variable cs_iceBrowserName is not added to the global context map
                INFO: This variable cs_ewtcompatName is not added to the global context map
                INFO: This variable cs_ewtName is not added to the global context map
                INFO: This variable cs_baliShareName is not added to the global context map
                INFO: This variable b_orabaseContainsOrahome is not added to the global context map
                INFO: This variable b_isWINDOWS is not added to the global context map
                INFO: This variable b_isUNIX is not added to the global context map
                INFO: This variable sl_dbmaParameterListForIcon is not added to the global context map
                INFO: This variable sl_dbcaParameterListForIcon is not added to the global context map
                INFO: This variable s_xmlparservLoc is not added to the global context map
                INFO: This variable s_skipHARegistrationFlag is not added to the global context map
                INFO: This variable s_ouiJlibLocation is not added to the global context map
                INFO: This variable s_oratabLocation is not added to the global context map
                INFO: This variable s_opsmLocation is not added to the global context map
                INFO: This variable s_dbuaLocation is not added to the global context map
                INFO: This variable s_dbcaLocation is not added to the global context map
                INFO: This variable s_OracleBinLocation is not added to the global context map
                INFO: This variable s_dbcaInstLaunchFile is not added to the global context map
                INFO: This variable s_dbcaLaunchFile is not added to the global context map
                INFO: This variable s_dbmaLaunchFile is not added to the global context map
                INFO: This variable s_dbmaInstLaunchFile is not added to the global context map
                INFO: This variable PROD_HOME is not added to the global context map
                INFO: ORACLE_HOME is not settable, hence not setting the value
                INFO: Handling the storing of variables for aggr name oracle.sysman.console.db
                INFO: This variable s_sid is not added to the global context map
                INFO: This variable s_serverInstallType is not added to the global context map
                INFO: This variable s_platform is not added to the global context map
                INFO: HashMap added with the key oracle.sysman.console.db and an empty variable Vector
                INFO: Adding the variable s_obfOc4jAdmPasswd to the aggregate oracle.sysman.console.db
                INFO: Adding the variable s_obfOc4jAdmPasswd to the global context map for the aggregate oracle.sysman.console.db
                INFO: Adding the variable s_obfJtaAdmPasswd to the aggregate oracle.sysman.console.db
                INFO: Adding the variable s_obfJtaAdmPasswd to the global context map for the aggregate oracle.sysman.console.db
                INFO: This variable s_nlsLang is not added to the global context map
                INFO: This variable s_emailServer is not added to the global context map
                INFO: This variable s_emailAddress is not added to the global context map
                INFO: This variable s_cfgtyperet is not added to the global context map
                INFO: Adding the variable s_JtaAdmPasswd to the aggregate oracle.sysman.console.db
                INFO: Adding the variable s_JtaAdmPasswd to the global context map for the aggregate oracle.sysman.console.db
                INFO: This variable n_uploadInterval is not added to the global context map
                INFO: This variable localhost is not added to the global context map
                INFO: This variable b_launchTools is not added to the global context map
                INFO: This variable b_launchBrowser is not added to the global context map
                INFO: This variable b_isUNIX is not added to the global context map
                INFO: This variable b_centralConsole is not added to the global context map
                INFO: This variable USE_HTTP_PROXY is not added to the global context map
                INFO: This variable USE_DB_CONSOLE is not added to the global context map
                INFO: This variable SET_CONSOLE_MODE is not added to the global context map
                INFO: This variable SA_SETUP is not added to the global context map
                INFO: This variable OC4JLOC is not added to the global context map
                INFO: This variable NO_PC_MODE is not added to the global context map
                INFO: This variable LOGGING_LEVEL is not added to the global context map
                INFO: This variable JRE_HOME is not added to the global context map
                INFO: This variable ISQLPLUS_PROTOCOL is not added to the global context map
                INFO: This variable ISQLPLUS_PORT is not added to the global context map
                INFO: This variable HOST_SID_OFFSET_ENABLED is not added to the global context map
                INFO: This variable HOSTNAME is not added to the global context map
                INFO: This variable EM_UPLOAD_DISABLE is not added to the global context map
                INFO: This variable EM_UIX_DEBUG_FLAG is not added to the global context map
                INFO: This variable EMPRODVER is not added to the global context map
                INFO: This variable CONSOLE_MODE is not added to the global context map
                INFO: This variable CONSOLE_CFG is not added to the global context map
                INFO: This variable sl_oraclehomes is not added to the global context map
                INFO: This variable s_oc4jDir is not added to the global context map
                INFO: This variable s_oc4jAppsDir is not added to the global context map
                INFO: This variable s_jreHome is not added to the global context map
                INFO: This variable s_configcommand is not added to the global context map
                INFO: This variable b_isRAC is not added to the global context map
                INFO: This variable b_UNIX is not added to the global context map
                INFO: This variable OJSP_JAR_LOC is not added to the global context map
                INFO: This variable OJSPUTIL_JAR_LOC is not added to the global context map
                INFO: This variable LDAP_JAR_LOC is not added to the global context map
                INFO: This variable JAVA_HOME is not added to the global context map
                INFO: This variable ISQLPLUS_HOST is not added to the global context map
                INFO: This variable EM_UIX_LOCATION is not added to the global context map
                INFO: This variable EM_REPOS_HOST is not added to the global context map
                INFO: This variable EM_PING_COMMAND is not added to the global context map
                INFO: This variable EM_OC4J_HOME is not added to the global context map
                INFO: This variable EM_EAR_LOC is not added to the global context map
                INFO: This variable EMDROOT is not added to the global context map
                INFO: Adding the variable s_oc4jAdmPasswd to the aggregate oracle.sysman.console.db
                INFO: Adding the variable s_oc4jAdmPasswd to the global context map for the aggregate oracle.sysman.console.db
                INFO: This variable s_launchBrowserClasspath is not added to the global context map
                INFO: This variable s_javapOracleHome is not added to the global context map
                INFO: This variable PROD_HOME is not added to the global context map
                INFO: {Parameter:TOPLEVEL_COMPONENT in {Aggregate:OuiConfigVariables:1.0.0.0.0:common}}: Parameter data type is not compatible with the provided String Array.
                INFO: passing params to cf done
                INFO: done saving info by cf
                INFO: This is a shared oracle home or remote nodes are null. No copy required.
                INFO: Checkpoint:Failed Checkpoint found returning it for getAllFailedCheckPoints.
                INFO: Checkpoint:Failed Checkpoint found returning null for getLastFailedCheckPoint.
                INFO: Checkpoint:Index file written and updated
                INFO: Checkpoint:Transfer of file done from remote node
                INFO: Adding iterator oracle.sysman.oii.oiif.oiifw.OiifwRootShWCDE
                INFO: Updating the global context
                INFO: Path To 'globalcontext.xml' = /u01/app/oracle/cmdseries/11.2.0/install/chainedInstall/globalcontext
                INFO: Since operation was successful, move the current OiicAPISessionDetails to installed list
                INFO: Number of scripts to be executed as root user = 1
                INFO: isSuccessfullInstallation: true
                INFO: isSuccessfullRemoteInstallation: true
                INFO: Adding ExitStatus SUCCESS to the exit status set
                INFO: Completed setting up InstallDB
                INFO: Number of scripts to be executed as root user = 1
                INFO: User accepted to run root scripts
                INFO: Shutting down OUISetupDriver.JobExecutorThread
                INFO: Cleaning up, please wait...
                INFO: Dispose the install area control object
                INFO: Update the state machine to STATE_CLEAN
                INFO: Setup completed with overall status as Succeeded
                INFO: All forked task are completed at state setup
                INFO: Completed background operations
                INFO: Moved to state <setup>
                INFO: Waiting for completion of background operations
                INFO: Completed background operations
                INFO: Validating view at state <setup>
                INFO: Completed validating view at state <setup>
                INFO: Validating state <setup>
                INFO: Completed validating state <setup>
                INFO: Verifying route success
                INFO: Get view named [FinishUI]
                INFO: View for [FinishUI] is oracle.install.ivw.db.view.FinishUI@6f286f28
                INFO: Initializing view <FinishUI> at state <finish>
                INFO: Completed initializing view <FinishUI> at state <finish>
                INFO: Displaying view <FinishUI> at state <finish>
                INFO: Completed displaying view <FinishUI> at state <finish>
                INFO: Loading view <FinishUI> at state <finish>
                INFO: Install Succeeded: true
                INFO: Config Tool Succeeded: true
                INFO: Remote Install Succeeded: true
                INFO: Completed loading view <FinishUI> at state <finish>
                INFO: Localizing view <FinishUI> at state <finish>
                INFO: Completed localizing view <FinishUI> at state <finish>
                INFO: Waiting for completion of background operations
                INFO: Completed background operations
                INFO: Executing action at state finish
                INFO: FinishAction Actions.execute called
                INFO: Completed executing action at state <finish>
                INFO: Waiting for completion of background operations
                INFO: Completed background operations
                INFO: Moved to state <finish>
                INFO: Adding ExitStatus SUCCESS_WITH_WARNINGS to the exit status set
                INFO: Finding the most appropriate exit status for the current application
                INFO: Exit Status is 6
                INFO: List of warnings encountered in this Application:
                INFO: PREREQS_FAILED_WITH_WARNING
                INFO: Shutdown Oracle Database 11g Release 2 Installer
                INFO: Unloading Setup Driver
                $
                • 5. Re: Error message "ORA-12547: TNS:lost contact" during dbca
                  Srini Chavali-Oracle
                  Hmm - Nothing of note in what you have posted. Are there any errors at all in this log file that you can find ? Are there any other logs in $ORACLE_BASE/cfgtoollogs/dbca ?

                  HTH
                  Srini
                  • 6. Re: Error message "ORA-12547: TNS:lost contact" during dbca
                    CowTown_dba
                    Thank you for your advice and help. I am going to run the deinstall script as downloaded from OTN to deinstall the database and grid infrastructure software, then run cluvfy again and re-install the software. I will update when I am successful. Thank you, once again.
                    • 7. Re: Error message "ORA-12547: TNS:lost contact" during dbca
                      CowTown_dba
                      Apparently, during my install of grid infrastructure, the oracle inventory location was "locked". So the software thought I was creating an Oracle Restart database. Once I ran the deinstall tool (downloaded from OTN, not the deinstall tool provided with the Grid Infrastructure download) for both Oracle homes (database and then grid infrastructure) the issue was resolved. Thank you again to everyone for the helpful advice.

                      Mark