oracle managed errors
TRANSCRIPT
Oracle Managed ErrorsFrom http://www.fadalti.com/oracle/database/managed_errors_oracle.htm
ORA-00600 lookup and debugginghttp://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:beginfunction package pragma procedure subtype type use<an identifier> <a double-quoted delimited-identifier> formcurrent cursoLook 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:40RMAN-03015: error occurred in stored script Memory ScriptORA-19507: failed to retrieve sequential file, handle="dbaseFAL_PRO_1uh0ei1p", parms=""ORA-27029: skgfrtrv: sbtrestore returned errorORA-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 thebackup 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 contactedunsuccessfully. The problem was appareantly solved by itself! Check dns resolution or other...
RMANRMAN-00571: ===========================================================RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============RMAN-00571: ===========================================================RMAN-03002: failure of restore command at 10/10/2005 16:01:54ORA-19507: failed to retrieve sequential file, handle="dbaseSAS_7kh0n7m5", parms=""ORA-27029: skgfrtrv: sbtrestore returned errorORA-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:41RMAN-03015: error occurred in stored script Memory ScriptORA-19501: read error on file "dbaseFWDBPRO_sbh7dc89", blockno 3859457 (blocksize=512)ORA-27190: skgfrd: sbtread2 returned errorORA-19511: Error received from media manager layer, error text: nwora_read: read section error
Tape is probably corrupt! Contact your media manager administrator
dbDb hung, all redo log active, they don't became inactive
Mon Jan 16 13:05:31 2006Thread 1 cannot allocate new log, sequence 2087Checkpoint 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 #defaultlog_checkpoint_interval=10000log_checkpoint_timeout=1800 #default
Solution:
#this may hung a little, but redo log begin became inactiveSQL>alter system checkpoint;log_checkpoint_interval=10000 is too high, bring it to 0, default valuefast_start_mttr_target=300 don't let it undefined-----------------------------------------------
db
Wed Mar 28 02:27:53 2007ARCH: Connecting to console port...Thread 1 cannot allocate new log, sequence 10All 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 abort2)- Startup mount3)- alter database NOARCHIVELOG;4)- alter database open
RMAN-00571: ===========================================================RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============RMAN-00571: ===========================================================RMAN-03002: failure during compilation of commandRMAN-03013: command type: changeRMAN-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 exists3) 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 encounteredORA-06550: line 1, column 41:PLS-00302: component 'SET_NO_OUTLINES' must be declaredORA-06550: line 1, column 15:PL/SQL: Statement ignoredEXP-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:57ORA-19554: error allocating device, device type: SBT_TAPE, device name:ORA-27211: Failed to load Media Management LibraryAdditional 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 versionUse:file oraclefile /usr/lib/libnwora.so
'allocate auxiliary channel' may work but 'allocate channel' not
ORA-09925: Unable to create audit trail fileSVR4 Error: 2: No such file or directoryAdditional 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:56RMAN-03015: error occurred in stored script Memory ScriptORA-19507: failed to retrieve sequential file, handle="dbaseRAI_PRO_46hi2krn", parms=""ORA-27029: skgfrtrv: sbtrestore returned errorORA-19511: Error received from media manager layer, error text: nwora_open_restore: The NW authentication for client 'db405ops' was refused byserver 'bk001bck' because 'client `db405ops.be.intranet.fw' is not properly configured 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:25RMAN-05501: aborting duplication of target databaseRMAN-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 RESETLOGSORA-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:21RMAN-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 databaseHave 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:29ORA-19506: failed to create sequential file, name="dbaseDMS_PRE_01hkhrmg", parms=""ORA-27028: skgfqcre: sbtbackup returned errorORA-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:16ORA-19506: failed to create sequential file, name="dbaseTSTARCH_01hks9dl", parms=""ORA-27028: skgfqcre: sbtbackup returned errorORA-19511: Error received from media manager layer, error text: nwora_open_backup: unable to start save session with serverbk001bck.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:24RMAN-06053: unable to perform media recovery because of missing logRMAN-06102: no channel to restore a backup or copy of log thread 1 seq 32 scn 89827RMAN-06102: no channel to restore a backup or copy of log thread 1 seq 31 scn 89824RMAN-06102: no channel to restore a backup or copy of log thread 1 seq 30 scn 89821RMAN-06102: no channel to restore a backup or copy of log thread 1 seq 29 scn 89817RMAN-06102: no channel to restore a backup or copy of log thread 1 seq 28 scn 89813RMAN-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 openTue Jun 6 14:47:19 2006LGWR: Primary database is in CLUSTER CONSISTENT modeLGWR: Primary database is in MAXIMUM PROTECTION modeLGWR: Destination LOG_ARCHIVE_DEST_1 is not serviced by LGWRLNS0 started with pid=12Tue Jun 6 14:47:23 2006LGWR: Error 16086 verifying archivelog destination LOG_ARCHIVE_DEST_2LGWR: Continuing...Tue Jun 6 14:47:23 2006Errors in file /tmp/tstarch_lgwr_9049.trc:ORA-16086: standby database does not contain available standby log filesLGWR: Error 16086 disconnecting from destination LOG_ARCHIVE_DEST_2 standby host 'TST_STB'LGWR: Minimum of 1 applicable standby database requiredTue Jun 6 14:47:23 2006Errors in file /tmp/tstarch_lgwr_9049.trc:ORA-16072: a minimum of one standby database destination is requiredLGWR: terminating instance due to error 16072Instance terminated by LGWR, pid = 9049*** SESSION ID:(3.1) 2006-06-06 14:47:19.714Destination LOG_ARCHIVE_DEST_1 is not serviced by LGWR*** 2006-06-06 14:47:19.742 43184 kcrr.cInitializing NetServer for dest=TST_STBInitializing PGA storage for Netserver communicationAllocating a brand new NetServerAllocated NetServer 0 Starting NetServerNetServer 0 has been started.Subscribing to KSR Channel 0success!Indicating recv buffer for KSR Channel 0successWaiting for Netserver 0 to initialize itself*** 2006-06-06 14:47:22.941 43464 kcrr.c Netserver 0 has been initializedLGWR performing a channel reset to ignore previous responsesLGWR connecting as publisher to KSR Channel 0LGWR-NS 0 initialized for destination=TST_STB*** 2006-06-06 14:47:22.941 43918 kcrr.cMaking upiahm request to NetServer 0Waiting for NetServer to respond to upiahm*** 2006-06-06 14:47:23.100 44104 kcrr.c upiahm connect done status is 0Receiving message from NetServer 0LGWR: Failedrfsp: 0x2ec5188rfsmod: 1 .......rfxslfact:0Error 16086 attaching RFS server to standby instance at host 'TST_STB'
*** 2006-06-06 14:47:23.180LGWR: Error 16086 verifying archivelog destination LOG_ARCHIVE_DEST_2Continuing...ORA-16086: standby database does not contain available standby log files*** 2006-06-06 14:47:23.185 45009 kcrr.cMaking 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.186LGWR: Error 16086 disconnecting from destination LOG_ARCHIVE_DEST_2 standby host 'TST_STB'Ignoring kcrrlvna() detach error 16086Standby database verification failed:16072error 16072 detected in background processORA-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=hpiGetPlatform:returned=0, and os is set to: hpi, platform=HP-UXLogFile for this Download can be found at: "/u01/app/oracle/product/agentDownload10.2.0.1.0Oui/agentDownload.hpi090706144414.log"Running on Selected Platform: HP-UXInstaller location: /u01/app/oracle/product/agentDownload10.2.0.1.0OuiDownloading 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=1Command 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.rspRemoving 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/productedit agentDownload.hpi and substitute the above bold variables
DatabaseSun Oct 8 21:09:09 2006ARC1: Media recovery disabled
-----
Archiver process is active but database is in NOARCHIVELOG.
Stop the archiver usingALTER SYSTEM ARCHIVE LOG stop;
Enterprise Manageropmn/bin/opmnctl startproc ias-component=OC4Jopmnctl: starting opmn managedprocesses...================================================================================
opmn id=co001dba:62000 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 startLog:/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 file06/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.PropertyMessageResourcesINFO: Initializing, config='org.apache.struts.util.LocalStrings', returnNull=trueOct 10, 2006 6:48:11 PM org.apache.struts.util.PropertyMessageResourcesINFO: Initializing, config='org.apache.struts.action.ActionResources', returnNull=trueOct 10, 2006 6:48:13 PM org.apache.struts.util.PropertyMessageResourcesINFO: Initializing, config='view.ApplicationResources', returnNull=true06/10/10 18:48:20 log4j:ERROR No appenders could be found for category (emSDK.conf).06/10/10 18:48:20 log4j:ERROR Please initialize the log4j system properly.06/10/10 18:48:51 OVF Integration class06/10/10 18:48:52 java.lang.IllegalArgumentException: Service already exists: oracle.sysman.emSDK.tgt.svc.ServiceConfigManager06/10/10 18:48:52 at oracle.sysman.emSDK.svc.ServiceUtil.setService(ServiceUtil.java:115)06/10/10 18:48:52 at oracle.sysman.emSDK.svc.ServiceUtil.initService(ServiceUtil.java:94)06/10/10 18:48:52 at oracle.sysman.ocs.svcsys.intg.OCSIntegration.init(OCSIntegration.java:121)06/10/10 18:48:52 at oracle.sysman.eml.app.ContextInitializer.contextInitialized(ContextInitializer.java:461)06/10/10 18:48:52 at com.evermind.server.http.HttpApplication.initDynamic(HttpApplication.java:1009)06/10/10 18:48:52 at com.evermind.server.http.HttpApplication.
(HttpApplication.java:549)06/10/10 18:48:52 at com.evermind.server.Application.getHttpApplication(Application.java:890)06/10/10 18:48:52 at com.evermind.server.http.HttpServer.getHttpApplication(HttpServer.java:707)06/10/10 18:48:52 at com.evermind.server.http.HttpSite.initApplications(HttpSite.java:625)06/10/10 18:48:52 at com.evermind.server.http.HttpSite.setConfig(HttpSite.java:278)06/10/10 18:48:52 at com.evermind.server.http.HttpServer.setSites(HttpServer.java:278)06/10/10 18:48:52 at com.evermind.server.http.HttpServer.setConfig(HttpServer.java:179)06/10/10 18:48:52 at com.evermind.server.ApplicationServer.initializeHttp(ApplicationServer.java:2394)06/10/10 18:48:52 at com.evermind.server.ApplicationServer.setConfig(ApplicationServer.java:1551)06/10/10 18:48:52 at com.evermind.server.ApplicationServerLauncher.run(ApplicationServerLauncher.java:92)06/10/10 18:48:52 at java.lang.Thread.run(Thread.java:534)06/10/10 18:50:09 Oracle Application Server Containers for J2EE 10g (10.1.2.0.2) initialized
-----
Have you killed EM processes?OMS_HOME/opmn/bin/opmnctl stopallOMS_HOME/opmn/bin/opmnctl statusOMS_HOME/opmn/bin/opmnctl startall
Pl/SqlORA-00942: table or view does not existORA-06512: at "SYS.DBMS_SYS_SQL", line 826ORA-06512: at "SYS.DBMS_SQL", line 39ORA-06512: at "ALWORKSHOP.GESTIONETABELLE", line 35ORA-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>
rmanRMAN-00571: ===========================================================RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============RMAN-00571: ===========================================================RMAN-03002: failure of restore command at 10/18/2006 18:05:20RMAN-06026: some targets not found - aborting restoreRMAN-06023: no backup or copy of datafile 3 found to restoreRMAN-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 DatabaseERROR at line 1:ORA-01113: file 1 needs media recoveryORA-01110: data file 1:'/NAS/test_saved_archive/admin/TSTARCH/data/system_01.dbf'
-----
SQL> recover datafile 1;
orUse this init parameter_allow_resetlogs_corruption=true
Oracle DatabaseWed Oct 25 15:55:51 2006Errors in file /NAS/test_saved_archive/admin/TSTARCH/bdump/tstarch_ckpt_9957.trc:ORA-01242: data file suffered media failure: database in NOARCHIVELOG modeORA-01122: database file 1 failed verification checkORA-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 DatabaseSQL> alter database open;alter database open*ERROR at line 1:ORA-00313: open failed for members of log group 1 of thread 1ORA-00312: online log 1 thread 1:'/NAS/test_saved_archive/admin/TSTARCH/data/redo01a.rdo'ORA-27037: unable to obtain file statusSVR4 Error: 2: No such file or directoryAdditional information: 3
----------
Are redo logs gone?You need to recreate the controlfile using the RESETLOGS optionSQL> alter database backup controlfile to trace;
Oracle DatabaseSQL> alter database open resetlogs;
alter database open resetlogs*ERROR at line 1:ORA-01194: file 1 needs more recovery to be consistentORA-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 errorsORA-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 1ORA-00289: suggestion : /tmp/arch_TST0000000005.logORA-00280: change 68159 for thread 1 is in sequence #5
Specify log: {=suggested | filename | AUTO | CANCEL}
------
This happened while refreshing a target database by physical copy without using'alter tablespace ... begin backup'
No logs to apply?add this parameter to your init.ora
_allow_resetlogs_corruption=true
Restart all and finally use:alter database open RESETLOGS;Remember to remove hidden parameter;
Oracle databaseORA-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_budgetcentre11:15:59 2 nocache11:15:59 3 noparallel11:15:59 4 build deferred11:15:59 5 refresh fast
11:15:59 6 on demand11:15:59 7 with rowid11:15:59 8 using default local rollback segment for update11:15:59 9 disable query rewrite as select11: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_upper11: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 loggrant select, insert, update, delete on geneva_admin.mlog$_budgetcentre to dwh_user;
-grant GLOBAL QUERY REWRITE to PPPsee http://www.lazydba.com/oracle/0__36187.html
Debug using How to trace
Oracle databaseThu Dec 7 17:33:04 2006Errors 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 incorrectSVR4 Error: 28: No space left on deviceAdditional information: -1Additional 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:40ORA-19506: failed to create sequential file, name="dbaseEPL_PRO_4ai4ma2j", parms=""ORA-27028: skgfqcre: sbtbackup returned errorORA-19511: Error received from media manager layer, error text: nwora_open_backup: The NW authentication for client 'db801epl' was refused by server '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:09ORA-19506: failed to create sequential file, name="dbaseEPL_PRO_47i4m9md", parms=""ORA-27028: skgfqcre: sbtbackup returned errorORA-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:37ORA-01580: error creating control backup file /app/oracle/product/8.1.7/dbs/snapcf_DC_PRO.fORA-27040: skgfrcre: create error, unable to create fileSVR4 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.fnew 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 valueOracle 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 defaultIf use .oraprofile please modify itExperience says this may happen when running sqlplus on uncorrectly migrated software in conjunction with multiple Oracle homes
OPATCH
$ opatch lsinventoryPERL5LIB=; export PERL5LIB/usr/contrib/bin/perl ./opatch.pl lsinventoryCan'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 queueORA-06512: at "SYS.DBMS_SYS_ERROR", line 86ORA-06512: at "SYS.DBMS_IJOB", line 529ORA-06512: at "SYS.DBMS_JOB", line 245ORA-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 43117ARC1: Beginning to archive log 1 thread 1 sequence 43117Creating 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 2007Errors in file /app/oracle/admin/ACSPROD/bdump/acsprod_arc1_19881.trc:ORA-00272: error writing archive logARC1: Error 270 Closing archive log file 'acsprod_dhdbhq05'Thu Mar 29 21:31:21 2007Errors in file /app/oracle/admin/ACSPROD/bdump/acsprod_arc1_19881.trc:ORA-00270: error creating archive logARC1: Completed archiving log 1 thread 1 sequence 43117Thu Mar 29 21:33:14 2007ARC0: 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 2007Errors in file /app/oracle/admin/ACSPROD/bdump/acsprod_arc0_19879.trc:ORA-00272: error writing archive logARC0: FAL archive failed, see trace file.ARCH: FAL archive failed. Archiver continuingThu Mar 29 21:33:17 2007ORACLE Instance ACSPROD - Archival Error. Archiver continuing.ARCH: Connecting to console port...Thu Mar 29 21:33:17 2007ORA-16055: FAL request rejectedARCH: Connecting to console port...Thu Mar 29 21:33:17 2007Errors 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:13RMAN-03015: error occurred in stored script Memory ScriptORA-19504: failed to create file "/ora02_rla/RLA_INT/data/TOOLS.dbf"ORA-27086: skgfglk: unable to lock file - already in useSVR4 Error: 11: Resource temporarily unavailableAdditional 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
rmanMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============RMAN-00571: ===========================================================RMAN-00601: fatal error in recovery managerRMAN-03004: fatal error during execution of commandRMAN-10039: error encountered while polling for RPC completion on channel clone_defaultRMAN-10006: error running SQL statement: select act from x$ksusex where sid=:1 and serial=:2RMAN-10002: ORACLE error: ORA-03113: end-of-file on communication channelRMAN-03002: failure of Duplicate Db command at 04/06/2007 00:51:29RMAN-03015: error occurred in stored script Memory ScriptRMAN-06136: ORACLE error from auxiliary database: ORA-01092: ORACLE instance terminated. Disconnection forced:1q
----
This is a generic error. Go to see alert.logI 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
dbORA-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 settingI 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
dbSQL> 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.
rmanRMAN-00571: ===========================================================RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============RMAN-00571: ===========================================================RMAN-03002: failure of recover command at 04/10/2007 00:15:27RMAN-06094: datafile 1 must be restored
----
A RECOVER command was issued, and the recovery catalog indicatesthe specified datafile should be part of the recovery, but this datafile is notlisted 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.
dbORA-04045: errors during recompilation/revalidation of ARADMIN.NO_TT_TRANSORA-00942: table or view does not existORA-06512: at "SYS.DBMS_SNAPSHOT", line 803ORA-06512: at "SYS.DBMS_SNAPSHOT", line 860ORA-06512: at "SYS.DBMS_IREFRESH", line 683ORA-06512: at "SYS.DBMS_REFRESH", line 195ORA-06512: at line 2
-------http://forums.oracle.com/forums/thread.jspa?messageID=17795641)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 mastersite.
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
importIMP-00032: SQL statement exceeded buffer lengthIMP-00032: SQL statement exceeded buffer lengthIMP-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
dbMon Apr 16 17:34:05 2007Errors 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' poolClearing the shared pool removes keeped object from the shared pool
dbORA-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 spaceleaks 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
dbORA-00059Sun Apr 29 22:57:07 2007DB_FILES[8] exceeded (fno=231 kcfdpk=230)ORA-59 signalled during: /* OracleOEM */ ALTER TABLESPACE "SNAPLOGS" ADD DA...
......
Increase db_files init parameterCheck MAXDATAFILES value in controlfile, adeguate it to db_files
db - rman
database openedFinished Duplicate Db at 03-MAY-07 23:44:28RMAN-00571: ===========================================================RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============RMAN-00571: ===========================================================ORA-03127: no new operations allowed until the active operation endsRMAN-12005: error during channel cleanupORA-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 oracleHow to install, patch and interim
dbORA-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 installStart 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 directorymv: 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 directorymake: *** [ntcontab.o] Error 1
End output from spawned process.----------------------------------Exception thrown from action: makeException Name: MakefileExceptionException 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
dbORA-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
dbORA-00988: missing or invalid password(s)
-------------Use double quotes:alter user tst identified by "43fg!" replace "12ab!"See Custom password security
dbORA-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.trcOracle9i Enterprise Edition Release 9.2.0.4.0 - ProductionWith the Partitioning optionJServer Release 9.2.0.4.0 - Production
ORACLE_HOME = /app/oracle/product/9.2.0System name: SunOSNode name: db032opsRelease: 5.9Version: Generic_118558-25Machine: sun4uInstance name: ISPDBPRORedo thread mounted by this instance: 1Oracle process number: 14Unix 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.672DEADLOCK DETECTEDCurrent 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 adeadlock due to user error in the design of an applicationor from issuing incorrect ad-hoc SQL. The followinginformation may aid in determining the deadlock:Deadlock graph: ---------Blocker(s)-------- ---------Waiter(s)---------Resource Name process session holds waits process session holds waitsTM-00001899-00000000 14 83 SX 21 55 SX SSXTM-0000189e-00000000 21 55 SX 14 83 SX SSXsession 83: DID 0001-000E-002DDBCB session 55: DID 0001-0015-00235428session 55: DID 0001-0015-00235428 session 83: DID 0001-000E-002DDBCBRows waited on:Session 55: obj - rowid = 00001899 - AAAAAAAAGAAAK22AAA (dictionary objn - 6297, file - 6, block - 44470, slot - 0)Session 83: no rowInformation on the OTHER waiting sessions:Session 55: pid=21 serial=3842 audsid=44466165 user: 35/ O/S info: user: resin, term: unknown, ospid: , machine: as002ums.fe.ums.fw program: JDBC Thin Client application name: JDBC Thin Client, hash value=0 Current SQL Statement: DELETE FROM UCUS_OA_CUSTOMER WHERE UCUS_ACCOUNT_NR = :b1End of information on OTHER waiting sessions.===================================================PROCESS STATE-------------Process global information: process: 3c1fa9a8, call: 3c257b70, xact: 3ccd2f14, curses: 3c243210, usrses: 3c243210 ---------------------------------------- SO: 3c1fa9a8, type: 2, owner: 0, flag: INIT/-/-/0x00 (process) Oracle pid=14, calls cur/top: 3c257b70/3c257b70, flag: (0) - int error: 0, call error: 0, sess error: 0, txn error 0 (post info) last post received: 0 0 20 last post received-location: ksqrcl last process to post me: 3c1fd238 172 0 last post sent: 0 0 19
last post sent-location: ksqcnl last process posted by me: 3c1fc378 202 0 (latch info) wait_event=0 bits=10 holding 20006534 Parent+children enqueue hash chains level=4 Location from where latch is held: ksqcmi: kslgpl: Context saved from call: 0 state=busy recovery area:Dump of memory from 0x3C1F74F4 to 0x3C1F74FC3C1F74F0 00000000 00000000 [........] Process Group: DEFAULT, pseudo proc: 3c20e884 O/S info: user: oracle, term: UNKNOWN, ospid: 298 OSD pid info: Unix process pid: 298, image: oracle@db032ops (TNS V1-V3) ---------------------------------------- SO: 3c9a8b00, type: 8, owner: 3c1fa9a8, flag: INIT/-/-/0x00 (FOB) flags=2 fib ptr=3ca1d5a8 incno=0 pending i/o cnt=0 ---------------------------------------- SO: 3c9a7d70, type: 8, owner: 3c1fa9a8, flag: INIT/-/-/0x00 (FOB) flags=2 fib ptr=3ca1d854 incno=0 pending i/o cnt=0 ---------------------------------------- SO: 3c9a974c, type: 8, owner: 3c1fa9a8, flag: INIT/-/-/0x00 (FOB) flags=2 fib ptr=3ca1d30c incno=0 pending i/o cnt=0 ---------------------------------------- SO: 3c9a9608, type: 8, owner: 3c1fa9a8, flag: INIT/-/-/0x00 (FOB) flags=2 fib ptr=3ca1c88c incno=1 pending i/o cnt=0 ---------------------------------------- <<<<SESSION CAUSING LOCK>>>> SO: 3c243210, type: 4, owner: 3c1fa9a8, flag: INIT/-/-/0x00 (session) trans: 3ccd2f14, creator: 3c1fa9a8, flag: (100041) USR/- BSY/-/-/-/-/- DID: 0001-000E-002DDBCB, short-term DID: 0000-0000-00000000 txn branch: 0 oct: 7, prv: 0, sql: 3d854e28, psql: 3d854e28, user: 34/ISPDB_APP O/S info: user: mvizzarro, term: MVIZZARRO-DXPL, ospid: 3524:3208, machine: FASTWEBIT\MVIZZARRO-DXPL program: TOAD.exe application name: TOAD 7.6.0.11, hash value=3091199043 last wait for 'enqueue' blocking sess=0x3c2329d0 seq=16821 wait_time=3002788 name|mode=544d0005, id1=189e, id2=0 temporary object counter: 0
dbORA-07445: exception encountered: core dump [kxscbb()+92] [SIGSEGV] [Address not mapped to object] [0x4] [] []
--------
Solution:alter system flush shared_pool
dbSQL> startupORA-00119: invalid specification for system parameter LOCAL_LISTENERORA-00132: syntax error or unresolved network name 'db601rcc'
---------
Correctly set init parameterlocal_listener=rcc_sct
where rcc_sct is a valid entry in tnsnames.ora
db installException 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-libsGot this on RedHat 5, install package libXp-1.0.0-8.1.el5.i386.rpm
rmanRMAN-00571: ===========================================================RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============RMAN-00571: ===========================================================RMAN-03002: failure of restore command at 06/29/2007 10:10:12ORA-19507: impossibile recuperare file sequenziale, handle="c-3956220806-20070627-09", param=""ORA-27029: skgfrtrv: sbtrestore ha restituito un erroreORA-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.
dbIoctl ASYNC_CONFIG error, errno = 1*** SESSION ID:(16.1) 2007-06-28 16:16:31.516*** 2007-06-28 16:16:31.516ORA-00313: open failed for members of log group 1 of thread 1ORA-00312: online log 1 thread 1: '/nis_pro/redo_tmp/redo0102.rdo'ORA-27037: unable to obtain file statusHPUX-ia64 Error: 2: No such file or directoryAdditional information: 3ORA-00312: online log 1 thread 1: '/nis_pro/redo_tmp/redo0101.rdo'ORA-27037: unable to obtain file statusHPUX-ia64 Error: 2: No such file or directoryAdditional information: 3ORA-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 statusHPUX-ia64 Error: 2: No such file or directoryAdditional information: 3ORA-00312: online log 2 thread 1: '/nis_pro/redo_tmp/redo0201.rdo'ORA-27037: unable to obtain file statusHPUX-ia64 Error: 2: No such file or directoryAdditional information: 3*** 2007-06-28 16:16:56.310ksedmp: internal or fatal errorORA-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 hexlocation 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 2007Errors in file /app/oracle/product/9.2.0/rdbms/log/nis_pro_ora_21235.trc:ORA-00704: bootstrap process failureORA-00600: internal error code, arguments: [25012], [1], [3], [], [], [], [], []Thu Jun 28 16:30:35 2007Error 704 happened during db open, shutting down databaseUSER: terminating instance due to error 704
---------------------
I got this error during rman duplicate, finally it looks like a bug. Rman restore works
rmanRMAN-00571: ===========================================================RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============RMAN-00571: ===========================================================RMAN-03002: failure of restore command at 07/05/2007 16:26:18ORA-27191: sbtinfo2 returned errorAdditional information: 2
-------------
No Legato environment variables defined?See Legato
rmanNetWorker: Reverse DNS lookup failed for address 10.1.1.6allocated channel: ch1channel ch1: sid=538 devtype=SBT_TAPEchannel ch1: NMO v4.2.0.0
----
That's not an error. Ignore it
dbFailure to extend rollback segment 14 because of 30036 conditionFULL status of rollback segment 14 set.FULL status of rollback segment 14 cleared.Wed Jul 11 12:09:23 2007Failure to extend rollback segment because of 30036 condition
----
select distinct status from v$rollstat;if result is UNKNOWN recreate than:recreate the undoalter system set undo_tablespace=undotbs2drop the old undo including contents and datafilesupdate your init.ora
Sun Jul 22 13:52:11 2007Active 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 2007Waiting for dispatcher 'D006' to shutdownWaiting for dispatcher 'D011' to shutdownWaiting for dispatcher 'D014' to shutdown
>shutdown abort
rmanRMAN-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:18ORA-19506: failed to create sequential file, name="arch_PERFRETE_91597_1_ediq175q",
parms=""ORA-27028: skgfqcre: sbtbackup returned errorORA-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.
dbCREATE CONTROLFILE set DATABASE RCC_PRO RESETLOGS FORCE LOGGING NOARCHIVELOG*ERROR at line 1:ORA-01503: CREATE CONTROLFILE failedORA-01161: database name RCC_SCT in file header does not match given name ofRCC_PROORA-01110: data file 2: '/ora01_rcc/RCC_PRO/data/undotbs01.dbf'
------------------
bbed solution
dbCREATE CONTROLFILE set DATABASE RCC_PRO RESETLOGS FORCE LOGGING NOARCHIVELOG*ERROR at line 1:ORA-01503: CREATE CONTROLFILE failedORA-01189: file is from a different RESETLOGS than previous filesORA-01110: data file 2: '/ora01_rcc/RCC_PRO/data/undotbs01.dbf'
----------
Comment out UNDO parameter from initRestart instance in nomountRecreate controlfile omitting the file aboveOpenDrop and recreate the undo
Enterprise Manager Agent 10gRequesting 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.propertiesThe Agent has not been secured.
------
When prompted forEnter 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 foundThe 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 encounteredORA-01435: user does not existIMP-00000: Import terminated unsuccessfully
EXP-00002: error in writing to export fileEXP-00002: error in writing to export fileerror closing export file xpipeEXP-00000: Export terminated unsuccessfully
-------
On full import you must be sure that temporary tablespaces have same name on source and destination dbImp uses the temp tablespace name when creating the userSee Amardeep Sidhu's Blog: Import ORA-01435: user does not exist...See Datapump/ Export/Import
dbHP-UX Error: 46: No locks available
------
Increase nflocks parameter valueInspect current value using:kmtune -q nflocks
rman duplicateErrors in file /nis_int1/NIS_INT1/udump/nis_int1_ora_12899.trc:ORA-01122: database file 202 failed verification checkORA-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 tablespaceAfter duplicate on 10.2 this happen when tempfiles are already present on filesystem
expdpORA-31634: job already exists
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 79ORA-06512: at "SYS.KUPV$FT", line 859ORA-31637: cannot create job EXPORT_TEMPORANEO for user SYSTEM
------
You using expdb and killed an export?Drop table EXPORT_TEMPORANEO
rmanORA-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 administratorCheck your /etc/hosts and dns resolution
dbalter system archive log current;--hang--
----
select status from v$log;
STATUS----------------ACTIVEACTIVEACTIVECURRENT
alter system checkpoint;System altered.
select status from v$log;
STATUS----------------CURRENTINACTIVEINACTIVEACTIVE
rmanresync got ORA-1220, retrying with sort_area_size = 20MBresync got ORA-1220, retrying with sort_area_size = 30MBresync got ORA-1220, retrying with sort_area_size = 40MBresync got ORA-1220, retrying with sort_area_size = 50MBresync got ORA-1220, retrying with sort_area_size = 60MBresync got ORA--1220, giving upRMAN-00571: ===========================================================RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================RMAN-03002: failure of allocate command at 12/19/2007 12:40:18RMAN-03014: implicit resync of recovery catalog failedRMAN-03009: failure of partial resync command on default channel at 12/19/2007 12:40:18ORA-01220: file based sort illegal before database is open
------
set sort_area_retained_size=655360set sort_area_size=655360
db - javaDOC>#######################################################################DOC>#######################################################################DOC> If the following rmjvm.check_for_rmjvm() statement results inDOC> ORA-00028 it means that the database has not been restartedDOC> since the rmjvm script was run. If so, restart the database andDOC> retry this script.DOC>#######################################################################DOC>#######################################################################DOC>*/call rmjvm.check_for_rmjvm() *ERROR at line 1:ORA-00028: your session has been killedORA-06512: at "SYS.RMJVM", line 455
-------------------
no need to restart, justalter system flush shared_pool;
db - java
*** SESSION ID:(42.12743) 2007-12-20 15:59:56.546java.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.579ksedmp: internal or fatal errorORA-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
RmanRMAN-00571: ===========================================================RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============RMAN-00571: ===========================================================RMAN-03009: failure of backup command on t3 channel at 12/20/2007 16:59:51ORA-19506: failed to create sequential file, name="dbaseNAA_PRO_03j43d84", parms=""ORA-27028: skgfqcre: sbtbackup returned errorORA-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
dbORA-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 nullcommit;alter system flush shared_pool;
rmanRMAN-00571: ===========================================================RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================RMAN-03002: failure of Duplicate Db command at 04/21/2008 16:00:25RMAN-03015: error occurred in stored script Memory ScriptRMAN-06055: could not find log sequence 15238 thread 1--------#Open database without applying from missing log in advancealter database open resetlogs;
dbTNS-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 linuxes127.0.0.1 localhost.localdomain localhost
Oracle Install - ClusterwareCaught Cluster ExceptionPRKC-1044 : Failed to check remote command execution setup for node linuxes.fadalti.com using shells /usr/bin/ssh and /usr/bin/rshlinuxes.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/rshlinuxes.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/rshlinuxes.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/rshlinuxes.fadalti.com: Connection refused]]
--------
Ensure ssh automatic connection works (see ssh - Automatic Connection) between nodesBe sure to test all possibilities answering "yes" to requests of new host addition
dbORA-01720: grant option does not exist for 'ALWORKSHOP.MYCRIPT'
--------Scenario:User A has a package called MYCRIPTuser 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.1add this line:session required pam_limits.soto 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->11gID processo: 14775ID sessione: 170, numero di serie: 7
XDB UNINITIALIZED: XDB$SCHEMA not accessibleErrors in file /app/oracle/diag/rdbms/al12/al12/trace/al12_ora_14775.trc:ORA-00904: "ACTIONCOLNO": identificativo non validoException [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 - ASMORA-00845: MEMORY_TARGET not supported on this system
-------------
See note 460506.1Not enough memory, on VMware simply assign more memory to the host
ASMORA-15110: no diskgroups mounted
-----
create a diskgroup and specify it in asm_diskgroups parameter
ASMASMCMD-08103: failed to connect to ASM; ASMCMD running in non-connected mode
----
export ORACLE_SID=+ASM
Oracle installlsnodes: 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 systemfind / -name libskgxn2.soif found then add path to LD_LIBRARY_PATHexport LD_LIBRARY_PATH=/app/oracle/product/10.2.0/lib
ASMORA-15032: not all alterations performedORA-15063: ASM discovered an insufficient number of disks for diskgroup"DGROUP1"
-------
use lsdsk to locate missing diskASMCMD> lsdsk -kITotal_MB Name Failgroup Path 300 DGROUP1_0000 CTLR1 /dev/raw/raw1 /dev/raw/raw2 /dev/raw/raw3 /dev/raw/raw4
ASMSQL> alter diskgroup DGROUP1 mount;alter diskgroup DGROUP1 mount*ERROR at line 1:ORA-15032: not all alterations performedORA-15040: diskgroup is incompleteORA-15042: ASM disk "3" is missingORA-15042: ASM disk "2" is missingORA-15042: ASM disk "1" is missing
------
use lsdsk to locate missing diskASMCMD> lsdsk -kITotal_MB Name Failgroup Path 300 DGROUP1_0000 CTLR1 /dev/raw/raw1 /dev/raw/raw2 /dev/raw/raw3 /dev/raw/raw4
Context indexORA-29855: error occurred in the execution of ODCIINDEXCREATE routineORA-20000: Oracle Text error:DRG-10700: preference does not exist: CTXSYS.DEFAULT_LEXERORA-06512: at "CTXSYS.DRUE", line 160ORA-06512: at "CTXSYS.TEXTINDEXMETHODS", line 364
---------------See http://www-1.ibm.com/support/docview.wss?uid=swg21130299, How to create a databaseInstall localized context versionsqlplus ctxsys/<password> @defaults/drdefus.sql
dbDb 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=400Mand with this params I solved the issue *.memory_target=400M *.memory_max_target=400M
Oracle RACsrvctl start nodeapps -n e2e2: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=eth0BOOTPROTO=noneBROADCAST=192.168.0.255IPADDR=192.168.0.13IPV6INIT=yesIPV6_AUTOCONF=yesNETMASK=255.255.255.0
NETWORK=192.168.0.0ONBOOT=yesTYPE=EthernetGATEWAY=192.168.0.13PEERDNS=yesUSERCTL=no
dbsql>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 - StreamsORA-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 correctsource_database parameter taken from:select * from global_namefrom the source database
db - StreamsORA-26663: error queue for apply process APPLY_STREAM must be emptyORA-06512: at "SYS.DBMS_APPLY_ADM_INTERNAL", line 283ORA-06512: at "SYS.DBMS_APPLY_ADM_INTERNAL", line 270
ORA-06512: at "SYS.DBMS_APPLY_ADM", line 691ORA-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 - StreamsThu Aug 21 02:40:46 2008knllgobjinfo: MISSING Streams multi-version data dictionary!!!knlldmm: gdbnm=DB10knlldmm: objn=59069knlldmm: objv=1knlldmm: scn=33636843247See 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 - streamsORA-01031: insufficient privileges
ORA-06512: at "SYS.DBMS_APPLY_ADM_INTERNAL", line 227ORA-06512: at "SYS.DBMS_APPLY_ADM", line 666ORA-06512: at line 2
---------I was doing this with user STRMADMIN before getting the error:BEGINDBMS_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.el5xenInstall compat-db-4.1.25-6.i386.rpm
db StreamsORA-01403: no data found
ORA-01403: no data found
ORA-06512: at "SYS.LCR$_ROW_RECORD", line 419
ORA-06512: at "MTS_APPLY.TABLE_HANDLERS", line 32
ORA-06512: at line 1
-----------------
I describe how to troubleshoot this error on my Streams section Oracle Streams
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 - JavaORA-29531: no method captureBankCharges in class
eds/AbnStreamsMTS/capture/BankChargesDATAORA-06512: at "STRMADMIN.PHOTO", line 23ORA-06512: at "STRMADMIN.PHOTO", line 33ORA-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 - StreamsORA-01031: insufficient privilegesORA-06512: at "SYS.DBMS_UTILITY", line 114ORA-06512: at "SYS.DBMS_STREAMS_ADM_UTL_INVOK", line 995ORA-06512: at "SYS.DBMS_APPLY_ADM", line 304ORA-06512: at "STRMADMIN.PREPAREDMLHANDLER", line 4ORA-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/SqlErrors for TYPE BODY STRINGTOKENIZER:
LINE/COL ERROR-------- -----------------------------------------------------------------15/5 PL/SQL: Statement ignored15/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;
DbERROR at line 1:ORA-16038: log 1 sequence# 280 cannot be archivedORA-00354: corrupt redo log block headerORA-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 similarIf 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 archivedORA-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 - StreamsORA-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_SCNat 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 419ORA-06512: at "MTS_APPLY.TABLE_HANDLERS", line 52ORA-06512: at "MTS_APPLY.TABLE_HANDLERS", line 55ORA-06512: at line 1
---------------
Print the record from dba_apply_error, see Oracle StreamsYou 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-00600ORA-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 - StreamsERROR at line 1:ORA-26723: user "STRMADMIN" requires the role "DBA"ORA-06512: at "SYS.DBMS_STREAMS_ADM", line 372ORA-06512: at "SYS.DBMS_STREAMS_ADM", line 312ORA-06512: at "STRMADMIN.PREPAREAPPLY", line 4ORA-06512: at line 1
----------------
I received this error while executing DBMS_STREAMS_ADM.ADD_TABLE_RULES from inside a stored procedureI solved this error simply calling manually DBMS_STREAMS_ADM.ADD_TABLE_RULES the first timeThis is a BUG
db - StreamsORA-26665: STREAMS process APPLY_MTS already existsORA-06512: at "SYS.DBMS_STREAMS_ADM", line 372ORA-06512: at line 6
----------------
to delete an apply processexecute DBMS_APPLY_ADM.STOP_APPLY(apply_name => 'apply_mts');execute DBMS_APPLY_ADM.DROP_APPLY(apply_name => 'apply_mts');
db - StreamsORA-25215: user_data type and queue type do not match
-----
I received this on Streams, sure it is a BUGAfter running
DECLARErc 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 risorsaORA-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 classessee How to Java
db - installINFO: Exception thrown from action: makeException Name: MakefileExceptionException 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/libln -sf libstdc++.so.6.0.3 libstdc++.so.5
db - installORA-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 guaranteetoUNDO TABLESPACE UNDOTBS1 DATAFILE '/opt/oracle/data/PRO/datafiles/undotbs01.dbf' SIZE 100M REUSE autoextend on maxsize 300M...
db - sqlplusSQL*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
dbORA-27121: unable to determine size of shared memory segmentLinux-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
RMANstarting media recovery
channel ORA_AUX_DISK_1: starting archived log restore to default destinationchannel ORA_AUX_DISK_1: restoring archived logarchived log thread=1 sequence=1492channel ORA_AUX_DISK_1: reading from backup piece /data01/app/oracle/product/11.1/SE/dbs/a3knr1k0_1_1channel ORA_AUX_DISK_1: ORA-19870: error while restoring backup piece /data01/app/oracle/product/11.1/SE/dbs/a3knr1k0_1_1ORA-19505: failed to identify file "/data01/app/oracle/product/11.1/SE/dbs/a3knr1k0_1_1"ORA-27037: unable to obtain file statusLinux-x86_64 Error: 2: No such file or directoryAdditional information: 3
failover to previous backupRMAN-00571: ===========================================================RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============RMAN-00571: ===========================================================RMAN-03002: failure of recover command at 08/28/2009 15:22:01RMAN-20506: no backup of archived log foundRMAN-06053: unable to perform media recovery because of missing logRMAN-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 numberlist backuppiece "/data01/app/oracle/product/11.1/SE/dbs/a3knr1k0_1_1";
List of Backup PiecesBP 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 refreshBEGIN DBMS_SNAPSHOT.REFRESH(LIST=>'DM3_OWNER.MYOFFERS_OPTIN', METHOD=>'F'); END;*ERROR at line 1:ORA-01031: insufficient privilegesORA-06512: at "SYS.DBMS_SNAPSHOT", line 2251ORA-06512: at "SYS.DBMS_SNAPSHOT", line 2457ORA-06512: at "SYS.DBMS_SNAPSHOT", line 2426ORA-06512: at line 1
--------------
Being granted the DBA role is NOT sufficient to refresh anotheruser's snapshot. You have to explicitly grant the user:ALTER ANY SNAPSHOTorALTER ANY MATERIALIZED VIEWandSELECT ANY TABLEsystem 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"