WikiOracle.es

errores_oracle:oracle_11i:pls:pls-00208

2012-02-03T07:32:33+01:00

PLS-00208: identifier 'string' is not a legal cursor attribute Cause: An identifier not declared as a cursor attribute was applied to an identifier declared as a cursor. For example, this error occurs if the cursor attribute is misspelled. Action: Check the spelling of the cursor attribute name. Make sure the attribute is one of these: %NOTFOUND, %FOUND, %ROWCOUNT, %ISOPEN.

backup:rman:rman_basico

2012-02-02T13:57:48+01:00

En este documento vamos a exponer diferentes aspectos, a la vez que varios ejemplos del uso de Rman para hacer los Backups de ORACLE Arrancar Rman rman target /@SID Opciones RMAN> LIST BACKUP OF DATABASE; Lista los backups de la BBDD disponibles RMAN> LIST COPY OF DATAFILE 1, 2, 3; Lista las copias disponibles de los datafiles 1, 2 y 3 RMAN> LIST BACKUP OF ARCHIVELOG FROM SEQUENCE Lista las copias de los archivelogs... RMAN> LIST CONTROLFILECOPY "/tmp/cf.cpy"; RMAN> …

errores_oracle:oracle_9i:pls:pls-00134

2012-02-02T09:00:18+01:00

PLS-00134 Pragma string expects 2nd argument to be an identifier or string-literal Cause: The second argument (actual parameter) passed to the named pragma (compiler directive) was not an identifier or string literal, as required. The parameter might be misspelled, or the pragma syntax might be faulty (for example, a comma might be missing between two parameters).

errores_oracle:oracle_11i:ora:ora-31206

2012-02-01T18:21:43+01:00

ORA-31206: DBMS_LDAP: PL/SQL - Invalid LDAP search scope. Cause: There has been an error in the DBMS_LDAP search operation. Action: Please check the search scope that you use for search, or report the error number and description to Oracle Support.

errores_oracle:oracle_9i:ora:ora-06017

2012-02-01T12:10:34+01:00

ORA-06017 NETASY: message receive failure Cause: Asynchronous driver gets I/O error while doing network read operation. Action: Check log file for operating system-specific error code and contact Oracle Support Services. ---------- * Busca Soluciones en - FORO Wikioracle

configuracion:instalacion_oracle10g - JgVkUpkFmSzExRny

2012-02-01T10:31:57+01:00

I found just what I was nedeed, and it was entertaining!

oracle_varios:iniciacion

2012-01-31T00:12:27+01:00

---------- Introducción a las bases de datos ¿Qué es una base de datos? Tipos de bases de datos Desde el punto de vista de la organización lógica: * Jerárquicas. (Progress) * Relacionales. (Oracle, Access, Sybase…) Desde el punto de vista de número de usuarios:

plsql:tipos_de_datos

2012-01-26T13:28:53+01:00

SQL ---------- Tipo de dato / Sintaxis Oracle 8i Oracle 9i Descripción dec(p, e) La precisión máxima es de 38 dígitos. Donde p es la precisión y e la escala. Por ejemplo: dec(3,1) es un número que tiene 2 dígitos antes del decimal y un dígito después del decimal.decimal(p, e) La precisión máxima es de 38 dígitos. Donde p es la precisión y e la escala. Por ejemplo: dec(3,1) es un número que tiene 2 dígitos antes del decimal y un dígito después del decimal.double precisionfloat La precisión má…

oracle_varios:flashback_recovery_area

2012-01-26T13:12:02+01:00

En una release 10gR2 y con las opciones de Flashback podemos hacer todo lo siguiente: Flashback Database: devuelve la Base de Datos a un estado previo sin necesidad de usar backups. Flashback Table: devuelve el contenido de una o más tablas a un punto del tiempo anterior. Flashback Drop: Deshace operaciones DROP TABLE. Flashback Query: Se usa para consultar (no restaura) el contenido de la base de datos en un momento anterior del tiempo. Flashback Version Query: Permite ver versiones anter…

errores_oracle:oracle_9i:ora:ora-01172

2012-01-18T11:42:31+01:00

ORA-01172 recovery of thread string stuck at block string of file string Cause: Crash recovery or instance recovery could not apply a change to a block because it was not the next change. This can happen if the block was corrupted and then repaired during recovery.

errores_oracle:oracle_11i:ora:ora-07280 - jGXykZvItyPhIiBlzE

2012-01-12T17:29:52+01:00

UdaKyQ ”>msnowyqwbnab

errores_oracle:oracle_9i:ora:ora-30035

2012-01-11T16:54:41+01:00

ORA-30035 Undo tablespace cannot be specified as default temporary tablespace Cause: Undo tablespace cannot be specified as default temporary tablespace for the database. Action: Check the tablespace name and reissue the command. ---------- * Busca Soluciones en - FORO Wikioracle

errores_oracle:oracle_9i:ora:ora-02293

2012-01-10T16:05:30+01:00

ORA-02293 cannot validate (string.string) - check constraint violated Cause: An attempt was made via an ALTERTABLE statement to add a check constraint to a populated table that had no complying values. Action: Retry the ALTER TABLE statement, specifying a check constraint on a table containing complying values. For more information about ALTER TABLE, see the Oracle9i SQL Reference.

errores_oracle:forms:forms6:frm-15001 - JNjRMnAsirmfcprtB

2012-01-10T06:56:38+01:00

Woah nelly, how about them alppes!

errores_oracle:oracle_11i:sql_loader:sql_loader-00640

2012-01-10T06:29:50+01:00

I had no idea how to aprpocah this before-now I'm locked and loaded.

errores_oracle:forms:forms6:frm-47017 - rMURWJPvKZIkxCb

2012-01-10T06:16:35+01:00

An answer from an expret! Thanks for contributing.

errores_oracle:forms:forms6:frm-41305 - BAehWAZJNUjByCunvoL

2012-01-10T06:12:01+01:00

This is what we need - an isnight to make everyone think

errores_oracle:forms:forms6:frm-47203

2012-01-10T05:16:54+01:00

FRM-47203: Cannot locate sound file %s. Cause: Form Builder was unable to find the file specified in READ_SOUND_FILE. Action: Check the file name and try again. Level: 99 Type: Error ---------- * Busca Soluciones en - FORO Wikioracle

errores_oracle:forms:forms6:frm-11600

2012-01-08T09:49:50+01:00

Yours is a clever way of tihnking about it.

errores_oracle:oracle_11i:rman:rman-12010

2012-01-08T02:35:01+01:00

RMAN-12010: automatic channel allocation initialization failed Cause: This message should be accompanied by other error message(s) indicating the cause of the error. Action: Check the accompanying errors. ---------- * Busca Soluciones en - FORO Wikioracle

errores_oracle:forms:forms6:frm-12501

2012-01-08T02:20:40+01:00

FRM-12501: Unable to store the current menus. Cause: Internal system error. Action: Contact your DBA or an Oracle support representative. ---------- * Busca Soluciones en - FORO Wikioracle ----------

errores_oracle:oracle_11i:ora:ora-28543

2012-01-08T02:15:47+01:00

ORA-28543: Error initializing apply connection to non-Oracle system Cause: Attempt to initialize connection to non-Oracle for heterogeneous replication failed. Action: Check if the listener used to connect to the gateway is up and is correctly configured. Make sure that the database link used has been configured correctly and, if a tnsnames alias has been used in the database link definition, make sure that the configuration of the entry in tnsnames.ora has been done correctly.

errores_oracle:forms:forms6:frm-11504

2012-01-08T00:51:07+01:00

FRM-11504: Trigger with this name already exists. Cause: You tried to define a trigger at the same definition level as an existing trigger of the same type. Action: None. ---------- * Busca Soluciones en - FORO Wikioracle ----------

errores_oracle:oracle_11i:ora:ora-19507 - qdRZebwa

2012-01-08T00:15:51+01:00

No more s***. All posts of this qaluity from now on

errores_oracle:oracle_9i:ora:ora-21526

2012-01-07T22:44:26+01:00

ORA-21526 initialization failed Cause: The initialization sequence failed. This can happen, for example, if an environment variable such as NLS_DATE_FORMAT is set to an invalid value. Action: Check that all NLS environment variables are well-formed.

errores_oracle:oracle_11i:oci:oci-22289

2012-01-07T22:41:48+01:00

OCI-22289: cannot perform string operation on an unopened file Cause: The file is not open for the required operation to be performed. Action: Check that the current operation is preceded by a successful file open operation. ---------- * Busca Soluciones en - FORO Wikioracle

errores_oracle:forms:forms6:frm-10751

2012-01-07T21:00:48+01:00

FRM-10751: At least one database column must be selected. Cause: At least one column must appear in the Database Items list of the field picker in order to leave this page of the wizard. Action: Move one or more columns from the Available Columns list to the Database Items list of the field picker.

backup:rman:duplicate

2012-01-07T13:40:33+01:00

Rman Duplicate El Duplicate es un facilidad que proporciona rman para duplicar completamente una BBDD desde las Versiones 9i en adelante. Esto es muy útil, si queremos automatizar una replicacion de nuestra BBDD contra otra para testing, reporting, etc. La replicacion se hace a traves de los backups de rman existentes, por lo que lo más usual en el caso de quere replicar una bbdd de forma periódica, es ejecutarlo justo después de los Backups.

errores_oracle:oracle_9i:nze:nze-28788

2012-01-07T13:10:43+01:00

NZE-28788 Invalid information provided by the user or unknown error Cause: Incorrect input by the user in response to a prompt or an unknown error. Action: Provide the correct input or enable tracing and check the trace file for errors. ---------- * Busca Soluciones en - FORO Wikioracle

errores_oracle:forms:forms6:frm-30179

2012-01-07T13:00:15+01:00

FRM-30179: Cannot find block %s Cause: The block name you specified does not exist. Action: Check the block name and try again. ---------- * Busca Soluciones en - FORO Wikioracle ----------

oracle_sql_scripts:bloqueos

2011-10-18T04:16:06+01:00

---------- SELECT NVL (b.username, 'SYS') username, session_id, lock_type, mode_held, mode_requested, lock_id1, lock_id2 FROM SYS.dba_lock_internal a, SYS.v_$session b WHERE a.session_id = b.SID AND lock_id2 in (SELECT lock_id2 Lock_addr FROM DBA_LOCK_INTERNAL WHERE mode_requested<>'None' AND mode_requested<>mode_held AND session_id IN ( SELECT sid FROM v$session_wait WHERE wait_time=0))

foro_wikioracle

chema comes — 2011-10-10T23:33:23+01:00

errores_oracle:oracle_9i:nno:nno-00159

2011-10-10T16:24:06+01:00

NNO-00159 warning: ignoring duplicate hint domain number name "string" Cause: The server's hint domain list contains a duplicate domain. The duplicate is ignored and the server continues running. This is an internal error, not normally visible to the user.

errores_oracle:oracle_11i:ora:ora-14016

2011-10-08T09:56:59+01:00

ORA-14016: underlying table of a LOCAL partitioned index must be partitioned Cause: User attempted to create a LOCAL partitioned index on a non-partitioned table which is illegal. Only GLOBAL indices (partitioned or otherwise) may be created on a non-partitioned table.

errores_oracle:oracle_11i:rman:rman-10024

2011-10-08T06:56:42+01:00

RMAN-10024: error setting up for rpc polling Cause: The Recovery Manager could not create the RPC polling context which is required to test for RPC completion. This message should be accompanied by other error message(s) indicating the cause of the error.

errores_oracle:oracle_8.1.7:ora:ora-09284

2011-10-08T06:13:23+01:00

ORA-09284 sllfop: cannot allocate read buffer Cause: MALLOC() system call returned an error. The system might have run out of heap space. Action: Check additional information for the operating system error. ---------- * Busca Soluciones en - FORO Wikioracle

errores_oracle:oracle_9i:img:img-00812

2011-10-08T04:00:52+01:00

IMG-00812 Merged area queue initialization failed Cause: Operating system process memory has been exhausted while initializing the merged area queue. Action: See the database administrator or operating system administrator to increase process memory quota.

errores_oracle:oracle_11i:sql_loader:sql_loader-00915

2011-10-05T19:02:35+01:00

SQL_Loader-00915: Error closing cursor: [number] Cause: Header message. Action: CCheck the message below this one in the log file for more information. ---------- * Busca Soluciones en - FORO Wikioracle ----------

errores_oracle:forms:forms6:frm-47007

2011-10-05T15:45:28+01:00

FRM-47007: Cannot get parameter %s attributes from Parameter List : invalid list ID. Cause: Specified an invalid parameter list ID. Action: Check the parameter list ID name and try again. Level: 99 Type: Error ---------- * Busca Soluciones en - FORO Wikioracle