Upgrades of Oracle databases from any version to any version on any platform

Oracle Docs:

Upgrade:

1.       Complete checklist for manual upgrades of Oracle databases from any version to any version on any platform (documents only from 7.3.x>>8.0.x>>8.1.x>>9.0.x>>9.2.x>>10.1.x>>10.2.x>>11.1.x>>11.2.x) [ID 421191.1]

 - This document provides only the links to others which clearly explains the steps of migrating Oracle databases manually from any version to any version on any platform.

2.       Complete Checklist for Manual Upgrades to 11gR2 [ID 837570.1]

 - This document is created for use as a guideline and checklist when manually upgrading from Oracle 9iR2 (9.2), Oracle 10gR1 (10.1), Oracle 10gR2 (10.2) or Oracle 11gR1 (11.1) to Oracle 11gR2 (11.2).

3.       Complete Checklist to Upgrade the Database to 11gR2 using DBUA [ID 870814.1]

 - The purpose of this article is to minimize the downtime while upgrading the database using DBUA.

4.       Information Center: Upgrading and Migration Oracle Database [ID 1351112.2] .

5.       Master Note For Oracle Database Upgrades and Migrations [ID 1152016.1]

 - This Master Note is intended to provide an index and references to the most frequently used My Oracle Support Notes with respect to Oracle Database Upgrade and Migration.

6.       Complete checklist for out-of-place manual upgrade from previous 11.2.0.N version to the latest 11.2.0.N patchset. [ID 1276368.1]

 - This document explains how to perform an out-of place manual database upgrade from 11.2.0.1 to 11.2.0.2 or later version of 11.2.0.N.

AIX for Oracle DBA

A) Memory Consumption:

$ svmon -G
               size       inuse        free         pin     virtual
memory      5079040     5076409        2631      706856     2983249
pg space    7864320       12885

               work        pers        clnt       other
pin          540803           0        2758      163295
in use      2983249           0     2093160

Manual Creation of Oracle Database

1. Create the pfile and sample parameter file is below
DUMMY.__db_cache_size=109051904
DUMMY.__java_pool_size=4194304
DUMMY.__large_pool_size=4194304
DUMMY.__oracle_base='/u01/app/oracle'#ORACLE_BASE set from environment
DUMMY.__pga_aggregate_target=167772160
DUMMY.__sga_target=251658240
DUMMY.__shared_io_pool_size=0
DUMMY.__shared_pool_size=125829120
DUMMY.__streams_pool_size=0
*.audit_file_dest='/u01/app/oracle/admin/DUMMY/adump'
*.audit_trail='db'
*.compatible='11.2.0.0.0'
*.control_files='/ORADATA/DUMMY/fra/DUMMY/controlfile/control_01_.ctl','/ORADATA/DUMMY/fra2/DUMMY/controlfile/control_02_.ctl'

Using ssh-keys from Openssh to Tectiassh and vice-versa

How to find the server is Openssh or Tectiassh
> ssh -V

Configuration starts from here

1. On SERVERA with Openssh:

 1. ssh-keygen -t rsa
 2. cd .ssh
 3. It creates two files id_rsa and id_rsa.pub
 4. Create a file authorized_keys and copy/paste id_rsa.pub into it.
 5. ssh-keygen -e -f id_rsa.pub >Openssh_to_Tectiassh

Genrating a stack from core dumps in unix and linux

Follow the instructions below in order:

1.      Check if you have a core file, we may find in cdump or bdump/trace or bdump or cluster log locations.

2.      Log into the user (the user need to be the owner of the core file) Then issue

               file <CORE_FILENAME>

The above output gives more info like from which executable (program) the core generated and other.

3.      Log into the user (owner of the program). Go to ORACLE_HOME/bin or GRID_HOME/bin, then issue

                file <Program>

Note: if possible give read permission to the program  (optional)

                chmod a+r <program>