Oracle Linux Notes

Kernal Parameters

Log in as root user
cd /proc/sys/kernel
cat sem
ex: 250 32000 32 128

SEMMSL: 250
SEMMNS: 32000
SEMOPM: 32
SEMMNI: 128

Set Permissions for File Creation

umask 022

Settings

export ORACLE_BASE=/u01/app/oracle
export ORACLE_HOME=/u01/app/oracle/product/9.0.1
export ORACLE_SID=karen
export TNS_ADMIN=/export/home/oracle/config/9.0.1

Groups

groupadd dba
groupadd oper
groupadd oinstall

Users

useradd oracle -g oinstall -G
passwd oracle

Other

mkdir /var/opt/oracle
chown oracle:dba /var/opt/oracle
chmod 755 /var/opt/oracle

/home/oracle/oraInventory
Unix Group Name: oinstall
/opt/oracle/product/9.0.1
JAVA_HOME=/usr/bin/java

Install Questions?

What would you like as the base directory?
/opt/oracle/oraInventory
UNIX Group Name: oinstall

su - root
/tmp/orainstRoot.sh

./orainstRoot.sh

Enter or select the full path for your Oracle Home:
/opt/oracle/oracle9i

Tools

dbca: Database Configuration Assistant
emca: Enterprise Manager Configuration Assistant
oemapp: Oracle Enterprise Manager
oemctl: Oracle Enterprise Manager Control Utility

oemctl start oms
oemctl stop oms
oemctl ping oms

oemapp console
oemapp dbastudio
oemapp worksheet

lsnrctl  start|stop|status
agentctl start|stop|status|restart

sqlplus "/ as sysdba"