Re: JDeveloper Connection to Oracle DB

JDeveloper may not have installed in the same oracle home as your regular Oracle client, first see if you have more than one Oracle home directory on your computer, either by checking the registry under HKEY_LOCAL_MACHINE/Software/Oracle or by searching for the TNSNAMES.ORA file. Then ensure that the TNSNAMES.ORA files in all those directories contain an entry for the database you're trying to test with, and that the SQLNET.ORA files agree. Then ensure that you can connect to the databse with SQL*Plus. If you still can't connect using the existing TNSNAMES method, try entering the host, port and SID instead. ( I see you did some of this already, but the mutiple homes thing changes the problem)

Finally, give up and call Oracle Support ;-).

Elias Mouchantaf wrote:

> Hi again,
>
> I would like to clarify the problem once again since it
> seems that I might have left some details out. I have
> installed JDeveloper 3.0 and I am running Oracle
> 8i personal edition on a Windows 98 platform. I am
> trying to create a connection to the DB from
> JDeveloper. I specify the "Oracle JDBC Thin" as driver
> since I need to use applets, and I select "Existing TNS
> Names" as the connection method and I choose the
> service running. When I click on the "Test Connection"
> button I get an error message that reads: "Io
> exception: The Network adapter could not establish the
> connection".
>
> I tried to resolve the problem but was unable to. I had
> the listener started using the command: lsnrctl start.
> I am able to ping the server. There are no firewalls
> invovled. According to the documentation, the Thin
> driver uses the sqlnet. I tried using the IP address
> instead of the TNSNames and I still got the same error
> message.
>
> I would appreciate any help.
>
> Thank you,
>
> Elias S. Mouchantaf
> Tel. (+961) 3 740319
> elmo_at_moshnet.com
> www.moshnet.com
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Elias Mouchantaf
> INET: elmo_at_moshnet.com
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
Received on Wed Jun 27 2001 - 08:25:15 CDT