Re: database links problem

A copy of this was sent to Galaxy Admin <galxyadm_at_nortelnetworks.ca> (if that email address didn't require changing) On Tue, 17 Aug 1999 15:15:14 -0400, you wrote:

>I have created a database link by the following statement:
>
>sql> create database link galaxy connect to galaxyadm identified by
>galaxyadm using 'galaxy';
>
>Assuming all is well and I have the tnsnames.ora entry and user/password
>is correct.
>
>When I try to do the following query:
>
>sql> select emp_at_galaxy
>ERROR:
>ORA-02248: invalid option for ALTER SESSION
>ORA-02063: preceding line from GALAXY
>
>this error comes up, I do not know what is going on?
>
>I can only think of a few possibilities:
>- listener.ora file is incorrect
>- tnsnames.ora file entry is incorrect
>- db_domain init parameter is set wrong
>- global_names init parameter is set wrong
>
>Thanks ahead of time for the help.

Is it possible you have set the NLS_DATE_FORMAT in your init.ora file?

If so:

Set any NLS parameter to use double quote marks in the initSID.ora file.  

       Example: NLS_DATE_FORMAT = "DD/MON/YYYY"  

The environment is then read as the literal between the double quotes.  

When environment variables are sent across the link, NLS_DATE_FORMAT is sent as ''''NLS_DATE_FORMAT = DD/MON/YYYY'''' due to using single quote marks in the initSID.ora file.

restart after doing that.

--
See http://govt.us.oracle.com/~tkyte/ for my columns 'Digging-in to Oracle8i'... Current article is "Part I of V, Autonomous Transactions" updated June 21'st  

Thomas Kyte                   tkyte_at_us.oracle.com
Oracle Service Industries     Reston, VA   USA

Opinions are mine and do not necessarily reflect those of Oracle Corporation Received on Tue Aug 17 1999 - 14:57:59 CDT