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.

  • 2
    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

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.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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