Operational Procedure for ASM Instance
Startup Sequence
1. Start the ASM Instance
2. Start the ASM Enabled Database
3. Start the Listener for ASM Enabled Database
Source the Environment Variable ORACLE_HOME
Export ORACLE_SID=+ASM
Login as sys dba and issue STARTUP Command
$ sqlplus "/ as sysdba"
SQL*Plus: Release 10.2.0.1.0 - Production on Sat Mar 17 19:41:49 2007
Copyright (c) 1982, 2005, Oracle. All rights reserved.
Connected to an idle instance.
SQL> startup
ASM instance started
Total System Global Area 83886080 bytes
Fixed Size 1217836 bytes
Variable Size 57502420 bytes
ASM Cache 25165824 bytes
ASM diskgroups mounted
SQL>
Background Process:
$ ps -ef | grep -i asm
ora10g 4682 1 0 19:42 ? 00:00:00 asm_pmon_+ASM
ora10g 4684 1 0 19:42 ? 00:00:00 asm_psp0_+ASM
ora10g 4686 1 0 19:42 ? 00:00:00 asm_mman_+ASM
ora10g 4688 1 0 19:42 ? 00:00:00 asm_dbw0_+ASM
ora10g 4690 1 0 19:42 ? 00:00:00 asm_lgwr_+ASM
ora10g 4692 1 0 19:42 ? 00:00:00 asm_ckpt_+ASM
ora10g 4694 1 0 19:42 ? 00:00:00 asm_smon_+ASM
ora10g 4696 1 0 19:42 ? 00:00:00 asm_rbal_+ASM
ora10g 4698 1 0 19:42 ? 00:00:00 asm_gmon_+ASM
ora10g 4703 4651 0 19:50 pts/0 00:00:00 grep -i asm
$
Additional Processes:
RBAL - ReBalancer , its duty is to rebalance the activity for ASM Disk Groups
Starting the ASM Dependent Database
Export ORACLE_SID=ODB
Login as sys dba and issue STARTUP Command
$ export ORACLE_SID=ODB
$ sqlplus "/ as sysdba"
SQL*Plus: Release 10.2.0.1.0 - Production on Sat Mar 17 19:59:23 2007
Copyright (c) 1982, 2005, Oracle. All rights reserved.
Connected to an idle instance.
SQL> startup
ORACLE instance started.
Total System Global Area 167772160 bytes
Fixed Size 1218316 bytes
Variable Size 71305460 bytes
Database Buffers 92274688 bytes
Redo Buffers 2973696 bytes
Database mounted.
Database opened.
SQL>
Starting the Listener of the ASM Dependent Database
$ lsnrctl start ODB
Shutdown Operation is the reverse of the Startup
1. Stop the Listener
2. Stop the ASM Enabled Database
3. Stop the ASM Instance
Summary Startup and Shutdown of ASM Instances
ASM instance are started and stopped in a similar way to normal database instances.
The options for the STARTUP command are:
FORCE - Performs a SHUTDOWN ABORT before restarting the ASM instance.
MOUNT - Starts the ASM instance and mounts the disk groups specified by the ASM_DISKGROUPS parameter.
NOMOUNT - Starts the ASM instance without mounting any disk groups.
OPEN - This is not a valid option for an ASM instance.
The options for the SHUTDOWN command are:
NORMAL - The ASM instance waits for all connected ASM instances and SQL sessions to exit then shuts down.
IMMEDIATE - The ASM instance waits for any SQL transactions to complete then shuts down. It doesn't wait for sessions to exit.
TRANSACTIONAL - Same as IMMEDIATE.
ABORT - The ASM instance shuts down instantly.
The voice in my head may not be real , but they have some good ideas !!!
Fail Fast, Fail Forward, Fail Often, Fail Better , Standup Every Time
Every problem has at least one solution. Only some solutions are harder to find.
Friday, June 22, 2007
Popular Posts
-
FS_CLONE Phase It is a stand-alone command used for file system cloning. Standard cloning (using adcfgclone.pl) cannot be used to synch...
-
[oracle@testebsop3app01 ~]$ perl /u01/install/APPS/fs1/EBSapps/comn/clone/bin/adcfgclone.pl appltop /u01/install/APPS/fs1/inst/apps/SATURN_...
-
Abort Phase If for some reason either the prepare or apply phase failed or gave problems, you can abort the patching cycle. After runnin...
-
As a green field expert in data science, you would be responsible for designing and implementing data science projects from scratch. This i...
-
PRVG-2031 : Owner of file "/u01/app/oracle/diag/crs/rac01/crs/lck" did not match the expected value on node "HOST1". [Ex...
-
Suddenly all production reports in BI Publisher failed with message " ORA-01017: invalid username/password; logon denied" The da...
-
If you are an EBS administrator the first thing some asks you to do a health check of an environment , you return to him with a Request ID o...
-
EBS 12.2 ADOP Cycle Errors During Validation Cannot open XML file for load ADOP cycle will have validation errors in some cases. *****...
-
ADOP patching on a downtime mode with [ERROR] Patch service is not exist or running Please note , if you get ADOP issues on PROD ple...
-
Let me start telling a story , "Once upon a time there lived a great ♚EBS 12.2 instance , it was very kind to the DBAs and one fine day...