Ygthkb

Why write a book when there's a movie in my head?

How do I purchase a drop bar bike that will be converted to flat bar?

Buying a "Used" Router

Is there any way to play D&D without a DM?

Plotting Laguerre Gaussian beam intensity in transverse and line profile via center?

Identical projects by students at two different colleges: still plagiarism?

Sets that are both Sum-free and Product-free

Reason for small-valued feedback resistors in low noise Op Amp

Can't figure out a htaccess rule

Existence of a strange function

Expression for "unconsciously using words (or accents) used by a person you often talk with or listen to"?

What is the meaning of "usr"?

How to transport 10,000 terrestrial trolls across ocean fast?

Do the speed limit reductions due to pollution also apply to electric cars in France?

Including proofs of known theorems in master's thesis

Why can all solutions to the simple harmonic motion equation be written in terms of sines and cosines?

Using functions like sine, cosine and tangent to calculate coordinates in Tikz

Is Screenshot Time-tracking Common?

Manager has noticed coworker's excessive breaks. Should I warn him?

Why aren't passengers instructed how to lift aisle armrests?

Is it possible to detect 100% of SQLi with a simple regex?

Can you say "leftside right"?

Isn't a semicolon (';') needed after a function declaration in C++?

Minimum Viable Product for RTS game?

configure sql developer for oracle using IPC fails with network adapter error

Oracle 11g Listener not workingHow can I allow an Oracle database to be accessed remotely?Oracle XE 11g (ORA-12514: TNS:listener does not currently know of service requested in connect descriptor )Can't connect to a Oracle db instance via SQLDeveloperOracle connection suddenly refused on windows 8Issues with SQL DeveloperConnect to Oracle RAC from SQL Developer?How to configure sql developer with oracle 12c?can not connect to oracle database with ip addressTNS-12560: TNS:protocol adapter error

0

i have oracle 11 XE installed locally. i can connect on the same machine using sqlplus with sqlplus user/pass. i can also connect using sqlplus user/pass@XE (XE is defined in tnsnames.ora and this connection uses TCP (default). I added an entry in tnsnames that uses IPC (XE_IPC) and i can connect using sqlplus user/pass@XE_IPC. tnsnping XE_IPC succeeds.

SQL DEVELOPER connection, when i choose TNS and then XE_IPC from the dropdown, fails with a network adapter error.

my question: how do i configure SQL DEVELOPER such that the IPC connection works? Once that works, what is the jdbc connection string that will work?

here is the rub: my company locks down ports like nobody else, so things like localhost and 127.0.0.1 do not work. This is why i'm using the IPC connection (or at least trying to).

TCP connections using sqlplus, jdbc, and sql developer work flawlessly when the server is on another machine.

oracle oracle-sql-developer

share

asked 6 mins ago

Scott TigerScott Tiger

1

New contributor

Scott Tiger is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

add a comment | 

0

i have oracle 11 XE installed locally. i can connect on the same machine using sqlplus with sqlplus user/pass. i can also connect using sqlplus user/pass@XE (XE is defined in tnsnames.ora and this connection uses TCP (default). I added an entry in tnsnames that uses IPC (XE_IPC) and i can connect using sqlplus user/pass@XE_IPC. tnsnping XE_IPC succeeds.

SQL DEVELOPER connection, when i choose TNS and then XE_IPC from the dropdown, fails with a network adapter error.

my question: how do i configure SQL DEVELOPER such that the IPC connection works? Once that works, what is the jdbc connection string that will work?

here is the rub: my company locks down ports like nobody else, so things like localhost and 127.0.0.1 do not work. This is why i'm using the IPC connection (or at least trying to).

TCP connections using sqlplus, jdbc, and sql developer work flawlessly when the server is on another machine.

oracle oracle-sql-developer

share

asked 6 mins ago

Scott TigerScott Tiger

1

New contributor

Scott Tiger is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

add a comment | 

i have oracle 11 XE installed locally. i can connect on the same machine using sqlplus with sqlplus user/pass. i can also connect using sqlplus user/pass@XE (XE is defined in tnsnames.ora and this connection uses TCP (default). I added an entry in tnsnames that uses IPC (XE_IPC) and i can connect using sqlplus user/pass@XE_IPC. tnsnping XE_IPC succeeds.

SQL DEVELOPER connection, when i choose TNS and then XE_IPC from the dropdown, fails with a network adapter error.

my question: how do i configure SQL DEVELOPER such that the IPC connection works? Once that works, what is the jdbc connection string that will work?

here is the rub: my company locks down ports like nobody else, so things like localhost and 127.0.0.1 do not work. This is why i'm using the IPC connection (or at least trying to).

TCP connections using sqlplus, jdbc, and sql developer work flawlessly when the server is on another machine.

oracle oracle-sql-developer

share

asked 6 mins ago

Scott TigerScott Tiger

1

New contributor

Scott Tiger is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

share

asked 6 mins ago

Scott TigerScott Tiger

1

New contributor

Scott Tiger is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

share

asked 6 mins ago

Scott TigerScott Tiger

1

New contributor

Scott Tiger is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

asked 6 mins ago

Scott TigerScott Tiger

1

New contributor

Scott Tiger is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

asked 6 mins ago

Scott TigerScott Tiger

1