• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1366
  • Last Modified:

Installation of Oracle on loopback adapter

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 - 169.254.25.129 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.
0
at999
Asked:
at999
  • 3
  • 2
1 Solution
 
Guy Hengel [angelIII / a3]Billing EngineerCommented:
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)
0
 
at999Author Commented:
AngelIII,

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!!!
0
 
Guy Hengel [angelIII / a3]Billing EngineerCommented:
>and restarted oracle
you only need to restart the listener, not the oracle database
0
 
Guy Hengel [angelIII / a3]Billing EngineerCommented:
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
0
 
at999Author Commented:
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?
0

Featured Post

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now