Monday, 15 February 2016

PeopleSoft Records containing email address

The following four table gives you the information regarding the email addresses in PeopleSoft.

select * from PS_EMAIL_ADDRESSES
select * from PSOPRDEFN
select * from PSUSEREMAIL
select * from PS_ROLEXLATOPR

Tuesday, 23 April 2013

How to clone root account in linux


If you want to make your account have the same right as root, you can clone root / duplicate root account. Here’s how to do that :

Suppose you have create user admin and you want that user to have the same right as root then you can do that just by simply typing the following command (make sure you login with root account or su) :

# usermod -u 0 admin
or
$ sudo usermod -u 0 admin

that's it … try login with user admin and if you got the # prompt, you know what it means …

Saturday, 26 May 2012

ORA-00022: invalid session ID; access denied Process ID: 10610 Session ID

This is related to Second DB Connection, and can be worked around.  In the  psappsrv.cfg & psprcs.cfg make the DbFlags=4, to disable Second DB Connection.

Thursday, 3 May 2012

Missing or Invalid Version of SQL Library libpsora

Taken from customer connection..



E:AS Missing or Invalid Version of SQL Library libpsora PeopleTools 8.48+ on Oracle 10g and 11i [ID 650409.1]

Modified 30-MAR-2012     Type PROBLEM     Status ARCHIVED

In this Document
  Symptoms
  Cause
  Solution

Applies to:

PeopleSoft Enterprise PT PeopleTools - Version: 8.48 to 8.51   [Release: 8.4 to 8.4]
Generic Linux
***Checked for relevance on 23-Aug-2011***

Symptoms

Application server can't start because of bad link.  The application server is looking for a library that does not exist: dlopen in libpscompat failed for libpsora.sl: ld.so.1: PSAPPSRV: fatal: libclntsh.sl.9.0: open failed: No such file or directory

stderr file has errors similar to:

/usr/lib/pa20_64/dld.sl: Unable to find library 'libclntsh.sl.9.0'.


stdout file has the error:

shl_load in libpscompat failed for libpsora.sl


Cause

Not Applicable

Solution

PeopleSoft now supports 64 bit Oracle for PeopleTools 8.48 and later. The library libclntsh.so.10.1 (Oracle 10g) libclntsh.so.11.1 (Oracle 11i) must be linked in the 64 bit lib directory.

NOTE: On Linux platforms for PeopleTools 8.48 and 8.49 we are still using the 32 bit libraries for the application server. Starting with PeopleTools 8.50 Linux now uses the 64 bit libraries. Make sure you are linking the libclntsh.sl.9.0 file from the $ORACLE_HOME/lib32 directory if running 64 bit Linux prior to PeopleTools 8.50. If you have only installed the Oracle 32 bit client on Linux you may only have the lib directory and not lib32, so do the link from the lib directory in this case.

If stderr error reports an error with libclntsh.sl.9.0, run the link command in the $ORACLE_HOME/lib directory as the oracle user :

     ln -s $ORACLE_HOME/lib/libclntsh.sl.10.1 libclntsh.sl.9.0    (Oracle 10g)

     ln -s $ORACLE_HOME/lib/libclntsh.so.11.1 libclntsh.sl.9.0    (Oracle 11i)

If stderr error reports an error with libclntsh.so.9.0, run the link command in the $ORACLE_HOME/lib directory as the oracle user :

     ln -s $ORACLE_HOME/lib/libclntsh.so.10.1  libclntsh.so.9.0   (Oracle 10g)
     
     ln -s $ORACLE_HOME/lib/libclntsh.so.11.1 libclntsh.so.9.0 (Oracle 11i)

** NOTE ** Check your library name in the $ORACLE_HOME/lib directory to make sure it it the exact name above. It the name differs replace above name with yours.


Make sure your LIBPATH, SHLIB_PATH or LD_LIBRARY_PATH references the $ORACLE_HOME 64 bit libraries ($ORACLE_HOME/lib).


Check your $PS_HOME/install/psdb.sh script and make sure the PATH's in there points to the 64 bit libraries for Oracle.

On PeopleTools 8.48+ the location of psdb.sh is $PS_HOME/setup

After fixing this, re-logon as the psoft account to reset your environment. Make sure you reconfigure your domain so it picks up the new changes. Check your $PS_HOME/appserv/DomainName/psappsrv.env file to ensure that your environment has the Oracle 64 bit libraries in your LIBPATH, SHLIB_PATH or LD_LIBRARY_PATH and not $ORACLE_HOME/lib32.