ORA-00600 lookup and debugging http://metalink.oracle.com/metalink/plsql/showdoc?db=NOT&id=153788.1 |
| oerr ora 1655 - on your host to have a quick error info |
| PLS-00103: Trovato il simbolo " " anziché uno dei seguenti: begin function package pragma procedure subtype type use <an identifier> <a double-quoted delimited-identifier> form current curso |
| Look the very last character of the line specified, there should be a blank character. Remove it. |
| ORA-00600: internal error code, arguments: [17285],
[0x503FA50], [2], [0x1C96F2D0], [], [], [], [] This occur when you are trying to recompile a package containing a pipelined function, but there is an opened cursor over that pipelined function |
RMAN
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of Duplicate Db command at 10/06/2005 14:33:40
RMAN-03015: error occurred in stored script Memory Script
ORA-19507: failed to retrieve sequential file, handle="dbaseFAL_PRO_1uh0ei1p", parms=""
ORA-27029: skgfrtrv: sbtrestore returned error
ORA-19511: Error received from media manager layer, error text:
nwora_open_restore: Could not locate the NWORA save file 'dbaseFAL_PRO_1uh0ei1p
' on server 'bk001bck.management.fw'.
----------------
Be sure to correctly set your Legato environment variables(run your environment set script)
Probably you are restoring or duplicating to a different client than the
backup owner.
Set variable NSR_CLIENT="source server backup owner"
example:
export NSR_CLIENT=db001srv
-------------------
Happened in the past the problem was not solved using the solution above, Legato administrator was contacted
unsuccessfully. The problem was appareantly solved by itself! Check dns resolution or other... |
RMAN RMAN-00571: =========================================================== RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== RMAN-00571: =========================================================== RMAN-03002: failure of restore command at 10/10/2005 16:01:54 ORA-19507: failed to retrieve sequential file, handle="dbaseSAS_7kh0n7m5", parms="" ORA-27029: skgfrtrv: sbtrestore returned error ORA-19511: Error received from media manager layer, error text: SBT error 0 in function sbtrestore - sbterror did not return error message ------------------- This is a permission issue - contact your Media Manager administrator |
create database p1 * ERROR at line 1: ORA-01092: ORACLE instance terminated. Disconnection forced ------------- Many reasons colud lead to this error, the most common is not to use password file: remote_login_passwordfile = none |
ORA-19511: Error received from media manager layer, error text: nwora_open_restore: Could not read the prologue. or RMAN-00571: =========================================================== RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== RMAN-00571: =========================================================== RMAN-03002: failure of Duplicate Db command at 12/28/2005 15:18:41 RMAN-03015: error occurred in stored script Memory Script ORA-19501: read error on file "dbaseFWDBPRO_sbh7dc89", blockno 3859457 (blocksize=512) ORA-27190: skgfrd: sbtread2 returned error ORA-19511: Error received from media manager layer, error text: nwora_read: read section error Tape is probably corrupt! Contact your media manager administrator |
db Db hung, all redo log active, they don't became inactive Mon Jan 16 13:05:31 2006 Thread 1 cannot allocate new log, sequence 2087 Checkpoint not complete Current log# 3 seq# 2086 mem# 0: /redo_ibis/IBIS_PRE/redo_A/redo03a.log Current log# 3 seq# 2086 mem# 1: /redo_ibis/IBIS_PRE/redo_B/redo03b.log ----------------------------------------------- Cause 1: fast_start_mttr_target=0 #default log_checkpoint_interval=10000 log_checkpoint_timeout=1800 #default Solution: #this may hung a little, but redo log begin became inactive SQL>alter system checkpoint; log_checkpoint_interval=10000 is too high, bring it to 0, default value fast_start_mttr_target=300 don't let it undefined ----------------------------------------------- |
db Wed Mar 28 02:27:53 2007 ARCH: Connecting to console port... Thread 1 cannot allocate new log, sequence 10 All online logs needed archiving Current log# 8 seq# 9 mem# 0: /NAS/DBCC63IN/redo/redo0801.rdo Current log# 8 seq# 9 mem# 1: /NAS/DBCC63IN/redo/redo0802.rdo --------- Your db in ARCHIVELOG is unable to archive redo logs, a drastic solution is to take db in NOARCHIVELOG: 1)- Shutdown abort 2)- Startup mount 3)- alter database NOARCHIVELOG; 4)- alter database open |
RMAN-00571: =========================================================== RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== RMAN-00571: =========================================================== RMAN-03002: failure during compilation of command RMAN-03013: command type: change RMAN-06004: ORACLE error from recovery catalog database: RMAN-20242: specification does not match any archivelog in the recovery catalog --------------- 1) check log_archive_dest_* in init.ora and... 2) check directory exists 3) correctly export ARCHDIR=/arch_p1/archive |
C:\temp>exp USERID="STRMADMIN"@RAI_PRE TABLES="PERFSTAT"."DBA_TABLESPACES_HIST" FILE=tables.dmp GRANTS=Y ROWS=Y LOG=exportTables.log OBJECT_CONSISTENT=Y INDEXES=Y Export: Release 10.2.0.1.0 - Production on Gio Mar 9 14:38:34 2006 Copyright (c) 1982, 2005, Oracle. All rights reserved. Password: EXP-00056: ORACLE error 6550 encountered ORA-06550: line 1, column 41: PLS-00302: component 'SET_NO_OUTLINES' must be declared ORA-06550: line 1, column 15: PL/SQL: Statement ignored EXP-00000: Export terminated unsuccessfully --- use exp for 9i |
RMAN-00571: =========================================================== RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== RMAN-00571: =========================================================== RMAN-03009: failure of allocate command on t1 channel at 05/03/2006 17:15:57 ORA-19554: error allocating device, device type: SBT_TAPE, device name: ORA-27211: Failed to load Media Management Library Additional information: 2 Media library is not present. Possible scenario: - Duplicating from source to target, target is missing media library, did you create the link? Please refer to Legato for correct configuration Verify bit version, if oracle runs in 32 bit, then the library must be the same bit version Use: file oracle file /usr/lib/libnwora.so 'allocate auxiliary channel' may work but 'allocate channel' not |
ORA-09925: Unable to create audit trail file SVR4 Error: 2: No such file or directory Additional information: 9925 check value of audit_file_dest parameter is a valid folder |
RMAN-00571: =========================================================== RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== RMAN-00571: =========================================================== RMAN-03002: failure of Duplicate Db command at 05/03/2006 17:20:56 RMAN-03015: error occurred in stored script Memory Script ORA-19507: failed to retrieve sequential file, handle="dbaseRAI_PRO_46hi2krn", parms="" ORA-27029: skgfrtrv: sbtrestore returned error ORA-19511: Error received from media manager layer, error text: nwora_open_restore: The NW authentication for client 'db405ops' was refused by server 'bk001bck' because 'client `db405ops.be.intranet.fw' is not properly con figured on the NetWorker Server'. The host above is not authenticated. Contact your Legato administrator. |
RMAN-00571: =========================================================== RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== RMAN-00571: =========================================================== RMAN-03002: failure of Duplicate Db command at 05/05/2006 11:37:25 RMAN-05501: aborting duplication of target database RMAN-05001: auxiliary filename /ora01_fag/FAG_PRO/data/fag_lob_tbs_01.dbf conflicts with a file used by the target database Is there that filesystem in destination db? Can you make a 'touch' of that file? Check log_file_name convert, db_file_name_convert in init.ora |
rman
RMAN-00571:
===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 05/09/2006 14:32:49
ORA-19507: failed to retrieve sequential file, handle="dbaseRTM_PRO_03hil27c", parms=""
ORA-27029: skgfrtrv: sbtrestore returned error
ORA-19511: Error received from media manager layer, error text:
nwora_open_restore: A connection to NW server 'bacco.management.fw' could not be established because
'Remote system error'.
------
The host name highligthed above is not correct |
SQL> alter database open; alter database open * ERROR at line 1: ORA-01190: controlfile or data file 1 is from before the last RESETLOGS ORA-01110: data file 1: '/dev/vx/rdsk/oradg/rawdev_100M_003' Database needs recover. You probably did a restore but not recovered yet. |
RMAN-00571: =========================================================== RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== RMAN-00571: =========================================================== RMAN-03002: failure of set command at 05/12/2006 15:14:21 RMAN-06004: ORACLE error from recovery catalog database: RMAN-20003: target database incarnation not found in recovery catalog Are you performing a point in time restore? This error occurs when you issue the 'recover' command and the controlfile is too recent. You have not probably followed the right sequence to restore a database: - Restore controlfiles (you have probably skipped this step) - Restore database - Recover database Have you opened your database using resetlogs? register the new incarnation using: RMAN> reset database; |
RMAN-00571: =========================================================== RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== RMAN-00571: =========================================================== RMAN-03009: failure of backup command on t1 channel at 06/01/2006 15:31:29 ORA-19506: failed to create sequential file, name="dbaseDMS_PRE_01hkhrmg", parms="" ORA-27028: skgfqcre: sbtbackup returned error ORA-19511: Error received from media manager layer, error text: nwora_open_backup: The NW authentication for client 'db901dms' was refused by s erver 'bk001bck.management.fw' because 'User oracle on computer db039ops is not on db901dms's remote access list'. Tell your backup administrator the real hostname (db039ops) |
RMAN-00571: =========================================================== RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== RMAN-00571: =========================================================== RMAN-03009: failure of backup command on t1 channel at 06/05/2006 14:27:16 ORA-19506: failed to create sequential file, name="dbaseTSTARCH_01hks9dl", parms="" ORA-27028: skgfqcre: sbtbackup returned error ORA-19511: Error received from media manager layer, error text: nwora_open_backup: unable to start save session with server bk001bck.management.fw: The feature "NetWorker Module for SAP R/3 on Oracle, UNIX Client/1" is not properly enabled for client co002dba. Contact you backup administrator, Oracle module, nwora library is not installed on client host |
rman
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of recover command at 06/06/2006 11:57:24
RMAN-06053: unable to perform media recovery because of missing log
RMAN-06102: no channel to restore a backup or copy of log thread 1 seq 32 scn 89827
RMAN-06102: no channel to restore a backup or copy of log thread 1 seq 31 scn 89824
RMAN-06102: no channel to restore a backup or copy of log thread 1 seq 30 scn 89821
RMAN-06102: no channel to restore a backup or copy of log thread 1 seq 29 scn 89817
RMAN-06102: no channel to restore a backup or copy of log thread 1 seq 28 scn 89813
RMAN-06102: no channel to restore a backup or copy of log thread 1 seq 27 scn 69196
Specified archive log not found over allocated channels.
Where are those backed up archives?
RMAN> list backup of archivelog from logseq 27;
List of Backup Sets
===================
BS Key Size Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ ------------------
184 266K DISK 00:00:08 06-JUN-06 11:13:44
BP Key: 185 Status: AVAILABLE Tag: TAG20060606T111336
Piece Name: /NAS/test_saved_archive/arch_TSTARCH_0ehkuif0
List of Archived Logs in backup set 184
Thrd Seq Low SCN Low Time Next SCN Next Time
---- ------- ---------- ------------------ ---------- ---------
1 27 69196 05-JUN-06 18:08:29 89813 06-JUN-06 11:11:44
1 28 89813 06-JUN-06 11:11:44 89817 06-JUN-06 11:11:50
1 29 89817 06-JUN-06 11:11:50 89821 06-JUN-06 11:11:53
1 30 89821 06-JUN-06 11:11:53 89824 06-JUN-06 11:11:56
1 31 89824 06-JUN-06 11:11:56 89827 06-JUN-06 11:11:59
1 32 89827 06-JUN-06 11:11:59 89863 06-JUN-06 11:13:32
1 33 89863 06-JUN-06 11:13:32 89868 06-JUN-06 11:13:35
As you can see the backup piece needed is on disk, be sure to have this in your script:
allocate channel t4 type disk;
|
Oracle databasealter database open Tue Jun 6 14:47:19 2006 LGWR: Primary database is in CLUSTER CONSISTENT mode LGWR: Primary database is in MAXIMUM PROTECTION mode LGWR: Destination LOG_ARCHIVE_DEST_1 is not serviced by LGWR LNS0 started with pid=12 Tue Jun 6 14:47:23 2006 LGWR: Error 16086 verifying archivelog destination LOG_ARCHIVE_DEST_2 LGWR: Continuing... Tue Jun 6 14:47:23 2006 Errors in file /tmp/tstarch_lgwr_9049.trc: ORA-16086: standby database does not contain available standby log files LGWR: Error 16086 disconnecting from destination LOG_ARCHIVE_DEST_2 standby host 'TST_STB' LGWR: Minimum of 1 applicable standby database required Tue Jun 6 14:47:23 2006 Errors in file /tmp/tstarch_lgwr_9049.trc: ORA-16072: a minimum of one standby database destination is required LGWR: terminating instance due to error 16072 Instance terminated by LGWR, pid = 9049 *** SESSION ID:(3.1) 2006-06-06 14:47:19.714
Destination LOG_ARCHIVE_DEST_1 is not serviced by LGWR
*** 2006-06-06 14:47:19.742 43184 kcrr.c
Initializing NetServer for dest=TST_STB
Initializing PGA storage for Netserver communication
Allocating a brand new NetServer
Allocated NetServer 0
Starting NetServer
NetServer 0 has been started.Subscribing to KSR Channel 0
success!
Indicating recv buffer for KSR Channel 0
success
Waiting for Netserver 0 to initialize itself
*** 2006-06-06 14:47:22.941 43464 kcrr.c
Netserver 0 has been initialized
LGWR performing a channel reset to ignore previous responses
LGWR connecting as publisher to KSR Channel 0
LGWR-NS 0 initialized for destination=TST_STB
*** 2006-06-06 14:47:22.941 43918 kcrr.c
Making upiahm request to NetServer 0
Waiting for NetServer to respond to upiahm
*** 2006-06-06 14:47:23.100 44104 kcrr.c
upiahm connect done status is 0
Receiving message from NetServer 0
LGWR: Failed
rfsp: 0x2ec5188
rfsmod: 1
.......
rfxslfact:0
Error 16086 attaching RFS server to standby instance at host 'TST_STB'
*** 2006-06-06 14:47:23.180
LGWR: Error 16086 verifying archivelog destination LOG_ARCHIVE_DEST_2
Continuing...
ORA-16086: standby database does not contain available standby log files
*** 2006-06-06 14:47:23.185 45009 kcrr.c
Making upidhs request to NetServer 0 (hst 0xffbee074)
NetServer pid:9065
*** 2006-06-06 14:47:23.185 45233 kcrr.c
upidhs done status 16086
*** 2006-06-06 14:47:23.186
LGWR: Error 16086 disconnecting from destination LOG_ARCHIVE_DEST_2 standby host 'TST_STB'
Ignoring kcrrlvna() detach error 16086
Standby database verification failed:16072
error 16072 detected in background process
ORA-16072: a minimum of one standby database destination is requiredAre you working with standby databases?
Please go to the standby instance and issue:
ALTER DATABASE ADD STANDBY LOGFILE('/opt/ora9/oradata/p2/standby_log/STANDBY_REDO_1')size 10M;
Be sure to add one more standby logfile than the primary with same size
|
Enterprise Manager Agent - installation
agentDownload.hpi invoked on Thu Sep 7 14:44:14 ADT 2006 with Arguments "-b /u01/app/oracle/product"
Platform=HP-UX, OS=hpi
GetPlatform:returned=0, and os is set to: hpi, platform=HP-UX
LogFile for this Download can be found at: "/u01/app/oracle/product/agentDownload10.2.0.1.0Oui/agentDownload.hpi090706144414.log"
Running on Selected Platform: HP-UX
Installer location: /u01/app/oracle/product/agentDownload10.2.0.1.0Oui
Downloading Agent install response file ...
http://%s_OMSHost%:%s_OMSPort%/agent_download/10.2.0.1.0/agent_download.rsp: Bad port number.
Finished Downloading with Status=1
Command failed: /usr/local/bin/wget --dot-style=mega --verbose --tries=5 http://%s_OMSHost%:%s_OMSPort%/agent_download/10.2.0.1.0/agent_download.rsp
Removing the copied stuff.....
Log name of installation can be found at: "/u01/app/oracle/product/9.2.0/agentDownload.hpi090706144414.log"
--------------
probably generated by:
$> ./agentDownload.hpi -b /u01/app/oracle/product
edit agentDownload.hpi and substitute the above bold variables
|
Database Sun Oct 8 21:09:09 2006 ARC1: Media recovery disabled ----- Archiver process is active but database is in NOARCHIVELOG. Stop the archiver using ALTER SYSTEM ARCHIVE LOG stop; |
Enterprise Manager opmn/bin/opmnctl startproc ias-component=OC4J opmnctl: starting opmn managed processes... ================================================================================ opmn id=co001dba:6200 0 of 1 processes started. ias-instance id=EnterpriseManager0.co001dba ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ ias-component/process-type/process-set: OC4J/OC4J_EM/default_island Error --> Process (pid=15963) time out while waiting for a managed process to start Log: /app/oracle/product/10.2.0/oms10g/opmn/logs/OC4J~OC4J_EM~default_island~1 [Log] -------- 06/10/10 18:47:55 Start process -------- 06/10/10 18:48:08 Warning: Error reading transaction-log file (/app/oracle/product/10.2.0/oms10g/j2ee/OC4J_EM/persistence/OC4J_EM_ default_island_1/transaction.state) for recovery: premature end of file 06/10/10 18:48:08 Forced or abrupt (crash etc) server shutdown detected, starting recovery process... 06/10/10 18:48:08 Recovery completed, 0 connections committed and 0 rolled back... Oct 10, 2006 6:48:11 PM org.apache.struts.util.PropertyMessageResources |
Pl/Sql ORA-00942: table or view does not exist ORA-06512: at "SYS.DBMS_SYS_SQL", line 826 ORA-06512: at "SYS.DBMS_SQL", line 39 ORA-06512: at "ALWORKSHOP.GESTIONETABELLE", line 35 ORA-06512: at line 7 ---- Are you using DBMS_SQL.PARSE(source_cursor, query, DBMS_SQL.native) from a Pl/Sql block? Does it work from other then a Pl/Sql block? The procedure owner have to be granted to select from query table directly but not through role. This seems more to be a bug... grant select on <query table> to <procedure owner> |
rman RMAN-00571: =========================================================== RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== RMAN-00571: =========================================================== RMAN-03002: failure of restore command at 10/18/2006 18:05:20 RMAN-06026: some targets not found - aborting restore RMAN-06023: no backup or copy of datafile 3 found to restore RMAN-06023: no backup or copy of datafile 2 found to restore RMAN-06023: no backup or copy of datafile 1 found to restore ---- Check your 'set until' clause, remember that can be removed. |
Oracle Database ERROR at line 1: ORA-01113: file 1 needs media recovery ORA-01110: data file 1: '/NAS/test_saved_archive/admin/TSTARCH/data/system_01.dbf' ----- SQL> recover datafile 1; or Use this init parameter _allow_resetlogs_corruption=true |
Oracle Database Wed Oct 25 15:55:51 2006 Errors in file /NAS/test_saved_archive/admin/TSTARCH/bdump/tstarch_ckpt_9957.trc: ORA-01242: data file suffered media failure: database in NOARCHIVELOG mode ORA-01122: database file 1 failed verification check ORA-01110: data file 1: '/NAS/test_saved_archive/admin/TSTARCH/data/system_01.dbf' ORA-01251: Unknown File Header Version read for file number 1 ------------ sum dba 1,1 apply Sorry, I'cant say more than this.... |
Oracle Database SQL> alter database open; alter database open * ERROR at line 1: ORA-00313: open failed for members of log group 1 of thread 1 ORA-00312: online log 1 thread 1: '/NAS/test_saved_archive/admin/TSTARCH/data/redo01a.rdo' ORA-27037: unable to obtain file status SVR4 Error: 2: No such file or directory Additional information: 3 ---------- Are redo logs gone? You need to recreate the controlfile using the RESETLOGS option SQL> alter database backup controlfile to trace; |
Oracle Database
SQL> alter database open resetlogs;
alter database open resetlogs
*
ERROR at line 1:
ORA-01194: file 1 needs more recovery to be consistent
ORA-01110: data file 1:
'/NAS/test_saved_archive/admin/TSTARCH/data/system_01.dbf'
SQL> recover datafile 1;
ORA-00283: recovery session canceled due to errors
ORA-01610: recovery using the BACKUP CONTROLFILE option must be done
SQL> recover database using backup controlfile;
ORA-00279: change 68159 generated at 10/25/2006 16:03:30 needed for thread 1
ORA-00289: suggestion : /tmp/arch_TST0000000005.log
ORA-00280: change 68159 for thread 1 is in sequence #5
Specify log: { |
Oracle database ORA-12505, TNS:listener does not currently know of SID given in connect descriptor --- set init parameter: local_listener='(ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.13) (PORT = 1521)))' alter system register; |
Oracle databaseORA-01031: insufficient privileges
------
1) From create materialized view:
11:15:59 SQL> create materialized view PPP.dwh_budgetcentre
11:15:59 2 nocache
11:15:59 3 noparallel
11:15:59 4 build deferred
11:15:59 5 refresh fast
11:15:59 6 on demand
11:15:59 7 with rowid
11:15:59 8 using default local rollback segment for update
11:15:59 9 disable query rewrite as select
11:15:59 10 account_num,
11:15:59 11 budget_centre_seq,
11:15:59 12 budget_centre_name,
11:15:59 13 parent_budget_centre_seq,
11:15:59 14 start_dat,
11:15:59 15 end_dat,
11:15:59 16 budget_centre_name_upper
11:15:59 17 from geneva_admin.budgetcentre;
from geneva_admin.budgetcentre
*
ERROR at line 17:
ORA-12018: following error encountered during code generation for
"DWH_USER"."DWH_BUDGETCENTRE"
ORA-01031: insufficient privileges
--------------
--User needs grant on materialized view log
grant select, insert, update, delete on geneva_admin.mlog$_budgetcentre to dwh_user;
-grant GLOBAL QUERY REWRITE to PPP
see http://www.lazydba.com/oracle/0__36187.html
Debug using How to trace |
Oracle database Thu Dec 7 17:33:04 2006 Errors in file /app/oracle/admin/SBLLAPRO/udump/sbllapro_ora_29160.trc: ORA-01114: IO error writing block to file 201 (block # 445449) ORA-27063: skgfospo: number of bytes read/written is incorrect SVR4 Error: 28: No space left on device Additional information: -1 Additional information: 57344 ----- I received this error having a 100% full file system. I freed some space (to 98%) (rebuilding TOOLS tablespace to another fs), and the problem was solved |
RMAN RMAN-00571: =========================================================== RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== RMAN-00571: =========================================================== RMAN-03009: failure of backup command on t1 channel at 12/11/2006 12:21:40 ORA-19506: failed to create sequential file, name="dbaseEPL_PRO_4ai4ma2j", parms="" ORA-27028: skgfqcre: sbtbackup returned error ORA-19511: Error received from media manager layer, error text: nwora_open_backup: The NW authentication for client 'db801epl' was refused by s erver 'bk801bck' because 'User oracle on computer db033ops is not on db801epl's remote access list'. --------- Contact your backup administrator, he is able to solve this issue. |
RMAN RMAN-00571: =========================================================== RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== RMAN-00571: =========================================================== RMAN-03009: failure of backup command on t1 channel at 12/11/2006 12:15:09 ORA-19506: failed to create sequential file, name="dbaseEPL_PRO_47i4m9md", parms="" ORA-27028: skgfqcre: sbtbackup returned error ORA-19511: Error received from media manager layer, error text: nwora_open_backup: A connection to NW server 'bk001bck.management.fw' could not be established because 'Program not registered'. ------- I received this error when I set an incorrect server address. |
rman RMAN-00571: =========================================================== RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== RMAN-00571: =========================================================== RMAN-03009: failure of resync command on default channel at 02/09/2007 10:45:37 ORA-01580: error creating control backup file /app/oracle/product/8.1.7/dbs/snapcf_DC_PRO.f ORA-27040: skgfrcre: create error, unable to create file SVR4 Error: 2: No such file or directory --------------------- The backup controlfile location is not correct RMAN> show all; ... CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/app/oracle/product/8.1.7/dbs/snapcf_DC_PRO.f'; RMAN> CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/app/oracle/product/9.2.0/dbs/snapcf_DC_PRO.f'; snapshot controlfile name set to: /app/oracle/product/9.2.0/dbs/snapcf_DC_PRO.f new RMAN configuration parameters are successfully stored |
Oracle database
SQL*Plus: Release 9.2.0.6.0 - Production on Fri Feb 16 10:50:39 2007
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
ERROR:
ORA-12705: invalid or unknown NLS parameter value specified
--------------
solution 1)
I had to unset ORA_NLS33 environment variable value
Oracle software version is 9.2.0.7 and ORA_NLS33 previous value was:
ORA_NLS33=/app/oracle/product/9.2.0/ocommon/nls/admin/data
solution 2)
Your NLS_LANGUAGE environment variable is not correctly set.
Please set it to AMERICAN_AMERICA.US7ASCII, the default
If use .oraprofile please modify it
Experience says this may happen when running sqlplus on uncorrectly migrated software in conjunction with multiple Oracle homes
|
OPATCH
$ opatch lsinventory
PERL5LIB=; export PERL5LIB
/usr/contrib/bin/perl ./opatch.pl lsinventory
Can't locate English.pm in @INC (@INC contains: /opt/perl5/lib/5.00502/PA-RISC1.1 /opt/perl5/lib/5.00502 /opt/perl5/lib/site_perl/5.005/PA-RISC1.1 /opt/perl5/lib/site_perl/5.005 .) at ./opatch.pl line 68.
BEGIN failed--compilation aborted at ./opatch.pl line 68.
------
I used a wrong perl version.
1) check current perl in use:
$ which perl
/usr/contrib/bin/perl
2) Find a perl version containg English.pm
(su -)
$ find / -name English.pm
3) Set the correct version
export PATH=/opt/perl64/bin:$PATH
4) Verify:
$ which perl
/opt/perl64/bin/perl
|
db ORA-23421: job number 249 is not a job in the job queue ORA-06512: at "SYS.DBMS_SYS_ERROR", line 86 ORA-06512: at "SYS.DBMS_IJOB", line 529 ORA-06512: at "SYS.DBMS_JOB", line 245 ORA-06512: at line 1 ---- You are not connected as the job owner |
Standby Thu Mar 29 21:31:18 2007 ARC1: Evaluating archive log 1 thread 1 sequence 43117 ARC1: Beginning to archive log 1 thread 1 sequence 43117 Creating archive destination LOG_ARCHIVE_DEST_2: 'acsprod_dhdbhq05' Creating archive destination LOG_ARCHIVE_DEST_1: '/app/oracle/admin/ACSPROD/oradata/archive/arch_ACSPROD_0000043117.log' ARC1: I/O error 272 archiving log 1 to 'acsprod_dhdbhq05' Thu Mar 29 21:31:21 2007 Errors in file /app/oracle/admin/ACSPROD/bdump/acsprod_arc1_19881.trc: ORA-00272: error writing archive log ARC1: Error 270 Closing archive log file 'acsprod_dhdbhq05' Thu Mar 29 21:31:21 2007 Errors in file /app/oracle/admin/ACSPROD/bdump/acsprod_arc1_19881.trc: ORA-00270: error creating archive log ARC1: Completed archiving log 1 thread 1 sequence 43117 Thu Mar 29 21:33:14 2007 ARC0: Begin FAL archive (thread 1 sequence 43117 destination acsprod_dhdbhq05) Creating archive destination LOG_ARCHIVE_DEST_2: 'acsprod_dhdbhq05' Thu Mar 29 21:33:17 2007 Errors in file /app/oracle/admin/ACSPROD/bdump/acsprod_arc0_19879.trc: ORA-00272: error writing archive log ARC0: FAL archive failed, see trace file. ARCH: FAL archive failed. Archiver continuing Thu Mar 29 21:33:17 2007 ORACLE Instance ACSPROD - Archival Error. Archiver continuing. ARCH: Connecting to console port... Thu Mar 29 21:33:17 2007 ORA-16055: FAL request rejected ARCH: Connecting to console port... Thu Mar 29 21:33:17 2007 Errors in file /app/oracle/admin/ACSPROD/bdump/acsprod_arc0_19879.trc: ----- Primary system is archiving log 43117, but fails on 'acsprod_dhdbhq05' (destination 2 remote) 1)standby: check for log 43117 on log_archive_dest (is there free space there?) |
rman RMAN-00571: =========================================================== RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== RMAN-00571: =========================================================== RMAN-03002: failure of Duplicate Db command at 04/06/2007 00:14:13 RMAN-03015: error occurred in stored script Memory Script ORA-19504: failed to create file "/ora02_rla/RLA_INT/data/TOOLS.dbf" ORA-27086: skgfglk: unable to lock file - already in use SVR4 Error: 11: Resource temporarily unavailable Additional information: 8 --------- A file already exists, even if its not in use because the instance you are restoring is in nomount state. Add 'nofilenamecheck' to your script to overwrite the file |
rman MAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== RMAN-00571: =========================================================== RMAN-00601: fatal error in recovery manager RMAN-03004: fatal error during execution of command RMAN-10039: error encountered while polling for RPC completion on channel clone_default RMAN-10006: error running SQL statement: select act from x$ksusex where sid=:1 and serial=:2 RMAN-10002: ORACLE error: ORA-03113: end-of-file on communication channel RMAN-03002: failure of Duplicate Db command at 04/06/2007 00:51:29 RMAN-03015: error occurred in stored script Memory Script RMAN-06136: ORACLE error from auxiliary database: ORA-01092: ORACLE instance terminated. Disconnection forced:1q ---- This is a generic error. Go to see alert.log I personally encountered this error when duplicating, but the undo_tablespace parameter was different between source and target instance. If you are duplicating, check that target instance parameter are compatible with source parameter |
db ORA-30012: undo tablespace 'UNDOTBS' does not exist or of wrong type --- is your undo_tablespace parameter correct in init.ora? |
db [1] + Segmentation Fault(coredump) [a big binary core file is generated] ----- This is a generic error. Check your ORACLE_HOME environment setting I encountered this when operating with a different software then the istance, that's because the instance version was 9.2.0.7 and my ORACLE_HOME referred to a 9.2.0 software |
db
SQL> CREATE CONTROLFILE REUSE SET DATABASE "mpc_int" RESETLOGS ARCHIVELOG
2 MAXLOGFILES 20
3 MAXLOGMEMBERS 5
4 MAXDATAFILES 500
5 MAXINSTANCES 2
6 MAXLOGHISTORY 1361
7 LOGFILE
8 GROUP 1 ( '/redo_mpc/redo_a/redo010a.rdo', '/redo_mpc/redo_b/redo010b.rdo' ) SIZE 104857600 REUSE,
9 GROUP 2 ( '/redo_mpc/redo_a/redo020a.rdo', '/redo_mpc/redo_b/redo020b.rdo' ) SIZE 104857600 REUSE,
10 GROUP 3 ( '/redo_mpc/redo_a/redo030a.rdo', '/redo_mpc/redo_b/redo030b.rdo' ) SIZE 104857600 REUSE,
11 GROUP 4 ( '/redo_mpc/redo_a/redo040a.rdo', '/redo_mpc/redo_b/redo040b.rdo' ) SIZE 104857600 REUSE,
12 GROUP 5 ( '/redo_mpc/redo_a/redo050a.rdo', '/redo_mpc/redo_b/redo050b.rdo' ) SIZE 104857600 REUSE
13 DATAFILE
14 '/ora01_mpc/MPC_INT/system/system01.dbf'
15 CHARACTER SET UTF8;
CHARACTER SET UTF8
*
ERROR at line 15:
ORA-12710: CREATE CONTROLFILE character set is not known
---------
The instance must be started using NLS_LANG=AMERICAN_AMERICA.UTF8, exit sqlplus and restart the instance.
|
rman RMAN-00571: =========================================================== RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== RMAN-00571: =========================================================== RMAN-03002: failure of recover command at 04/10/2007 00:15:27 RMAN-06094: datafile 1 must be restored ---- A RECOVER command was issued, and the recovery catalog indicates the specified datafile should be part of the recovery, but this datafile is not listed in the control file, and cannot be found on disk. 1)Possible scenario: you issued a datafile/s restore using "set newname", but the controlfile has not that path for the datafile. Rename the file in the controlfile. |
db ORA-04045: errors during recompilation/revalidation of ARADMIN.NO_TT_TRANS ORA-00942: table or view does not exist ORA-06512: at "SYS.DBMS_SNAPSHOT", line 803 ORA-06512: at "SYS.DBMS_SNAPSHOT", line 860 ORA-06512: at "SYS.DBMS_IREFRESH", line 683 ORA-06512: at "SYS.DBMS_REFRESH", line 195 ORA-06512: at line 2 ------- http://forums.oracle.com/forums/thread.jspa?messageID=1779564 1) I received this error also when refreshing complete a materialized view, that means not using any log. I resolved the error by dropping and recreating the materialized view. This is quite misterious. 2) It's look that you have problem with reading from materialized view log on master site. Check if mlog for you master table on master site exists. If you have changed master table you maybe must drop and create mlog on master site. |
rman legato (pid = 14375) (date = 04/08/07 14:43:01) lnm_index_cfx_start: Exiting. (pid = 14375) (date = 04/08/07 14:43:01) lnm_index_cfx_connect: Exiting. (pid = 14375) (date = 04/08/07 14:43:01) lnm_index_cfx_lookup: Exiting with an error. -------- My legato administrator say that legato indexes are no more functioning (when going from disk to tape). I don't know wether this is a good explanation, anyway try a more recent date from your rman script |
import IMP-00032: SQL statement exceeded buffer length IMP-00032: SQL statement exceeded buffer length IMP-00008: unrecognized statement in the export file: 95 INITRANS 1 MAXTRANS 255 STORAGE( FREELIST --- Increase or set buffer parameter, this solved the problem for me: buffer=1048576 |
db Mon Apr 16 17:34:05 2007 Errors in file /app/oracle/admin/VITRIA/udump/vitria_ora_8808.trc: ORA-00600: internal error code, arguments: [17069], [0xD1DC65D0], [], [], [], [], [], [] ---- alter system flush shared_pool; the invalid package in my case was in the 'KEEP' pool Clearing the shared pool removes keeped object from the shared pool |
db ORA-00600: internal error code, arguments: [729], [4776], [space leak], [], [], [], [], [] ------ A space leak has been detected in the User Global Area (UGA). There is NO data corruption as a result of this error. It is an internal memory housekeeping problem. PROCESS FAILURE - But only during logoff so impact is minimal. NON CORRUPTIVE - No underlying data corruption. Set the following in init.ora for example to disable space leaks less than 4000 bytes: event = "10262 trace name context forever, level 4000" ---- MTS shared server may lead to this problem. See metalink note 31056.1 |
db ORA-00059 Sun Apr 29 22:57:07 2007 DB_FILES[8] exceeded (fno=231 kcfdpk=230)ORA-59 signalled during: /* OracleOEM */ ALTER TABLESPACE "SNAPLOGS" ADD DA... ...... Increase db_files init parameter Check MAXDATAFILES value in controlfile, adeguate it to db_files |
db - rman database opened Finished Duplicate Db at 03-MAY-07 23:44:28 RMAN-00571: =========================================================== RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== RMAN-00571: =========================================================== ORA-03127: no new operations allowed until the active operation ends RMAN-12005: error during channel cleanup ORA-06544: PL/SQL: internal error, arguments: [56319], [], [], [], [], [], [], [] ORA-06553: PLS-801: internal error [56319] ----------- Here I duplicated a 32 bit version database to a 64 bit version database. Check versions: >cd $ORACLE_HOME/bin >file oracle How to install, patch and interim |
db ORA-01779: cannot modify a column which maps to a non key-preserved table --- This happened to me when inserting in a view. This is a view condition: ... and ora_login.id_user(+)=ora_users.id ... Create a unique index for ora_login.id_user |
db install
Start output from spawned process:
----------------------------------
(if [ "compile" = "compile" ] ; then \
/app/oracle/product/9.2.0/bin/gennttab > ntcontab.c ;\
/usr/bin/gcc -c ntcontab.c ;\
rm -f /app/oracle/product/9.2.0/lib/ntcontab.o ;\
mv ntcontab.o /app/oracle/product/9.2.0/lib/ ;\
/usr/bin/ar rv /app/oracle/product/9.2.0/lib/libn9.a /app/oracle/product/9.2.0/lib/ntcontab.o ; fi)
/bin/sh: line 1: /usr/bin/gcc: No such file or directory
mv: cannot stat `ntcontab.o': No such file or directory
/usr/bin/ar: /app/oracle/product/9.2.0/lib/ntcontab.o: No such file or directory
make: *** [ntcontab.o] Error 1
End output from spawned process.
----------------------------------
Exception thrown from action: make
Exception Name: MakefileException
Exception String: Error in invoking target 'ntcontab.o' of makefile '/app/oracle/product/9.2.0/network/lib/ins_net_client.mk'. See '/app/oracle/oraInventory/logs/installActions2007-05-15_12-56-23PM.log' for details.
Exception Severity: 1
--------- solution ----------
Look in indicated log file, gcc is not installed in current case, carefully read the log lines the solution is always there
|
db ORA-28221: REPLACE not specified ---- You have probably enabled profiles with custom function. Supply the old password: alter user tst identified by "pioone" replace "pioo" See Custom password security |
db ORA-00988: missing or invalid password(s) ------------- Use double quotes: alter user tst identified by "43fg!" replace "12ab!" See Custom password security |
db
ORA-000060: Deadlock detected. More info in file /app/oracle/admin/ISPDBPRO/udump/ispdbpro_ora_298.trc
------
Go to indicated trace file,
/app/oracle/admin/ISPDBPRO/udump/ispdbpro_ora_298.trc
Oracle9i Enterprise Edition Release 9.2.0.4.0 - Production
With the Partitioning option
JServer Release 9.2.0.4.0 - Production
ORACLE_HOME = /app/oracle/product/9.2.0
System name: SunOS
Node name: db032ops
Release: 5.9
Version: Generic_118558-25
Machine: sun4u
Instance name: ISPDBPRO
Redo thread mounted by this instance: 1
Oracle process number: 14
Unix process pid: 298, image: oracle@db032ops (TNS V1-V3)
*** 2007-05-24 11:48:40.673
<<<<SESSION CAUSING LOCK>>>>
*** SESSION ID:(83.3893) 2007-05-24 11:48:40.672
DEADLOCK DETECTED
Current SQL statement for this session:
<<<<SESSION CAUSING LOCK>>>>
delete from UCUS_OA_CUSTOMER where UCUS_ACCOUNT_NR = '0409852'
The following deadlock is not an ORACLE error. It is a
deadlock due to user error in the design of an application
or from issuing incorrect ad-hoc SQL. The following
information may aid in determining the deadlock:
Deadlock graph:
---------Blocker(s)-------- ---------Waiter(s)---------
Resource Name process session holds waits process session holds waits
TM-00001899-00000000 14 83 SX 21 55 SX SSX
TM-0000189e-00000000 21 55 SX 14 83 SX SSX
session 83: DID 0001-000E-002DDBCB session 55: DID 0001-0015-00235428
session 55: DID 0001-0015-00235428 session 83: DID 0001-000E-002DDBCB
Rows waited on:
Session 55: obj - rowid = 00001899 - AAAAAAAAGAAAK22AAA
(dictionary objn - 6297, file - 6, block - 44470, slot - 0)
Session 83: no row
Information on the OTHER waiting sessions:
Session 55:
pid=21 serial=3842 audsid=44466165 user: 35/ |
db ORA-07445: exception encountered: core dump [kxscbb()+92] [SIGSEGV] [Address not mapped to object] [0x4] [] [] -------- Solution: alter system flush shared_pool |
db SQL> startup ORA-00119: invalid specification for system parameter LOCAL_LISTENER ORA-00132: syntax error or unresolved network name 'db601rcc' --------- Correctly set init parameter local_listener=rcc_sct where rcc_sct is a valid entry in tnsnames.ora |
db install
Exception java.lang.UnsatisfiedLinkError: /tmp/OraInstall2007-06-18_06-41-49PM/jre/1.4.2/lib/i386/libawt.so: libXp.so.6: cannot open shared object file: No such file or directory occurred..
java.lang.UnsatisfiedLinkError: /tmp/OraInstall2007-06-18_06-41-49PM/jre/1.4.2/lib/i386/libawt.so: libXp.so.6: cannot open shared object file: No such file or directory
at java.lang.ClassLoader$NativeLibrary.load(Native Method)
at java.lang.ClassLoader.loadLibrary0(Unknown Source)
...
----------
Linux kernel is too recent, particularly X libs.
Got this on RedHat 4 with 2.6.9-42.ELsmp, install package xorg-x11-deprecated-libs
Got this on RedHat 5, install package libXp-1.0.0-8.1.el5.i386.rpm
|
rman RMAN-00571: =========================================================== RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== RMAN-00571: =========================================================== RMAN-03002: failure of restore command at 06/29/2007 10:10:12 ORA-19507: impossibile recuperare file sequenziale, handle="c-3956220806-20070627-09", param="" ORA-27029: skgfrtrv: sbtrestore ha restituito un errore ORA-19511: È stato ricevuto un errore dal layer del gestore supporti, testo dell'errore: The NW authentication for client 'pkg_nis' was refused by server 'bk001bck' because 'client `db008ora.management.fw' is not properly configured on the NetWorker Server'. (2:12:0) ------------ Is bk001bck the correct backup server? Your Legato administrator needs to add db008ora to authorized client. |
db
Ioctl ASYNC_CONFIG error, errno = 1
*** SESSION ID:(16.1) 2007-06-28 16:16:31.516
*** 2007-06-28 16:16:31.516
ORA-00313: open failed for members of log group 1 of thread 1
ORA-00312: online log 1 thread 1: '/nis_pro/redo_tmp/redo0102.rdo'
ORA-27037: unable to obtain file status
HPUX-ia64 Error: 2: No such file or directory
Additional information: 3
ORA-00312: online log 1 thread 1: '/nis_pro/redo_tmp/redo0101.rdo'
ORA-27037: unable to obtain file status
HPUX-ia64 Error: 2: No such file or directory
Additional information: 3
ORA-00313: open failed for members of log group 2 of thread 1
ORA-00312: online log 2 thread 1: '/nis_pro/redo_tmp/redo0202.rdo'
ORA-27037: unable to obtain file status
HPUX-ia64 Error: 2: No such file or directory
Additional information: 3
ORA-00312: online log 2 thread 1: '/nis_pro/redo_tmp/redo0201.rdo'
ORA-27037: unable to obtain file status
HPUX-ia64 Error: 2: No such file or directory
Additional information: 3
*** 2007-06-28 16:16:56.310
ksedmp: internal or fatal error
ORA-00600: internal error code, arguments: [25012], [1], [3], [], [], [], [], []
Current SQL statement for this session:
select obj#,type#,ctime,mtime,stime,status,dataobj#,flags,oid$, spare1, spare2 from obj$ where owner#=:1 and name=:2 and namespace=
:3 and remoteowner is null and linkname is null and subname is null
----- Call Stack Trace -----
calling call entry argument values in hex
location type point (? means dubious value)
-------------------- -------- -------------------- ----------------------------
Cannot find symbol in .
ksedmp()+528 call _etext_f()+23058430 000000000 ?
09102745940 C000000000000996 ?
Errors in file /app/oracle/product/9.2.0/rdbms/log/nis_pro_ora_21235.trc:
ORA-00600: internal error code, arguments: [25012], [1], [3], [], [], [], [], []
Thu Jun 28 16:30:35 2007
Errors in file /app/oracle/product/9.2.0/rdbms/log/nis_pro_ora_21235.trc:
ORA-00704: bootstrap process failure
ORA-00600: internal error code, arguments: [25012], [1], [3], [], [], [], [], []
Thu Jun 28 16:30:35 2007
Error 704 happened during db open, shutting down database
USER: terminating instance due to error 704
---------------------
I got this error during rman duplicate, finally it looks like a bug. Rman restore works
|
rman RMAN-00571: =========================================================== RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== RMAN-00571: =========================================================== RMAN-03002: failure of restore command at 07/05/2007 16:26:18 ORA-27191: sbtinfo2 returned error Additional information: 2 ------------- No Legato environment variables defined? See Legato |
rman NetWorker: Reverse DNS lookup failed for address 10.1.1.6 allocated channel: ch1 channel ch1: sid=538 devtype=SBT_TAPE channel ch1: NMO v4.2.0.0 ---- That's not an error. Ignore it |
db Failure to extend rollback segment 14 because of 30036 condition FULL status of rollback segment 14 set. FULL status of rollback segment 14 cleared. Wed Jul 11 12:09:23 2007 Failure to extend rollback segment because of 30036 condition ---- select distinct status from v$rollstat; if result is UNKNOWN recreate than: recreate the undo alter system set undo_tablespace=undotbs2 drop the old undo including contents and datafiles update your init.ora |
Sun Jul 22 13:52:11 2007 Active call for process 7953 user 'ora920' program 'oracle@invmi02 (S090)' Active call for process 18051 user 'ora920' program 'oracle@invmi02 (S056)' Active call for process 9457 user 'ora920' program 'oracle@invmi02 (S001)' Active call for process 12902 user 'ora920' program 'oracle@invmi02 (S101)' Active call for process 22485 user 'ora920' program 'oracle@invmi02 (S100)' Active call for process 22045 user 'ora920' program 'oracle@invmi02 (S006)' SHUTDOWN: waiting for active calls to complete. ----- Here is what to do: $ kill -9 7953 $ kill -9 18051 $ kill -9 9457 $ kill -9 12902 $ kill -9 22485 $ kill -9 22045 ..... Sun Jul 22 13:55:29 2007 Waiting for dispatcher 'D006' to shutdown Waiting for dispatcher 'D011' to shutdown Waiting for dispatcher 'D014' to shutdown >shutdown abort |
rman
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03009: failure of backup command on ORA_SBT_TAPE_1 channel at 08/22/2007 12:21:18
ORA-19506: failed to create sequential file, name="arch_PERFRETE_91597_1_ediq175q", parms=""
ORA-27028: skgfqcre: sbtbackup returned error
ORA-19511: Error received from media manager layer, error text:
The call to nsr_start() failed with the message:
Unknown host (0:5:0)
Recovery Manager complete.
------------
Contact your Legato administrator.
This happened when the Legato storage node was mounted on another host and the Legato administrator forget to update some parameter.
|
db CREATE CONTROLFILE set DATABASE RCC_PRO RESETLOGS FORCE LOGGING NOARCHIVELOG * ERROR at line 1: ORA-01503: CREATE CONTROLFILE failed ORA-01161: database name RCC_SCT in file header does not match given name of RCC_PRO ORA-01110: data file 2: '/ora01_rcc/RCC_PRO/data/undotbs01.dbf' ------------------ bbed solution |
db CREATE CONTROLFILE set DATABASE RCC_PRO RESETLOGS FORCE LOGGING NOARCHIVELOG * ERROR at line 1: ORA-01503: CREATE CONTROLFILE failed ORA-01189: file is from a different RESETLOGS than previous files ORA-01110: data file 2: '/ora01_rcc/RCC_PRO/data/undotbs01.dbf' ---------- Comment out UNDO parameter from init Restart instance in nomount Recreate controlfile omitting the file above Open Drop and recreate the undo |
Enterprise Manager Agent 10g Requesting an HTTPS Upload URL from the OMS... Done. Requesting an Oracle Wallet and Agent Key from the OMS... Failed. Failed to contact the OMS at the HTTP URL set in /app/oracle/admin/RCC_PRO/agent10g/db801rcc.intranet.fw/sysman/config/emd.properties The Agent has not been secured. ------ When prompted for Enter Agent Registration password : you must insert the correct SYSMAN password |
db Exception in thread "main" java.sql.SQLException: Listener refused the connection with the following error: ORA-12519, TNS:no appropriate service handler found The Connection descriptor used by the client was: localhost:1521:al12 ------ increment processes parameter |
exp/imp . importing CTI2ADMIN's objects into CTI2ADMIN "ALTER SESSION SET CURRENT_SCHEMA= "CTI2ADMIN"" IMP-00003: ORACLE error 1435 encountered ORA-01435: user does not exist IMP-00000: Import terminated unsuccessfully EXP-00002: error in writing to export file EXP-00002: error in writing to export fileerror closing export file xpipe EXP-00000: Export terminated unsuccessfully ------- On full import you must be sure that temporary tablespaces have same name on source and destination db Imp uses the temp tablespace name when creating the user See Amardeep Sidhu's Blog: Import ORA-01435: user does not exist... See Datapump/ Export/Import |
db HP-UX Error: 46: No locks available ------ Increase nflocks parameter value Inspect current value using: kmtune -q nflocks |
rman duplicate Errors in file /nis_int1/NIS_INT1/udump/nis_int1_ora_12899.trc: ORA-01122: database file 202 failed verification check ORA-01110: data file 202: '/ora02_nis/NIS_INT1/temp/temp02.dbf' ORA-01203: wrong incarnation of this file - wrong creation SCN ---------- On temp file drop and recreate temporary tablespace After duplicate on 10.2 this happen when tempfiles are already present on filesystem |
expdp ORA-31634: job already exists ORA-06512: at "SYS.DBMS_SYS_ERROR", line 79 ORA-06512: at "SYS.KUPV$FT", line 859 ORA-31637: cannot create job EXPORT_TEMPORANEO for user SYSTEM ------ You using expdb and killed an export? Drop table EXPORT_TEMPORANEO |
rman
ORA-19511: Error received from media manager layer, error text:
The call to nsr_start() failed with the message:
Unable to extract resource info for client demo03.management.fw. (0:5:0)
-------
Contact your Legato administrator
Check your /etc/hosts and dns resolution
|
db alter system archive log current; --hang-- ---- select status from v$log; STATUS ---------------- ACTIVE ACTIVE ACTIVE CURRENT alter system checkpoint; System altered. select status from v$log; STATUS ---------------- CURRENT INACTIVE INACTIVE ACTIVE |
rman resync got ORA-1220, retrying with sort_area_size = 20MB resync got ORA-1220, retrying with sort_area_size = 30MB resync got ORA-1220, retrying with sort_area_size = 40MB resync got ORA-1220, retrying with sort_area_size = 50MB resync got ORA-1220, retrying with sort_area_size = 60MB resync got ORA--1220, giving up RMAN-00571: =========================================================== RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== RMAN-00571: =========================================================== RMAN-03002: failure of allocate command at 12/19/2007 12:40:18 RMAN-03014: implicit resync of recovery catalog failed RMAN-03009: failure of partial resync command on default channel at 12/19/2007 12:40:18 ORA-01220: file based sort illegal before database is open ------ set sort_area_retained_size=655360 set sort_area_size=655360 |
db - java
DOC>#######################################################################
DOC>#######################################################################
DOC> If the following rmjvm.check_for_rmjvm() statement results in
DOC> ORA-00028 it means that the database has not been restarted
DOC> since the rmjvm script was run. If so, restart the database and
DOC> retry this script.
DOC>#######################################################################
DOC>#######################################################################
DOC>*/
call rmjvm.check_for_rmjvm()
*
ERROR at line 1:
ORA-00028: your session has been killed
ORA-06512: at "SYS.RMJVM", line 455
-------------------
no need to restart, just
alter system flush shared_pool;
|
db - java
*** SESSION ID:(42.12743) 2007-12-20 15:59:56.546
java.lang.ArrayStoreException
at java.lang.System.arraycopy(System.java)
at java.io.ByteArrayOutputStream.write(ByteArrayOutputStream.java)
at java.io.OutputStreamWriter.flushBuffer(OutputStreamWriter.java)
at java.io.OutputStreamWriter.flush(OutputStreamWriter.java)
at java.io.PrintWriter.newLine(PrintWriter.java)
at java.io.PrintWriter.println(PrintWriter.java)
at java.io.PrintWriter.println(PrintWriter.java)
at java.lang.Throwable.printStackTrace(Throwable.java)
at oracle.aurora.jdkcompiler.JdkDriver.compile(JdkDriver.java)
at oracle.aurora.rdbms.Compiler.doCompile(Compiler.java)
at oracle.aurora.rdbms.Compiler.access$000(Compiler.java)
at oracle.aurora.rdbms.Compiler$1.run(Compiler.java)
at java.security.AccessController.doPrivileged(AccessController.java)
at oracle.aurora.rdbms.Compiler.compile(Compiler.java)
Exception signal: 11 (SIGSEGV), code: 1 (Address not mapped to object), addr: 0x18, PC: [0xfeddeebc, joninvk()+492]
*** 2007-12-20 15:59:56.579
ksedmp: internal or fatal error
ORA-07445: exception encountered: core dump [joninvk()+492] [SIGSEGV] [Address not mapped to object] [0x18] [] []
Current SQL statement for this session:
ALTER JAVA CLASS "SYSTEM"."visio/VisioDb/javaRun/ShellCmd" COMPILE
---------------
The class visio/VisioDb/javaRun/ShellCmd was scompiled.
The ORA-07445 was raised during implicit compilation due to client call.
Problem solved by flushing the shared_pool before loading new java classes
|
Rman
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03009: failure of backup command on t3 channel at 12/20/2007 16:59:51
ORA-19506: failed to create sequential file, name="dbaseNAA_PRO_03j43d84", parms=""
ORA-27028: skgfqcre: sbtbackup returned error
ORA-19511: Error received from media manager layer, error text:
The call to nsr_start() failed with the message:
no matching devices; check storage nodes, devices or pools (0:5:0)
-----------
check NSR_DATA_VOLUME_POOL env variable
|
db
ORA-00600: internal error code, arguments: [17059], [0x701BEFE8], [], [], [], [], [], []
-----
See note 138554.1
This query must return no rows:
select do.obj#,
po.obj# ,
p_timestamp,
po.stime ,
decode(sign(po.stime-p_timestamp),0,'SAME','*DIFFER*') X
from sys.obj$ do, sys.dependency$ d, sys.obj$ po
where P_OBJ#=po.obj#(+)
and D_OBJ#=do.obj#
and do.status=1 /*dependent is valid*/
and po.status=1 /*parent is valid*/
and po.stime!=p_timestamp /*parent timestamp not match*/
order by 2,1
update sys.dependency$ d set p_timestamp = (select stime from sys.obj$ where obj#=p_obj#)
where not (select stime from sys.obj$ where obj#=p_obj#) is null
commit;
alter system flush shared_pool; |
rman RMAN-00571: =========================================================== RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== RMAN-00571: =========================================================== RMAN-03002: failure of Duplicate Db command at 04/21/2008 16:00:25 RMAN-03015: error occurred in stored script Memory Script RMAN-06055: could not find log sequence 15238 thread 1 -------- #Open database without applying from missing log in advance alter database open resetlogs; |
db TNS-12537: TNS:connection closed TNS-12560: TNS:protocol adapter error TNS-00507: Connection closed Linux Error: 29: Illegal seek ----------- This is my listener.ora: ... (ADDRESS = (PROTOCOL = TCP)(HOST = linuxes)(PORT = 1521)) ... This was my /etc/hosts before cure: 127.0.0.1 linuxes linuxes This is my /etc/hosts after cure: 127.0.0.1 linuxes linuxes 127.0.0.1 localhost.localdomain localhost |
Oracle Install - Clusterware Caught Cluster ExceptionPRKC-1044 : Failed to check remote command execution setup for node linuxes.fadalti.com using shells /usr/bin/ssh and /usr/bin/rsh linuxes.fadalti.com: Connection refused [PRKC-1044 : Failed to check remote command execution setup for node linuxes.fadalti.com using shells /usr/bin/ssh and /usr/bin/rsh linuxes.fadalti.com: Connection refused] [PRKC-1044 : Failed to check remote command execution setup for node linuxes.fadalti.com using shells /usr/bin/ssh and /usr/bin/rsh linuxes.fadalti.com: Connection refused [PRKC-1044 : Failed to check remote command execution setup for node linuxes.fadalti.com using shells /usr/bin/ssh and /usr/bin/rsh linuxes.fadalti.com: Connection refused]] -------- Ensure ssh automatic connection works (see ssh - Automatic Connection) between nodes Be sure to test all possibilities answering "yes" to requests of new host addition |
db
ORA-01720: grant option does not exist for 'ALWORKSHOP.MYCRIPT'
--------
Scenario:
User A has a package called MYCRIPT
user A> grant all on MYCRIPT to B;
user B> create view VVV as select A.MYCRIPT.aFunction from dual;
user B> grant select on VVV to C;
ORA-01720: grant option does not exist for 'ALWORKSHOP.MYCRIPT'
Solution:
user A> grant all on MYCRIPT to A with grant option;
|
OS Linux - db install -bash: ulimit: stack size: cannot modify limit: Operation not permitted ---- See metalink note 300819.1 add this line: session required pam_limits.so to this files: /etc/pam.d/login /etc/pam.d/su /etc/pam.d/sshd /etc/pam.d/xdm /etc/pam.d/gdm /etc/pam.d/kde |
DB - upgrade 10g->11g ID processo: 14775 ID sessione: 170, numero di serie: 7 XDB UNINITIALIZED: XDB$SCHEMA not accessible Errors in file /app/oracle/diag/rdbms/al12/al12/trace/al12_ora_14775.trc: ORA-00904: "ACTIONCOLNO": identificativo non valido Exception [type: SIGSEGV, Address not mapped to object] [ADDR:0x40] [PC:0x8939E3A, kkttrex()+1524] Errors in file /app/oracle/diag/rdbms/al12/al12/trace/al12_ora_14775.trc (incident=13348): ORA-07445: trovata eccezione: dump della memoria [kkttrex()+1524] [SIGSEGV] [ADDR:0x40] [PC:0x8939E3A] [Address not mapped to object] [] Incident details in: /app/oracle/diag/rdbms/al12/al12/incident/incdir_13348/al12_ora_14775_i13348.trc ------- See note 462790.1 Relink with no DataVault $ cd to the 11g $ORACLE_HOME/rdbms/lib $ make -f ins_rdbms.mk dv_off $ cd to the 11g $ORACLE_HOME/bin $ relink oracle |
db - ASM ORA-00845: MEMORY_TARGET not supported on this system ------------- See note 460506.1 Not enough memory, on VMware simply assign more memory to the host |
ASM ORA-15110: no diskgroups mounted ----- create a diskgroup and specify it in asm_diskgroups parameter |
ASM ASMCMD-08103: failed to connect to ASM; ASMCMD running in non-connected mode ---- export ORACLE_SID=+ASM |
Oracle install lsnodes: error while loading shared libraries: libskgxn2.so: cannot open shared object file: No such file or directory ---- try to find the missing library in the system find / -name libskgxn2.so if found then add path to LD_LIBRARY_PATH export LD_LIBRARY_PATH=/app/oracle/product/10.2.0/lib |
ASM
ORA-15032: not all alterations performed
ORA-15063: ASM discovered an insufficient number of disks for diskgroup
"DGROUP1"
-------
use lsdsk to locate missing disk
ASMCMD> lsdsk -kI
Total_MB Name Failgroup Path
300 DGROUP1_0000 CTLR1 /dev/raw/raw1
/dev/raw/raw2
/dev/raw/raw3
/dev/raw/raw4
|
ASM
SQL> alter diskgroup DGROUP1 mount;
alter diskgroup DGROUP1 mount
*
ERROR at line 1:
ORA-15032: not all alterations performed
ORA-15040: diskgroup is incomplete
ORA-15042: ASM disk "3" is missing
ORA-15042: ASM disk "2" is missing
ORA-15042: ASM disk "1" is missing
------
use lsdsk to locate missing disk
ASMCMD> lsdsk -kI
Total_MB Name Failgroup Path
300 DGROUP1_0000 CTLR1 /dev/raw/raw1
/dev/raw/raw2
/dev/raw/raw3
/dev/raw/raw4
|
Context index ORA-29855: error occurred in the execution of ODCIINDEXCREATE routine ORA-20000: Oracle Text error: DRG-10700: preference does not exist: CTXSYS.DEFAULT_LEXER ORA-06512: at "CTXSYS.DRUE", line 160 ORA-06512: at "CTXSYS.TEXTINDEXMETHODS", line 364 --------------- See http://www-1.ibm.com/support/docview.wss?uid=swg21130299, How to create a database Install localized context version sqlplus ctxsys/<password> @defaults/drdefus.sql |
db Db hang on "SGA: allocation forcing component growth" with a process 100% cpu ----- This is an irritating bug not solved both in 10g and 11g. on 11g with this params I received the error: *.memory_target=150M *.memory_max_target=400M and with this params I solved the issue *.memory_target=400M *.memory_max_target=400M |
Oracle RAC srvctl start nodeapps -n e2 e2:ora.e2.vip:ping to 192.168.1.50 via eth0 failed, rc = 1 (host=E2) e2:ora.e2.vip:ping to 192.168.1.50 via eth0 failed, rc = 1 (host=E2) e2:ora.e2.vip:Interface eth0 checked failed (host=E2) e2:ora.e2.vip:Invalid parameters, or failed to bring up VIP (host=E2) CRS-1006: No more members to consider ---------- 192.168.1.50 was the default gateway for eth0, looks like the problem is that the VIP address is not able to ping eth0 gateway. Problem solved by setting eth0 gateway the same as its ip address [/etc/sysconfig/network-scripts/ifcfg-eth0] DEVICE=eth0 BOOTPROTO=none BROADCAST=192.168.0.255 IPADDR=192.168.0.13 IPV6INIT=yes IPV6_AUTOCONF=yes NETMASK=255.255.255.0 NETWORK=192.168.0.0 ONBOOT=yes TYPE=Ethernet GATEWAY=192.168.0.13 PEERDNS=yes USERCTL=no |
db sql>select * from global_name; GLOBAL_NAME -------------------------------------------------------------------------------- AL12.REGRESS.RDBMS.DEV.US.ORACLE.COM sql>alter database rename global_name to "AL12"; sql>select * from global_name; GLOBAL_NAME -------------------------------------------------------------------------------- AL12.REGRESS.RDBMS.DEV.US.ORACLE.COM Is this a bug? Sure, simply issue: db_domain="" sql>update global_name set global_name = 'AL12'; sql>commit |
db - Streams
ORA-26685: cannot apply transactions from multiple sources
----
I used a wrong source_database parameter when creating the apply process using:
DBMS_STREAMS_ADM.ADD_TABLE_RULES(
table_name => 'MTS_OWNER.BANK_CHARGES',
streams_type => 'apply',
streams_name => 'APPLY_MTS' ,
queue_name => 'STRMADMIN.Q_MTS',
include_dml => true,
include_ddl => false,
inclusion_rule => true,
dml_rule_name => mdml_rule_name,
ddl_rule_name => mddl_rule_name,
source_database => '&2');
You must stop and remove the Streams apply process before relaunching the above procedure with the correct
source_database parameter taken from:
select * from global_name
from the source database
|
db - Streams
ORA-26663: error queue for apply process APPLY_STREAM must be empty
ORA-06512: at "SYS.DBMS_APPLY_ADM_INTERNAL", line 283
ORA-06512: at "SYS.DBMS_APPLY_ADM_INTERNAL", line 270
ORA-06512: at "SYS.DBMS_APPLY_ADM", line 691
ORA-06512: at line 2
------------
option 1) Correct the cause of the errors and reapply changes using:
BEGIN
DBMS_APPLY_ADM.EXECUTE_ALL_ERRORS(
apply_name => 'apply_oe',
execute_as_user => false);
END;
option 2) Brutally truncate the queue:
EXEC DBMS_APPLY_ADM.DELETE_ALL_ERRORS(apply_name => 'apply_stream');
Finally you can remove the apply process:
BEGIN
DBMS_APPLY_ADM.DROP_APPLY(
apply_name => 'apply_stream');
END;
|
db - Streams *** 2008-08-21 01:54:25.900 *** SESSION ID:(130.3) 2008-08-21 01:54:25.900 *** CLIENT ID:() 2008-08-21 01:54:25.900 *** SERVICE NAME:(SYS$USERS) 2008-08-21 01:54:25.900 *** MODULE NAME:(oracle@E2 (TNS V1-V3)) 2008-08-21 01:54:25.900 *** ACTION NAME:() 2008-08-21 01:54:25.900 kwqplgps: first propagation/source db bounce/ queue recreated src_queue: "STRMADMIN"."STREAMS_QUEUE2" source db DB10 hwm 0 ----- This is a bug, you must restart the destination db, see metalink note 7246048 |
db - Streams
Thu Aug 21 02:40:46 2008
knllgobjinfo: MISSING Streams multi-version data dictionary!!!
knlldmm: gdbnm=DB10
knlldmm: objn=59069
knlldmm: objv=1
knlldmm: scn=33636843247
See trace file for more information
-----
Look at the trace file generated in bdump, is very clear.
select owner, object_name from dba_objects
where object_id =59069
exec dbms_capture_adm.prepare_table_instantiation('TEST.SOURCETABLE'); |
db - streams ORA-01031: insufficient privileges ORA-06512: at "SYS.DBMS_APPLY_ADM_INTERNAL", line 227 ORA-06512: at "SYS.DBMS_APPLY_ADM", line 666 ORA-06512: at line 2 --------- I was doing this with user STRMADMIN before getting the error: BEGIN DBMS_APPLY_ADM.ALTER_APPLY(apply_name => 'apply_test', ddl_handler => 'test.apply_ddl_handler'); END; The solution is: grant all on test.apply_ddl_handler to strmadmin; |
Oracle Http Server - install -------- 08/08/22 01:13:53 Start process -------- /app/oracle/product/10.2.0_http/Apache/Apache/bin/apachectl start: execing httpd /app/oracle/product/10.2.0_http/Apache/Apache/bin/httpd: error while loading shared libraries: libdb.so.2: cannot open shared object file: No such file or directory ------ I had this error installing Http Server 10.2 from Companion CD on Linux 2.6.18-92.el5xen Install compat-db-4.1.25-6.i386.rpm |
db Streams ORA-01403: no data found |
SQL> alter system set java_pool_size=50M; alter system set java_pool_size=50M * ERROR at line 1: ORA-32018: parameter cannot be modified in memory on another instance ---- alter system set java_pool_size=50M scope=both sid='dmtaa1'; |
db - Java
ORA-29531: no method captureBankCharges in class eds/AbnStreamsMTS/capture/BankChargesDATA
ORA-06512: at "STRMADMIN.PHOTO", line 23
ORA-06512: at "STRMADMIN.PHOTO", line 33
ORA-06512: at line 2
--------------
This was my wrong declaration:
function captureBankCharges(idBankCharges number, ownerDML varchar2, tableDML varchar2, idDML number) return blob as
LANGUAGE JAVA NAME 'eds.AbnStreamsMTS.capture.BankChargesDATA.captureBankCharges(java.lang.double) return java.sql.Blob';
This is the right declaration, native types must not be completely declared:
function captureBankCharges(idBankCharges number, ownerDML varchar2, tableDML varchar2, idDML number) return blob as
LANGUAGE JAVA NAME 'eds.AbnStreamsMTS.capture.BankChargesDATA.captureBankCharges(double) return java.sql.Blob';
See How to Java
|
db - Streams
ORA-01031: insufficient privileges
ORA-06512: at "SYS.DBMS_UTILITY", line 114
ORA-06512: at "SYS.DBMS_STREAMS_ADM_UTL_INVOK", line 995
ORA-06512: at "SYS.DBMS_APPLY_ADM", line 304
ORA-06512: at "STRMADMIN.PREPAREDMLHANDLER", line 4
ORA-06512: at line 1
----
From STRMADMIN I was executing this statement:
execute prepareDmlHandler('MTS_OWNER', 'BANK_CHARGES_FEE_COMPONENTS', 'MTS_APPLY.TABLE_HANDLERS.BANK_CHARGES_FEE_COMPONENTS');
** error ***
Solution:
grant all on MTS_APPLY.table_handlers to strmadmin;
|
Pl/Sql
Errors for TYPE BODY STRINGTOKENIZER:
LINE/COL ERROR
-------- -----------------------------------------------------------------
15/5 PL/SQL: Statement ignored
15/5 PLS-00363: expression 'SELF.LASTSEPPOSITION' cannot be used as an
assignment target
----------------
this was the member function causing the error:
member function nextToken return varchar2 is
result varchar2(32767);
begin
self.lastSepPosition := 5;
return result;
end;
a SELF parameter is implicitly passed to the nextToken function as read only value.
The solution is to declare it explicitly:
member function nextToken(self in out StringTokenizer) return varchar2 is
result varchar2(32767);
begin
lastSepPosition := 5;
return result;
end;
|
Db ERROR at line 1: ORA-16038: log 1 sequence# 280 cannot be archived ORA-00354: corrupt redo log block header ORA-00312: online log 1 thread 1: '/oradata/al12/DATA/redo/R3' ----- This error may be a big problem if the redo log is needed by some standby db, history db or similar If you dont care about losing the redo log then here is exactly my code to solve the problem, take immediately a backup after doing this: SYS AS SYSDBA@al12 >alter database clear logfile group 1; alter database clear logfile group 1 * ERROR at line 1: ORA-00350: log 1 of instance al12 (thread 1) needs to be archived ORA-00312: online log 1 thread 1: '/oradata/al12/DATA/redo/R3' SYS AS SYSDBA@al12 >ALTER DATABASE CLEAR UNARCHIVED LOGFILE GROUP 1; Database altered. |
db - Streams ORA-26687: no instantiation SCN provided for "MTS_OWNER"."AGENTS" in source database "DMTGA.DE" ------ I forgot to specify the source_database_name(=global_name) in while calling DBMS_APPLY_ADM.SET_TABLE_INSTANTIATION_SCN at the apply site. See Oracle Streams |
db - Streams
ORA-01400: cannot insert NULL into ("MTS_HDATA"."AGENTS"."PARTY_BIC")
ORA-06512: at "SYS.LCR$_ROW_RECORD", line 419
ORA-06512: at "MTS_APPLY.TABLE_HANDLERS", line 52
ORA-06512: at "MTS_APPLY.TABLE_HANDLERS", line 55
ORA-06512: at line 1
---------------
Print the record from dba_apply_error, see Oracle Streams
You are not probably logging the required columns on source database, use:
ALTER TABLE agents ADD SUPPLEMENTAL LOG DATA (ALL) COLUMNS;
See Oracle Streams |
db ora-00600 ORA-00600: internal error code, arguments: [mal0-size-too-large], [bfo_qeeOpn: qkexrXformOpn_InitOpn], [], [], [], [], [], [] ----- I got this error working with a pipelined function: type tvarchar2 is table of varchar2(32000); function genInsert return tvarchar2 pipelined is .... reducing the size of tvarchar2 solved the problem: type tvarchar2 is table of varchar2(6000); |
db - Streams ERROR at line 1: ORA-26723: user "STRMADMIN" requires the role "DBA" ORA-06512: at "SYS.DBMS_STREAMS_ADM", line 372 ORA-06512: at "SYS.DBMS_STREAMS_ADM", line 312 ORA-06512: at "STRMADMIN.PREPAREAPPLY", line 4 ORA-06512: at line 1 ---------------- I received this error while executing DBMS_STREAMS_ADM.ADD_TABLE_RULES from inside a stored procedure I solved this error simply calling manually DBMS_STREAMS_ADM.ADD_TABLE_RULES the first time This is a BUG |
db - Streams ORA-26665: STREAMS process APPLY_MTS already exists ORA-06512: at "SYS.DBMS_STREAMS_ADM", line 372 ORA-06512: at line 6 ---------------- to delete an apply process execute DBMS_APPLY_ADM.STOP_APPLY(apply_name => 'apply_mts'); execute DBMS_APPLY_ADM.DROP_APPLY(apply_name => 'apply_mts'); |
db - Streams
ORA-25215: user_data type and queue type do not match
-----
I received this on Streams, sure it is a BUG
After running
DECLARE
rc BINARY_INTEGER;
BEGIN
/* Verify that the queues aquser.q1def and aquser.q2def in the local database
have the same payload type */
DBMS_AQADM.VERIFY_QUEUE_TYPES(
src_queue_name => 'STRMADMIN.Q_MTS',
dest_queue_name => 'STRMADMIN.Q_MTS',
destination => 'SMTAA.ST',
rc => rc);
DBMS_OUTPUT.PUT_LINE(rc);
END;
everything went fine
See Advanced Queue for more infos on this procedure
|
db - loadjava
...
Error while creating class myOracle/odbcPipelineConnector/Connector
ORA-29537: impossibile creare o eliminare direttamente la classe o la risorsa
ORA-06512: a line 1
...
The following operations failed
class myOracle/odbcPipelineConnector/Connector: creation (createFailed)
exiting : Failures occurred during processing
----
I tried to load a jar containing class files,
Manually delete the source files before loading the more recent classes
see How to Java
|
db - install INFO: Exception thrown from action: make Exception Name: MakefileException Exception String: Error in invoking target 'all_no_orcl ihsodbc' of makefile '/opt/oracle/product/10.2/rdbms/lib/ins_rdbms.mk'. See '/opt/oracle/oraInventory/logs/installActions2009-05-27_11-23-14AM.log' for details. Exception Severity: 1 --------------- cd /usr/lib ln -sf libstdc++.so.6.0.3 libstdc++.so.5 |
db - install ORA-01552: cannot use system rollback segment for non-system tablespace 'TEMP' --------- Changed the create database script from ... UNDO TABLESPACE UNDOTBS1 DATAFILE '/opt/oracle/data/PRO/datafiles/undotbs01.dbf' SIZE 100M REUSE retention guarantee to UNDO TABLESPACE UNDOTBS1 DATAFILE '/opt/oracle/data/PRO/datafiles/undotbs01.dbf' SIZE 100M REUSE autoextend on maxsize 300M ... |
db - sqlplus SQL*Plus: Release 11.1.0.7.0 - Production on Tue Aug 4 11:55:07 2009 Copyright (c) 1982, 2008, Oracle. All rights reserved. ERROR: ORA-12162: TNS:net service name is incorrectly specified ------ Solution: export ORACLE_SID=PIPPO |
db ORA-27121: unable to determine size of shared memory segment Linux-x86_64 Error: 13: Permission denied ---- I got this error after changing UID to oracle. The ORACLE_HOME and all db files was changed too but still got this error. The error was solved with a system reboot. Fuck |
RMAN
starting media recovery
channel ORA_AUX_DISK_1: starting archived log restore to default destination
channel ORA_AUX_DISK_1: restoring archived log
archived log thread=1 sequence=1492
channel ORA_AUX_DISK_1: reading from backup piece /data01/app/oracle/product/11.1/SE/dbs/a3knr1k0_1_1
channel ORA_AUX_DISK_1: ORA-19870: error while restoring backup piece /data01/app/oracle/product/11.1/SE/dbs/a3knr1k0_1_1
ORA-19505: failed to identify file "/data01/app/oracle/product/11.1/SE/dbs/a3knr1k0_1_1"
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3
failover to previous backup
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of recover command at 08/28/2009 15:22:01
RMAN-20506: no backup of archived log found
RMAN-06053: unable to perform media recovery because of missing log
RMAN-06025: no backup of archived log for thread 1 with sequence 1492 and starting SCN of 1422860 found to restore
----------------
A backup was mistakenly launched from command line without allocating the correct channel.
We need to move the backupset containing the not found backuppiece
#get backupset number
list backuppiece "/data01/app/oracle/product/11.1/SE/dbs/a3knr1k0_1_1";
List of Backup Pieces
BP Key BS Key Pc# Cp# Status Device Type Piece Name
------- ------- --- --- ----------- ----------- ----------
58889 58887 1 1 AVAILABLE DISK /data01/app/oracle/product/11.1/SE/dbs/a3knr1k0_1_1
#move the backupset (backup and delete)
run {
allocate channel t1 type DISK format '/data03/oradata/MPD/DB1/ITADRT/backup/backup/%d_%s_%p_%U_ARCH';
BACKUP backupset 58887 delete input;
release channel t1;
} |
db mv refresh BEGIN DBMS_SNAPSHOT.REFRESH(LIST=>'DM3_OWNER.MYOFFERS_OPTIN', METHOD=>'F'); END; * ERROR at line 1: ORA-01031: insufficient privileges ORA-06512: at "SYS.DBMS_SNAPSHOT", line 2251 ORA-06512: at "SYS.DBMS_SNAPSHOT", line 2457 ORA-06512: at "SYS.DBMS_SNAPSHOT", line 2426 ORA-06512: at line 1 -------------- Being granted the DBA role is NOT sufficient to refresh another user's snapshot. You have to explicitly grant the user: ALTER ANY SNAPSHOT or ALTER ANY MATERIALIZED VIEW and SELECT ANY TABLE system privilege. |
Clusterware install INFO: Calling Query ClusterQueries10.2.0.1.0 ValidateUserEquiv nodeNames = node1,node2, INFO: Query Returned: SEVERE: The specified nodes are not clusterable. The following error was returned by the operating system: ---- Answer yes to all combinations from all hosts: node 1> ssh node1 "date;hostname" node 1> ssh node2 "date;hostname" node 1> ssh node1-priv "date;hostname" node 1> ssh node2-priv "date;hostname" node 1> ssh node1.fadalti.com "date;hostname" node 1> ssh node2.fadalti.com "date;hostname" node 1> ssh node1-priv.fadalti.com "date;hostname" node 1> ssh node2-priv.fadalti.com "date;hostname" |