by Ramesh Natarajan on May 18, 2009
Starting up and shutting down the oracle listener is a routine task for a database administrator. However a Linux system administrator or programmer may end-up doing some basic DBA operations on development database. It is critical for non-DBAs to understand the basic database admin activities.
In this article, let us review how to start, stop, check status of an oracle listener using Oracle listener control utility LSNRCTL.
(more…)
by Ramesh Natarajan on January 26, 2009
For a DBA, starting up and shutting down of oracle database is a routine and basic operation. Sometimes Linux administrator or programmer may end-up doing some basic DBA operations on development database. So, it is important for non-DBAs to understand some basic database administration activities.
In this article, let us review how to start and stop an oracle database.
(more…)
by Ramesh Natarajan on October 2, 2008
This is a 16 step Oracle 11g installation guide that covers a typical installation scenario with screenshots.
1. Select installation method
Following two installation methods are available:
- Basic Installation – Choose this to perform the full Oracle Database 11g installation with standard configuration options. You can use only filesystem for storage in this option.
- Advanced Installation – This gives your full control over the installation, including the ability to choose Automatic Storage Management. Select this option as shown below.
(more…)
by Ramesh Natarajan on August 25, 2008
Oracle offers Linux distribution, that is based on Red Hat Linux. Should you use Oracle Linux Distro? I’ll provide appropriate information that will help you to answer this question. I have also provided screenshots of a Linux upgrade using Oracle Enterprise Linux.
(more…)