topic Re: oracle 9.2.0.1 installation problem in Operating System - HP-UX

oracle 9.2.0.1 installation problem

inventsekar_1 — Thu, 02 Mar 2006 00:24:40 GMT

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.

Re: oracle 9.2.0.1 installation problem

Arunvijai_4 — Thu, 02 Mar 2006 00:32:00 GMT

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

Re: oracle 9.2.0.1 installation problem

inventsekar_1 — Thu, 02 Mar 2006 00:44:24 GMT

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.

Re: oracle 9.2.0.1 installation problem

Indira Aramandla — Thu, 02 Mar 2006 00:47:26 GMT

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

Re: oracle 9.2.0.1 installation problem

Arunvijai_4 — Thu, 02 Mar 2006 00:51:50 GMT

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

Re: oracle 9.2.0.1 installation problem

Indira Aramandla — Thu, 02 Mar 2006 01:01:56 GMT

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

Re: oracle 9.2.0.1 installation problem

Eric Antunes — Fri, 03 Mar 2006 07:36:09 GMT

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

Re: oracle 9.2.0.1 installation problem

inventsekar_1 — Mon, 13 Mar 2006 00:57:48 GMT

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..

Re: oracle 9.2.0.1 installation problem

Yogeeraj_1 — Mon, 13 Mar 2006 01:36:21 GMT

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

Re: oracle 9.2.0.1 installation problem

Yogeeraj_1 — Mon, 13 Mar 2006 01:47:20 GMT

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

Re: oracle 9.2.0.1 installation problem

tcsa — Mon, 13 Mar 2006 01:48:19 GMT

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.

Re: oracle 9.2.0.1 installation problem

Indira Aramandla — Mon, 13 Mar 2006 02:10:47 GMT

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

Re: oracle 9.2.0.1 installation problem

Yogeeraj_1 — Mon, 13 Mar 2006 02:39:11 GMT

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