w*m
发帖数: 1806 | 1 EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = ipc)(KEY = extproc10g_a))
(CONNECT_DATA = (SID = plsextproc10g_a)(PRESENTATION = RO))
)
这是一个extproc_connection_data,假设我还有另外一个key, extproc10g_b/
plsextproc10g_b,怎么写？
谢谢，包子奉上。 |
B*****g
发帖数: 34098 | 2 EXTPROC_CONNECTION_DATA=
(DESCRIPTION=
(ADDRESS_LIST=
(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC0))
)
(CONNECT_DATA=(SID=PLSExtProc)(PRESENTATION= RO))
)
【在 w*m 的大作中提到】
: EXTPROC_CONNECTION_DATA =
: (DESCRIPTION =
: (ADDRESS = (PROTOCOL = ipc)(KEY = extproc10g_a))
: (CONNECT_DATA = (SID = plsextproc10g_a)(PRESENTATION = RO))
: )
: 这是一个extproc_connection_data,假设我还有另外一个key, extproc10g_b/
: plsextproc10g_b,怎么写？
: 谢谢，包子奉上。
|
w*m
发帖数: 1806 | 3 beijing, 能再详细点儿么？俺不理解啊，
是不是在同一个 tnsnames.ora里，再添加一个extproc_connection_data，不make
sense 啊？
EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = ipc)(KEY = extproc10g_a))
(CONNECT_DATA = (SID = plsextproc10g_a)(PRESENTATION = RO))
)
EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = ipc)(KEY = extproc10g_b))
(CONNECT_DATA = (SID = plsextproc10g_b)(PRESENTATION = RO))
) |
B*****g
发帖数: 34098 | 4 (ADDRESS_LIST=
(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC0))
(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1))
.....
)
【在 w*m 的大作中提到】
: beijing, 能再详细点儿么？俺不理解啊，
: 是不是在同一个 tnsnames.ora里，再添加一个extproc_connection_data，不make
: sense 啊？
: EXTPROC_CONNECTION_DATA =
: (DESCRIPTION =
: (ADDRESS = (PROTOCOL = ipc)(KEY = extproc10g_a))
: (CONNECT_DATA = (SID = plsextproc10g_a)(PRESENTATION = RO))
: )
: EXTPROC_CONNECTION_DATA =
: (DESCRIPTION =
|
w*m
发帖数: 1806 | 5 最想知道的就是 connect_data怎么写？有没有connect_data_list这一说？
EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LSIT =
(ADDRESS = (PROTOCOL = ipc)(KEY = extproc10g_a))
(ADDRESS = (PROTOCOL = ipc)(KEY = extproc10g_b))
)
/***????? connect_data_list?
(CONNECT_DATA_LIST =
(CONNECT_DATA = (SID = plsextproc10g_a)(PRESENTATION = RO))
(CONNECT_DATA = (SID = plsextproc10g_b)(PRESENTATION = RO))
)
)
(ADDRESS_LIST=
(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC0))
(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1))
.....
)
【在 B*****g 的大作中提到】
: (ADDRESS_LIST=
: (ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC0))
: (ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1))
: .....
: )
|
B*****g
发帖数: 34098 | 6 don't know, may try use 2 extproc_connection_data with different name?
like extproc_connection_data.10ga and extproc_connection_data.10gb
【在 w*m 的大作中提到】
: 最想知道的就是 connect_data怎么写？有没有connect_data_list这一说？
: EXTPROC_CONNECTION_DATA =
: (DESCRIPTION =
: (ADDRESS_LSIT =
: (ADDRESS = (PROTOCOL = ipc)(KEY = extproc10g_a))
: (ADDRESS = (PROTOCOL = ipc)(KEY = extproc10g_b))
: )
: /***????? connect_data_list?
: (CONNECT_DATA_LIST =
: (CONNECT_DATA = (SID = plsextproc10g_a)(PRESENTATION = RO))
|
v*****r
发帖数: 1119 | 7 You can not have more than one EXTPROC_CONNECTION_DATA alias in one tnsnames
.ora file. In your case, you will need to create two copy of tnsnames.ora
file, one for the client calling "plsextproc10g_a" and one for client
calling "plsextproc10g_b", so just switch different versions of tnsnames.ora
file when external program changes.
BTW, the most important part is to add both "extproc10g_a/plsextproc10g_a"
and "extproc10g_b/plsextproc10g_b" to server listener.ora config file. You
can add external proc config to default listerner, but Oracle suggest using
separate dedicated listener for external calls.
【在 w*m 的大作中提到】
: EXTPROC_CONNECTION_DATA =
: (DESCRIPTION =
: (ADDRESS = (PROTOCOL = ipc)(KEY = extproc10g_a))
: (CONNECT_DATA = (SID = plsextproc10g_a)(PRESENTATION = RO))
: )
: 这是一个extproc_connection_data,假设我还有另外一个key, extproc10g_b/
: plsextproc10g_b,怎么写？
: 谢谢，包子奉上。
|
w*m
发帖数: 1806 | 8 thanks. one more question,
can I have two $TNS_ADMIN, and then use the same "lsnrctl" to start two
listener?
tnsnames
ora
using
【在 v*****r 的大作中提到】
: You can not have more than one EXTPROC_CONNECTION_DATA alias in one tnsnames
: .ora file. In your case, you will need to create two copy of tnsnames.ora
: file, one for the client calling "plsextproc10g_a" and one for client
: calling "plsextproc10g_b", so just switch different versions of tnsnames.ora
: file when external program changes.
: BTW, the most important part is to add both "extproc10g_a/plsextproc10g_a"
: and "extproc10g_b/plsextproc10g_b" to server listener.ora config file. You
: can add external proc config to default listerner, but Oracle suggest using
: separate dedicated listener for external calls.
|
v*****r
发帖数: 1119 | 9 Yes, for sure. You can start multiple listeners under the same oracle_home
once you configure non-default listeners in listener.ora file (each non-
default listener will have its own name).
【在 w*m 的大作中提到】
: thanks. one more question,
: can I have two $TNS_ADMIN, and then use the same "lsnrctl" to start two
: listener?
:
: tnsnames
: ora
: using
|
v*****r
发帖数: 1119 | 10 But for one oracle_home, you can only define one $TNS_ADMIN
【在 v*****r 的大作中提到】
: Yes, for sure. You can start multiple listeners under the same oracle_home
: once you configure non-default listeners in listener.ora file (each non-
: default listener will have its own name).
|
w*m
发帖数: 1806 | 11 one oracle home, one $TNS_ADMIN, that's bad.....
【在 v*****r 的大作中提到】
: But for one oracle_home, you can only define one $TNS_ADMIN
|
