Re: Oracle Client Tools

fitzjarrell_at_cox.net wrote:

> Interesting ... I've installed the instant client correctly and all I
> get from my 9.2.0.6 database is an ORA-12705 error stating an unknown
> or invalid NLS parameter exists. Nothing in my glogin.sql file appears
> to be causing this. If someone can get this to connect successfully to
> an Oracle instance older than 10.1.0 let me know.
>
>
> David Fitzjarrell
>

Works, if you set NLS_LANG explicitly... C:\10GCli>sqlplus wk_test/wk_test_at_o1001
SQL*Plus: Release 10.1.0.3.0 - Production on Sat Mar 5 10:12:58 2005 Copyright (c) 1982, 2004, Oracle. All rights reserved.

ERROR:
ORA-12705: invalid or unknown NLS parameter value specified

Enter user-name:

C:\10GCli>SET NLS_LANG=AMERICAN_AMERICA.WE8MSWIN1252

C:\10GCli>sqlplus wk_test/wk_test_at_o1001

SQL*Plus: Release 10.1.0.3.0 - Production on Sat Mar 5 10:15:38 2005 Copyright (c) 1982, 2004, Oracle. All rights reserved.

Connected to:
Oracle Database 10g Enterprise Edition Release 10.1.0.2.0 - Production With the Partitioning, OLAP and Data Mining options

SQL> exit
C:\10GCli>sqlplus hr/hr_at_o920
SQL*Plus: Release 10.1.0.3.0 - Production on Sat Mar 5 10:16:59 2005 Copyright (c) 1982, 2004, Oracle. All rights reserved.

Connected to:
Oracle9i Enterprise Edition Release 9.2.0.4.0 - Production With the Partitioning, Oracle Label Security, OLAP and Oracle Data Mining options
JServer Release 9.2.0.4.0 - Production

Sorry - not upgraded, yet :) and 8i is down the drain

It also works, if you define an NLS_LANG environment variable via Control Panel, System, Advanced, Environment. Add a User Environment Variable, and close/reopen a command prompt window, or the sqlplus session (it needs to pick up the new environment)

-- 
Regards,
Frank van Bortel