Re: Connot Convert Single Instance to RAC rconfig
Date: Wed, 4 May 2016 05:05:18 -0500
Message-ID: <CAFH+ifc1ok7LqmC8k7Crc1ftfiQRP+kPjOWw6Du86VvhR-FPcw_at_mail.gmail.com>
oraInventory was updated with runInstaller when I did this for the first time (for this instance) last week as part of making sure the database was ready to go. Unfortunately I had the same issue last week. I've been running rconfig in "ONLY" mode, but tried it as "YES" and even through OEM last night without success. As I mentioned, I have some time pressure on this. I can only get the system for about an hour, maybe or two if I apply well in advance. Ran out of time last night. I'll put in an SR, but it looks like I may end up recreating the whole thing. I've done this with numerous other databases and never run into this problem. I'd like to figure out what the problem is since whatever is happening may have other implications.
On Wed, May 4, 2016 at 3:27 AM, Stojan Veselinovski < stojan.veselinovski_at_gmail.com> wrote:
> How was the Oracle Home installed? You may need to update the inventory
> with runInstaller updateNodeList or attachHome ... or something along those
> lines.
>
> Stojan.
>
> On Wed, May 4, 2016 at 1:14 PM Chitale, Hemant K <Hemant-K.Chitale_at_sc.com>
> wrote:
>
>> Is the oratab file updated with the new ORACLE_HOME ?
>>
>>
>>
>> Hemant K Chitale
>>
>>
>>
>>
>>
>> *From:* oracle-l-bounce_at_freelists.org [mailto:
>> oracle-l-bounce_at_freelists.org] *On Behalf Of *David Barbour
>> *Sent:* Wednesday, May 04, 2016 6:22 AM
>> *To:* oracle-l mailing list
>> *Subject:* Connot Convert Single Instance to RAC rconfig
>>
>>
>>
>> Sort of have some time pressure here and am running into an issue with
>> rconfig.
>>
>>
>>
>> I've set up the .xml file and am running it with <n:Convert
>> verify="ONLY">. It comes back with:
>>
>>
>>
>> Oracle home is not a cluster database home. Make sure that oracle binary
>> is linked with RAC option and the Oracle home entry in Oracle inventory is
>> updated with cluster node list.
>>
>>
>>
>> Okay - the Oracle binary appears to be properly linked: The banner shows:
>>
>>
>>
>> Connected to:
>>
>> Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit
>> Production
>>
>> With the Partitioning, Real Application Clusters and Automatic Storage
>> Management options
>>
>>
>>
>> and v$option shows:
>>
>>
>>
>> PARAMETER VALUE
>>
>> ----------------------------------------------------------------
>> ----------------------------------------------------------------
>>
>> Partitioning TRUE
>>
>> Objects TRUE
>>
>> Real Application Clusters TRUE
>>
>>
>>
>> and testing the binary results in:
>>
>>
>>
>> oracle_at_rchr2t01 D30 $ ar -t $ORACLE_HOME/rdbms/lib/libknlopt.a|grep
>> kcsm.o
>>
>> kcsm.o
>>
>>
>>
>> But when I run rconfig the log shows:
>>
>>
>>
>> main] [ 2016-05-03 16:41:37.992 CDT ]
>> [OracleHome.isDatabaseOptionOn:1136] Checking Database Option: Real
>> Application Clusters
>>
>> [main] [ 2016-05-03 16:41:37.993 CDT ]
>> [OracleHome.isDatabaseOptionOn:1193] Database Option Real Application
>> Clusters is false
>>
>> [main] [ 2016-05-03 16:41:37.993 CDT ] [OracleHome.isRacEnabled:205]
>> bRacOn = false
>>
>> [main] [ 2016-05-03 16:41:37.995 CDT ] [RACConvertStep.execute:193] STEP
>> Result=Oracle home is not a cluster database home. Make sure that oracle
>> binary is linked with RAC option and the Oracle home entry in Oracle
>> inventory is updated with cluster node list.
>>
>>
>>
>>
>>
>> I'm going to go through relinking this puppy again, but does anyone have
>> any idea where this information is coming from? I haven't seen this
>> before.
>>
>>
>>
>> The database was upgraded to 11.2.0.4 several weeks ago. This actually
>> changed the ORACLE_HOME. But the correct ORACLE_HOME is reflected in the
>> oraInventory and validated with opatch lsinventory. Before the finding RAC
>> is not an option, the log does have a series of entries:
>>
>> [main] [ 2016-05-03 16:41:29.476 CDT ] [OracleHome.initOptions:1253]
>> executing: startup nomount
>> pfile='/oracle/D30/11204/dbs/initDBUA4129413.ora'
>>
>> [main] [ 2016-05-03 16:41:37.874 CDT ] [SQLEngine.done:2189] Done called
>>
>> [main] [ 2016-05-03 16:41:37.875 CDT ] [OracleHome.initOptions:1262]
>> ORA-27102: out of memory
>>
>> [main] [ 2016-05-03 16:41:37.912 CDT ] [OracleHome.initOptions:1291]
>> ORA-01034: ORACLE not available
>>
>> But then it shuts down the 'dummy' instance and starts over and seems to
>> be doing just fine until ....................
>>
>>
>>
>> [main] [ 2016-05-03 16:41:37.913 CDT ] [OracleHome.initOptions:1300]
>> shutting down dummy instance
>>
>> [main] [ 2016-05-03 16:41:37.913 CDT ] [SQLEngine.reInitialize:738]
>> Reinitializing SQLEngine...
>>
>> [main] [ 2016-05-03 16:41:37.913 CDT ] [OracleHome.getVersion:892]
>> OracleHome.getVersion called. Current Version: 11.2.0.4.0
>>
>> [main] [ 2016-05-03 16:41:37.914 CDT ] [OracleHome.getVersion:960]
>> Current Version From Inventory: 11.2.0.4.0
>>
>> [main] [ 2016-05-03 16:41:37.914 CDT ] [OracleHome.getVersion:892]
>> OracleHome.getVersion called. Current Version: 11.2.0.4.0
>>
>> [main] [ 2016-05-03 16:41:37.914 CDT ] [OracleHome.getVersion:960]
>> Current Version From Inventory: 11.2.0.4.0
>>
>> [main] [ 2016-05-03 16:41:37.914 CDT ] [OracleHome.getVersion:892]
>> OracleHome.getVersion called. Current Version: 11.2.0.4.0
>>
>> [main] [ 2016-05-03 16:41:37.915 CDT ] [OracleHome.getVersion:960]
>> Current Version From Inventory: 11.2.0.4.0
>>
>> [main] [ 2016-05-03 16:41:37.915 CDT ] [SQLPlusEngine.getCmmdParams:222]
>> m_home 11.2.0.4.0
>>
>> [main] [ 2016-05-03 16:41:37.915 CDT ] [SQLPlusEngine.getCmmdParams:223]
>> version > 112 true
>>
>> [main] [ 2016-05-03 16:41:37.916 CDT ] [SQLEngine.getEnvParams:555]
>> Default NLS_LANG: AMERICAN_AMERICA.AL32UTF8
>>
>> [main] [ 2016-05-03 16:41:37.916 CDT ] [SQLEngine.getEnvParams:565]
>> NLS_LANG: AMERICAN_AMERICA.AL32UTF8
>>
>> [main] [ 2016-05-03 16:41:37.917 CDT ] [SQLEngine.initialize:325]
>> Execing SQLPLUS/SVRMGR process...
>>
>> [main] [ 2016-05-03 16:41:37.921 CDT ] [SQLEngine.initialize:362]
>> m_bReaderStarted: false
>>
>> [main] [ 2016-05-03 16:41:37.921 CDT ] [SQLEngine.initialize:366]
>> Starting Reader Thread...
>>
>> [main] [ 2016-05-03 16:41:37.922 CDT ] [SQLEngine.initialize:415]
>> Waiting for m_bReaderStarted to be true
>>
>> [main] [ 2016-05-03 16:41:37.951 CDT ] [SQLEngine.done:2189] Done called
>>
>> [main] [ 2016-05-03 16:41:37.951 CDT ] [OracleHome.initOptions:1332]
>> Database Options queried: 0
>>
>> [main] [ 2016-05-03 16:41:37.952 CDT ] [OracleHome.getNodeNames:327]
>> inside getNodeNames, inventory loc null
>>
>> [main] [ 2016-05-03 16:41:37.992 CDT ]
>> [InventoryUtil.getOUIInvSession:347] setting OUI READ level to
>> ACCESSLEVEL_READ_LOCKLESS
>>
>> [main] [ 2016-05-03 16:41:37.992 CDT ]
>> [OracleHome.isClusterInstalled:309] bClusterInstalled=true
>>
>> [main] [ 2016-05-03 16:41:37.992 CDT ]
>> [OracleHome.isDatabaseOptionOn:1136] Checking Database Option: Real
>> Application Clusters
>>
>> [main] [ 2016-05-03 16:41:37.993 CDT ]
>> [OracleHome.isDatabaseOptionOn:1193] Database Option Real Application
>> Clusters is false
>>
>>
>>
>> This email and any attachments are confidential and may also be
>> privileged. If you are not the intended recipient, please delete all copies
>> and notify the sender immediately. You may wish to refer to the
>> incorporation details of Standard Chartered PLC, Standard Chartered Bank
>> and their subsidiaries at
>> https://www.sc.com/en/incorporation-details.html
>>
>
-- http://www.freelists.org/webpage/oracle-lReceived on Wed May 04 2016 - 12:05:18 CEST