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
Bookmarks