Re: How to set J.developer for ORACLE..??

In article <dcaibh$4e2$2@xxxxxxxxxxxxxx>,
"Robert Bralic" <robo_bralic@xxxxxxxxxxx> wrote:

> Dear,
>
> When I try to connect from J.Developer to ORACLE vith SQL+,
> it returns me a error: "ORA-12203: TNS:unable to connect to destination".
> Description is:
> Cause: Invalid TNS address supplied or destination is not listening.
> This error can also occur because of underlying network transport problems.
> Action: Verify that the service name you entered on the command line was
> correct. Ensure that the listener is running at the remote node and that the
> ADDRESS parameters specified in TNSNAMES.ORA are correct. Finally, check
> that all Interchanges needed to make the connection are up and running.
>
> Thanks in advance, Robert !
>
> robert.bralic@xxxxxxxxxxx

Look in $ORACLE_HOME/network/admin/tnsnames.ora for the service name of
your Oracle database. From the command line, try running "tnsping
<service_name>".

You may need to contact your Oracle database administrator. If that's
you, check out "Net Services Administrator's Guide" at
<http://otn.oracle.com/>

--
John
jmatthews at wright dot edu
www dot wright dot edu/~john.matthews/
.

Relevant Pages

  • Re: Float to String
    ... > The problem in that case was that values stored in an Oracle database ... > when later extracted sometimes differed in the lsb. ... > stored in decimal format. ... jmatthews at wright dot edu ...
    (comp.lang.ada)
  • Re: Java Date Formatting
    ... sammynash@uboot.com wrote: ... Why not let Oracle do the work? ... Just tell it the format of the ... jmatthews at wright dot edu ...
    (comp.lang.java.programmer)
  • SUMMARY: sudo version 1.6.7p5 : using -H -u options on Solaris 8
    ... Many thanks to those that responded, as expected all responses were helpful. ... This will allow you to do the thing that the user oracle requires while also ... designated in the sudoers file who requires to use the command, ... there is a CLASSPATH variable set which, as the oracle user I can see by ...
    (SunManagers)
  • Re: Basic question | run multiple queries without reconnecting
    ... :>From an oracle client like oracle sqldeveloper, I can run the DCL - ... : system as role: sysdba - but then I cant even connect to the db.. ... as default - I get the same error when I run this command: ...
    (comp.databases.oracle.server)
  • [NEWS] Oracle Database 9ir2 Interval Conversion Buffer Overflow
    ... The following security advisory is sent to the securiteam mailing list, and can be found at the SecuriTeam web site: http://www.securiteam.com ... Oracle Database Server provides two functions that can be used with PL/SQL ... Exploitation of these vulnerabilities becomes easy if Oracle ...
    (Securiteam)