Database creation Using Data Mover- Part I

/psdemo91/software/ptools/setup/PsMpDbInstall
euxMe{orahr_psdemo91}# ./setup.sh -tempdir /psdemo91/FTP/PT5.0/tmp
Setting temporary directory /psdemo91/FTP/PT5.0/tmp/IA.12254
Executing setup.hp   -DPS_UMASK=022
Preparing to install...
Extracting the installation resources from the installer archive...
Configuring the installer for this system's environment...


Launching installer...


Preparing CONSOLE Mode Installation...


=========================================================================Peoplesoft Database Configuration (created with InstallAnywhere by Macrovision)
-------------------------------------------------------------------------------
=========================================================================Welcome
-------


Welcome to the PeopleSoft Database Configuration Wizard 8.50


This Wizard will assist you in configuring and loading a PeopleSoft database.


PRESS TO CONTINUE:


=========================================================================


Please enter an installation location or press to accept the default
   (DEFAULT: /psdemo91/software/ptools):


Press 1 for Next, 2 for Previous, 3 to Cancel or 5 to Redisplay [1] :


=========================================================================


For a database platform of 'Oracle', are you installing a:


    1- Non-Unicode Database
  ->2- Unicode Database


To select an item enter its number, or 0 when you are finished [0] :


Press 1 for Next, 2 for Previous, 3 to Cancel or 5 to Redisplay [1] :


Oracle - UNICODE
=========================================================================


Select Character Set:


  >1- AL32UTF8
    2- UTF8


To select an item enter its number, or 0 when you are finished [0] :


Database Create Type:


  >1- Demo
    2- System
    3- PeopleTools System




To select an item enter its number, or 0 when you are finished [0] :


Press 1 for Next, 2 for Previous, 3 to Cancel or 5 to Redisplay [1] :


=========================================================================
Select PeopleSoft Application:


  ->1- PeopleSoft HRCS Database - US English


To select an item enter its number, or 0 when you are finished [0] :


Press 1 for Next, 2 for Previous, 3 to Cancel or 5 to Redisplay [1] :


=========================================================================


   Specify the directory path for 'sqlplus' [/ora_psdemo91/software/bin]   :


   Specify the location for ORACLE_HOME [/ora_psdemo91/software]   :


Location of modified scripts: /psdemo91/software/ptools/modifiedscripts


Press 1 for Next, 2 for Previous, 3 to Cancel or 5 to Redisplay [1] :


=========================================================================


Please select the Oracle version you are building the database on:


  ->1- Oracle 9i
    2- Oracle 10g or above


To select an item enter its number, or 0 when you are finished [0] : 2


Please select the Oracle version you are building the database on:


    1- Oracle 9i
  ->2- Oracle 10g or above


To select an item enter its number, or 0 when you are finished [0] :


Do you want to create a new SID or use existing one?


  ->1- Create new SID
    2- Use existing SID


To select an item enter its number, or 0 when you are finished [0] :


Press 1 for Next, 2 for Previous, 3 to Cancel or 5 to Redisplay [1] :


=========================================================================


   Oracle SID [HC]: PT850


   DatabaseName [HC]: PT850


   Mount Point 1( for SYSTEM and REDO LOGS file in createdb.sql, ex: NT 'C'  ,  UNIX 'u01') [c]:


   Mount Point 2 ( for PSTEMP and PSDEFAULT file in utlspace.sql, ex: NT 'C'  ,  UNIX 'u01') [c]:


   Mount Point 3 ( for all files in xxddl.sql, ex: NT 'C'  , UNIX 'u01') [c]   :


Enable AutoExtend for Peoplesoft Tablespaces?


  ->1- Yes
    2- No


To select an item enter its number, or 0 when you are finished [0] :


Press 1 for Next, 2 for Previous, 3 to Cancel or 5 to Redisplay [1] :


=========================================================================


   Peoplesoft owner ID (ex: 'SYSADM') [SYSADM]:


   Peoplesoft owner password (ex: 'SYSADM') [SYSADM]:


   Peoplesoft connect ID [people]:


   Peoplesoft connect password [peop1e]:


   Peoplesoft default tablespace  (ex: 'PSDEFAULT') [PSDEFAULT]   :


   Location of init.ora file complete path
   [/ora_psdemo91/software/dbs/initPT850.ora]:


Press 1 for Next, 2 for Previous, 3 to Cancel or 5 to Redisplay [1] :


=========================================================================


Select Base Lanaguage


  ->1- ENG - US English


To select an item enter its number, or 0 when you are finished [0] :


Press 1 for Next, 2 for Previous, 3 to Cancel or 5 to Redisplay [1] :


=========================================================================
Pre-Installation Summary
------------------------


Please Review the Following Before Continuing:


Product Name:
    Peoplesoft Database Configuration


Install Folder:
    /psdemo91/software/ptools


Database Platform:
    Oracle  -  Unicode


Oracle SID:
    PT850


Application:
          PeopleSoft HRCS Database - US English


Database Name:
    PT850


Please type 'back' to go to previous panels


PRESS TO CONTINUE:


=========================================================================
Installing...
-------------


 [==================|==================|==================|================]
 [------------------|------------------|------------------|------------------]




========================================================================
Please Wait...
--------------


Executing.. /psdemo91/software/ptools/modifiedscripts/runCreatedb10.sh.


========================================================================
Please Wait...
--------------


Executing.. /psdemo91/software/ptools/modifiedscripts/runUtlspace.sh.


=========================================================================
Please Wait...
--------------


Executing.. /psdemo91/software/ptools/modifiedscripts/hcddl.sql.


=========================================================================
Please Wait...
--------------


Executing.. /psdemo91/software/ptools/modifiedscripts/dbowner.sql.


=========================================================================
Please Wait...
--------------


Executing.. /psdemo91/software/ptools/modifiedscripts/psroles.sql.


=========================================================================
Please Wait...
--------------


Executing.. /psdemo91/software/ptools/modifiedscripts/psadmin.sql.


=========================================================================
Please Wait...
--------------


Executing.. /psdemo91/software/ptools/modifiedscripts/connect.sql.


=========================================================================
Executing DM: -CT ORACLE -CS eux531.sgp.st.com -CD LOCAL -CO SYSADM -CP SYSADM
-CI people -CW peop1e -FP /psdemo91/software/ptools/modifiedscripts/dbsetup.dms
Console Mode: true


Initializing Data Mover ... please wait


Console DM Mode: /psdemo91/software/ptools/bin/psdmtx
/psdemo91/software/ptools/setup/parm1
PeopleTools 8.50 - Data Mover
Copyright (c) 2010 PeopleSoft, Inc.
All Rights Reserved
shl_load in libpscompat failed for libpsora.sl.  errno=2: No such file or
directory
PSDMTX euxMy: signon
Reason: Could not sign on to database LOCAL with user SYSADM.
ExitCode: 0
euxMy: true




=========================================================================euxMy
-----


The following euxMy occurred while running data mover .
euxMy: Running psdmtx.
Please select OK to exit installer.


PRESS TO ACCEPT THE FOLLOWING (OK):






=========================================================================
Install Complete
----------------


The installation of Peoplesoft Database Configuration is complete, but some
errors occurred during the install.
   Please see the installation log for details.  Press "Done" to quit the
installer.


PRESS TO EXIT THE INSTALLER:
eux531{orahr_psdemo91}#




but again installation was success and at the end you will see,


 Creating temp table instances (3)
 Building required indexes for XML_FILE_TMP
Records remaining: 1
Creating Table  XML_F_LNG_TMP
 Creating temp table instances (3)
 Building required indexes for XML_F_LNG_TMP
 SQL Tables: 894  Temp Tables: 7990 Indexes: 8629
Ended: Sun May 30 02:13:08 2010
Successful completion
ExitCode: 0
euxMy: false




=========================================================================
Installation Complete
---------------------


Congratulations. Peoplesoft Database Configuration has been successfully
installed to:


   /psdemo91/software/ptools


PRESS TO EXIT THE INSTALLER:
euxME{orahr_psdemo91}#