Step by Step PS Install: Load the Database

This is a continuation of my virtual PeopleSoft installation.  In this step, we will run Data Mover to load the database.  To see the complete list of steps, click here.

Because I installed the data into the Linux version of the pshome and the program is running out of the Windows pshome, I had to create some symbolic links.


cd ~/pshome-win/
mv data data-old
ln -s ~/pshome/data data

But, that didn’t work.  It still needed access to files in the setup directory.  So, I got a better idea:


cd ~/pshome
ln -s ~/pshome-win/bin bin-win

Open Data mover (psdmtx).  I opened it from the pshome share, bin-win, client, winx86 directory.

Choose File > Database Setup

Keep the defaults for the database type screen.

Then, I chose a demo database at the bottom first.  Next, I chose the HRCS option and clicked the Add button.

Keep the defaults for the database parameters.

Finally, the wizard closed and left the new script in the window.

Next, I click on the run button (or File, Run) to run the script.

When I checked on everything in the morning, I found that the virtual computer had rebooted.  It may have been a good idea to unplug the host computer from the network so the virtual did not have access to the Internet to download updates for Windows.

4 thoughts on “Step by Step PS Install: Load the Database

  1. Open Data mover (psdmtx). I opened it from the pshome share, bin-win, client, winx86 directory.

    Forgive me for asking. How did you open datamover. I mean what was the command? I got to that point and didn’t know what to write. Cliff Moore

  2. Cliff,

    Data Mover is psdmtx.exe. It is located in binclientwinx86psdmtx.exe. You can just double click on it to run it. You can login either with a PeopleSoft ID or with a Database ID.

    You might also have to run pscfg.exe and configure the Connect ID, which is typically, PEOPLE.

    Hope this helps,

    Stephen

      1. Cary,

        I did this in Bootstrap mode, which means I used the database user. Since this is an Oracle database, I used the SYSADM account in the Oracle database. That user should be setup during the database creation.

Leave a Comment

Your email address will not be published. Required fields are marked *