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 Tao Zuo

Reply: 1 2 3 4 5

suspect the master table is gone...

-- --Original Message-- --
From: oracle-l-bounce@(protected) [mailto:oracle-l-bounce@(protected)]On Behalf Of Nguyen, David M
Sent: Monday, June 07, 2004 5:04 PM
To: oracle-l@(protected)
Subject: errors from alert.log

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

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN " >
<HTML > <HEAD >
<META HTTP-EQUIV= "Content-Type " CONTENT= "text/html; charset=iso-8859-1 " >

<META content= "MSHTML 6.00.2800.1106 " name=GENERATOR >
<STYLE >@(protected) Section1 {size: 8.5in 11.0in; margin: 1.0in 1.25in 1.0in 1.25in; }
P.MsoNormal {
 FONT-SIZE: 12pt; MARGIN: 0in 0in 0pt; FONT-FAMILY: "Times New Roman "
}
LI.MsoNormal {
 FONT-SIZE: 12pt; MARGIN: 0in 0in 0pt; FONT-FAMILY: "Times New Roman "
}
DIV.MsoNormal {
 FONT-SIZE: 12pt; MARGIN: 0in 0in 0pt; FONT-FAMILY: "Times New Roman "
}
A:link {
 COLOR: blue; TEXT-DECORATION: underline
}
SPAN.MsoHyperlink {
 COLOR: blue; TEXT-DECORATION: underline
}
A:visited {
 COLOR: navy; TEXT-DECORATION: underline
}
SPAN.MsoHyperlinkFollowed {
 COLOR: navy; TEXT-DECORATION: underline
}
SPAN.EmailStyle17 {
 COLOR: windowtext; FONT-FAMILY: Arial
}
DIV.Section1 {
 page: Section1
}
</STYLE >
</HEAD >
<BODY lang=EN-US vLink=navy link=blue >
<DIV > suspect the master table is gone... </DIV >
<BLOCKQUOTE dir=ltr style= "MARGIN-RIGHT: 0px " >
<DIV class=OutlookMessageHeader dir=ltr align=left > -- --Original Message-- -- From: 
oracle-l-bounce@(protected) [mailto:oracle-l-bounce@(protected)] On
Behalf Of Nguyen, David M Sent: Monday, June 07, 2004 5:04
PM To: oracle-l@(protected) Subject: errors from
alert.log </DIV >
<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 > </BLOCKQUOTE > </BODY > </HTML >