| I Can't launch sqlplus from JDeveloper [message #348825] |
Thu, 18 September 2008 00:44  |
MSTRKRFT
Messages: 2
Registered: September 2008
|
Junior Member |
|
|
In JDeveloper under tools -> preferences -> database connections and the SQL*PLUS setting I have the following:
/Applications/Utilities/Terminal.app/Contents/MacOS/Terminal & /opt/oracle/instantclient/sqlplus
If I control+click (right click) on an open sql file and choose Run in SQL*Plus it doesn't work even though I have the database connection set up. The exact same configuration works fine on windows.
sqlplus is installed correctly as I can start it in the terminal and run it just fine. This is what I have had to do thus far.
SQL*plus version is:
Version 10.2.0.4
[Updated on: Thu, 18 September 2008 00:46] Report message to a moderator |
|
|
|
|
|
| Re: I Can't launch sqlplus from JDeveloper [message #349006 is a reply to message #348844] |
Thu, 18 September 2008 09:41  |
MSTRKRFT
Messages: 2
Registered: September 2008
|
Junior Member |
|
|
"Doesn't work" as in the terminal pops up I enter my username and password then I receive the following message....
ORA-12545: Connect failed because target host or object does not exist
jdeveloper output window displays the following:
Invoking SQL*Plus...
/Applications/Utilities/Terminal.app/Contents/MacOS/Terminal /opt/oracle/instantclient/sqlplus MSTRKRFT@(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=oracle.cis.ksu.edu)(PORT=1521)))(CONNECT_DATA=(SID=ORACLE)))
[Updated on: Thu, 18 September 2008 14:30] Report message to a moderator |
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
