~]$ crsctl stat res -t -------------------------------------------------------------------------------- NAME TARGET STATE SERVER STATE_DETAILS -------------------------------------------------------------------------------- Local Resources -------------------------------------------------------------------------------- ora.DATA.dg ONLINE ONLINE oracle11gasm01 ora.LISTENER.lsnr ONLINE ONLINE oracle11gasm01 ora.OCR.dg ONLINE ONLINE oracle11gasm01 ora.asm ONLINE ONLINE oracle11gasm01 Started ora.ons OFFLINE OFFLINE oracle11gasm01 -------------------------------------------------------------------------------- Cluster Resources -------------------------------------------------------------------------------- ora.cssd 1 ONLINE ONLINE oracle11gasm01 ora.diskmon 1 OFFLINE OFFLINE ora.evmd 1 ONLINE ONLINE oracle11gasm01 ora.orcl.db 1 ONLINE ONLINE oracle11gasm01 Open
~]$ srvctl stop database -d orcl
~]$ crsctl stop has CRS-2791: Starting shutdown of Oracle High Availability Services-managed resources on 'oracle11gasm01' CRS-2673: Attempting to stop 'ora.OCR.dg' on 'oracle11gasm01' CRS-2673: Attempting to stop 'ora.DATA.dg' on 'oracle11gasm01' CRS-2673: Attempting to stop 'ora.LISTENER.lsnr' on 'oracle11gasm01' CRS-2677: Stop of 'ora.DATA.dg' on 'oracle11gasm01' succeeded CRS-2677: Stop of 'ora.LISTENER.lsnr' on 'oracle11gasm01' succeeded CRS-2677: Stop of 'ora.OCR.dg' on 'oracle11gasm01' succeeded CRS-2679: Attempting to clean 'ora.OCR.dg' on 'oracle11gasm01' CRS-2681: Clean of 'ora.OCR.dg' on 'oracle11gasm01' succeeded CRS-2673: Attempting to stop 'ora.asm' on 'oracle11gasm01' CRS-2677: Stop of 'ora.asm' on 'oracle11gasm01' succeeded CRS-2673: Attempting to stop 'ora.cssd' on 'oracle11gasm01' CRS-2677: Stop of 'ora.cssd' on 'oracle11gasm01' succeeded CRS-2673: Attempting to stop 'ora.evmd' on 'oracle11gasm01' CRS-2677: Stop of 'ora.evmd' on 'oracle11gasm01' succeeded CRS-2793: Shutdown of Oracle High Availability Services-managed resources on 'oracle11gasm01' has completed CRS-4133: Oracle High Availability Services has been stopped.
~]# /u01/app/11.2.0/grid/crs/install/roothas.pl -deconfig -force -verbose Using configuration parameter file: /u01/app/11.2.0/grid/crs/install/crsconfig_params CRS-4639: Could not contact Oracle High Availability Services CRS-4000: Command Stop failed, or completed with errors. CRS-4639: Could not contact Oracle High Availability Services CRS-4000: Command Delete failed, or completed with errors. CRS-4544: Unable to connect to OHAS CRS-4000: Command Stop failed, or completed with errors. Successfully deconfigured Oracle Restart stack
Checking swap space: must be greater than 500 MB. Actual 3929 MB Passed The inventory pointer is located at /etc/oraInst.loc The inventory is located at /u01/app/oraInventory 'DetachHome' was successful.
~]$ cat > ConvertToRAC_AdminManaged.xml << 'EOF' <?xml version="1.0" encoding="UTF-8"?> <n:RConfig xmlns:n="http://www.oracle.com/rconfig" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://www.oracle.com/rconfig rconfig.xsd"> <n:ConvertToRAC> <!-- Verify does a precheck to ensure all pre-requisites are met, before the conversion is attempted. Allowable values are: YES|NO|ONLY --> <n:Convert verify="ONLY"> <!--Specify current OracleHome of non-rac database for SourceDBHome --> <n:SourceDBHome>/u01/app/oracle/product/11.2.0/db_1</n:SourceDBHome> <!--Specify OracleHome where the rac database should be configured. It can be same as SourceDBHome --> <n:TargetDBHome>/u01/app/oracle/product/11.2.0/dbhome_1</n:TargetDBHome> <!--Specify SID of non-rac database and credential. User with sysdba role is required to perform conversion --> <n:SourceDBInfo SID="orcl"> <n:Credentials> <n:User>sys</n:User> <n:Password>oracle</n:Password> <n:Role>sysdba</n:Role> </n:Credentials> </n:SourceDBInfo> <!--Specify the list of nodes that should have rac instances running for the Admin Managed Cluster Database. LocalNode should be the first node in this nodelist. --> <n:NodeList> <n:Node name="oracle11gasm01"/> <n:Node name="oracle11gasm02"/> </n:NodeList> <!--Specify RacOneNode along with servicename to convert database to RACOne Node --> <!--n:RacOneNode servicename="orcl"/--> <!--Instance Prefix tag is optional starting with 11.2. If left empty, it is derived from db_unique_name.--> <n:InstancePrefix>orcl</n:InstancePrefix> <!-- Listener details are no longer needed starting 11.2. Database is registered with default listener and SCAN listener running from Oracle Grid Infrastructure home. --> <!--Specify the type of storage to be used by rac database. Allowable values are CFS|ASM. The non-rac database should have same storage type. ASM credentials are no needed for conversion. --> <n:SharedStorage type="ASM"> <!--Specify Database Area Location to be configured for rac database.If this field is left empty, current storage will be used for rac database. For CFS, this field will have directory path. --> <n:TargetDatabaseArea>+DATA</n:TargetDatabaseArea> <!--Specify Fast Recovery Area to be configured for rac database. If this field is left empty, current recovery area of non-rac database will be configured for rac database. If current database is not using recovery Area, the resulting rac database will not have a recovery area. --> <n:TargetFlashRecoveryArea>+DATA</n:TargetFlashRecoveryArea> </n:SharedStorage> </n:Convert> </n:ConvertToRAC> </n:RConfig> EOF
~]$ $ORACLE_HOME/bin/rconfig ConvertToRAC_AdminManaged.xml <?xml version="1.0" ?> <RConfig version="1.1" > <ConvertToRAC> <Convert> <Response> <Result code="0" > Operation Succeeded </Result> </Response> <ReturnValue type="object"> There is no return value for this step </ReturnValue> </Convert> </ConvertToRAC></RConfig>
~]$ sed -i 's/"ONLY"/"YES"/' ConvertToRAC_AdminManaged.xml
[FATAL] [INS-35354] The system on which you are attempting to install Oracle RAC is not part of a valid cluster.
CAUSE: Before you can install Oracle RAC, you must install Oracle Grid Infrastructure on all servers (Oracle Clusterware and Oracle ASM) to create a cluster.
ACTION: Oracle Grid Infrastructure is not installed. Install it either from the separate installation media included in your media pack, or install it by downloading it from Electronic Product Delivery (EPD) or the Oracle Technology Network (OTN). Oracle Grid Infrastructure normally is installed by a different operating system user than the one used for Oracle Database. It may need to be installed by your system administrator. See the installation guide for more details.
CAUSE:
From the inventory.xml, we see that the HOME NAME line is missing the CRS="true" flag.
