Oracle8 Administrator's Reference for LINUX
Release 8.0.5

A66585-01

Library

Product

Contents

Index

Prev Next

1
Optimal Flexible Architecture on Oracle8

Optimal Flexible Architecture (OFA)

¿À¶óŬ»ç´Â Oracle8À» À§ÇÑ OFA (Optimal Flexible Architecture) Ç¥ÁØÀ» ±ÇÀåÇÏ°í ÀÖ´Ù. OFA Ç¥ÁؾÈÀº À¯Áöº¸¼ö°¡ °ÅÀÇ ÇÊ¿ä¾ø´Â, ºü¸£°í ¾ÈÀüÇÑ ¿À¶óŬ µ¥ÀÌÅͺ£À̽º¸¦ À§ÇÑ ¼³Á¤ °¡À̵å¶óÀÎÀÇ ÁýÇÕÀ» ¸»ÇÑ´Ù.

OFA´Â ´ÙÀ½°ú °°ÀÌ ¼³°èµÇ¾îÁ® ÀÖ´Ù:

OFA¸¦ µû¸£´Â (OFA-Compliant) µ¥ÀÌÅͺ£À̽ºÀÇ Æ¯Â¡

OFA¸¦ µû¸£´Â µ¥ÀÌÅͺ£À̽º´Â ´ÙÀ½°ú °°Àº ÀåÁ¡À» °¡Áø´Ù:

File System ±¸¼º

File systemÀº °ü¸®°¡ ½¬¿ì¸ç, Å©´õ¶óµµ ÀûÀÀÇÒ¼ö ÀÖµµ·Ï µÇ¾î ÀÖ´Ù:

ÀÔÃâ·Â ºÎÇÏ (I/O load)ÀÇ ºÐ»ê

º´¸ñÇö»óÀ» ¸·±âÀ§ÇÏ¿© ÃæºÐÇÑ µð½ºÅ©µå¶óÀ̺갣¿¡ ÀÔÃâ·ÂÀ» ºÐ»ê½ÃŲ´Ù.

Çϵå¿þ¾î Áö¿ø

Çϵå¿þ¾î ºñ¿ëÀº ¿î¿µ°ü¸® ¹®Á¦¿Í Ãæµ¹À» ÇÏÁö ¾ÊÀ» ¶§ ÃÖ¼ÒÈ­µÈ´Ù.

µå¶óÀÌºê ¿¡·¯ ¹ß»ý½Ã ¾ÈÁ¤¸Á ¿ªÇÒ

ÇÑ°³ ÀÌ»óÀÇ µå¶óÀ̺꿡 ºÐ»ê½ÃÅ´À¸·Î¼­ µå¶óÀÌºê ¿¡·¯°¡ ¹ß»ýÇصµ ÃÖ¼ÒÇÑÀÇ ÇÇÇظ¦ ´çÇϵµ·Ï ÇÑ´Ù.

Home directoryÀÇ ºÐ»ê

´ÙÀ½ Ç׸ñÀº ÇÑ°³ÀÌ»óÀÇ µå¶óÀ̺꿡 ºÐ»êµÇ¾î ÀÖ´Ù:

·Î±×ÀΠȨ µð·ºÅ丮ÀÇ ¹«°á¼º (Integrity)

·Î±×ÀΠȨ µð·ºÅ丮¸¦ ±×µéÀ» ÂüÁ¶ÇÏ´Â ÇÁ·Î±×·¥À» ¼öÁ¤ÇÏÁö ¾Ê°í, Ãß°¡ÇÏ°í ¿Å±â°í ¶Ç´Â Áö¿ì´Â °ÍÀÌ °¡´ÉÇÏ´Ù.

LINUX Directory SubtreesÀÇ µ¶¸³

ÆÄÀÏÀÇ Ä¿Å×°í¸®´Â µ¶¸³µÈ ¸®´ª½º µå·ºÅ丮 subtree·Î ºÐ¸®µÇ¾î ÀÖ´Ù. ±× ¶§¹®¿¡ ÇÑ Ä¿Å×°í¸®³»ÀÇ ÆÄÀϵéÀº ´Ù¸¥ Ä¿Å×°í¸®ÀÇ ÆÄÀÏ¿¡ ´ëÇÑ Á¶ÀÛ¿¡ ÀÇÇØ ÃÖ¼ÒÇÑÀ¸·Î ¿µÇâÀ» ¹Þ´Â´Ù.

ÀÀ¿ë ¼ÒÇÁÆ®¿þ¾îÀÇ µ¿½Ã ¼öÇàÀ» Áö¿ø

µ¿½Ã¿¡ ¿©·¯ ¹öÀüÀÇ ÀÀ¿ë ÇÁ·Î±×·¥ÀÌ ½ÇÇàµÉ ¼ö ÀÖÀ¸¸ç, »ç¿ëÀÚ°¡ ÀÌÀü ¹öÀüÀ» ¹ö¸®±â Àü¿¡ »õ·Î¿î ¹èÆ÷ÆÇÀ» Å×½ºÆ®ÇÏ°í »ç¿ëÇØ º¼¼ö ÀÖ´Ù. ¾÷±×·¹À̵å ÈÄ¿¡ »õ·Î¿î ¹öÀüÀ¸·Î ¿Å°Ü °¡´Â°ÍÀº °ü¸®ÀÚ¿¡°Ô´Â ´Ü¼øÇÏ°í »ç¿ëÀÚ¿¡°Ô´Â ¼Õ½¬¿î ÀÏÀÌ´Ù.

°¢°¢ÀÇ µ¥ÀÌÅͺ£À̽º¿¡ ´ëÇÑ °ü¸®Á¤º¸¸¦ ±¸º°

´Ù¸¥ µ¥ÀÌÅͺ£À̽º·Î ºÎÅÍ ÇÑ µ¥ÀÌÅͺ£À̽º¿¡ °üÇÑ °ü¸® Á¤º¸¸¦ ºÐ¸®ÇÒ ¼ö ÀÖ´Â ´É·ÂÀº °ü¸® ÀÚ·áÀÇ ÀúÀå°ú ±¸¼ºÀ» À§ÇÑ ÇÕ¸®ÀûÀÎ ±¸Á¶¸¦ °¡´ÉÇÏ°Ô ÇÑ´Ù.

ÀÏ°ýÀûÀÎ µ¥ÀÌÅͺ£À̽º ÆÄÀÏ À̸§À» »ç¿ë

µ¥ÀÌÅͺ£À̽º ÆÄÀÏÀ» ´ÙÀ½°ú °°ÀÌ À̸§ Áö¾î Áø´Ù:

Tablespace ³»¿ëÀÇ ºÐ¸®

Tablespace³»¿ëÀº ´ÙÀ½°ú °°ÀÌ ºÐ¸®µÇ¾î ÀÖ´Ù:

¸ðµç µå¶óÀ̺꿡 °ÉÃļ­ ÀÔÃâ·Â ºÎÇÏÀÇ Á¶Àý

I/O loads´Â ¿À¶óŬ ÀڷḦ ÀúÀåÇÏ´Â µå¶óÀ̺긦 Æ÷ÇÔÇÏ¿©, ¸ðµç µå¶óÀ̺꿡 °ÉÃļ­ Á¶ÀýµÇ¾î Áø´Ù.

º´·Ä ¼­¹ö ¼³Ä¡½Ã OFAÀÇ ÀÌÁ¡

¿À¶óŬ º´·Ä ¼­¹ö ÀνºÅçÀ» À§ÇÏ¿©:

¸®´ª½º¿ë Oracle8¿¡¼­ÀÇ OFAÀÇ ±¸Çö

µ¥ÀÌÅͺ£À̽º ÆÄÀÏ¿¡ ´ëÇÑ Á¶½É½º·¯¿î ¸í¸í¹ýÀº °ü¸®»óÀÇ ¹®Á¦¸¦ ¸¹ÀÌ ÁÙ¿© ÁØ´Ù. OFA ±ÔÄ¢Àº ¿ø·¡ÀÇ OFA ±ÇÀå »çÇ×À» The OFA Standard: Oracle8 for Open Systems¿¡ Á¦°øµÈ´Ù.

Naming Mount Points

Mount Point Syntax

¸ðµç mount pointÀÇ À̸§Àº /pm, ±¸¹®À» »ç¿ëÇؼ­ À̸§ ºÙ¿©¶ó. ¿©±â¼­ p´Â ¹®ÀÚ »ó¼öÀÌ°í mÀº À¯ÀÏÇÑ °íÁ¤±æÀÌÀÇ key (ÀüÇüÀûÀ¸·Î 2ÀÚ¸® ¼ýÀÚ)°¡ mount point¸¦ ±¸ºÐÇϱâ À§Çؼ­ »ç¿ëµÈ´Ù. ¿¹¸¦ µé¸é: /u01 °ú /u02, ¶Ç´Â /disk01 °ú /disk02.

Naming Mount Points for Very Large Databases (VLDBs)

¸¸¾à °¢°¢ÀÇ µð½ºÅ© µå¶óÀ̺갡 ÇϳªÀÇ ÀÀ¿ë ÇÁ·Î±×·¥ÀÇ µ¥ÀÌŸº£À̽º ÆÄÀÏÀ» Æ÷ÇÔÇÏ°í ÀÖ°í °¢°¢ÀÇ µ¥ÀÌŸº£À̽º¸¦ À§ÇØ ÀÔÃâ·Â º´¸ñÇö»óÀÌ ³ªÅ¸³ªÁö ¾ÊÀ» Á¤µµ·Î ÃæºÐÇÑ µð½ºÅ© µå¶óÀ̺긦 °¡Áö°í ÀÖ´Ù¸é mount point À̸§À» ºÙÀ̴µ¥ Table 1-1¿¡ ¼³¸íµÈ °Íó·³ /q/dm ¹®¹ýÀ» »ç¿ëÇ϶ó.

Table 1-1 Syntax for Naming Mount Points

q

 

¿À¶óŬ µ¥ÀÌŸ°¡ ÀúÀåµÇ´Â °÷À» ¸í½Ã

 

dm

 

DB_NAME ÀÎÀÚÀÇ ÃʱâÈ­ °ª ( ÇϳªÀÇ ÀνºÅϽº µ¥ÀÌÅͺ£À̽º ½Ã½ºÅÛ¿¡¼­´Â sid¿Í µ¿ÀǾîÀÌ´Ù )

 

¿¹¸¦ µé¸é, /u01/oradata/test01°ú /u01/oradata/test02¶ó´Â À̸§ÀÇ mount point´Â ¿À¶óŬÀÇ Å×½ºÆ®¿ë µ¥ÀÌÅͺ£À̽º¸¦ À§ÇÏ¿© ÇÒ´çÇÑ´Ù.

Naming Directories

Home Directory Syntax

Name home directories´Â Table 1-2¿¡ ¼³¸íµÈ °Í ó·³ /pm/h/u ¹®¹ýÀ» »ç¿ëÇÑ´Ù.

Table 1-2 Syntax for Naming Home Directories

pm

 

a mount point name

 

h

 

Ç¥ÁØ µð·ºÅ丮 À̸§

 

u

 

µð·ºÅ丮 ¼ÒÀ¯ÀÚÀÇ À̸§

 

¿¹¸¦ µé¸é, /u01/app/oracle Àº ¿À¶óŬ ¼­¹ö ¼ÒÀ¯ÀÚÀÇ È¨µð·ºÅ丮ÀÌ´Ù. (ORACLE_BASE·Î ºÎ¸£±âµµ Çϸç, Installer¿¡ ÀÇÇØ ±âº»ÀûÀ¸·Î ¼³Á¤µÈ´Ù) ±×¸®°í /u01/app/applmgr´Â ¿À¶óŬ ÀÀ¿ë ¼ÒÇÁÆ®¿þ¾îÀÇ ¼ÒÀ¯ÀÚÀÇ È¨ µð·ºÅ丮ÀÌ´Ù.

Ȩµð·ºÅ丮¸¦ ¸®´ª½º ÆÄÀÏ ½Ã½ºÅÛ¿¡¼­ °°Àº ·¹º§¿¡ µÎ´Â °ÍÀÌ ´ÙÀ½°ú °°Àº ÀÌÀ¯·Î À¯¸®ÇÏ´Ù: ±×·¸°Ô ÇÔÀ¸·Î½á ÀÀ¿ë ÇÁ·Î±×·¥ÀÇ ¼ÒÀ¯ÀÚ ·Î±×ÀΠȨµð·ºÅ丮°¡ ¼­·Î ´Ù¸¥ mount point »ó¿¡ ³õÀÌ´õ¶óµµ, ´ÜÀÏ ÆÐÅÏÀÇ ¹®ÀÚ¿­·Î, Áï /*/app/*¿Í °°Àº, À̵éÀ» ãÀ» ¼ö ÀÖ´Ù.

°æ·Î¸í ÂüÁ¶Çϱâ

±×µéÀ» ÀúÀåÇϱâ À§ÇØ Æ¯º°ÇÏ°Ô µðÀÚÀÎµÈ ÆÄÀϸ¸, ¿¹¸¦ µé¸é /etc/passwd ±×¸®°í ¿À¶óŬÀÇ oratab file µî°ú °°Àº, ¸í¹éÇÑ °æ·Î¸íÀ» ÂüÁ¶Ç϶ó. ±×·ìÀÇ ÇöȲÀº /etc/group file ¸¸À» ÀÌ¿ëÇ϶ó.

Software Directories

µ¿½Ã¿¡ ¿©·¯¹öÀüÀÇ ÀÀ¿ë ¼ÒÇÁÆ®¿þ¾î°¡ OFAÀÇ ¿ä±¸»ç¾çÀ» µû¸£¸é¼­ ½ÇÇàµÉ ¼ö ÀÖµµ·Ï Çϱâ À§ÇÏ¿©, °¢ ¹öÀüÀÇ Oracle8 Server ¼ÒÇÁÆ®¿þ¾î¸¦, Table 1-3¿¡¼­ ¼³¸íÇÑ °Íó·³, ÆÐÅÏ /pm/h/product/v¿¡ ¸ÅĪ µÉ ¼ö ÀÖµµ·Ï °¢ µð·ºÅ丮¿¡ ÀúÀåÇÑ´Ù.

Table 1-3 Oracle8 Server ¼ÒÇÁÆ®¿þ¾î µð·ºÅ丮¸¦ ¸í¸íÇÏ´Â ¹®¹ý

h

 

Ç¥ÁØ µð·ºÅ丮 À̸§

 

v

 

¼ÒÇÁÆ®¿þ¾îÀÇ ¹öÀü

 
.

¿¹¸¦ µé¸é: /u01/app/oracle/product/8.0.5´Â Oracle8 ¼­¹ö ÆÄÀÏÀÌ À§Ä¡ÇÑ µð·ºÅ丮 ±¸Á¶ÀÇ ½ÃÀۺκÐÀ» °¡¸£Å²´Ù. ORACLE_HOME ȯ°æº¯¼ö¸¦ ÀÌ°÷À¸·Î ¼³Á¤Ç϶ó.

Naming Files

Administration Files

°ü¸® ÀÚ·áÀÇ ±¸¼ºÀ» ¿ëÀÌÇÏ°Ô Çϱâ À§ÇÏ¿©, µ¥ÀÌÅͺ£À̽º¿¡ ƯÀÌÀûÀÎ °ü¸® ÆÄÀϵéÀº h/admin/d/a/¿Í °°Àº ¼­ºêµð·ºÅ丮¿¡ ÀúÀåÇØ µÎ¶ó. ¿©±â¼­ h´Â ¿À¶óŬ ¼ÒÇÁÆ®¿þ¾î ¼ÒÀ¯ÀÚÀÇ È¨ µð·ºÅ丮À̸ç, d´Â µ¥ÀÌÅͺ£À̽º À̸§(DB_NAME)À̸ç, a´Â Table 1-4¿¡ ±â¼úµÇ¾î ÀÖ´Â °¢°¢ÀÇ µ¥ÀÌÅͺ£À̽º °ü¸® ÆÄÀÏÀ» À§ÇÑ ¼­ºêµð·ºÅ丮ÀÌ´Ù.

Table 1-4 µ¥ÀÌÅͺ£À̽º °ü¸® ÆÄÀÏÀ» À§ÇÑ ¼­ºêµð·ºÅ丮µé

adhoc

 

ÁÖ¾îÁø µ¥ÀÌÅͺ£À̽º¿¡ ´ëÇÑ ad hoc SQL scripts

 

arch

 

archived redo log files

 

adump

 

audit files
(ÀÌ°ÍÀÇ À§Ä¡¸¦ ÁöÁ¤Çϱâ À§ÇÏ¿© configdb_name.ora¿¡ ÀÖ´Â AUDIT_FILE_DEST¸¦ ¼³Á¤Ç϶ó. ÀÌ µð·ºÅ丮´Â ÀÏÁ¤½Ã°£ °£°ÝÀ¸·Î Áö¿öÁø´Ù).

 

bdump

 

background process trace files

 

cdump

 

core dump files

 

create

 

µ¥ÀÌÅͺ£À̽º »ý¼ºÀ» À§ÇØ »ç¿ëµÇ´Â ÇÁ·Î±×·¥µé

 

exp

 

database export files

 

logbook

 

µ¥ÀÌÅͺ£À̽ºÀÇ »óÅÂ¿Í history¸¦ ±â·ÏÇÏ´Â ÆÄÀϵé

 

pfile

 

instance parameter files

 

udump

 

user SQL trace files

 

¿¹¸¦ µé¸é, adhoc ¼­ºêµð·ºÅ丮´Â /u01/app/oracle/admin/sab/adhoc/¿Í °°Àº °æ·Î¸íÀ» °¡Áö°Ô µÈ´Ù.

Database Files

´ÙÀ½ÀÇ µ¥ÀÌÅͺ£À̽º ÆÄÀÏÀÇ ¸í¸í¹ýÀº ÆÄÀϵéÀ» ¼Õ½±°Ô ±¸º°ÇÒ ¼ö ÀÖµµ·Ï µÇ¾î ÀÖ´Ù:

¹®¹ýÀº Table 1-5¿¡ ¼³¸íµÇ¾î ÀÖ´Ù.

Table 1-5 Syntax for Naming Database Files

pm

 

Mount point nameÀº ÀÌ ÀåÀÇ ÃʹݺκÐÀÌ ±â¼úµÇ¾î ÀÖ´Ù.

 

q

 

Oracle data¸¦ ´Ù¸¥ ÆÄÀϵé°ú ±¸ºÐÇÏ´Â ¹®ÀÚ¿­ (ÀϹÝÀûÀ¸·Î ORACLE ¶Ç´Â oradata¸¦ »ç¿ëÇÑ´Ù)

 

d

 

µ¥ÀÌÅͺ£À̽ºÀÇ DB_NAME

 

t

 

Oracle tablespace name

 

n

 

two-digit string

 


Note:

/pm/q/d¿¡´Â µ¥ÀÌÅͺ£À̽º¿Í °ü·ÃµÈ control, redo log ¶Ç´Â data file¿Ü´Â ÀúÀåÇÏÁö ¸¶¶ó.

 

ÀÌ·¯ÇÑ ÀϹÝÀûÀÎ ¸í¸í¹ýÀ» µû¸£°Ô µÇ¸é /u03/oradata/sab/system01.dbf¿Í °°Àº À̸§ÀÌ »ý¼ºµÇ°Ô µÇ´Âµ¥ ÀÌ´Â À̸§¸¸ º¸¾Æµµ ¾î´À µ¥ÀÌÅͺ£À̽º¿¡ ¼ÓÇÏ°Ô µÇ´ÂÁö ½±°Ô ¾Ë¼ö ÀÖ´Ù.

Separate Segments with Different Requirements

ÁÖ±âÀÇ ´Ù¾ç¼º, ÀÔÃâ·Â ¿ä±¸, ±×¸®°í ¹é¾÷ºóµµ µî¿¡ µû¶ó ´Ù¸¥ tablespace·Î ºÐ¸®Ç϶ó.

°¢°¢ÀÇ ¿À¶óŬ µ¥ÀÌÅͺ£À̽º¿¡¼­, Table 1-6¿¡ ¸í½ÃµÈ Ư¼öÇÑ tablespace¸¦ ¸¸µé¾î¶ó. À̵é tablespaces´Â ÀÀ¿ë ¼¼±×¸ÕÆ®¿¡¼­µµ ÇÊ¿äÇÑ ¿ä¼ÒµéÀÌ´Ù.

Table 1-6 Special Tablespace

SYSTEM

 

data dictionary segments

 

TEMP

 

temporary segments

 

RBS

 

rollback segments

 

TOOLS

 

general-purpose tools

 

USERS

 

miscellaneous user segments

 

µñ¼Å³Ê¸® ¼¼±×¸ÕÆ®´Â Àý´ë·Î µå¶øµÇÁö ¾Ê±â ¶§¹®¿¡ ÀÌ°ÍÀº ¹«Ã´ È¿°úÀûÀÎ ¹æ¹ýÀ̸ç, SYSTEM tablespace¿¡¼­´Â µå¶øÀ» Çã¿ëÇÏÁö ¾Ê´Â´Ù. ÀÌ°ÍÀº SYSTEM tablespace°¡ ºó°ø°£ÀÇ ºÐÇÒ(fragmentation)À¸·Î ÀÎÇÑ À缳ġ(rebuild)¸¦ ÇÊ¿ä·Î ÇÏÁö ¾Ê´Â´Ù´Â °ÍÀÌ´Ù.

rollback ¼¼±×¸ÕÆ®´Â ÀÀ¿ëÇÁ·Î±×·¥ µ¥ÀÌŸ¸¦ ÀúÀåÇÏ°í ÀÖ´Â tablespace¿¡ ÀúÀåµÇÁö ¾Ê±â ¶§¹®¿¡, °ü¸®ÀÚ´Â À¯Áöº¸¼ö¸¦ À§ÇØ ÀÀ¿ëÇÁ·Î±×·¥ÀÇ ÀڷḦ °¡Áö°í ÀÖ´Â tablespace·Î offline »óÅ¿¡¼­ Á¢±ÙÇϴµ¥ ¹æÇØ ¹ÞÁö ¾Ê´Â´Ù. ¼¼±×¸ÕÆ®´Â type¿¡ ÀÇÇØ ¹°¸®ÀûÀ¸·Î ºÐÇҵǾî ÀÖÀ¸¸ç, ±×¸®°í °ü¸®ÀÚ´Â º¹ÀâÇÑ Åø¾øÀ̵µ ÀÚ·áÀÇ ¼ºÀå ¼Óµµ¸¦ ¿¹ÃøÇÏ°í ±â·ÏÇÒ ¼ö ÀÖ´Ù.

Naming Tablespaces

À̸§ tablespaces´Â ÃÖ´ë 8±ÛÀÚ¸¦ ÀÌ¿ëÇÑ´Ù.

ºñ·Ï Oracle8 tablespace À̸§ÀÌ 30ÀÚ±îÁö Çã¿ëµÇÁö¸¸, Linux·Î Æ÷ÆõǸ鼭 ÆÄÀÏ À̸§Àº 14ÀÚ·Î ÇÑÁ¤µÇ¾î ÀÖ´Ù. ±ÇÀåÇÏ´Â µ¥ÀÌŸ ÆÄÀÏÀÇ ±âº»ÀûÀÎ À̸§Àº tn.dbfÀÌ´Ù. ¿©±â¼­ t´Â tablespace À̸§À» ÀûÀ¸¸ç, nÀº µÎÀÚ¸®¼öÀÇ ¼ýÀÚ¹®ÀÚ¿­ÀÌ´Ù. È®ÀåÀÚ+µÎÀÚ¸® ¼ýÀÚ´Â ÃÑ 6ÀÚ¸¦ Â÷ÁöÇϱ⠶§¹®¿¡ ½ÇÁ¦ÀûÀ¸·Î tablespace À̸§À» À§ÇÏ¿© 8ÀÚ¸¸À» ÀÌ¿ëÇÒ ¼ö ÀÖ´Ù.

µ¥ÀÌŸ ÆÄÀÏÀÇ À̸§À¸·Î Çã¿ëµÇ´Â À̸§Àº ±×°ÍÀÌ ÀÌ¿ëÇÏ´Â tablespace¿Í ¿¬°üÀÌ ÀÖ´Ù. ¿¹¸¦ µé¸é, GLD¿Í GLX´Â °¢°¢ µ¥ÀÌŸ¿Í À妽º¸¦ ÀúÀåÇÏ´Â tablespaces¿¡ ÀÌ¿ëµÈ´Ù.


Note:

tablespaceÀÇ À̸§¿¡ "tablespace" ¶ó´Â ´Ü¾î´Â »ç¿ëÇÏÁö ¸¶¶ó. Tablespaces´Â context¿¡ ÀÇÇØ ±¸º°°¡´ÉÇϸç, ±×¸®°í À̸§Àº type¿¡ °üÇÑ Á¤º¸¸¦ Æ÷ÇÔÇÒ ÇÊ¿ä´Â ¾ø´Ù.

 

Oracle ÆÄÀÏ¿¡¼­ OFA Structure ÀÌ¿ëÇϱâ

Table 1-7 ¿¡´Â ÆÄÀÏÀÇ class¸¦ È®ÀÎÇϴµ¥ ÀÌ¿ëÇÏ´Â ¹®¹ý(syntax)¸¦ º¸¿©ÁÖ°í ÀÖ´Ù.

Table 1-7 Directory Structure Syntax for Identifying Classes of Files

/u[0-9][0-9]

 

user data directories

 

/*/home/*

 

user home directories

 

/*/app/*

 

user application software directories

 

/*/app/applmgr

 

Oracle apps software subtrees

 

/*/app/oracle/product

 

Oracle Server software subtrees

 

/*/app/oracle/product/8.0.5

 

Oracle Server 8.0.5 distribution files

 

/*/app/oracle/admin/sab

 

sab database administrative subtrees

 

/*/app/oracle/admin/sab/arch/*

 

sab database archived log files

 

/*/oradata

 

Oracle data directories

 

/*/oradata/sab/*

 

sab database files

 

/*/oradata/sab/*.log

 

sab database redo log files

 

OFA File Mapping

Table 1-8Àº °¢ ÆÄÀÏÀÇ mount point, ÀÀ¿ëÇÁ·Î±×·¥, µ¥ÀÌÅͺ£À̽º ±×¸®°í tablespace µîÀ» Æ÷ÇÔÇÏ´Â, OFA¸¦ µû¸£´Â µ¥ÀÌÅͺ£À̽º »ùÇÃÀÇ °èÃþÀûÀÎ ÆÄÀÏ Áöµµ¸¦ º¸¿©ÁÖ°í ÀÖ´Ù. ÆÄÀÏ À̸§Àº ÆÄÀÏ type (control, log ¶Ç´Â µ¥ÀÌŸ)À» °¡¸£Å²´Ù.

Table 1-8 Hierarchical File Mapping for OFA Installation

/

 

 

 

 

 

 

root mount point

 

 

u01/

 

 

 

 

 

'user data' mount point #1

 

 

 

app/

 

 

 

 

subtree for app software

 

 

 

 

oracle/

 

 

 

home for oracle software owner

 

 

 

 

 

admin/

 

 

subtree for database admin files

 

 

 

 

 

 

TAR/

 

subtree for Support logs

 

 

 

 

 

 

db_name1/

 

admin subtree for db_name1 database

 

 

 

 

 

 

db_name2/

 

admin subtree for db_name2 database

 

 

 

 

 

doc/

 

 

online documentation

 

 

 

 

 

local/

 

 

subtree for local Oracle software

 

 

 

 

 

 

aps6/

 

an Oracle6 admin package

 

 

 

 

 

 

aps7/

 

an Oracle7 admin package

 

 

 

 

 

product/

 

 

distribution files

 

 

 

 

 

 

7.3.2/

 

ORACLE_HOME for 7.3.2 instances

 

 

 

 

 

 

7.3.3/

 

ORACLE_HOME for 7.3.3 instances

 

 

 

 

 

 

8.0.4/

 

ORACLE_HOME for 8.0.4 instances

 

 

 

home/

 

 

 

 

subtree for login home directories

 

 

 

 

ltb/

 

 

 

home for a user

 

 

 

 

sbm/

 

 

 

home for a user

 

 

 

oradata/

 

 

 

 

subtree for Oracle data

 

 

 

 

db_name1/

 

 

 

subtree for db_name1 database files

 

 

 

 

db_name2/

 

 

 

subtree for db_name2 database files

 

 

u02/

 

 

 

 

 

'user data' mount point #2

 

 

 

home/

 

 

 

 

subtree for login home directories

 

 

 

 

cvm/

 

 

 

home for a user

 

 

 

 

vrm/

 

 

 

home for a user

 

 

 

oradata/

 

 

 

 

subtree for Oracle data

 

 

 

 

db_name1/

 

 

 

subtree for db_name1 database files

 

 

 

 

db_name2/

 

 

 

subtree for db_name2 database files

 

 

u03/

 

 

 

 

 

'user data' mount point #3

 

 

 

home/

 

 

 

 

subtree for login home directories

 

 

 

oradata/

 

 

 

 

subtree for Oracle data

 

 

 

 

db_name1/

 

 

 

subtree for db_name1 database files

 

 

 

 

db_name2/

 

 

 

subtree for db_name2 database files

 

Raw Device Sizes

Oracle µ¥ÀÌÅͺ£À̽º ÆÄÀϵéÀ» ÀúÀåÇϴµ¥ ÀÌ¿ëÇÒ ¸ðµç raw deviceÀÇ Ç¥ÁØ Å©±âÀÇ ¼³Á¤À» ¼±ÅÃ.

ÀϹÝÀûÀ¸·Î, songle size¿¡ ´ëÇÑ Ç¥ÁØÈ­¸¦ ±ÇÀåÇÑ´Ù. ¸¸¾à single size°¡ ÀÌ¿ëµÇ¸é, raw ÆÄÀÏÀº ÇÑ ÆÄƼ¼Ç¿¡¼­ ´Ù¸¥ °÷À¸·Î ¾ÈÀüÇÏ°Ô ¿Å°ÜÁú ¼ö ÀÖ´Ù. Å©±â´Â ²Ï Å« ¼ö¸¦ »ý¼ºÇÒ ¼ö ÀÖµµ·Ï ÃæºÐÈ÷ ÀÛ¾Æ¾ß ÇÏ°í, ¹Ý´ë·Î Æí¸®ÇÒ Á¤µµ·Î ÃæºÐÈ÷ Å©¾ß ÇÑ´Ù.

¿¹¸¦ µé¸é, 2 GB µå¶óÀ̺ê´Â 200 MB ¾¿ÀÇ 10°³ÀÇ ÆÄƼ¼ÇÀ¸·Î ³ª´©´Â °ÍÀÌ Å©±â¿Í ¼ýÀÚ¿¡ À־ ±ÕÇüÀ» ¸ÂÃß´Â °ÍÀÏ °ÍÀÌ´Ù. raw device¸¦ ÀÌ¿ëÇÏ´Â ¸ðµç tablespace´Â ¸î°³ÀÇ µå¶óÀ̺ê·Î ³ª´µ¾î Áø´Ù. ¸¸¾à °¡´ÉÇÏ´Ù¸é, ÀÌ ³ª´©±â´Â logical volume manager·Î ÇÏ´Â °ÍÀÌ ÁÁ´Ù.

File Mapping for Multiple-Instance OFA Database

´ÙÁß ÀνºÅϽºÀÇ µ¥ÀÌÅÍ º£À̽º´Â (¿À¶óŬ º´·Ä ¼­¹ö ¼³Ä¡) Ãß°¡ÀûÀÎ ÆÄÀÏ ¸ÊÇÎÀÌ ÇÊ¿äÇÏ´Ù.

Administrative Home for Oracle Parallel Server

¿À¶óŬ º´·Ä¼­¹ö¸¦ ÀÌ¿ëÇÒ °æ¿ì, ÇϳªÀÇ ¼­¹ö¸¦ ±× Áý´ÜÀÇ Oracle administrative homeÀ¸·Î µ¿ÀÛÇϵµ·Ï ¼±ÅÃÇÑ´Ù. administrative home¿¡´Â administrative subtree¸¦ Æ÷ÇÔÇÑ´Ù. °¢°¢ÀÇ ÀνºÅϽº¿¡ ÀÖ´Â ~/admin/d/ µð·ºÅ丮¿¡ ÀÖ´Â bdump, cdump, logbook, pfile ±×¸®°í udump µð·ºÅ丮¿¡ ÀÖ´Â µ¥ÀÌÅͺ£À̽º·Î Á¢±ÙÇϱâ À§ÇÑ ¼­ºêµð·ºÅ丮¸¦ »ý¼ºÇÑ´Ù. administrative homeÀÇ The admin directory´Â ¸ðµç ÀνºÅϽºÀÇ admin directory·Î¼­ ¸¶¿îÆ®µÇ¾î¾ß ÇÑ´Ù. Table 1-9¿¡ ¿¹¸¦ µé¾î ¼³¸íÇØ µÎ¾ú´Ù.

Table 1-9 Administrative Directory Structure for Dual-Instance Oracle Parallel Server

u01/

 

app/oracle/admin/sab/

 

 

administrative directory for sab database

 

 

adhoc/

 

 

 

directory for miscellaneous scripts

 

 

arch/

 

 

 

log archive dest for all instances

 

 

 

redo001.arc

 

 

archived redo log file

 

 

bdump/

 

 

 

directory for background dump files

 

 

 

inst1/

 

 

background dump dest for inst1 instance

 

 

 

inst2/

 

 

background dump dest for inst2 instance

 

 

cdump/

 

 

 

directory for core dump files

 

 

 

inst1/

 

 

core dump dest for inst1 instance

 

 

 

inst2/

 

 

core dump dest for inst2 instance

 

 

create/

 

 

 

directory for creation scripts

 

 

 

1-rdbms.sql

 

 

SQL script to create inst database

 

 

exp/

 

 

 

directory for exports

 

 

 

970920full.dmp

 

 

Sept 20 full export dump file

 

 

 

export/

 

 

directory for export parfiles

 

 

 

import/

 

 

directory for import parfiles

 

 

logbook/

 

 

 

directory for inst logbook entries

 

 

 

inst1/

 

 

directory for inst1 instance reports

 

 

 

 

params.lst

 

v$parameter report for inst1 instance

 

 

 

inst2/

 

 

directory for inst2 instance reports

 

 

 

 

params.lst

 

v$parameter report for inst2 instance

 

 

 

user.lst

 

 

dba_users report

 

 

pfile/

 

 

 

directory for instance parameter files

 

 

 

inst1/

 

 

directory for inst1 instance parameters

 

 

 

 

init

 

instance parameters for inst1 instance

 

 

 

inst2/

 

 

directory for inst2 instance parameters

 

 

 

 

init

 

instance parameters for inst2 instance

 

 

udump/

 

 

 

directory for user dump files

 

 

 

inst1/

 

 

user dump dest for inst1 instance

 

 

 

inst2/

 

 

user dump dest for inst2 instance

 

Directory Structure

ORACLE_BASE Directory

ORACLE_BASE is the root of the Oracle directory structure. ORACLE_BASE directory structure and content is described in Table 1-10. When installing an OFA-compliant database using the Oracle Installer, ORACLE_BASE is by default, set to /pm/app/oracle.

Table 1-10 ORACLE_BASE Directory Structure and Content

admin

 

administrative files

 

doc

 

online documentation

 

local

 

subtree for local Oracle software

 

product

 

Oracle software

 

ORACLE_HOME Directory

¸¸¾à OFA¸¦ µû¸£´Â Oracle ¼­¹ö¸¦ ¼³Ä¡ÇÏ±æ ¿øÇÑ´Ù¸é, ORACLE_HOME µð·ºÅ丮´Â /mount_point/app/oracle/product/release_number·Î ÇÑ´Ù. ORACLE_HOME directory ±¸Á¶¿Í ³»¿ëÀº Table 1-11¿¡ ¼³¸íµÇ¾î ÀÖ´Ù. LinuxÇÏ¿¡¼­ ORACLE_HOME directory´Â °¢°¢ÀÇ ¿À¶óŬ Á¦Ç°À» À§ÇÑ ¼­ºêµð·ºÅ丮 »Ó¸¸ ¾Æ´Ï¶ó ´ÙÀ½°ú °°Àº ¼­ºê µð·ºÅ丮¸¦ Æ÷ÇÔÇÑ´Ù.

Table 1-11 ORACLE_HOME Directory Structure and Content

bin

 

binaries for all products

 

ctx

 

ConText cartridge

 

dbs

 

initsid.ora, lksid

 

jdbc

 

JDBC drivers

 

lib

 

Oracle product libraries

 

md

 

Spatial cartridge

 

mlx

 

Xerox Stemmer (for ConText cartridge)

 

network

 

Net8

 

nlsrtl

 

NLS runtime loadable data

 

ocommon

 

common files for all products

 

odg

 

data gatherer

 

opsm

 

Parallel Server Manager Components

 

oracore

 

core libraries

 

orainst

 

master installation files and programs

 

ord

 

data cartridges

 

otrace

 

Oracle TRACE

 

plsql

 

PL/SQL

 

precomp

 

precompilers

 

rdbms

 

server files and libraries required for the database

 

slax

 

SLAX parser

 

sqlplus

 

SQL*Plus

 

svrmgr

 

Server Manager

 

Oracle Product Subdirectories

Á¦Ç°ÀÇ ¼­ºêµð·ºÅ丮´Â ¿©·¯ºÐµéÀÇ ½Ã½ºÅÛ¿¡¼­ ÀÌ¿ë°¡´ÉÇÑ ¿À¶óŬ Á¦Ç°°ú ¿©·¯ºÐµéÀÌ ±¸ÀÔÇÑ Á¦Ç°¿¡ µû¶ó, Table 1-12¿¡ ±â¼úµÈ °ÍµéÀ» Æ÷ÇÔÇÑ´Ù.

Table 1-12 Oracle Product Subdirectories

network

 

Oracle Net8

 

ocommon

 

libraries ¿Í SQL messages. ¸ðµç Á¦Ç°µéÀº ÀÚµ¿À¸·Î ¼³Ä¡µÈ µð·ºÅ丮¿¡ ÀÇÁ¸ÇÑ´Ù.

 

plsql

 

PL/SQL version 2, procedural option

 

sqlplus

 

SQL*Plus

 

svrmgr

 

Server Manager

 

Contents of Product Subdirectories

°¢°¢ÀÇ Á¦Ç°µéÀÇ ¼­ºêµð·ºÅ丮´Â Table 1-13¿¡ ±â¼úµÈ ¼­ºêµð·ºÅ丮¸¦ Æ÷ÇÔÇÑ´Ù:

Table 1-13 Contents of Product Subdirectories

admin

 

administrative SQL and shell scripts (for example, catalog.sql, catexp.sql, and demo.sql)

 

admin/*

 

special directories for other products

 

admin/resource

 

resource files

 

admin/terminal

 

runtime terminal files

 

demo

 

demonstration scripts and datafiles

 

doc

 

README files (for example, readmeLINUX.doc)

 

install

 

product installation scripts

 

lib

 

product libraries and distributed makefiles

 

log

 

trace files and log files (for example, orasrv.log and *.trc files)

 

mesg

 

U.S. message files, and Multilingual Option (formerly National Language Support) message text and binary files (for example, oraus.msg and oraus.msb)

 

Examples of Product Subdirectories

Á¦Ç°ÀÇ ¼­ºêµð·ºÅ丮¿Í ±×µéÀÇ ³»¿ëÀº Table 1-14¿¡¼­ º¼¼ö ÀÖ´Ù.

Table 1-14 Examples of Product Subdirectories

rdbms

 

install, lib, admin, doc, mesg, log

 

sqlplus

 

install, demo, lib, admin, doc, mesg

 

File Naming Conventions in the admin Directory

rdbms/admin µð·ºÅ丮´Â Table 1-15¿¡ ÀÖ´Â SQL scripts¸¦ º¼ ¼ö ÀÖ´Ù.

Table 1-15 admin Directory, File Naming Conventions

cat*.sql

 

catalog, data dictionary tables ±×¸®°í views¸¦ º¼ »ý¼ºÇÑ´Ù. ´ÙÀ½ ÆÄÀϵéÀº ¼³Ä¡ÇÏ´Â µ¿¾È¿¡ ÀÚµ¿À¸·Î ½ÇÇàµÈ´Ù:
catalog.sql (¸ðµç ¼³Ä¡°úÁ¤¿¡¼­)
catproc.sql (¸ðµç ¼³Ä¡°úÁ¤¿¡¼­)
catparr.sql (º´·Ä ¼­¹ö ¿É¼Ç ¼³Ä¡½Ã¿¡¸¸)
catrep.sql (¸ðµç ¼³Ä¡°úÁ¤¿¡¼­)

 

dbms*.sql

 

additional database packages

 

utl*.sql

 

tables °ú µ¥ÀÌŸº£À̽º À¯Æ¿¸®Æ¼¸¦ À§ÇÑ view¸¦ »ý¼ºÇÑ´Ù.

 

Filename Extensions

ÆÄÀÏ À̸§ È®ÀåÀÚ¿¡ ´ëÇÑ ±â¼úÀº Table 1-16¿¡ ÀûÇô ÀÖ´Ù.

Table 1-16 Filename Extensions

.a

 

object file libraries; Ada runtime libraries

 

.ada

 

Ada source files

 

.aud

 

Oracle audit file

 

.bdf

 

X11 font description file

 

.bmp

 

X11 bitmap file

 

.c

 

C source file

 

.ctl

 

SQL*Loader control file; Oracle Server control file

 

.dat

 

SQL*Loader datafile

 

.dbf

 

Oracle Server tablespace file

 

.dei

 

ORCA de-installation script

 

.dmp

 

Export file

 

.doc

 

ASCII text file

 

.env

 

shell script file for setting environment

 

.f

 

FORTRAN source file

 

.h

 

C header file; also, sr.h is a SQL*Report Writer help file

 

.ins

 

ORCA installation script

 

.l

 

LINUX manual page

 

.lis

 

output of SQL*Plus scripts

 

.log

 

installation log files; Oracle Server redo log files

 

.map

 

Installer product component files

 

.mk

 

make files

 

.msb

 

NLS message file (binary)

 

.msg

 

NLS message file (text)

 

.o

 

object module

 

.ora

 

Oracle configuration files

 

.orc

 

installation prototype files

 

.pad

 

Pro*Ada source file

 

.pc

 

Pro*C source file

 

.pco

 

Pro*COBOL source file

 

.ppd

 

printer driver file

 

.pfo

 

Pro*FORTRAN source file

 

.prd

 

product registration template file (for orainst)

 

.res

 

Toolkit II resource file

 

.sh

 

Bourne shell script file

 

.sql

 

SQL* script files

 

.sys

 

Bourne shell script file

 

.tab

 

SQL* script file

 

.trc

 

trace files

 

.tut

 

Bourne shell script file

 

.us

 

orainst message file

 

.utd

 

Uniform Terminal Definitions

 

.vrf

 

Installer Dependencies Verification Script

 

Default OFA Database

OFA default database´Â Figure 1-1¿¡ º¸ÀÌ´Â ¿À¶óŬ Installer¸¦ ÀÌ¿ëÇÏ¿© »ý¼ºµÇ¾ú´Ù.

Figure 1-1 Default Oracle Installation




Prev

Next
Oracle
Copyright © 1998 Oracle Corporation.

All Rights Reserved.

Library

Product

Contents

Index