Wednesday 11 February 2015

Database Creation Part 2


On the windows system enter the following tns entry.
FIN92DMO =
 (DESCRIPTION =
   (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.56.101)(PORT = 1521))
   (CONNECT_DATA =
     (SERVER = DEDICATED)
     (SERVICE_NAME = FIN92DMO)
   )
 )
Open configuration manager.
Go to Profile → Select default → Edit



Login to application designer.
Go to File → Database Setup

Click on the Run button to run the script.


4 comments:

  1. I couldn't sign login to application designer. I have created two users on FIN92DMO database as 'sysadm' and password 'sysadm' and 'people' and password 'people'. How do you map user id (SYSADM), connect id (people), and password (......) on the configuration manager and on the login at application designer. Sorry, i'm a newbie to PeopleSoft.

    ReplyDelete
  2. Login to Data Mover not Application Designer..

    ReplyDelete
    Replies
    1. Jorge, thanks, it is very helpful, I'm a newbie to PeopleSoft, hope to learn more from you.

      Delete
  3. When I run the Data Mover script, I am getting unique constraint error for some records (e.g. ACCT_TYPE_TBL) and script fails. What could be wrong here? I am installing PS for the first time

    ReplyDelete