Re: SQL*Plus site profile/user profile on Solaris

I also experimented a bit, with SQLPATH environment variable on AIX, and came to the following conclusion:
$ORACLE_HOME/sqlplus/admin/glogin.sql is always executed first then
if the current directory has a login.sql that one will be executed and not $SQLPATH/login.sql
if the current directory does not have a loging.sql then $SQLPATH/login.sql will be executed.

Could be that on Solaris the environment variable should be SQL_PATH, not sure.

You can also use truss to find out what files are being opened by sqlplus client.

Regards,
Andre van Winssen

"Roman Mirzaitov" <rmirzaitov_at_kt.kg> wrote in message news:a4vf1t$3evpr$1_at_ID-127142.news.dfncis.de...
> > Your search path on Solaris, or in any UNIX environment, is defined in
> > your .profile.
> >
> > Daniel Morgan
>
> Hi Daniel,
>
> right now I've performed a little experiment on Solaris box.
> And as result I got that sqlplus looks for login.sql only in current
> directory.
> Putting this file in any dir from my $PATH has no effect.
> As it stated in SQL*Plus user's guide:
>
> "SQL*Plus searches for a file named LOGIN with the extension SQL in your
> current directory.
> If SQL*Plus does not find the file there, SQL*Plus will search a
> system-dependent path to find the file.
> ___Some operating systems may not support___ this path search."
>
> May be Solaris is one of those OSes?
>
> Regards,
>
> --
> Roman Mirzaitov
> Brainbench MVP for Oracle Administration
> www.brainbench.com
>
>
Received on Wed Feb 20 2002 - 03:59:43 CST