Change Access Password

The symbolic ID is the account used by PeopleSoft to link users (operators) to the system account which is stored as ACCESSID in the PSACCESSPRFL record and encrypted.
Syntax to change or update password is:
CHANGE_ACCESS_PASSWORD [SymbolicID] [Password]
Alternative Method:
If user(“SYSADM” for Oracle and “SA” for MSS) is altered by the below query,

ALTER USER username IDENTIFIED BY password

then below scripts need to execute.

UPDATE PSSTATUS SET OWNERID = 'SYSADM';
UPDATE PSOPRDEFN SET SYMBOLICID = 'SYSADM1', OPERPSWD = OPRID, ENCRYPTED = 0;
UPDATE PSACCESSPRFL SET ACCESSID = 'SYSADM', SYMBOLICID = 'SYSADM1', ACCESSPSWD = 'SYSADM', VERSION = 0, ENCRYPTED = 0;
GRANT SELECT ON PSSTATUS TO people;
GRANT SELECT ON PSOPRDEFN TO people;
GRANT SELECT ON PSACCESSPRFL TO people;

Now login to Data-Mover in bootstrap mode and execute the below script.

 
REM - ENCRYPT PASSWORD
/
SET LOG d:\dbsetup_log\encrypt.log;
ENCRYPT_PASSWORD *;
/

Note: Make sure Connect-ID (people) account is not locked and correctly entered to configuration manager.

Tuxedo 10gR3_VS2005 Installation for PeopleSoft.

While installing Tuxedo 10gR3_VS2005 oh higher you may get error because NLSPATH and TUXDIR registry may not be created properly.

So follow the below steps:

Step 1. Create a folder to install Tuxedo and specify the path in the registry as mentioned below.

Step 2. Add the registry content as mentioned below.

Add String value.

Then Edit String as follows.

Step 3. Run the Tuxedo setup.

PeopleTools 8.5x - Windows - Missing or invalid version of SQL library PSORA (200,0)

Error:
PeopleSoft Application Server fails to start on a Windows system where the PeopleTools version is 8.50. Specifically, the PSAPPSRV process generates an initialization error when booting. The following messages are logged to the APPSRV log:

PSAPPSRV.2692 (0) [01/26/10 14:10:10](0) Cache Directory being used: C:\Documents and Settings\hrtuxedo\psft\pt\8.50\appserv\dmo91\CACHE\PSAPPSRV_2\
PSAPPSRV.2692 (0) [01/26/10 14:10:10](1) GenMessageBox(200, 0, M): PS General SQL Routines: Missing or invalid version of SQL library PSORA (200,0)
PSAPPSRV.2692 (0) [01/26/10 14:10:10](1) GenMessageBox(0, 0, M): Database Signon: Could not sign on to database DMOHR191 with user PS.
PSAPPSRV.2692 (0) [01/26/10 14:10:10](0) Server failed to start
PSADMIN.3116 (0) [01/26/10 14:10:17](0) End boot attempt on domain dmo91

 

 
Cause:
The first logged error message refers to an invalid or missing PSORA library file. This message indicates that the PSAPPSRV process is not able to load the library. It may be that it cannot locate it or that the library located is not compatible with this current version of Tools.

Solution:

PeopleTools 8.5x has been certified to run on 64bit Windows platforms but the program itself is 32bit. This means that any library it needs to load also needs to be 32bit.

The Oracle client lib 'PSORA' for instance, must be the 32bit version rather than the 64bit version.

If you have the 64bit Oracle client installed please uninstall it and install the 32bit version. Also, make sure the 'Add to Path' entry in the psappsrv.cfg file reflects the 32 bit binaries location.

If PSAPPSRV is successfully loading the PSORA library then you will not see this logged message:

GenMessageBox(200, 0, M): PS General SQL Routines: Missing or invalid version of SQL library PSORA (200,0)

ORA-12560 "TNS protocol adapter error" (Tns: Protocol Adapter Error Ora-12560 Connecting Via Sqlplus)

Cause:  The ORACLE_SID is not set in the environment

Solution:

To implement the solution, please execute the following steps (for Multiple Oracle Homes Or One oracle Home):
===============================================================
ORACLE_SID variables should only be set in the appropriate registry key that corresponds to the software installation. In this case it should be set back to Original (old) instance name for taking it as default ORACLE_SID.

For 8i and 9i, this would be:
----------------------------
HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\HOME(n)


For 10g and 11g, this would be:
-----------------------------------
HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\ORACLE\KEY_

OR

You may execute the following steps (If only one Oracle Home installed ) to set variables at system level :
======================================================================

1. Go to: My Computer >> right click >> Properties >> Advanced >> Env variables >> System

2. Add new variable

3. Enter ORACLE_SID as the variable name

4. Enter the database sid as the value