-
Sid,service,service_name
In TNSNAMES.ORA file entry for CONNECT_DATA,i've seen three types of entries,one with SID,other with SERVICE_NAME & third one is SERVICE.
For example,for your reference i've given SERVICE entry which i read
TEST.world =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(COMMUNITY = spx.world)
(PROTOCOL = SPX)
(SERVICE = Server_lsnr)
)
(CONNECT_DATA = (SID = TEST)
)
)
Clear my following doubts,
1) what is the diference between SID,SERVICE_NAME & SERVICE.
2) I've seen 3 types of protocols in TNSNAMES.ORA setting,
TCP - for network connection
IPC - for External procedure
what is the need & use of SPX protocol and explain me what is COMMUNITY in SPX setting ?
-
answer this quesion - why dont you EVER look things up for yourself
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
|