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

Thread: ORA-12500: TNS:listener failed to start a dedicated server process

Threaded View

  1. #9
    Join Date
    Nov 2002
    Location
    New Delhi, INDIA
    Posts
    1,796
    --Change the listener to

    # LISTENER.ORA Network Configuration File: D:\ora92\network\admin\listener.ora

    LISTENER =
    (DESCRIPTION_LIST =
    (DESCRIPTION =
    (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = TCP)(HOST = 172.18.50.37)(PORT = 1521)
    )
    )
    )
    )

    ---- no need to enter the entry for 803 if you are using the same listener name and port.

    SID_LIST_LISTENER =
    (SID_LIST =
    (SID_DESC =
    (SID_NAME = TEST92)
    (ORACLE_HOME = D:\ora92)
    )
    (SID_DESC =
    (SID_NAME = DCC1)
    (ORACLE_HOME = C:\ORANT)
    )
    )

    -- and change tns to

    # TNSNAMES.ORA Network Configuration File: D:\ora92\network\admin\tnsnames.ora
    DCC1 =
    (DESCRIPTION =
    (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = TCP)(HOST = 172.18.50.37)(PORT = 1521)
    )
    )
    (CONNECT_DATA = (SID = DCC1)
    )
    )

    TEST92 =
    (DESCRIPTION =
    (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = TCP)(HOST = 172.18.50.37)(PORT = 1521)
    )
    )
    (CONNECT_DATA = (SERVICE_NAME = TEST92)
    )
    )

    I did put TNS_ADMIN to ora92 tnsnames.ora
    --- point this to D:\ora92\network\admin (directory) not the tnsnames.ora file
    Last edited by adewri; 01-31-2003 at 04:04 AM.
    Amar
    "There is a difference between knowing the path and walking the path."

    Amar's Blog  Get Firefox!

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