I am trying to install peoplesoft 9.0 ..
I installed all the required software into my system.datamover part is over.After that when I try to log in to app designer it is throwing me the error (Invalid username and password ).Could you please let me out in tracing what would be the problem.

First try to login to using Datamover in bootstrap mode which is SYSADM/PASSWORD. If you are able to login then there is no issue with the DATABASE USER ACCESS. If not then change the database password for SYSADM from database and try the above step again.

Second try using VP1 or PS it it does not work, then login to data mover in bootstrap mode and run this to the actual password for SYSADM.
CHANGE_ACCESS_PASSWORD SYSADM1 YOURPASSWORD;
[Don't forget the ; at the end]

Then logout and login using VP1/PS.If you still have problem, then login to data mover in bootstrap mode again and run this command:

update PSOPRDEFN set OPERPSWD = 'VP1', ACCTLOCK = 0, ENCRYPTED = 0
where OPRID = 'VP1';
ENCRYPT_PASSWORD VP1;
commit;

YOU SHOULD BE ABLE TO LOGIN NOW.
If not then the INSTALLATION IS NOT GOOD, CLEAN THE DATABASE and run all the datamover scripts for creating the database.

Thanks for your prompt response.I can login to datamover in bootstrap mode by using sysadm .Even I can login through VP1 also.I went through the database setup in datamover and ran the scripts.When I come to next step like login to the Application designer
I am getting an error .(Here i tried to login by using sysadm,VP1).

Looks like the tools installation did not go well. You need to drop user and created the user again and go through the installation document.

It is better to create the database manually [check the appendix in the installation for installing database manually]. This way the chances of running into some error and missing some important table.

Also make sure to provide unlimited tablespace limit to expand while installing. Check the disk space while installing so that it does not error out.

Create as large as possible PSTEMP tablespace also before installing.

Good Luck.

Hi,

I created the database manually as you said by looking at "create database manually in windows".
But when I try to execute the utlspace.sql. It is giving me an stating that cannot create tablespace "psdefault" It reaches the maximum 4GB limit.I am using oracle 10g express edition .My question is I can't use oracle express edition for my peoplesoft installation or I need to change something else to do the same.

thanks

Yes, you can NOT use Oracle Express Edition for PeopleSoft. If you are using this for learning purpose and not for production, you can download from the e-delivery site the oracle Enterprise or Standard Edition.

Also note that you should check the correct oracle version compatible to the People Tools version and Operating system you are installing in the installation document.

Hi,
Thankyou very much for your prompt response.
I am little bit confused about your second paragraph.
I am trying to install peoplesoft 9.0 with peopletools 8.49 for windows for that oracle 10g version(enterprise) is ok .
when I go to edelivery and select the product name as oracle database and windows 32 bit.
from that I can select the below mentioned one and I am sorry if this is a silly question.
can you use this (Oracle® Database 10g Release 2 (10.2.0.1.0) Media Pack (with Oracle® Enterprise Manager 10g Release 4 Grid Control, Oracle® Secure Backup Release 10.1.0.3.0 and Oracle® Warehouse Builder 10g Release 2) for Microsoft Windows (32-bit)

Oracle® Database 10g Release 2 (10.2.0.1.0) Media Pack should be fine. Other tools like Enterprise manager or Warehouse builder are not required.

Hi,
I used Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
Created database manually and then all executed alall scripts. And I logged to the data mover in bootstrap mode and ran the scripts.And it was showing sucessful completion.
Simply ran this query:
select count(*), object_type from user_objects group by object_type;

COUNT(*) OBJECT_TYPE
---------- -------------------
5 TRIGGER
1792 TABLE
2208 INDEX
1331 VIEW
After that I tried to config,create,launch the app server
I created a domain and it said domain config complete.after that I tried to boot the same and it is throwing the error.

PSADMIN.4676 (0) [01/26/09 17:13:59](0) Begin boot attempt on domain FDEVELOC
PSWATCHSRV.320 (0) [01/26/09 17:14:07] Checking process status every 120 seconds

PSWATCHSRV.320 (0) [01/26/09 17:14:07] Server started
PSAPPSRV.3060 (0) [01/26/09 17:14:08](0) PeopleTools Release 8.49 (WinX86) start
ing
PSAPPSRV.3060 (0) [01/26/09 17:14:08](0) Cache Directory being used: D:\peopleso
ft\BIN\appserv\FDEVELOC\CACHE\PSAPPSRV_2\
PSAPPSRV.3060 (0) [01/26/09 17:14:10](1) GenMessageBox(0, 0, M): Database Signon
: Invalid user ID or password for database signon. (id=PS)
PSAPPSRV.3060 (0) [01/26/09 17:14:10](0) Server failed to start
PSWATCHSRV.320 (0) [01/26/09 17:14:11] Shutting down
PSADMIN.4676 (0) [01/26/09 17:14:17](0) End boot attempt on domain FDEVELOC

could you please help me out.

Thanks,
Sri

Are you able to login using App Designer? IF yes what user id you are using and what user id you are using to start the app servers?

Hi,

I created ,configured the app server by using PSADMIN.
By using user id as :PSADMIN I can able to create and config a app server.
And I used this id(PSADMIN) to login to app designer.But it is not working with VP1 or PS.

How you were able to create the user id PSADMIN where you are not able to login in PIA. Also you should start the App Servers using VP1 or PS as this is the user id which has permissions to start and start the App servers.

Please check on that why you are not able to use these two user ids. The user id PSADMIN may not have permission to start the app server. Check on the permissions for this user id.

Hi,

I tried to create,config and start the app server and I got this error message
"Database Signon
: Invalid user ID or password for database signon. (id=PS)"

After that I checked in PSOPRDEFN table and find out these entries.
OPRID
------------
PSADMIN
PTADMIN
PTDMO
PTPORTAL
PTSECADM
PTTOOLS
PTWEBSERVER

So I used PSADMIN to create,config and start the app server.This time I didnt get that error message.And when I try to boot the domain 11 proccess has started.

Next I tried login to Application Designer using PSADMIN which is allowing me(but not with VP1 or PS)

Next I tried to login to peoplesoft sign on page using PSADMIN which is allowing me(but not with VP1 or PS)

After that I tried to config the process scheduler with PSADMIN but no success.

All these things I have done before getting ur reply.And from ur reply I found that I need to do with VP1 or PS.

So I am just wondering is there a way to find out why my VP1 or PS entry is not there in PSOPRDEFN table.

Hi,
I am just waiting for the reply.

You should have Roles to VP1 or PS. Mostly if it is Finance/CRM it should be VP1 and for HRMS it should PS. Check and compare the roles between VP1/PS and PSADMIN, if you have that user id already.

Try to give "PeopleSoft Administrator" and "ProcessSchedulerAdmin" roles to the user id.

Also post what are the roles that VP1/PS has and PSADMIN has if you still have problem.