AIX SP update and Oracle interaction Post: 302913866

Sponsored Content

Operating Systems AIX AIX SP update and Oracle interaction Post 302913866 by allenhibbert on Wednesday 20th of August 2014 10:39:18 AM

08-20-2014

Registered User

AIX SP update and Oracle interaction

Situation:

AIX 7.1 various SP levels
Update to SP9 on DB systems with Oracle 10 or 11G

Steps:

Apply SP9 update
Bring down databases
shutdown -Fr
Check system health - AIX
Bring up databases
Confirm functionality

Would applying the update while the databases are up cause problems with either the SP update or the Oracle databases?

I've looked for a definitive answer on the web, and asking others, to no avail. The conservative approach is to do the SP update after the databases are down. However, if the SP update can be done before, it would streamline the over all process.

Last edited by rbatte1; 08-20-2014 at 01:12 PM.. Reason: Set LIST tags and correct spellings

allenhibbert

View Public Profile for allenhibbert

Find all posts by allenhibbert

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 DEBIAN

ctl_cyrusdb

CTL_CYRUSDB(8)						      System Manager's Manual						    CTL_CYRUSDB(8)

 *

NAME

       ctl_cyrusdb - perform operations common to all Cyrus databases

SYNOPSIS

       ctl_cyrusdb [ -C config-file ] -r [ -x ]
       ctl_cyrusdb [ -C config-file ] -c

DESCRIPTION

       Ctl_cyrusdb is used to perform various administrative operations on the Cyrus databases.

       Ctl_cyrusdb  reads its configuration options out of the imapd.conf(5) file unless specified otherwise by -C.  The configdirectory option is
       used to determine the default location of the Cyrus databases.

OPTIONS

       -C config-file
	      Read configuration options from config-file.

       -r     Recover the databases after an application or system failure.  Also performs database cleanup  like  removing  mailbox  reservations
	      (and any associated mailbox files).

	      All  mailbox  files  are	also checked to make sure the file format matches the configured database type in imapd.conf.  If not, the
	      file is automatically converted using the same logic as cvt_cyrusdb.

       -x     Used with -r to recover the database only.  (Prevents database cleanup).

       -c     Checkpoint and archive the databases.  Changes to the database which are part of committed transactions are written to disk.   Also,
	      a hot backup of the databases is made and inactive log files are removed.

FILES

       /etc/imapd.conf

SEE ALSO

       imapd.conf(5), cyrmaster(8)

CMU
								   Project Cyrus						    CTL_CYRUSDB(8)