C:\>set ORACLE_HOME=C:\DevSuiteHome C:\>cd C:\DevSuiteHome C:\DevSuiteHome>cd repadm61\ADMIN C:\DevSuiteHome\repadm61\ADMIN>sqlplus sys@xe as sysdba SQL*Plus: Release 10.1.0.4.2 - Production on So Mrz 9 11:53:43 2009 Copyright (c) 1982, 2005, Oracle. All rights reserved. Kennwort eingeben: Verbunden mit: Oracle Database 10g Express Edition Release 10.2.0.1.0 - Production SQL> @ckqa Enter TNS connect String for server Enter TNS : XE Enter password for SYS ....' Kennwort eingeben: Connect durchgef³hrt. Enter the Repository size you wish to create. Small(S),Medium(M),Large(L) ... Enter S/M/L : S Dropping temporary table CKRAU_TEMP drop table CKRAU_TEMP * FEHLER in Zeile 1: ORA-00942: Tabelle oder View nicht vorhanden Creating temporary table CKRAU_TEMP Tabelle wurde angelegt. Enter datafile location and name for CONSTANT_GROW_INDEXES... Enter datafile : C:\ORACLEXE\ORADATA\XE\constant_grow_indexes.dbf Enter datafile location and name for CONSTANT_GROW_TABLES... Enter datafile : C:\ORACLEXE\ORADATA\XE\constant_grow_tables.dbf Enter datafile location and name for DEPENDENCY_INDEXES... Enter datafile : C:\ORACLEXE\ORADATA\XE\dependency_indexes.dbf Enter datafile location and name for DEPENDENCY_TABLES... Enter datafile : C:\ORACLEXE\ORADATA\XE\dependency_tables.dbf Enter datafile location and name for DIAGRAM_INDEXES... Enter datafile : C:\ORACLEXE\ORADATA\XE\diagram_indexes.dbf Enter datafile location and name for DIAGRAM_TABLES... Enter datafile : C:\ORACLEXE\ORADATA\XE\diagram_tables.dbf Enter datafile location and name for LOB_DATA... Enter datafile : C:\ORACLEXE\ORADATA\XE\lob_data.dbf Enter datafile location and name for RAPID_GROW_INDEXES... Enter datafile : C:\ORACLEXE\ORADATA\XE\rapid_grow_indexes.dbf Enter datafile location and name for RAPID_GROW_TABLES... Enter datafile : C:\ORACLEXE\ORADATA\XE\rapid_grow_tables.dbf Enter datafile location and name for SYSTEM_META_INDEXES... Enter datafile : C:\ORACLEXE\ORADATA\XE\system_meta_indexes.dbf Enter datafile location and name for SYSTEM_META_TABLES... Enter datafile : C:\ORACLEXE\ORADATA\XE\system_meta_tables.dbf Enter datafile location and name for TEMPORARY_INDEXES... Enter datafile : C:\ORACLEXE\ORADATA\XE\temporary_indexes.dbf Enter datafile location and name for TEMPORARY_TABLES... Enter datafile : C:\ORACLEXE\ORADATA\XE\temporary_tables.dbf Enter datafile location and name for VERSION_INDEXES... Enter datafile : C:\ORACLEXE\ORADATA\XE\version_indexes.dbf Enter datafile location and name for VERSION_TABLES... Enter datafile : C:\ORACLEXE\ORADATA\XE\version_tables.dbf Enter datafile location and name for REPOS_RBS tablespace... Enter datafile : C:\ORACLEXE\ORADATA\XE\repos_rbs.dbf Enter datafile location and name for REPOS_TEMP tablespace... Enter datafile : C:\ORACLEXE\ORADATA\XE\repos_temp.dbf For ten or more subordinate users, we recommend giving access using public synonyms. Do you wish to grant create/drop public synonym privilege to Repository Owner ? Enter Choice (Y/N) : Y Rem PARAMETER DEFINITION FILE Rem Rem TNS Connect String define CONN = XE define TBS_NAME1 = CONSTANT_GROW_INDEXES define DF_NAME1 = C:\ORACLEXE\ORADATA\XE\constant_grow_indexes.dbf define TBS_NAME2 = CONSTANT_GROW_TABLES define DF_NAME2 = C:\ORACLEXE\ORADATA\XE\constant_grow_tables.dbf define TBS_NAME3 = DEPENDENCY_INDEXES define DF_NAME3 = C:\ORACLEXE\ORADATA\XE\dependency_indexes.dbf define TBS_NAME4 = DEPENDENCY_TABLES define DF_NAME4 = C:\ORACLEXE\ORADATA\XE\dependency_tables.dbf define TBS_NAME5 = DIAGRAM_INDEXES define DF_NAME5 = C:\ORACLEXE\ORADATA\XE\diagram_indexes.dbf define TBS_NAME6 = DIAGRAM_TABLES define DF_NAME6 = C:\ORACLEXE\ORADATA\XE\diagram_tables.dbf define TBS_NAME7 = LOB_DATA define DF_NAME7 = C:\ORACLEXE\ORADATA\XE\lob_data.dbf define TBS_NAME8 = RAPID_GROW_INDEXES define DF_NAME8 = C:\ORACLEXE\ORADATA\XE\rapid_grow_indexes.dbf define TBS_NAME9 = RAPID_GROW_TABLES define DF_NAME9 = C:\ORACLEXE\ORADATA\XE\rapid_grow_tables.dbf define TBS_NAME10 = SYSTEM_META_INDEXES define DF_NAME10 = C:\ORACLEXE\ORADATA\XE\system_meta_indexes.dbf define TBS_NAME11 = SYSTEM_META_TABLES define DF_NAME11 = C:\ORACLEXE\ORADATA\XE\system_meta_tables.dbf define TBS_NAME12 = TEMPORARY_INDEXES define DF_NAME12 = C:\ORACLEXE\ORADATA\XE\temporary_indexes.dbf define TBS_NAME13 = TEMPORARY_TABLES define DF_NAME13 = C:\ORACLEXE\ORADATA\XE\temporary_tables.dbf define TBS_NAME14 = VERSION_INDEXES define DF_NAME14 = C:\ORACLEXE\ORADATA\XE\version_indexes.dbf define TBS_NAME15 = VERSION_TABLES define DF_NAME15 = C:\ORACLEXE\ORADATA\XE\version_tables.dbf Rem Rem Tablespace for Rollback Segment define RTBLSPACE = REPOS_RBS Rem File name and location for Rollback Segment tablespace define RDFILENAME = C:\ORACLEXE\ORADATA\XE\repos_rbs.dbf Rem Rem Name of Rollback Segment define RBSNAME = REPOS_RBS_SEGMENT Rem Rem Name of temporary tablespace for Repository Owner define TEMPTBLSPACE = REPOS_TEMP Rem File name and location for temporary tablespace define TEMPFILENAME = C:\ORACLEXE\ORADATA\XE\repos_temp.dbf Rem File size of temporary tablespace for Repository Owner define TEMPFILESIZE = 15372k Rem Rem Name of Repository Owner define REPOSOWNER = REPOS_MANAGER Rem Rem Default tablespace for Repository Owner define DEFTABSPACE = TEMPORARY_TABLES Rem Choice indicating whether Repository Owner has privilege Rem to create/drop public synonyms define MOREUSERS = Y Rem Rem Default tablespace size for default tablespaces (SMALL Repository) define CONST_GROW_INDX_SIZE = 2048k define CONST_GROW_TAB_SIZE = 2048k define DEP_INDX_SIZE = 10240k define DEP_TAB_SIZE = 2048k define DIAG_INDX_SIZE = 4096k define DIAG_TAB_SIZE = 2048k define LOB_DATA_SIZE = 1024k define RAP_GROW_INDX_SIZE = 303104k define RAP_GROW_TAB_SIZE = 89200k define SYS_META_INDX_SIZE = 30720k define SYS_META_TAB_SIZE = 20480k define TEMP_INDX_SIZE = 10240k define TEMP_TAB_SIZE = 10240k define VER_INDX_SIZE = 10240k define VER_TAB_SIZE = 5600k Rem Rem Default Storage parameters for tablespace define INITIAL_VALUE = 100k define NEXT_VALUE = 100k define PCTINC_VALUE = 0 define MINEXT_VALUE = 1 define MAXEXT_VALUE = UNLIMITED Hit enter to Continue with validation process .... Started Validation ...... 0 Zeilen wurden gel÷scht. Inserting parameter values into temporary table CKRAU_TEMP ... 1 Zeile wurde erstellt. ... 1 Zeile wurde erstellt. Insertion complete ... Transaktion mit COMMIT abgeschlossen. Following tablespaces already exists ----------------------------------- Following Rollback segment already exists ---------------------------------------- Following Username already exists ---------------------------------------- End of Validation .... " ***************************************************************************** * " " * Please verify the above values. * " " * Edit 'ckparams.txt' to make any changes. Then run ckparams.txt * " " ***************************************************************************** * " SQL>@ckparams.txt SQL>@ckcreate_mb Dropping role CK_ORACLE_REPOS_OWNER if it already exists DROP ROLE CK_ORACLE_REPOS_OWNER * FEHLER in Zeile 1: ORA-01919: Rolle 'CK_ORACLE_REPOS_OWNER' nicht vorhanden Creating role CK_ORACLE_REPOS_OWNER Rolle wurde angelegt. Granting privileges to CK_ORACLE_REPOS_OWNER Benutzerzugriff (Grant) wurde erteilt. Granting EXECUTE privilege on STANDARD to CK_ORACLE_REPOS_OWNER Benutzerzugriff (Grant) wurde erteilt. ************************************************ * Creating database Objects * ************************************************ Creating tablespaces .............. Creating CONSTANT_GROW_INDEXES tablespace .... Tablespace wurde angelegt. Creating CONSTANT_GROW_TABLES tablespace .... Tablespace wurde angelegt. Creating DEPENDENCY_INDEXES tablespace .... Tablespace wurde angelegt. Creating DEPENDENCY_TABLES tablespace .... Tablespace wurde angelegt. Creating DIAGRAM_INDEXES tablespace .... Tablespace wurde angelegt. Creating DIAGRAM_TABLES tablespace .... Tablespace wurde angelegt. Creating LOB_DATA tablespace .... Tablespace wurde angelegt. Creating RAPID_GROW_INDEXES tablespace .... Tablespace wurde angelegt. Creating RAPID_GROW_TABLES tablespace .... Tablespace wurde angelegt. Creating SYSTEM_META_INDEXES tablespace .... Tablespace wurde angelegt. Creating SYSTEM_META_TABLES tablespace .... Tablespace wurde angelegt. Creating TEMPORARY_INDEXES tablespace .... Tablespace wurde angelegt. Creating TEMPORARY_TABLES tablespace .... Tablespace wurde angelegt. Creating VERSION_INDEXES tablespace .... Tablespace wurde angelegt. Creating VERSION_TABLES tablespace .... Tablespace wurde angelegt. Creating REPOS_TEMP tablespace .... Tablespace wurde angelegt. PL/SQL-Prozedur wurde erfolgreich abgeschlossen. 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_TEMP ONLINE SYSTEM_META_INDEXES ONLINE SYSTEM_META_TABLES ONLINE TEMPORARY_INDEXES ONLINE TEMPORARY_TABLES ONLINE VERSION_INDEXES ONLINE VERSION_TABLES ONLINE Name and Status of the rollback segment State of non-system rollback segments _SYSSMU10$ ONLINE _SYSSMU9$ ONLINE _SYSSMU8$ ONLINE _SYSSMU7$ ONLINE _SYSSMU6$ ONLINE _SYSSMU5$ ONLINE _SYSSMU4$ ONLINE _SYSSMU3$ ONLINE _SYSSMU2$ ONLINE _SYSSMU1$ ONLINE The repository packages, procedures and views are stored in the SYSTEM tablespace, and needs 140Mb of free space **************************************************************************************************************** Current datafile size(in MB) of SYSTEM tablespace C:\ORACLEXE\ORADATA\XE\SYSTEM.DBF SYSTEM 340 Current Free space(in MB) available in SYSTEM tablespace SYSTEM 10,0625 Datafile resizing complete ..... Free space(in MB) available in system tablespace ... ****************************************************** SYSTEM 150,0625 Creating Repository User : REPOS_MANAGER having Password : MANAGER Benutzer wurde angelegt. Granting privilege on database objects to REPOS_MANAGER ***************************************************** Granting EXECUTE on dbms_rls to REPOS_MANAGER .... Benutzerzugriff (Grant) wurde erteilt. Granting EXECUTE on dbms_lock to REPOS_MANAGER .... Benutzerzugriff (Grant) wurde erteilt. Granting EXECUTE on dbms_pipe to REPOS_MANAGER .... Benutzerzugriff (Grant) wurde erteilt. Granting CREATE TABLE to REPOS_MANAGER .... Benutzerzugriff (Grant) wurde erteilt. Granting CREATE VIEW to REPOS_MANAGER .... Benutzerzugriff (Grant) wurde erteilt. Granting CREATE PROCEDURE to REPOS_MANAGER .... Benutzerzugriff (Grant) wurde erteilt. Granting CREATE SYNONYM to REPOS_MANAGER .... Benutzerzugriff (Grant) wurde erteilt. Granting CREATE SEQUENCE to REPOS_MANAGER .... Benutzerzugriff (Grant) wurde erteilt. Granting SELECT on sys.v_$nls_parameters to REPOS_MANAGER .... Benutzerzugriff (Grant) wurde erteilt. Granting SELECT on sys.v_$parameter to REPOS_MANAGER .... Benutzerzugriff (Grant) wurde erteilt. Granting SELECT on dba_rollback_segs to REPOS_MANAGER .... Benutzerzugriff (Grant) wurde erteilt. Granting SELECT on dba_segments to REPOS_MANAGER .... Benutzerzugriff (Grant) wurde erteilt. Granting CREATE ANY SYNONYM to REPOS_MANAGER .... Benutzerzugriff (Grant) wurde erteilt. Granting DROP ANY SYNONYM to REPOS_MANAGER .... Benutzerzugriff (Grant) wurde erteilt. Granting CK_ORACLE_REPOS_OWNER to REPOS_MANAGER .... Benutzerzugriff (Grant) wurde erteilt. Granting CONNECT,RESOURCE to REPOS_MANAGER .... Benutzerzugriff (Grant) wurde erteilt. Granting ALL on CKRAU_TEMP to REPOS_MANAGER .... Benutzerzugriff (Grant) wurde erteilt. Creating Synonym CKRAU_TEMP .... Synonym wurde angelegt. PL/SQL-Prozedur wurde erfolgreich abgeschlossen. End of Grant privilege on database objects to REPOS_MANAGER End of 'Create database Objects' process ************************************************ SQL> @ckreport Connect durchgef³hrt. ********************************************************************** Report on the missing database objects ********************************************************************** Following tablespaces are missing -------------------------------- REPOS_RBS Following Rollback segments are missing --------------------------------------- REPOS_RBS_SEGMENT ********************************************************************** Report on the database objects created during the Install process ********************************************************************** Rollback Segments created ------------------------ Following Roles were created --------------------------- CK_ORACLE_REPOS_OWNER The following privilege were granted to the CK_ORACLE_REPOS_ROLE --------------------------------------------------------------- CREATE ANY TABLE CREATE ANY SEQUENCE CREATE ANY TYPE ALTER SESSION CREATE ANY VIEW SELECT ANY SEQUENCE CREATE DATABASE LINK CREATE ANY PROCEDURE CREATE ANY TRIGGER CREATE ANY CLUSTER CREATE SESSION CREATE ANY SYNONYM CREATE ANY INDEX DROP ANY SYNONYM CREATE ROLE CREATE ANY MATERIALIZED VIEW Tablespaces and their size ------------------------- TABLESPACE_NAME Size (in KB) ------------------------- ------------ CONSTANT_GROW_INDEXES 1976 CONSTANT_GROW_TABLES 1976 DEPENDENCY_INDEXES 10088 DEPENDENCY_TABLES 1976 DIAGRAM_INDEXES 3952 DIAGRAM_TABLES 1976 LOB_DATA 936 RAPID_GROW_INDEXES 302952 RAPID_GROW_TABLES 89128 SYSTEM_META_INDEXES 30576 SYSTEM_META_TABLES 20384 TEMPORARY_INDEXES 10088 TEMPORARY_TABLES 10088 VERSION_INDEXES 10088 VERSION_TABLES 5512 Tablespace and their Storage parameters -------------------------------------- TABLESPACE_NAME Initial Next PCT Inc Min Extents Max Extents ------------------------- ------- ----- ---------- ----------- -------------- CONSTANT_GROW_INDEXES 104 104 0 1 2147483645 CONSTANT_GROW_TABLES 104 104 0 1 2147483645 DEPENDENCY_INDEXES 104 104 0 1 2147483645 DEPENDENCY_TABLES 104 104 0 1 2147483645 DIAGRAM_INDEXES 104 104 0 1 2147483645 DIAGRAM_TABLES 104 104 0 1 2147483645 LOB_DATA 104 104 0 1 2147483645 RAPID_GROW_INDEXES 104 104 0 1 2147483645 RAPID_GROW_TABLES 104 104 0 1 2147483645 REPOS_TEMP 1024 1024 0 1 SYSTEM_META_INDEXES 104 104 0 1 2147483645 SYSTEM_META_TABLES 104 104 0 1 2147483645 TEMPORARY_INDEXES 104 104 0 1 2147483645 TEMPORARY_TABLES 104 104 0 1 2147483645 VERSION_INDEXES 104 104 0 1 2147483645 VERSION_TABLES 104 104 0 1 2147483645 Name of the Repository Owner. ---------------------------- REPOS_MANAGER The following privileges were granted to REPOS_MANAGER ----------------------------------------------------- DROP PUBLIC SYNONYM DROP ANY SYNONYM CREATE TABLE CREATE VIEW CREATE ANY SYNONYM UNLIMITED TABLESPACE CREATE PUBLIC SYNONYM CREATE SYNONYM CREATE PROCEDURE CREATE SEQUENCE The following Roles were granted to REPOS_MANAGER ------------------------------------------------ CK_ORACLE_REPOS_OWNER CONNECT RESOURCE SQL> alter user repos_manager identified by r3p0man; Benutzer wurde geõndert. SQL> grant execute on utl_file to repos_manager; Benutzerzugriff (Grant) wurde erteilt.