AIX SP update and Oracle interaction Post: 302914021

Sponsored Content

Operating Systems AIX AIX SP update and Oracle interaction Post 302914021 by ibmtech on Thursday 21st of August 2014 11:30:26 AM

08-21-2014

Registered User

Those are all good, but make sure you use alternate disk install
To summarize
1. You need to have a free disk (equal to greater in size of rootvg)
2.

Code:

smitty -->   Software Installation and Maintenance -->  Alternate Disk Installation  -->
  Clone the rootvg to an Alternate Disk

Code:

[TOP]                                                   [Entry Fields]
* Target Disk(s) to install                          [hdisk1]                             +
  Phase to execute                                    all                                 +
  image.data file                                    []                                    /
  Exclude list                                       []                                    /

  Bundle to install                                  [update_all]                         +
    -OR-
  Fileset(s) to install                              []

  Fix bundle to install                              []
    -OR-
  Fixes to install                                   []

  Directory or Device with images                    [/export/aix71/tl01sp09]
  (required if filesets, bundles or fixes used)

  installp Flags
  COMMIT software updates?                            yes                                 +
  SAVE replaced files?                                no                                  +
  AUTOMATICALLY install requisite software?           yes                                 +
  EXTEND file systems if space needed?                yes                                 +
  OVERWRITE same or newer versions?                   no                                  +
  VERIFY install and check file sizes?                no                                  +
  ACCEPT new license agreements?                      yes                                 +

  Customization script                               []                                    /
[MORE...5]

This will 1st copy the existing mksysb to new disk, then it will update the OS, all your setting will remain the same.

If your Tl01SP09 binaries are on NIM server, you can export that directory to the client and use that location.

Make sure you accept the license agreement.

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 DEBIAN

jifty::dbi::handle::oracle

Jifty::DBI::Handle::Oracle(3pm) 			User Contributed Perl Documentation			   Jifty::DBI::Handle::Oracle(3pm)

NAME

	 Jifty::DBI::Handle::Oracle - An oracle specific Handle object

SYNOPSIS

DESCRIPTION

       This module provides a subclass of Jifty::DBI::Handle that compensates for some of the idiosyncrasies of Oracle.

METHODS

   connect PARAMHASH: Driver, Database, Host, User, Password
       Takes a paramhash and connects to your DBI datasource.

   database_version
       Returns value of ORA_OCI constant, see "Constants" in DBD::Oracle.

   insert
       Takes a table name as the first argument and assumes that the rest of the arguments are an array of key-value pairs to be inserted.

   build_dsn PARAMHASH
       Takes a bunch of parameters:

       Required: Driver, Database or Host/SID, Optional: Port and RequireSSL

       Builds a dsn suitable for an Oracle DBI connection

   blob_params column_NAME column_type
       Returns a hash ref for the bind_param call to identify BLOB types used by the current database for a particular column type.  The current
       Oracle implementation only supports ORA_CLOB types(112).

   apply_limits STATEMENTREF ROWS_PER_PAGE FIRST_ROW
       takes an SQL SELECT statement and massages it to return ROWS_PER_PAGE starting with FIRST_ROW;

   distinct_query STATEMENTREF
       takes an incomplete SQL SELECT statement and massages it to return a DISTINCT result set.

AUTHOR

       Jesse Vincent, jesse@fsck.com

SEE ALSO

       Jifty::DBI, Jifty::DBI::Handle, DBD::Oracle

perl v5.14.2							    2011-04-26					   Jifty::DBI::Handle::Oracle(3pm)