Jump to content


Photo
- - - - -

v6 oracle error


6 replies to this topic

#1 jschokman

jschokman

    Newbie

  • Members
  • Pip
  • 3 posts

Posted 01 November 2007 - 06:26 AM

Hi. We are getting an error when testing ver 6 greenscreen on linux and oracle 10g. The error is :

p4 err : 373
SYSerr : 0175
SYSmsg : libproivora10g.so

The .so file is readable, full permissions. The error occurs when we try to read a table in a function , ie. proisam only functions won't generate the error.

Any ideas?

James

#2 Cleve Haynes

Cleve Haynes

    Expert

  • Members
  • PipPipPipPip
  • 172 posts
  • Gender:Male

Posted 01 November 2007 - 09:40 AM

Hi James

Do you have your LD_LIBRARY_PATH environment variable set correctly? Ie, is the path where libproivora10g.so lives set in your LD_LIBRARY_PATH?

If you look at the "runproiv" script in <proiv install dir>/virtual_machine, it sets the LD_LIBRARY_PATH. E.G:

#!/bin/ksh
   #
   check_file_in_named_path(){
	 TOKENS=`echo $2 | sed -e 's;:;;g'`
	 if [ -n "$TOKENS" ]; then
	   for i in $TOKENS; do
		 if [ -d "$i" ]; then
		   if [ -f "$i/$1" ]; then
			 return 1
		   fi
		 fi
	   done
	 fi
	 echo "A required library could not be found: $1"
	 exit 1
   }
   
   CDATE_50=Y
   DATE_SC_50=Y
   JAVA_HOME=/usr/opt/java142/jre
   LD_LIBRARY_PATH=$LD_LIBRARY_PATH:$JAVA_HOME/lib/alpha:/usr/proiv/6.1.13.0/virtual_machine/lib
   PROIV_HOME=/usr/proiv/6.1.13.0/virtual_machine
   PROPATH=/usr/proiv/6.1.13.0/virtual_machine/boots
   PRODATA=/usr/proiv/6.1.13.0/virtual_machine/boots
   PROTERM=GUIDEV
   #PROTERM=DECVT220
   PATH=/usr/proiv/6.1.13.0/virtual_machine:/sbin:/usr/sbin:/usr/bin:/usr/ccs/bin:/usr/bin/X11:/usr/local:/usr/lo
   cal/bin
   PRORUNTYPE=DEV
   TP_ROLLBACK=N
   INFORMIXDIR=/usr/proiv/6.1.13.0/virtual_machine/boots
   export CDATE_50 DATE_SC_50 TP_ROLLBACK INFORMIXDIR
   export PROTERM PROPATH PRODATA PRORUNTYPE JAVA_HOME LD_LIBRARY_PATH PROIV_HOME
   cd $PROPATH
   check_file_in_named_path libcstubs.so $PROIV_HOME/lib
   check_file_in_named_path libextsub.so $PROIV_HOME/lib
   check_file_in_named_path libOraProCLogon2.so $PROIV_HOME/lib
   check_file_in_named_path libOraProCLogon.so $PROIV_HOME/lib
   check_file_in_named_path libp4core.so $PROIV_HOME/lib
   check_file_in_named_path libp4java.so $PROIV_HOME/lib
   check_file_in_named_path libp4serp.so $PROIV_HOME/lib
   check_file_in_named_path libp4ssoAPI.so $PROIV_HOME/lib
   check_file_in_named_path libToolbarsAndMenusModel.so $PROIV_HOME/lib
   
   MISSLIBS=`ldd /usr/proiv/6.1.13.0/virtual_machine/pro | grep "not found" | uniq | awk '{print $1;}'`
   if [ "$MISSLIBS" != "" ]; then
	 echo "A required library could not be found: $MISSLIBS"  
	 exit 1
   fi
   
   exec /usr/proiv/6.1.13.0/virtual_machine/pro $*

If it's not the LD_LIBRARY_PATH, it could also be some other environment variables or /etc/pro4v6.ini settings related to Oracle.

HTH's,

Cleve

#3 jschokman

jschokman

    Newbie

  • Members
  • Pip
  • 3 posts

Posted 01 November 2007 - 09:51 AM

Cleve! Thanks mate - yes the LD_LIBRARY_PATH and the ORACLE_DLLNAME are both set. Should've mentioned that.

#4 Neil Hunter

Neil Hunter

    ProIV Guru

  • Members
  • PipPipPipPipPip
  • 414 posts
  • Gender:Male
  • Location:Johannesburg, South Africa

Posted 01 November 2007 - 11:59 AM

Directory access to virtual_machine and the lib directory within that?

You aren't by any chance running on 64 bit?

#5 jschokman

jschokman

    Newbie

  • Members
  • Pip
  • 3 posts

Posted 01 November 2007 - 12:13 PM

Directory access to virtual_machine and the lib directory within that?

Hi , what's the deal with 64 bit?

Here's the proof of access :

[~]-[proiv]$ echo $ORACLE_DLLNAME
/opt/northgate/proiv_version_6/virtual_machine/lib/libproivora10g.so

[~]-[proiv]$ echo $LD_LIBRARY_PATH
/opt/northgate/proiv_version_6/virtual_machine/lib:/opt/oracle/OracleHomes/db10g/lib:/usr/lib/jvm/java-1.5.0-ibm-1.5.0.4.x86_64/jre/lib

[~]-[proiv]$ ls -ltra /opt/northgate/proiv_version_6/virtual_machine/lib/libproivora10g.so
-rwxrwxrwx 1 root root 7931 Oct 4 18:40 /opt/northgate/proiv_version_6/virtual_machine/lib/libproivora10g.so

[~]-[proiv]$ ls -ltra /opt/oracle/OracleHomes/db10g/lib/libclntsh.so
lrwxrwxrwx 1 oracle oinstall 51 Jun 27 14:03 /opt/oracle/OracleHomes/db10g/lib/libclntsh.so -> /opt/oracle/OracleHomes/db10g/lib/libclntsh.so.10.1

#6 Neil Hunter

Neil Hunter

    ProIV Guru

  • Members
  • PipPipPipPipPip
  • 414 posts
  • Gender:Male
  • Location:Johannesburg, South Africa

Posted 01 November 2007 - 12:19 PM

If you are running 64 bit, you need LD_LIBRARY_PATH_64 as well...

What are the permissions on opt, northgate etc ?

In other words does your user have read access to work their way from opt to lib?

#7 jdc99

jdc99

    Newbie

  • Members
  • Pip
  • 1 posts
  • Gender:Male

Posted 02 November 2007 - 11:21 AM

On our working systems we set ORACLE_DLLNAME=libproivora10g.so i.e. with out the path. I believe pro looks for it in it s virtual_machine/lib directory by default, although we have added this to LD_LIBRARY_PATH.

If this doesn't work I would suggest logging on as the user and then cd to /opt/northgate/proiv_version_6/virtual_machine/lib and then run ldd libproivora10g.so this may give you more informationas to why it is not working



Reply to this topic



  


0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users