This is strange, maybe this could be memory
I runned catproct.sql with this configuration (standard edition) and no
problem
replace xxx for the db_name
good luck
and following the creatin process of the database until the catproc.sql
script
DB_BLOCK_SIZE = 8192
COMPATIBLE = 9.2.0.1.0
DB_NAME = XXX
INSTANCE_NAME = XXX
REMOTE_LOGIN_PASSWORDFILE = SHARED
CURSOR_SPACE_FOR_TIME = FALSE # NO ELIMINA CURSORES EN SESION, No
Habilitar en Developer
#O7_DICTIONARY_ACCESSIBILITY=TRUE
###########################################
# CACHE AND I/O
###########################################
DB_CACHE_SIZE = 60M
DB_KEEP_CACHE_SIZE = 25M
DB_RECYCLE_CACHE_SIZE = 10M
DB_FILE_MULTIBLOCK_READ_COUNT = 16
# DB_CACHE_ADVICE = ON/READY/OFF # HABILITAR PARA OBTENER ESTADÍSTICAS DEL
USO DEL CACHE.
###########################################
# POOLS
###########################################
WORKAREA_SIZE_POLICY = AUTO
PGA_AGGREGATE_TARGET = 100M
#JAVA_POOL_SIZE
#JAVA_POOL_SIZE = 1000000 # SI NO UTILIZA JAVA
JAVA_POOL_SIZE = 33000000 # SI USA O SI SE ESTA INSTALANDO
LARGE_POOL_SIZE = 8000000
SHARED_POOL_SIZE = 50000000
# SHARED_POOL_RESERVED_SIZE = 10000000
# PRE_PAGE_SGA = TRUE # OPTIMIZA SI HAY MEMORIA PERMITE ALCANZAR PUNTO
OPTIMO MAS RAPIDO AUNQUE DESACELERA INICIALMENTE
# LOCK_SGA = TRUE # COLOCA TODO EL SGA EN MEMORIA, no funciona en NT
###########################################
# ARCHIVELOGFILES
###########################################
LOG_BUFFER = 1000000 # CANTIDAD DE DATOS QUE PUEDEN GENERARSE
DURANTE 9 SEGUNDOS SIN COMMIT O SAVEPOINT
LOG_ARCHIVE_START = TRUE
LOG_ARCHIVE_DEST = D:\XXXARCHLOG
LOG_CHECKPOINT_INTERVAL = 0
FAST_START_MTTR_TARGET = 300
###########################################
# CURSORS AND LIBRARY CACHE
###########################################
OPEN_CURSORS=800
SESSION_CACHED_CURSORS = 1000
###########################################
# UNDO MANAGEMENT
###########################################
UNDO_MANAGEMENT = AUTO
UNDO_TABLESPACE = TBL_UNDO
UNDO_RETENTION = 56000
###########################################
# DIAGNOSTICS AND STATISTICS
###########################################
BACKGROUND_DUMP_DEST = E:\ORAXXX\TRACE\BACKGROUND
USER_DUMP_DEST = E:\ORAXXX\TRACE\USER
CORE_DUMP_DEST = E:\ORAXXX\TRACE\CDUMP
###########################################
# FILE CONFIGURATION
###########################################
CONTROL_FILES = ("E:\ORAXXX\CONTROLFILES\CTL_XXX01.CTL",
"E:\ORAXXX\CONTROLFILES\CTL_XXX02.CTL",
"D:\ORAXXX\CONTROLFILES\CTL_XXX01.CTL",
"D:\ORAXXX\CONTROLFILES\CTL_XXX02.CTL")
READ_ONLY_OPEN_DELAYED = FALSE #TRUE, accede READONLY tablespaces solo al
leer datos ahi
DB_FILES=15
###########################################
# EXTERNAL FILES
###########################################
UTL_FILE_DIR = *
SESSION_MAX_OPEN_FILES = 30
###########################################
# NÚMERO MÁXIMO DE ROLES PERMITIDOS PARA BD
###########################################
MAX_ENABLED_ROLES = 70
LICENSE_MAX_USERS = 70
PROCESSES = 50 # 5 + (# USUARIOS CONCURRENTES*2
REPORT/DEVELOPER)
## SESSION = DERIVED (1.1 * PROCESSES + 5)
###########################################
# JOBS
###########################################
JOB_QUEUE_PROCESSES = 1
###########################################
# DISTRIBUTED
###########################################
OPEN_LINKS = 4
DB_DOMAIN = ""
REMOTE_DEPENDENCIES_MODE = SIGNATURE
###########################################
# PARA FUNCTION BASED INDEXES
###########################################
QUERY_REWRITE_ENABLED = TRUE
QUERY_REWRITE_INTEGRITY = ENFORCED
###########################################
# CBO
###########################################
optimizer_max_permutations=2500
OPTIMIZER_INDEX_COST_ADJ = 10 # Cambiar a 50 en datawarehousing
OPTIMIZER_INDEX_CACHING = 90 # No cambiar, posibilidad de encontrar
indice en cache
CURSOR_SHARING = EXACT # SIMILAR OR FORCE, quita performance, se
utilizan como auxiliar para mal binding
###########################################
# STATISTICS
###########################################
#TIMED_STATISTICS = TRUE
#STATISTICS_LEVEL = ALL
###########################################
# AUDIT
###########################################
AUDIT_SYS_OPERATIONS = TRUE
AUDIT_TRAIL = DB
- IMPORTANTE IMPORTANTE
- en tnsnames conexión debe estar configurada como dedicada, ver formulario
instalacion oracle 9i
- fin importante
SET ECHO ON
connect SYS/change_on_install_at_xxx as SYSDBA;
shutdown immediate;
connect SYS/change_on_install_at_xxx as SYSDBA;
startup nomount pfile=E:\oraxxx\init\initxxx.ora;
SPOOL D:\ORAxxx\CREDATA.LOG;
- PCTFREE 5 STORAGE ( INITIAL 64K NEXT 64K PCTINCREASE 0 MAXEXTENTS
UNLIMITED );
CREATE DATABASE xxx
CONTROLFILE REUSE
LOGFILE
GROUP 1 ('D:\oraxxx\logfiles\log_1xxx.ora',
'E:\oraxxx\logfiles\log_1xxx.ora') SIZE 10M,
GROUP 2 ('D:\oraxxx\logfiles\log_2xxx.ora',
'E:\oraxxx\logfiles\log_2xxx.ora') SIZE 10M
MAXLOGFILES 32
DATAFILE 'E:\oraxxx\datafiles\dfl_sys_xxx'
size 200M
REUSE AUTOEXTEND ON NEXT 640K MAXSIZE UNLIMITED
EXTENT MANAGEMENT LOCAL
DEFAULT TEMPORARY TABLESPACE TBL_TEMP TEMPFILE
'D:\oraxxx\datafiles\DFL_TEMP_xxx'
SIZE 50M
REUSE AUTOEXTEND ON NEXT 640K MAXSIZE UNLIMITED
EXTENT MANAGEMENT LOCAL UNIFORM SIZE 640K
UNDO TABLESPACE TBL_UNDO DATAFILE 'E:\oraxxx\datafiles\dfl_undo_xxx'
SIZE 50M
REUSE AUTOEXTEND ON NEXT 640K MAXSIZE UNLIMITED
MAXLOGHISTORY 1
MAXLOGFILES 3
MAXLOGMEMBERS 3
MAXDATAFILES 15
MAXINSTANCES 1
ARCHIVELOG
EXCLUSIVE
CHARACTER SET WE8ISO8859P1
NATIONAL CHARACTER SET AL16UTF16
;
- Tablespace usuario
CREATE TABLESPACE TBL_USERS DATAFILE 'E:\oraxxx\datafiles\DFL_USER_xxx'
SIZE 100M
REUSE AUTOEXTEND ON NEXT 640k MAXSIZE UNLIMITED
SEGMENT SPACE MANAGEMENT AUTO
EXTENT MANAGEMENT LOCAL UNIFORM SIZE 64K ;
CREATE TABLESPACE TBL_INDX DATAFILE 'D:\oraxxx\datafiles\DFL_INDX_xxx'
SIZE 100M
REUSE AUTOEXTEND ON NEXT 640k MAXSIZE UNLIMITED
SEGMENT SPACE MANAGEMENT AUTO
EXTENT MANAGEMENT LOCAL UNIFORM SIZE 64K ;
CREATE TABLESPACE TBL_OVERFLOW DATAFILE
'D:\oraxxx\datafiles\DFL_OVERFLOW_xxx'
SIZE 1M
REUSE AUTOEXTEND ON NEXT 640k MAXSIZE UNLIMITED
SEGMENT SPACE MANAGEMENT AUTO
EXTENT MANAGEMENT LOCAL UNIFORM SIZE 64K ;
CREATE TABLESPACE TBL_BLOB DATAFILE 'E:\oraxxx\datafiles\DFL_LOB_xxx'
size 1M
REUSE AUTOEXTEND ON NEXT 640k MAXSIZE UNLIMITED ;
CREATE TABLESPACE TBL_STATPACK DATAFILE
'E:\oraxxx\datafiles\DFL_STATPACK_xxx'
SIZE 100M
REUSE AUTOEXTEND ON NEXT 640k MAXSIZE UNLIMITED
SEGMENT SPACE MANAGEMENT AUTO
EXTENT MANAGEMENT LOCAL UNIFORM SIZE 64K ;
- Tablespace Read-Only
CREATE TABLESPACE TBL_readonly DATAFILE
'e:\OraxxxReadOnly\DFL_READONLY_xxx'
SIZE 100M
REUSE AUTOEXTEND ON NEXT 640k MAXSIZE UNLIMITED
SEGMENT SPACE MANAGEMENT AUTO
EXTENT MANAGEMENT LOCAL UNIFORM SIZE 64K ;
CREATE TABLESPACE TBL_readonly_IDX DATAFILE
'd:\OraxxxReadOnly\DFL_READONLY_IDX_xxx'
SIZE 100M
REUSE AUTOEXTEND ON NEXT 640k MAXSIZE UNLIMITED
SEGMENT SPACE MANAGEMENT AUTO
EXTENT MANAGEMENT LOCAL UNIFORM SIZE 64K ;
ALTER TABLESPACE "TBL_READONLY" READ ONLY;
ALTER TABLESPACE TBL_READONLY_idx READ ONLY;
- data files para paquetes adicionales
CREATE TABLESPACE TBL_DRSYS DATAFILE 'D:\oraxxx\datafiles\DFL_DRSYS_xxx'
SIZE 2M
REUSE AUTOEXTEND ON NEXT 640k MAXSIZE UNLIMITED
SEGMENT SPACE MANAGEMENT AUTO
EXTENT MANAGEMENT LOCAL UNIFORM SIZE 64K ;
CREATE TABLESPACE TBL_XDB DATAFILE 'D:\oraxxx\datafiles\DFL_XDB_xxx'
SIZE 2M
REUSE AUTOEXTEND ON NEXT 640k MAXSIZE UNLIMITED
SEGMENT SPACE MANAGEMENT AUTO
EXTENT MANAGEMENT LOCAL UNIFORM SIZE 64K ;
set echo off
@C:\oracle\ora92\rdbms\admin\catalog.sql;
alter system archive log all;
@C:\oracle\ora92\rdbms\admin\catblock.sql;
alter system archive log all;
@C:\oracle\ora92\rdbms\admin\catproc.sql;
@c:\oracle\ora92\rdbms\admin\catoctk.sql;
@c:\oracle\ora92\rdbms\admin\owminst.plb;
- Original Message -----
From: "Thomas Day" <tday6_at_csc.com>
To: <oracle-l_at_freelists.org>
Sent: Friday, February 20, 2004 3:57 PM
Subject: Trying to run catproc.sql with no luck.
Windows 2K, Oracle 9.2.
Any ideas gratefully accepted (except change operating system - that's not
within my scope).
SQL> DECLARE
2 vt sys.re$variable_type_list;
3 BEGIN
4 vt := sys.re$variable_type_list(
5 sys.re$variable_type('DML', 'SYS.LCR$_ROW_RECORD',
6 'SYS.DBMS_STREAMS_INTERNAL.ROW_VARIABLE_VALUE_FUNCTION',
7 'SYS.DBMS_STREAMS_INTERNAL.ROW_FAST_EVALUATION_FUNCTION'),
8 sys.re$variable_type('DDL', 'SYS.LCR$_DDL_RECORD',
9 'SYS.DBMS_STREAMS_INTERNAL.DDL_VARIABLE_VALUE_FUNCTION',
10 'SYS.DBMS_STREAMS_INTERNAL.DDL_FAST_EVALUATION_FUNCTION'));
11
12 dbms_rule_adm.create_evaluation_context(
13 evaluation_context_name=>'SYS.STREAMS$_EVALUATION_CONTEXT',
14 variable_types=>vt,
15 evaluation_function=>
16 'SYS.DBMS_STREAMS_INTERNAL.EVALUATION_CONTEXT_FUNCTION');
17 EXCEPTION WHEN OTHERS THEN
18 IF SQLCODE = -24145 THEN
19 -- suppress evaluation context already exists error to minimize
20 -- unwanted noise during upgrade.
21 NULL;
22 ELSE
23 RAISE;
24 END IF;
25 END;
26 /
PL/SQL procedure successfully completed.
SQL>
SQL> begin
2 dbms_rule_adm.grant_object_privilege(
3 privilege=>dbms_rule_adm.EXECUTE_ON_EVALUATION_CONTEXT,
4 object_name=>'SYS.STREAMS$_EVALUATION_CONTEXT',
5 grantee=>'PUBLIC', grant_option=>FALSE);
6 end;
7 /
begin
*
ERROR at line 1:
ORA-03113: end-of-file on communication channel
Please see the official ORACLE-L FAQ:
http://www.orafaq.com
To unsubscribe send email to: oracle-l-request_at_freelists.org
put 'unsubscribe' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request_at_freelists.org
put 'unsubscribe' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Received on Fri Feb 20 2004 - 16:51:11 CST