Please read the Instant Peoplesoft Cloning Refresher Kit before continuing in this post,

Take care to remove the reuse word in the create control file statement and replace it with SET

Once the Control file is created

alter database open resetlogs

If you encounter problems,

login to command prompt,
sqlplus /nolog
connect sys/manager as sysdba
shutdown immediate
startup
exit

select * from psdbowner;

update PSDBOWNER SET DBNAME = ‘destination db name’

create user sysadm identified by <password> default tablespace <tablespacename> temporary tablespace <tablespacename>

Create user PS identified by <password> default tablespace <tablespacename> temporary tablespace <tablespacename>

Create user PEOPLE identified by <password> default tablespace <tablespacename> temporary tablespace <tablespacename>

Grant connect, resource, dba to sysadm

Grant connect, resource to ps

Grant create session to people

And after revisiting all the above points, you would be able to access application designer after configurations in configuration manager.

You might want to read these awesome related posts

• Demystifying PSPROJECTITEM -Part 2
• Instant Peoplesoft Cloning Refresher Kit
• Part II – Peoplesoft and Microsoft Active Directory Single sign on Setup
• How to be any OPRID, if
• Ask the Experts – 91