ORA-00997: illegal use of LONG datatype
During PeopleTools upgrade or PeopleSoft application upgrade, you may get an Oracle error: ORA-00997: illegal use of LONG datatype. This post will walk you through the steps to workaround and resolve the error. I encountered this error during PTools upgrade and based on the symptoms, it looks like you may face this error in PeopleSoft application […]
Continue readingORA-60019: Creating initial extent of size 14 in tablespace of extent size 13
During PeopleTools upgrade, there is a step to convert LONG datatypes to CLOB and BLOB. When using Oracle database, you may get this error: ORA-60019: Creatin g initial extent of size 14 in tablespace of extent size 13 The numbers associated with the extend size may change according to the tablespace involved in the DDL statement […]
Continue reading
11
How to Resolve TNS-03505: Failed to resolve name
Every now and then when I created a new Oracle database in an existing Oracle base (be it 11g or 12c) – I get the error “TNS-03505: Failed to resolve name” whenever I try to do tnsping on a new database. You may receive this error even when not doing tnsping. For example, you may see […]
Continue reading
5
Get Count of All PeopleSoft Tables with one SQL
While performing upgrades or applying maintenance to your PeopleSoft applications, you might want to get row count of all your PeopleSoft tables. There are few ways of doing it which we will discuss below and finally the one which I think is the easiest and most efficient way. Option 1: Running UPGCOUNT AE UPGCOUNT is […]
Continue reading
1
ORA-20005: object statistics are locked (stattype = ALL)
While doing an application or a PeopleTools upgrade, you do update stats at a couple of steps. Also, to support your PeopleSoft instance, you do update stats at frequent interval. What update stats can cause is an error very similar to something like this: SQL Error. Error Position: 0 Return: 20005 – ORA-20005: object statistics […]
Continue reading
1
Oracle PL/SQL Cheat Sheet
PL/SQL (Procedural Language/Structured Query Language) is Oracle Corporation’s procedural language extension for SQL and the Oracle relational database. PL/SQL is available in Oracle Database (since version 7) and IBM DB2 (since version 9.7). Oracle Corporation usually extends PL/SQL functionality with each successive release of the Oracle Database. While PL/SQL is easy to learn, it can […]
Continue reading(SQR 3725) Bad return fetching row from database.
The PeopleTools upgrade step “Running DBTSFIX Report” might fail with the error: Rel script conversion program PRCSDEFN match Error on line 842: (SQR 3725) Bad return fetching row from database. SQR for PeopleSoft: Program Aborting. How to Fix (SQR 3725) Bad return fetching row from database. This error is caused by invalid packages in case of […]
Continue reading