ora-24314 error
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: ora-24314 error

  1. #1
    Join Date
    Apr 2001
    Posts
    21
    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?

    Thanks.
    DKM

  2. #2
    Join Date
    Jun 2001
    Location
    Helsinki. Finland
    Posts
    3,938
    Did you have an abnormally terminated session? A shadow process still living? Is TNS_ADMIN right? Is tnsnames.ora OK?

  3. #3
    Join Date
    Sep 2001
    Location
    Makati, Philippines
    Posts
    857
    Hi,
    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().


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width