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

Thread: Remote client connection 2 server

  1. #1
    Join Date
    May 2003
    Location
    Pretoria, Rep of South Africa
    Posts
    191

    Remote client connection 2 server

    Greetings

    Problem:client connection to remote server
    I need to make a remote connection to a server as a client. could anyone assist me in the configuration of the connection. I have never performed a remote connection before.
    Info i have:
    Public_IP
    db_name(not global)
    username
    password
    Should it look something like this to create link:

    1.create database link db_name.global
    connect to username identified by password
    using 'db_name';

    2.in tns: note global=NAMES.DEFAULT_DOMAIN

    db.global =
    (DESCRIPTION =
    (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = TCP)(HOST = 000.00.00.000)(PORT = ####))
    )
    (CONNECT_DATA =
    (SID = db_name)
    (GLOBAL_NAME=db_name.global)
    )
    )


    Thanx 4 your assistance



    Able was I ere I saw Elba

  2. #2
    Join Date
    Oct 2002
    Posts
    807
    Yup, that looks alright. What's your problem? What's the error message?

  3. #3
    Join Date
    May 2003
    Location
    Pretoria, Rep of South Africa
    Posts
    191
    When i try 2 connect i get a timeout "error".
    but...when I ping the IP I get an immediate response
    Able was I ere I saw Elba

  4. #4
    Join Date
    May 2003
    Location
    Pretoria, Rep of South Africa
    Posts
    191
    what about my SQLNET config. connection?

    NAMES.DEFAULT_DOMAIN = "globalname"
    SQLNET.AUTHENTICATION_SERVICES= (NTS)
    NAMES.MAX_OPEN_CONNECTIONS = 4

    anything wrong here?
    Able was I ere I saw Elba

  5. #5
    Join Date
    Jul 2002
    Location
    Northampton, England
    Posts
    612
    You say you can ping the IP, but can you TNSPING the DBNAME to name sure your listener is contactable?

    ....Contactable? Is that a word?....

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