Home » RDBMS Server » Server Administration » How to manage ASM instance (oracle 10g, windows server 2008)
How to manage ASM instance [message #561799] Wed, 25 July 2012 06:21 Go to next message
x-oracle
Messages: 380
Registered: April 2011
Location: gujarat
Senior Member
hello i have create asm instance on my single database name wser

i have successfully create this asm instance

now i want to know how can i start and stop this asm instance and my database

when i using this steps and i want to access database i got this error

C:\Users\Administrator>set oracle_sid=+asm


C:\Users\Administrator>sqlplus

SQL*Plus: Release 10.2.0.3.0 - Production on Wed Jul 25 16:35:55 2012

Copyright (c) 1982, 2006, Oracle.  All Rights Reserved.

Enter user-name: sys as sysdba
Enter password:

Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - Production
With the Partitioning, OLAP and Data Mining options

SQL> select name from v$database;
select name from v$database
                 *
ERROR at line 1:
ORA-01507: database not mounted

SQL> select instance_name from v$instance;

INSTANCE_NAME
----------------
+asm



this is not a rac database i just create this asm instance on my single database only

[EDITED by LF: fixed topic title typo; was "hwo"]

[Updated on: Wed, 25 July 2012 15:06] by Moderator

Report message to a moderator

Re: Hwo to manage asm instance [message #561802 is a reply to message #561799] Wed, 25 July 2012 06:32 Go to previous messageGo to next message
bhat.veeresh@gmail.com
Messages: 88
Registered: July 2012
Location: Bangalore
Member
You Can check the following:

select name,state from v$asm_diskgroup; --Just to verify disk groups are mounted

ps -ef|grep ASM --To verify at OS level

If not stated,

srvctl start asm

Regards,
Veeresh

Re: Hwo to manage asm instance [message #561812 is a reply to message #561799] Wed, 25 July 2012 06:42 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
The error is expected.
ASM is not a database just an instance.
So your ASM instance is started.
The only useful views are v$instance, v$parameter and v$asm% ones (and maybe a couple of other ones I don't think about now).

Regards
Michel
Re: Hwo to manage asm instance [message #561820 is a reply to message #561802] Wed, 25 July 2012 07:11 Go to previous messageGo to next message
x-oracle
Messages: 380
Registered: April 2011
Location: gujarat
Senior Member
i run this syntax veeresh

sql> select name,state from v$asm_diskgroup;

name                 state
---------------------------

data                   mounted


c
:\users\administrator>srvctl start asm
PRKO-2001 : invalid command line syntax
Re: Hwo to manage asm instance [message #561821 is a reply to message #561812] Wed, 25 July 2012 07:16 Go to previous messageGo to next message
x-oracle
Messages: 380
Registered: April 2011
Location: gujarat
Senior Member
yeah michel its a asm instance but how can i use this my wser using this asm instance

how can i start and stop asm instance with this my database
Re: Hwo to manage asm instance [message #561840 is a reply to message #561821] Wed, 25 July 2012 11:03 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
its a asm instance but how can i use this my wser using this asm instance


What does that mean?
There is only one account in ASM instance: SYS/SYSDBA (+ SYSASM in 11g).

Quote:
how can i start and stop asm instance with this my database


Not clear, you start the ASM instance like any other one, using STARTUP command and you stop it using SHUTDOWN one.

Regards
Michel
Re: Hwo to manage asm instance [message #562336 is a reply to message #561840] Tue, 31 July 2012 06:34 Go to previous messageGo to next message
x-oracle
Messages: 380
Registered: April 2011
Location: gujarat
Senior Member
thanks for your reply michel
but how can i use this asm instance with my single database name "WSER"

when i simply connected my database using this I Just only connected to this wser database without asm instance

C:\Users\Administrator>Sqlplus

Enter User-name :  sys as sysdba
Enter password :

sql> Select name from v$database;

NAME
---------
WSER

SQL> Select instance_name,instance_number from v$instance;

INSTANCE_NAME      INSTANCE_NUMBER
---------------    -----------------
WSER                     1



Re: Hwo to manage asm instance [message #562337 is a reply to message #562336] Tue, 31 July 2012 07:08 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
I don't understand the question.
Please explain in details.
I think you do not understand what is ASM.
ASM is just a volume manager; it allows you to create your database files in some disks it manages.

Regards
Michel
Re: Hwo to manage asm instance [message #562362 is a reply to message #562337] Tue, 31 July 2012 13:59 Go to previous messageGo to next message
alan.kendall@nfl.com
Messages: 163
Registered: June 2012
Location: Culver City, California
Senior Member
Here are commands that I used to check and stop asm before some maintenance.
The asm instances came up on their own when the Unix boxes were restarted.
csdrdb01(oracle)/u01/home/oracle>srvctl status asm -n csdrdb01
ASM instance +ASM1 is running on node csdrdb01.
csdrdb01(oracle)/u01/home/oracle>srvctl status asm -n csdrdb02
ASM instance +ASM2 is running on node csdrdb02.
csdrdb01(oracle)/u01/home/oracle>srvctl stop asm -n csdrdb01
csdrdb01(oracle)/u01/home/oracle>srvctl stop asm -n csdrdb02
csdrdb01(oracle)/u01/home/oracle>srvctl status asm -n csdrdb01
ASM instance +ASM1 is not running on node csdrdb01.
csdrdb01(oracle)/u01/home/oracle>srvctl status asm -n csdrdb02
ASM instance +ASM2 is not running on node csdrdb02.
Re: Hwo to manage asm instance [message #562373 is a reply to message #562362] Tue, 31 July 2012 21:38 Go to previous messageGo to next message
trantuananh24hg
Messages: 744
Registered: January 2007
Location: Ha Noi, Viet Nam
Senior Member
@alan: The ASM instance is independent to Oracle Database Instance.
Before 9i, datafile was created with 2 options: File-system based on OS managed block or raw-device. Both of them without any Oracle manage or control separetly. After 10g, ASM is introduced, I think you should read ASM instance at tahiti.oracle.com.
Re: Hwo to manage asm instance [message #562507 is a reply to message #562373] Wed, 01 August 2012 14:12 Go to previous message
alan.kendall@nfl.com
Messages: 163
Registered: June 2012
Location: Culver City, California
Senior Member
Here are commands that I used to check and stop "ASM" before some maintenance
on our disaster recovery boxes. The asm instances came up on their own
when the Unix boxes were restarted.
csdrdb01(oracle)/u01/home/oracle>srvctl status asm -n csdrdb01
ASM instance +ASM1 is running on node csdrdb01.
csdrdb01(oracle)/u01/home/oracle>srvctl status asm -n csdrdb02
ASM instance +ASM2 is running on node csdrdb02.
csdrdb01(oracle)/u01/home/oracle>srvctl stop asm -n csdrdb01
csdrdb01(oracle)/u01/home/oracle>srvctl stop asm -n csdrdb02
csdrdb01(oracle)/u01/home/oracle>srvctl status asm -n csdrdb01
ASM instance +ASM1 is not running on node csdrdb01.
csdrdb01(oracle)/u01/home/oracle>srvctl status asm -n csdrdb02
ASM instance +ASM2 is not running on node csdrdb02.

To shutdown the production database prior to shutting down ASM
I used the following commands.
>srvctl status database -d CSCDAP
>srvctl stop instance -d CSCDAP -i CSCDAP1
>srvctl stop instance -d CSCDAP -i CSCDAP2
>srvctl stop instance -d CSCDAP -i CSCDAP3
>srvctl status database -d CSCDAP

Whenever I do maintenance on RAC, I stop then start one
instance at a time. This way if there is a startup error,
I can fix it from one of the started instances and "Voila"
I never have an outage related to changing oracle memory parameters.
SQL> alter system set sessions=10000 scope=spfile sid='*';
System altered.
SQL> alter system set processes=10000 scope=spfile sid='*';
System altered.
SQL> alter system set open_cursors=10000 scope=spfile sid='*';
System altered.

>srvctl status database -d CSCDAP
Instance CSCDAP1 is running on node csprdcdadb01-fe
Instance CSCDAP2 is running on node csprdcdadb02-fe
Instance CSCDAP3 is running on node csprdcdadb03-fe
>srvctl stop instance -d CSCDAP -i CSCDAP1
>srvctl status database -d CSCDAP
Instance CSCDAP1 is not running on node csprdcdadb01-fe
Instance CSCDAP2 is running on node csprdcdadb02-fe
Instance CSCDAP3 is running on node csprdcdadb03-fe
>srvctl start instance -d CSCDAP -i CSCDAP1
>srvctl status database -d CSCDAP
Instance CSCDAP1 is running on node csprdcdadb01-fe
Instance CSCDAP2 is running on node csprdcdadb02-fe
Instance CSCDAP3 is running on node csprdcdadb03-fe
>srvctl stop instance -d CSCDAP -i CSCDAP2
>srvctl status database -d CSCDAP
Instance CSCDAP1 is running on node csprdcdadb01-fe
Instance CSCDAP2 is not running on node csprdcdadb02-fe
Instance CSCDAP3 is running on node csprdcdadb03-fe
>srvctl start instance -d CSCDAP -i CSCDAP2
>srvctl status database -d CSCDAP
Instance CSCDAP1 is running on node csprdcdadb01-fe
Instance CSCDAP2 is running on node csprdcdadb02-fe
Instance CSCDAP3 is running on node csprdcdadb03-fe
>srvctl stop instance -d CSCDAP -i CSCDAP3
>srvctl status database -d CSCDAP
Instance CSCDAP1 is running on node csprdcdadb01-fe
Instance CSCDAP2 is running on node csprdcdadb02-fe
Instance CSCDAP3 is not running on node csprdcdadb03-fe
>srvctl start instance -d CSCDAP -i CSCDAP3
>srvctl status database -d CSCDAP
Instance CSCDAP1 is running on node csprdcdadb01-fe
Instance CSCDAP2 is running on node csprdcdadb02-fe
Instance CSCDAP3 is running on node csprdcdadb03-fe

To stop CRS after shutting down ASM, I did the following:
cd /u01/app/oracle/product/10.2.0/crs
crsctl check crs
crsctl stop crs

To restart the stage listener on one node:
csstgcdadb11(oracle)/home/oracle>srvctl status listener -n csstgcdadb11
Listener LISTENER is enabled on node(s): csstgcdadb11
Listener LISTENER is running on node(s): csstgcdadb11
csstgcdadb11(oracle)/home/oracle>srvctl status listener -n csstgcdadb12
Listener LISTENER is enabled on node(s): csstgcdadb12
Listener LISTENER is running on node(s): csstgcdadb12
csstgcdadb11(oracle)/home/oracle>srvctl stop listener -n csstgcdadb11
csstgcdadb11(oracle)/home/oracle>srvctl status listener -n csstgcdadb11
Listener LISTENER is enabled on node(s): csstgcdadb11
Listener LISTENER is not running on node(s): csstgcdadb11
csstgcdadb11(oracle)/home/oracle>srvctl start listener -n csstgcdadb11
csstgcdadb11(oracle)/home/oracle>srvctl status listener -n csstgcdadb11
Listener LISTENER is enabled on node(s): csstgcdadb11
Listener LISTENER is running on node(s): csstgcdadb11
Previous Topic: Empty database
Next Topic: Few Cluster services are down.Why
Goto Forum:
  


Current Time: Thu Mar 28 17:34:02 CDT 2024