Showing posts with label Oracle on Linux. Show all posts
Showing posts with label Oracle on Linux. Show all posts

Wednesday, June 30, 2010

Sendmail and sm-client very slow on boot - Solution

I observer that when database server (Linux 5.x 64-bit) restart "sendmail" and "sm-client" very slow. normally it take 5 to 8 minutes.

currently have a redhat box named "primarydb." /etc/hosts looks like this:

# Do not remove the following line, or various programs
# that require network functionality will fail.
::1 localhost6.localdomain6 localhost6
127.0.0.1 localhost.localdomain localhost
192.168.1.1 primarydb primarydb
192.168.1.2 physicaldb physicaldb
192.168.1.3 logicaldb logicaldb

If I change the hosts file back to it's original setting, this does not occur. Just change /etc/hosts like this, just add one new line:

127.0.0.1 primarydb.localdomain primarydb
or
127.0.0.1 primarydb localhost.localdomain localhost

Contents after changing /etc/hosts, will be like this:

::1 localhost6.localdomain6 localhost6
127.0.0.1 localhost.localdomain localhost
127.0.0.1 primarydb.localdomain primarydb
192.168.1.1 primarydb primarydb
192.168.1.2 physicaldb physicaldb
192.168.1.3 logicaldb logicaldb

Sunday, February 21, 2010

Removing Oracle Database from RedHat Linux

If want to remove oracle database from Oracle RedHat Enterprize Linux, just follow following process for removing oracle database from RedHat 4.7

1. go into the base directory of orcale like /oradisk/app/oracle then delete all files.
2. Next, go into /usr/local/bin then delete all files
3. Next , go into /etc then delete oraInst.loc and oratab files.
4. Next, restart the system.

Tip: Use Emacs text editor if, some problems in .bash_profile or dbstart configuration file

Saturday, February 20, 2010

Auto Startup and Shutdown Oracle Database on Linux

Follow the following steps for configuring Automating Database Startup and Shutdown on Linux


1. Once the instance is created, edit /etc/oratab file setting the restart flag for each instance to 'Y'.

  ORCL:/oradisk/app/oracle/product/10.2.0:Y

2. Next, create a file /etc/init.d/dbstart as the root user, containing the following.

Installing Oracle Database on Linux

First of all install Oracle Enterprise Linux 4 operating system for installing oracle database on linux os just read my previous post Installing Oracle Enterprise Linux OS for Oracle Database

Configuring/Preparing Enterprise Linux OS for Oracle Database

Linux Operating system is installed successfully, now you need to configure it for installing oracle database. This section walks through the steps required to configure Oracle Enterprise Linux 4 OS for Oracle Database 10g Release 2.

Thursday, February 11, 2010

Installing Linux for Oracle Database

.
In this tutorial, you learn how to install Oracle Database 10gR2 on Oracle Enterprise Linux 4 Following are the linux distributions certified for Oracle Database 10g Release 2:

Oracle Enterprise Linux 5 (OEL5)
Oracle Enterprise Linux 4 (OEL4)
Red Hat Enterprise Linux 5 (RHEL5)
Red Hat Enterprise Linux 4 (RHEL4)
Red Hat Enterprise Linux 3 (RHEL3)
Novell SUSE Linux Enterprise Server 10 (SLES10)
Novell SUSE Linux Enterprise Server 9 (SLES9)
Asianux 2.0
Asianux 1.0

This guide assumes a server with the following hardware: