Shutdown Oracle DB on SunOS Cluster Post: 302946078

Sponsored Content

Operating Systems Solaris Shutdown Oracle DB on SunOS Cluster Post 302946078 by db_senior on Saturday 6th of June 2015 08:21:08 PM

06-06-2015

Registered User

Shutdown Oracle DB on SunOS Cluster

Hi,
I've this Oracle database version:
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production

Oracle is install in a SunOS DBSERVER1 5.11 11.2 sun4v sparc sun4v cluster (Not RAC environment)
DBSERVER1 is node active and DBSERVER2 is node inactive

Now I need to shutdown Oracle DB and I'd like to Know if I have to put in
before the freeze cluster or I can do the shutdown normally issue the command "shutdown immediate".
I have another cluster redhat and I follow the below sequence to shutdown oracle DB:

Code:

1) clusvcadm -Z <service_name>
2) sqlplus / as sysdba
shutdown immediate
startup
3) clusvcadm -U <service_name>

In SunOS cluster What is the correct set of sequence to shutdown oracle DB?

Thanks in advance!

Last edited by jim mcnamara; 06-07-2015 at 01:01 AM..

db_senior

View Public Profile for db_senior

Find all posts by db_senior

6 More Discussions You Might Find Interesting

1. 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. 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...

3. 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...

4. 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. 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...

6. 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...

LEARN ABOUT SUSE

mounted.ocfs2

mounted.ocfs2(8)						OCFS2 Manual Pages						  mounted.ocfs2(8)

NAME

       mounted.ocfs2 - Detects all OCFS2 volumes on a system.

SYNOPSIS

       mounted.ocfs2 [-d] [-f] [device]

DESCRIPTION

       mounted.ocfs2  is used to detect OCFS2 volume(s) on a system.  This tool assumes that the nodes detected on the system are part of the same
       cluster as the one specified in /etc/ocfs2/cluster.conf.

OPTIONS

       -d     Lists the OCFS2 volumes along with their labels and uuids.  If a device is not specified, it scans all the devices  in  /proc/parti-
	      tions.

       -f     Lists  the OCFS2 volumes along with the list of nodes that have mounted the volume. The node names are listed if the O2CB cluster is
	      online. Note: As this information is gathered using dirty-read, the information may be stale.

EXAMPLES

       [root@node1 ~]# mounted.ocfs2 -d
       Device	   FS	  UUID					Label
       /dev/sdb1   ocfs2  26d5dcdf-6d87-45a7-b01a-b98a7791bd61	logs_0405

       [root@node1 ~]# mounted.ocfs2 -f
       Device	   FS	  Nodes
       /dev/sdb1   ocfs2  node15, node1

SEE ALSO

       mkfs.ocfs2(8) fsck.ocfs2(8) tunefs.ocfs2(8) debugfs.ocfs2(8) ocfs2console(8) o2cb(7)

AUTHORS

       Oracle Corporation

COPYRIGHT

       Copyright (C) 2004, 2010 Oracle. All rights reserved.

Version 1.4.3							   February 2010						  mounted.ocfs2(8)