Re: Oracle 9i | login.sql does not run on login by default

From: Maxim Demenko <mdemenko_at_arcor.de>
Date: Wed, 10 Jan 2007 14:51:16 +0100
Message-ID: <45a4effc$0$27612$9b4e6d93@newsspool2.arcor-online.net>

Anoop schrieb:
> $ sqlplus user/passwd_at_cdb
>
> SQL*Plus: Release 9.2.0.8.0 - Production on Wed Jan 10 07:12:24 2007
>
> Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
>
>
> Connected to:
> Oracle9i Release 9.2.0.8.0 - 64bit Production
> JServer Release 9.2.0.8.0 - Production
>
> SQL> @/opt/app/oracle/local/sql/login.sql
> cdb >
>
>
> Here is content of my login.sql:
>
> SET SQLPROMPT '&_CONNECT_IDENTIFIER > '
>
> I also had this in my login.sql which also did not show up when I
> logged into sqlplus:
> SET TERMOUT OFF
> DEFINE sqlprompt=none
> COLUMN sqlprompt NEW_VALUE sqlprompt
>
> SELECT USER || '@' || NVL('&_CONNECT_IDENTIFIER', global_name )
> sqlprompt
> FROM global_name;
>
> SET SQLPROMPT '&sqlprompt> '
> UNDEFINE sqlprompt
> SET TERMOUT ON
>
>
> Do I need to put anything else there to make it read on login to
> sqlplus?
>
> Thanks,
> Anoop
>

Do you have environment variable SQLPATH which contains the path /opt/app/oracle/local/sql ?

Best regards

Maxim Received on Wed Jan 10 2007 - 07:51:16 CST