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
This Oracle 12C Setting Can Jeopardize Your PeopleSoft Installation
Oracle Database 12C is supported with PeopleTools 8.53 but there is one feature in Oracle 12C that can jeopardize your PeopleSoft Installation. Recently while installing PeopleSoft 9.2 with PeopleTools 8.53 using Oracle 12C as database, I was struck at running initial database creation scripts like dbowner.sql and psroles.sql. Scripts weren’t creating users and roles as […]
Continue readingHow to Manually Uninstall Oracle in Windows 8
Let’s face it – Oracle database is an excellent product but its uninstall process is still mediocre. There are a lot of unknown issues arise when you try to uninstall Oracle database and then try to install it again. We get a lot of queries every week regarding problems installing Oracle products. Most of these […]
Continue reading
5
Understanding Oracle Database and PeopleSoft Database
Some of the terms especially when it comes to database are loosely used and may cause confusion when performing a PeopleSoft installation. This post will help you revisit and understand PeopleSoft database concepts when used with Oracle database. When you perform a PeopleSoft installation, you will create these types of PeopleSoft databases: • System (also […]
Continue readingHow to Find Oracle Hidden Parameters
Oracle has hundreds of initialization parameters, which are hidden and undocumented. Many savvy Oracle professionals are known to commonly adjust the hidden parameters to improve the overall performance of their systems. However, because these are “undocumented” parameters, most Oracle professionals rely on publications such as “Oracle Internals” to get insights into the proper setting for the […]
Continue reading