dev db issues

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

dev db issues

dev db issues

2005-10-13 - By O'Donnell, Kevin

Reply: 1 2

Hello all, I have a dev db that uses iscsi. The box lost power today and
is now complaining about being out of sync with the redo logs

ORA-00283 (See ORA-00283.ora-code.com): recovery session canceled due to errors

ORA-00314 (See ORA-00314.ora-code.com): log 2 of thread 1, expected sequence# 9134 doesn't match 9136

ORA-00312 (See ORA-00312.ora-code.com): online log 2 thread 1: '/ora_base/oradata/dirx/redo02a.log'

SQL> archive log list;

Database log mode No Archive Mode

Automatic archival Disabled

Archive destination
/ora_base/app/oracle/product/10.1/db/dbs/arch

Oldest online log sequence 9133

Current log sequence 9134

I have never seen this in a db. Any suggestions? Could it of been from
the power loss?

Kevin O'Donnell

Sr. Database Administrator

Neighborcare Technology Center

Cell: 443-257-3323

Office: 410-534-1959

e-mail: kevin.odonnell@(protected)

<html xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas
-microsoft-com:office:word" xmlns:st1="urn:schemas-microsoft-com:office
:smarttags" xmlns="http://www.w3.org/TR/REC-html40">

<head>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=us-ascii">
<meta name=Generator content="Microsoft Word 11 (filtered medium)">
<o:SmartTagType namespaceuri="urn:schemas-microsoft-com:office:smarttags"
name="place"/>
<o:SmartTagType namespaceuri="urn:schemas-microsoft-com:office:smarttags"
name="PlaceType"/>
<o:SmartTagType namespaceuri="urn:schemas-microsoft-com:office:smarttags"
name="PlaceName"/>

<style>

</style>

</head>

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

<div class=Section1>

Hello all, I have a dev db that uses iscsi. The box lost
power today and is now complaining about being out of sync with the redo logs<o
:p></o:p>

<o:p> </o:p>

ORA-00283 (See ORA-00283.ora-code.com): recovery session canceled due to errors<o:p></o
:p>

ORA-00314 (See ORA-00314.ora-code.com): log 2 of thread 1, expected sequence# 9134
doesn't match 9136<o:p></o:p>

ORA-00312 (See ORA-00312.ora-code.com): online log 2 thread 1:
'/ora_base/oradata/dirx/redo02a.log'<o:p></o:p>

<o:p> </o:p>

SQL> archive log list;<o:p></o:p>

Database log mode       
       No Archive Mode<o:p></o:p>

Automatic archival      &nbsp
;      Disabled<o:p></o:p>

Archive destination      
     
/ora_base/app/oracle/product/10.1/db/dbs/arch<o:p></o:p>

Oldest online log sequence     9133<o:p
></o:p>

Current log sequence      
     9134<o:p></o:p>

<o:p> </o:p>

I have never seen this in a db. Any suggestions? Could it
of been from the power loss?<o:p></o:p>

<o:p> </o:p>

Kevin O’Donnell<o:p></o:p>

Sr. Database Administrator<o:p></o:p>

<st1:place w:st="on"><st1:PlaceName w:st="on">Neighborcare</st1:PlaceName> <st1
:PlaceName
w:st="on">Technology</st1:PlaceName> <st1:PlaceType w:st="on">Center</st1
:PlaceType></st1:place><o:p></o:p
>

<o:p> </o:p>

Cell: 443-257-3323<o:p></o:p>

Office: 410-534-1959<o:p></o:p>

e-mail: kevin.odonnell@(protected) <o:p></o:p
>

<o:p> </o:p>

</div>

</body>

</html>