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.
Read About: DBA Refresher
