1. oracle-validate 미설치시 설정
root 유저로 수행 (oracle-validated 미설치시)
# 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.
vi /etc/security/limits.conf 편집 root 유저로 수행 (oracle-validated 미설치시)
oracle soft nproc 2047 oracle hard nproc 16384 oracle soft nofile 1024 oracle hard nofile 65536
vi /etc/pam.d/login 편집 root 유저로 수행 (oracle-validated 미설치시)
session required pam_limits.so
2. 필수 설정
root 유저로 수행
mkdir /u01 chown oracle:oinstall /u01
[root@oel4 ~]# mkdir /u01 [root@oel4 ~]# chown oracle:oinstall /u01
oracle 유저 : vi .bash_profile
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]$ '