Cry about...
Oracle Troubleshooting

ORA-03121: no interface driver connected

Symptom:

When trying to connect to Oracle the following error is returned:

ORA-03121: no interface driver connected – function not performed

Cause:

This error indicates that Oracle does not know which database to connect to.

Possible remedies:

• Specify the TNS alias to use as part of the connection string.

• In order to connect to a database without specifying an explicit TNS alias (i.e. setting it 'by default') either:

  • set the environment variable ‘LOCAL’ to the required alias.

  • Set the registry value ‘HKEY_LOCAL_MACHINE \ SOFTWARE \ ORACLE \ LOCAL’ to the required alias.

• If the workstation has not been rebooted since Oracle client was installed then try rebooting it now.