Skip to Main Content

SQL Developer

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Using SQL Developer and IPC connection

529051Sep 29 2006 — edited Jan 10 2007
SQL Dev 1.0.0.15 on Windows XP

On the windows PC I am run SQL Dev on I have a Listener & tnsnames setup to use an IPC connection. I did not have the listener setup to use a protocol of TCP. The connection to the db worked fine via sql+. Also I have toad on this PC and it worked just fine via the IPC connection.

I installed SQL Dev and tried to use the IPC connection. It did not work. I kept getting the message of "unable to access the network adapter" or something close to that. The message made sense as an IPC connection does not use the Network or Network adapter.

I ended up setting up the listener to listen for both IPC and TCP and SQL Dev worked.

My question is does SQL Dev use only the JDBC thin driver as it is my understanding the thin driver must use TCP. And is there a method to allow SQL Dev to use an IPC connection.

Here is my currect listener and tnsnames. SQL Dev I simple listed the parms to connect via TCP in the basic tab of the connection dialog.

listener=
(description=
(address_list=
(address=(protocol=tcp)(host=localhost)(port=1521))
(address=(protocol=ipc)(key=to2))
)
)

sid_list_listener=
(sid_list=
(sid_desc=(sid_name=to2)))



tnsnames:
to2.world =
(description =
(address = (protocol=ipc)(key=to2))
(connect_data = (sid=to2)))




Thanks
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Feb 7 2007
Added on Sep 29 2006
3 comments
3,099 views