=============
Dropping role CK_ORACLE_REPOS_OWNER if it already exists
Creating role CK_ORACLE_REPOS_OWNER
Granting privileges to CK_ORACLE_REPOS_OWNER
Granting EXECUTE privilege on STANDARD to CK_ORACLE_REPOS_OWNER
************************************************
* Creating database Objects *
************************************************
Creating tablespaces ..............
Creating CONSTANT_GROW_INDEXES tablespace ....
Tablespace created.
Creating CONSTANT_GROW_TABLES tablespace ....
Tablespace created.
Creating DEPENDENCY_INDEXES tablespace ....
Tablespace created.
Creating DEPENDENCY_TABLES tablespace ....
Tablespace created.
Creating DIAGRAM_INDEXES tablespace ....
Tablespace created.
Creating DIAGRAM_TABLES tablespace ....
Tablespace created.
Creating LOB_DATA tablespace ....
Tablespace created.
Creating RAPID_GROW_INDEXES tablespace ....
Tablespace created.
Creating RAPID_GROW_TABLES tablespace ....
Tablespace created.
Creating SYSTEM_META_INDEXES tablespace ....
Tablespace created.
Creating SYSTEM_META_TABLES tablespace ....
Tablespace created.
Creating TEMPORARY_INDEXES tablespace ....
Tablespace created.
Creating TEMPORARY_TABLES tablespace ....
Tablespace created.
Creating VERSION_INDEXES tablespace ....
Tablespace created.
Creating VERSION_TABLES tablespace ....
Tablespace created.
Creating REPOS_RBS tablespace ....
Tablespace created.
Creating REPOS_TEMP tablespace ....
create tablespace REPOS_TEMP
*
ERROR at line 1:
ORA-12913: Cannot create dictionary managed tablespace
End of tablespace creation process.
****************************************************
Following tablespaces were created
****************************************************
CONSTANT_GROW_INDEXES ONLINE
CONSTANT_GROW_TABLES ONLINE
DEPENDENCY_INDEXES ONLINE
DEPENDENCY_TABLES ONLINE
DIAGRAM_INDEXES ONLINE
DIAGRAM_TABLES ONLINE
LOB_DATA ONLINE
RAPID_GROW_INDEXES ONLINE
RAPID_GROW_TABLES ONLINE
REPOS_RBS ONLINE
SYSTEM_META_INDEXES ONLINE
SYSTEM_META_TABLES ONLINE
TEMPORARY_INDEXES ONLINE
TEMPORARY_TABLES ONLINE
VERSION_INDEXES ONLINE
VERSION_TABLES ONLINE
Creating rollback segment REPOS_RBS_SEGMENT .....
create rollback segment REPOS_RBS_SEGMENT tablespace REPOS_RBS
*
ERROR at line 1:
ORA-30019: Illegal rollback Segment operation in Automatic Undo mode
Bring the rollback segment online .....
alter rollback segment REPOS_RBS_SEGMENT online
*
ERROR at line 1:
ORA-30019: Illegal rollback Segment operation in Automatic Undo mode
Name and Status of the rollback segment
State of non-system rollback segments
_SYSSMU1$ ONLINE
_SYSSMU2$ ONLINE
_SYSSMU3$ ONLINE
_SYSSMU4$ ONLINE
_SYSSMU5$ ONLINE
_SYSSMU6$ ONLINE
_SYSSMU7$ ONLINE
_SYSSMU8$ ONLINE
_SYSSMU9$ ONLINE
_SYSSMU10$ ONLINE
The repository packages, procedures and views are stored in the SYSTEM tablespace, and need 140Mb of free space
****************************************************************************************************************
Current datafile size(in MB) of SYSTEM tablespace
G:\ORACLE\ORADATA\ITCDB\SYSTEM01.DBF SYSTEM 546
Current Free space(in MB) available in SYSTEM tablespace
SYSTEM 150.0625
Sufficient free space available. No resizing necessary ..
Free space(in MB) available in system tablespace ...
******************************************************
SYSTEM 150.0625
Creating Repository User : REPOS_MANAGER having Password : MANAGER
create user REPOS_MANAGER identified by MANAGER
*
ERROR at line 1:
ORA-00959: tablespace 'REPOS_TEMP' does not exist
Granting privilege on database objects to REPOS_MANAGER
*****************************************************
Granting EXECUTE on dbms_lock to REPOS_MANAGER ....
grant execute on dbms_lock to REPOS_MANAGER
*
ERROR at line 1:
ORA-01917: user or role 'REPOS_MANAGER' does not exist
Granting EXECUTE on dbms_pipe to REPOS_MANAGER ....
grant execute on dbms_pipe to REPOS_MANAGER
*
ERROR at line 1:
ORA-01917: user or role 'REPOS_MANAGER' does not exist
Granting CREATE TABLE to REPOS_MANAGER ....
grant create table to REPOS_MANAGER
*
ERROR at line 1:
ORA-01917: user or role 'REPOS_MANAGER' does not exist
Granting CREATE VIEW to REPOS_MANAGER ....
grant create view to REPOS_MANAGER
*
ERROR at line 1:
ORA-01917: user or role 'REPOS_MANAGER' does not exist
Granting CREATE PROCEDURE to REPOS_MANAGER ....
grant create procedure to REPOS_MANAGER
*
ERROR at line 1:
ORA-01917: user or role 'REPOS_MANAGER' does not exist
Granting CREATE SYNONYM to REPOS_MANAGER ....
grant create synonym to REPOS_MANAGER
*
ERROR at line 1:
ORA-01917: user or role 'REPOS_MANAGER' does not exist
Granting CREATE SEQUENCE to REPOS_MANAGER ....
grant create sequence to REPOS_MANAGER
*
ERROR at line 1:
ORA-01917: user or role 'REPOS_MANAGER' does not exist
Granting SELECT on sys.v_$nls_parameters to REPOS_MANAGER ....
grant select on sys.v_$nls_parameters to REPOS_MANAGER with grant option
*
ERROR at line 1:
ORA-01917: user or role 'REPOS_MANAGER' does not exist
Granting SELECT on sys.v_$parameter to REPOS_MANAGER ....
grant select on sys.v_$parameter to REPOS_MANAGER
*
ERROR at line 1:
ORA-01917: user or role 'REPOS_MANAGER' does not exist
Granting SELECT on dba_rollback_segs to REPOS_MANAGER ....
grant select on dba_rollback_segs to REPOS_MANAGER
*
ERROR at line 1:
ORA-01917: user or role 'REPOS_MANAGER' does not exist
Granting SELECT on dba_segments to REPOS_MANAGER ....
grant select on dba_segments to REPOS_MANAGER
*
ERROR at line 1:
ORA-01917: user or role 'REPOS_MANAGER' does not exist
Granting CREATE ANY SYNONYM to REPOS_MANAGER ....
grant create any synonym to REPOS_MANAGER
*
ERROR at line 1:
ORA-01917: user or role 'REPOS_MANAGER' does not exist
Granting DROP ANY SYNONYM to REPOS_MANAGER ....
grant drop any synonym to REPOS_MANAGER
*
ERROR at line 1:
ORA-01917: user or role 'REPOS_MANAGER' does not exist
Granting CK_ORACLE_REPOS_OWNER to REPOS_MANAGER ....
grant ck_oracle_repos_owner to REPOS_MANAGER
*
ERROR at line 1:
ORA-01917: user or role 'REPOS_MANAGER' does not exist
Granting CONNECT,RESOURCE to REPOS_MANAGER ....
grant connect,resource to REPOS_MANAGER
*
ERROR at line 1:
ORA-01917: user or role 'REPOS_MANAGER' does not exist
Granting ALL on CKRAU_TEMP to REPOS_MANAGER ....
grant ALL on sys.CKRAU_TEMP to REPOS_MANAGER
*
ERROR at line 1:
ORA-01917: user or role 'REPOS_MANAGER' does not exist
Creating Synonym CKRAU_TEMP ....
create synonym "REPOS_MANAGER".ckrau_temp for sys.ckrau_temp
*
ERROR at line 1:
ORA-01917: user or role '' does not exist
declare
*
ERROR at line 1:
ORA-01917: user or role 'REPOS_MANAGER' does not exist
ORA-06512: at line 6
End of Grant privilege on database objects to REPOS_MANAGER
End of 'Create database Objects' process
************************************************