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 I would expect it to. Even when I tried to create the users manually, I was still getting the errors. When I did little bit research about the error, it was found that Oracle 12C database was configured with CDB (Container Database) and commands to create users and roles are different.

PeopleSoft Installation Scripts like dbowner.sql,psroles.sql were using the traditional Oracle commands to create users and roles. By this time, I knew that issue was caused due to Oracle 12C CDB feature. On further investigation, I found that though Oracle 12C is certified with PeopleTools 8.53 but CDB feature doesn’t work with PeopleTools. In Oracle Open World 2013 sessions, it was mentioned that hopefully PeopleTools 8.54 will support Oracle’s CDB (Container Database ) feature.

Now, lets see how to fix the issue. To make sure you don’t get errors while creating PeopleSoft database, you need to make sure you disabled ‘Container Database’ feature when creating Oracle database. This feature is enabled by default so you need to uncheck it before proceeding with database creation.