create undo tablespace undotbs2 datafile '/<path>/undotbs02.dbf' size 2000M ;
ALTER SYSTEM SET UNDO_TABLESPACE = undotbs2 scope=both;

select

tablespace_name, contents, extent_management

from dba_tablespaces where contents = 'UNDO';

select segment_name, tablespace_name, status from dba_rollback_segs order by 2;

drop tablespace undotbs1;

이올린에 북마크하기(0) 이올린에 추천하기(0)

1. oinstall, dba, oper 그룹추가
  - groupadd oinstall
  - groupadd dba
  - groupadd oper

2. oracle 유저 추가
  - useradd -g oinstall -G dba,oper oracle

3. 시스템 환경 변수 수정 및 reboot
* /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 = 262144
net.core.rmem_max = 262144
net.core.wmem_default = 262144
net.core.wmem_max = 262144

Note: Include lines only for the kernel parameter values that you
want to change. For the semaphore parameters (kernel.sem), you
must specify all four values. However, if any of the current values
are larger than the recommended value, then specify the larger
value.

* /etc/security/limits.conf
oracle soft nproc 2047
oracle hard nproc 16384
oracle soft nofile 1024
oracle hard nofile 65536

* /etc/pam.d/login
session required pam_limits.so

4. ORACLE_BASE, ORACLE_HOME, mount_point 생성
# mkdir -p /mount_point/app/oracle_sw_owner
# chown -R oracle:oinstall /mount_point/app/oracle_sw_owner
# chmod -R 775 /mount_point/app/oracle_sw_owner

5. 사용하고자 할 response 파일 수정
Response File Description
* enterprise.rsp  - Enterprise Edition installation of Oracle Database 10g
* standard.rsp    - Standard Edition installation of Oracle Database 10g
* custom.rsp      - Custom installation of Oracle Database 10g
* dbca.rsp         - Database Configuration Assistant
* netca.rsp        - Oracle Net Configuration Assistant
* emca.rsp        - Enterprise Manager Configuration Assistant

6. 설치 시작
<설치파일 위치>/runInstaller.sh -silent -responseFile <rsp File full path>

이올린에 북마크하기(0) 이올린에 추천하기(0)