If using pfile, it must be a filesystem 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 DB instances before 11.2)
Trying to put ASM spfile on a shared device.
Solution
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
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>]
-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.
From Oracle
-------------------------------------------------------------------------------------------------------
Blog: http://blog.csdn.net/tianlesoftware
Email: dvd.dba@gmail.com
DBA1 群:62697716(满); DBA2 群:62697977(满) DBA3 群:62697850(满)
DBA 超级群:63306533(满); DBA4 群: 83829929 DBA5群: 142216823
聊天 群:40132017 聊天2群:69087192
--加群需要在备注说明Oracle表空间和数据文件的关系,否则拒绝申请
分享到:
相关推荐
本次安装为AIX6.1平台上使用ORACLE GRID+ASM方式安装ORACLE11gR2 RAC,升级至目前最新补丁11.2.0.3并且创建数据库。本文档主要记录软件安装、数据库创建、补丁升级、数据库实例参数配置的情况。
Oracle RAC增加ASM盘,创建表空间
oracle10g rac asm for linux oracle10g rac asm for linux
Aix6.1 + ASM + ORACLE10GR2 RAC实施手册 ,Aix6.1 + ASM + ORACLE10GR2 RAC实施手册
RHEL 7环境下19c RAC安装之udev规则配置ASM共享存储 RHEL 7环境下19c RAC安装之udev规则配置ASM共享存储 RHEL 7环境下19c RAC安装之udev规则配置ASM共享存储
oracle_rac 环境搭建所需的asm包
Oracle rac+asm 原库备份与恢复
Redhat AS4 Oracle10g+ASM单实例转RAC
Oracle RAC安装和配置及ASM最佳实践
Windows Server 2008 R2 X64环境下搭建双网络Oracle 12C R1 RAC+ASM
Moving your SAP database to Oracle 11gR2 ASM A “Best Practices” Guide
VM虚拟机创建RAC全程实例,如何创建虚拟机环境,以及搭建,用于windows操作系统的!
asm数据库安装补丁,用于RAC集群搭建,linux版本5.8实际安装通过,共6个文件
Windows Server 2012 R2 X64环境下搭建Oracle 11G R2 RAC+ASM,文档目录清晰,需要的拿去。
oracle11g+asm+rac安装指南
RAC与ASM最佳实践,介绍了如何实施基于ASM的RAC项目。 包括ASM,RAC调优等
RHEL4 + oracle database 10g RAC(ASM) 安装参考文档
ISCSI+ASM+RAC实施文档,帮助你更好的学习rac
Oracle10g RAC ASM 环境日常管理命令
oracle 11g rac and asm Installation instructions,If you have any questions, please contact :Email:634598660@qq.com