ORA-24314 service handle not initialized
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: ORA-24314 service handle not initialized

  1. #1
    Join Date
    Dec 2001
    Location
    Baltimore, MD
    Posts
    372
    Hi Gang
    I was trying to connect to my production database as INTERNAL and was getting this error and I have no clue.



    Cause: The server context does not done exist.

    Action: Establish the server context in the service context.

    How to establish the server context? in the service context.

    The action is superflux to me.
    Please advise if you ever have that problem
    Thanks
    Arsene Lupain
    The lie takes the elevator, the truth takes the staircase but ends up catching up with the lie.

  2. #2
    Join Date
    Oct 2000
    Location
    Saskatoon, SK, Canada
    Posts
    3,925
    0. Make sure that your environment is set correctly.
    1. Are you on a unix system?
    2. What is your DB version?
    3. Are you trying to connect to the database through

    Code:
         connect / as sysdba
    4. In 9i the error could be because that the previous process was terminated abnormally and you have to kill that shadow process in-order to connect

    Code:
          $ ps -ef|grep ora9i 
          $ kill pid

    Hopefully one of these would provide you the answer.

    Sam
    Thanx
    Sam



    Life is a journey, not a destination!


  3. #3
    Join Date
    Dec 2001
    Location
    Baltimore, MD
    Posts
    372
    Hey Sam
    It has been awhile since I got you? Thanks for the prompt response. I am using oracle 8.1.7 on windows 2000 advanced server and I am on the server connect as follows.
    SET ORACLE_SID= DB_NAME
    SQLPLUS
    INTERNAL
    PASSWORD XXXXXXXX
    Thanks

    [Edited by Ablakios on 10-10-2002 at 03:16 PM]
    Arsene Lupain
    The lie takes the elevator, the truth takes the staircase but ends up catching up with the lie.

  4. #4
    Join Date
    Oct 2000
    Location
    Saskatoon, SK, Canada
    Posts
    3,925
    can you connect as follows
    Code:
      sqlplus internal@dbname
    Sam
    Thanx
    Sam



    Life is a journey, not a destination!


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