AIX SP update and Oracle interaction Post: 302914035

Sponsored Content

Operating Systems AIX AIX SP update and Oracle interaction Post 302914035 by bakunin on Thursday 21st of August 2014 12:35:01 PM

08-21-2014

Registered User

Quote:

Originally Posted by allenhibbert

mksysb is the backout plan

I do have the DBA team verify the oracle version is compatible with the intended OS update. I also read up to determine myself.

I'm curious if applying the SP while the databases are still up would cause issues. The oracle is 11G, on AIX 7 TL1 SP9. I'd try it in a test area, if I could.

You seem to come from a different flavour of Unix, so maybe a bit of background information about Alternate Disk Migration is in order. To expand on what ibmtech already explained:

One usually has a mirrored rootvg, which means that you have two identical disks carrying identical copies of the OS. ADM now does the following: it breaks up the mirror. Then you apply the update (or the installation - there is not only Alternate Disk Migration but also Alternate Disk Installation) to one of these copies. Then you reboot into this newly installed/updated environment.

If everything turns out OK you destroy the unchanged copy and remirror, so that you now have two copies of the new system images. If some problem occurs you reboot back into the old environment from the still existing (and unchanged) disk, destroy the new installation and remirror, arriving at the point you started from again.

Most of these steps are done behind the scenes by the provided procedures, but it helps to have a working picture of what is going on.

NOTE: at the end of the procedure do not forget to apply the bosboot command and maintain the system bootlist with bootlist command.

I hope this helps.

bakunin

bakunin

View Public Profile for bakunin

Find all posts by bakunin

4 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

update a oracle table using shell script

Hi, I would like to know how to update a table in Oracle database, if a command in one shell script either successfully completes or it fails.(like Y if its success or N if its a failure) While the command is running,I am able to view the log file created in the Unix machine.After the command...

2. UNIX for Advanced & Expert Users

unix script for update or insert records from a file to a oracle table

Hi, I have delimited file(|). Sample data: 1|name|50009|DS24|0|12 2|name|30009|DS24|0|13 3|name|20409|DS24|0|14 4|name|20009|DS24|0|15 5|name|10009|DS24|0|16 I want to load this data into a oracle table (update and insert) Please help me the commands and also...

3. UNIX for Advanced & Expert Users

oracle update not working

Hi, I have a oracle source with a field my_date =06/02/2009 I am trying to update the table to SYSDATE with a myscript.sql where I have UPDATE table set my_date=to_DATE(SYSDATE,'MM/DD/YYYY'); Now I try to run it with myupdate.SH script where I have sqlplus nolog @myscript.sql ...

4. Shell Programming and Scripting

How to update a Oracle table through shell scripting?

My Code is get_week_date() { `sqlplus -s ${DQM_SQL_LOGON}@${DQM_SID} << EOF SET ECHO OFF SET FEEDBACK OFF SET PAGES 0 SET SERVEROUTPUT ON SET VERIFY OFF SET TRIMSPOOL ON (update file_level_qc fq set FQ.DATA_FILE_NAME='Hyvee_Pharmacy_Solutions_201304_v1.txt'...

LEARN ABOUT CENTOS

mkqdisk

mkqdisk(8)						      Quorum Disk Management							mkqdisk(8)

NAME

       mkqdisk - Cluster Quorum Disk Utility

WARNING

       Use of this command can cause the cluster to malfunction.

SYNOPSIS

       mkqdisk [-?|-h] | [-L] | [-f label] [-c device  -l label] [-d [-d ...]]

DESCRIPTION

       The mkqdisk command is used to create a new quorum disk or display existing quorum disks accessible from a given cluster node.

OPTIONS

       -c device -l label
	      Initialize  a new cluster quorum disk.  This will destroy all data on the given device.  If a cluster is currently using that device
	      as a quorum disk, the entire cluster will malfunction.  Do not run this on an active cluster  when  qdiskd  is  running.	 Only  one
	      device  on  the  SAN should ever have the given label; using multiple different devices is currently not supported (it is expected a
	      RAID array is used for quorum disk redundancy).  The label can be any textual string up to 127 characters - and is therefore  enough
	      space to hold a UUID created with uuidgen(1).

       -f label
	      Find the cluster quorum disk with the given label and display information about it.

       -L     Display information on all accessible cluster quorum disks.

       -d     Increase debugging level.  Specify multiple times for more information.  Currently, specifying more than twice has no effect.

SEE ALSO

       qdisk(5), qdiskd(8), uuidgen(1)

								     July 2006								mkqdisk(8)