at999
asked on
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.
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.
ASKER CERTIFIED SOLUTION
![Avatar of Guy Hengel [angelIII / a3]](https://filedb.experts-exchange.com/files/public/2013/11/25/ddbe0ea6-aa6e-4279-b781-57b735dd3ea0.jpeg){kind=small}
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
>and restarted oracle
you only need to restart the listener, not the oracle database
you only need to restart the listener, not the oracle database
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
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
ASKER
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?
I dont understand what do u mean by - 'Check the host files' - what host files?
ASKER
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!!!