Administration

Oracle Database 11g: Interactive Quick Reference, Your Essential Guide to Oracle Database 11g Release 2

Last fall, I posted a note about Oracle Database 11g Architecture and Background Processes. This post is just a short note to point out that last week, Oracle University has made Oracle Database 11g Interactive Quick Reference available to public for download; it is a flash application, available for offline use in compressed file (.ZIP) …

Oracle Database 11g: Interactive Quick Reference, Your Essential Guide to Oracle Database 11g Release 2 Read More »

Enabling and Disabling Database Options

This is just a short note to point out that starting from Oracle database 11g Release 2, a command line utility, chopt (change option) is available to enable or disable a particular database feature; the tool is located under ORACLE_HOME/bin directory.  Currently, you can enable or disable the following features using this utility: Oracle Data Mining RDBMS Files, …

Enabling and Disabling Database Options Read More »

Upgrade path for Oracle Database 11g Release 1

Still quite a few remain in 7.3, 8.1.7 and 9.2.0.8 (ofcourse, without a support on very old versions and happy with what they have) – Others are gearing towards to upgrade to Oracle 11g Release 1. The recommended direct and indirect path upgrade listed below: Direct Upgrade Path Source Database Target Database 9.2.0.4.0 (or higher) 11.1.x 10.1.0.2.0 …

Upgrade path for Oracle Database 11g Release 1 Read More »

How to create an Oracle User to use both OS Authentication and Password Authentication

The initialization parameter REMOTE_OS_AUTHENT offers a trusted authentication model to the network, users can have OS accounts on machines other than the database server and gain access to database, convenience of single sign-on through remote OS authentication REMOTE_OS_AUTHENT accepts BOOLEAN value, FALSE is a default value, which can be altered via ALTER SYSTEM command. This …

How to create an Oracle User to use both OS Authentication and Password Authentication Read More »

How to run multiple Oracle database instances on a single server

You can have multiple instances on the same machine, each with their own data files,  either sharing the ORACLE_HOME or each with different ORACLE_HOME. ORACLE_HOME and ORACLE_SID are the key environment variables used by Oracle to identify an instance.  In addition $ORACLE_HOME/bin must be in your PATH environment variable. To check the value of these …

How to run multiple Oracle database instances on a single server Read More »

Prepare your Linux Server to install Oracle database using oracle-validated RPM

Preparing a Linux server to install oracle has been made easy with the help of oracle-validated rpm package. Install of oracle-validated automates the download and install of all required RPMs including dependencies, setup of Linux kernel parameters, creation of oracle user (Linux user) and dba, oinstall groups I have been thinking of trying out oracle-validated …

Prepare your Linux Server to install Oracle database using oracle-validated RPM Read More »

Managing Software Packages (aka RPMs) with Yum

Introduction Yum (Yellow dog Updater, Modified) automatic updater and package installer/remover for rpm systems. It automatically computes dependencies and figures out what things should occur to install packages. Packages also include a digital signature to identify their source. Software management utilities like yum and rpm verify these signatures using GPG public key. Yum and RPM …

Managing Software Packages (aka RPMs) with Yum Read More »

Managing Oracle database services

This post summarizes on how to start, stop and to check the status of Oracle database services. Oracle 10g Oracle Listener: To Start, execute the following command: $ su – oracle $ lsnrctl start To Stop, execute the following command: $ su – oracle $ lsnrctl stop Grid Control for Database Management: To Start, execute …

Managing Oracle database services Read More »

Removing Oracle 10g Software from Linux Server

This article briefs about the steps that are required to remove Oracle 10g software from Linux server using Oracle Universal Installer and manually. Removing Oracle 10g Software Using Oracle Universal Installer Identify all instances associated with the Oracle home: To identify all instances associated with the Oracle home that you want to remove, issue the …

Removing Oracle 10g Software from Linux Server Read More »