Simpler Navigation coming for Servers and Operating Systems
Coming soon: a much simpler Servers and Operating Systems section of the Community. We will combine many of the older boards, and you won't have to click through so many levels to get at the information you need. If you are looking for an older board and do not find it, check the consolidated boards, as the posts are still there.
cancel
Showing results for 
Search instead for 
Did you mean: 

oracle 9.2.0.1 installation problem

SOLVED
Go to solution
inventsekar_1
Respected Contributor

oracle 9.2.0.1 installation problem

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.
Be Tomorrow, Today.
12 REPLIES
Arunvijai_4
Honored Contributor

Re: oracle 9.2.0.1 installation problem

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
"A ship in the harbor is safe, but that is not what ships are built for"
inventsekar_1
Respected Contributor

Re: oracle 9.2.0.1 installation problem

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.
Be Tomorrow, Today.
Indira Aramandla
Honored Contributor

Re: oracle 9.2.0.1 installation problem

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

Never give up, Keep Trying
Arunvijai_4
Honored Contributor

Re: oracle 9.2.0.1 installation problem

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
"A ship in the harbor is safe, but that is not what ships are built for"
Indira Aramandla
Honored Contributor

Re: oracle 9.2.0.1 installation problem

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
Never give up, Keep Trying
Eric Antunes
Honored Contributor
Solution

Re: oracle 9.2.0.1 installation problem

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


Each and every day is a good day to learn.
inventsekar_1
Respected Contributor

Re: oracle 9.2.0.1 installation problem

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..
Be Tomorrow, Today.
Yogeeraj_1
Honored Contributor

Re: oracle 9.2.0.1 installation problem

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
No person was ever honoured for what he received. Honour has been the reward for what he gave (clavin coolidge)
Yogeeraj_1
Honored Contributor

Re: oracle 9.2.0.1 installation problem

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
No person was ever honoured for what he received. Honour has been the reward for what he gave (clavin coolidge)
tcsa
Frequent Advisor

Re: oracle 9.2.0.1 installation problem

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.
Determination is key for success.
Indira Aramandla
Honored Contributor

Re: oracle 9.2.0.1 installation problem

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
Never give up, Keep Trying
Yogeeraj_1
Honored Contributor

Re: oracle 9.2.0.1 installation problem

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
No person was ever honoured for what he received. Honour has been the reward for what he gave (clavin coolidge)