Home
All Oracle Error Codes
Oracle DBA Forum

Frequent Oracle Errors

TNS:could not resolve the connect identifier specified
Backtrace message unwound by exceptions
invalid identifier
PL/SQL compilation error
internal error
missing expression
table or view does not exist
end-of-file on communication channel
TNS:listener unknown in connect descriptor
insufficient privileges
PL/SQL: numeric or value error string
TNS:protocol adapter error
ORACLE not available
target host or object does not exist
invalid number
unable to allocate string bytes of shared memory
resource busy and acquire with NOWAIT specified
error occurred at recursive SQL level string
ORACLE initialization or shutdown in progress
archiver error. Connect internal only, until freed
snapshot too old
unable to extend temp segment by string in tablespace
Credential retrieval failed
missing or invalid option
invalid username/password; logon denied
unable to create INITIAL extent for segment
out of process memory when trying to allocate string bytes
shared memory realm does not exist
cannot insert NULL
TNS:unable to connect to destination
remote database not found ora-02019
exception encountered: core dump
inconsistent datatypes
no data found
TNS:operation timed out
PL/SQL: could not find program
existing state of packages has been discarded
maximum number of processes exceeded
error signaled in parallel query server
ORACLE instance terminated. Disconnection forced
TNS:packet writer failure
see ORA-12699
missing right parenthesis
name is already used by an existing object
cannot identify/lock data file
invalid file operation
quoted string not properly terminated

Re: Trying to run catproc.sql with no luck.

Juan Cachito Reyes Pacheco

2004-02-20

Replies:
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@(protected);
shutdown immediate;
connect SYS/change_on_install@(protected);
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@(protected)>
To: <oracle-l@(protected)>
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@(protected)
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@(protected)
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
-----------------------------------------------------------------