Oracle9.2.0.1 Problem
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: Oracle9.2.0.1 Problem

  1. #1
    Join Date
    Jan 2008
    Posts
    1

    Oracle9.2.0.1 Problem

    Hi!
    I'm new to this forum and this is my first Q ..

    I installed Oracle9.2 on WinXP.
    I started Listener and DB services in Windows Services.
    Their status is STARTED.

    But when i start Listener manually, i get the following errors.
    -------------------

    LSNRCTL> start listener
    Starting tnslsnr: please wait...

    Service OracleOraHome92TNSListener already running.
    TNS-12560: TNSrotocol adapter error
    TNS-00530: Protocol adapter error
    32-bit Windows Error: 1056: Unknown error
    ----------------------------
    # LISTENER.ORA Network Configuration File: J:\oracle\ora92\network\admin\listener.ora
    # Generated by Oracle configuration tools.

    LISTENER =
    (DESCRIPTION_LIST =
    (DESCRIPTION =
    (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.100.2)(PORT = 1521))
    )
    (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
    )
    )
    )

    SID_LIST_LISTENER =
    (SID_LIST =
    (SID_DESC =
    (SID_NAME = PLSExtProc)
    (ORACLE_HOME = J:\Oracle\ora92)
    (PROGRAM = extproc)
    )
    (SID_DESC =
    (GLOBAL_DBNAME = COMPANY)
    (ORACLE_HOME = J:\Oracle\ora92)
    (SID_NAME = COMPANY)
    )
    )

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

    INST1_HTTP =
    (DESCRIPTION =
    (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.100.2)(PORT = 1534))
    )
    (CONNECT_DATA =
    (SERVER = SHARED)
    (SERVICE_NAME = MODOSE)
    (PRESENTATION = http://HRService)
    )
    )

    EXTPROC_CONNECTION_DATA =
    (DESCRIPTION =
    (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
    )
    (CONNECT_DATA =
    (SID = PLSExtProc)
    (PRESENTATION = RO)
    )
    )

    COMPANY =
    (DESCRIPTION =
    (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.100.2)(PORT = 1521))
    )
    (CONNECT_DATA =
    (SERVER = DEDICATED)
    (SERVICE_NAME = COMPANY)
    )
    )

    ----------------------------------------
    # SQLNET.ORA Network Configuration File: J:\oracle\ora92\network\admin\sqlnet.ora
    # Generated by Oracle configuration tools.

    SQLNET.AUTHENTICATION_SERVICES= (NTS)

    NAMES.DIRECTORY_PATH= (TNSNAMES, ONAMES, HOSTNAME)

    ----------------------------
    i attached above the config. files of my Oracle 9.2.0.1

    I get TNS - 12560 error when i try to login using scott/tiger in SQLPlus.

    I searched the forums and internet and couldn't find any solution..

    Can anyone help me with this error or anyone guide me to a clean installation on XP for Oracle9.2..

    I've Java1.5, Eclipse 3.3, Tomcat 6.0 also installed.

    Thanks in advance.

  2. #2
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,333
    your database service isnt started for what you are trying to connect to

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