• Skip to primary navigation
  • Skip to main content
  • Skip to primary sidebar

The Geek Diary

CONCEPTS | BASICS | HOWTO

  • OS
    • Linux
    • CentOS/RHEL
    • Solaris
    • Oracle Linux
    • Linux Services
    • VCS
  • Database
    • oracle
    • oracle 12c
    • ASM
    • mysql
    • MariaDB
    • Data Guard
  • DevOps
    • Docker
    • Shell Scripting
  • Interview Questions
  • Big Data
    • Hadoop
    • Cloudera
    • Hortonworks HDP

How to move ASM spfile to a shared device in RAC

By admin

If you are using pfile, it must be a text file on local filesystem. If using spfile, then it can be in the following locations.

  • a filesystem file spfile on local filesystem
  • spfile on shared device
  • a ASM file in a ASM diskgroup (only for spfile for instances after 11.2)

Here are steps to put ASM spfile on a shared device.

1. Edit the pfile and make sure all the parameters could be used for all instances.

2. Login to ASM with sqlplus and startup nomount with pfile.

3. Run the following commands to create a new spfile from pfile. Shutdown the database after creating the spfile.

SQL> create spfile=[shared_device] from pfile;
SQL> Shutdown immediate

4. Backup the pfile to a new filename.

5. Modify the pfile to have only the following entry.

spfile=[shared_device]

6. Do step 4 and 5 on remote nodes.

7. Startup the instances on all nodes with sqlplus to see if it works.

8. If all works, update the OCR ASM registry to have the new spfile location with srvctl command.

Usage: srvctl modify asm -n [node_name] -i [asm_inst_name] [-o oracle_home] [-p spfile]

Here,
-n [node] Node name
-i [asm_inst_name] ASM instance name
-o [oracle_home] ORACLE_HOME path
-p [spfile] Server parameter file path

9. Repeat step 8 for all nodes.

10. Test instance startup with srvctl on all nodes.

Filed Under: ASM, oracle, RAC

Some more articles you might also be interested in …

  1. How to delete archives from only 1 archive destination when 2 or more are in use
  2. How to startup an Oracle Database Instance using spfile or pfile(init.ora) parameter file
  3. Oracle 12.2 : RMAN Cross-Platform Transport of PDB into Destination CDB
  4. Oracle database : Basics about pfile and spfile
  5. How to Create Undo Tablespace for a Newly Added RAC Instance (ORA-30012)
  6. How to Recover DROPPED PDB After Flashback of CDB
  7. Oracle Automatic Storage Management (ASM) concepts
  8. Automatic Stop of Oracle Database (dbshut) not working in CentOS/RHEL 7 with systemd
  9. Where to find ASMLib / oracleasm RPMs for CentOS/RHEL, SUSE, OEL
  10. How to Disable os-prober in CentOS/RHEL 7

You May Also Like

Primary Sidebar

Recent Posts

  • How to Disable IPv6 on Ubuntu 18.04 Bionic Beaver Linux
  • How to Capture More Logs in /var/log/dmesg for CentOS/RHEL
  • Unable to Start RDMA Services on CentOS/RHEL 7
  • How to rename a KVM VM with virsh
  • Archives
  • Contact Us
  • Copyright

© 2021 · The Geek Diary