Need help - Install EnterpriseOne / Oracle DB Install

[owlearner]

Hello All,


I am configuring a entrprise one sp1 setup with oracle as DB. i am keeping the enterprise machine and DB machine separately. The 3rd CD (Enterprise One CD's) is failing with a meesage "Failed to install Oracle DB". could not go further and no idea in which direction i should go. Could you guys please help me out in successfully installing the DB with enterrpise one cds?




Please correct me if I am doing wrong any where in the following process, which I am following.



I have installed Enterprise Server on One machine without selecting the Enterprise Server DB options as I am going to install the DB on a separate machine. I have completed the DB machine setup with Oracle 10.2.0.3 successfully and started with Enterprise one CD's on the same machine. Disk1, Disk2, Disk3....mounted and DISK 3 endup with an error message Install failed and the Log file shows as follows. I have tried to create the users id's and role manually and tried again but it came out with an error message in the log as role or user conflicts with an existing user.



Could you please write me the steps need to follow for a successful DB install on separate machine?



Here are the logs

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

CRDBAUSR.log



old 2: default tablespace &PSFTUSERS

new 2: default tablespace USERS

old 3: temporary tablespace &PSFTTEMP

new 3: temporary tablespace TEMP

old 4: quota unlimited on &PSFTUSERS

new 4: quota unlimited on USERS

old 5: quota unlimited on &PSFTTEMP

new 5: quota unlimited on TEMP

create user psftdba identified by psftdba

*

ERROR at line 1:

ORA-30041: Cannot grant quota on the tablespace





grant connect, resource, dba to psftdba

*

ERROR at line 1:

ORA-01917: user or role 'PSFTDBA' does not exist



CRTABSP_SH.log





old 1: create tablespace sy&&RELEASE.t

new 1: create tablespace sy811t

old 3: datafile '&&TABLE_PATH\sy&&RELEASE.t01.dbf' size 250M autoextend on next 25M maxsize 1000M

new 3: datafile 'E:\PeopleSoft\ORCL\sy811t01.dbf' size 250M autoextend on next 25M maxsize 1000M

create tablespace sy811t

*

ERROR at line 1:

ORA-01119: error in creating database file 'E:\PeopleSoft\ORCL\sy811t01.dbf'

ORA-27038: created file already exists

OSD-04010: <create> option specified, file already exists



CRUSRS_APPS.log



Role created.





Grant succeeded.



old 2: default tablespace &PSFTUSERS

new 2: default tablespace USERS

old 3: temporary tablespace &PSFTTEMP

new 3: temporary tablespace TEMP

old 4: quota unlimited on &PSFTUSERS

new 4: quota unlimited on USERS

old 5: quota unlimited on &PSFTTEMP

new 5: quota unlimited on TEMP

create user psft identified by psft

*

ERROR at line 1:

ORA-30041: Cannot grant quota on the tablespace





old 2: default tablespace &PSFTUSERS

new 2: default tablespace USERS

old 3: temporary tablespace &PSFTTEMP

new 3: temporary tablespace TEMP

old 4: quota unlimited on &PSFTUSERS

new 4: quota unlimited on USERS

old 5: quota unlimited on &PSFTTEMP

new 5: quota unlimited on TEMP

create user applead identified by applead

*

ERROR at line 1:

ORA-30041: Cannot grant quota on the tablespace





old 2: default tablespace &PSFTUSERS

new 2: default tablespace USERS

old 3: temporary tablespace &PSFTTEMP

new 3: temporary tablespace TEMP

old 4: quota unlimited on &PSFTUSERS

new 4: quota unlimited on USERS

old 5: quota unlimited on &PSFTTEMP

new 5: quota unlimited on TEMP

create user sysadmin identified by sysadmin

*

ERROR at line 1:

ORA-30041: Cannot grant quota on the tablespace





old 2: default tablespace &PSFTUSERS

new 2: default tablespace USERS

old 3: temporary tablespace &PSFTTEMP

new 3: temporary tablespace TEMP

old 4: quota unlimited on &PSFTUSERS

new 4: quota unlimited on USERS

old 5: quota unlimited on &PSFTTEMP

new 5: quota unlimited on TEMP

create user produser identified by produser

*

ERROR at line 1:

ORA-30041: Cannot grant quota on the tablespace





old 2: default tablespace &PSFTUSERS

new 2: default tablespace USERS

old 3: temporary tablespace &PSFTTEMP

new 3: temporary tablespace TEMP

old 4: quota unlimited on &PSFTUSERS

new 4: quota unlimited on USERS

old 5: quota unlimited on &PSFTTEMP

new 5: quota unlimited on TEMP

create user devuser identified by devuser

*

ERROR at line 1:

ORA-30041: Cannot grant quota on the tablespace





grant psft_role to psft

*

ERROR at line 1:

ORA-01917: user or role 'PSFT' does not exist





grant psft_role to applead

*

ERROR at line 1:

ORA-01917: user or role 'APPLEAD' does not exist





grant psft_role to sysadmin

*

ERROR at line 1:

ORA-01917: user or role 'SYSADMIN' does not exist





grant psft_role to produser

*

ERROR at line 1:

ORA-01917: user or role 'PRODUSER' does not exist





grant psft_role to devuser

*

ERROR at line 1:

ORA-01917: user or role 'DEVUSER' does not exist



OracleStatus.log



Success = FALSE


++++++++++++++++++++++++++++++++++++++++++++++++

i have created the users and granted full rights fro tablespace, even then it fails with the same message.

Thanks in advance

Aftab

 

[msouterblight1]

Hello,

When running the CDs (these are collectively known as the platform pack) on the database server, it requests the DB admin user and passord (I forget the exact field names), what are you entering there??? It appears that whatever ID you are using, it doesn't have the correct privileges. You need to use an ID that has SYSDBA privileges, it is recommended that you use the SYS ID that was created when you installed Oracle. Behind the scenes, the platform pack is attemping to access the DB using the ID you entered when asked and passing it "as sysdba"..

The easiest solution is to use the SYS ID...

Matthew

 

[owlearner]

Hello Mathew,

Thanks for the reply. i have used the SYS user id for while installing from the CD's. I came to know that there is a bug in the CD's which need to be corrected manually after the 3rd CD and run those related scripts after editing them. Do you have any idea on editing those scripts?

Thanks

Aftab