Help, multiple EXTPROC_CONNECTION_DATA - 未名空间MITBBS历史存档

国际科技财经博客移民网络热点娱乐民生时事公众号

Redian新闻

>未名空间

>Database - 数据库

Help, multiple EXTPROC_CONNECTION_DATA

Help, multiple EXTPROC_CONNECTION_DATA# Database - 数据库

w*m2010-10-19 07:10

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*g2010-10-19 07:10

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*m2010-10-19 07:10

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*g2010-10-19 07:10

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*m2010-10-19 07:10

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*g2010-10-19 07:10

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*r2010-10-19 07:10

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 的大作中提到】

w*m2010-10-19 07:10

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*r2010-10-19 07:10

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*r2010-10-19 07:10

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*m2010-10-19 07:10

11 楼

one oracle home, one $TNS_ADMIN, that's bad.....

【在 v*****r 的大作中提到】

: But for one oracle_home, you can only define one $TNS_ADMIN