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>

Rman Connect Target Fails With ORA-06508 or RMAN-04015 or PLS-00201

Rman Connect Target Fails With ORA-06508 or RMAN-04015  or PLS-00201

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00554: initialization of internal recovery manager package failed
RMAN-04005: error from target database:
ORA-04063: package body "APPS.DBMS_BACKUP_RESTORE" has errors
ORA-06508: PL/SQL: could not find program unit being called: "APPS.DBMS_BACKUP_RESTORE"
ORA-06512: at line 1
RMAN-04015: error setting target database character set to UTF8