Installation of Oracle on loopback adapter

Posted on 2006-05-29
Last Modified: 2008-01-09
I have installed oracle on loopback adapter.

I have confusion regarding its use -
1. Will I be able to use all the features of oracle installed on loopback adapter, compared to those available to the one installed on domain server?
2. What is the actual difference in installing on loopback and installing on domain server?
3. When I do a 'tnsping' it shows loopback adapter's IP Address - as HOST.  Can I change the oracle's host to be other than loop back adapter - now, I mean after the installation?
4. Will this oracle database be available to other computers in the network, though it is installed on a machine's loopback adapter?

Pl help, I am planning to reinstall oracle on a domain server(windows XP) becos of all of these problems!!! I am getting a fixed IP Address from a router.
Question by:at999
    LVL 142

    Accepted Solution

    1) yes
    2) none
    3) yes. configure the listener.ora file (in $ORACLE_HOME/network/admin resp. in the $TNS_ADMIN folder)
    4) no (unless the listener.ora file config is changed)

    Author Comment


    I changed configuration in listener.ora, and restarted oracle, but after tnsping, it shows the host with same ip address as before - loopback adapter's!!!
    LVL 142

    Expert Comment

    by:Guy Hengel [angelIII / a3]
    >and restarted oracle
    you only need to restart the listener, not the oracle database
    LVL 142

    Expert Comment

    by:Guy Hengel [angelIII / a3]
    also, from the client (which is the server itself here), you need to adjust the tnsnames.ora file to reflect the good ip address (or host name).
    if tnsnames.ora uses a hostname, and the os resolves that name into the loopback adapter's address, then you have to check the hosts files

    Author Comment

    Thank you very much AngelIII the answers u gave has solved lot of my confusion regarding oracle's installation.

    I dont understand what do u mean by - 'Check the host files' - what host files?

    Featured Post

    Gigs: Get Your Project Delivered by an Expert

    Select from freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely and get projects done right.

    Join & Write a Comment

    Truncate is a DDL Command where as Delete is a DML Command. Both will delete data from table, but what is the difference between these below statements truncate table <table_name> ?? delete from <table_name> ?? The first command cannot be …
    Working with Network Access Control Lists in Oracle 11g (part 2) Part 1: Previously, I introduced the basics of network ACL's including how to create, delete and modify entries to allow and deny access.  For many…
    This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
    This video shows how to configure and send email from and Oracle database using both UTL_SMTP and UTL_MAIL, as well as comparing UTL_SMTP to a manual SMTP conversation with a mail server.

    745 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

    16 Experts available now in Live!

    Get 1:1 Help Now