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. #5
    Join Date
    Nov 2002
    Location
    New Delhi, INDIA
    Posts
    1,796
    I have made the changes, try this

    ORA8.0.3:LISTENER
    ################
    # Filename......: listener.ora
    # Node..........: local.world
    # Date..........: 24-MAY-94 13:23:20
    ################
    LISTENER1 =
    (ADDRESS_LIST =
    (ADDRESS=
    (PROTOCOL= TCP)(Host= 172.18.50.37)(Port= 1526)
    )
    )

    SID_LIST_LISTENER1 =
    (SID_LIST =
    (SID_DESC =
    (SID_NAME = DCC1)(ORACLE_HOME = C:\ORANT)
    )
    )

    ORA8.0.3 TNSNAMES.ORA

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

    ORA92 LISTENER

    # LISTENER.ORA Network Configuration File: D:\ora92\network\admin\listener.ora
    # Generated by Oracle configuration tools.

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

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

    ORA92 TNSNAMES.ORA

    # TNSNAMES.ORA Network Configuration File: D:\ora92\network\admin\tnsnames.ora
    # Generated by Oracle configuration tools.

    DCC1 =
    (DESCRIPTION =
    (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = TCP)(HOST = 172.18.50.37)(PORT = 1526))
    )
    (CONNECT_DATA =
    (SID = DCC1)
    )
    )

    TEST92 =
    (DESCRIPTION =
    (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = TCP)(HOST = 172.18.50.37)(PORT = 1521))
    )
    (CONNECT_DATA =
    (SERVICE_NAME = TEST92)
    )
    )
    Last edited by adewri; 01-30-2003 at 02:23 PM.
    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