[ tibor @ 10.03.2005. 14:04 ] @
ukratko, imam problem sa instalacijom repository-a tj. konkretno sa pravljenjem tablespace-ova. Imam instaliranu bazu 9.2.0.1.0 i Developer Suite Rel 2 (9.0.2). Podesavanje parametara baze je podesio admin pa baza radi kako treba. Podesavanje tablespace-ova sam radio (nazalost) ja na osnovu repository installation guide-a prvo skript metodom, pa onda i manuelnom. U nastavku cete naci logove i greske, nadam se da mi mozete pomoci. Admin mi je rekao da mi ne treba undo i rollback ali ja to ne znam da izbacim iz skript metode a ne poznajem oracle toliko da koristim rucnu metodu. ============= 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 ************************************************ |