When you run the SQLPLUS does it come up and show it is the Oracle 11 version?
#> sqlplus
SQL*Plus: Release 11.2.0.1.0 Production on Thu Nov 1 13:45:36 2012
Copyright (c) 1982, 2009, Oracle. All rights reserved.
If I remember correctly you also need to go in and add a symbolic link in the
oracle library directory. To check do the following:
#> cd $ORACLE_HOME/lib
#> ls -al libclntsh*
You will see something like:
-rwxrwxr-x 1 {user} {group} 45396816 Sep 9 2010
libclntsh.so.11.1
lrwxrwxrwx 1 {user} {group} 17 Jan 6 2011 libclntsh.so
-> libclntsh.so.11.1
lrwxrwxrwx 1 {user} {group} 12 Jan 6 2011
libclntsh.so.10.1 -> libclntsh.so
In your case you probably only have "libclntsh.so.11.1". If so then create
the 2 symbolic links:
#> ln -s libclntsh.so.11.1 libclntsh.so
#> ln -s libclntsh.so libclntsh.so.10.1
Fred
-----Original Message-----
From: Action Request System discussion list(ARSList)
[mailto:[email protected]] On Behalf Of Sandeep Pandey
Sent: Thursday, November 01, 2012 1:24 PM
To: [email protected]
Subject: Re: HP UX: Upgrading install Oracle failed to connect the database.
** Hi Patrick,
Sorry....went for vacation.
Still the same issue we are facing today "Failed to connect database" and in
installer log we found following line.
"LOG EVENT {Description=[SET PROPERTY
VALIDATION_ERROR_RESULT],Detail=INVALID_OCI_ORACLE_CONNECTION_UNIX]}"
We tried to fix by all possibilities from our side but no luck. Seems something
is missing still some where.
LD_LIBRARY_PATH is pointing now to the 64bit.
I am able to do sqlplus and tnsping as well. Please suggest.
--
Sandeep Pandey
Remedy Developer
-----Original Message-----
On Thu, Oct 25, 2012 at 1:27 AM, patrick zandi wrote:
** Can I assume.. you are working sir ?
-----Original Message-----
On Tue, Oct 23, 2012 at 9:42 AM, patrick zandi wrote:
it should say something like 11.2.0/lib
-----Original Message-----
On Tue, Oct 23, 2012 at 9:40 AM, patrick zandi wrote:
There is your problem right there..
LD_LIBRARY_PATH=/ems/u01/
product/10.2.0/lib:
10.2 is 32bit -- not 64bit.. so it looks like your DBA are blowing smoke..
-----Original Message-----
On Tue, Oct 23, 2012 at 9:29 AM, Sandeep Pandey wrote:
** Hi Patrick,
Able to do sqlplus and TNSPING as well.
We did LD_LIBRARY_PATH is pointing to the 64bit as per dbs confirms, but no
hope.
LD_LIBRARY_PATH=/ems/u01/product/10.2.0/lib:/ems/u01/product/10.2.0/lib32 is
set like this currently.
--
Sandeep Pandey
Remedy Developer
-----Original Message-----
On Tue, Oct 23, 2012 at 5:59 PM, patrick zandi wrote:
** prior to installing can you use sqlplus and login,
can you do a TNSPING?
if those are working -- off the 64bit side.. then you should be fine..
but if you LD_LIBRARY_PATH is pointing to the 32bit, first, and not the 64bit
first..
and you cannot use the sqlplus from the 11.. this is a great start
On Tue, Oct 23, 2012 at 8:27 AM, Sandeep Pandey <[email protected]>
wrote:
** Yes Patrick,
You are correct. Yes we are pointing new oracle client 64 bit for install
upgrade. Do you know any fix or solution for this?
--
Sandeep Pandey
Remedy Developer
-----Original Message-----
On Tue, Oct 23, 2012 at 5:50 PM, Patrick Zandi wrote:
**
But you are using 7.1 : that does not use 64 bit, so here is the thought. Is
you box with oracle 32 bit client 10 let's say and 11.2 in the same box, so is
your selection for the install pointing to the new client? Just asking. 2
different paths... Just a thought
Sent from my iPhone
-----Original Message-----
On Oct 23, 2012, at 7:49, Sandeeps Pandey wrote:
** Hi Patrick,
We are using 64 bit clients only. But not able to proceed.
Checked everything tnsnames.ora, listner, env etc in place and running fine.
--
Sandeep Pandey
Remedy Developer
-----Original Message-----
On Tue, Oct 23, 2012 at 5:08 PM, Patrick Zandi wrote:
**
64 bit libraries
You went from 32 to 64
You need 64bit client looks like ur issue
Sent from my iPhone
-----Original Message-----
On Oct 23, 2012, at 6:55, Karthik wrote:
** I had this issue way back when i was installing 5.x on HP UX and it was
issue with oracle binaries being wrongly installed.
Did you check the compatibility matrix and install the correct binaries? Double
check this please as the error says the same here
- Karthik
-----Original Message-----
On 23 October 2012 16:10, Sandeep Pandey wrote:
** Dear List,
We are facing one issue when we trying to upgrade the 7.1 P11 to 7.6.04 SP 3
ARS on HP-UX i3. We are running installer and one point of time getting below
error.
Warning! Failed to connect to the database.
Possible causes: tnsnames.ora does not exist or has incorrect connection
details
Missing 64 bit Oracle client libraries
Insufficient privileges for oracle client libraries.
Error in insall log:
LOG EVENT {Description=[SET PROPERTY BMC_LEGACY_ARCFG_EXISTS],Detail=[true]}
(Oct 22 2012 12:49:22.319 PM
+0200),CONFIG,com.bmc.install.task.InstallationPropertiesHelper,
LOG EVENT {Description=[SET PROPERTY
VALIDATION_ERROR_RESULT],Detail=[INVALID_OCI_ORACLE_CONNECTION_UNIX]}
(Oct 22 2012 12:49:22.329 PM
+0200),INFO,com.bmc.install.product.arsuitekit.platforms.arsystemservers.arserver.ARServerDatabaseOptionsValidationTask,
LOG EVENT {Description=[Validation
error],Detail=[INVALID_OCI_ORACLE_CONNECTION_UNIX]}
(Oct 22 2012 12:49:22.764 PM
+0200),CONFIG,com.bmc.install.builder.installanywhere.InstallationTaskAction,
LOG EVENT {Description=[COMPLETED
InstallationTask],Detail=[com.bmc.install.product.arsuitekit.platforms.arsystemservers.arserver.ARServerDatabaseOptionsValidationTask]}
(Oct 22 2012 12:51:12.791 PM
+0200),CONFIG,com.bmc.install.task.InstallationPropertiesHelper,
LOG EVENT {Description=[SET PROPERTY
VALIDATION_ERROR_RESULT],Detail=[VALIDATION_SUCCESS]}
(Oct 22 2012 12:51:12.811 PM
+0200),CONFIG,com.bmc.install.task.InstallationPropertiesHelper,
LOG EVENT {Description=[SET PROPERTY VALIDATION_FEATURE],Detail=[]}
We did so many things but no help.
Anyone see or fix?
--
Sandeep Pandey
Remedy Developer
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are"
