Login or Register to Ask a Question and Join Our Community


Solaris

Shutdown Oracle DB on SunOS Cluster

 
Thread Tools Search this Thread
Operating Systems Solaris Shutdown Oracle DB on SunOS Cluster
Prev   Next
# 5  
Old 06-08-2015
You should not issue shutdown commands from instance on Solaris Cluster.

The clusterware will see this as failed resource group and will failover on another node.

What you need to do is :

Identify the cluster group resource which is responsible for resources.
clrg show and clrs show will tell you that.

After you have identifed the cluster group(s) responsible for database you will just need to do a clrg offline group-name

This will stop everything related to database (every resource in resource group[s]), umount filesystems if used, stop ASM etc. -> depending on the resources configuration and database resources setup).

If you want to tinkle around the database while resource group is online you will need to put its resources in unmonitor state clrg unmonitor group-name .
Be sure to return them to monitor after you are done, or risk failover not happening.

Test this on virtualbox cluster or test enviroment, setup a small cluster and get into resource groups and resources Smilie

I haven't done this with oracle databases, but i have with NFS and HA filesystem on sun cluster.


Hope that helps.
Regards
Peasant.
 
Login or Register to Ask a Question

Previous Thread | Next Thread

6 More Discussions You Might Find Interesting

1. Solaris

SunOS 8.5 random shutdown

hope this is the correct spot. we have 4 unit running SunOS 8.5 2 in offices and 2 running equipment in the lab. the communicate over our network to run/monitor jobs on the equipment. they randomly shut off recently. twice last thursday and once this friday. the vendor of the equipment... (4 Replies)
Discussion started by: fah_kinright
4 Replies

2. UNIX for Dummies Questions & Answers

Script to force Oracle database shutdown when shutdown immediate does not work

I have Oracle 9i R2 on AIX 5.2. My Database is running in shared server mode (MTS). Sometimes when I shutdown the database it shutsdown cleanly in 4-5 mints and sometimes it takes good 15-20 minutes and then I get some ora-600 errors and only way to shutdown is by opening another session and... (7 Replies)
Discussion started by: aixhp
7 Replies

3. Solaris

Shutdown the package in SUN cluster

Hi, I have a SUN cluster system. I want to know what script do when the SUN cluster shutdown the package as I may need to modify it ?? Where can I find out this information in the system?? In which directory and log file ??? Any suggestion ??? (5 Replies)
Discussion started by: chuikingman
5 Replies

4. Shell Programming and Scripting

Shell script to Shutdown Computers on Cluster

Hello all. I have built a cluster of 9 Macs for computational chemistry and I need a shell script that I can use from one computer to all the rest to shutdown. I have modified all of the Macs so that there is pass-wordless ssh. As well, I have modified each "visudo" file on each machine by... (1 Reply)
Discussion started by: marcozd
1 Replies

5. UNIX for Advanced & Expert Users

Capturing Oracle Shutdown error

Hi, Iam calling 3 sql scripts through one shell script 'rmia.sh'. Till now this was working fine, but last time while calling the SQL scripts, Oracle was down. But amazingly the exit status was '0' (success)!!! Below is the shell code: #!/usr/bin/ksh -x assign_file asql a.sql 1... (15 Replies)
Discussion started by: ganapati
15 Replies

6. UNIX for Dummies Questions & Answers

Connecting to a Oracle Db using SunOS

Hi Guys, how do I connect to a Oracle Database from my machines running on Solaris 5 and 9. Do I need a Oracle client installed or is there any other way to connect to the Oracle Db without using the oracle client? Any inputs will be highly appreciated. (2 Replies)
Discussion started by: darmat0712
2 Replies
Login or Register to Ask a Question

LEARN ABOUT DEBIAN

sql::reservedwords::oracle

SQL::ReservedWords::Oracle(3pm) 			User Contributed Perl Documentation			   SQL::ReservedWords::Oracle(3pm)

NAME

       SQL::ReservedWords::Oracle - Reserved SQL words by Oracle

SYNOPSIS

	  if ( SQL::ReservedWords::Oracle->is_reserved( $word ) ) {
	      print "$word is a reserved Oracle word!";
	  }

DESCRIPTION

       Determine if words are reserved by Oracle Database.

METHODS

       is_reserved( $word )
	   Returns a boolean indicating if $word is reserved by either Oracle7, Oracle8i, Oracle9i or Oracle10g.

       is_reserved_by_oracle7( $word )
	   Returns a boolean indicating if $word is reserved by Oracle7.

       is_reserved_by_oracle8( $word )
	   Returns a boolean indicating if $word is reserved by Oracle8i.

       is_reserved_by_oracle9( $word )
	   Returns a boolean indicating if $word is reserved by Oracle9i.

       is_reserved_by_oracle10( $word )
	   Returns a boolean indicating if $word is reserved by Oracle10g.

       reserved_by( $word )
	   Returns a list with Oracle versions that reserves $word.

       words
	   Returns a list with all reserved words.

EXPORTS

       Nothing by default. Following subroutines can be exported:

       is_reserved
       is_reserved_by_oracle7
       is_reserved_by_oracle8
       is_reserved_by_oracle9
       is_reserved_by_oracle10
       reserved_by
       words

SEE ALSO

       SQL::ReservedWords

       <http://www.oracle.com/technology/documentation/>

AUTHOR

       Christian Hansen "chansen@cpan.org"

COPYRIGHT

       This program is free software, you can redistribute it and/or modify it under the same terms as Perl itself.

perl v5.8.8							    2008-03-28					   SQL::ReservedWords::Oracle(3pm)