Announcements

Oracle training based on real-time expertise as per industry standards. Upcoming batch details are here.

View batch schedule

Free Oracle mock interview. Register using the link.

Register

#DBAchallenge: submit your questions.

Ask questions
Swipe for more →
Browse by Topic
Latest Posts

    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

    🌟 Proud to be an Oracle ACE Pro! 🚀

    🌟 Proud to be an Oracle ACE Pro! 🚀 I’m excited to share my official Oracle ACE Profile with the Oracle community. 👨‍💻 Mallikarjun ...