AIX SP update and Oracle interaction Post: 302913874

Sponsored Content

Operating Systems AIX AIX SP update and Oracle interaction Post 302913874 by ibmtech on Wednesday 20th of August 2014 11:10:45 AM

08-20-2014

Registered User

What is your backout plan? What if your SP is not consistent and you have to go back to the original OS and SP level?
The answer is you always create an alternative disk (of rootvg) and upgrade that disk, without impacting anything on the current running environment.

For this you need to have an additional disk, if you cannot get an additional disk, then you can also use multibos on the same disk to achieve the similar result (but make sure the root disk have enough space for multibos operation). But, never ever go directly without a backup copy.

But you want to be sure that the new SP is compatible with existing oracle version, so throw that question to oracle DBA team, ask them to find out oracle compatibility with that new SP version.

Last edited by ibmtech; 08-20-2014 at 12:12 PM.. Reason: Added more comments

ibmtech

View Public Profile for ibmtech

Find all posts by ibmtech

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 OSF1

disklabel

disklabel(4)						     Kernel Interfaces Manual						      disklabel(4)

NAME

       disklabel - Disk pack label

SYNOPSIS

       #include <sys/disklabel.h>

DESCRIPTION

       Each disk or disk pack on a system may contain a disk label which provides detailed information about the geometry of the disk and the par-
       titions into which the disk is divided.	It should be initialized when the disk is formatted, and may be changed later with  the  disklabel
       program.   This	information is used by the system disk driver and by the bootstrap program to determine how to program the drive and where
       to find the file systems on the disk partitions.  Additional information is used by the file system in order to use  the  disk  most  effi-
       ciently	and  to locate important file system information.  The description of each partition contains an identifier for the partition type
       (standard file system, swap area, etc.).  The file system updates the in-core copy of the label if it contains incomplete information about
       the file system.

       The label is located in sector number LABELSECTOR of the drive, usually sector 0 (zero) where it may be found without any information about
       the disk geometry.  It is at an offset LABELOFFSET from the beginning of the sector, to allow room for the  initial  bootstrap.	 The  disk
       sector  containing  the	label  is normally made read-only so that it is not accidentally overwritten by pack-to-pack copies or swap opera-
       tions; the DIOCWLABEL ioctl, which is done as needed by the disklabel program, allows modification of the label sector.

       A copy of the in-core label for a disk can be obtained with the DIOCGDINFO ioctl; this works with a file descriptor for a block or  charac-
       ter  (raw)  device for any partition of the disk.  The in-core copy of the label is set by the DIOCSDINFO ioctl.  The offset of a partition
       cannot generally be changed, nor made smaller while it is open.	One exception is that any change is allowed if no label was found  on  the
       disk,  and  the	driver was able to construct only a skeletal label without partition information.  Finally, the DIOCWDINFO ioctl operation
       sets the in-core label and then updates the on-disk label; there must be an existing label on the  disk	for  this  operation  to  succeed.
       Thus,  the  initial  label for a disk or disk pack must be installed by writing to the raw disk.  All of these operations are normally done
       using the disklabel program.

RELATED INFORMATION

       Files: disktab(4)

       Commands: disklabel(8) delim off

																      disklabel(4)