3 Replies Latest reply: Jul 4, 2013 7:22 AM by user5076678 RSS

    R12 RAC Doubt

    Maverick
      Hi everybody,

      I have Installed R12.1.1 and upgraded database to 11gr2 and configured cluster and evry thing. Now i am at stage of running RCONFIG

      Here i have a doubt there are 3 Oracle Homes

      i. R12 database oracle home
      ii.CRS oracle Home
      iii. one more oracle home after installing Cluster that is for dummy database which i created.

      i have two questions :

      i. when editing convertRAC.xml file

      what should i give for source database and target database

      what shopuld be the database status which should be up and running and which should be down.

      waiting for reply

      Thanks
        • 1. Re: R12 RAC Doubt
          Hussein Sawwan-Oracle
          what should i give for source database and target database
          Both should point to the ORACLE_HOME you are converting from non-RAC to RAC.
          what shopuld be the database status which should be up and running and which should be down.
          The database should be up before converting the database.

          Using Oracle 11g Release 2 Real Application Clusters with Oracle E-Business Suite Release 12 [ID 823587.1]

          Thanks,
          Hussein
          • 2. Re: R12 RAC Doubt
            Maverick
            I have started my R12 database from new oracle home after creating spfile,

            when i run RCONFIG i'm getting like


            <?xml version="1.0" ?>
            <RConfig version="1.1" >
            <ConvertToRAC>
            <Convert>
            <Response>
            <Result code="1" >
            Got Exception
            </Result>
            <ErrorDetails>
            ORA-01034: ORACLE not available

            Operation Failed. Refer logs at /d01/oracle/app/oracle/cfgtoollogs/rconfig/rconf ig_12_30_10_18_40_06.log for more details.

            </ErrorDetails>
            </Response>
            </Convert>
            </ConvertToRAC></RConfig>
            [oracle@linux1 sampleXMLs]$ rconfig ConvertToRAC.xml
            <?xml version="1.0" ?>
            <RConfig version="1.1" >
            <ConvertToRAC>
            <Convert>
            <Response>
            <Result code="1" >
            Got Exception
            </Result>
            <ErrorDetails>
            ORA-01034: ORACLE not available

            Operation Failed. Refer logs at /d01/oracle/app/oracle/cfgtoollogs/rconfig/rconfig_12_30_10_18_40_30.log for more details.

            </ErrorDetails>
            </Response>
            </Convert>
            </ConvertToRAC></RConfig>

            and when i chek the log
            ----------------------------------
            [main] [ 2010-12-30 18:40:30.627 IST ] [RConfig.<init>:88] java.class.path=/d01/oracle/app/oracle/product/11.2.0/dbhome_1/jdk/jre/lib/rt.jar:/d01/oracle/app/oracle/product/11.2.0/dbhome_1/jdk/jre/lib/i18n.jar:/d01/oracle/app/oracle/product/11.2.0/dbhome_1/assistants/jlib/rconfigPatch.jar:/d01/oracle/app/oracle/product/11.2.0/dbhome_1/assistants/jlib/rconfig.jar:/d01/oracle/app/oracle/product/11.2.0/dbhome_1/assistants/jlib/assistantsCommon.jar:/d01/oracle/app/oracle/product/11.2.0/dbhome_1/jlib/ewt3.jar:/d01/oracle/app/oracle/product/11.2.0/dbhome_1/jlib/ewtcompat-3_3_15.jar:/d01/oracle/app/oracle/product/11.2.0/dbhome_1/jlib/share.jar:/d01/oracle/app/oracle/product/11.2.0/dbhome_1/jlib/help4.jar:/d01/oracle/app/oracle/product/11.2.0/dbhome_1/jlib/jewt4.jar:/d01/oracle/app/oracle/product/11.2.0/dbhome_1/jlib/oracle_ice5.jar:/d01/oracle/app/oracle/product/11.2.0/dbhome_1/jlib/kodiak.jar:/d01/oracle/app/oracle/product/11.2.0/dbhome_1/jlib/swingall-1_1_1.jar:/d01/oracle/app/oracle/product/11.2.0/dbhome_1/lib/xmlparserv2.jar:/d01/oracle/app/oracle/product/11.2.0/dbhome_1/jlib/orai18n.jar:/d01/oracle/app/oracle/product/11.2.0/dbhome_1/jlib/orai18n-mapping.jar:/d01/oracle/app/oracle/product/11.2.0/dbhome_1/jlib/orai18n-utility.jar:/d01/oracle/app/oracle/product/11.2.0/dbhome_1/jlib/orai18n-collation.jar::/d01/oracle/app/oracle/product/11.2.0/dbhome_1/jlib/ldapjclnt11.jar:/d01/oracle/app/oracle/product/11.2.0/dbhome_1/jlib/netcfg.jar:/d01/oracle/app/oracle/product/11.2.0/dbhome_1/jlib/ojmisc.jar:/d01/oracle/app/oracle/product/11.2.0/dbhome_1/jlib/oraclepki103.jar:/d01/oracle/app/oracle/product/11.2.0/dbhome_1/jlib/opm.jar:/d01/oracle/app/oracle/product/11.2.0/dbhome_1/jdbc/lib/ojdbc5.jar:/d01/oracle/app/oracle/product/11.2.0/dbhome_1/jlib/srvm.jar:/d01/oracle/app/oracle/product/11.2.0/dbhome_1/jlib/srvmhas.jar:/d01/oracle/app/oracle/product/11.2.0/dbhome_1/jlib/srvmasm.jar:/d01/oracle/app/oracle/product/11.2.0/dbhome_1/classes:/d01/oracle/app/oracle/product/11.2.0/dbhome_1/jlib/oemlt.jar:/d01/oracle/app/oracle/product/11.2.0/dbhome_1/jlib/emca.jar:/d01/oracle/app/oracle/product/11.2.0/dbhome_1/sysman/jlib/emCORE.jar:/d01/oracle/app/oracle/product/11.2.0/dbhome_1/oc4j/j2ee/home/oc4j.jar:/d01/oracle/app/oracle/product/11.2.0/dbhome_1/oc4j/j2ee/home/db_oc4j_deploy.jar:/d01/oracle/app/oracle/product/11.2.0/dbhome_1/jlib/emConfigInstall.jar:/d01/oracle/app/oracle/product/11.2.0/dbhome_1/oui/jlib/OraInstaller.jar:/d01/oracle/app/oracle/product/11.2.0/dbhome_1/oui/jlib/OraPrereq.jar:/d01/oracle/app/oracle/product/11.2.0/dbhome_1/inventory/prereqs/oui/OraPrereqChecks.jar:/d01/oracle/app/oracle/product/11.2.0/dbhome_1/oui/jlib/OraPrereqChecks.jar:/d01/oracle/app/oracle/product/11.2.0/dbhome_1/jlib/cvu.jar:/d01/oracle/app/oracle/product/11.2.0/dbhome_1/jdk/jre/lib/ext/sunjce_provider.jar:/d01/oracle/app/oracle/product/11.2.0/dbhome_1/assistants/asmca/jlib/asmca.jar
            [main] [ 2010-12-30 18:40:30.629 IST ] [RConfig.<init>:89] java.home=/d01/oracle/app/oracle/product/11.2.0/dbhome_1/jdk/jre
            [main] [ 2010-12-30 18:40:30.629 IST ] [RConfig.<init>:90] rconfig.user.dir=/d01/oracle/app/oracle/product/11.2.0/dbhome_1/assistants/rconfig/sampleXMLs
            [main] [ 2010-12-30 18:40:30.784 IST ] [ConfigParser.createURL:182] PATH=/d01/oracle/app/oracle/product/11.2.0/dbhome_1/assistants/rconfig/sampleXMLs/oracle/sysman/assistants/rconfig/parser/rconfig.xsd
            [main] [ 2010-12-30 18:40:30.784 IST ] [ConfigParser.createURL:197] URL=file:/d01/oracle/app/oracle/product/11.2.0/dbhome_1/assistants/rconfig/sampleXMLs/oracle/sysman/assistants/rconfig/parser/rconfig.xsd
            [main] [ 2010-12-30 18:40:30.786 IST ] [ConfigParser.parse:104] Found the parser at url file:/d01/oracle/app/oracle/product/11.2.0/dbhome_1/assistants/rconfig/sampleXMLs/oracle/sysman/assistants/rconfig/parser/rconfig.xsd
            [main] [ 2010-12-30 18:40:30.866 IST ] [ConfigParser.parse:136] Input File is not null, parsing input file xml
            [main] [ 2010-12-30 18:40:30.867 IST ] [ConfigParser.parse:143] Input xml Path : ConvertToRAC.xml
            [main] [ 2010-12-30 18:40:30.868 IST ] [ConfigParser.parse:147] validating the input against rconfig.xsd:
            [main] [ 2010-12-30 18:40:30.871 IST ] [ConfigurationHandler.startElement:114] localName=RConfig
            [main] [ 2010-12-30 18:40:30.871 IST ] [ConfigurationHandler.startElement:114] localName=ConvertToRAC
            [main] [ 2010-12-30 18:40:30.882 IST ] [ConfigurationHandler.processElement:75] RACConversion request created
            [main] [ 2010-12-30 18:40:30.884 IST ] [ConfigurationHandler.startElement:114] localName=Convert
            [main] [ 2010-12-30 18:40:30.895 IST ] [Convert.<init>:92] doPrechecks=ONLY
            [main] [ 2010-12-30 18:40:30.895 IST ] [ConfigurationHandler.startElement:114] localName=SourceDBHome
            [main] [ 2010-12-30 18:40:30.896 IST ] [ClusterStep.startChild:65] Inside startchild of cluster step for SourceDBHome
            [main] [ 2010-12-30 18:40:30.897 IST ] [ConfigurationHandler.endElement:149] endElement localName=SourceDBHome
            [main] [ 2010-12-30 18:40:30.897 IST ] [ClusterStep.endChild:133] Calling endChild for ClusterStep
            [main] [ 2010-12-30 18:40:30.901 IST ] [OraHome.<init>:51] Path to Oracle Home=/d01/oracle/PROD/db/tech_st/11.2.0
            [main] [ 2010-12-30 18:40:30.906 IST ] [OraHome.<init>:51] Path to Oracle Home=/d01/oracle/PROD/db/tech_st/11.2.0
            [main] [ 2010-12-30 18:40:30.907 IST ] [ConfigurationHandler.startElement:114] localName=TargetDBHome
            [main] [ 2010-12-30 18:40:30.908 IST ] [ClusterStep.startChild:65] Inside startchild of cluster step for TargetDBHome
            [main] [ 2010-12-30 18:40:30.908 IST ] [ConfigurationHandler.endElement:149] endElement localName=TargetDBHome
            [main] [ 2010-12-30 18:40:30.909 IST ] [ClusterStep.endChild:133] Calling endChild for ClusterStep
            [main] [ 2010-12-30 18:40:30.909 IST ] [OraHome.<init>:51] Path to Oracle Home=/d01/oracle/app/oracle/product/11.2.0/dbhome_1
            [main] [ 2010-12-30 18:40:30.910 IST ] [ConfigurationHandler.startElement:114] localName=SourceDBInfo
            [main] [ 2010-12-30 18:40:30.910 IST ] [ClusterStep.startChild:65] Inside startchild of cluster step for SourceDBInfo
            [main] [ 2010-12-30 18:40:30.916 IST ] [ConfigurationHandler.startElement:114] localName=Credentials
            [main] [ 2010-12-30 18:40:30.917 IST ] [ConfigurationHandler.startElement:114] localName=User
            [main] [ 2010-12-30 18:40:30.918 IST ] [ConfigurationHandler.endElement:149] endElement localName=User
            [main] [ 2010-12-30 18:40:30.918 IST ] [Instance$Credentials.endChild:220] UserName=sys
            [main] [ 2010-12-30 18:40:30.919 IST ] [ConfigurationHandler.startElement:114] localName=Password
            [main] [ 2010-12-30 18:40:30.926 IST ] [ConfigurationHandler.endElement:149] endElement localName=Password
            [main] [ 2010-12-30 18:40:30.927 IST ] [Instance$Credentials.endChild:224] Password Encrypted=false
            [main] [ 2010-12-30 18:40:30.930 IST ] [ConfigurationHandler.startElement:114] localName=Role
            [main] [ 2010-12-30 18:40:30.932 IST ] [ConfigurationHandler.endElement:149] endElement localName=Credentials
            [main] [ 2010-12-30 18:40:30.932 IST ] [ConfigurationHandler.endElement:149] endElement localName=SourceDBInfo
            [main] [ 2010-12-30 18:40:30.933 IST ] [ConfigurationHandler.startElement:114] localName=NodeList
            [main] [ 2010-12-30 18:40:30.933 IST ] [ClusterStep.startChild:65] Inside startchild of cluster step for NodeList
            [main] [ 2010-12-30 18:40:30.934 IST ] [ConfigurationHandler.startElement:114] localName=Node
            [main] [ 2010-12-30 18:40:30.934 IST ] [ClusterStep.startChild:65] Inside startchild of cluster step for Node
            [main] [ 2010-12-30 18:40:30.935 IST ] [Node.<init>:47] Name as obtained in inputXML=linux1
            [main] [ 2010-12-30 18:40:30.936 IST ] [Node.<init>:61] Qualified Node name=linux1, Non-qualified Node name=linux1
            [main] [ 2010-12-30 18:40:30.936 IST ] [ConfigurationHandler.endElement:149] endElement localName=Node
            [main] [ 2010-12-30 18:40:30.937 IST ] [ConfigurationHandler.startElement:114] localName=Node
            [main] [ 2010-12-30 18:40:30.937 IST ] [ClusterStep.startChild:65] Inside startchild of cluster step for Node
            [main] [ 2010-12-30 18:40:30.938 IST ] [Node.<init>:47] Name as obtained in inputXML=linux2
            [main] [ 2010-12-30 18:40:30.938 IST ] [Node.<init>:61] Qualified Node name=linux2, Non-qualified Node name=linux2
            [main] [ 2010-12-30 18:40:30.939 IST ] [ConfigurationHandler.endElement:149] endElement localName=Node
            [main] [ 2010-12-30 18:40:30.939 IST ] [ConfigurationHandler.endElement:149] endElement localName=NodeList
            [main] [ 2010-12-30 18:40:30.940 IST ] [ClusterStep.endChild:133] Calling endChild for ClusterStep
            [main] [ 2010-12-30 18:40:30.940 IST ] [ClusterStep.endChild:136] Nodes.length=2
            [main] [ 2010-12-30 18:40:30.940 IST ] [ConfigurationHandler.startElement:114] localName=InstancePrefix
            [main] [ 2010-12-30 18:40:30.941 IST ] [ClusterStep.startChild:65] Inside startchild of cluster step for InstancePrefix
            [main] [ 2010-12-30 18:40:30.942 IST ] [ConfigurationHandler.endElement:149] endElement localName=InstancePrefix
            [main] [ 2010-12-30 18:40:30.943 IST ] [OptionsCheck.endChild:115] NewSIDPREFIX=PROD
            [main] [ 2010-12-30 18:40:30.943 IST ] [ConfigurationHandler.startElement:114] localName=SharedStorage
            [main] [ 2010-12-30 18:40:30.943 IST ] [ClusterStep.startChild:65] Inside startchild of cluster step for SharedStorage
            [main] [ 2010-12-30 18:40:30.944 IST ] [ClusterStep.startChild:65] Inside startchild of cluster step for SharedStorage
            [main] [ 2010-12-30 18:40:30.951 IST ] [ConfigurationHandler.startElement:114] localName=TargetDatabaseArea
            [main] [ 2010-12-30 18:40:30.952 IST ] [ConfigurationHandler.endElement:149] endElement localName=TargetDatabaseArea
            [main] [ 2010-12-30 18:40:30.978 IST ] [ConfigurationHandler.startElement:114] localName=TargetFlashRecoveryArea
            [main] [ 2010-12-30 18:40:30.979 IST ] [ConfigurationHandler.endElement:149] endElement localName=TargetFlashRecoveryArea
            [main] [ 2010-12-30 18:40:30.979 IST ] [ConfigurationHandler.endElement:149] endElement localName=SharedStorage
            [main] [ 2010-12-30 18:40:30.980 IST ] [ConfigurationHandler.endElement:149] endElement localName=Convert
            [main] [ 2010-12-30 18:40:30.981 IST ] [ClusterStep.endChild:133] Calling endChild for ClusterStep
            [main] [ 2010-12-30 18:40:30.982 IST ] [ConfigurationHandler.endElement:149] endElement localName=ConvertToRAC
            [main] [ 2010-12-30 18:40:30.982 IST ] [ConfigurationHandler.endElement:149] endElement localName=RConfig
            [main] [ 2010-12-30 18:40:30.983 IST ] [ConfigParser.parse:149] Validated input against rconfig schema:
            [main] [ 2010-12-30 18:40:30.984 IST ] [OsUtilsBase.getBaseFromOrabase:516] oraBaseUtility /d01/oracle/app/oracle/product/11.2.0/dbhome_1/bin/orabase
            [main] [ 2010-12-30 18:40:30.985 IST ] [OsUtilsBase.getBaseFromOrabase:525] cmds: /d01/oracle/app/oracle/product/11.2.0/dbhome_1/bin/orabase
            [main] [ 2010-12-30 18:40:31.008 IST ] [OsUtilsBase.getBaseFromOrabase:530] baseLocation from orabase
            /d01/oracle/app/oracle
            [main] [ 2010-12-30 18:40:31.009 IST ] [OsUtilsBase.getBaseFromOrabase:555] orabaseLocation= /d01/oracle/app/oracle
            [main] [ 2010-12-30 18:40:31.009 IST ] [RACConvertStep.execute:149] $$$$$$$ The request name is ConvertToRAC
            [main] [ 2010-12-30 18:40:31.014 IST ] [RACConvertStep.execute:164] InetAddress.getLocalHost=linux1.oracle.com
            [main] [ 2010-12-30 18:40:31.015 IST ] [Node.<init>:47] Name as obtained in inputXML=linux1.oracle.com
            [main] [ 2010-12-30 18:40:31.015 IST ] [Node.<init>:61] Qualified Node name=linux1.oracle.com, Non-qualified Node name=linux1
            [main] [ 2010-12-30 18:40:31.016 IST ] [RACConvertStep.execute:168] Value of _localNode=linux1
            [main] [ 2010-12-30 18:40:31.016 IST ] [ClusterStep.checkNodeList:187] Index of localNode in HostItemlist=0
            [main] [ 2010-12-30 18:40:31.021 IST ] [OracleHome.getVersion:877] OracleHome.getVersion called. Current Version: null
            [main] [ 2010-12-30 18:40:31.263 IST ] [InventoryUtil.getOUIInvSession:347] setting OUI READ level to ACCESSLEVEL_READ_LOCKLESS
            [main] [ 2010-12-30 18:40:31.264 IST ] [OracleHome.getVersion:896] Homeinfo /d01/oracle/app/oracle/product/11.2.0/dbhome_1,3
            [main] [ 2010-12-30 18:40:32.001 IST ] [OracleHome.getVersion:922] OracleHome.server.getVersion Version: 11.2.0.1.0
            [main] [ 2010-12-30 18:40:32.004 IST ] [OracleHome.getVersion:943] Current Version From Inventory: 11.2.0.1.0
            [main] [ 2010-12-30 18:40:32.004 IST ] [OracleHome.getVersion:948] using sqlplus: /d01/oracle/app/oracle/product/11.2.0/dbhome_1/bin/sqlplus
            [main] [ 2010-12-30 18:40:32.005 IST ] [OracleHome.getVersion:877] OracleHome.getVersion called. Current Version: 11.2.0.1.0
            [main] [ 2010-12-30 18:40:32.005 IST ] [OracleHome.getVersion:943] Current Version From Inventory: 11.2.0.1.0
            [main] [ 2010-12-30 18:40:32.005 IST ] [OracleHome.getVersion:948] using sqlplus: /d01/oracle/app/oracle/product/11.2.0/dbhome_1/bin/sqlplus
            [main] [ 2010-12-30 18:40:32.008 IST ] [OracleHome.getVersion:877] OracleHome.getVersion called. Current Version: 11.2.0.1.0
            [main] [ 2010-12-30 18:40:32.008 IST ] [OracleHome.getVersion:943] Current Version From Inventory: 11.2.0.1.0
            [main] [ 2010-12-30 18:40:32.009 IST ] [OracleHome.getVersion:948] using sqlplus: /d01/oracle/app/oracle/product/11.2.0/dbhome_1/bin/sqlplus
            [main] [ 2010-12-30 18:40:32.009 IST ] [SQLPlusEngine.getCmmdParams:222] m_home 11.2.0.1.0
            [main] [ 2010-12-30 18:40:32.009 IST ] [SQLPlusEngine.getCmmdParams:223] version > 112 true
            [main] [ 2010-12-30 18:40:32.010 IST ] [OsUtilsBase.getBaseFromOrabase:516] oraBaseUtility /d01/oracle/app/oracle/product/11.2.0/dbhome_1/bin/orabase
            [main] [ 2010-12-30 18:40:32.010 IST ] [OsUtilsBase.getBaseFromOrabase:525] cmds: /d01/oracle/app/oracle/product/11.2.0/dbhome_1/bin/orabase
            [main] [ 2010-12-30 18:40:32.045 IST ] [OsUtilsBase.getBaseFromOrabase:530] baseLocation from orabase
            /d01/oracle/app/oracle
            [main] [ 2010-12-30 18:40:32.048 IST ] [OsUtilsBase.getBaseFromOrabase:555] orabaseLocation= /d01/oracle/app/oracle
            [main] [ 2010-12-30 18:40:32.166 IST ] [SQLEngine.getEnvParams:547] Default NLS_LANG: AMERICAN_AMERICA.AL32UTF8
            [main] [ 2010-12-30 18:40:32.166 IST ] [SQLEngine.getEnvParams:557] NLS_LANG: AMERICAN_AMERICA.AL32UTF8
            [main] [ 2010-12-30 18:40:32.169 IST ] [SQLEngine.initialize:317] Execing SQLPLUS/SVRMGR process...
            [main] [ 2010-12-30 18:40:32.173 IST ] [SQLEngine.initialize:354] m_bReaderStarted: false
            [main] [ 2010-12-30 18:40:32.173 IST ] [SQLEngine.initialize:358] Starting Reader Thread...
            [main] [ 2010-12-30 18:40:32.253 IST ] [OsUtilsBase.getBaseFromOrabase:516] oraBaseUtility /d01/oracle/app/oracle/product/11.2.0/dbhome_1/bin/orabase
            [main] [ 2010-12-30 18:40:32.253 IST ] [OsUtilsBase.getBaseFromOrabase:525] cmds: /d01/oracle/app/oracle/product/11.2.0/dbhome_1/bin/orabase
            [main] [ 2010-12-30 18:40:32.280 IST ] [OsUtilsBase.getBaseFromOrabase:530] baseLocation from orabase
            /d01/oracle/app/oracle
            [main] [ 2010-12-30 18:40:32.280 IST ] [OsUtilsBase.getBaseFromOrabase:555] orabaseLocation= /d01/oracle/app/oracle
            [main] [ 2010-12-30 18:40:32.281 IST ] [Instance.getSQLEngine:381] SQLEngine spooling to=/d01/oracle/app/oracle/cfgtoollogs/rconfig/PROD1/sqlLog
            [main] [ 2010-12-30 18:40:32.281 IST ] [SQLEngine.setSpool:1940] old Spool = null
            [main] [ 2010-12-30 18:40:32.281 IST ] [SQLEngine.setSpool:1941] Setting Spool = /d01/oracle/app/oracle/cfgtoollogs/rconfig/PROD1/sqlLog
            [main] [ 2010-12-30 18:40:32.282 IST ] [SQLEngine.setSpool:1942] Is spool appendable? --> true
            [main] [ 2010-12-30 18:40:32.284 IST ] [OracleHome.getVersion:877] OracleHome.getVersion called. Current Version: null
            [main] [ 2010-12-30 18:40:32.292 IST ] [InventoryUtil.getOUIInvSession:347] setting OUI READ level to ACCESSLEVEL_READ_LOCKLESS
            [main] [ 2010-12-30 18:40:32.293 IST ] [OracleHome.getVersion:896] Homeinfo /d01/oracle/PROD/db/tech_st/11.2.0,1
            [main] [ 2010-12-30 18:40:32.702 IST ] [OracleHome.getVersion:922] OracleHome.server.getVersion Version: 11.2.0.1.0
            [main] [ 2010-12-30 18:40:32.703 IST ] [OracleHome.getVersion:943] Current Version From Inventory: 11.2.0.1.0
            [main] [ 2010-12-30 18:40:32.703 IST ] [OracleHome.getVersion:948] using sqlplus: /d01/oracle/PROD/db/tech_st/11.2.0/bin/sqlplus
            [main] [ 2010-12-30 18:40:32.703 IST ] [OracleHome.getVersion:877] OracleHome.getVersion called. Current Version: 11.2.0.1.0
            [main] [ 2010-12-30 18:40:32.704 IST ] [OracleHome.getVersion:943] Current Version From Inventory: 11.2.0.1.0
            [main] [ 2010-12-30 18:40:32.704 IST ] [OracleHome.getVersion:948] using sqlplus: /d01/oracle/PROD/db/tech_st/11.2.0/bin/sqlplus
            [main] [ 2010-12-30 18:40:32.704 IST ] [OracleHome.getVersion:877] OracleHome.getVersion called. Current Version: 11.2.0.1.0
            [main] [ 2010-12-30 18:40:32.705 IST ] [OracleHome.getVersion:943] Current Version From Inventory: 11.2.0.1.0
            [main] [ 2010-12-30 18:40:32.705 IST ] [OracleHome.getVersion:948] using sqlplus: /d01/oracle/PROD/db/tech_st/11.2.0/bin/sqlplus
            [main] [ 2010-12-30 18:40:32.705 IST ] [SQLPlusEngine.getCmmdParams:222] m_home 11.2.0.1.0
            [main] [ 2010-12-30 18:40:32.706 IST ] [SQLPlusEngine.getCmmdParams:223] version > 112 true
            [main] [ 2010-12-30 18:40:32.706 IST ] [OsUtilsBase.getBaseFromOrabase:516] oraBaseUtility /d01/oracle/PROD/db/tech_st/11.2.0/bin/orabase
            [main] [ 2010-12-30 18:40:32.707 IST ] [OsUtilsBase.getBaseFromOrabase:525] cmds: /d01/oracle/PROD/db/tech_st/11.2.0/bin/orabase
            [main] [ 2010-12-30 18:40:32.785 IST ] [OsUtilsBase.getBaseFromOrabase:530] baseLocation from orabase
            /d01/oracle/app/oracle
            [main] [ 2010-12-30 18:40:32.786 IST ] [OsUtilsBase.getBaseFromOrabase:555] orabaseLocation= /d01/oracle/app/oracle
            [main] [ 2010-12-30 18:40:32.786 IST ] [SQLEngine.getEnvParams:547] Default NLS_LANG: AMERICAN_AMERICA.AL32UTF8
            [main] [ 2010-12-30 18:40:32.787 IST ] [SQLEngine.getEnvParams:557] NLS_LANG: AMERICAN_AMERICA.AL32UTF8
            [main] [ 2010-12-30 18:40:32.787 IST ] [SQLEngine.initialize:317] Execing SQLPLUS/SVRMGR process...
            [main] [ 2010-12-30 18:40:32.797 IST ] [SQLEngine.initialize:354] m_bReaderStarted: false
            [main] [ 2010-12-30 18:40:32.799 IST ] [SQLEngine.initialize:358] Starting Reader Thread...
            [main] [ 2010-12-30 18:40:32.865 IST ] [OsUtilsBase.getBaseFromOrabase:516] oraBaseUtility /d01/oracle/PROD/db/tech_st/11.2.0/bin/orabase
            [main] [ 2010-12-30 18:40:32.866 IST ] [OsUtilsBase.getBaseFromOrabase:525] cmds: /d01/oracle/PROD/db/tech_st/11.2.0/bin/orabase
            [main] [ 2010-12-30 18:40:32.892 IST ] [OsUtilsBase.getBaseFromOrabase:530] baseLocation from orabase
            /d01/oracle/app/oracle
            [main] [ 2010-12-30 18:40:32.892 IST ] [OsUtilsBase.getBaseFromOrabase:555] orabaseLocation= /d01/oracle/app/oracle
            [main] [ 2010-12-30 18:40:32.893 IST ] [Instance.getSQLEngine:381] SQLEngine spooling to=/d01/oracle/app/oracle/cfgtoollogs/rconfig/PROD/sqlLog
            [main] [ 2010-12-30 18:40:32.893 IST ] [SQLEngine.setSpool:1940] old Spool = null
            [main] [ 2010-12-30 18:40:32.893 IST ] [SQLEngine.setSpool:1941] Setting Spool = /d01/oracle/app/oracle/cfgtoollogs/rconfig/PROD/sqlLog
            [main] [ 2010-12-30 18:40:32.894 IST ] [SQLEngine.setSpool:1942] Is spool appendable? --> true
            [Thread-19] [ 2010-12-30 18:40:32.897 IST ] [Instance$RConfigErrorListener.gotError:435] Got error
            [Thread-19] [ 2010-12-30 18:40:32.897 IST ] [Instance$RConfigErrorListener.handleNonIgnorableError:450] Number of ERRORS:1
            [Thread-19] [ 2010-12-30 18:40:32.898 IST ] [Instance$RConfigErrorListener.handleNonIgnorableError:453] ERROR=ORA-01034: ORACLE not available
            [main] [ 2010-12-30 18:40:32.898 IST ] [SQLEngine.done:2148] Done called
            [main] [ 2010-12-30 18:40:32.898 IST ] [SQLEngine.spoolOff:2008] Setting spool off = /d01/oracle/app/oracle/cfgtoollogs/rconfig/PROD/sqlLog
            [main] [ 2010-12-30 18:40:32.900 IST ] [SQLEngine.done:2148] Done called
            [main] [ 2010-12-30 18:40:32.900 IST ] [OracleHome.getVersion:877] OracleHome.getVersion called. Current Version: 11.2.0.1.0
            [main] [ 2010-12-30 18:40:32.901 IST ] [OracleHome.getVersion:943] Current Version From Inventory: 11.2.0.1.0
            [main] [ 2010-12-30 18:40:32.901 IST ] [OracleHome.getVersion:948] using sqlplus: /d01/oracle/PROD/db/tech_st/11.2.0/bin/sqlplus
            [main] [ 2010-12-30 18:40:32.901 IST ] [OracleHome.getVersion:877] OracleHome.getVersion called. Current Version: 11.2.0.1.0
            [main] [ 2010-12-30 18:40:32.901 IST ] [OracleHome.getVersion:943] Current Version From Inventory: 11.2.0.1.0
            [main] [ 2010-12-30 18:40:32.902 IST ] [OracleHome.getVersion:948] using sqlplus: /d01/oracle/PROD/db/tech_st/11.2.0/bin/sqlplus
            [main] [ 2010-12-30 18:40:32.902 IST ] [OracleHome.getVersion:877] OracleHome.getVersion called. Current Version: 11.2.0.1.0
            [main] [ 2010-12-30 18:40:32.903 IST ] [OracleHome.getVersion:943] Current Version From Inventory: 11.2.0.1.0
            [main] [ 2010-12-30 18:40:32.903 IST ] [OracleHome.getVersion:948] using sqlplus: /d01/oracle/PROD/db/tech_st/11.2.0/bin/sqlplus
            [main] [ 2010-12-30 18:40:32.903 IST ] [SQLPlusEngine.getCmmdParams:222] m_home 11.2.0.1.0
            [main] [ 2010-12-30 18:40:32.904 IST ] [SQLPlusEngine.getCmmdParams:223] version > 112 true
            [main] [ 2010-12-30 18:40:32.904 IST ] [OsUtilsBase.getBaseFromOrabase:516] oraBaseUtility /d01/oracle/PROD/db/tech_st/11.2.0/bin/orabase
            [main] [ 2010-12-30 18:40:32.904 IST ] [OsUtilsBase.getBaseFromOrabase:525] cmds: /d01/oracle/PROD/db/tech_st/11.2.0/bin/orabase
            [main] [ 2010-12-30 18:40:32.930 IST ] [OsUtilsBase.getBaseFromOrabase:530] baseLocation from orabase
            /d01/oracle/app/oracle
            [main] [ 2010-12-30 18:40:32.930 IST ] [OsUtilsBase.getBaseFromOrabase:555] orabaseLocation= /d01/oracle/app/oracle
            [main] [ 2010-12-30 18:40:32.976 IST ] [SQLEngine.getEnvParams:547] Default NLS_LANG: AMERICAN_AMERICA.AL32UTF8
            [main] [ 2010-12-30 18:40:32.977 IST ] [SQLEngine.getEnvParams:557] NLS_LANG: AMERICAN_AMERICA.AL32UTF8
            [main] [ 2010-12-30 18:40:32.977 IST ] [SQLEngine.initialize:317] Execing SQLPLUS/SVRMGR process...
            [main] [ 2010-12-30 18:40:32.981 IST ] [SQLEngine.initialize:354] m_bReaderStarted: false
            [main] [ 2010-12-30 18:40:32.981 IST ] [SQLEngine.initialize:358] Starting Reader Thread...
            [main] [ 2010-12-30 18:40:33.042 IST ] [OsUtilsBase.getBaseFromOrabase:516] oraBaseUtility /d01/oracle/PROD/db/tech_st/11.2.0/bin/orabase
            [main] [ 2010-12-30 18:40:33.043 IST ] [OsUtilsBase.getBaseFromOrabase:525] cmds: /d01/oracle/PROD/db/tech_st/11.2.0/bin/orabase
            [main] [ 2010-12-30 18:40:33.078 IST ] [OsUtilsBase.getBaseFromOrabase:530] baseLocation from orabase
            /d01/oracle/app/oracle
            [main] [ 2010-12-30 18:40:33.079 IST ] [OsUtilsBase.getBaseFromOrabase:555] orabaseLocation= /d01/oracle/app/oracle
            [main] [ 2010-12-30 18:40:33.080 IST ] [Instance.getSQLEngine:381] SQLEngine spooling to=/d01/oracle/app/oracle/cfgtoollogs/rconfig/PROD/sqlLog
            [main] [ 2010-12-30 18:40:33.080 IST ] [SQLEngine.setSpool:1940] old Spool = null
            [main] [ 2010-12-30 18:40:33.080 IST ] [SQLEngine.setSpool:1941] Setting Spool = /d01/oracle/app/oracle/cfgtoollogs/rconfig/PROD/sqlLog
            [main] [ 2010-12-30 18:40:33.081 IST ] [SQLEngine.setSpool:1942] Is spool appendable? --> true
            [Thread-25] [ 2010-12-30 18:40:33.084 IST ] [Instance$RConfigErrorListener.gotError:435] Got error
            [Thread-25] [ 2010-12-30 18:40:33.084 IST ] [Instance$RConfigErrorListener.handleNonIgnorableError:450] Number of ERRORS:1
            [Thread-25] [ 2010-12-30 18:40:33.084 IST ] [Instance$RConfigErrorListener.handleNonIgnorableError:453] ERROR=ORA-01034: ORACLE not available
            [main] [ 2010-12-30 18:40:33.085 IST ] [SQLEngine.done:2148] Done called
            [main] [ 2010-12-30 18:40:33.085 IST ] [SQLEngine.spoolOff:2008] Setting spool off = /d01/oracle/app/oracle/cfgtoollogs/rconfig/PROD/sqlLog
            [main] [ 2010-12-30 18:40:33.086 IST ] [SQLEngine.done:2148] Done called
            oracle.sysman.assistants.util.sqlEngine.SQLFatalErrorException: ORA-01034: ORACLE not available

            at oracle.sysman.assistants.util.sqlEngine.SQLEngine.executeImpl(SQLEngine.java:1650)
            at oracle.sysman.assistants.util.sqlEngine.SQLEngine.executeQuery(SQLEngine.java:823)
            at oracle.sysman.assistants.util.sqlEngine.SQLPlusEngine.getResultFromQuery(SQLPlusEngine.java:409)
            at oracle.sysman.assistants.rconfig.engine.DBInstance.initialize(DBInstance.java:127)
            at oracle.sysman.assistants.rconfig.engine.RACConvertStep.execute(RACConvertStep.java:179)
            at oracle.sysman.assistants.rconfig.engine.Request.execute(Request.java:79)
            at oracle.sysman.assistants.rconfig.engine.RConfigEngine.execute(RConfigEngine.java:66)
            at oracle.sysman.assistants.rconfig.RConfig.<init>(RConfig.java:97)
            at oracle.sysman.assistants.rconfig.RConfig.<init>(RConfig.java:62)
            at oracle.sysman.assistants.rconfig.RConfig.main(RConfig.java:145)
            [main] [ 2010-12-30 18:40:33.088 IST ] [RACConvertStep.execute:215] Returning result:Got Exception
            [main] [ 2010-12-30 18:40:33.089 IST ] [RConfigEngine.execute:68] bAsyncJob=false
            [main] [ 2010-12-30 18:40:33.091 IST ] [RConfigEngine.execute:77] Result=<?xml version="1.0" ?>
            <RConfig version="1.1" >
            <ConvertToRAC>
            <Convert>
            <Response>
            <Result code="1" >
            Got Exception
            </Result>
            <ErrorDetails>
            ORA-01034: ORACLE not available

            Operation Failed. Refer logs at /d01/oracle/app/oracle/cfgtoollogs/rconfig/rconfig_12_30_10_18_40_30.log for more details.

            </ErrorDetails>
            </Response>

            Thanks
            • 3. Re: R12 RAC Doubt
              user5076678

              Hi

               

              Did You notice?:

               

              [Thread-19] [ 2010-12-30 18:40:32.897 IST ] [Instance$RConfigErrorListener.gotError:435] Got error

              [Thread-19] [ 2010-12-30 18:40:32.897 IST ] [Instance$RConfigErrorListener.handleNonIgnorableError:450] Number of ERRORS:1

              [Thread-19] [ 2010-12-30 18:40:32.898 IST ] [Instance$RConfigErrorListener.handleNonIgnorableError:453] ERROR=ORA-01034: ORACLE not available

               

              I had the same situation.

              Did You check Your SI database "PROD" and proper rconfig configuration file?

              In my case it was a not proper db name set.

               

              Good luck!

               

              Andreas