Categories

JAVA DATEBASE
Technology Network Community
Oracle Database
Fusion Middleware
Development Tools
Java
Desktop
Server & Storage Systems
Enterprise Management
Berkeley DB Family
Cloud Computing
Big Data
Business Intelligence
Architecture
Migration and Modernization
E-Business Suite
Siebel
PeopleSoft Enterprise
JD Edwards World
Industries
JD Edwards EnterpriseOne
User Productivity Kit Pro (UPK) and Tutor
Governance, Risk & Compliance (GRC)
Master Data Management (MDM)
Oracle CRM On Demand
On Demand: SaaS and Managed Applications
AutoVue Enterprise Visualization
Primavera
ATG
Agile PLM
Endeca Experience Management
Fusion Applications
Archived Forums

 



Tags

PeopleSoft General Discussion


Missing or invalid version of SQL Library PSORA with 8.50


Although unsupported, I am trying to get a HCM 9.1 on PT 8.50.05 running on a 64 bit Windows 7 Pro laptop.  Running 11.1.0.7 Windows 2008 64 bit Oracle.    I installed the 32 bit Oracle 11.1.0.7 client for Win2008 also.  Every thing seems OK until I try to start an App Server domain.   I can login two-tier via PS.  I can connect sqlplus with SYSADM and people.  I ran the VERSION AE process without incident. Datamover runs fine with PS and bootstrap.  When I try to boot my domain, I get the "Missing or invalid version of SQL library PSORA (200,0)" error.  In stderr file it notes "LoadLibraryA() in pscompat.dll failed for 'PSORA.dll': reason=126".  I have the path to my 32bit client files within the app servers' AddtoPath setting.  I even tried using the UseLocalOracleDB settings but that didn't help either.  Any of you smart folks have any suggestions (aside from using a Supported OS and calling Oracle support)?

Well, not only Peoplesoft issue, but Oracle database issue. Oracle has not yet delivered the database software for Windows 7. Whether Peopletools 8.50 is fully 64bit compliant, it must use 32bit Oracle client libraries on Windows... understand who can. Anyway, it seems you are trying to use the 32bit libraries from within the Appserver configuration file, right ? Did you reconfigure the domain after modification ? I already installed and ran same config on W2k8 without problem. Did you have a look into the appserver log ?  Nicolas.

I set the app server log fence to 5 and it still doesn't provide any real insight.  Sorry if this i little long:  PSADMIN.3916 (0) [01/25/10 10:00:51](0) Begin boot attempt on domain HR91DMO PSAPPSRV.2868 (0) [01/25/10 10:01:28](0) PeopleTools Release 8.50.05 (WinX86) starting. Tuxedo server is APPSRV(99)/2 PSAPPSRV.2868 (0) [01/25/10 10:01:28](4) Server Environment: PSAPPSRV.2868 (0) [01/25/10 10:01:28](4) Server Configuration Settings: {logging level=5, sql trace=15, client sql trace mask=12319, peoplecode trace=0, client PC trace mask=4095, Time-out=0, recycle count=1000, max conseq svc failures=0, database type=ORACLE, database name='HR91DMO', database server='*****', user id='PS', connect id='people'} PSAPPSRV.2868 (0) [01/25/10 10:01:28](0) Cache Directory being used: C:\PT8.50\PS_CFG_HOME\appserv\HR91DMO\CACHE\PSAPPSRV_2\ PSAPPSRV.2868 (0) [01/25/10 10:01:28](1) GenMessageBox(200, 0, M): PS General SQL Routines: Missing or invalid version of SQL library PSORA (200,0) PSAPPSRV.2868 (0) [01/25/10 10:01:28](1) GenMessageBox(0, 0, M): Database Signon: Could not sign on to database HR91DMO with user PS. PSAPPSRV.2868 (0) [01/25/10 10:01:28](0) Server failed to start PSADMIN.3916 (0) [01/25/10 10:01:35](0) End boot attempt on domain HR91DMO   Tux log just has  100106.MPMCT3!tmadmin.2164.2188.-2: TMADMIN_CAT:1330: INFO: Command: boot -A 100109.MPMCT3!tmboot.3816.3796.-2: 01-25-2010: Tuxedo Version 10.3.0.0 with VS2005, 32-bit 100109.MPMCT3!tmboot.3816.3796.-2: CMDTUX_CAT:1851: INFO: TM_BOOTTIMEOUT is set to 120 seconds 100109.MPMCT3!tmboot.3816.3796.-2: CMDTUX_CAT:1855: INFO: TM_BOOTPRESUMEDFAIL option is selected 100113.MPMCT3!BBL.3872.3804.0: 01-25-2010: Tuxedo Version 10.3.0.0 with VS2005, 32-bit, Patch Level (none) 100113.MPMCT3!BBL.3872.3804.0: LIBTUX_CAT:262: INFO: Standard main starting 100115.MPMCT3!tmboot.3076.696.-2: 01-25-2010: Tuxedo Version 10.3.0.0 with VS2005, 32-bit 100115.MPMCT3!tmboot.3076.696.-2: CMDTUX_CAT:1851: INFO: TM_BOOTTIMEOUT is set to 120 seconds 100115.MPMCT3!tmboot.3076.696.-2: CMDTUX_CAT:1855: INFO: TM_BOOTPRESUMEDFAIL option is selected 100117.MPMCT3!PSWATCHSRV.356.1968.-2: 01-25-2010: Tuxedo Version 10.3.0.0 with VS2005, 32-bit 100117.MPMCT3!PSWATCHSRV.356.1968.-2: LIBTUX_CAT:262: INFO: Standard main starting 100127.MPMCT3!PSAPPSRV.2868.1040.0: 01-25-2010: Tuxedo Version 10.3.0.0 with VS2005, 32-bit 100127.MPMCT3!PSAPPSRV.2868.1040.0: LIBTUX_CAT:262: INFO: Standard main starting 100128.MPMCT3!PSAPPSRV.2868.1040.0: LIBTUX_CAT:250: ERROR: tpsvrinit() failed 100129.MPMCT3!tmboot.3076.696.-2: tmboot: CMDTUX_CAT:827: ERROR: Fatal error encountered; initiating user error handler 100132.MPMCT3!BBL.3872.3804.0: CMDTUX_CAT:26: INFO: The BBL is exiting system 100135.MPMCT3!PSADMIN.3916: End boot attempt on domain HR91DMO  Stderr has this  LoadLibraryA() in pscompat.dll failed for 'PSORA.dll': reason=126  Edited by: Chris.C on 25-Jan-2010 1:25 PM

I got it.  I think the 11g installer is a bit different. To correct and get my App server domain booted, I needed to copy all the files from  C:\oracle\product\11.1.0\client_1 folder to the C:\oracle\product\11.1.0\client_1\BIN   I think PSORA.dll specifically looks for oci.dll and other files here.  Might just be able to copy key files but I don't have the time to determine which ones.

Chris - you are a brave soul trying to do this on Windows 7. Have you thought about using the delivered Window 7s VM Tool and install an image with a supported OS and go from there?

Chris.C wrote: I got it.  I think the 11g installer is a bit different. To correct and get my App server domain booted, I needed to copy all the files from  C:\oracle\product\11.1.0\client_1 folder to the C:\oracle\product\11.1.0\client_1\BIN  Hmmm, that's rather weird, maybe it is coming from your own installation.  Nicolas.

Hmmm, that's rather weird, maybe it is coming from your own installation.  I think you are correct.  I tried again and all files were present.  Initally for the 32bit client install, I accidently kept the default option to do the "Instant Client" install.  I later went back an re-ran with the "Administrative Tools" install.  Maybe something got messed up that way.  A shame as it spent a bit of time on that issue.  8.50 on Windows 7 has been suprising easy so far.  I did look into the new Oracle VM downloads but decided to stick with the devil I know.  That fact that the Oracle VM host machine runs direclty on the hardware with no host O/S turned me off.  I am working with a stand alone laptop not a server and client(s) machines.

There are others possibilities than Oracle VM. You could install any virtual software on top of your Windows host, "VMWare server" for instance (it is free of charge), create a virtual machine, install OEL (Oracle Entreprise Linux, it is free of charge), then install Peoplesoft into that one. Your main OS will remain Windows 7, then you can start your guest OS whenever you want or need it for your Peoplesoft training or study exactly like if it was a remote server.  Nicolas.

Chris C,  Could you please summarize your configuration and extra undocumented steps taken to have PeopleSoft working on Windows 7.  That will really help me in my install process.  Regards

To install Oracle Enterprise Linux, do you need both Source and the other executible (just saw that there were two different things on the Oracle download site), one just mentioned some cryptic name like _x66... while the other said source. Kinda confused, about what i would need on windows 7.

Unless you want to rewrite or re-compile OEL, you should leave "source" and download only the ready to install cd/dvd. For instance : Enterprise Linux Release 5 Update 4 for x86_64 (64 Bit) - DVD which means OEL 5.4 64bit  Nicolas.

Thank you. I apprecite your prompt response. Would i have to ftp the install files, once i have installed enterprise  Linux on Windows 7 ?  Thanks in advance. Regards

user10509606 wrote: Thank you. I apprecite your prompt response. Would i have to ftp the install files, once i have installed enterprise  Linux on Windows 7 ?  Or the simplest way, and space safer, is to share a NFS point between your host OS and your guest OS for the Peoplesoft installer binaries.  Nicolas.

Does that require any additional software ? How do i go about it on windows 7 host and linux guest. Sorry, don't mean to be too demanding, but need your advice and  blessings to get this install started. Thank you

You could do a NFS mount with Cygwin http://gasparotto.blogspot.com/2007/12/on-peoplesoft-road-cygwin-xclient-and.html Or just share a directory http://kamranagayev.wordpress.com/2009/04/06/mount-windows-folder-on-linux/ I don't know if both solutions are working under Windows 7 though, but you could have a try.  Nicolas.


Related Links

Limitation with CI?
Hardware architecture recommendations for PS 9.1
how to connect database on server from client with peopletools?
How to Migrate Webservices from one environment to another
About Application Workflow Engine
Process Sheduler not posting report.
Process scheduler picking up trace settings that are not currently on
about database creation in Peoplesoft.
8.50 Related Content External URLs
Peoplesoft HRCS 9.0, Peopletools 8.50 - Install issues SQL Server2005,SP3
Peoplesoft upgrade delta site
sorry, wrong forum posted
minimum memory_target??
Need help on query - on psaccesslog table – URGENET PLEASE.
SCROLLABLEGRID option invisible on PSOPTIONS page
cannot call psconfig.sh