PeopleTools and Lifecycle Management - PSFT (MOSC)

MOSC Banner

I am doing peoplesoft 8.55 database refresh activity for development db from prod db. Is this steps

edited Jun 20, 2017 5:01AM in PeopleTools and Lifecycle Management - PSFT (MOSC) 3 commentsAnswered ✓

Hi All,

I am doing PeopleSoft DB refresh from prod to dev.

This are my steps:

Export Database HR92PRD:-

1) Took an export backup of complete database through expdb command.

2) Took backup of report nodes and IB configurations.

3) Took backup of security tables.

4) Took backup of PSDBOWNER table.

Import Database:-

1) Created a new database HR92DEV.

2) Run the six peoplesoft db scripts utlspace.sql, hcddl.sql, dbowner.sql, psroles,sql, psadmin.sql, connect.sql

3) Run the import command to import the data in HR92DEV

4) Change the DB name in PSDBOWNER.sql

5) Import the security tables.

6) Configure and check the report nodes and IB configurations.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center