Problem:

SQLPlus just quits when trying to log via the application.


Unfortunately, we need to see an error, so log into sqlplus via the DOS prompt (Windows Start menu, type in cmd in program search) by typing the following, replacing password with the appropriate password, of course:

sqlplus biotics_dlink/password@biotics5


If the following error is received, then the problem is lack of sufficient privileges:

yZzLVdb5i2Yu6jbPzoWOqHoJpHyJLJy6WA.png


Solution:

To get around the permissions problem, either:

  • Navigate to where the DOS version of SQLPlus is installed (typically c:\oracle\product\10.2.0.\client_1\BIN\sqlplus.exe) and right click on the file to Run as Administrator. In the dos window, when prompted for user-name, enter all the following on the same line: biotics_dlink/password@biotics5, replacing password with the password, of course. 
  • OR from the Windows Start menu, expand Oracle. Right click on SQL Plus and choose to Run as Administrator.

This enables successful connection!