Finishing Off

Posted 5 April, 2006 - 14:19

ORACLE Networking Files

Create the following files in ${ORACLE_HOME}/network/admin:

  • tnsnames.ora
  • sqlnet.ora
  • listener.ora
  • ldap.ora

There are numerous sample network configuration files provided as part of the installation.

Update /etc/oratab to ensure the instance will be brought up at boot time. Create an init.d script and activate it.

Final Steps

Reverse the changes made earlier regarding gcc and gcc296 (figure 1.0). As root,

Figure 1.0

# mv gcc gcc296
# mv gcc3 gcc

Replace the RPM files we removed earlier (figure 1.1).

Figure 1.1

##// First remove the Fedora Core 2 RPM
# rpm -e compat-gcc-7.3-2.96.126.i386

##// Reinstall the Fedora Core 4 RPMs
# rpm -ivh compat-gcc-32-3.2.3-47.fc4.i386.rpm
# rpm -ivh compat-gcc-32-c++-3.2.3-47.fc4.i386.rpm
# rpm -ivh compat-gcc-32-g77-3.2.3-47.fc4.i386.rpm

The database software installation is complete. The creation and establishment of the ORACLE database should follow this step.


Named Behaviour


I noticed that named did not function properly following a reboot and that a manual bounce was required to put things right each time. This is repeatable and traceable to the /etc/sysctl.conf entry (figure 1.2):

Figure 1.2

net.ipv4.ip_local_port_range = 1024 65000

When this line is commented out, named works fine on bootup. Setting the port range to the default values 32768 61000 also puts this right.

In Conclusion

At this point we are in a position to create the ORACLE database. The details for performing this activity rely upon DBA knowledge and won't be covered in this article. As we are using ORACLE 9i as a stepping stone, we'll leave these details for when we embark upon performing the same task for ORACLE 10g.

So there you have it. Some pointers in the general direction of getting ORACLE 9i running under Fedora Core 4 Linux. This is by no means a description that covers all possible eventualities - a thinking mind would be redundant otherwise - but it should be enough to provide a good whiff of the finishing line.