Has Anyone Got TOra 1.2.4 On Linux Working Against Oracle Database 10g?
February 24th, 2004 by Mark Rittman
I’ve been trying to get TOra 1.2.4 to connect to an Oracle Database 10g installation, with both client and server on the same Red Hat 9.0 machine.
Unfortunately, although TOra starts up, as soon as I try and connect I keep coming up with the error “ORA 12705: invalid or unknown NLS parameter value specified”, even after setting the following environment variables
ORACLE_HOME=/home/oracle/product/10.1.0/db_1
ORACLE_SID=markr10g
PATH=$PATH:$ORACLE_HOME/bin
NLS_LANG=AMERICAN_AMERICA.WE8ISO8859P1
I’ve posted a message to Henrik and the same problem’s been mentioned on the TOra forum recently. I’ve made sure the version I’m running is the one from the TOra website (rather than the RedHat supplied one, which doesn’t come with Oracle connectivity), but so far, no luck. iSQLPlus and SQLPlus work fine.
Anyone got any ideas?
March 1st, 2004 at 2:57 pm
I have the same problem with Oracle 9.2
March 2nd, 2004 at 3:10 am
I remember having a similar problem not with Tora.
Unfortunately I cannot recall the details. I think it was an incorrect NLS_LANG in a Windows Registry.
I suggest, if you can, create a logon trigger for the schema which will start a trace.
Then you should be able to examine the trace file and see what command is causing the issue.
create or replace trigger USERNAME.trace_on after logon on schema
begin
execute immediate ‘ALTER SESSION SET EVENTS ‘’10046 trace name context forever, level 4′’ ‘;
end;
March 8th, 2004 at 4:21 pm
Hi Mark,
I ve read the posting on your weblog about Oracle 10g and tora.
I have just downloaded TOra 1.3.13 alpha for linux and installed it on RHEL AS 3.0.
It was just a matter of installing the rpm and voil ! I was able to connect immediately to my fresh installation of Oracle 10g.
I haven t played with all its features but it looks very promising .
Roberto
March 30th, 2004 at 2:47 pm
Hi,
have the same problem with Suse Linux 8.1, Oacle 10g
and Tora 1.3.8
did anybody found a workaround?
Carl
April 6th, 2004 at 12:09 am
Yes, tora works with 10g. Had a problem with the new NLS. Created the database using UTF-8, struggled for a few hours, then decided on a whim to recompile tora. works fine now…Had to set the “LANG” environment variable “LANG=en_US” and my machine locales are “LC_ALL=en_US”.
Hope that helps,
James
April 6th, 2004 at 6:29 pm
ORA-12705 invalid or unknown NLS parameter value specified”
What am I missing??
TOra 1.2.4
Fedora Core 2
Kernel: Linux 2.6.4-1.300
NLS_LANG=AMERICAN
NLS_LANGUAGE=AMERICAN
LC_ALL=en_US
LANG=en_US
$ tora &
[3] 7345
$ Qt: Locales not supported on X server
And although I can select oracle connection provider and see my databases, I still get the ORA-12705
“invalid or unknown NLS parameter value specified”
when trying to open connection
June 13th, 2004 at 7:14 pm
Hi,
got the same problem with SuSE 8.2 and Oracle 10g
together with TOra 1.2.4 (stable). I’ve tried everything suggested so far. Has anybody got a clue?
Uli
June 17th, 2004 at 5:58 pm
i just figured it out. i’m on SuSE 8.2 and i found that this env variable had to be removed!
unset ORA_NLS33
then tora worked!
July 10th, 2004 at 12:37 am
Hello,
I’m trying to connect to an Oracle 8i database from Tora 1.2.4. The version of tora is from toras website and not the one that comes with Fedora Core 2. I have the oracle client version 9.2.0.4 installeed and sqlplus works. When i fire up tora, it sees the oracle plugin, and the databases in the tnsnames file. When i try to connect, it comes back with the error “Unable to connect to the database” No ora error codes or nothing, just that. I have set the $oracle_home, $oracle_base,ld_library_path, ld_assume_kernel variables set - no other oracle related variables have been set. I want to move to Fedora Core2. Currently, I have Fedora core 1, tora 1.2.4, and I’m not sure what oracle client is installed, and the connection works perfectly. I was hoping to get core 2 configured and running before i switch my main pc over. If i ever get it running, I’ll post the steps i went through on my website.