oracle-validate 미설치시 설정

# groupadd oinstall
# groupadd dba
# useradd -g oinstall -G oinstall,dba oracle
# id oracle
# passwd oracle
[root@oel4 ~]# groupadd oinstall
[root@oel4 ~]# groupadd dba
[root@oel4 ~]# useradd -g oinstall -G oinstall,dba oracle
[root@oel4 ~]# id oracle
uid=500(oracle) gid=501(oinstall) groups=501(oinstall),500(dba)
[root@oel4 ~]# passwd oracle
Changing password for user oracle.
New UNIX password: 
BAD PASSWORD: it is based on a dictionary word
Retype new UNIX password: 
passwd: all authentication tokens updated successfully.

 

oracle soft nproc 2047
oracle hard nproc 16384
oracle soft nofile 1024
oracle hard nofile 65536

 

session    required     pam_limits.so

 

필수 설정

mkdir /u01
chown oracle:oinstall /u01
[root@oel4 ~]# mkdir /u01
[root@oel4 ~]# chown oracle:oinstall /u01

 

export EDITOR=vi
export LD_ASSUME_KERNEL=2.4.19
export ORACLE_BASE=/u01/app/oracle
export ORACLE_HOME=$ORACLE_BASE/product/10.2.0/db_1
export ORACLE_SID=orcl
export LANG=ko_KR.eucKR
export ORACLE_TERM=xterm
export NLS_LANG=AMERICAN_AMERICA.KO16KSC5601
export ORA_NLS33=$ORACLE_HOME/ocommon/nls/admin/data
export LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib:/usr/local/lib
export PATH=$JAVA_HOME/bin:$PATH:$ORACLE_HOME/bin
export CLASSPATH=$ORACLE_HOME/JRE:$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib
export PS1='[\u@$ORACLE_SID \W]$ '