DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4
  1. #1
    Join Date
    Sep 2005

    Question sqlplus's login.sql

    I have followed Tom's Expert One on One Oracle to configure my sqlplus, I composed a file called login.sql which contains:
    set serveroutput on size 1000000

    set trimspool on
    set long 5000
    set linesize 100
    set pagesize 9999
    column plan_plus_exp format a80

    column global_name new_value gname
    set termout off
    select lower(user) || '@' ||
    decode(global_name, 'ORACLE10.WORLD', '10.0', 'ORA10g.WORLD',
    '10g', global_name ) global_name from global_name;
    set sqlprompt '&gname> '
    set termout on

    and then I start sqlplus, it worked well yesterday, but today the login.sql seems never been executed, because when I input the command ‘show serveroutput', it always tells me ’serveroutput off'

    my database is Oracle 10g and my OS is Windows XP SP2

    Thanks for any clue.

  2. #2
    Join Date
    Sep 2005
    And if I append the script into the file glogin.sql, then things seem to work properly. Why sqlplus do not execute login.sql? In the Oracle document it says:
    Previously, the SQL*Plus site and user profile files, glogin and login, were run when SQL*Plus was started with a username and password, or with /NOLOG. The profile files, glogin and login are now also run after successful CONNECT commands.

  3. #3
    Join Date
    Sep 2005
    I have solved the problem. It's just because that when sqlplus start, it only check the current directory to see if there is a login.sql, so if I first switch the directory into the one where login.sql reside, it will then work properly!

  4. #4
    Join Date
    Mar 2002
    Mesa, Arizona
    Nice job figuring this one out...
    "I do not fear computers. I fear the lack of them." Isaac Asimov
    Oracle Scirpts DBA's need

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Click Here to Expand Forum to Full Width

We have made updates to our Privacy Policy to reflect the implementation of the General Data Protection Regulation.