Monday, January 1, 2024

RACOneNode relocate fails with PRKO-2148 Option'-node' must be supplied when running 'srvctl relocate database'

1. RACOneNode database Instance one is running on node1

[oracle@node2 ~]$ srvctl status database -d RAC1N
Instance RAC1N_1 is running on node node1
Online relocation: INACTIVE
[oracle@node2 ~]$

2. Config properties of RACOneNode database in 2 node clusters

[oracle@node2 ~]$ srvctl config database -d RAC1N
Database unique name: RAC1N
Database name:
Oracle home: /u01/app/oracle/product/12.2.0.1/dbhome_1
Oracle user: oracle
Spfile: +DATA/RAC1N/PARAMETERFILE/spfile.318.1067549521
Password file: +DATA/RAC1N/PASSWORD/pwdrac1n.286.1067549269
Domain:
Start options: open
Stop options: immediate
Database role: PRIMARY
Management policy: AUTOMATIC
Server pools:
Disk Groups: DATA,RECO
Mount point paths:
Services:
Type: RACOneNode
Online relocation timeout: 30
Instance name prefix: RAC1N
Candidate servers: node1,node2
OSDBA group: oinstall
OSOPER group: oinstall
Database instances: RAC1N_1
CSS critical: no
CPU count: 0
Memory target: 0
Maximum memory: 0
Default network number for database services:
Database is administrator managed
[oracle@node2 ~]$

[oracle@node1 ~]$ . oraenv
ORACLE_SID = [RAC1N_2] ? +ASM1
The Oracle base remains unchanged with value /u01/app/oracle
[oracle@node1 ~]$
[oracle@node1 ~]$ olsnodes
node1
node2
[oracle@node1 ~]$

3. Trying to relocate Instance 1 from node1 to node2 which will fails 

[oracle@node1 ~]$ srvctl relocate database -d RAC1N
PRKO-2148 : Option '-node' must be supplied when running 'srvctl relocate database' for administrator-managed RAC One Node database
[oracle@node1 ~]$

After using -node or -n oprion I am able to reloacte Instance 1 to node2
Now the Instacne 2 is running on node2 after relocate

[oracle@node1 ~]$ srvctl relocate database -d RAC1N -n node2
[oracle@node1 ~]$ srvctl status database -d RAC1N
Instance RAC1N_2 is running on node node2
Online relocation: INACTIVE
[oracle@node1 ~]$

[oracle@node1 ~]$ srvctl config database -d RAC1N
Database unique name: RAC1N
Database name:
Oracle home: /u01/app/oracle/product/12.2.0.1/dbhome_1
Oracle user: oracle
Spfile: +DATA/RAC1N/PARAMETERFILE/spfile.318.1067549521
Password file: +DATA/RAC1N/PASSWORD/pwdrac1n.286.1067549269
Domain:
Start options: open
Stop options: immediate
Database role: PRIMARY
Management policy: AUTOMATIC
Server pools:
Disk Groups: DATA,RECO
Mount point paths:
Services:
Type: RACOneNode
Online relocation timeout: 30
Instance name prefix: RAC1N
Candidate servers: node1,node2
OSDBA group: oinstall
OSOPER group: oinstall
Database instances: RAC1N_2
CSS critical: no
CPU count: 0
Memory target: 0
Maximum memory: 0
Default network number for database services:
Database is administrator managed
[oracle@node1 ~]$

Regards,
Mallik

No comments:

Post a Comment

Automation Script | Archivelog Generation Hourly Monitoring

1. List out all the running databases and pic one database where we want to monitore the archive log generation from last 1 month. [oracle@o...