Thursday, January 10, 2008

On The Peoplesoft Road : Peoplesoft Database creation - Part I

Please, before to run the installation ensure you understood the concepts explain previously here.

This first part of the Peoplesoft Database Creation concern the Oracle database creation itself and the Application (including PeopleTools) data.

Of course, you need to have install the Database server previously, see here.

Peoplesoft provide scripts to create the database, you can find all the required scripts under
$PS_HOME/scripts/unix. Because we'll need to modify some of these files, it's better to copy all the files under a working directory, or like me, under $ORACLE_BASE/admin/$ORACLE_SID/create folder.

So, I'll use that ones.
Step 1 to 14 have to be run on the database server.

1. Modify the script createdb10.sql (for the 10g customer), character set and strings :

[ora102@orion:/oradata/DMOHRMS9/create]$ vi createdb10.sql
set termout on
set echo on
spool createdb.log

startup nomount pfile=$ORACLE_HOME/dbs/initDMOHRMS9.ora
CREATE DATABASE "DMOHRMS9"
MAXINSTANCES 8
MAXLOGHISTORY 1
MAXLOGFILES 16
MAXLOGMEMBERS 3
MAXDATAFILES 100
DATAFILE '/oradata/DMOHRMS9/datafiles/system01.dbf' SIZE 300M REUSE AUTOEXTEND ON NEXT 10240K MAXSIZE UNLIMITED
EXTENT MANAGEMENT LOCAL
SYSAUX DATAFILE '/oradata/DMOHRMS9/datafiles/sysaux01.dbf' SIZE 120M REUSE AUTOEXTEND ON NEXT 10240K MAXSIZE UNLIMITED
SMALLFILE DEFAULT TEMPORARY TABLESPACE TEMP TEMPFILE '/oradata/DMOHRMS9/datafiles/temp01.dbf' SIZE 20M REUSE AUTOEXTEND ON NEXT 640K MAXSIZE UNLIMITED
SMALLFILE UNDO TABLESPACE "PSUNDOTS" DATAFILE '/oradata/DMOHRMS9/datafiles/psundots01.dbf' SIZE 200M REUSE AUTOEXTEND ON NEXT 5120K MAXSIZE UNLIMITED
CHARACTER SET AL32UTF8
NATIONAL CHARACTER SET UTF8
LOGFILE GROUP 1 ('/oradata/DMOHRMS9/redologs/redo01.log') SIZE 51200K,
GROUP 2 ('/oradata/DMOHRMS9/redologs/redo02.log') SIZE 51200K,
GROUP 3 ('/oradata/DMOHRMS9/redologs/redo03.log') SIZE 51200K;
spool off

2. Create the directories to receive your new database, and your init.ora file. Please refer to the Oracle Database Documentation http://docs.oracle.com

3. Ensure your NLS_LANG env variable is set correctly.


4. Create the password file


5. Add the tns entry for the new database in tnsnames.ora (and listener.ora for fixed addressing)


6. Set the ORACLE_SID, and run the creation database script :
[ora102@orion:/oradata/DMOHRMS9/create]DMOHRMS9$ sqlplus / as sysdba

SQL*Plus: Release 10.2.0.3.0 - Production on Sun Jan 6 14:50:12 2008

Copyright (c) 1982, 2006, Oracle. All Rights Reserved.

Connected to an idle instance.

SQL> @createdb10.sql
SQL>
SQL> startup nomount pfile=$ORACLE_HOME/dbs/initDMOHRMS9.ora

ORACLE instance started.

Total System Global Area 767557632 bytes
Fixed Size 1264136 bytes
Variable Size 205522424 bytes
Database Buffers 557842432 bytes
Redo Buffers 2928640 bytes
SQL> CREATE DATABASE "DMOHRMS9"
2 MAXINSTANCES 8
3 MAXLOGHISTORY 1
4 MAXLOGFILES 16
5 MAXLOGMEMBERS 3
6 MAXDATAFILES 100
7 DATAFILE '/oradata/DMOHRMS9/datafiles/system01.dbf' SIZE 300M REUSE AUTOEXTEND ON NEXT 10240K MAXSIZE UNLIMITED
8 EXTENT MANAGEMENT LOCAL
9 SYSAUX DATAFILE '/oradata/DMOHRMS9/datafiles/sysaux01.dbf' SIZE 120M REUSE AUTOEXTEND ON NEXT 10240K MAXSIZE UNLIMITED
10 SMALLFILE DEFAULT TEMPORARY TABLESPACE TEMP TEMPFILE '/oradata/DMOHRMS9/datafiles/temp01.dbf' SIZE 20M REUSE AUTOEXTEND ON NEXT 640K MAXSIZE UNLIMITED
11 SMALLFILE UNDO TABLESPACE "PSUNDOTS" DATAFILE '/oradata/DMOHRMS9/datafiles/psundots01.dbf' SIZE 200M REUSE AUTOEXTEND ON NEXT 5120K MAXSIZE UNLIMITED
12 CHARACTER SET AL32UTF8
13 NATIONAL CHARACTER SET UTF8
14 LOGFILE GROUP 1 ('/oradata/DMOHRMS9/redologs/redo01.log') SIZE 51200K,
15 GROUP 2 ('/oradata/DMOHRMS9/redologs/redo02.log') SIZE 51200K,
16 GROUP 3 ('/oradata/DMOHRMS9/redologs/redo03.log') SIZE 51200K;

Database created.


7. Modify and run the utlspace.sql script (dictionaries views)

[ora102@orion:/oradata/DMOHRMS9/create]DMOHRMS9$ vi utlspace.sql
-- ******************************************************************

REM * Set terminal output and command echoing on; log output of this script.
REM *
set termout on

REM * The database should already be started up at this point from createdb.sql

set echo off
spool utlspace.log

REM * Creates data dictionary views. Must be run when connected AS SYSDBA
@$ORACLE_HOME/rdbms/admin/catalog.sql;

REM * Creates views of oracle locks
@$ORACLE_HOME/rdbms/admin/catblock.sql;

REM * Scripts for procedural option. Must be run when connected AS SYSDBA
@$ORACLE_HOME/rdbms/admin/catproc.sql;

set echo on

REM * Create a temporary tablespace for database users.
REM *
CREATE TEMPORARY TABLESPACE PSTEMP
TEMPFILE '/oradata/DMOHRMS9/datafiles/pstemp01.dbf' SIZE 300M
EXTENT MANAGEMENT LOCAL UNIFORM SIZE 128K
;

REM * Create a tablespace for database users default tablespace.
REM *
CREATE TABLESPACE PSDEFAULT
DATAFILE '/oradata/DMOHRMS9/datafiles/psdefault.dbf' SIZE 100M
EXTENT MANAGEMENT LOCAL AUTOALLOCATE
SEGMENT SPACE MANAGEMENT AUTO
;

spool off

[ora102@orion:/oradata/DMOHRMS9/create]DMOHRMS9$
[ora102@orion:/oradata/DMOHRMS9/create]DMOHRMS9$ sqlplus / as sysdba
SQL> @utlspace.sql

8. Modify (don't change the PS user name) and run the dbowner.sql script
[ora102@orion:/oradata/DMOHRMS9/create]DMOHRMS9$ vi dbowner.sql
-- ******************************************************************

set echo on
spool dbowner.log

GRANT CONNECT, RESOURCE, DBA TO PS IDENTIFIED BY PS;
CONNECT PS/PS;
CREATE TABLE PSDBOWNER (DBNAME VARCHAR2(8) NOT NULL, OWNERID VARCHAR2(8) NOT NULL ) TABLESPACE PSDEFAULT;
CREATE UNIQUE INDEX PS_PSDBOWNER ON PSDBOWNER (DBNAME) TABLESPACE PSDEFAULT;
CREATE PUBLIC SYNONYM PSDBOWNER FOR PSDBOWNER;
GRANT SELECT ON PSDBOWNER TO PUBLIC;
CONNECT system/manager;
REVOKE CONNECT, RESOURCE, DBA FROM PS;

spool off
[ora102@orion:/oradata/DMOHRMS9/create]DMOHRMS9$ sqlplus / as sysdba
SQL> @dbowner.sql

9. . To create the specific tablespaces (for HRMS hcddl.sql), modify and run hcddl.sql :
[ora102@orion:/oradata/DMOHRMS9/create]DMOHRMS9$ vi hcddl.sql
-- **************************************************************
REMARK * This script is used to create tablespaces for the PeopleSoft 9 HRMS Products
REMARK * on Oracle UNIX.
REMARK * Date last modified: 01/30/2007

REMARK * NOTE: The sizing of the tablespaces here are only sample sizes that will
REMARK * hold the demo database tables. This is not sized correctly for a
REMARK * production database.

REMARK * Users can choose to use the autoextending tablespace feature.
REMARK * The syntax is at the end of this script.

set echo on
spool hcddl.log

CREATE TABLESPACE AAAPP DATAFILE '/oradata/DMOHRMS9/datafiles/aaapp.dbf' SIZE 21M
EXTENT MANAGEMENT LOCAL AUTOALLOCATE
SEGMENT SPACE MANAGEMENT AUTO
/
[...]
[ora102@orion:/oradata/DMOHRMS9/create]DMOHRMS9$ sqlplus / as sysdba
SQL> @hcddl.sql
[...]

You may want to set AUTOEXTEND to ON to avoid space extension problem against the tablespace during the application load.

10. Check and run the database ROLES creation : [ora102@orion:/oradata/DMOHRMS9/create]DMOHRMS9$ more psroles.sql
-- ******************************************************************

REMARK -- These are the minimum privileges required to run PeopleSoft
REMARK -- applications. If you plan to run SQL<>Secure, you will need to
REMARK -- grant "execute any procedure" to PSUSER and PSADMIN.

set echo on
spool psroles.log

DROP ROLE PSUSER;
DROP ROLE PSADMIN;

CREATE ROLE PSUSER;
GRANT CREATE SESSION TO PSUSER;

CREATE ROLE PSADMIN;
GRANT
ANALYZE ANY,
ALTER SESSION, ALTER TABLESPACE, ALTER ROLLBACK SEGMENT,
CREATE CLUSTER, CREATE DATABASE LINK, CREATE PUBLIC DATABASE LINK,
CREATE PUBLIC SYNONYM, CREATE SEQUENCE, CREATE SNAPSHOT,
CREATE SESSION, CREATE SYNONYM, CREATE TABLE, CREATE VIEW,
CREATE PROCEDURE, CREATE TRIGGER, CREATE TABLESPACE, CREATE USER,
CREATE ROLLBACK SEGMENT,
DROP PUBLIC DATABASE LINK, DROP PUBLIC SYNONYM, DROP ROLLBACK SEGMENT,
DROP TABLESPACE, DROP USER, MANAGE TABLESPACE, RESOURCE,
EXP_FULL_DATABASE, IMP_FULL_DATABASE,
GRANT ANY ROLE, ALTER USER, BECOME USER
TO PSADMIN WITH ADMIN OPTION;

spool off
[ora102@orion:/oradata/DMOHRMS9/create]DMOHRMS9$ sqlplus / as sysdba
SQL> @psroles.sql

11. Check and modify if necessary the ceation of the owner of the Peoplesoft objects (psadmin.sql script). Commonly, The admin user is named SYSADM, the default tablespace is PSDEFAULT :
[ora102@orion:/oradata/DMOHRMS9/create]DMOHRMS9$ more psadmin.sql
-- ******************************************************************

REMARK -- This script sets up the PeopleSoft Owner ID. An Oracle DBA is
REMARK -- required to run this script.

set echo on
spool psadmin.log

ACCEPT ADMIN CHAR PROMPT 'Enter name of PeopleSoft Owner ID: '
ACCEPT PASSWORD CHAR PROMPT 'Enter PeopleSoft Owner ID password:'
PROMPT
PROMPT Enter a desired default tablespace for this user.
PROMPT
PROMPT Please Note: The tablespace must already exist
PROMPT If you are unsure, enter PSDEFAULT or SYSTEM
PROMPT
ACCEPT TSPACE CHAR PROMPT 'Enter desired default tablespace:'


REMARK -- Create the PeopleSoft Administrator schema.

create user &ADMIN identified by &PASSWORD default tablespace &TSPACE
temporary tablespace pstemp;
grant PSADMIN TO &ADMIN;

REMARK -- PeopleSoft Administrator needs unlimited tablespace in order to
REMARK -- create the PeopleSoft application tablespaces and tables in Data
REMARK -- Mover. This system privilege can only be granted to schemas, not
REMARK -- Oracle roles.

grant unlimited tablespace to &ADMIN;

REMARK -- Run the commands below to create database synonyms.
REMARK -- Modify the connect string appropriately for your organization.

connect system/manager

set echo off

@$ORACLE_HOME/rdbms/admin/catdbsyn
@$ORACLE_HOME/sqlplus/admin/pupbld

spool off
[ora102@orion:/oradata/DMOHRMS9/create]DMOHRMS9$ sqlplus / as sysdba
SQL> @psadmin.sql

12. Check and modify if necessary the creation script of the security check user people - connector user -, take care the default password is peop1e (1, one, instead of the letter l) :
[ora102@orion:/oradata/DMOHRMS9/create]DMOHRMS9$ more connect.sql
-- ******************************************************************

REMARK -- This script sets up the PeopleSoft Connect ID.
REMARK -- An Oracle DBA is required to run this script prior
REMARK -- to loading a PSOFT database.
REMARK --
REMARK -- If you wish to use the default CONNECTID and PASSWORD,
REMARK -- then run this script as is.
REMARK -- If you wish to change the default CONNECTID and PASSWORD,
REMARK -- DELETE the default CREATE and GRANT statements below and
REMARK -- uncomment the template version modifying the following
REMARK -- parameters , ,
REMARK --

REMARK -- Create the PeopleSoft Administrator schema.

set echo on
spool connect.log

REMARK -- drop user people cascade;

create user people identified by peop1e default tablespace PSDEFAULT
temporary tablespace PSTEMP;

GRANT CREATE SESSION to people;

REMARK -- drop user cascade;

REMARK -- create user identified by default tablespace
REMARK -- temporary tablespace ;

REMARK -- GRANT CREATE SESSION to ;

spool off
[ora102@orion:/oradata/DMOHRMS9/create]DMOHRMS9$ sqlplus / as sysdba
SQL> @connect.sql

13. For Unicode database, if you don't want to raise the following error on the application datamover load : ''Character Length Semantics (CLS) is not enabled'' , you may want to add the following line in your parameters file : NLS_LENGTH_SEMANTICS=CHAR, or modify the spfile :
SQL> alter system set NLS_LENGTH_SEMANTICS=CHAR scope=both;


System altered.


14. Lastly, create spfile and bounce your database :

SQL> create spfile from pfile='/apps/oracle/admin/DMOHRMS9/pfile/initDMOHRMS9.ora';

File created.

SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup
show parameter ORACLE instance started.

Total System Global Area 767557632 bytes
Fixed Size 1264136 bytes
Variable Size 205522424 bytes
Database Buffers 557842432 bytes
Redo Buffers 2928640 bytes
Database mounted.
Database opened.


From step 15, you have to be on your client machine.

15. Set up your environement on your client machine, started by the connector password (people user), run the Configuration of your client environment Peopletools :
Set the connect Id and connect password as defined at the step 12.
16. Start the DataMover tool from of your client environment Peopletools :
Give the Database Name (you need previously to modify your tnsnames.ora of your Oracle client install), the admin user name and password create at the step 11 (commonly SYSADM) :
17. Run the the Database Setup within the DataMover.
18. Choose the type of Database, Unicode or non-Unicode and the chareacter set.
19. Choose the type of database you want (DEMO, SYSTEM) or if you want to add product or language to an existing database :
20. Add the languages you want to see in your application :21. Give the database name (will be included in the PSDBOWNER table), symbolic id shouldn't be change, leave SYSADM1, Access ID is the admin user created at the step 11 (commonly SYSADM), Connect ID is PEOPLE (better to not change it). Well, on this screen just change the access password if you changed it at the step 11.22. The base language should be English, unless for some specific needs.23. At the end, a script has been created, checkit and run it (take care of the time to apply, since it require Mb od dataload in your dataase through the network, it can take hours on slow network) :
It's finish for the basics tasks.
If you're sure your application database version (the Peopletools version which your application has been built on) is same as your current database, go directly at the Peoplesoft Database creation part III, else go to the Peoplesoft Database creation part II.

29 comments:

Anonymous said...

hi,
your work is great! thanks!
i am new in peoplesoft. i want to install peoplesoft hrms on oracle in windows 2003.when i install peopletools,orcale and hrms.then
1. i create the database named 'hrms' using database configuration assitant.(because i cannot run the script from the dic d:\pt8.49\script\nt\create10.sql)

2. then i run the script following your steps.

3. but finally i can not accoss to the data move using name 'PS'/'PS'.the error is invailed use id and pwd.

so i need your help! i have two questions :
1. why i do not create database using the script? the error is that :ora-01100 database already mounted.

2. why i can not access to the database using the PS/PS.

could you can give me some steps to install the oracle database for peoplesoft hrms.

i do not know your step 3. Ensure your NLS_LANG env variable is set correctly. how to set the NLS_LANG .my os is english. and oracle is english.

and i do not your step 4. Create the password file . how to create the password file? i do not know.

the step 5 i just add the tnsnames.ora this:
hrms =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = jx-zheng.china.freeborders)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = hrms)
)
)

i do know if it is right.

my oracle is 10g and peopletools is 8.49 hrms is 9.0.

could you send email to me. i need your help.i really need your help.i am looking forword your mail. my email is wawdj17@hotmail.com.

thanks very much!
best wishes!
thanks again!

king
2008-10-15

Anonymous said...

Hi,

Thanks for your steps listed here.
I am trying to launch datamover for the first time from windows client in boot strap mode. I want to run databse setup to create the demo database. Some how its not allowing me to login with sysadm id. it says invalid username/passwd. I am able to login using sqlplus with sysadm and connect id as well. Could you please share your thoughts?

Thanks...

Nicolas Gasparotto said...

Did you make the settings through the Configuration Manager (step 15) ?

Anonymous said...

Hey Thanks for your response. I did do the setup and i was getting the error PSAFFIRM ..Error on *.cpp and followed by invalid username/passwd error in datamover. For some reason my 8 character passwd fro sysadm while creating the PS database was taken in as 9 characters and ps seems to be not liking it. I altered the passwd for a 8 character and now i am able to proceed. Again appreciate your effort in putting this together.

jmechols said...

Good information What files does data mover look for when you want to choose a database type. I am having that problem it see my fin but not my crm database which is the one I want to create.

Nicolas Gasparotto said...

jmechols, if you don't see the crm one with in the database setup, that means you didn't install crm application in same folder as the Peopletools you are running.

jmechols said...

Thanks for the reply. I found out what the problem was you have to run the data mover from the directory where the database dumps are. Yesterday I used a link to data mover from Fin file structure so data mover only saw the Fin database dump files. Today I used the data mover exe from the CRM directory and it saw my CRM dump files. Thanks again pass this on to others. CRM 9.0 tools 8.48.11

Anonymous said...

Gasparotto Nicolas said...
jmechols, if you don't see the crm one with in the database setup, that means you didn't install crm application in same folder as the Peopletools you are running.

I'm facing same problem here ... I installed FSCM 9 in PS_HOME but when I'm about to run the Data Mover ... the FSCM database doesn't pop up. My directory looks like this D:\PT8.49\FSCM9.0 ... is this okay??

Need some assistance please.

Regards.

Nicolas Gasparotto said...

No, no and no.
If you installed Peopletools under D:\PT8.49, then you must installed the application in D:\PT8.49 also !

Anonymous said...

If you installed Peopletools under D:\PT8.49, then you must installed the application in D:\PT8.49 also !

Pleas, I dont understand this ... can you please show me how the directory will look like?

D:\PT8.49 .....FSCM9.0 ... does all the content of FSCM9.0 go in D:\PT8.49????? or what????

Make it clearer please.

Regards.

Nicolas Gasparotto said...

Both directories should be same.
If you used D:\PT8.49 to installed Peopletools, then you should use D:\PT8.49 for the application installation (do not use different path directory or subfolder).

Anonymous said...

Thanks for your wisdom.

I'll do that ... and expect to hear from me again ...


Regards.

Anonymous said...

Hi Nic, I'm back again. Now everything seems to work fine ... I finally installed HRMS9.0 Apps and the database pops up in the Database setup ... but what I'm concerned about now is that it's been running for more than 8 hours now and not yet finished it's around Importing GPCH_TX_RATES.

Can you please tell me how long it takes to run and what the size of the DB will be?

Thanks.

Anonymous said...

Have anybody faced problem like this before..

I am trying to Copy The Project using Application Designer
(Tools > Copy Project)

As soon as I click on the Copy Project, my app designer closes..

Same happens in Data Mover, when I tried to open a file.

Any help would be appreciated..

PS: I am in the step 4 of Peoplesoft Database creation - Part II

Farooq Malik said...

Hi,
I have installed application and have created the database with the scripts you mentioned. Now I am on step 19 and when i choose demo database option, i could not see any database listing and as a result of this the "next" button is not active anymore. When i try the system database, it show me one database option and the next button is also active.
I have perform every step you mentioned in the peopletools installation and also applied the latest patch (8.49.19) on server and client machine.
Can you please help me resolving this issue??
Thanks

Bruce said...

Hi

Oracle's documentation on the manual database creation tells us to log into SQL Plus as "the System user" - your blog says to connect as sysdba. We did not do that, connected as system/manager. Do we need to revert and re-run from here? We ran grant.sql but cannot connect using PS as a PeopleSoft operator.

thanks,
Bruce

Prashant said...

Hi Bruce
3 scripts utlspace, dbowner and xxddl needs to be run as sysdba. On the other hand , psadmin and connect.sql should be run as system user. It is recommended by Peoplesoft. If you have ran these scripts than you can run them again using proper user ids.
If you are not able to login using PS designer, please share error or any logs if any.

Anonymous said...

How long it takes to complete the database configuration wizard, It is more than 1 hrs screen displays executing createdb10.sql and no log file is created yet....

How to check whether it is running fine or having any issues...

Thx
Kiran Kumar

Anonymous said...

Hello Nicolas..

when I run createdb10.sql I got Oracle Not available. I echo ORACLE_SID, it's same with variable I set up on createdb10.sql.

Any idea.?

Anonymous said...

Hi, guys..you blog has really helped me run the PSOFT installation fromscratch. Thanks for your work. But I am stack at this point;
1) When I log in Data Mover as either PS/PS or sysadm/sysadm i get an
"File: E:\pt850-903-R1-retail\peopletools\SRC\pssys\stmget.cppSQL error. Stmt #: 2722 Error Position: 39 Return: 904 - ORA-00904: "DBNAME": invalid identifier
Failed SQL stmt:SELECT OWNERID FROM PS.PSDBOWNER WHERE DBNAME=:1" error but I used the Configuration manager to set them.
2) when i run psadmin.sql it run well but later gives me;
ERROR at line 1:
ORA-00942: table or view does not exist.
3) i do not know your step 3. Ensure your NLS_LANG env variable is set correctly. how to set the NLS_LANG .my is english.
and oracle is english and also how to set the password file.
I am using oracle 10g and FSCM 9.0 and PT 8.50
Also my domain is not booting. It always gives me the error that my appserv cannot connect to my database. But is the same user/password to log into the database.

Can you send me an email(hubert_boateng@yahoo.co.uk) to let me know how I will be able to go about it. Thank you very much.

shiva said...

Hi Nicolas,
I have successfully installed oracle 11g R2, PT8.50 on OEL 5.3 on VMWare Server. I am running Database setup import script in datamover from my host windows machine , its been running since 3 days and the script didnt finished, I have added all the required recommended parameter to init.ora file but there is no improvement. Please give me any more suggestions on how can I improve this import script performance. Please let me know if you need any more information. Thanks in advance

Alex Lozano said...

Hello.

Thanks so much for posting this info.

I am installing on Windows XP/Oracle 11G. I am building the PeopleSoft database (Tools & Application have been installed) and executing the sql scripts to build the database.

I have executed the following scripts.

utlspace.sql
dbowner.sql

I am ready to execute the PADDL.sql script but wanted to know at which part of the process I should execute the PTDDL.sql script? I created the database instance through DBCA.

Thanks!!

Nicolas Gasparotto said...

PADDL.SQL is creating the tablespaces for Entrprise Portal, it should take place at step 9 instead of HCDDL.SQL (my case was on HRMS).
So, you should run it before load the Peoplesoft objects.
You don't need to PTDDL.SQL which is used for a Peopletools System Database (Peopletools objects only without Application).

Nicolas.

Anonymous said...

Hi Nicolas,
I a new to PS, I am installing PT8.49, HRMS9.0 v1 in Oracle10g, Win2003.

I got struck in creating datbase, I am using peoplesoft database configuration wizard to setup the database. It got struck with error.

Importing AV_MBR_ORG_TBL
Creating Table AV_MBR_ORG_TBL
SQL Error. Error Position: 34 Return: 8007 - Insufficient memory available
INSERT INTO PS_AV_MBR_ORG_TBL ....
Error: Unable to insert row 2
Error: SQL execute error for AV_MBR_ORG_TBL
SQL Spaces: 0 Tables: 335 Triggers: 0 Indexes: 404 Views: 0
Ended: Thu Aug 05 20:31:43 2010
Unsuccessful completion

I tried it several times, however i got struck at this point.

I need your help to figure out the issue.

Thanks

Rajesh

Anonymous said...

Hi,
This krish.I am searching for job as psadmin.can u tell me which type of quations asked in interviw.

Hari said...

Hi
I instaling PT849 and got below error during manual database creation.
Logged into Datamover bootstrap mode with SYSADM and selected 'Database Setup' --> Demo. auto generated script cameup. When I executed the script got below error. Please help how to proceed from here.

5
Updating statistics for GP_FORMULA
Records remaining: 10832
Importing GP_FORMULA_CLUE
Creating Table GP_FORMULA_CLUE
File: e:\pt849-905-R1-retail\peopletools\SRC\pssys\gendttm.cppSQL error. Stmt #: 192 Error Position: 62 Return: 942 - ORA-00942: table or view does not exist
Failed SQL stmt:SELECT TO_CHAR(SYSDATE,'YYYY-MM-DD-HH24.MI.SS."000000"') FROM PSCLOCK

Neha said...

Hi Nicolas, I am installing PeopleSoft HRMS 9.0 with PT 8.50 on personal laptop. I am at Step 15, where we need to run the DMS scripts. Since I am installing on laptop, I do not have a client m\c. So how should I go about running the DMS? The PS guide tells something about telnet seeion, but I am not able to actually understand it.

RAFIUDDEEN said...

cannot create spfile already being used by the instance?? Mean what??

Iam ask questions of create spfile
from pfile =c:\app.\...\...\pfile\initcsdev90.ora

SafePaaS said...

Nice information. Visit SafePaaS, We offer you a new application-risk management for PeopleSoft, which unlocks new opportunities to show the impact of freight costs on your profit margins.