Re: ORA-12705 weird problem

Andre.Seesink_at_TheLodge.nl (Andre) wrote in message news:<4b24dbe0.0201240035.390534d3_at_posting.google.com>...
> Hi all,
> I logon with a userid td1adm on a Unix system and start sqlplus.
> table zfindau is a symbolic link using a database link.
>
> unix> sqlplus /
>
> SQL> select count(*) from zfindau;
> select count(*) from zfindau
> *
> ERROR at line 1:
> ORA-12705: invalid or unknown NLS parameter value specified
> ORA-02063: preceding line from HUBD
> SQL> exit
>
> (I am still connected with the same user in Unix, but connect with a
> different Oracle user. So Unix environment variables are still the
> same!)
>
> benist01:td1adm 2> sqlplus sapr3
> Enter password:
> SQL> select count(*) from zfindau;
>
> COUNT(*)
> ----------
> 74991
>
>
>
> Does anyone have a clue what's going on here??????
>
> Andre Seesink

The database link will cause a login to occur. Apparently during this login your .profile is not executed. You can include your environment variables with the (envs= ) option in listener.ora This is discussed in the net8 administrators manual.

Hth

Sybrand Bakker
Senior Oracle DBA Received on Thu Jan 24 2002 - 07:31:07 CST