Home
All Oracle Error Codes
Oracle DBA Forum

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

[suse-oracle] ORA-00600: internal error code, arguments: [3005], [1], [2016], [34412], [0], [0

�? 搴��

2006-09-04

Replies:
oracle 10.2.0.1
sles9 sp2
part of alter.log :
Errors in file /opt/oracle/admin/history/bdump/history_smon_6925.trc:
ORA-01115: Message 1115 not found; No message file for product=RDBMS,
facility=ORA; arguments: [1] [3770]
ORA-01110: Message 1110 not found; No message file for product=RDBMS,
facility=ORA; arguments: [1] [/opt/oracle/oradata/history/system01.dbf]
ORA-27091: Message 27091 not found; No message file for product=RDBMS,
facility=ORA
ORA-27072: Message 27072 not found; No message file for product=RDBMS,
facility=ORA
Linux Error: 5: Input/output error
Additional information: 4
Additional information: 3769
Additional information: -1
Fri Sep 1 16:14:00 2006
Waiting for Job queue slaves to complete
Fri Sep 1 16:14:00 2006
Job queue slave processes stopped
All dispatchers and shared servers shutdown
Fri Sep 1 16:14:04 2006
ALTER DATABASE CLOSE NORMAL
ORA-1115 signalled during: ALTER DATABASE CLOSE NORMAL...
Fri Sep 1 16:14:08 2006
Errors in file /opt/oracle/admin/history/bdump/history_smon_6925.trc:
ORA-01115: Message 1115 not found; No message file for product=RDBMS,
facility=ORA; arguments: [1] [3770]
ORA-01110: Message 1110 not found; No message file for product=RDBMS,
facility=ORA; arguments: [1] [/opt/oracle/oradata/history/system01.dbf]
ORA-27091: Message 27091 not found; No message file for product=RDBMS,
facility=ORA
ORA-27072: Message 27072 not found; No message file for product=RDBMS,
facility=ORA
Linux Error: 5: Input/output error
Additional information: 4
Additional information: 3769
Additional information: -1
Fri Sep 1 16:21:23 2006
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Picked latch-free SCN scheme 2
Using LOG_ARCHIVE_DEST_10 parameter default value as
USE_DB_RECOVERY_FILE_DEST
Autotune of undo retention is turned on.
IMODE=BR
ILAT =18
LICENSE_MAX_USERS = 0
SYS auditing is disabled
ksdpec: called for event 13740 prior to event group initialization
Starting up ORACLE RDBMS Version: 10.2.0.1.0.
System parameters with non-default values:
processes           = 150
__shared_pool_size     = 402653184
__large_pool_size     = 16777216
__java_pool_size      = 16777216
__streams_pool_size    = 50331648
nls_language         = SIMPLIFIED CHINESE
nls_territory        = CHINA
sga_target          = 2046820352
control_files        = /opt/oracle/oradata/history/control01.ctl,
/opt/oracle/oradata1/history/control02.ctl,
/opt/oracle/oradata2/history/control03.ctl
db_block_size        = 8192
__db_cache_size       = 1543503872
compatible          = 10.2.0.1.0
db_files           = 65534
db_file_multiblock_read_count= 16
db_recovery_file_dest   = /opt/oracle/flash_recovery_area
db_recovery_file_dest_size= 107374182400
undo_management       = AUTO
undo_tablespace       = UNDOTBS1
remote_login_passwordfile= EXCLUSIVE
db_domain           =
dispatchers         = (PROTOCOL=TCP) (SERVICE=historyXDB)
job_queue_processes    = 10
background_dump_dest   = /opt/oracle/admin/history/bdump
user_dump_dest       = /opt/oracle/admin/history/udump
core_dump_dest       = /opt/oracle/admin/history/cdump
audit_file_dest       = /opt/oracle/admin/history/adump
sort_area_size       = 1048576
db_name            = history
open_cursors         = 300
pga_aggregate_target   = 679477248
Fri Sep 1 16:21:27 2006
WARNING:Oracle instance running on a system with low open file descriptor
    limit. Tune your system to increase this limit to avoid
    severe performance degradation.
PMON started with pid=2, OS id=6935
PSP0 started with pid=3, OS id=6937
MMAN started with pid=4, OS id=6939
DBW0 started with pid=5, OS id=6941
LGWR started with pid=6, OS id=6943
CKPT started with pid=7, OS id=6945
SMON started with pid=8, OS id=6947
RECO started with pid=9, OS id=6949
CJQ0 started with pid=10, OS id=6951
MMON started with pid=11, OS id=6953
Fri Sep 1 16:21:28 2006
starting up 1 dispatcher(s) for network address
'(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
MMNL started with pid=12, OS id=6955
Fri Sep 1 16:21:28 2006
starting up 1 shared server(s) ...
Fri Sep 1 16:21:29 2006
ALTER DATABASE  MOUNT
Fri Sep 1 16:21:34 2006
Setting recovery target incarnation to 2
Fri Sep 1 16:21:34 2006
Successful mount of redo thread 1, with mount id 228937929
Fri Sep 1 16:21:34 2006
Database mounted in Exclusive Mode
Completed: ALTER DATABASE  MOUNT
Fri Sep 1 16:21:34 2006
ALTER DATABASE OPEN
Fri Sep 1 16:22:43 2006
Beginning crash recovery of 1 threads
parallel recovery started with 3 processes
Fri Sep 1 16:22:44 2006
Started redo scan
Fri Sep 1 16:22:44 2006
Errors in file /opt/oracle/admin/history/udump/history_ora_6961.trc:
ORA-00600: internal error code, arguments: [3005], [1], [2016], [34412],
[0], [0], [], []
Fri Sep 1 16:22:45 2006
Aborting crash recovery due to error 600
Fri Sep 1 16:22:45 2006
Errors in file /opt/oracle/admin/history/udump/history_ora_6961.trc:
ORA-00600: internal error code, arguments: [3005], [1], [2016], [34412],
[0], [0], [], []
ORA-600 signalled during: ALTER DATABASE OPEN...
Fri Sep 1 16:30:37 2006


sos , i need to recover it .

i haven't backup. Database is archivelog mode , has a month's archivelog.
can anyone give me some suggestion?

_________________________________________________________________
???????????????????????????? MSN Messenger: http://messenger.msn.com/cn


--
To unsubscribe, email: suse-oracle-unsubscribe@(protected)
For additional commands, email: suse-oracle-help@(protected)
Please see http://www.suse.com/oracle/ before posting