Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I installed the 32-bit ODAC ( from here. The Oracle Universal Installer version contains Oracle SQL*Plus But I'm missing the sqlplus/admin/ folder in the installation, where I usually put the glogin.sql file.


This install is on a new Windows 7 - 64 bit Notebook, which is my first 64-bit Windows system.

The initial idea is not to install any Oracle server there, but I guess I'll change my mind about this during the first 2 month.

I find sqlplus.exe in the folder D:\app\berndk\product\11.2.0\client_1.

BTW This install has no sqlplus subfolder and the ORACLE_HOME environment varaiable is not set. As I do not need ODBC that install generally works quite well.

share|improve this question
Can you use login.sql instead? – Jack Douglas Aug 20 '11 at 12:49
Is this an Oracle server or a client PC? – Guy Aug 20 '11 at 17:21
It is a client on my new Windows 7-64 bit notebook. – bernd_k Aug 20 '11 at 17:29
up vote 3 down vote accepted

Thanks to the link provided by Jack Douglas, I found the solution.

I needed to create a login.sql file in the same folder as sqlplus.exe and I had to set the SQLPATH environment variable to this path.

From the article I got the impression, that setting the variable was not necessary.

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.