Gentoo Websites Logo
Go to: Gentoo Home Documentation Forums Lists Bugs Planet Store Wiki Get Gentoo!
Bug 255090 - dev-db/oracle-instantclient-sqlplus-10.2.0.3 - glogin.sql in wrong directory, won't be auto-executed
Summary: dev-db/oracle-instantclient-sqlplus-10.2.0.3 - glogin.sql in wrong directory...
Status: RESOLVED FIXED
Alias: None
Product: Gentoo Linux
Classification: Unclassified
Component: Current packages (show other bugs)
Hardware: All Linux
: High normal (vote)
Assignee: Tobias Scherbaum (RETIRED)
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2009-01-15 20:28 UTC by Fabian Holler
Modified: 2009-05-04 17:00 UTC (History)
0 users

See Also:
Package list:
Runtime testing required: ---

Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description Fabian Holler 2009-01-15 20:28:20 UTC 
Howdy,

SQLplus has an "autostart" script which should be executed during every sqlplus startup:

"When SQL*Plus starts up, it looks for a global login script called glogin.sql in the $ORACLE_HOME/sqlplus/admin directory. If found, this script will be executed. "
http://www.orafaq.com/wiki/SQL*Plus_FAQ

The oracle-instantclient-sqlplus package comes with the file /usr/lib64/oracle/10.2.0.3/client/lib/glogin.sql the path should be correct because
ORACLE_HOME is set to /usr/lib64/oracle/10.2.0.3/client from /etc/profile.csh.
But it won't be executed :/

Instead if the glogin.sql is in the directory  /usr/lib64/oracle/10.2.0.3/client/sqlplus/admin/ it will be executed during every startup.


Reproducible: Always

Steps to Reproduce:
1. echo "set pagesize 5" >> /usr/lib64/oracle/10.2.0.3/client/lib/glogin.sql
2. start sqlplus execute an select statement
3. ln -s /usr/lib64/oracle/10.2.0.3/client/lib/glogin.sql /usr/lib/oracle/10.2.0.3/client/sqlplus/admin/
4. start sqlplus execute an select statement

(PAGESIZE 5 should put headings after every 2 results from select)

Actual Results:  
nothing

Expected Results:  
execution of glogin.sql
Comment 1 Tobias Scherbaum (RETIRED) gentoo-dev 2009-05-04 17:00:02 UTC 
Fixed in CVS.