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 HPUX

vxconfigbackupd

vxconfigbackupd(1M)													       vxconfigbackupd(1M)

NAME

       vxconfigbackupd - disk group configuration backup daemon

SYNOPSIS

       vxconfigbackupd [-l]

DESCRIPTION

       The vxconfigbackupd daemon automatically backs up information about a disk group's new configuration whenever the configuration is changed.

OPTIONS

       -l	 Logs backup daemon activities to the file /etc/vx/cbr/bkdaemonLog.

FILES

       /sbin/init.d/vxvm-recover
		 Startup file for vxconfigbackupd.

       /etc/vx/cbr/bk/dgname.dgid/dgid.dginfo
		 Location of backup file for disk group information.

       /etc/vx/cbr/bk/dgname.dgid/dgid.diskinfo
		 Location of backup file for disk attributes.

       /etc/vx/cbr/bk/dgname.dgid/dgid.binconfig
		 Location of backup file for binary configuration copy.

       /etc/vx/cbr/bk/dgname.dgid/dgid.cfgrec
		 Location of backup file for configuration records in vxprint -m format.

NOTES

       The vxconfigbackup command can be used to back up a disk group's configuration manually at any desired time.

       The  disk  group  configuration	backup and restore utilities do not save any data in the public region. This includes file system or other
       application data that is configured within VxVM objects.

       When a disk group is destroyed, its configuration backup information (including the backup directory) is also removed.  The only  exception
       to this behavior is when the disk group is in the precommit state of restoration.

       The  backup  directory should be large enough to accommodate copies of all the currently imported disk groups. The minimum recommended size
       of the backup directory is P * (N + 1) megabytes, where P is the private region in megabytes (by default, 32MB), and N  is  the	number	of
       disk  groups. The additional P megabytes is required to hold a temporary copy of the disk group configuration when a disk group is imported
       or a configuration change is made.

       The default backup directory is /etc/vx/cbr/bk.	The location of the backup directory can be configured	by  using  the	vxconfigbackup	-l
       backup_directory_path command.

SEE ALSO

       vxconfigbackup(1M), vxconfigrestore(1M)

VxVM 5.0.31.1							    24 Mar 2008 					       vxconfigbackupd(1M)