|
2 .bash_profile에 환경 설정값 지정 및 alias 설정
# .bash_profile
# Get the aliases and functions
if [ -f ~/.bashrc ]; then
. ~/.bashrc
fi# User specific environment and startup programs
PATH=$PATH:$HOME/bin
export PATH
unset USERNAME
export ORACLE_BASE=/oracle
export ORACLE_HOME=$ORACLE_BASE/ora92
export ORACLE_SID=PROD
export PATH=$PATH:$ORACLE_HOME/bin:
export LD_ASSUME_KERNEL=2.4.19
export LANG=en_US
export TNS_ADMIN=$ORACLE_HOME/network/admin
export ORA_NLS33=$ORACLE_HOME/ocommon/nls/admin/data
export LD_LIBRARY_PATH=$ORACLE_HOME/lib:$ORACLE_HOME/rdbms/lib
export DATA=/opt/oracle/oradata
export EDITOR=vi
export DISPLAY=192.168.100.100:0.0
# User specific aliases and functions
alias dbs='cd /oracle/ora92/dbs'
alias log='cd /oracle/admin/PROD'
alias net='cd /oracle/ora92/network/admin'
alias ss='sqlplus "/as sysdba"'
alias prod='export ORACLE_SID=PROD'
alias resp='export ORACLE_SID=RESP'
alias df='cd /opt/oracle/oradata/PROD'
3. $ORACLE_HOME/dbs/초기화 파라메터 설정 (ex - initPROD.ora)
db_name=PROD
instance_name=PROD
control_files='/opt/oracle/oradata/PROD/disk3/ctrl01.ctl'
compatible=9.2.0
sga_max_size=250m
shared_pool_size=64m
db_cache_size=64m
db_block_size=4096
large_pool_size=8m
java_pool_size=24m
remote_login_passwordfile=exclusive
job_queue_processes=10
processes=50
background_dump_dest='/oracle/admin/PROD/bdump'
user_dump_dest='/oracle/admin/PROD/udump'
core_dump_dest='/oracle/admin/PROD/cdump'
#undo_management=auto
#undo_tablespace=undotbs
log_archive_start=true
log_archive_format=PROD_%S.arc
log_archive_dest='/opt/oracle/oradata/PROD/ARCH1'
#dispatchers="(protocol=tcp)(dispatcher=2)(conn=2)(sess=3)(tick=2)"
#max_dispatchers=5
#shared_servers=2
#max_shared_servers=5
#local_listener=local
#circuits=50
#service_names=PROD,PROD.OCM,REPS,REPS.OCM,RMAN.OCM,PROD_S.OCM,PROD_CM.OCM
4. password file 생성
5. $ echo $ORACLE_SID
$ export ORACLE_SID=PROD
6. $ sqlplus '/as sysdba'
7. SQL> startup nomount
8. $ credb.sql 생성 (db생성 스크립트)
create database PROD
controlfile reuse
logfile
group 1 ('/opt/oracle/oradata/PROD/disk2/log1a.log','/opt/oracle/oradata/PROD/disk2/log1b.log')size 10m reuse,
group 2 ('/opt/oracle/oradata/PROD/disk3/log2a.log','/opt/oracle/oradata/PROD/disk3/log2b.log')size 10m reuse
maxlogfiles 5
maxlogmembers 5
maxinstances 1
maxdatafiles 50
datafile '/opt/oracle/oradata/PROD/disk1/system01.dbf' size 100m reuse
autoextend on next 10m maxsize unlimited
default temporary tablespace temp
tempfile '/opt/oracle/oradata/PROD/disk3/temp01.dbf' size 50m reuse
character set we8iso8859p1
;
9. 생성 후 확인 (select instance_name from v$instance;)
10. script 실행 ($ORACLE_HOME/rdbms/admin/catalog.sql 및 $ORACLE_HOME/rdbms/admin/catproc.sql
11. SQL> conn system/manager
SQL> $ORACLE_HOME/sqlplus/admin/pupbld.sql
- 두번째 DB 생성
1. $ echo $ORACLE_SID
$ export ORACLE_SID=RESP
2. 그 후 동일 (3~10 재수행)
- Undo Tablespace 생성 및 Archivelog mode 설정
SQL>create undo tablespace undotbs
2 datafile '/opt/oracle/oradata/PROD/disk2/undotbs01.dbf' size 50mSQL> shutdown immediate
#cd $ORACLE_HOME/dbs
# vi initPROD.ora#undo_management=auto
#undo_tablespace=undotbs 에서 # 지우기!!SQL> startup mount
SQL> alter database archivelog;
SQL> alter database open;
|