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

刚吃完饭，厦门同事打来电话说数据库有问题，说很短时间内就把磁盘空间占满了。登到服务器上查看，日志文件，错误如下：
........
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/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/22779291/viewspace-694607/