Today : 1146 Total : 394346
|
|
page id: 1380, 4457 hits, unlocked, unhidden, current: v7
v5:2008-07-30 22:31:02(73), v6:2008-07-30 22:32:51(1,194)
diff v5:빠바기 v6:빠바기
| = listener.ora는 server, tnsnames.ora는 client 셋팅 |
| = |
| = !! listener.ora 예제 |
| = |
| + {{{ |
| + # LISTENER.ORA Network Configuration File: /opt/oracle/product/9.2.0.4/network/admin/listener.ora |
| + # Generated by Oracle configuration tools. |
| + |
| + LISTENER = |
| + (DESCRIPTION_LIST = |
| + (DESCRIPTION = |
| + (ADDRESS_LIST = |
| + (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC)) |
| + ) |
| + (ADDRESS_LIST = |
| + (ADDRESS = (PROTOCOL = TCP)(HOST = localhost.localdomain)(PORT = 1521)) |
| + ) |
| + ) |
| + ) |
| + |
| + SID_LIST_LISTENER = |
| + (SID_LIST = |
| + (SID_DESC = |
| + (SID_NAME = PLSExtProc) |
| + (ORACLE_HOME = /opt/oracle/product/9.2.0.4) |
| + (PROGRAM = extproc) |
| + ) |
| + (SID_DESC = |
| + (GLOBAL_DBNAME = KWC.cheongshim.com) |
| + (ORACLE_HOME = /opt/oracle/product/9.2.0.4) |
| + (SID_NAME = KWC) |
| + ) |
| + ) |
| + }}} |
| + |
| + !! tnsnames.ora 예제 |
| + {{{ |
| + # TNSNAMES.ORA Network Configuration File: /opt/oracle/product/9.2.0.4/network/admin/tnsnames.ora |
| + # Generated by Oracle configuration tools. |
| + |
| + KWC.LOCALDOMAIN = |
| + (DESCRIPTION = |
| + (ADDRESS_LIST = |
| + (ADDRESS = (PROTOCOL = TCP)(HOST = localhost.localdomain)(PORT = 1521)) |
| + ) |
| + (CONNECT_DATA = |
| + (SERVER = DEDICATED) |
| + (SERVICE_NAME = KWC.cheongshim.com) |
| + ) |
| + ) |
| + |
| + }}} |
| + |
ViewPage
|
