Today : 944 Total : 394144
|
|
page id: 1380, 4457 hits, unlocked, unhidden, current: v7
v3:2008-07-30 22:29:31(1,193), v4:2008-07-30 22:30:52(782)
diff v3:빠바기 v4:빠바기
| = 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
|
