topic Re: sqlplus default values in Operating System - HP-UX

sqlplus default values

Brian Gebhard_1 — Tue, 11 Mar 2003 18:17:09 GMT

I'm trying to set up the server sqlplus default values when each user logs into sqlplus. It was my understanding that the file $ORACLE_HOME/sqlplus/glogin.sql is used for this. But when I add the following line to the file
set LINESIZE 80
nothing happens when log into sqlplus. Am I using the wrong file? Is there another file in 9i to use?

Re: sqlplus default values

James Specht — Tue, 11 Mar 2003 18:44:10 GMT

We use login.sql not glogin.sql. Plus we have it in a directory that is on the users path. It works fine. Here is our login.sql.

rem
rem customized login.sql for users
rem
SET ECHO OFF
DEF _editor = 'vi'
COLUMN COUNT(*) FORMAT 999999
SET NEWPAGE 1
SET PAGESIZE 24
SET TAB OFF
SET TIME OFF
SET TIMING OFF
SET ECHO OFF
SET SHOWMODE OFF
rem PROMPT end of LOGIN.SQL

Re: sqlplus default values

Volker Borowski — Tue, 11 Mar 2003 18:45:13 GMT

Hi,

do you have a "login.sql" file in the directory where you call "sqlplus" ?
It might overrule settings from glogin.sql

Volker

Re: sqlplus default values

Brian Gebhard_1 — Tue, 11 Mar 2003 18:48:48 GMT

Yes it was the login.sql. After reading the oracle docs I now see that glogin is called before login.sql. And it was in a different directory even though oracle's docs said it is copied to $ORACLE_HOME/dbs/ on install. Thanks for your help.

Re: sqlplus default values

Christian Gebhardt — Tue, 11 Mar 2003 18:51:13 GMT

HI

It's not a 9i feature, but every user has it's own loginfile called login.sql in the start-dir of sqlplus.

This file overrides the general settings of glogin.sql

By the way, you mentioned "server sqlplus default".
glogin.sql and login.sql are client settings you have to set on each client.
If you change this files on the oracle server only sqlpus-connections from this server have the new settings.

Chris

Re: sqlplus default values

Graham Cameron_1 — Wed, 12 Mar 2003 08:28:18 GMT

Be aware that if you have the environment variable $SQLPATH set, SQL*Plus will look there for login.sql. This can be useful for sharing settings between unix accounts, without everyone having to keep a local copy.
Like PATH, SQLPATH can contain a list of directories, separated by colons.
The search order is $PWD, $SQLPATH.