Link to home
Create AccountLog in
Avatar of walkerdba
walkerdba

asked on

glogin

[oracle@wtu sqlplus]$ cd admin/
[oracle@wtu admin]$ ls
glogin.sql  help  libsqlplus.def  plustrce.sql  pupbld.sql
[oracle@wtu admin]$ cat glogin.sql
--
-- Copyright (c) 1988, 2005, Oracle.  All Rights Reserved.
--
-- NAME
--   glogin.sql
--
-- DESCRIPTION
--   SQL*Plus global login "site profile" file
--
--   Add any SQL*Plus commands here that are to be executed when a
--   user starts SQL*Plus, or uses the SQL*Plus CONNECT command.
--
-- USAGE
--   This script is automatically run
--
[oracle@wtu admin]$


Is this the expected output..

IF not do you need to run the script again..
Avatar of johnsone
johnsone
Flag of United States of America image

The glogin file is a script that is run every time someone does an initial login through SQL*Plus on the machine.

There is no expected commands in there.  In fact, your file is empty, as all of those lines are comments.

Be aware, that it only applies to logins initiated on that machine.  Any remote login will not run those commands.
Think of it as a global environment for all users (on that machine).  I commonly set the session arraysize to a higher/better value, to set a common prompt, or to change default tracing.
ASKER CERTIFIED SOLUTION
Avatar of Mark Geerlings
Mark Geerlings
Flag of United States of America image

Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
Avatar of walkerdba
walkerdba

ASKER

yes