Essentials Oracle

Quick Peek into your database:

List or view database list on Linux and Unix Platforms.

cat /etc/oratab

Check if your Oracle software is 32 bit or 64 bit

cd $ORACLE_HOME/bin

file oracl*

Check your database size

SELECT SUM(BYTES)/(1024*1024*1024) FROM DBA_DATA_FILE

Datamover is importing into rows into tables and the Datamover is hanged and the logs are not accessible for some reason and you want to know if the datamover insertion is happening or not.. Use the Below Query to get the information

SELECT SUM(BYTES)/(1024*1024*1024) FROM DBA_SEGMENTS WHERE SEGMENT_TYPE='TABLE';

Database File Locations 

$oracle_home/dba   -- InIt<SID>.ora

Show Parameter Commands

SHOW PARAMETER SEC_CASE_SENSITIVE_LOGON 

The SEC_CASE_SENSITIVE_LOGON initialization parameter gives control over case sensitive passwords.

Environment Variables:

TMP=/tmp; export TMP

TMPDIR=$TMP; export TMPDIR

ORACLE_HOSTNAME=oel45.localdomain; export ORACLE_HOSTNAME

ORACLE_BASE=/u01/app/oracle; export ORACLE_BASE

ORACLE_HOME=$ORACLE_BASE/product/11.1.0/db_1; export ORACLE_HOME

ORACLE_SID=DB11G; export ORACLE_SID

ORACLE_TERM=xterm; export ORACLE_TERM

PATH=/usr/sbin:$PATH; export PATH

PATH=$ORACLE_HOME/bin:$PATH; export PATH

LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib; export LD_LIBRARY_PATH

.Profile File ..Oracle : AIX

PATH=/usr/bin:/etc:/usr/sbin:/usr/ucb:$HOME/bin:/usr/bin/X11:/sbin:.:/usr/local/bin:${ORACLE_HOME}:${ORACLE_HOME}/bin:${ORACLE_HOME}/OPatch:/oracle/dba/bin

export PATH
export HISTFILE=$HOME/.histdir/$(tty|sed 's-/-_-g')
export DBA_INIT_INI=/oracle/dba/funcs/dba_init.ini

# NMON variable to stop oslevel checking
export NMONAIX=5.2.0.0

export EDITOR=vi
export FPATH=/oracle/dba/funcs
export TNS_ADMIN=/var/opt/oracle
export ORACLE_BASE=/opt/oracle
export ORACLE_ASK=YES
export ORACLE_OWNER=oracle

export NLS_LANG=AMERICAN_AMERICA.UTF8
export NLS_DATE_FORMAT='YYYY/MM/DD HH24:MI'

nins
. .kshrc

# Set up machine independent variables
stty erase '^H' kill "^U" intr "^C" eof "^D"
umask 002

export HOST=$(uname -n)
export PWD=`pwd`
export PS1='$ORACLE_SID@$HOST: $PWD> '
if [ -s "$MAIL" ]           # This is at Shell startup.  In normal
then echo "$MAILMSG"        # operation, the Shell checks
fi                          # periodically.
~

OEM:

OPATCH Commands

$ORACLE_HOME/OPatch/opatch lsinventory

Latest Oracle Installed with latest patchset info:
opatch lsinventory -bugs_fixed | egrep -i 'PSU|DATABASE PATCH SET UPDATE'



A list will be output, and the highest release version reported is the current PSU installed. In the following example output, 11.2.0.2.6 is the installed Database PSU:

10248523   13696224  Fri Mar 30 14:00:25 EDT 2012   DATABASE PSU 11.2.0.2.1
11724916   13696224  Fri Mar 30 14:00:25 EDT 2012   DATABASE PSU 11.2.0.2.2 (INCLUDES CPUAPR2011)
12419331   13696224  Fri Mar 30 14:00:25 EDT 2012   DATABASE PSU 11.2.0.2.3 (INCLUDES CPUJUL2011)
12827726   13696224  Fri Mar 30 14:00:25 EDT 2012   DATABASE PSU 11.2.0.2.4 (INCLUDES CPUOCT2011)
13343424   13696224  Fri Mar 30 14:00:25 EDT 2012   DATABASE PATCH SET UPDATE 11.2.0.2.5 (INCLUDES CPUJAN2012)
13696224   13696224  Fri Mar 30 14:00:25 EDT 2012   DATABASE PATCH SET UPDATE 11.2.0.2.6 (INCLUDES CPUAPR2012)


To check if your database is on RAC or not


SQL> select name, value from v$parameter where name='cluster_database'; 

NAME                  VALUE 
--------------------- --------------------- 
cluster_database      TRUE 

or

set serveroutput on 
 BEGIN 
  IF dbms_utility.is_cluster_database THEN 
      dbms_output.put_line('Running in SHARED/RAC mode.'); 
  ELSE 
      dbms_output.put_line('Running in EXCLUSIVE mode.'); 
  END IF; 
END; 

/ 

check the java version in aix:

lslpp -L | grep Java

pshcm1@wpibm019: /db/new_pshcmd8/d01/pshome/sree/install/bea/tuxedo9.1> lslpp -L | grep Java
  Java14.sdk               1.4.2.225    C     F    Java SDK 32-bit
  Java14_64.license          1.4.2.0    C     F    Java SDK 64-bit License
  Java14_64.sdk            1.4.2.175    C     F    Java SDK 64-bit
  Java5.sdk                5.0.0.235    C     F    Java SDK 32-bit
  Java6.sdk                6.0.0.125    C     F    Java SDK 32-bit
  Java6_64.sdk             6.0.0.150    C     F    Java SDK 64-bit

Listerner issue: Service cannot be found.

SQL> alter system set LOCAL_LISTENER='(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=wpibm019.albertsons.com)(PORT=1222)))';

System altered.

SQL> alter system register;

System altered.