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

Thread: Ora-12560

Hybrid View

  1. #1
    Join Date
    Jan 2007
    Posts
    7

    Ora-12560

    Hi,
    I'm new in this forum.
    I have to following situation installed in one machine:
    - xp pro with oralce8174 (server and client)
    - rhel4 (vmware) with: oracle9i (server and client)

    Now, I would like to connect xp onto rhel4 using sqlplus.

    After started oracle9i and cofigurated the tnsnames.ora in xp

    RHEL4.WORLD =
    (DESCRIPTION =
    (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.33.99)(PORT = 1521))
    )
    (CONNECT_DATA =
    (SERVICE_NAME = MATRIX.WORLD)
    )
    )


    The HOST value is the IP for the network adapter per vmWare.

    When I try to connect myself I caught the error in title.
    can somebody help me ??

    PS:I have to tell that when I installed the rhel4 the db, I called it Matrix (sid) but it's also the machine name for xp

  2. #2
    Join Date
    Nov 2000
    Posts
    224
    Welcome to Forum.

    You are trying to connect XP as Client to a database server on RHEL4, Right?

    I will take the following steps
    1) On XP - Ping the ip address (ping 192.168.33.99)
    2) On RHEL4 - Make sure listener is running on RHEL4
    3) On XP - TNSPING RHEL4.WORLD
    4) SQL+

    If 1-3 fails, you can not connect using SQL+. Good Luck.

  3. #3
    Join Date
    Jan 2007
    Posts
    7
    thanks for answer,

    yes, I would try to connect XP on RHEL4 .

    I did the following steps:
    1) ping from xp to rhel4, ok !
    2) the listener works fine on rhel4
    3) tnsping RHEL4.WORLD does not work , and I caught the error ORA-12560 protocol adaptor error .


    I don't know what wrong !

  4. #4
    Join Date
    Mar 2004
    Location
    DC,USA
    Posts
    650
    Could you post the lsnrctl services output?
    "What is past is PROLOGUE"

  5. #5
    Join Date
    Jan 2007
    Posts
    7
    this is the listener.ora:


    # LISTENER.ORA Network Configuration File: /app/oracle/product/9.2.0/network/admin/listener.ora
    # Generated by Oracle configuration tools.

    LISTENER =
    (DESCRIPTION_LIST =
    (DESCRIPTION =
    (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = TCP)(HOST = rhel4)(PORT = 1521))
    )
    (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
    )
    )
    )

    SID_LIST_LISTENER =
    (SID_LIST =
    (SID_DESC =
    (SID_NAME = PLSExtProc)
    (ORACLE_HOME = /app/oracle/product/9.2.0)
    (PROGRAM = extproc)
    )
    (SID_DESC =
    (GLOBAL_DBNAME = MATRIX.WORLD)
    (ORACLE_HOME = /app/oracle/product/9.2.0)
    (SID_NAME = MATRIX)
    )
    )


    And this is wath happens with:
    $ lsnrctl start

    LSNRCTL for Linux: Version 9.2.0.4.0 - Production on 31-DEC-2006 09:24:11

    Copyright (c) 1991, 2002, Oracle Corporation. All rights reserved.

    Starting /app/oracle/product/9.2.0/bin/tnslsnr: please wait...

    TNSLSNR for Linux: Version 9.2.0.4.0 - Production
    System parameter file is /app/oracle/product/9.2.0/network/admin/listener.ora
    Log messages written to /app/oracle/product/9.2.0/network/log/listener.log
    Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=localhost.localdomain)(PORT=1521)))
    Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC)))

    Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=rhel4)(PORT=1521)))
    STATUS of the LISTENER
    ------------------------
    Alias LISTENER
    Version TNSLSNR for Linux: Version 9.2.0.4.0 - Production
    Start Date 31-DEC-2006 09:24:11
    Uptime 0 days 0 hr. 0 min. 0 sec
    Trace Level off
    Security OFF
    SNMP OFF
    Listener Parameter File /app/oracle/product/9.2.0/network/admin/listener.ora
    Listener Log File /app/oracle/product/9.2.0/network/log/listener.log
    Listening Endpoints Summary...
    (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=localhost.localdomain)(PORT=1521)))
    (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC)))
    Services Summary...
    Service "MATRIX" has 1 instance(s).
    Instance "MATRIX", status UNKNOWN, has 1 handler(s) for this service...
    Service "PLSExtProc" has 1 instance(s).
    Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
    The command completed successfully



    thanks for help.

  6. #6
    Join Date
    Mar 2004
    Location
    DC,USA
    Posts
    650
    You run the service Matrix but not Matrix.world. Correct this in your tnsnames and try sql+
    "What is past is PROLOGUE"

  7. #7
    Join Date
    Jan 2007
    Posts
    7
    I changed it, but doesn't work !!

  8. #8
    Join Date
    Jan 2007
    Posts
    7
    Sorry to everybody ..... I have forgotten to disable the firewall linux side.
    Now it works !!

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