I am attempting to connect to a remote database using the command 'sqlplus internal@db_alias' and each time I receive the error ora-24314 service handle not initialized. Can anyone give me an idea on what could be causing this error?
Did you have an abnormally terminated session? A shadow process still living? Is TNS_ADMIN right? Is tnsnames.ora OK?
do you really need to connect through SQL to a remote database using INTERNAL user?
You might find problem connecting anyway. If you really have to, then try
setting parameter REMOTE_LOGIN_PASSWORDFILE = exclusive in initSID.ora.
Anyway if you are trying to connect from a 3rd party software. Maybe this might help.
ORA-24314: need explicit attach before initialize service context
Cause: An ociatch() was not done before an ociisc() call.
Action: Issue ociatch() before calling ociatch().
Click Here to Expand Forum to Full Width