ITPub博客

首页 > Linux操作系统 > Linux操作系统 > 记一次主机名与hosts不一致导致日志占满磁盘空间

记一次主机名与hosts不一致导致日志占满磁盘空间

原创 Linux操作系统 作者:frog-qs 时间:2011-05-06 13:21:45 0 删除 编辑
刚吃完饭,厦门同事打来电话说数据库有问题,说很短时间内就把磁盘空间占满了。登到服务器上查看,日志文件,错误如下:
........
dispatcher 'D000' encountered error getting listening address
Fri May  6 12:34:43 2011
Errors in file /opt/oracle/admin/orcl/bdump/orcl_ora_11851.trc:
ORA-07445: exception encountered: core dump [kslgetl()+80] [SIGSEGV] [Address not mapped to object] [0x130] [] []
ORA-00108: failed to set up dispatcher to accept connection asynchronously
Fri May  6 12:34:46 2011
found dead dispatcher 'D000', pid = (21, 20)
Fri May  6 12:34:46 2011
dispatcher 'D000' encountered error getting listening address
Fri May  6 12:34:46 2011
Errors in file /opt/oracle/admin/orcl/bdump/orcl_ora_11861.trc:
ORA-07445: exception encountered: core dump [kslgetl()+80] [SIGSEGV] [Address not mapped to object] [0x130] [] []
ORA-00108: failed to set up dispatcher to accept connection asynchronously
Fri May  6 12:34:49 2011
found dead dispatcher 'D000', pid = (21, 21)
Fri May  6 12:34:49 2011
dispatcher 'D000' encountered error getting listening address
Fri May  6 12:34:49 2011
Errors in file /opt/oracle/admin/orcl/bdump/orcl_ora_11865.trc:
ORA-07445: exception encountered: core dump [kslgetl()+80] [SIGSEGV] [Address not mapped to object] [0x130] [] []
ORA-00108: failed to set up dispatcher to accept connection asynchronously
Fri May  6 12:34:52 2011
found dead dispatcher 'D000', pid = (21, 22)
Fri May  6 12:34:52 2011
dispatcher 'D000' encountered error getting listening address
Fri May  6 12:34:52 2011
..................
检查hosts文件和主机名对比,发现不对,更改hosts文件。重启数据库错误信息消失。
但是在启动数据库的时候出现ORA-32004报错
oracle@LS42-202-WEDB:~/admin/orcl/bdump> sqlplus / as sysdba
SQL*Plus: Release 10.2.0.4.0 - Production on Fri May 6 12:38:41 2011
Copyright (c) 1982, 2007, Oracle.  All Rights Reserved.
Connected to an idle instance.
SQL> startup
ORA-32004: obsolete and/or deprecated parameter(s) specified
ORACLE instance started.
Total System Global Area 1610612736 bytes
Fixed Size                  1267740 bytes
Variable Size             922748900 bytes
Database Buffers          671088640 bytes
Redo Buffers               15507456 bytes
Database mounted.
Database opened.
oracle@LS42-202-WEDB:~/admin/orcl/bdump> oerr ora 32004
32004, 00000, "obsolete and/or deprecated parameter(s) specified"
// *Cause:  One or more obsolete and/or parameters were specified in
//          the SPFILE or the PFILE on the server side.
// *Action: See alert log for a list of parameters that are obsolete.
//          or deprecated. Remove them from the SPFILE or the server
//          side PFILE.
查看alert日志文件
Deprecated system parameters with specified values:  log_archive_start
End of deprecated system parameter listing
在10g中,Log_archive_start参数被弃用。
重新设置log_archive_start参数
SQL> ALTER SYSTEM RESET log_archive_start SCOPE=SPFILE SID='*';

System altered.
SQL> SQL>
SQL>
SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup
ORACLE instance started.
Total System Global Area 1610612736 bytes
Fixed Size                  1267740 bytes
Variable Size             922748900 bytes
Database Buffers          671088640 bytes
Redo Buffers               15507456 bytes
Database mounted.
Database opened.
SQL>
查看弃用的参数
select name,description from v$parameter where  where isdeprecated='TRUE';
NAME            DESCRIPTION
--------------- -----------------------------------
lock_name_space lock name space used for generating
                 lock names for standby/clone datab
                ase
buffer_pool_kee Number of database blocks/latches i
p               n keep buffer pool
buffer_pool_rec Number of database blocks/latches i
ycle            n recycle buffer pool
max_commit_prop Max age of new snapshot in .01 seco
NAME            DESCRIPTION
--------------- -----------------------------------
agation_delay   nds
remote_archive_ remote archival enable setting
enable
log_archive_sta start archival process on SGA initi
rt              alization
parallel_server if TRUE startup in parallel server
                mode

NAME            DESCRIPTION
--------------- -----------------------------------
parallel_server number of instances to use for sizi
_instances      ng OPS SGA structures
fast_start_io_t Upper bound on recovery reads
arget
logmnr_max_pers maximum number of threads to mine
istent_sessions
serial_reuse    reuse the frame. segments
max_enabled_rol max number of roles a user can have
NAME            DESCRIPTION
--------------- -----------------------------------
es               enabled
global_context_ Global Application Context Pool Siz
pool_size       e in Bytes
plsql_compiler_ PL/SQL compiler flags
flags
sql_trace       enable SQL trace
parallel_automa enable intelligent defaults for par
tic_tuning      allel execution parameters
NAME            DESCRIPTION
--------------- -----------------------------------
drs_start       start DG Broker monitor (DMON proce
                ss)

17 rows selected.

来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/22779291/viewspace-694607/,如需转载,请注明出处,否则将追究法律责任。

上一篇: ora-00845
下一篇: 有点乱
请登录后发表评论 登录
全部评论

注册时间:2009-10-27

  • 博文量
    132
  • 访问量
    243156