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

The Geek Diary

  • OS
    • Linux
    • CentOS/RHEL
    • Solaris
    • Oracle Linux
    • VCS
  • Interview Questions
  • Database
    • oracle
    • oracle 12c
    • ASM
    • mysql
    • MariaDB
  • DevOps
    • Docker
    • Shell Scripting
  • 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. What users and roles are created during Oracle SQLT installation
  2. How to check the status of OMS and Agent in OEM 13cR2
  3. New Background Processes In Oracle Database 12c
  4. How to change the SCAN IP address (SCAN VIP resources) in 11gR2 Grid (CRS) environment
  5. How To Change A Dictionary Managed Tablespace To A Locally Managed Tablespace
  6. 12c ASM: PRCR-1001 : Resource ora.proxy_advm Does Not Exist (Flex ASM with Cardinality = ALL)
  7. How to Configure client connectivity in Oracle Data Guard configuration (Implement failover procedures)
  8. ORA-01506: missing or illegal database name
  9. How long does Oracle retain the statistics for
  10. How to Use DBMS_METADATA To Get The DDL For Objects

You May Also Like

Primary Sidebar

Recent Posts

  • “aws s3 mv” Command Examples
  • “aws s3 mb” Command Examples
  • “aws s3 ls” Command Examples
  • “aws s3 cp” Command Examples

© 2023 · The Geek Diary

  • Archives
  • Contact Us
  • Copyright