Andrei DANEASA

I wrote a lot how to install loopback adapter, how to set the ip address (either manual or automatically), how to add an entry to hosts file (either manual or automatically). Now let’s add all together into a single script.
The script will do the following:

• call DevCon to install Microsoft Loopback Adapter (you need to download DevCon and save it in the same folder as the script)
• set the IP address and mask for the recently installed loopback adapter
• dinamically read from Windows folder the hosts file
• dinamically read the hostname
• add a new entry to the hosts file with the supplied IP address and hostname
• ping the hostname and check if the supplied IP address is responded
• MOST IMPORTANT: everything is dynamic and automatic. You don’t need to edit the script before each install. Just run it!

You can download this script here: Read the rest of this entry »

As a common practice all the servers have fixed IP address. Because not all Oracle Databases are installed directly on servers, but on laptops or different machines, it’s very probable that you have DHCP-provided IP address.
If you have DHCP IP address, your full computer name may vary, because different domain is added to computer name. Once the name can be mylaptop.oracle.com, the next day the name can be mylaptop.myhomenetwork.ro and so on.
The problem is when you want to install Oracle Database Enterprise Manager (web-based administration tool), because the installer is creating a folder on the disk have the name based on fully computer name. If you change the network the Enterprise Manager will not work, because it will not find a folder based on the actual computer name.
Enterprise Manager is not crucial , it’s just an interface, so if you don’t want to install it your database will work the same and you will configure the database through SQL*Plus or SQL Developer or Toad or what third party admin you want.
Read the rest of this entry »