Re: sqlplus from Unix prompt

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! Received on Mon Jan 08 2001 - 14:53:41 CST