Category Archives for Unix

Install Oracle Enterprise Linux 5.2 on VMware server 2.0

This is part II of series Installing Oracle Database (10g/11g) on Oracle Enterprise Linux 5.2 using Vmware Server 2.0. For part I – Download VMware, Oracle Enterprise Linux and creating Virtual Machine on Windows  Click Here In last post we started Virtual Machine using Green Arrow button, once Virtual Machine (Linux) is Up start console by clicking on Console […]

Read More

Download & Install VMware 2.0 and Oracle Enterprise Linux for Oracle Database

This post is for our 10g DBA or Oracle Apps (11i/R12) DBA training here Top Level Steps 1. Download and Unzip Oracle Enterprise Linux 5   2. Download and Install VMware server on Windows Machine 3. Configure Linux Machine on VMware Server 4. Install Oracle Enterprise Linux 5 on VMware server 2.0 5. Install 10g Database or Oracle […]

Read More

LDAP Installation and Migration

  How to Migrate LDAP server to another machine with same architecture? The following article explains simple way to install and migrate LDAP server. I have taken two machines (host1.example.com and host2.example.com) with Oracle Enterprise Linux 4, as it is available free.  Host1 machine is already installed and running with LDAP server and now we need to […]

Read More

Managing Yum @ Redhat / Oracle Enterprise 4

Most of the times while we are installing prerequisites for the oracle installation, its some what painful to get the updated rpms and dependencies, especially in Redhat Enterprise and Oracle Enterpirse version 4.  The following document explains us to overcome this issue. Yum is the easiest way to keep all programs up to date. It […]

Read More

Recover an accidentally deleted file when the database is still open.

On Unix/Linux, when a file is deleted, but a process still has the file open, the file is still there in the filesystem, and only the inode is removed. But the process can continue to use its file handle, and the file can also be accessible under /proc/<pid>/fd . In the following example, we use […]

Read More

Embedding SQL in Shell

Embedding a SQL inside Shell Script:- Here is a tip on how to run sqlplus scripts within a shell script. This is an example of how to pass database values into shell variables, and to make shell scripts more dynamic. This will help DBA to automate certain DBA tasks, also to setup some automation using […]

Read More

Root password Recovery SUN,AIX, LINUX(Redhat) and HP-UX

I am trying  to cover   the password file information and root password recovery . It is not the task of DBA but sometimes the knowledge of Unix administration task help us to do the activities in effective manner . Password file information of root :- Operating system Sun Solaris :-  /etc/passwd and /etc/shadow   Operating system […]

Read More

Share files/folders from Windows to Linux on VMWare

This post is for our Online Apps DBA trainees trying to install Oracle Application on Virtual Linux machine. If you install Linux O.S. as (Guest Operating System) on top of your existing windows machine using VMware virtual Server check here, Next step is to copy R12/11i/oracle software from windows machine to VMware Linux O.S. Steps […]

Read More

Introduction to Zones : Solaris 10

This post covers new feature ZONESintroduced in Solaris 10,  zone is virtualized solaris operating system within Solaris. You can install multiple Solaris Operating System (Multiple Machine) with in Single Big Machine. This will help in consolidating multiple small Solaris machine into one big machine with multiple Solaris operating system each running different application. Zones: is virtualized […]

Read More

How to find PID listening particular Port on Linux/Solaris 10

If you are trying to run any apps service (adapcctl.sh, opmnctl, lsnrctl) and get message like  “unable to bind port <port_number>” (Most probably this port is in use by other process), fix is to either start your service on different port or terminate process listening on that particular port using kill -9 <pid> In order […]

Read More