Category Archives: Errors

Oracle Errors.

NON-SYSTEM DATA SEGMENTS IN SYSTEM TABLESPACES policy is firing for ORDDATA and APEX users [ID 1328174.1]

Posted on June 12, 2011 by Gary

Found that you have EM reporting segments in SYSTEM and SYAUX tablespaces ? This is down to a bug in EM, Metalink note 1328174.1 explains it.

Email
Posted in Enterprise Manager, Errors, Oracle | Tagged , , , | Comments Off

avoid ORA-19527 set dummy log_file_name_convert

Posted on November 17, 2009 by Gary

You created new standby database using hotbackup script and did not create online REDO logs.  You are now trying to enable “Managed Standby Recovery” using the following command: alter database recover managed standby database using current logfile disconnect;

Email
Posted in Configuration., Errors, Oracle, Parameters | Tagged , , | Comments Off

ORA-16014 log not archived, no available destinations

Posted on October 7, 2009 by Gary

If you cannot archive your logs, you will get an error as below. SQL> alter database open; alter database open* ERROR at line 1: ORA-16014: log 4 sequence# 3874 not archived, no available destinations ORA-00312: online log 4 thread 1:’D:ORACLEFLASH_RECOVERY_AREARTNEONLINELOGO1_MF_4_5BWL0XDH_.LOG’ … Continue reading →

Email
Posted in Configuration., DataGuard, Errors, Oracle, Parameters, Standby | Tagged , , , | Comments Off

ORA-12170: TNS:Connect timeout occurred in pending transations.

Posted on September 29, 2009 by Gary

We were continually getting alert errors similar to: Tue Sep 29 12:47:23 2009Errors in file /oracle/ora926/OraHome/admin/hist10g/bdump/hist10g_reco_741702.trc:ORA-12170: TNS:Connect timeout occurredoracle@historydb || DB=hist10g

Email
Posted in Configuration., Errors, Networking, Oracle | Tagged | Comments Off

RMAN-03002, PLS-00553, rman restore

Posted on January 23, 2008 by Gary

I found an interesting error, PLS-00553

Email
Posted in Errors, Oracle, Recovery Manager | Tagged , , , | Comments Off