errors from alert.log

Links

Frequent Oracle Errors

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

errors from alert.log

errors from alert.log

2004-06-07 - By Nguyen, David M

Reply: 1 2 3 4 5

I receive following errors from alert.log. I 'd like to know root cause
of the error and how to fix it. Please help.

We have oracle8.0.5 running on solaris8.

ORA-12012 (See ORA-12012.ora-code.com): error on auto execute of job 125

ORA-12008 (See ORA-12008.ora-code.com): error in snapshot refresh path

ORA-00942 (See ORA-00942.ora-code.com): table or view does not exist

ORA-02063 (See ORA-02063.ora-code.com): preceding line from SSDB.PBNA0

ORA-06512 (See ORA-06512.ora-code.com): at "SYS.DBMS_SNAPSHOT ", line 386

ORA-06512 (See ORA-06512.ora-code.com): at "SYS.DBMS_IREFRESH ", line 450

ORA-06512 (See ORA-06512.ora-code.com): at "SYS.DBMS_REFRESH ", line 182

ORA-06512 (See ORA-06512.ora-code.com): at line 1

ORA-12012 (See ORA-12012.ora-code.com): error on auto execute of job 124

ORA-12008 (See ORA-12008.ora-code.com): error in snapshot refresh path

ORA-00942 (See ORA-00942.ora-code.com): table or view does not exist

ORA-02063 (See ORA-02063.ora-code.com): preceding line from SSDB.PBNA0

ORA-06512 (See ORA-06512.ora-code.com): at "SYS.DBMS_SNAPSHOT ", line 386

ORA-06512 (See ORA-06512.ora-code.com): at "SYS.DBMS_IREFRESH ", line 450

ORA-06512 (See ORA-06512.ora-code.com): at "SYS.DBMS_REFRESH ", line 182

ORA-06512 (See ORA-06512.ora-code.com): at line 1

Thanks,
David

<html >

<head >
<META HTTP-EQUIV= "Content-Type " CONTENT= "text/html; charset=us-ascii " >

<meta name=Generator content= "Microsoft Word 10 (filtered) " >

<style >
<!--
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
 {margin:0in;
 margin-bottom:.0001pt;
 font-size:12.0pt;
 font-family: "Times New Roman ";}
a:link, span.MsoHyperlink
 {color:blue;
 text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
 {color:navy;
 text-decoration:underline;}
span.EmailStyle17
 {font-family:Arial;
 color:windowtext;}
@(protected) Section1
 {size:8.5in 11.0in;
 margin:1.0in 1.25in 1.0in 1.25in;}
div.Section1
 {page:Section1;}
-- >
</style >

</head >

<body lang=EN-US link=blue vlink=navy >

<div class=Section1 >

 I receive following errors from alert.log. I’d like
to know root cause of the error and how to fix it. Please help. 

 We have oracle8.0.5 running on solaris8. 

 

 ORA-12012 (See ORA-12012.ora-code.com): error on auto
execute of job 125 

 ORA-12008 (See ORA-12008.ora-code.com): error in
snapshot refresh path 

 ORA-00942 (See ORA-00942.ora-code.com): table or view
does not exist 

 ORA-02063 (See ORA-02063.ora-code.com): preceding line
from SSDB.PBNA0 

 ORA-06512 (See ORA-06512.ora-code.com): at
"SYS.DBMS_SNAPSHOT", line 386 

 ORA-06512 (See ORA-06512.ora-code.com): at
"SYS.DBMS_IREFRESH", line 450 

 ORA-06512 (See ORA-06512.ora-code.com): at
"SYS.DBMS_REFRESH", line 182 

 ORA-06512 (See ORA-06512.ora-code.com): at line 1 

 ORA-12012 (See ORA-12012.ora-code.com): error on auto
execute of job 124 

 ORA-12008 (See ORA-12008.ora-code.com): error in
snapshot refresh path 

 ORA-00942 (See ORA-00942.ora-code.com): table or view
does not exist 

 ORA-02063 (See ORA-02063.ora-code.com): preceding line
from SSDB.PBNA0 

 ORA-06512 (See ORA-06512.ora-code.com): at
"SYS.DBMS_SNAPSHOT", line 386 

 ORA-06512 (See ORA-06512.ora-code.com): at
"SYS.DBMS_IREFRESH", line 450 

 ORA-06512 (See ORA-06512.ora-code.com): at
"SYS.DBMS_REFRESH", line 182 

 ORA-06512 (See ORA-06512.ora-code.com): at line 1 

 

 Thanks, 
David 

 

</div >

</body >

</html >