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

Thread: ora-24314 error

  1. 09-06-2001, 08:12 AM #1
    dkmartin13
    dkmartin13 is offline Junior Member
    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
    Reply With Quote Reply With Quote
  2. 09-06-2001, 08:29 AM #2
    julian
    julian is offline Senior Advisor
    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?
    Reply With Quote Reply With Quote
  3. 09-06-2001, 08:42 AM #3
    reydp's Avatar
    reydp
    reydp is offline Senior Advisor
    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().

    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules

Click Here to Expand Forum to Full Width