Oracle instance ¸¦ 2°³ ¼³Ä¡ÇÏ´Â ¹æ¹ý
¿À¶óŬ¿¡¼ instance ¸¦ 2°³ ¼³Ä¡ÇÒ·Á¸é...? | |||||
ÀÛ¼ºÀÚ |
±è¼ö°æ(ksklab) |
ÀÛ¼ºÀÏ |
2003-12-31 00:34:39 |
Á¶È¸¼ö |
1,825 |
---|
¿À¶óŬ¿¡¼ 2°³ÀÇ instance¸¦ ¸¸µé·Á¸é ¾î¶»°Ô ÇØ¾ß Çϳª¿ä??? ÇöÀç ¿À¶óŬ 8.1.7¸¦ »ç¿ëÇÏ°í ÀÖ½À´Ï´Ù. ºÎµæÀÌ 2°³ÀÇ ÀνºÅϽº¸¦ ¸¸µé·Á±¸ Çϴµ¥ ¸¸µå´Â ¹æ¹ýÀ» ¸ô¶ó µµ¿òÀ» ¿äûÇÕ´Ï´Ù. ÀνºÅϽº¸¦ 2°³·Î ¸¸µå´Â ÀýÂ÷¸¦ ÀÚ¼¼È÷ ¾Ë·Á ÁÖ½Ã¸é °í¸¿°Ú½À´Ï´Ù. |
ÇϳªÀÇ ¼¹ö¿¡ µÎ°³ÀÇ ÀνºÅϽº¸¦ ¸¸µå½Ç·Á¸é
ÀÏ´Ü oracle user ¸¦ Çϳª ´õ »ý¼ºÇϽŴÙÀ½ ±× user profile À» ¼öÁ¤ÇϽǶ§ ¿øÇϽô oracle sid¸¦ ³Ö¾îÁֽðí , $ORACLE_HOME/dbs µð·ºÅ丮 ¾È¿¡ oracle password ÆÄÀÏÀ» »ý¼ºÇÏ½Ã¸é µË´Ï´Ù.
±×¸®°í ±âÁ¸ÀÇ 8.1.7 À» ¼³Ä¡ÇϽǶ§ ¹Þ¾Æ³õÀº db create ½ºÅ©¸³ÀÌ ÀÖÀ¸½Ã¸é ±×°É·Î µ¹¸®½Ã°í ¾øÀ¸½Ã¸é dbca ·Î ¸¸µé¾î¼Åµµ µË´Ï´Ù.
os : solaris 2.7 »ç¿ë
oracle : 8.1.7 »ç¿ë
db group¿¡ »õ·Î ¸¸µç user Ãß°¡ ½ÃÅ´
¿À¶óŬ user¸¦ Çϳª ´õ »ý¼ºÇؼ ±âÁ¸ÀÇ ¿À¶óŬ userÀÇ profile¸¦ »õ·Î ¸¸µç user¿¡ Ä«ÇÇÇÏ¿© ORACLE_SID ¸¸ »õ·Î¿î user¿¡¼ ¹Ù²Ù¾î ÁÖ¾ú½À´Ï´Ù. ³ª¸ÓÁö ¼³Á¤ºÎºÐµéÀº ±×´ë·Î ÀÔ´Ï´Ù.
±×¸®°í »õ·Î ¸¸µç user·Î dbassist ¸¦ ½ÇÇàÇÏ¿© »õ·Î¿î DB ¸¦ ¸¸µé·Á±¸ Çߴµ¥. DB¸¸µå´Â ȸ鿡¼ ¿¡·¯°¡ ³ª¸é¼ ´õÀÌ»ó ÁøÇàÀÌ ¾ÊµË´Ï´Ù.
dbassist½ÇÇà ÇÒ¶§ »õ·Î ¸¸µç °èÁ¤¿¡¼ ½ÇÇàÇÏ´ÂÁö ±Ã±ÝÇÕ´Ï´Ù.
±×¸®°í dbassist´Â ±âÁ¸¿¡ ¼³Ä¡ µÇ¾î ÀÖ´ø ¿À¶óŬÀÇ dbassist¸¦ ½ÇÇà ÇÑ°Í °°½À´Ï´Ù.
±×¸®°í dbassist¸¦ ½ÇÇàÇؼ db ¸¸µå´Â ºÎºÐ¿¡¼ °¢°¢ÀÇ db¸¸µé À§Ä¡¸¦ »õ·Î¸¸µç userȨ¿¡ ¸¸µéµµ·Ï ÀüºÎ ¼öÁ¤Çؼ ÇÏ´Â°Ô ¸Â´ÂÁöµÎ ±Ã±ÝÇÕ´Ï´Ù.
ÇÑ°¡Áö ´õ ¿À¶óŬ 8.1.7½Ãµð´Â ÇÊ¿ä°¡ ¾ø´ÂÁöµÎ ±Ã±ÝÇÕ´Ï´Ù.
½Ãµð´Â ÇÊ¿ä¾ø´Â°Í °°¾Æ¼¿ä.
ÀÌ·¸°Ô Çϴµ¥ Àß ¾ÊµÇ¾î¼ ±×·¸½À´Ï´Ù.
Á¦°¡ ÇÏ´Â ¹æ¹ýÀÌ ¸Â´ÂÁö ±Ã±ÝÇÕ´Ï´Ù.
óÀ½ Á¢ÇÏ´Â °Å¶ó¼ Àß ¸ô¶ó ¹®ÀÇ µå¸³´Ï´Ù.
ÀÌ ´ñ±ÛÀº 2004-01-01 12:06:40¿¡ ¸¶Áö¸·À¸·Î ¼öÁ¤µÇ¾ú½À´Ï´Ù.
oracle user »ý¼º -> dba group
.profile or .cshrc ¼öÁ¤ (ORACLE_SID »õ·Î¿îSID ÀÔ·Â)
initSID.ora ÆÄÀÏ »ý¼º -> ±âÁ¸ÀÇ db¿Í Ʋ¸®°Ô ÇØ¾ßµÉ ºÎºÐÀÌ ÇÊ¿ä
control file, sid ....µîµî
# svrmgrl
svrmgr> connect internal
svrmgr> startup nomount pfile=/.../pfile/initSID.ora;
svrmgr> create database "SID"
maxinstances 8
maxlogfiles
32
character set "KO16KSC5601"
national character set
"KO16KSC5601"
datafile
'/.../system01.dbf' size 500M
logfile
'/.../redo1.log' size 10M,
'/.../redo2.log' size
10M,
'/.../redo3.log' size 10M;
svrmgr> @$ORACLE_HOME/rdbms/admin/catalog.sql
svrmgr>
@$ORACLE_HOME/rdbms/admin/catproc.sql
svrmgr>
@$ORACLE_HOME/rdbms/admin/catalog6.sql
svrmgr>
@$ORACLE_HOME/rdbms/admin/catblock.sql
svrmgr>
@$ORACLE_HOME/rdbms/admin/utllockt.sql
svrmgr>
@$ORACLE_HOME/sqlplus/admin/pupbld.sql
svrmgr> connect
internal
svrmgr> CREATE tablespace rbs datafile '/.../rbs01.dbf' size
50M
default storage (
initial 128k
next
128k
pctincrease 0
);
svrmgr> create tablespace tools datafile '/.../tools01.dbf' size
20M;
svrmgr> create tablespace users datafile '/.../users01.dbf'
size 50M;
svrmgr> ALTER ROLLBACK SEGMENT R01 OFFLINE ;
svrmgr>
ALTER ROLLBACK SEGMENT R02 OFFLINE ;
svrmgr> DROP ROLLBACK SEGMENT R01
;
svrmgr> DROP ROLLBACK SEGMENT R02 ;
svrmgr> CREATE ROLLBACK
SEGMENT R01 TABLESPACE RBS STORAGE(INITIAL 10M NEXT 5M) ;
svrmgr> CREATE
ROLLBACK SEGMENT R02 TABLESPACE RBS STORAGE(INITIAL 10M NEXT 5M) ;
svrmgr>
ALTER ROLLBACK SEGMENT R01 ONLINE;
svrmgr> ALTER ROLLBACK SEGMENT R02
ONLINE;
svrmgr> alter database mount;
svrmgr> alter database start;
svrmgr> exit
cd $ORACLE_HOME/network/admin
vi listener.ora
»õ·Î¿î listener »ý¼º
lsnrctl start »õ·Î¿îlistener
¿À¶óŬ user¸¦ Çϳª ´õ »ý¼ºÇؼ ±âÁ¸ÀÇ ¿À¶óŬ userÀÇ profile¸¦ »õ·Î ¸¸µç user¿¡ Ä«ÇÇÇÏ¿© ORACLE_SID ¸¸ »õ·Î¿î user¿¡¼ ¹Ù²Ù¾î ÁÖ¾ú½À´Ï´Ù. ³ª¸ÓÁö ¼³Á¤ºÎºÐµéÀº ±×´ë·Î ÀÔ´Ï´Ù.
±×¸®°í »õ·Î ¸¸µç user·Î dbassist ¸¦ ½ÇÇàÇÏ¿© »õ·Î¿î DB ¸¦ ¸¸µé·Á±¸ Çߴµ¥. DB¸¸µå´Â ȸ鿡¼ ¿¡·¯°¡ ³ª¸é¼ ´õÀÌ»ó ÁøÇàÀÌ ¾ÊµË´Ï´Ù.
[´äº¯]
¾Æ¸¶ db createÇÏ´Â °úÁ¤À» write ÇÏ´Â log°¡ µÎ¹ø° µðºñ¸¦ »ý¼ºÇÏ´Â À¯´Ð½º À¯Àú°¡ ±ÇÇÑÀÌ ¾ø¾î¼ ÀÏ °Ì´Ï´Ù.
$ORACLE_HOME/install/log/ ¹Ø¿¡ º¸½Ã¸é
·Î±× ÆÄÀÏÀÌ ÀÖÀ» °Çµ¥, µÎ¹ø° »ý¼ºÇÏ´Â À¯´Ð½º À¯Àú°¡
log µð·ºÅ丮¿¡ ÀÖ´Â ÆÄÀϵé write ÇÏ´Â ±ÇÇÑÀÌ ÀÖ¾î¾ß ÇÕ´Ï´Ù.
chmod 664 $ORACLE_HOME/install/log/* ÇϽðí
dbassist ·Î dbcreate ÇÏ½Ã¸é µË´Ï´Ù.