-
Dear DBA's
I have setted my database environment following way for IIOP protocol connection but still not getting it. Please guide me in this.
Please also tell me how to test whether connection is proper.
INIT.ORA parameters....
mts_dispatchers = "(ADDRESS=(PROTOCOL=TCP)(HOST=192.1.10.37)(PORT=2481))(DISPATCHERS=1) (PRE=oracle.aurora.server.SGiopServer)"
mts_max_dispatchers=10
mts_servers=1
mts_max_servers=10
mts_listener_address="(ADDRESS=(PROTOCOL=tcp)(host=PC_MY_NT)(port=2481))"
mts_service = ORCL
Listener.Ora .....
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = pc_my_nt)(PORT = 1521))
)
)
(DESCRIPTION =
(PROTOCOL_STACK =
(PRESENTATION = GIOP)
(SESSION = RAW)
)
(ADDRESS = (PROTOCOL = TCP)(HOST = pc_my_nt)(PORT = 2481))
)
)
CONNECT_TIMEOUT_LISTENER=10
STARTUP_WAIT_TIME_LISTENER = 0
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = D:\ORANT)
(PROGRAM = extproc)
)
(SID_DESC =
(GLOBAL_DBNAME = orcl)
(ORACLE_HOME = D:\ORANT)
(SID_NAME = orcl)
)
)
TNSNAMES.ORA .....
orcl=
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = pc_my_nt)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = orcl)
)
)
Thanks & Regards
Shailesh
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|