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

Re: [suse-oracle] SLES 9 Oracle 10g Instance Crash opteron

Seah Hong Yee

2005-07-11

Replies:
Ok, the log is pretty big but I isolate an incident around 2am 7/72005, before
and after around that time.

Current log# 1 seq# 107 mem# 0: /u01/app/oracle/oradata/compiere/redo01.log
Thu Jul 7 00:21:54 2005
Private_strands 3 at log switch
Thread 1 advanced to log sequence 108
Current log# 2 seq# 108 mem# 0: /u01/app/oracle/oradata/compiere/redo02.log
Thu Jul 7 01:42:40 2005
Private_strands 3 at log switch
Thread 1 advanced to log sequence 109
Current log# 3 seq# 109 mem# 0: /u01/app/oracle/oradata/compiere/redo03.log
Thu Jul 7 02:00:13 2005
Starting background process EMN0
EMN0 started with pid=48, OS id=3244
Thu Jul 7 02:00:13 2005
Shutting down instance: further logons disabled
Thu Jul 7 02:00:14 2005
Stopping background process CJQ0
Thu Jul 7 02:00:14 2005
Stopping background process QMNC
Thu Jul 7 02:00:48 2005
Stopping background process MMNL
Thu Jul 7 02:00:49 2005
Stopping background process MMON
Thu Jul 7 02:00:50 2005
Errors in file /u01/app/oracle/admin/compiere/udump/compiere_ora_3242.trc:
ORA-00604: error occurred at recursive SQL level 1
ORA-06521: PL/SQL: Error mapping function
ORA-06512: at "SYS.OLAPIHISTORYRETENTION", line 1
ORA-06512: at line 6
Thu Jul 7 02:00:50 2005
Shutting down instance (immediate)
License high water mark = 31
Thu Jul 7 02:00:50 2005
Stopping Job queue slave processes
Thu Jul 7 02:00:50 2005
Job queue slave processes stopped
All dispatchers and shared servers shutdown
Thu Jul 7 02:00:56 2005
ALTER DATABASE CLOSE NORMAL
Thu Jul 7 02:00:56 2005
SMON: disabling tx recovery
SMON: disabling cache recovery
Thu Jul 7 02:00:56 2005
Shutting down archive processes
Archiving is disabled
Archive process shutdown avoided: 0 active
Thread 1 closed at log sequence 109
Successful close of redo thread 1
Thu Jul 7 02:00:56 2005
Completed: ALTER DATABASE CLOSE NORMAL
Thu Jul 7 02:00:56 2005
ALTER DATABASE DISMOUNT
Completed: ALTER DATABASE DISMOUNT
ARCH: Archival disabled due to shutdown: 1089
Shutting down archive processes
Archiving is disabled
Archive process shutdown avoided: 0 active
ARCH: Archival disabled due to shutdown: 1089
Shutting down archive processes
Archiving is disabled
Archive process shutdown avoided: 0 active
Thu Jul 7 02:00:58 2005
Starting ORACLE instance (normal)
Thu Jul 7 02:00:58 2005
Running with 1 strand for Non-Enterprise Edition
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Picked latch-free SCN scheme 1
KCCDEBUG_LEVEL = 0
Using LOG_ARCHIVE_DEST_10 parameter default value as USE_DB_RECOVERY_FILE_DEST
Autotune of undo retention is turned on.
Running with 1 strand for Non-Enterprise Edition
Dynamic strands is set to FALSE
Running with 1 shared and 18 private strand(s). Zero-copy redo is FALSE
IMODE=BR
ILAT =18
LICENSE_MAX_USERS = 0
SYS auditing is disabled
Starting up ORACLE RDBMS Version: 10.1.0.3.0.
System parameters with non-default values:
processes           = 150
__shared_pool_size     = 155189248
__large_pool_size     = 4194304
__java_pool_size      = 16777216
sga_target          = 603979776
control_files        
= /u01/app/oracle/oradata/compiere/control01.ctl, /u0
1/app/oracle/oradata/compiere/control02.ctl, /u01/app/oracle/oradata/compiere/co
ntrol03.ctl
db_block_size        = 8192
__db_cache_size       = 423624704
compatible          = 10.1.0.2.0
db_file_multiblock_read_count= 16
db_recovery_file_dest   = /u01/app/oracle/flash_recovery_area/
db_recovery_file_dest_size= 2147483648
undo_management       = AUTO
undo_tablespace       = UNDOTBS1
remote_login_passwordfile= EXCLUSIVE
db_domain           = polyscientific.com.my
dispatchers         = (PROTOCOL=TCP) (SERVICE=compiereXDB)
job_queue_processes    = 10
background_dump_dest   = /u01/app/oracle/admin/compiere/bdump
user_dump_dest       = /u01/app/oracle/admin/compiere/udump
core_dump_dest       = /u01/app/oracle/admin/compiere/cdump
db_name            = compiere
open_cursors         = 300
pga_aggregate_target   = 200278016
PMON started with pid=2, OS id=3260
MMAN started with pid=3, OS id=3262
DBW0 started with pid=4, OS id=3264
LGWR started with pid=5, OS id=3266
CKPT started with pid=6, OS id=3268
SMON started with pid=7, OS id=3270
RECO started with pid=8, OS id=3272
Thu Jul 7 02:00:59 2005
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)
(PROTOCOL
=TCP))'...
CJQ0 started with pid=9, OS id=3274
Thu Jul 7 02:00:59 2005
starting up 1 shared server(s) ...
Oracle Data Guard is not available in this edition of Oracle.
Thu Jul 7 02:00:59 2005
ALTER DATABASE  MOUNT
Thu Jul 7 02:00:59 2005
Controlfile identified with block size 16384
Thu Jul 7 02:01:03 2005
Setting recovery target incarnation to 2
Thu Jul 7 02:01:03 2005
Successful mount of redo thread 1, with mount id 3919384091
Thu Jul 7 02:01:03 2005
Database mounted in Exclusive Mode.
Completed: ALTER DATABASE  MOUNT
Thu Jul 7 02:01:05 2005
db_recovery_file_dest_size of 2048 MB is 44.38% used. This is a
user-specified limit on the amount of space that will be used by this
database for recovery-related files, and does not reflect the amount of
space available in the underlying filesystem or ASM diskgroup.
Incremental restore complete of datafile 2 to datafile
copy /u01/app/oracle/flas
h_recovery_area/COMPIERE/datafile/o1_mf_undotbs1_02dycwoh_.dbf
checkpoint is 938084
Incremental restore complete of datafile 4 to datafile
copy /u01/app/oracle/flas
h_recovery_area/COMPIERE/datafile/o1_mf_users_02dyczrh_.dbf
checkpoint is 938084
Incremental restore complete of datafile 3 to datafile
copy /u01/app/oracle/flas
h_recovery_area/COMPIERE/datafile/o1_mf_sysaux_02dyc3kr_.dbf
checkpoint is 938084
Incremental restore complete of datafile 1 to datafile
copy /u01/app/oracle/flas
h_recovery_area/COMPIERE/datafile/o1_mf_system_02dyb0ds_.dbf
checkpoint is 938084
Thu Jul 7 02:01:52 2005
Created Oracle managed
file /u01/app/oracle/flash_recovery_area/COMPIERE/backups
et/2005_07_07/o1_mf_nnnd1_TAG20050707T020120_1dr73jyd_.bkp
Created Oracle managed
file /u01/app/oracle/flash_recovery_area/COMPIERE/backups
et/2005_07_07/o1_mf_ncsn1_TAG20050707T020120_1dr74ng9_.bkp
Thu Jul 7 02:10:37 2005
Shutting down instance: further logons disabled
Thu Jul 7 02:10:37 2005
Shutting down instance (immediate)
Thu Jul 7 02:10:37 2005
Stopping background process CJQ0
License high water mark = 4
Thu Jul 7 02:10:37 2005
Stopping Job queue slave processes
Thu Jul 7 02:10:37 2005
Job queue slave processes stopped
Waiting for shared server 'S000' to die
All dispatchers and shared servers shutdown
Thu Jul 7 02:10:38 2005
ALTER DATABASE CLOSE NORMAL
ORA-1109 signalled during: ALTER DATABASE CLOSE NORMAL...
Thu Jul 7 02:10:38 2005
ALTER DATABASE DISMOUNT
Completed: ALTER DATABASE DISMOUNT
ARCH: Archival disabled due to shutdown: 1089
Shutting down archive processes
Archiving is disabled
Archive process shutdown avoided: 0 active
ARCH: Archival disabled due to shutdown: 1089
Shutting down archive processes
Archiving is disabled
Archive process shutdown avoided: 0 active
Thu Jul 7 02:10:48 2005
Starting ORACLE instance (normal)
Thu Jul 7 02:10:48 2005
Running with 1 strand for Non-Enterprise Edition
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Picked latch-free SCN scheme 1
KCCDEBUG_LEVEL = 0
Using LOG_ARCHIVE_DEST_10 parameter default value as USE_DB_RECOVERY_FILE_DEST
Autotune of undo retention is turned on.
Running with 1 strand for Non-Enterprise Edition
Dynamic strands is set to FALSE
Running with 1 shared and 18 private strand(s). Zero-copy redo is FALSE
IMODE=BR
ILAT =18
LICENSE_MAX_USERS = 0
SYS auditing is disabled
Starting up ORACLE RDBMS Version: 10.1.0.3.0.
System parameters with non-default values:
processes           = 150
__shared_pool_size     = 155189248
__large_pool_size     = 4194304
__java_pool_size      = 16777216
sga_target          = 603979776
control_files        
= /u01/app/oracle/oradata/compiere/control01.ctl, /u0
1/app/oracle/oradata/compiere/control02.ctl, /u01/app/oracle/oradata/compiere/co
ntrol03.ctl
db_block_size        = 8192
__db_cache_size       = 423624704
compatible          = 10.1.0.2.0
db_file_multiblock_read_count= 16
db_recovery_file_dest   = /u01/app/oracle/flash_recovery_area/
db_recovery_file_dest_size= 2147483648
undo_management       = AUTO
undo_tablespace       = UNDOTBS1
remote_login_passwordfile= EXCLUSIVE
db_domain           = polyscientific.com.my
dispatchers         = (PROTOCOL=TCP) (SERVICE=compiereXDB)
job_queue_processes    = 10
background_dump_dest   = /u01/app/oracle/admin/compiere/bdump
user_dump_dest       = /u01/app/oracle/admin/compiere/udump
core_dump_dest       = /u01/app/oracle/admin/compiere/cdump
db_name            = compiere
open_cursors         = 300
pga_aggregate_target   = 200278016
PMON started with pid=2, OS id=5750
MMAN started with pid=3, OS id=5752
DBW0 started with pid=4, OS id=5754
LGWR started with pid=5, OS id=5756
CKPT started with pid=6, OS id=5758
SMON started with pid=7, OS id=5760
RECO started with pid=8, OS id=5762
Thu Jul 7 02:10:48 2005
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)
(PROTOCOL
=TCP))'...
CJQ0 started with pid=9, OS id=5764
Thu Jul 7 02:10:48 2005
starting up 1 shared server(s) ...
Oracle Data Guard is not available in this edition of Oracle.
Thu Jul 7 02:10:48 2005
ALTER DATABASE  MOUNT
Thu Jul 7 02:10:48 2005
Controlfile identified with block size 16384
Thu Jul 7 02:10:52 2005
Setting recovery target incarnation to 2
Thu Jul 7 02:10:53 2005
Successful mount of redo thread 1, with mount id 3919392616
Thu Jul 7 02:10:53 2005
Database mounted in Exclusive Mode.
Completed: ALTER DATABASE  MOUNT
Thu Jul 7 02:10:53 2005
ALTER DATABASE OPEN
Thu Jul 7 02:10:53 2005
Maximum redo generation record size = 132096 bytes
Maximum redo generation change vector size = 116476 bytes
Private_strands 2 at log switch
Thread 1 opened at log sequence 109
Current log# 3 seq# 109 mem# 0: /u01/app/oracle/oradata/compiere/redo03.log
Successful open of redo thread 1
Thu Jul 7 02:10:53 2005
SMON: enabling cache recovery
Thu Jul 7 02:10:53 2005
Successfully onlined Undo Tablespace 1.
Thu Jul 7 02:10:53 2005
SMON: enabling tx recovery
Thu Jul 7 02:10:53 2005
Database Characterset is WE8ISO8859P1
Thu Jul 7 02:10:53 2005
Starting background process QMNC
QMNC started with pid=13, OS id=5775
Thu Jul 7 02:10:53 2005
replication_dependency_tracking turned off (no async multimaster replication
fou
nd)
Thu Jul 7 02:10:53 2005
Starting background process MMON
Starting background process MMNL
MMON started with pid=14, OS id=5777
MMNL started with pid=15, OS id=5779
Thu Jul 7 02:10:54 2005
Errors in file /u01/app/oracle/admin/compiere/udump/compiere_ora_5773.trc:
ORA-00604: error occurred at recursive SQL level 1
ORA-06521: PL/SQL: Error mapping function
ORA-06512: at "SYS.OLAPIHISTORYRETENTION", line 1
ORA-06512: at line 7
Thu Jul 7 02:10:54 2005
Completed: ALTER DATABASE OPEN
Thu Jul 7 02:10:57 2005
db_recovery_file_dest_size of 2048 MB is 44.89% used. This is a
user-specified limit on the amount of space that will be used by this
database for recovery-related files, and does not reflect the amount of
space available in the underlying filesystem or ASM diskgroup.
Thu Jul 7 02:13:52 2005
alter database open
Thu Jul 7 02:13:52 2005
ORA-1531 signalled during: alter database open...
Thu Jul 7 03:00:04 2005
Private_strands 3 at log switch
Thread 1 advanced to log sequence 110
Current log# 1 seq# 110 mem# 0: /u01/app/oracle/oradata/compiere/redo01.log
Thu Jul 7 04:00:38 2005
Private_strands 3 at log switch
Thread 1 advanced to log sequence 111
Current log# 2 seq# 111 mem# 0: /u01/app/oracle/oradata/compiere/redo02.log
Thu Jul 7 05:12:38 2005
Private_strands 3 at log switch
Thread 1 advanced to log sequence 112
Current log# 3 seq# 112 mem# 0: /u01/app/oracle/oradata/compiere/redo03.log
Thu Jul 7 06:42:33 2005
Private_strands 3 at log switch
Thread 1 advanced to log sequence 113
Current log# 1 seq# 113 mem# 0: /u01/app/oracle/oradata/compiere/redo01.log
Thu Jul 7 08:00:19 2005
Private_strands 3 at log switch
Thread 1 advanced to log sequence 114
Current log# 2 seq# 114 mem# 0: /u01/app/oracle/oradata/compiere/redo02.log
Thu Jul 7 09:12:41 2005
Private_strands 3 at log switch
Thread 1 advanced to log sequence 115
Current log# 3 seq# 115 mem# 0: /u01/app/oracle/oradata/compiere/redo03.log
Thu Jul 7 10:47:36 2005
Private_strands 3 at log switch

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