linux ¿À¶óŬ ¸®½º³Ê ¼³Á¤(¿À¶óŬ ¿ø°ÝÁ¢¼Ó)
* ¿À¶óŬ ¸®½º³Ê
´Ù¸¥ ÄÄÇ»ÅÍ¿¡¼ ¿À¶óŬ¿¡ Á¢¼ÓÇÏ·Á¸é ¸®½º³Ê°¡ µ¿ÀÛÇØ¾ß ÇÑ´Ù. ¸®½º³Ê´Â ³×Æ®¿öÅ©¸¦ ÀÌ¿ëÇÏ¿© Ŭ¶óÀ̾ðÆ®¿¡¼ ¿À¶óŬ ¼¹ö·Î ¿¬°áÇϱâ À§ÇÑ ¿À¶óŬ ³×Æ®¿öÅ© °ü¸®ÀÚ ÀÌ´Ù. ¿À¶óŬ ¼¹ö¿¡¼ ¸®½º³Ê¸¦ ½ÃÀÛ½ÃÄÑ ÁÖ¾î¾ß Ŭ¶óÀ̾ðÆ®µéÀÌ Á¢¼Ó ÇÒ ¼ö ÀÖ´Ù.
Listener´Â ÇÊ¿ä¿¡ µû¶ó ¿©·¯ °³°¡ µ¿½Ã¿¡ ±¸¼º µÇ°í ½ÇÇàµÉ ¼ö ÀÖÀ¸¸ç, °¢°¢ÀÇ Listener´Â ¼ºñ½º ¸ñ·ÏÀ» µ¿Àû ¶Ç´Â ¼öµ¿À¸·Î µî·ÏÇÒ ¼ö ÀÖ´Ù. ±âº» Æ÷Æ® (1521)¸¦ »ç¿ëÇÏ´Â Listener´Â PMON À¸·Î ºÎÅÍ ÇöÀç ½ÇÇà ÁßÀÎ µð½ºÆÐóÀÇ Á¤º¸µµ ÇÔ²² µî·ÏÇÏ°í ÀÖÀ½À» È®ÀÎ ÇÒ ¼ö ÀÖ´Ù. ÇÏÁö¸¸ ±âº» Æ÷Æ®¸¦ »ç¿ëÇÏÁö ¾Ê´Â Listener(·ÎÄà ¸®½º³Ê ¼³Á¤À» º¯°æÇÑ ´Ù¸¥ ¸®½º³Ê)´Â µ¿ÀûÀ¸·Î ¼ºñ½ºÀÇ Á¤º¸¸¦ µî·Ï ¹ÞÀ» ¼ö ¾ø´Ù.
Å×½ºÆ® ¼³Á¤ ¹× È®ÀÎ »çÇ×
SQL PLUS °°Àº Å͹̳ΠÁ¢¼ÓÀÏ °æ¿ì .bash_profile À» ¼öÁ¤ ->
/home/oracle/.bash_profile
* ¿¹½Ã
export ORACLE_BASE=/usr/local/app/oracle
export ORACLE_SID=orcl
export ORACLE_HOME=$ORACLE_BASE/product/11.2.0/dbhome_1
export ORA_NLS10=$ORACLE_HOME/nls/data
export TNS_ADMIN=$ORACLE_HOME/network/admin
export LD_LIBRARY_PATH=$ORACLE_HOME/lib:/usr/lib
export NLS_LANG=AMERICAN_AMERICA.KO16KSC5601
export PATH=$PATH:.:$ORACLE_HOME/bin:/usr/ccs/bin:/usr/sbin:/sbin:/usr/bin:/bin:/usr/X11R6/bin:/usr/bin/X11
export EDITOR=vi
export PS1='$LOGNAME@`hostname`:$PWD>'
* ¸®½º³Ê ±¸¼º ÆÄÀÏÀº $ORACLE_HOME/network/admin ¾Æ·¡¿¡ ÀÖ´Â listener.ora ÆÄÀÏÀ̸ç, ¿À¶óŬ ¼¹ö¿¡¼ Ŭ¶óÀ̾ðÆ®ÀÇ ¿äûÀ» µè°í Ŭ¶óÀ̾ðÆ®¿ÍÀÇ Åë½Å ȯ°æÀ» ¼³Á¤ÇÑ´Ù.
* listener.ora ÆÄÀÏÀÌ ¾ø´Ù¸é, console â¿¡¼
oracle$ lsnrctl start ¶ó°í Ä¡¸é ÀÚµ¿À¸·Î ¸¸µé¾îÁø´Ù.
¸¸µé¾îÁø ¸®½º³Ê´Â ¼ºñ½º·Î µî·ÏµÇ´Âµ¥, À©µµ¿ì °°Àº °æ¿ì ¼ºñ½º °ü¸®ÀÚ¿¡¼ Oracle....TNSListener¶ó´Â À̸§ÀÌ ¹Ù·Î ¸®½º³Ê ¼ºñ½º´Ù.
ÀÌ ¼ºñ½ºÀÇ ½ÃÀÛ À¯ÇüÀ» "ÀÚµ¿" À¸·Î º¯°æ.
# cd $ORACLE_HOME/network/admin
# ls
listener.ora samples shrept.lst sqlnet.ora tnsnames.ora
[root@dev admin]# cat listener.ora
** °ø¹é ÁÖÀÇ!!
# listener.ora Network Configuration File: /usr/local/app/oracle/product/11.2.0/dbhome_1/network/admin/listener.ora
# Generated by Oracle configuration tools.
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = xxx.xxx.xxx.xxx)(PORT = 1521))
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
)
)
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(ORACLE_HOME = /usr/local/app/oracle/product/11.2.0/dbhome_1)
(SID_NAME = orcl)
)
)
ADR_BASE_LISTENER = /usr/local/app/oracle
* tnsnames.ora ÆÄÀÏÀº ¿À¶óŬ ¼¹ö·Î Á¢¼ÓÇÒ ¶§ ÇÊ¿äÇÑ ÇÁ·ÎÅäÄÝ ¹× Æ÷Æ®¹øÈ£, ¼¹öÁÖ¼Ò, ÀνºÅϽº µîÀ» ¼³Á¤ÇØ ÁÖ´Â ÆÄÀÏÀÌ´Ù.
[root@dev admin]# cat tnsnames.ora
# tnsnames.ora Network Configuration File: /usr/local/app/oracle/product/11.2.0/dbhome_1/network/admin/tnsnames.ora
# Generated by Oracle configuration tools.
orcl =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = xxx.xxx.xxx.xxx)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl)
(SID = orcl)
)
)
[root@dev admin]# cat sqlnet.ora
# sqlnet.ora Network Configuration File: /usr/local/app/oracle/product/11.2.0/dbhome_1/network/admin/sqlnet.ora
# Generated by Oracle configuration tools.
NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT)
ADR_BASE = /usr/local/app/oracle
[root@dev admin]# su - oracle
oracle@dev.xxxxxxxxxxxx.com:/home/oracle>lsnrctl reload
LSNRCTL for Linux: Version 11.2.0.1.0 - Production on 03-DEC-2014 07:30:52
Copyright (c) 1991, 2009, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=xxx.xxx.xxx.xxx)(PORT=1521)))
The command completed successfully
oracle@dev.goodbyenote.com:/home/oracle>
oracle@dev.xxxxxxxxxxxx.com:/home/oracle>lsnrctl status
LSNRCTL for Linux: Version 11.2.0.1.0 - Production on 03-DEC-2014 07:31:14
Copyright (c) 1991, 2009, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=xxx.xxx.xxx.xxx6)(PORT=1521)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for Linux: Version 11.2.0.1.0 - Production
Start Date 03-DEC-2014 06:22:15
Uptime 0 days 1 hr. 8 min. 59 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /usr/local/app/oracle/product/11.2.0/dbhome_1/network/admin/listener.ora
Listener Log File /usr/local/app/oracle/diag/tnslsnr/dev/listener/alert/log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=2xxx.xxx.xxx.xxx)(PORT=1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))
Services Summary...
Service "orcl" has 2 instance(s).
Instance "orcl", status UNKNOWN, has 1 handler(s) for this service...
Instance "orcl", status READY, has 1 handler(s) for this service...
Service "orclXDB" has 1 instance(s).
Instance "orcl", status READY, has 1 handler(s) for this service...
The command completed successfully
oracle@dev.xxxxxxxxxxxx.com:/home/oracle>
oracle@dev.xxxxxxxxxxxx.com:/home/oracle>tnsping xxx.xxx.xxx.xxx
TNS Ping Utility for Linux: Version 11.2.0.1.0 - Production on 03-DEC-2014 07:32:03
Copyright (c) 1997, 2009, Oracle. All rights reserved.
Used parameter files:
/usr/local/app/oracle/product/11.2.0/dbhome_1/network/admin/sqlnet.ora
Used EZCONNECT adapter to resolve the alias
Attempting to contact (DESCRIPTION=(CONNECT_DATA=(SERVICE_NAME=))(ADDRESS=(PROTOCOL=TCP)(HOST=xxx.xxx.xxx.xxx)(PORT=1521)))
OK (0 msec)
oracle@dev.xxxxxxxxxxx.com:/home/oracle>tnsping dev.xxxxxxxxxx.com 10 // 10À» ºÙÀ̸é 10¹ø Å×½ºÆ®
TNS Ping Utility for Linux: Version 11.2.0.1.0 - Production on 03-DEC-2014 07:32:13
Copyright (c) 1997, 2009, Oracle. All rights reserved.
Used parameter files:
/usr/local/app/oracle/product/11.2.0/dbhome_1/network/admin/sqlnet.ora
Used EZCONNECT adapter to resolve the alias
Attempting to contact (DESCRIPTION=(CONNECT_DATA=(SERVICE_NAME=))(ADDRESS=(PROTOCOL=TCP)(HOST=xxx.xxx.xxx.xxx)(PORT=1521)))
OK (0 msec)
OK (0 msec)
OK (0 msec)
OK (0 msec)
OK (0 msec)
OK (0 msec)
OK (0 msec)
OK (0 msec)
OK (0 msec)
OK (0 msec)
oracle@dev.xxxxxxxxxxxx.xxx:/home/oracle>
À©µµ¿ì PC¿¡¼ Å×½ºÆ®
1. > telnet xxx.xxx.xxx.xxx 1521
2. toad for oracle ÇÁ·Î±×·¥ ÀÌ¿ë
http://www.toadworld.com/ -> ´Ù¿î·Îµå
*************************************************************************************************************************
listener ¹× tnsping Å×½ºÆ® ½Ã ¿¡·¯°¡ °è¼Ó ¹ß»ýÇÏ¿© ±¸±Û¸µÇÑ °Í Áß Çϳª.
########### ¸®½º³Ê.ora ÆÄÀÏÀÔ´Ï´Ù.
LISTENER =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = IPÁÖ¼Ò)(PORT = 1521))
)
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(GLOBAL_DBNAME = ORA9)<----- SID,DB_NAME´Â ´ë¹®ÀÚÀÔ´Ï´Ù.
(ORACLE_HOME = /home/oracle/product/9.0)
(SID_NAME = ORA9)<----- SID,DB_NAME´Â ´ë¹®ÀÚÀÔ´Ï´Ù.
)
)
########### tnsnames.ora ÆÄÀÏÀÔ´Ï´Ù.
ORA9 =<--- aliasµµ ´ë¹®ÀÚ·Î ³ÖÀ¸½Ã±¸¿©..
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = º»ÄÄÇ»ÅÍipÀû¾úÀ½)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = ORA9)<----- SID,DB_NAME´Â ´ë¹®ÀÚÀÔ´Ï´Ù.
)
)
---> ¿É¼ÇÀº À§¿Í °°ÀÌ ÇÏ¿´À¸¸ç, listener.ora ÆÄÀÏ °°Àº °æ¿ì °ø¹é ¶§¹®¿¡ ¿À·ù°¡ ¹ß»ýÇÏ¿© °ø¹éÀ» ÁÖ¾î ¼³Á¤ ÇÏ¿´À¸¸ç, SID_NAME, SERVICE_NAME, alias °°Àº °æ¿ì .bash_profile¿¡ ¼Ò¹®ÀÚ·Î ¼³Á¤ÇÏ¿´±â ¶§¹®¿¡ ¼Ò¹®ÀÚ·Î ÅëÀÏÇÏ¿´´Ù.
Âü°í URL : http://oukr.tistory.com/54 --> ¿À¶óŬ ³×Æ®¿öÅ© ȯ°æ ±¸¼º, ¿©·¯°³ÀÇ ¸®½º³Ê ±¸¼º
Âü°í URL : http://blog.daum.net/slime9/19 --> ¿À¶óŬ 10G XE ¼³Ä¡ ÈÄ ¸®½º³Ê ¹× tns ¼³Á¤
Ãâó: http://kkamagistory.tistory.com/366?category=620111 [Karas.]