Thursday, November 15, 2012

empreqkit error UNABLE_TO_START_NEW_SESSION_ON_NEW_DB #EM12c

To install an new EM12c environment it is highly recommended you run the emprereqkit  utility . This utility is accessible thru the installation binaries  in the $SHARED_SOFT_PATH/12.1.0.2/install/requisites/bin directory. if you are running a prereq check via a shared mount point . you might hit an error like the one below. This error happens if you ran an emprereqkit   on another environment and never completed all the tasks.


Following exception occured in EMPrereqKit
Calling sequence (top to bottom)
--level 1--------------------------------------
Class/Method: EMPrereqKitManager/getInitialState
Id          : UNABLE_TO_START_NEW_SESSION_ON_NEW_DB
Message     :  Please end the session in last db (runPrereqs, runCorrectiveActions, runPostCorrectiveActions). Then only you can start a new session at a new db

         at oracle.sysman.emdrep.emprereqkit.emprerequisitemanager.EMPrereqKitManager.getInitialState(EMPrereqKitManager.java:353)
         at oracle.sysman.emdrep.emprereqkit.emprerequisitemanager.EMPrereqKitManager.processActionsList(EMPrereqKitManager.java:330)
         at oracle.sysman.emdrep.emprereqkit.emprerequisitemanager.EMPrereqKitManager.executeMainOperation(EMPrereqKitManager.java:171)
         at oracle.sysman.emSDK.emdrep.emprereqkit.EMPrerequisiteKit.executeMainOperation(EMPrerequisiteKit.java:83)
         at oracle.sysman.emdrep.emprereqkit.core.EMPrereqKit.main(EMPrereqKit.java:72)

 Caused by: null



empreqkit creates a state file that keep tab on the state of the job.
the Statefile is created in $SHARED_SOFT_PATH/12.1.0.2/install/requisites/bin/prerequisiteResults
a cat of the statefile will show something like this
(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=example-scan.example.com)(PORT=1521)))(CONNECT_DATA=(SID=demdb11))):DoneCorrectiveActions


If this state file is there it will not  allow you to run a seperate session until either the old session on the old database server  is completed or the statefile is removed or renamed.

Google Search