| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
Home -> Community -> Usenet -> c.d.o.misc -> Re: oracle oci driver error
: if ORCL is the sid -- its incorrect syntax ...
In thin driver I use sid ORCL worked, but in oci8 should I use
extproc instead ?
Can you show me the right syntax ?
And if I should fix some sections in tnsnames.ora and listener.ora ?
Are the following right or wrong ?
1.oci8 uses ipc protocol?
2.right syntax like below:
jdbc:oracle:oci8:@(description=(address=(protocol=ipc)(key=pnpkey))
(connect_data=(sid=extproc)))
3.In tnsnames.ora bellow lines are needed
extproc_connection_data = (DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = PNPKEY))
(CONNECT_DATA = (SID = extproc))
: if its a TNSNAMES.ora entry and setup properly there -- you should be
: ok ...
4.In tnsnames.ora, are the following lines right?
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = PNPKEY))
(CONNECT_DATA = (SID = extproc)))
I really thank your help!
alex
Received on Mon Dec 06 1999 - 01:55:10 CST
![]() |
![]() |