Posted on 2011-04-27
Last Modified: 2012-05-11
I have two machines adjacent in which oracle installed..
Is there any way to access database in another machine using the first machine...
adjusting tnsnames.ora

Question by:nobleit
    LVL 76

    Accepted Solution


    Set up a tnsnames.ora file with the information for the other servers database and listener information.

    Then just use the alias set up in the tnsnames.ora file:

    Sqlplus user/password@aliasName

    Where aliasName is the name in the tns file.
    LVL 5

    Assisted Solution


    Yes, you can access the database from other machine if both the machines are in same network.
    If there is no network between these two machines then you cannot access it...

    If it is under same network the copy the tns entry and paste it in the tnsnames.ora file from where you want to access and test using the tnsping utility... then connect to the db using the sqlplus.

    LVL 1

    Expert Comment

    I have reopened your question and started the process of closing it with a split amongst two or more Experts, as that outcome seems more equitable than your original disposition.
    EE Admin

    Featured Post

    Looking for New Ways to Advertise?

    Engage with tech pros in our community with native advertising, as a Vendor Expert, and more.

    Join & Write a Comment

    Article by: Swadhin
    From the Oracle SQL Reference ( we are told that a join is a query that combines rows from two or more tables, views, or materialized views. This article provides a glimps…
    Configuring and using Oracle Database Gateway for ODBC Introduction First, a brief summary of what a Database Gateway is.  A Gateway is a set of driver agents and configurations that allow an Oracle database to communicate with other platforms…
    This video shows how to copy a database user from one database to another user DBMS_METADATA.  It also shows how to copy a user's permissions and discusses password hash differences between Oracle 10g and 11g.
    Via a live example, show how to take different types of Oracle backups using RMAN.

    728 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    18 Experts available now in Live!

    Get 1:1 Help Now