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

Thread: ORA-12560(very urgent)

  1. #1
    Join Date
    Mar 2002
    Posts
    303
    Hi all,

    i want to create a new instance on server: I've already two
    instances on this server.
    The install fail with the error message:ORA-12560


    Please help
    Thank's


  2. #2
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    ORA-12560 is a networking issue. Check you listener.ora and tnsnames.ora files.
    Jeff Hunter

  3. #3
    I got this info from another forum. Hope this is helpful!
    -----------------------------------------------------------
    error 12560 is a very basic and generic error mostly the issue is oracle_sid. to solve this, you may need to poke around a lot of things.

    1. Are u using windows terminal services? if so there are some known issues with that. From the docs*************

    2. - If the drive is NTFS then check the permissions on the drive or oracle home to be sure SYSTEM has full control on all subdirectories and files.

    - Be sure the instance is started Goto Start-->Settings--> Control Panel-->Services and check if the database service is started.

    - Be sure the ORACLE_SID is set in the registry correctly. Goto Start button-->RUN-->type regedt32--> Goto the following directory tree within the registry - HKEY_LOCAL_MACHINE -> SOFTWARE -> ORACLE - highlight ORACLE - look on the left side look for ORACLE_SID = To change you can highlight ORACLE_SID - right click on your mouse and select modify. Enter the SID. The above is only valid when using DEFAULT_HOME, when you have another home then you need to highlight that HOME under ORACLE key usually HOME1-HOMEx - No spaces can be entered after the = when setting ORACLE_SID at the DOS Prompt, set oracle_sid=xyz should be used and not set oracle_sid = xyz.

    - If you have verified that ORACLE_SID is properly set, and the service is running, yet you still get an ORA-12560, then it is possible that you have created an instance with a non-alphanumeric character. The Getting Started Guide for Oracle8i on Windows NT documents that SID names can contain only alphanumerics, however if you attempt to create a SID with an underscore or a dash on Oracle8i you are not prevented from doing so. The service will be created and started successfully, but attempts to connect will fail with an ORA-12560.

    - If doing the above and the error still occurs on a new instance creation then the createdb scripts did not run correctly.
    ------------------------------------------
    Shyami.S.Seelan, OCP 8i, 9i DBA
    Dublin, Ireland.
    http://www.geocities.com/shyamiseelan/OCP
    ------------------------------------------

  4. #4
    Join Date
    Mar 2002
    Posts
    303
    Thank's all.
    I resolve the problem as Shyamala Sathiaseelan told me.
    That was terminal services problem.

    Bensmail

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