LAMP & Oracle Technical Information

If you want to use just SQLPLUS, you do not have to install Oracle Client Software.
It is gonna be very easy to use it.

1. Download an instant client

   Download Oracle Instant Client from http://www.oracle.com/technology/software/tech/oci/instantclient/htdocs/... Instant Client Package
   - "Basic" and "Instant Client Package"

   Like :

   oracle-instantclient11.2-basic-11.2.0.1.0-1.x86_64.rpm
   oracle-instantclient11.2-sqlplus-11.2.0.1.0-1.x86_64.rpm

The followings are what you need to do in order to have java in your Firefox on 64bit Linux.

1. Update: Use Firefox from your distro repository.

2. Download JRE 6uxx (latest version from SUN) and install Java to any desired folder.
    (Suggest : /usr/lib/jvm folder for Ubuntu users, this is where Ubuntu places Java by default)

3. Installation (LInux x64 RPM)

    * The downloaded file might be in your desktop folder.

You have noticed on RedHat & CentOS, there is no PHP-MSSQL module/extension available in the default yum repositories.
So if you want to use it, you can search php-mssql and download it from the follwoing URL. You do not configure ODBC or use sybase extension.

URL: http://rpm.pbone.net/

Example :

The Yellowdog Updater, Modified (YUM) is an open-source command-line package-management utility for RPM-compatible Linux operating systems
and has been released under the GNU General Public License. Suddenly you can not update any packaged by yum.
So you need to clear yum cache with the following command. Probably after thet, you would undate old packages.

You could see the following error message in the Apache log after Oracle EBS Application installation.

[Wed Dec 23 08:03:24 2009] [error] [client 192.168.10.10] [ecid: 1261584204:192.168.17.20:8726:0:4098,0]
File does not exist: /d01/oracle/PROD/inst/apps/PROD_myserver/portal/favicon.ico

This explains how to use Telnet to test Simple Mail Transfer Protocol (SMTP) communication between messaging servers. By default,
SMTP listens on port 25. If you use Telnet on port 25, you can enter the SMTP commands that are used to connect to an SMTP server
and send a message exactly as if your Telnet session was an SMTP messaging server. You can see the success or failure of each
step in the connection and message submission process.

GNU GRUB is a Multiboot boot loader. It was derived from GRUB, the GRand Unified Bootloader.
boot loader is the first software program that runs when a computer starts.
It is responsible for loadingand transferring control to the operating system kernel software.
A GRUB installation consist of at least two and sometimes three executables,

known as stages.

You just need to get a backup created, and you want to take the simpllest approach.

BACKUP :

Command to back up your entire database:

You should see a list of RMAN message displaying information.

To display information about your backup, use the list backup command as follows :

You attempted to use RMAN to backup your database and received the following error message:

RMAN-03009: failure of backup command on ORA_DISK_1 channel
ORA-196602: cannot backup or copy active file in NOARCHIVELOG mode

This message indicates that before you can create an RMAN online backup. you need to place your database
into archivelog mode.

Enabling Archivelog Mode :