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

$ 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 Received on Wed Jan 10 2007 - 06:24:58 CST