Skip to Main Content
Forums

PeopleSoft Enterprise

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Invalid userid and or password when logging to application designer as PS/PS

user10704896Jan 3 2016 — edited Jan 5 2016

I have installed HRDEMO database on HCM 9.2 I ran all the configuration scripts to success except including grant.sql and datmover scripts which sure took a long time to complete. I am running in Windows Server 2012 environment for both server and client.

I can log on to datamover using userids, SYSADM, and PS, but I can not log on to Application server, for the life of me, I am only getting "invalid userid and password on signon" I turned on trace and I see some oracle errors of "table or view does not exist" on select statement on PSOPTIONS and PSSSTATUS table.

   Would anyone has any idea why this phenomena occurs,

I have pasted the trace file below for your attention

3-1  10.19.00         Cache Repair enabled
3-2  10.19.000.001000 Tuxedo session opened {oprid='PS', appname='TwoTier', addr='//TwoTier:7000', open at 0000002853FAA340, pid=1512}
3-3  10.19.000.036000 Cur#0.1512.HRDEMO RC=0 Dur=0.003000 --- router PSORA64 load succeeded
3-4  10.19.000.001000   PSORA pid=1512 - Initializing PSORA
3-5  10.19.000.000000   PSORA pid=1512 - Initializing PSDB maximum cursor = 1024
3-6  10.19.000.000000   PSORA pid=1512 - szSubKey=SOFTWARE\ORACLE\KEY_OraDB12Home1!
3-7  10.19.000.000000   PSORA pid=1512 - Environment change: AMERICAN_AMERICA.UTF8
3-8  10.19.000.000000   PSORA pid=1512 - OCIEnvCreate
3-9  10.19.000.000000   PSORA pid=1512 - OCIHandleAlloc(OCI_HTYPE_ERROR)
3-10 10.19.000.000000   PSORA pid=1512 - OCIAttrSet(OCI_HTYPE_ENV, OCI_ATTR_RESERVED_486)
3-11 10.19.000.065000   PSORA pid=1512 - PSORA Initialized post Oracle 12c
3-12 10.19.000.000000   PSORA pid=1512 - PSORA_Initialize() nStatus=0 0 0
3-13 10.19.000.001000 Cur#0.1512.HRDEMO RC=0 Dur=0.068000 INI
3-14 10.19.000.000000 Cur#0.1512.HRDEMO RC=0 Dur=0.000000 SET type=1003 value=4
3-15 10.19.000.000000   PSORA pid=1512 - OCIHandleAlloc(OCI_HTYPE_SERVER)
3-16 10.19.000.000000   PSORA pid=1512 - OCIServerAttach(HRDEMO)
3-17 10.19.000.000000   PSORA pid=1512 - OCIServerVersion()
3-18 10.19.000.040000   PSORA pid=1512 - Attached to new server HRDEMO 0 11.100100
3-19 10.19.000.000000   PSORA pid=1512 - OCIHandleAlloc, OCI_HTYPE_SPOOL
3-20 10.19.000.000000   PSORA pid=1512 - OCISessionPoolCreate server=HRDEMO sessMin=1 sessMax=5 sessIncr=0 user=PEOPLE
3-21 10.19.000.004000   PSORA pid=1512 - OCIHandleAlloc(OCI_HTYPE_AUTHINFO)
3-22 10.19.000.000000   PSORA pid=1512 - OCIAttrSet(OCI_HTYPE_AUTHINFO, OCI_ATTR_USERNAME, user=PEOPLE)
3-23 10.19.000.000000   PSORA pid=1512 - OCIAttrSet(OCI_HTYPE_AUTHINFO, OCI_ATTR_PASSWORD, password=****)
3-24 10.19.000.001000   PSORA pid=1512 - OCISessionGet(OCI_SESSGET_SPOOL SessionPoolName[0] server HRDEMO)
3-25 10.19.000.154000   PSORA pid=1512 - OCIAttrSet(OCI_HTYPE_SVCCTX,OCI_ATTR_STMTCACHESIZE)
3-26 10.19.000.000000   PSORA pid=1512 - OCIAttrGet(OCI_HTYPE_SVCCTX,OCI_ATTR_SERVER)
3-27 10.19.000.000000   PSORA pid=1512 - OCIAttrGet(OCI_HTYPE_SVCCTX,OCI_ATTR_SESSION)
3-28 10.19.000.000000   PSORA pid=1512 - Successfully logged into server HRDEMO as user PEOPLE
3-29 10.19.000.000000   PSORA pid=1512 - OCIAttrSet(OCI_HTYPE_SERVER, OCI_ATTR_FOCBK)
3-30 10.19.000.000000   PSORA pid=1512 - OCIAttrSet(OCI_HTYPE_ENV, OCI_ATTR_EVTCBK)
3-31 10.19.000.000000   PSORA pid=1512 - OCIAttrSet(OCI_HTYPE_ENV, OCI_ATTR_EVTCTX)
3-32 10.19.000.000000   PSORA pid=1512 - callbacks are registered
3-33 10.19.000.000000   PSORA pid=1512 - Made new connection: Primary :PEOPLE@HRDEMO 0
3-34 10.19.000.000000   PSORA pid=1512 - PS_sqlcch(0000002853FCD0D0)
3-35 10.19.000.000000 Cur#0.1512.HRDEMO RC=0 Dur=0.203000 Create Connection Info=Primary/HRDEMO/PEOPLE/ Handle=0000002853FCD0D0
3-36 10.19.000.000000   PSORA pid=1512 - PS_sqlopc(0000002853FCD0D0)
3-37 10.19.000.000000   PSORA pid=1512 - Cursor #1: connected to PEOPLE@HRDEMO
3-38 10.19.000.001000   PSORA pid=1512 - Cursor #1: found 0 bind column(s), last column 0
3-39 10.19.000.000000   PSORA pid=1512 - Cursor #1: about to Prepare: ALTER SESSION SET NLS_NUMERIC_CHARACTERS = '.,'
3-40 10.19.000.000000   PSORA pid=1512 - OCIStmtPrepare2(ALTER SESSION SET NLS_NUMERIC_CHARACTERS = '.,')
3-41 10.19.000.000000   PSORA pid=1512 - Cursor #1: about to Execute
3-42 10.19.000.000000   PSORA pid=1512 - OCIStmtExecute()
3-43 10.19.000.002000   PSORA pid=1512 - OCIAttrGet(OCI_HTYPE_STMT,OCI_ATTR_ROW_COUNT)
3-44 10.19.000.000000   PSORA pid=1512 - Cursor #1: found 0 bind column(s), last column 0
3-45 10.19.000.000000   PSORA pid=1512 - Cursor #1: about to Prepare: alter session set NLS_TIMESTAMP_FORMAT = 'YYYY-MM-DD-HH24.MI.SS.FF'
3-46 10.19.000.000000   PSORA pid=1512 - OCIStmtPrepare2(alter session set NLS_TIMESTAMP_FORMAT = 'YYYY-MM-DD-HH24.MI.SS.FF')
3-47 10.19.000.000000   PSORA pid=1512 - Initial OCIStmtRelease() succeeded, Cursor #1, Statement alter session set NLS_TIMESTAMP_FORMAT = 'YYYY-MM-DD-HH24.MI.SS.FF'
3-48 10.19.000.000000   PSORA pid=1512 - Cursor #1: about to Execute
3-49 10.19.000.000000   PSORA pid=1512 - OCIStmtExecute()
3-50 10.19.000.000000   PSORA pid=1512 - OCIAttrGet(OCI_HTYPE_STMT,OCI_ATTR_ROW_COUNT)
3-51 10.19.000.000000   PSORA pid=1512 - Cursor #1: found 0 bind column(s), last column 0
3-52 10.19.000.000000   PSORA pid=1512 - Cursor #1: about to Prepare: alter session set NLS_TIMESTAMP_TZ_FORMAT = 'YYYY-MM-DD-HH24.MI.SS.FF'
3-53 10.19.000.000000   PSORA pid=1512 - OCIStmtPrepare2(alter session set NLS_TIMESTAMP_TZ_FORMAT = 'YYYY-MM-DD-HH24.MI.SS.FF')
3-54 10.19.000.000000   PSORA pid=1512 - Initial OCIStmtRelease() succeeded, Cursor #1, Statement alter session set NLS_TIMESTAMP_TZ_FORMAT = 'YYYY-MM-DD-HH24.MI.SS.FF'
3-55 10.19.000.000000   PSORA pid=1512 - Cursor #1: about to Execute
3-56 10.19.000.000000   PSORA pid=1512 - OCIStmtExecute()
3-57 10.19.000.001000   PSORA pid=1512 - OCIAttrGet(OCI_HTYPE_STMT,OCI_ATTR_ROW_COUNT)
3-58 10.19.000.001000   PSORA pid=1512 - Cursor #1: found 0 bind column(s), last column 0
3-59 10.19.000.000000   PSORA pid=1512 - Cursor #1: about to Prepare: alter session set NLS_DATE_FORMAT = 'YYYY-MM-DD'
3-60 10.19.000.000000   PSORA pid=1512 - OCIStmtPrepare2(alter session set NLS_DATE_FORMAT = 'YYYY-MM-DD')
3-61 10.19.000.000000   PSORA pid=1512 - Initial OCIStmtRelease() succeeded, Cursor #1, Statement alter session set NLS_DATE_FORMAT = 'YYYY-MM-DD'
3-62 10.19.000.000000   PSORA pid=1512 - Cursor #1: about to Execute
3-63 10.19.000.000000   PSORA pid=1512 - OCIStmtExecute()
3-64 10.19.000.002000   PSORA pid=1512 - OCIAttrGet(OCI_HTYPE_STMT,OCI_ATTR_ROW_COUNT)
3-65 10.19.000.000000   PSORA pid=1512 - Cursor #1: found 0 bind column(s), last column 0
3-66 10.19.000.000000   PSORA pid=1512 - Cursor #1: about to Prepare: SELECT COUNT(*) FROM PSOPTIONS WHERE COLLATION_TYPE != '000'
3-67 10.19.000.000000   PSORA pid=1512 - OCIStmtPrepare2(SELECT COUNT(*) FROM PSOPTIONS WHERE COLLATION_TYPE != '000')
3-68 10.19.000.000000   PSORA pid=1512 - Initial OCIStmtRelease() succeeded, Cursor #1, Statement SELECT COUNT(*) FROM PSOPTIONS WHERE COLLATION_TYPE != '000'
3-69 10.19.000.000000   PSORA pid=1512 - Cursor #1: found 1 Select column(s)
3-70 10.19.000.000000   PSORA pid=1512 - Cursor #1: No fetch buffers to set
3-71 10.19.000.000000   PSORA pid=1512 - Cursor #1: about to Execute
3-72 10.19.000.000000   PSORA pid=1512 - OCIStmtExecute()
3-73 10.19.000.003000   PSORA pid=1512 - OCIErrorGet()
3-74 10.19.000.000000   PSORA pid=1512 - Oracle error code: 942
3-75 10.19.000.000000   PSORA pid=1512 - ORA-00942: table or view does not exist
3-76 10.19.000.000000   PSORA pid=1512 - OCIAttrGet(OCI_HTYPE_STMT, OCI_ATTR_PARSE_ERROR_OFFSET)
3-77 10.19.000.000000   PSORA pid=1512 - Cursor #1: found 0 bind column(s), last column 0
3-78 10.19.000.001000   PSORA pid=1512 - Cursor #1: about to Prepare: SELECT UNICODE_ENABLED FROM PSSTATUS WHERE UNICODE_ENABLED = 1
3-79 10.19.000.000000   PSORA pid=1512 - OCIStmtPrepare2(SELECT UNICODE_ENABLED FROM PSSTATUS WHERE UNICODE_ENABLED = 1)
3-80 10.19.000.000000   PSORA pid=1512 - Initial OCIStmtRelease() succeeded, Cursor #1, Statement SELECT UNICODE_ENABLED FROM PSSTATUS WHERE UNICODE_ENABLED = 1
3-81 10.19.000.000000   PSORA pid=1512 - Cursor #1: found 1 Select column(s)
3-82 10.19.000.000000   PSORA pid=1512 - Cursor #1: No fetch buffers to set
3-83 10.19.000.000000   PSORA pid=1512 - Cursor #1: about to Execute
3-84 10.19.000.000000   PSORA pid=1512 - OCIStmtExecute()
3-85 10.19.000.002000   PSORA pid=1512 - OCIErrorGet()
3-86 10.19.000.000000   PSORA pid=1512 - Oracle error code: 942
3-87 10.19.000.000000   PSORA pid=1512 - ORA-00942: table or view does not exist
3-88 10.19.000.000000   PSORA pid=1512 - OCIAttrGet(OCI_HTYPE_STMT, OCI_ATTR_PARSE_ERROR_OFFSET)
3-89 10.19.000.000000 Cur#1.1512.notSamTran RC=0 Dur=0.028000 Open Cursor Handle=0000002853FCD0D0
3-90 10.19.000.000000 Cur#1.1512.HRDEMO RC=0 Dur=0.000000 GET type=1003 dbtype=4
3-91 10.19.000.000000   PSORA pid=1512 - OCIServerVersion(512,OCI_HTYPE_SERVER)
3-92 10.19.000.000000 Cur#1.1512.HRDEMO RC=0 Dur=0.001000 GET type=1004 release=12
3-93 10.19.000.000000   PSORA pid=1512 - Cursor #1: found 1 bind column(s), last column 1
3-94 10.19.000.000000   PSORA pid=1512 - Cursor #1: about to Prepare: SELECT OWNERID FROM PS.PSDBOWNER WHERE DBNAME=:1
3-95 10.19.000.000000   PSORA pid=1512 - OCIStmtPrepare2(SELECT OWNERID FROM PS.PSDBOWNER WHERE DBNAME=:1)
3-96 10.19.000.000000   PSORA pid=1512 - Initial OCIStmtRelease() succeeded, Cursor #1, Statement SELECT OWNERID FROM PS.PSDBOWNER WHERE DBNAME=:1
3-97 10.19.000.000000   PSORA pid=1512 - Cursor #1: found 1 Select column(s)
3-98 10.19.000.000000 Cur#1.1512.HRDEMO RC=0 Dur=0.001000 COM Stmt=SELECT OWNERID FROM PS.PSDBOWNER WHERE DBNAME=:1
3-99 10.19.000.000000 Cur#1.1512.HRDEMO RC=0 Dur=0.000000 SSB column=1 type=2 length=9 scale=0
3-10010.19.000.000000 Cur#1.1512.HRDEMO RC=0 Dur=0.000000 Bind-1 type=2 length=6 value=HRDEMO
3-10110.19.000.000000   PSORA pid=1512 - OCIBindByName(1,512,5)
3-10210.19.000.000000   PSORA pid=1512 - OCIAttrSet(OCI_HTYPE_BIND,OCI_UCS2ID,OCI_ATTR_CHARSET_ID)
3-10310.19.000.000000   PSORA pid=1512 - OCIAttrSet(OCI_HTYPE_BIND,768,OCI_ATTR_MAXDATA_SIZE)
3-10410.19.000.000000   PSORA pid=1512 - Cursor #1: bind buffers set size=1
3-10510.19.000.000000   PSORA pid=1512 - Cursor #1: fetch buffers set size=200 3640
3-10610.19.000.000000   PSORA pid=1512 - OCIDefineByPos(1,18,5,0)
3-10710.19.000.000000   PSORA pid=1512 - OCIAttrSet(OCI_HTYPE_DEFINE,OCI_UCS2ID,OCI_ATTR_CHARSET_ID)
3-10810.19.000.000000   PSORA pid=1512 - Cursor #1: fetch buffers set size=200
3-10910.19.000.001000   PSORA pid=1512 - Cursor #1: about to Execute
3-11010.19.000.000000   PSORA pid=1512 - OCIStmtExecute()
3-11110.19.000.013000   PSORA pid=1512 - OCIAttrGet(OCI_HTYPE_STMT,OCI_ATTR_ROW_COUNT)
3-11210.19.000.000000 Cur#1.1512.HRDEMO RC=0 Dur=0.015000 EXE
3-11310.19.000.000000   PSORA pid=1512 - Cursor #1, row 1, column 1: ind=0 rcode=0 rlen=6 alen=0
3-11410.19.000.000000 Cur#1.1512.HRDEMO RC=0 Dur=0.000000 Fetch
3-11510.19.000.000000   PSORA pid=1512 - Cursor #1: changing setting 3018
3-11610.19.000.000000 Cur#1.1512.HRDEMO RC=0 Dur=0.000000 SET type=3018 des=early
3-11710.19.000.000000   PSORA pid=1512 - Cursor #1: found 0 bind column(s), last column 0
3-11810.19.000.000000   PSORA pid=1512 - Cursor #1: about to Prepare: SELECT OWNERID, TOOLSREL, TO_CHAR(LASTREFRESHDTTM,'YYYY-MM-DD-HH24.MI.SS'), TO_CHAR(LASTCHANGEDTTM,'YYYY-MM-DD-HH24.MI.SS') FROM SYSADM.PSSTATUS
3-11910.19.000.000000   PSORA pid=1512 - OCIStmtPrepare2(SELECT OWNERID, TOOLSREL, TO_CHAR(LASTREFRESHDTTM,'YYYY-MM-DD-HH24.MI.SS'), TO_CHAR(LASTCHANGEDTTM,'YYYY-MM-DD-HH24.MI.SS') FROM SYSADM.PSSTATUS)
3-12010.19.000.000000   PSORA pid=1512 - Initial OCIStmtRelease() succeeded, Cursor #1, Statement SELECT OWNERID, TOOLSREL, TO_CHAR(LASTREFRESHDTTM,'YYYY-MM-DD-HH24.MI.SS'), TO_CHAR(LASTCHANGEDTTM,'YYYY-MM-DD-HH24.MI.SS') FROM SYSADM.PSSTATUS
3-12110.19.000.000000   PSORA pid=1512 - Cursor #1: about to Execute in Describe Only mode
3-12210.19.000.000000   PSORA pid=1512 - OCIStmtExecute(OCI_DESCRIBE_ONLY)
3-12310.19.000.007000   PSORA pid=1512 - Cursor #1: found 4 Select column(s)
3-12410.19.000.000000 Cur#1.1512.HRDEMO RC=0 Dur=0.009000 COM Stmt=SELECT OWNERID, TOOLSREL, TO_CHAR(LASTREFRESHDTTM,'YYYY-MM-DD-HH24.MI.SS'), TO_CHAR(LASTCHANGEDTTM,'YYYY-MM-DD-HH24.MI.SS') FROM SYSADM.PSSTATUS
3-12510.19.000.000000   PSORA pid=1512 - Cursor #1: changing setting 3018
3-12610.19.000.000000 Cur#1.1512.HRDEMO RC=0 Dur=0.000000 SET type=3018 des=never
3-12710.19.000.000000 Cur#1.1512.HRDEMO RC=0 Dur=0.000000 SSB column=1 type=2 length=9 scale=0
3-12810.19.000.000000 Cur#1.1512.HRDEMO RC=0 Dur=0.000000 SSB column=2 type=2 length=21 scale=0
3-12910.19.000.000000 Cur#1.1512.HRDEMO RC=0 Dur=0.000000 SSB column=3 type=25 length=27 scale=0
3-13010.19.000.000000 Cur#1.1512.HRDEMO RC=0 Dur=0.000000 SSB column=4 type=25 length=27 scale=0
3-13110.19.000.000000   PSORA pid=1512 - Cursor #1: fetch buffers set size=200 390
3-13210.19.000.000000   PSORA pid=1512 - OCIDefineByPos(1,18,5,0)
3-13310.19.000.000000   PSORA pid=1512 - OCIAttrSet(OCI_HTYPE_DEFINE,OCI_UCS2ID,OCI_ATTR_CHARSET_ID)
3-13410.19.000.000000   PSORA pid=1512 - OCIDefineByPos(2,42,5,0)
3-13510.19.000.000000   PSORA pid=1512 - OCIAttrSet(OCI_HTYPE_DEFINE,OCI_UCS2ID,OCI_ATTR_CHARSET_ID)
3-13610.19.000.000000   PSORA pid=1512 - OCIDefineByPos(3,54,5,0)
3-13710.19.000.000000   PSORA pid=1512 - OCIAttrSet(OCI_HTYPE_DEFINE,OCI_UCS2ID,OCI_ATTR_CHARSET_ID)
3-13810.19.000.000000   PSORA pid=1512 - OCIDefineByPos(4,54,5,0)
3-13910.19.000.001000   PSORA pid=1512 - OCIAttrSet(OCI_HTYPE_DEFINE,OCI_UCS2ID,OCI_ATTR_CHARSET_ID)
3-14010.19.000.000000   PSORA pid=1512 - Cursor #1: fetch buffers set size=200
3-14110.19.000.000000   PSORA pid=1512 - Cursor #1: about to Execute
3-14210.19.000.000000   PSORA pid=1512 - OCIStmtExecute()
3-14310.19.000.001000   PSORA pid=1512 - OCIAttrGet(OCI_HTYPE_STMT,OCI_ATTR_ROW_COUNT)
3-14410.19.000.000000 Cur#1.1512.HRDEMO RC=0 Dur=0.003000 EXE
3-14510.19.000.000000   PSORA pid=1512 - Cursor #1, row 1, column 1: ind=0 rcode=0 rlen=6 alen=0
3-14610.19.000.000000   PSORA pid=1512 - Cursor #1, row 1, column 2: ind=0 rcode=0 rlen=4 alen=0
3-14710.19.000.000000   PSORA pid=1512 - Cursor #1, row 1, column 3: ind=0 rcode=0 rlen=19 alen=0
3-14810.19.000.000000   PSORA pid=1512 - Cursor #1, row 1, column 4: ind=0 rcode=0 rlen=19 alen=0
3-14910.19.000.000000 Cur#1.1512.HRDEMO RC=0 Dur=0.001000 Fetch
3-15010.19.000.000000   PSORA pid=1512 - Cursor #1: found 0 bind column(s), last column 0
3-15110.19.000.000000   PSORA pid=1512 - Cursor #1: about to Prepare: SELECT DBID FROM SYSADM.PSSTATUS
3-15210.19.000.000000   PSORA pid=1512 - OCIStmtPrepare2(SELECT DBID FROM SYSADM.PSSTATUS)
3-15310.19.000.000000   PSORA pid=1512 - Initial OCIStmtRelease() succeeded, Cursor #1, Statement SELECT DBID FROM SYSADM.PSSTATUS
3-15410.19.000.000000   PSORA pid=1512 - Cursor #1: found 1 Select column(s)
3-15510.19.000.000000 Cur#1.1512.HRDEMO RC=0 Dur=0.001000 COM Stmt=SELECT DBID FROM SYSADM.PSSTATUS
3-15610.19.000.000000 Cur#1.1512.HRDEMO RC=0 Dur=0.000000 SSB column=1 type=2 length=33 scale=0
3-15710.19.000.000000   PSORA pid=1512 - Cursor #1: fetch buffers set size=200 992
3-15810.19.000.000000   PSORA pid=1512 - OCIDefineByPos(1,66,5,0)
3-15910.19.000.000000   PSORA pid=1512 - OCIAttrSet(OCI_HTYPE_DEFINE,OCI_UCS2ID,OCI_ATTR_CHARSET_ID)
3-16010.19.000.000000   PSORA pid=1512 - Cursor #1: fetch buffers set size=200
3-16110.19.000.000000   PSORA pid=1512 - Cursor #1: about to Execute
3-16210.19.000.000000   PSORA pid=1512 - OCIStmtExecute()
3-16310.19.000.003000   PSORA pid=1512 - OCIAttrGet(OCI_HTYPE_STMT,OCI_ATTR_ROW_COUNT)
3-16410.19.000.000000 Cur#1.1512.HRDEMO RC=0 Dur=0.004000 EXE
3-16510.19.000.000000   PSORA pid=1512 - Cursor #1, row 1, column 1: ind=0 rcode=0 rlen=6 alen=0
3-16610.19.000.000000 Cur#1.1512.HRDEMO RC=0 Dur=0.001000 Fetch
3-16710.19.000.000000   PSORA pid=1512 - Cursor #1: found 1 bind column(s), last column 1
3-16810.19.000.000000   PSORA pid=1512 - Cursor #1: about to Prepare: SELECT VERSION, OPERPSWD, OPERPSWDSALT, ENCRYPTED, SYMBOLICID, ACCTLOCK FROM SYSADM.PSOPRDEFN WHERE OPRID = :1
3-16910.19.000.000000   PSORA pid=1512 - OCIStmtPrepare2(SELECT VERSION, OPERPSWD, OPERPSWDSALT, ENCRYPTED, SYMBOLICID, ACCTLOCK FROM SYSADM.PSOPRDEFN WHERE OPRID = :1)
3-17010.19.000.000000   PSORA pid=1512 - Initial OCIStmtRelease() succeeded, Cursor #1, Statement SELECT VERSION, OPERPSWD, OPERPSWDSALT, ENCRYPTED, SYMBOLICID, ACCTLOCK FROM SYSADM.PSOPRDEFN WHERE OPRID = :1
3-17110.19.000.001000   PSORA pid=1512 - Cursor #1: found 6 Select column(s)
3-17210.19.000.000000 Cur#1.1512.HRDEMO RC=0 Dur=0.001000 COM Stmt=SELECT VERSION, OPERPSWD, OPERPSWDSALT, ENCRYPTED, SYMBOLICID, ACCTLOCK FROM SYSADM.PSOPRDEFN WHERE OPRID = :1
3-17310.19.000.000000 Cur#1.1512.HRDEMO RC=0 Dur=0.000000 SSB column=1 type=8 length=4 scale=0
3-17410.19.000.000000 Cur#1.1512.HRDEMO RC=0 Dur=0.000000 SSB column=2 type=2 length=32 scale=0
3-17510.19.000.000000 Cur#1.1512.HRDEMO RC=0 Dur=0.000000 SSB column=3 type=2 length=88 scale=0
3-17610.19.000.000000 Cur#1.1512.HRDEMO RC=0 Dur=0.000000 SSB column=4 type=6 length=4 scale=0
3-17710.19.000.000000 Cur#1.1512.HRDEMO RC=0 Dur=0.000000 SSB column=5 type=2 length=9 scale=0
3-17810.19.000.000000 Cur#1.1512.HRDEMO RC=0 Dur=0.000000 SSB column=6 type=6 length=4 scale=0
3-17910.19.000.000000 Cur#1.1512.HRDEMO RC=0 Dur=0.000000 Bind-1 type=2 length=2 value=PS
3-18010.19.000.000000   PSORA pid=1512 - OCIBindByName(1,512,5)
3-18110.19.000.000000   PSORA pid=1512 - OCIAttrSet(OCI_HTYPE_BIND,OCI_UCS2ID,OCI_ATTR_CHARSET_ID)
3-18210.19.000.000000   PSORA pid=1512 - OCIAttrSet(OCI_HTYPE_BIND,768,OCI_ATTR_MAXDATA_SIZE)
3-18310.19.000.000000   PSORA pid=1512 - Cursor #1: bind buffers set size=1
3-18410.19.000.000000   PSORA pid=1512 - Cursor #1: fetch buffers set size=200 242
3-18510.19.000.000000   PSORA pid=1512 - OCIDefineByPos(1,4,3,0)
3-18610.19.000.000000   PSORA pid=1512 - OCIDefineByPos(2,64,5,0)
3-18710.19.000.000000   PSORA pid=1512 - OCIAttrSet(OCI_HTYPE_DEFINE,OCI_UCS2ID,OCI_ATTR_CHARSET_ID)
3-18810.19.000.000000   PSORA pid=1512 - OCIDefineByPos(3,176,5,0)
3-18910.19.000.000000   PSORA pid=1512 - OCIAttrSet(OCI_HTYPE_DEFINE,OCI_UCS2ID,OCI_ATTR_CHARSET_ID)
3-19010.19.000.000000   PSORA pid=1512 - OCIDefineByPos(4,4,3,0)
3-19110.19.000.000000   PSORA pid=1512 - OCIDefineByPos(5,18,5,0)
3-19210.19.000.000000   PSORA pid=1512 - OCIAttrSet(OCI_HTYPE_DEFINE,OCI_UCS2ID,OCI_ATTR_CHARSET_ID)
3-19310.19.000.000000   PSORA pid=1512 - OCIDefineByPos(6,4,3,0)
3-19410.19.000.000000   PSORA pid=1512 - Cursor #1: fetch buffers set size=200
3-19510.19.000.000000   PSORA pid=1512 - Cursor #1: about to Execute
3-19610.19.000.000000   PSORA pid=1512 - OCIStmtExecute()
3-19710.19.000.017000   PSORA pid=1512 - OCIAttrGet(OCI_HTYPE_STMT,OCI_ATTR_ROW_COUNT)
3-19810.19.000.000000 Cur#1.1512.HRDEMO RC=0 Dur=0.019000 EXE
3-19910.19.000.000000   PSORA pid=1512 - Cursor #1, row 1, column 1: ind=0 rcode=0 rlen=4 alen=0
3-20010.19.000.000000   PSORA pid=1512 - Cursor #1, row 1, column 2: ind=0 rcode=0 rlen=31 alen=0
3-20110.19.000.000000   PSORA pid=1512 - Cursor #1, row 1, column 3: ind=0 rcode=0 rlen=24 alen=0
3-20210.19.000.001000   PSORA pid=1512 - Cursor #1, row 1, column 4: ind=0 rcode=0 rlen=4 alen=0
3-20310.19.000.000000   PSORA pid=1512 - Cursor #1, row 1, column 5: ind=0 rcode=0 rlen=7 alen=0
3-20410.19.000.000000   PSORA pid=1512 - Cursor #1, row 1, column 6: ind=0 rcode=0 rlen=4 alen=0
3-20510.19.000.000000 Cur#1.1512.HRDEMO RC=0 Dur=0.001000 Fetch
3-20610.19.000.001000   PSORA pid=1512 - OCIStmtRelease()
3-20710.19.000.000000   PSORA pid=1512 - OCIStmtRelease() succeeded, Cursor #1, Statement SELECT VERSION, OPERPSWD, OPERPSWDSALT, ENCRYPTED, SYMBOLICID, ACCTLOCK FROM SYSADM.PSOPRDEFN WHERE OPRID = :1
3-20810.19.000.000000   PSORA pid=1512 - Cursor #1: dropped
3-20910.19.000.000000 Cur#1.1512.HRDEMO RC=0 Dur=0.001000 Disconnect
3-21010.19.000.000000   PSORA pid=1512 - PS_sqldch(0000002853FCD0D0)
3-21110.19.000.000000   PSORA pid=1512 - OCITransCommit()?1
3-21210.19.000.001000   PSORA pid=1512 - OCISessionRelease()
3-21310.19.000.000000   PSORA pid=1512 - Disconnected user PEOPLE from server HRDEMO
3-21410.19.000.000000 Cur#0.1512.notSamTran RC=0 Dur=0.001000 Destroy Connection Handle=0000002853FCD0D0
3-21510.19.021.781000   PSORA pid=1512 - PSORA_Done()
3-21610.19.020.000000   PSORA pid=1512 - OCISessionPoolDestroy() 1
3-21710.19.020.029000   PSORA pid=1512 - OCIHandleFree(OCI_HTYPE_SPOOL)
3-21810.19.020.000000   PSORA pid=1512 - OCIHandleFree(OCI_HTYPE_ERROR)
3-21910.19.020.000000   PSORA pid=1512 - OCIHandleFree(OCI_HTYPE_ENV)
3-22010.19.020.001000 Cur#0.1512.notSamTran RC=0 Dur=0.032000 DON
3-22110.19.042.192000 Tuxedo session opened { DisconnectAll at 0000002853FAA340, pid=1512}

Thanks for your help

JJ
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Feb 2 2016
Added on Jan 3 2016
#peoplesoft-general-discussion
20 comments
3,457 views