About DATABASE

1. 그룹 생성
groupadd -g 5000 dba

2. 설치폴더 생성
mkdir -p /app/oracle

3. 사용자 생성
useradd -g 5000 -u 501 -d /oracle oracle

4. 소유권 변경
chown -R oracle:dba /oracle
chmod -R 755 /oracle

5. 시스템 설정 파일 변경
vi /etc/sysctl.conf

kernel.shmall                = 2097152
kernel.shmmax                = 2147483648
kernel.shmmni                = 4096
kernel.sem                   = 250 32000 100 128
fs.file-max                  = 65536
net.ipv4.ip_local_port_range = 1024 65000
net.core.rmem_default        = 1048576
net.core.rmem_max            = 1048576
net.core.wmem_default        = 262144
net.core.wmem_max            = 262144

  (확인시)
  /sbin/sysctl -p

6.  vi /etc/security/limits.conf

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

7. vi /etc/profile

if [ $USER = "oracle10" ]; then
   ulimit -u 16384 -n 65536
fi

8.vi /etc/pam.d/login

  session  required  /lib/security/pam_limits.so

9.oracle 계정 profile 설정
umask 022
LANG=C
export ORACLE_BASE=/oracle
export ORACLE_HOME=$ORACLE_BASE
export ORACLE_SID=TESTDB
export ORACLE_TERM=vt100
export PATH=$PATH:$ORACLE_HOME/bin:/bin:/usr/bin:/sbin:/usr/ccs/bin:/usr/ucb    
export LD_LIBRARY_PATH=$ORACLE_HOME/lib:/usr/lib:$ORACLE_HOME/network/lib
export NLS_LANG=AMERICAN_AMERICA.UTF8
export ORA_NLS10=$ORACLE_HOME/nls/data
export TNS_ADMIN=$ORACLE_HOME/network/admin
export EDITOR=vi

10.설치
xmanager passive 실행
export DISPLAY=xxx.xxx.xxx.xxx:0.0

11.설치시 에러 무시
./runInstaller -ignoreSysPrereqs (10g R1 설치할때 에러가 나온다)


select instance_name, status from v$instance;

select file_name, bytes/1024/1024"MB", tablespace_name from dba_data_files;

select file_name, bytes/1024/1024"MB", tablespace_name from dba_temp_files;

select member from v$logfile;

select name from v$controlfile;