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

Thread: abuot mts config

  1. #1
    Join Date
    Nov 2000
    Posts
    9

    Question

    i have configured my database with mts option. but only local host can connected to it(sqlplus scott/tiger@testdb), on other machine, sqlplus can't connected to my database. why? below message is my config files in server and client , i need help.
    thanks.



    #################################
    #listener.ora in database server
    #################################
    LISTENER =
    (DESCRIPTION_LIST =
    (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = 10.1.1.228)(PORT = 9137))
    (PROTOCOL_STACK =
    (PRESENTATION = TTC)
    (SESSION = NS)
    )
    )
    (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = db)(PORT = 9138))
    (PROTOCOL_STACK =
    (PRESENTATION = TTC)
    (SESSION = NS)
    )
    )
    )

    CONNECT_TIMEOUT_LISTENER = 2

    SID_LIST_LISTENER =
    (SID_LIST =
    (SID_DESC =
    (GLOBAL_DBNAME = testdb.legend.com)
    (ORACLE_HOME = /app/oracle/product/release/8.1.5)
    (SID_NAME = testdb)
    )
    )


    #################################
    #init.ora in database server
    #################################

    mts_dispatchers = "(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))(DIS=2)(SES=254)(CON=254
    )(TIC=15)(POO=NO)(MUL=NO)(LIS=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=10.1.1.
    228)(PORT=9137))))"
    mts_dispatchers = "(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))(DIS=2)(SES=254)(CON=254
    )(TIC=15)(POO=NO)(MUL=NO)(LIS=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=10.1.1.
    228)(PORT=9138))))"

    mts_max_dispatchers = 100
    mts_servers = 2
    mts_max_servers = 20


    #################################
    #tnsnames.ora in client machine
    #################################
    testdb =
    (DESCRIPTION =
    (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = TCP)(HOST = 10.1.1.228)(PORT = 9137))
    )
    (CONNECT_DATA =
    (SERVICE_NAME = testdb.legend.com)
    )
    )

    #################################
    #error messgae in client machine
    #################################
    sqlplus
    Enter user-name: scott/tiger@testdb
    ERROR:
    ORA-12545: Connect failed because target host or object does not exist

    note: network is available and ip address is valid.

  2. #2
    Join Date
    Dec 1999
    Location
    Alpharetta, GA, US
    Posts
    192
    ftp your tnsnames.ora file from your server to Client and try.
    ie. update your client tnsnames.ora with your server tnsnames.ora

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

  3. #3
    Join Date
    Oct 2000
    Posts
    80
    Try this:
    TNSPING (or TNSPING80 depending on your client version)
    First try this:
    TNSPING testdb
    see what happens and report. If fails try
    TNSPING testdb.legend.com

    Also rename sqlnet.ora (if it's there) on client machine to something else(to make it invisible to Oracle) and retry.

  4. #4
    Join Date
    Nov 2000
    Posts
    9
    hi, Chandra and JDoyle:

    Thank your help !
    Chandra, I compared tnsnames.ora in client side and server side, find unique different is tnsnames.ora of server using hostname in "address" section, but in client, it using ip address in "address" section. i must to be add alias of server machine to /etc/hosts of clients , then i can connected to database. but when i removed that alias and changed alias to ip address , same error occured. why? i must be resolve this problem.
    JDoyle, i also renamed sqlnet.ora to other. but it also can't connected to my database.


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