oracle 9.2.0.1 installation problem

[inventsekar_1]

hpux 11.11
oracle 9.2.0.1
after su - oracle
i gave sqlplus and this is the error:
----------------------------------------
/usr/lib/pa20_64/dld.sl: Unable to find library 'libwtc9.sl'.
Abort(coredump)
----------------------------------------
i am new to oracle.
so dont know what to do.

[Arunvijai_4]

Hi Sekar,

From user "oracle", type # echo $SHLIB_PATH
And if you dont see a path to libwtc9.sl, you need to search and export it.

# export SHLIB_PATH=$SHLIB_PATH:

-Arun

[inventsekar_1]

Hi arun,
----------------------
$ echo $SHLIB_PATH
/usr/lib
----------------------
and also while installing, there was some errors and i gave some softlinks.
i think there may be something wrong with the softlinks.

and do u have a list of softlinks, so that i can check it.

[Indira Aramandla]

Hi Sekar,

Check you variables are set properly.
SHLIB_PATH, LD_LIBRARY_PATH, ORACLE_HOME

The problem could be with setuid and setgid. This turns off library path search.

dld disables any dynamic library searching through environment variables, SHLIB_PATH for 32-bit and 64-bit mode, and LD_LIBRARY_PATH for 64-bit mode. If a library only exists in the directory specified in SHLIB_PATH (or LD_LIBRARY_PATH), you get the runtime error "library not found"


IA

[Arunvijai_4]

Hi Sekar,

You need to find out where is libwtc9.sl in your system and export it to SHLIB_PATH.

# find / -name "libwtc9.sl" will do..

Also, make sure your ORACLE_HOME is correctly setup as Indira suggested.

-Arun

[Indira Aramandla]

Hi Sekar,

check the ldd command for more details.

Have a look at this thread.

http://forums1.itrc.hp.com/service/forums/questionanswer.do?threadId=713819


Indira A

[Eric Antunes · Accepted solution]

Hi Sekar,

your SHLIB_PATH and LD_LIBRARY_PATH seem to be incomplete.

SHLIB_PATH should be something like this (at least):

$ORACLE_HOME/lib:/usr/lib


LD_LIBRARY_PATH should be something like this (at least):

$ORACLE_HOME/lib:/usr/dt/lib:/usr/openwin/lib


Best Regards,

Eric Antunes

[inventsekar_1]

i found the libwtc9.sl path and got four results:(2 here)
---------------
/u01/app/oracle/product/9.2.0.1/lib/libwtc9.sl
/u01/app/oracle/product/9.2.0.1/lib32/libwtc9.sl
-----------------
then i did:
$ export SHLIB_PATH=$ORACLE_HOME/lib
----------
NOW
$sqlplus
working fine and asking me user name.
i have installed this oracle and while installing i created only one user "oracle"..

now my questions:
1. $ export SHLIB_PATH=$ORACLE_HOME/lib
or $ export SHLIB_PATH=$ORACLE_HOME/lib32

what Indira said, i am not able to understand. so explain me in simple.
2. do i need to create any user for sqlplus? or when i tried to login with user name "oracle" ...
----------------------------------------
$ export SHLIB_PATH=$ORACLE_HOME/lib
$ echo $SHLIB_PATH
/u01/app/oracle/product/9.2.0.1/lib
$ sqlplus

SQL*Plus: Release 9.2.0.1.0 - Production on Mon Mar 13 11:24:00 2006

Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.

Enter user-name: oracle
Enter password:
ERROR:
ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
HP-UX Error: 2: No such file or directory


Enter user-name:
----------------------------------------

3. i need to check whether oracle installed properly or not..?is there any command available for that?...


thanks a lot..

[Yogeeraj_1]

hi,

----
3. i need to check whether oracle installed properly or not..?is there any command available for that?...
----

the only way to check that is to query the installation log files for errors.

it should normally be found in the following path:
/oraInventory/logs/

file names looks as such:
installActions2006-03-07_01-23-40PM.log


hope this helps!

kind regards
yogeeraj

[Yogeeraj_1]

hi again,

---
2. do i need to create any user for sqlplus? or when i tried to login with user name "oracle" ...
---

You don't really create users for "sqlplus". You can user sqlplus as a tool (or any other available tool) to create database users.

but... the problem you are getting here is related to your environment settings.

kind regards
yogeeraj

[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