Oracle Rac to Rac One Node

=~=~=~=~=~=~=~=~=~=~=~= PuTTY log 2020.01.14 20:05:12 =~=~=~=~=~=~=~=~=~=~=~=

[oracle@rac01 ~]$ srvctl status database -d racdb
Instance racdb1 is running on node rac01
Instance racdb2 is running on node rac02
[oracle@rac01 ~]$ srvctl config database -d racdb
Database unique name: racdb
Database name: racdb
Oracle home: /oracle/home
Oracle user: oracle
Spfile: +DGDATA/racdb/spfileracdb.ora
Domain: 
Start options: open
Stop options: immediate
Database role: PRIMARY
Management policy: AUTOMATIC
Server pools: racdb
Database instances: racdb1,racdb2
Disk Groups: DGDATA
Mount point paths: 
Services: 
Type: RAC
Database is administrator managed
[oracle@rac01 ~]$ srvctl config service -d racdb
[oracle@rac01 ~]$ srvctl stop database -d racdb
[oracle@rac01 ~]$ srvctl status database -d racdb
Instance racdb1 is not running on node rac01
Instance racdb2 is not running on node rac02
[oracle@rac01 ~]$ srvctl remove instance -d racdb -i racdb2
Remove instance from the database racdb? (y/[n]) y
[oracle@rac01 ~]$ srvctl add service -d racdb -s rac -r racdb1 -P BASIC -e SELECT -m BASIC -y AUTOMATIC
[oracle@rac01 ~]$ srvctl config service -d racdb
Service name: rac
Service is enabled
Server pool: racdb_rac
Cardinality: 1
Disconnect: false
Service role: PRIMARY
Management policy: AUTOMATIC
DTP transaction: false
AQ HA notifications: false
Failover type: SELECT
Failover method: BASIC
TAF failover retries: 0
TAF failover delay: 0
Connection Load Balancing Goal: LONG
Runtime Load Balancing Goal: NONE
TAF policy specification: BASIC
Edition: 
Preferred instances: racdb1
Available instances: 
[oracle@rac01 ~]$ srvctl start service -d racdb -s rac
[oracle@rac01 ~]$ srvctl status database -d racdb
Instance racdb1 is running on node rac01
[oracle@rac01 ~]$ srvctl convert database -d racdb -c RACONENODE -i racdb1
[oracle@rac01 ~]$ srvctl config database -d racdb
Database unique name: racdb
Database name: racdb
Oracle home: /oracle/home
Oracle user: oracle
Spfile: +DGDATA/racdb/spfileracdb.ora
Domain: 
Start options: open
Stop options: immediate
Database role: PRIMARY
Management policy: AUTOMATIC
Server pools: racdb
Database instances: 
Disk Groups: DGDATA
Mount point paths: 
Services: rac
Type: RACOneNode
Online relocation timeout: 30
Instance name prefix: racdb1
Candidate servers: rac01
Database is administrator managed
[oracle@rac01 ~]$ srvctl config service -d racdb
Service name: rac
Service is enabled
Server pool: racdb
Cardinality: 1
Disconnect: false
Service role: PRIMARY
Management policy: AUTOMATIC
DTP transaction: false
AQ HA notifications: false
Failover type: SELECT
Failover method: BASIC
TAF failover retries: 0
TAF failover delay: 0
Connection Load Balancing Goal: LONG
Runtime Load Balancing Goal: NONE
TAF policy specification: BASIC
Edition: 
Preferred instances: racdb1_1
Available instances: 
[oracle@rac01 ~]$ ps -ef|grep smon
root      2512     1  1 Jan12 ?        00:33:13 /grid/home/bin/osysmond.bin
grid      2960     1  0 Jan12 ?        00:00:04 asm_smon_+ASM1
oracle   29723     1  0 17:19 ?        00:00:00 ora_smon_racdb1
oracle   30301 28630  0 17:21 pts/0    00:00:00 grep smon
[oracle@rac01 ~]$ srvctl stop database -d racdb
[oracle@rac01 ~]$ srvctl start database -d racdb
[oracle@rac01 ~]$ ps -ef|grep smon
root      2512     1  1 Jan12 ?        00:33:14 /grid/home/bin/osysmond.bin
grid      2960     1  0 Jan12 ?        00:00:04 asm_smon_+ASM1
oracle   30591     1  0 17:21 ?        00:00:00 ora_smon_racdb1_1
oracle   30724 28630  0 17:22 pts/0    00:00:00 grep smon
[oracle@rac01 ~]$ srvctl relocate database -d racdb -n rac02
[oracle@rac01 ~]$ crsctl stat res -t
-bash: crsctl: command not found
[oracle@rac01 ~]$ su - grid
Password:                                       
[grid@rac01 ~]$ crs_stat -t
Name           Type           Target    State     Host        
------------------------------------------------------------
ora.DGDATA.dg  ora....up.type ONLINE    ONLINE    rac01       
ora....ER.lsnr ora....er.type ONLINE    ONLINE    rac01       
ora....N1.lsnr ora....er.type ONLINE    ONLINE    rac02       
ora.OGOCR.dg   ora....up.type ONLINE    ONLINE    rac01       
ora.asm        ora.asm.type   ONLINE    ONLINE    rac01       
ora.cvu        ora.cvu.type   ONLINE    ONLINE    rac02       
ora.gsd        ora.gsd.type   OFFLINE   OFFLINE               
ora....network ora....rk.type ONLINE    ONLINE    rac01       
ora.oc4j       ora.oc4j.type  ONLINE    ONLINE    rac02       
ora.ons        ora.ons.type   ONLINE    ONLINE    rac01       
ora....SM1.asm application    ONLINE    ONLINE    rac01       
ora....01.lsnr application    ONLINE    ONLINE    rac01       
ora.rac01.gsd  application    OFFLINE   OFFLINE               
ora.rac01.ons  application    ONLINE    ONLINE    rac01       
ora.rac01.vip  ora....t1.type ONLINE    ONLINE    rac01       
ora....SM2.asm application    ONLINE    ONLINE    rac02       
ora....02.lsnr application    ONLINE    ONLINE    rac02       
ora.rac02.gsd  application    OFFLINE   OFFLINE               
ora.rac02.ons  application    ONLINE    ONLINE    rac02       
ora.rac02.vip  ora....t1.type ONLINE    ONLINE    rac02       
ora.racdb.db   ora....se.type ONLINE    ONLINE    rac02       
ora....rac.svc ora....ce.type ONLINE    ONLINE    rac02       
ora....ry.acfs ora....fs.type ONLINE    ONLINE    rac01       
ora.scan1.vip  ora....ip.type ONLINE    ONLINE    rac02       
[grid@rac01 ~]$ srvctl relocate database -d racdb -n rac01
PRCD-1222 : Online relocation of database "racdb" failed but database was restored to its original state
PRCR-1037 : Failed to update cardinality of the resource ora.racdb.db to 2
PRCR-1071 : Failed to register or update resource ora.racdb.db
CRS-0245:  User doesn't have enough privilege to perform the operation
[grid@rac01 ~]$ exit
logout
[oracle@rac01 ~]$ srvctl relocate database -d racdb -n rac01
[oracle@rac01 ~]$ su - grid
Password: 
[grid@rac01 ~]$ crs_stat -t
Name           Type           Target    State     Host        
------------------------------------------------------------
ora.DGDATA.dg  ora....up.type ONLINE    ONLINE    rac01       
ora....ER.lsnr ora....er.type ONLINE    ONLINE    rac01       
ora....N1.lsnr ora....er.type ONLINE    ONLINE    rac02       
ora.OGOCR.dg   ora....up.type ONLINE    ONLINE    rac01       
ora.asm        ora.asm.type   ONLINE    ONLINE    rac01       
ora.cvu        ora.cvu.type   ONLINE    ONLINE    rac02       
ora.gsd        ora.gsd.type   OFFLINE   OFFLINE               
ora....network ora....rk.type ONLINE    ONLINE    rac01       
ora.oc4j       ora.oc4j.type  ONLINE    ONLINE    rac02       
ora.ons        ora.ons.type   ONLINE    ONLINE    rac01       
ora....SM1.asm application    ONLINE    ONLINE    rac01       
ora....01.lsnr application    ONLINE    ONLINE    rac01       
ora.rac01.gsd  application    OFFLINE   OFFLINE               
ora.rac01.ons  application    ONLINE    ONLINE    rac01       
ora.rac01.vip  ora....t1.type ONLINE    ONLINE    rac01       
ora....SM2.asm application    ONLINE    ONLINE    rac02       
ora....02.lsnr application    ONLINE    ONLINE    rac02       
ora.rac02.gsd  application    OFFLINE   OFFLINE               
ora.rac02.ons  application    ONLINE    ONLINE    rac02       
ora.rac02.vip  ora....t1.type ONLINE    ONLINE    rac02       
ora.racdb.db   ora....se.type ONLINE    ONLINE    rac01       
ora....rac.svc ora....ce.type ONLINE    ONLINE    rac01       
ora....ry.acfs ora....fs.type ONLINE    ONLINE    rac01       
ora.scan1.vip  ora....ip.type ONLINE    ONLINE    rac02       
[grid@rac01 ~]$ exit
logout
[oracle@rac01 ~]$ exit
logout