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.


Share

4 Comments

  1. Cliff Moore says:

    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. digitaleagle says:

    Cliff,

    Data Mover is psdmtx.exe. It is located in \bin\client\winx86\psdmtx.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

    • Cary says:

      Stephen,
      What user id to use in the data mover signon screen? I could not get that passed. Thanks!

      • digitaleagle says:

        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