In addition to Weibo, there is also WeChat
Please pay attention
WeChat public account
Shulou
2025-04-06 Update From: SLTechnology News&Howtos shulou NAV: SLTechnology News&Howtos > Database >
Share
Shulou(Shulou.com)06/01 Report--
Failure phenomenon:
ORALCE Startup Times made the following error:
ORA-03113: end-of-file on communication channel
SQL > startup
ORACLE instance started.
Total System Global Area 3657797632 bytes
Fixed Size 2258600 bytes
Variable Size 2013268312 bytes
Database Buffers 1627389952 bytes
Redo Buffers 14880768 bytes
Database mounted.
ORA-03113: end-of-file on communication channel
Process ID: 2118
Session ID: 401 Serial number: 5
SQL > startup mount
ORA-24324: service handle not initialized
ORA-01041: internal error. Hostdef extension doesn't exist
Reason lookup:
Check the orcle startup log to determine exactly what caused the error.
Cd $ORACLE_HOME/diag/rdbms/ncdbemu/ncdbemu/trace/
Ls-alcr | grep alert (c time order, r reverse order) to locate the startup log. Open the content for a long time, and it's hard to find. So use tracking to find it.
Tail-f-n 500 alert_ncdbemu.log then restart and run the above startup command, and the trace results as follows.
ARC3 started with pid=23, OS id=2126
Errors in file / oracle/app/oracle/diag/rdbms/ncdbemu/ncdbemu/trace/ncdbemu_ora_2118.trc:
ORA-19815: WARNING: db_recovery_file_dest_size of 20971520000 bytes is 100.005% used, and has 0 remaining bytes available.
*
You have following choices to free up space from recovery area:
1. Consider changing RMAN RETENTION POLICY. If you are using Data Guard
Then consider changing RMAN ARCHIVELOG DELETION POLICY.
2. Back up files to tertiary device such as tape using RMAN
BACKUP RECOVERY AREA command.
3. Add disk space and increase db_recovery_file_dest_size parameter to
Reflect the new space.
4. Delete unnecessary files using RMAN DELETE command. If an operating
System command was used to delete files, then use RMAN CROSSCHECK and
DELETE EXPIRED commands.
*
ARCH: Error 19809 Creating archivelog file to'/ backup/fast_recovery_area/NCDBEMU/archivelog/2016_02_01/o1_mf_1_603_%u_.arc'
Errors in file / oracle/app/oracle/diag/rdbms/ncdbemu/ncdbemu/trace/ncdbemu_ora_2118.trc:
ORA-16038: log 3 sequence# 603 cannot be archived
ORA-19809: limit exceeded for recovery files
ORA-00312: online log 3 thread 1:'/ dbdata/oradata/ncdbemu/redog03m01.rdo'
ORA-00312: online log 3 thread 1:'/ dbdata/oradata/ncdbemu/redog03m02.rdo'
USER (ospid: 2118): terminating the instance due to error 16038
System state dump requested by (instance=1, osid=2118), summary= [abnormal instance termination].
System State dumped to trace file / oracle/app/oracle/diag/rdbms/ncdbemu/ncdbemu/trace/ncdbemu_diag_2087_20160201162949.trc
Dumping diagnostic data in directory= [CDMP _ 20160201162949], requested by (instance=1, osid=2118), summary= [abnormal instance termination].
Instance terminated by USER, pid = 2118
Mon Feb 01 16:33:49 2016
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Initial number of CPU is 2
CELL communication is configured to use 0 interface (s):
CELL IP affinity details:
NUMA status: non-NUMA system
Cellaffinity.ora status: N/A
CELL communication will use 1 IP group (s):
Grp 0:
Picked latch-free SCN scheme 3
Using LOG_ARCHIVE_DEST_1 parameter default value as USE_DB_RECOVERY_FILE_DEST
Autotune of undo retention is turned on.
IMODE=BR
ILAT = 88
LICENSE_MAX_USERS = 0
SYS auditing is disabled
Starting up:
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0-64bit Production
With the Partitioning, Oracle Label Security, OLAP, Data Mining
Oracle Database Vault and Real Application Testing options.
ORACLE_HOME = / oracle/app/oracle/dbhome
System name: Linux
Node name: NcDbEmulator
Release: 2.6.32-431.el6.x86_64
Version: # 1 SMP Sun Nov 10 22:19:54 EST 2013
Machine: x86_64
Using parameter settings in server-side spfile / oracle/app/oracle/dbhome/dbs/spfilencdbemu.ora
System parameters with non-default values:
Processes = 500,
Sessions = 800,
Memory_target = 3504m
Control_files = "/ dbdata/oradata/ncdbemu/control01.ctl"
Control_files = "/ backup/fast_recovery_area/ncdbemu/control02.ctl"
Control_files = "/ dbdata/oradata/ncdbemu/control03.ctl"
Db_block_size = 8192
Compatible = "11.2.0.4.0"
Log_archive_format = "% t_%s_%r.dbf"
Cluster_database = FALSE
Db_recovery_file_dest = "/ backup/fast_recovery_area"
Db_recovery_file_dest_size= 20000M
Undo_tablespace = "UNDOTBS1"
Remote_login_passwordfile= "EXCLUSIVE"
Db_domain = ""
Dispatchers = "(PROTOCOL=TCP) (SERVICE=ncdbemuXDB)"
Job_queue_processes = 1000
Audit_file_dest = "/ oracle/app/oracle/admin/ncdbemu/adump"
Audit_trail = "DB"
Db_name = "ncdbemu"
Open_cursors = 300
Diagnostic_dest = "/ oracle/app/oracle"
4. Solution
There are three: (in fact, four solutions have been given in the log above. )
1) set the archive to another directory and modify alter system set log_archive_dest = other path
2) transfer or delete the archive logs in the flashback recovery area.
3) increase the flashback recovery area. Alter system set db_recovery_file_dest_size=30G
Resolution of the second error (24324 and 01041):
Just log out of sqlplus and log in again.
5. Solution steps:
1) Boot to mount state
SQL > startup mount
ORA-24324: service handle not initialized
ORA-01041: internal error. Hostdef extension doesn't exist
SQL > startup nomount
ORA-24324: service handle not initialized
ORA-01041: internal error. Hostdef extension doesn't exist
SQL > exit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.4.0-64bit Production
With the Partitioning, Oracle Label Security, OLAP, Data Mining
Oracle Database Vault and Real Application Testing options
[oracle@NcDbEmulator ~] $sqlplus / as sysdba
SQL*Plus: Release 11.2.0.4.0 Production on Mon Feb 1 16:33:44 2016
Copyright (c) 1982, 2013, Oracle. All rights reserved.
Connected to an idle instance.
SQL > startup mount
ORACLE instance started.
Total System Global Area 3657797632 bytes
Fixed Size 2258600 bytes
Variable Size 2013268312 bytes
Database Buffers 1627389952 bytes
Redo Buffers 14880768 bytes
Database mounted.
2) View the location and size of the recovery area (flashback area):
SQL > show parameter db_recovery
NAME TYPE VALUE
-
Db_recovery_file_dest string / backup/fast_recovery_area
Db_recovery_file_dest_size big integer 20000M
SQL > show parameter flashback
NAME TYPE VALUE
-
Db_flashback_retention_target integer 1440
SQL > select file_type,PERCENT_SPACE_USED,NUMBER_OF_FILES from v$flash_recovery_area_usage
FILE_TYPE PERCENT_SPACE_USED NUMBER_OF_FILES
CONTROL FILE 0 0
REDO LOG 0 0
ARCHIVED LOG 99.85 595
BACKUP PIECE 0 0
IMAGE COPY 0 0
FLASHBACK LOG 0 0
FOREIGN ARCHIVED LOG 0 0
7 rows selected.
3) method 1, modify the size of the recovery area:
SQL > alter system set db_recovery_file_dest_size=30G
System altered.
SQL > show parameter db_recovery_file_dest_size
NAME TYPE VALUE
-
Db_recovery_file_dest_size big integer 30G
4) Open the database
SQL > alter database open
Database altered.
Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.
Views: 0
*The comments in the above article only represent the author's personal views and do not represent the views and positions of this website. If you have more insights, please feel free to contribute and share.
Continue with the installation of the previous hadoop.First, install zookooper1. Decompress zookoope
"Every 5-10 years, there's a rare product, a really special, very unusual product that's the most un
© 2024 shulou.com SLNews company. All rights reserved.