(if that email address didn't require changing)
>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
>When I try to do the following query:
>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?
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
Oracle Service Industries Reston, VA USA
Opinions are mine and do not necessarily reflect those of Oracle Corporation