Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> 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! alexReceived on Mon Dec 06 1999 - 01:55:10 CST
![]() |
![]() |