News Junkie wrote:
>
> vk02720_at_my-deja.com wrote in <93cquh$q20$1_at_nnrp1.deja.com>:
>
> >When using sqlplus from a Unix shell prompt, is there a way to specify
> >the path of the login.sql file or any option so that login.sql is not
> >used at all ? I am running Oracle 7.3.4 on AIX 4.3.3 .
> >TIA
> >
> >
> >Sent via Deja.com
> >http://www.deja.com/
> >
>
> On Solaris is a utility called "truss";
> which shows all "system calls" made by an application.
>
> In one window I can start SQL*Plus WITHOUT providing
> any username/password & get prompted for same.
>
> From another window with root access I start truss -p pid
> of the SQL*Plus session.
>
> Then from the original window I enter a valid username/password.
>
> The truss window will display ALL the *login.sql files that
> attempted to be opened by SQL*Plus. On Solaris it looks for
> at least 4 different files if my memory serves me correctly.
>
> HTH & YMMV!
Can you share with us the four locations. I know that sqlplus looks for
for $ORACLE_HOME/sqlplus/admin and $HOME/login.sql and IIRC
$SQL_PATH/login.sql. That is only three, what is the fourth?
Received on Tue Jan 09 2001 - 07:23:23 CST
