<<Back to Oracle ASM Main Page
How to Connect to an ASM Instance
set ORACLE_SID environment variable to the Oracle ASM system identifier (SID).
You can find ASM SID using ps command
$ps -ef|grep pmon |grep asm
oragrid 30609 1 0 Jun08 ? 00:00:21 asm_pmon_+ASM
export ORACLE_SID=+ASM
set ORACLE_HOME environment variable to the Grid Infrastructure home where Oracle ASM was installed
$ps -ef|grep crs
oragrid 5421 1 0 Jun05 ? 00:00:14 /u01/oragrid/12.2.0.1/grid/bin/tnslsnr LISTENER -no_crs_notify -inherit
$export ORACLE_HOME=/u01/oragrid/12.2.0.1/grid
$export PATH=$PATH:$ORACLE_HOME/bin
You can find ASM SID using ps command
$ps -ef|grep pmon |grep asm
oragrid 30609 1 0 Jun08 ? 00:00:21 asm_pmon_+ASM
export ORACLE_SID=+ASM
set ORACLE_HOME environment variable to the Grid Infrastructure home where Oracle ASM was installed
$ps -ef|grep crs
oragrid 5421 1 0 Jun05 ? 00:00:14 /u01/oragrid/12.2.0.1/grid/bin/tnslsnr LISTENER -no_crs_notify -inherit
$export ORACLE_HOME=/u01/oragrid/12.2.0.1/grid
$export PATH=$PATH:$ORACLE_HOME/bin
How to Start ASM Instance
logina s sysasm
$sqlplus "/as sysasm"
Startup
SQL>startup
Starting Up an Oracle ASM instance with an Incorrect SPFILE Path
locate the spfile
/u01/oragrid/spfile/spfileASM.ora
Create pfile from spfileSQL> create pfile='/u01/oragrid/spfile/ASM.ora' from spfile='/u01/oragrid/spfile/spfileASM.ora';
Startup ASM instance with PFILE
SQL> startup pfile='/u01/oragrid/spfile/ASM.ora'
Update the spfile path to point the spfile
$asmcmd spset /u01/oragrid/spfile/spfileASM.ora
28.50-PM-768x501.png 768w, https://www.laweekly. If you’re looking for a trusted brand, this is it! What differentiates them from the average company is their two main claims: their first claim is that the product is actually dehydrated urine, so it cannot technically be considered a ‘fake’ or ‘synthetic’ product. The second claim is that the product has ‘never failed in the history of the product’. Visit: https://www.urineworld.com/
ReplyDelete