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