Hi Fred, Please see following output. Looks okay below configuration. please suggest. Thanks.
sqlplus SQL*Plus: Release 11.2.0.3.0 Production on To Nov 1 20:46:44 2012 Copyright (c) 1982, 2011, Oracle. All rights reserved. cd $ORACLE_HOME/lib ls -al libclntsh* lrwxr-xr-x 1 oraars oinstall 45 okt 8 08:45 libclntsh.so -> /ems/u01/product/11.2.0/lib/libclntsh.so.11.1 lrwxr-xr-x 1 oraars oinstall 12 okt 8 08:39 libclntsh.so.10.1 -> libclntsh.so -rwxr-xr-x 1 oraars oinstall 120559664 okt 8 08:46 libclntsh.so.11.1 -rwxr-xr-x 1 oraars oinstall 120559664 okt 8 08:39 libclntsh_nopthread.so -- Sandeep Pandey Remedy Developer On Fri, Nov 2, 2012 at 1:08 AM, Grooms, Frederick W < [email protected]> wrote: > 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" > _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are"
