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

Thread: ORA-12513

  1. #1
    Join Date
    Jul 2000
    Posts
    147
    I am trying to connect to test database where I running two instances. I also update both TNSNAME.ORA and LISTNER.ORA. From some reason when I try to connect through sql from client side to one of the instance giving an error….

    ORA-12513: TNS: service handler found but it has registered for a different protocol

    But I can connect to other instance without any problem.

    I’m not sure what is wrong…any idea?

  2. #2
    Join Date
    Dec 1999
    Location
    Alpharetta, GA, US
    Posts
    192
    can you give us more detail.

    Thanks
    Chan
    OCP7.3/8.0/8i/9i
    Sun Certified Sys. Admin

  3. #3
    Join Date
    Oct 2000
    Location
    Saskatoon, SK, Canada
    Posts
    3,925
    They seems to have the different protocol. i.e check the tnsnames.ora and listener.ora files and make sure that the service_name that you are trying to call uses the same protocol. If they both are the same, then check your parameter file for the instance in the initSID.ora and make sure that you have specified the correct protocol adaptor name in the MTS_DISPATCHER parameter, incase if you are using the Multi threaded server option.

    Hope this would fix your problem. If not let us know.

    Sam
    Thanx
    Sam



    Life is a journey, not a destination!


  4. #4
    Join Date
    Jul 2000
    Posts
    147
    I think problem is in listener.ora. Both of my instances are running of my same ORACLE_HOME. Could it be the problem? Here is copy of my listner.ora…..
    I can tnsping both of my instances without any problem and locally I can connect through sql on both instance. It is when I connect from a client through sql I can connect to only one instance. My listener is running and both services is up.

    Thanks

    ################
    # Filename......: listener
    # Name..........:
    # Date..........:
    ################
    SQLNET.AUTHENTICATION_SERVICES = (NONE)
    USE_PLUG_AND_PLAY_LISTENER = OFF
    USE_CKPFILE_LISTENER = OFF
    LISTENER =
    (ADDRESS_LIST =
    (ADDRESS=
    (PROTOCOL=ipc)
    (KEY= db03.world)
    )
    (ADDRESS=
    (PROTOCOL=ipc)
    (KEY= db03)
    )
    (ADDRESS=
    (PROTOCOL=IPC)
    (KEY= testdb.world)
    )
    (ADDRESS=
    (PROTOCOL=IPC)
    (KEY= testdb)
    )
    (ADDRESS =
    (COMMUNITY = db03.world)
    (PROTOCOL = tcp)
    (Host = xxx.xxx.xxx.22)
    (Port = 1521)
    )
    )
    STARTUP_WAIT_TIME_LISTENER = 0
    CONNECT_TIMEOUT_LISTENER = 10
    TRACE_LEVEL_LISTENER = OFF
    SID_LIST_LISTENER =
    (SID_LIST =
    (SID_DESC =
    (GLOBAL_DBNAME = db03.world)
    (SID_NAME = db03)
    (ORACLE_HOME = /xtrn5/u01/home/oracle/product/8.0.5)
    (PRESPAWN_MAX = 10)
    )
    )
    SID_LIST_LISTENER =
    (SID_LIST =
    (SID_DESC =
    (GLOBAL_DBNAME = testdb.world)
    (SID_NAME = testdb)
    (ORACLE_HOME = /xtrn5/u01/home/oracle/product/8.0.5)
    (PRESPAWN_MAX = 10)
    )
    )



  5. #5
    Join Date
    Oct 2000
    Location
    Saskatoon, SK, Canada
    Posts
    3,925
    It could be an issue with the db03.world. At one point you seems to be calling it using the IPC and at another point you are calling the same instance with the TCP. Check that out.

    Sam
    Thanx
    Sam



    Life is a journey, not a destination!


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