Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.tools -> 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