owlearner
Active Member
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
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