Oracle connection problem - please help

From: Damir Dezeljin <news_at_dezo.org>
Date: Fri, 17 Jan 2003 10:49:27 +0100
Message-ID: <b08j9t$6qn$1_at_planja.arnes.si>

Hi.

On my Win2k machine I first installed Oracle Developer 6.0 in C:\ORANT. After that I also installed Oracle in C:\ORACLE.

I always used sqlplus C:\ORACLE\BIN\SQLPLUS.EXE till now. Now I have to use Forms builder to complete my homework. The problem is that I can't connect to my Oracle database with Forms builder.

I try to solve my problem by comparing runs of C:\ORACLE\BIN\SQLPLUS.EXE with C:\ORANT\BIN\SQLPLUS.EXE (from developer tools). So I execute: - sqlplus my_user/my_pass_at_testconn
[Quoted] in each directory. In the C:\ORACLE\BIN (using sqlplus that come with Oracle database) all works fine, while in C:\ORANT\BIN (using sqlplus that come with development tools) I get an error: - ORA-12705: invalid or unknown NLS parameter value specified

I try to fix the problem by editing copying connection data from C:\ORACLE\network\ADMIN\tnsnames.ora to C:\ORANT\NET80\ADMIN\tnsnames.ora, but this didn't help.

Can someone help me?

My tnsnames.ora:

---

TESTCONN.world =

   (DESCRIPTION =

     (ADDRESS_LIST =
       (ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521))
     )
     (CONNECT_DATA =
       (SID = MYSID)
     )

   )

---

I also tried with:

---

TESTCONN =
   (DESCRIPTION =

     (ADDRESS_LIST =
       (ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521))
     )
     (CONNECT_DATA =
       (SID = MYSID)
     )

   )

---

but this didn't solve my problem.

Any sugestion, hint,...?

BTW: I'm using Personal Oracle8i Release 8.1.6.0.0 .

Regards,
Dezo Received on Fri Jan 17 2003 - 10:49:27 CET