oracle 9.2.0.1 installation problem

[tcsa]

Here is a link to a good site. Since you are new to oracle you may find some useful info on this site:

www.oracle-base.com

They have some step-by-step articles on oracle installation.
Another useful document will be the installation guide on OTN. otn.oracle.com


Good luck.

[Indira Aramandla]

Hi Sekar,

Your questions:

1. $ export SHLIB_PATH=$ORACLE_HOME/lib
or $ export SHLIB_PATH=$ORACLE_HOME/lib32

You need export SHLIB_PATH=$ORACLE_HOME/lib

Now first thing you need to do is check if you oracle installation was completed successfully. Check the install logs for any errors. As Yogeeraj mentioned, check in the oraInventory/logs.

If there are any errors fix them and then try to logon.

You can logon to the database using sqlplus where you can log on in any of the following ways.

You can logon as sysdba using sqlplus / connect as sysdba without any password.
You can logon using sqlplus / without any username or password when you logon to the OS as an user that is defined in the database and is OS authernticated.

You can logon using sqlplus username/password or username/password@oracle_sid.

In you can the errors that you are experiencing with sqlplus "Oracle not available:"
Did you check you ORACLE_SID. To make sure you are logingin to a database that is up and running.


Indira A

[Yogeeraj_1]

hi,

below a quote from metalink note 109621.1:


5. WHICH VARIABLE SHOULD BE SET FOR 64 BIT ORACLE?

A 64 bit install of Oracle includes both 32 bit executables (such as svrmgrl and sqlplus) and 64 bit executables (such as oracle).

The installation contains two 'lib' areas:
Prior to 9i:
$ORACLE_HOME/lib - 32 bit libs
$ORACLE_HOME/lib64 - 64 bit libs
9i onwards:
$ORACLE_HOME/lib32 - 32 bit libs
$ORACLE_HOME/lib - 64 bit libs

Both of these directories contain libraries of the same name. To ensure that 32 bit executables search the 32 bit dir, and 64 bit executables search the 64 bit dir, set the following:

Prior to 9i:
$LD_LIBRARY_PATH - includes $ORACLE_HOME/lib64, but not $ORACLE_HOME/lib
$SHLIB_PATH - includes $ORACLE_HOME/lib, but not $ORACLE_HOME/lib64

9i onwards:
$LD_LIBRARY_PATH - includes $ORACLE_HOME/lib, but not $ORACLE_HOME/lib32
$SHLIB_PATH - includes $ORACLE_HOME/lib32, but not $ORACLE_HOME/lib


hope this helps too!

kind regards
yogeeraj