Just like any other fusion product installations, OSR also needs certain schemas to be in Oracle database prior to installation.
Though we don't have any readymade RCU like in SOA, the schemas required for OSR installation are very few, so execute the following commands
Log into Oracle (system or DBA privileges are required).
Create a data tablespace named OSR_TABLESPACE with at least 50M of available space.
Though we don't have any readymade RCU like in SOA, the schemas required for OSR installation are very few, so execute the following commands
Log into Oracle (system or DBA privileges are required).
Create a data tablespace named OSR_TABLESPACE with at least 50M of available space.
CREATE TABLESPACE OSR_TABLESPACE LOGGING
DATAFILE 'OSR.DBF' SIZE 50M REUSE AUTOEXTEND
ON NEXT 10M MAXSIZE UNLIMITED
DEFAULT STORAGE (
INITIAL 5M
NEXT 5M
MINEXTENTS 1
MAXEXTENTS UNLIMITED
PCTINCREASE 50);
CREATE USER OSR
PROFILE DEFAULT
IDENTIFIED BY welcome1
DEFAULT TABLESPACE OSR_TABLESPACE
TEMPORARY TABLESPACE TEMP
ACCOUNT UNLOCK;
GRANT CONNECT TO OSR;
GRANT RESOURCE TO OSR;
GRANT UNLIMITED TABLESPACE TO OSR;
GRANT CREATE ANY SYNONYM TO OSR;
GRANT DROP ANY SYNONYM TO OSR;
Once the above sql's are executed, run the installer.
Hope this helps.
Hope this helps.
No comments:
Post a Comment