LINUX
2017.03.14 / 11:36

[CentOS] CentOS ¿À¶óŬ ¼­¹ö ¸®½º³Ê ¼³Á¤

Ŭ·¡½Ã
Ãßõ ¼ö 136

Á¦°¡ º¸±â¿¡´Â default·Î Ãʱ⼳ġ»óÅ ±×´ë·Î ¼³Á¤ÇϽŠ°Í °°½À´Ï´Ù.
pro*c¸¦ »ç¿ëÇϽô °Í °°Áö ¾ÊÀºµ¥¿ä. ¸ÂÁö¿ä? Ȥ½Ã visual studio
¸¦ ÅëÇؼ­ pro*c¸¦ »ç¿ëÇÏ½Ã¸é ¸ð¸£°ÚÁö¸¸ ÀϹÝÀûÀ¸·Î´Â toad¸¦
»ç¿ëÇÏ°í DB¿¬½ÀÀ» ÇϽŴٸé pro*c¼³Á¤Àº ÇÊ¿ä¾øÀ» °Í °°³×¿ä.

sid_list ºÎºÐ¿¡´Â SID¸¦ ÁöÁ¤ÇÏÁö ¾ÊÀ¸¼Ì³×¿ä. Áö±Ý ¼³Á¤µÈ °ÍÀº
SIDÀ̸§ÀÌ ¾Æ´Ï¶ó PRO*C¸¦ À§ÇÑ ¼³Á¤ÀÎ °Í °°±¸¿ä.

±×·¸´Ù¸é dynamic service registrationÀ¸·Î DB¿¡ Á¢¼ÓÇÏ°Ô
µÇ°Ú½À´Ï´Ù.
1521¹ø Æ÷Æ®ÀÌ´Ï LOCAL_LISTENER¸¦ DB ÆĶó¹ÌÅÍ¿¡ ÁöÁ¤ÇÏÁö ¾ÊÀ¸¼ÌÀ» °ÍÀÌ°í
ÀÌ°ÍÀ» ±âµ¿½ÃÄÑ Á¢¼ÓÇϱâ À§Çؼ­´Â ¸®½º³Ê¸¦ ¸ÕÀú ±âµ¿½ÃÅ°°í DB¸¦
±âµ¿ÇØ¾ß pmonÇÁ·Î¼¼½º°¡ ¸®½º³Ê¸¦ ã¾Æ³»°í DBÁ¢¼ÓÀÌ 
ÀÌ·ç¾îÁö°Ú½À´Ï´Ù.(±â¾ïÀÌ °¡¹°..PMONÀÌ ¸ÂÀ»ÅÙµ¥..)

dynamic service registrationÀº listener¸¦ ±âµ¿ÇÏ°í
³ª¼­´Â ¾î´À ¼­ºñ½º¿¡ Á¢¼ÓÀÌ µÇ¾ú´Ù¶ó´Â ¸Þ¼¼Áö°¡ ¾ø½À´Ï´Ù.
lsnrctl service ¸í·ÉÀ» ÇÏ½Ã¸é ¾î¶² DB¿¡ ´ëÇÑ Á¢¼ÓÀ» ÇÑ´Ù°í
¾ÈÇÏ°Ú½À´Ï´Ù. ±×·±µ¥ DB¸¦ Àç±âµ¿ÇÏ°Ô µÇ¸é ±× ¶§°¡ µÇ¾î¼­¾ß
DB°¡ ¿Ã¶ó°¡¸é¼­ pmonÇÁ·Î¼¼½º°¡ 1521¹ø Æ÷Æ®ÀÇ ¸®½º³Ê¸¦ ¹ß°ßÇÏ°í
"³ª ¿©±âÀÖ¾î¿ä~" Çϸ鼭 ¸®½º³Ê¿¡°Ô ¾Ë·ÁÁÖ°ÚÁö¿ä.
ÀÌÁ¦ lsnrctl service ¸í·ÉÀ» ÇÏ¸é ¾î´À DB¿¡ Á¢¼ÓÇß´Ù°í ³ª¿É´Ï´Ù.
ÀÌ°ÍÀÌ dynamic service registration ÀÔ´Ï´Ù.
1521¹ø Æ÷Æ®¸¦ »ç¿ëÇßÀ» ¶§¸¸ ±×·¸°í ¸¸¾à ´Ù¸¥ Æ÷Æ®·Î Á¢¼ÓÇϱâ
À§Çؼ­´Â DBÆĶó¹ÌÅÍ¿¡ local_listener=local À̶ó°í ÇÏ°í
¼­¹öÀÇ tnsnames.ora ÆÄÀÏ¿¡ local À̶ó´Â alias·Î

local=
(address_list=
(address=(protocol=tcp)(host=192.168.10.130)(port=1531)))
À» ÁöÁ¤ÇØ¾ß ÇÕ´Ï´Ù.

±×·¸´Ù¸é dynamic ÀÌ ¾Æ´Ñ static service registrationÀ¸·Î ÁöÁ¤ÇØÁÖ´Â °ÍÀÌ
ÆíÇÏ°í ÁÁ°Ú½À´Ï´Ù.(´ëºÎºÐ ±×·¸°Ô »ç¿ë)
¾Æ·¡ listenerºÎºÐ¿¡¼­ HOSTºÎºÐÀ» ip·Î ¸í½ÃÀûÀ¸·Î Áֽô °ÍÀÌ
ÁÁÀ» °Í °°½À´Ï´Ù.
¸¸¾à °øÀ¯±â·Î µÇ¾î ÀÖ´Ù¸é static IP¸¦ ÅëÇؼ­ ¼³Á¤ÇØÁֽô °ÍÀÌ
ÁÁ°Ú½À´Ï´Ù.(Àúµµ ±×·¸°Ô »ç¿ëÇÕ´Ï´Ù)

LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.10.130)(PORT = 1521))
)
)

¾Æ·¡¿Í °°ÀÌ SID_NAME ºÎºÐ¿¡ SID¸íÀ» ÁÖ¼¼¿ä. Àú´Â DBÀ̸§ÀÌ
PRODÀ̹ǷΠPROD¶ó°í ÇÏ°Ú½À´Ï´Ù.
º¸ÅëÀº DBÀ̸§°ú °°ÀÌ »ç¿ëÇÕ´Ï´Ù. ±×¸®°í program ºÎºÐµµ pro*c¸¦ 
»ç¿ëÇÏÁö ¾Ê´Â °Í °°À¸´Ï Á¦°ÅÇϽñ¸¿ä. ±×¸®°í ORACLE_HOMEºÎºÐ¿¡ 
°æ·Î°¡ Á¤È®ÇØ¾ß ÇÕ´Ï´Ù.

SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(ORACLE_HOME = C:\oracle\product\10.2.0\db_1)
(SID_NAME =PROD)
)
)

±×·¸´Ù¸é TOAD·Î Á¢¼ÓÇϽô tnsnames.ora ÆÄÀÏÀÌ Á¤È®ÇÏ°Ô
¼³Á¤ÇØ¾ß ÇÒÅÙµ¥.. ¸¸¾à À§¿¡¼­ 1521¹ø Æ÷Æ®¿¡ SID_NAMEÀÌ
PROD ·Î µÇ¾î ÀÖ°í sqlplus system/manager@KKK
·Î Á¢¼ÓÀ» KKK ¶ó´Â alias·Î Á¢¼ÓÀ» ÇϽŴٸé

KKK=
(DESCRIPTION=
(ADDRESS_LIST=
(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.10.130)(PORT=1521)
)
)
(CONNECT_DATA=
(SID=PROD)
)
)

±×¸®°í Ȥ½Ã sqlnet.ora ÆÄÀÏ¿¡ domainÀÌ ÀÖÀ¸¸é domainÀ»
kkk.µµ¸ÞÀÎ= À¸·Î ÁöÁ¤ÇØÁÖ¾î¾ß ÇÕ´Ï´Ù.
¿¹¸¦µé¾î sqlnet.ora ÆÄÀÏ¿¡
names.default_domain=min1004
¶ó¸é
kkk.min1004= À̶ó°í tnsnames.ora ÆÄÀÏÀÇ tns alias¿¡
¼³Á¤ÇØ¾ß ÇÕ´Ï´Ù.

±×¸®°í Çì±ò¸®½Ç °Í °°Àºµ¥ listener.ora ÆÄÀÏ¿¡ ¸®½º³Ê¿¡¼­´Â
SID_NAME À» »ç¿ëÇÏ°í, tnsnames.ora ÆÄÀÏ¿¡´Â SID ¶Ç´Â
SERVICE_NAMEÀ» »ç¿ëÇÕ´Ï´Ù. SID_NAME ÀÎÁö SIDÀÎÁö°¡ Çì±ò¸®´Ï
Á¶½ÉÇϼſä~

listener.ora ÆÄÀÏ

# listener.ora Network Configuration File: /u01/app/oracle/product/10.2.0/db_1/network/admin/listener.ora
# Generated by Oracle configuration tools.

LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.10.130)(PORT = 1531))
)
)
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = /u01/app/oracle/product/10.2.0/db_1)
(PROGRAM = extproc)
)
(SID_DESC =
(SID_NAME = orcl)
(ORACLE_HOME = /u01/app/oracle/product/10.2.0/db_1)
)
)

tnsnames.ora ÆÄÀÏ
# tnsnames.ora Network Configuration File: /u01/app/oracle/product/10.2.0/db_1/network/admin/tnsnames.ora
# Generated by Oracle configuration tools.

ORCL =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.10.130)(PORT = 1531))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl)
)
)

EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)