| Oracle 10g, Forms6i and SQL Developer connection problem [message #382971] |
Mon, 26 January 2009 16:17  |
sindikalac
Messages: 52
Registered: November 2008
Location: Europe
|
Member |
|
|
Hi,
I have installed Oracle 10g DB, after that I have installed Oracle Forms 6i.
When I try to connect to a database via Sql*Plus, it works fine. But When I try to connect via SQL Developer, an error occurs:
Status: Failure -ORA-00604:error occured at recursive SQL level 1 ORA-12705: Cannot access NLS data files or invalid environment specified.
I don't understand much about ORACLE_HOME, but I have found some comments about ORACLE_HOME, and I checked it in cmd: set %ORACLE_HOME%, it says:
Environment variable %oracle_home% not defined
But when I open PATH variable, I have this values among the others:
C:\oracle\product\10.2.0\db_1;
C:\oracle\product\10.2.0\db_1\bin;
C:\oracle\OraFR6i\jdk\bin;
C:\oracle\OraFR6i\bin;
I have two products installed DB and Forms. Their home directories are:
C:\oracle\product\10.2.0\db_1 and
C:\oracle\OraFR6i
respectively.
In the registry there is ORACLE_HOME set to C:\Oracle\OraFR6i, under ORACLE fodler. But there is also a subfolder called Key_ORADB10g_home1 with ORACLE_HOME containing C:\oracle\product\10.2.0\db_1
I really don't know how to set up all this, if you have any tutorial or advice how to do this or how to learn things related to administration and configuration (homes, etc) I would be so thankfull. (I just started to make simple application in oracle forms, but those problems just came up).
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
