oracle启动报错ORA-32004，查看alert日志，不知道怎么解决？

counter1219

ora-32004bsolete and/or deprecated parameter(s)specified
启动的alert日志里面的内容如下，怎么看出来是哪里的问题？
Mon Apr 28 10:04:20 2014
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Picked latch-free SCN scheme 3
Autotune of undo retention is turned on.
IMODE=BR
ILAT =218
LICENSE_MAX_USERS = 0
SYS auditing is disabled
Starting up ORACLE RDBMS Version: 11.1.0.7.0.
Using parameter settings in server-side pfile /oracle/app/product/11g/db/dbs/initora01.ora
System parameters with non-default values:
  processes                = 1800
  sessions                 = 1985
  sga_max_size             = 8G
  shared_pool_size         = 832M
  spfile                   = "/oratbs/lv_ora_spfile"
  nls_date_format          = "MM/DD/YYYY HH24:MI:SS"
  sga_target               = 4928M
  memory_target            = 8G
  memory_max_target        = 8G
  control_files            = "/oratbs/ora01/lv_ora_ctl01"
  control_files            = "/oratbs/ora01/lv_ora_ctl02"
  control_files            = "/oratbs/ora01/lv_ora_ctl03"
  db_block_size            = 8192
  compatible               = "11.1.0.0.0"
  log_archive_dest_1       = "LOCATION=/oratbs/ora_arch"
  log_archive_format       = "%t_%s_%r.dbf"
  log_buffer               = 3145728
  log_checkpoint_interval  = 0
  log_checkpoint_timeout   = 0
  archive_lag_target       = 7200
  db_recovery_file_dest    = ""
  fast_start_io_target     = 0
  fast_start_mttr_target   = 1800
  undo_tablespace          = "UNDOTBS1"
  undo_retention           = 1800
  remote_os_authent        = TRUE
  remote_login_passwordfile= "EXCLUSIVE"
  db_domain                = ""
  remote_listener          = ""
  parallel_max_servers     = 0
  audit_file_dest          = "/oracle/app/admin/ora01/adump"
  audit_trail              = "NONE"
  db_name                  = "ora01"
  open_cursors             = 300
  pga_aggregate_target     = 819M
  diagnostic_dest          = "/oracle/app"
  max_dump_file_size       = "1024K"
Deprecated system parameters with specified values:
  fast_start_io_target     
  remote_os_authent        
End of deprecated system parameter listing
Mon Apr 28 10:04:23 2014
PMON started with pid=2, OS id=15776
Mon Apr 28 10:04:23 2014
VKTM started with pid=3, OS id=15780
VKTM running at (100ms) precision
Mon Apr 28 10:04:23 2014
DIAG started with pid=4, OS id=15786
Mon Apr 28 10:04:23 2014
DBRM started with pid=5, OS id=15790
Mon Apr 28 10:04:23 2014
PSP0 started with pid=6, OS id=15794
Mon Apr 28 10:04:23 2014
DIA0 started with pid=7, OS id=15798
Mon Apr 28 10:04:23 2014
MMAN started with pid=8, OS id=15802
Mon Apr 28 10:04:23 2014
DBW0 started with pid=9, OS id=15806
Mon Apr 28 10:04:23 2014
DBW1 started with pid=10, OS id=15810
Mon Apr 28 10:04:23 2014
LGWR started with pid=11, OS id=15814
Mon Apr 28 10:04:23 2014
CKPT started with pid=12, OS id=15818
Mon Apr 28 10:04:23 2014
SMON started with pid=13, OS id=15822
Mon Apr 28 10:04:23 2014
RECO started with pid=14, OS id=15826
Mon Apr 28 10:04:23 2014
MMON started with pid=15, OS id=15830
Mon Apr 28 10:04:23 2014
MMNL started with pid=16, OS id=15834
ORACLE_BASE from environment = /oracle/app
Mon Apr 28 10:04:23 2014
ALTER DATABASE   MOUNT
Setting recovery target incarnation to 2
Successful mount of redo thread 1, with mount id 889439591
Database mounted in Exclusive Mode
Lost write protection disabled
Completed: ALTER DATABASE   MOUNT
Mon Apr 28 10:04:27 2014
ALTER DATABASE OPEN
Beginning crash recovery of 1 threads
parallel recovery setup failed: using serial mode
Started redo scan
Completed redo scan
1349 redo blocks read, 74 data blocks need recovery
Started redo application at
Thread 1: logseq 2481, block 26380
Recovery of Online Redo Log: Thread 1 Group 3 Seq 2481 Reading mem 0
  Mem# 0: /oratbs/ora01/lv_ora_redo3
Completed redo application of 0.23MB
Completed crash recovery at
Thread 1: logseq 2481, block 27729, scn 182130487
74 data blocks read, 74 data blocks written, 1349 redo blocks read
Thread 1 advanced to log sequence 2482 (thread open)
Thread 1 opened at log sequence 2482
  Current log# 4 seq# 2482 mem# 0: /oratbs/ora01/redo04.log
Successful open of redo thread 1
SMON: enabling cache recovery
Successfully onlined Undo Tablespace 2.
Verifying file header compatibility for 11g tablespace encryption..
Verifying 11g file header compatibility for tablespace encryption completed
SMON: enabling tx recovery
Database Characterset is AL32UTF8
Opening with internal Resource Manager plan
Starting background process FBDA
Mon Apr 28 10:04:32 2014
FBDA started with pid=18, OS id=16004
replication_dependency_tracking turned off (no async multimaster replication found)
Starting background process QMNC
Mon Apr 28 10:04:33 2014
QMNC started with pid=19, OS id=16016
Completed: ALTER DATABASE OPEN
Mon Apr 28 10:04:36 2014
Starting background process CJQ0
Mon Apr 28 10:04:36 2014
CJQ0 started with pid=24, OS id=16048
Mon Apr 28 10:14:34 2014
Starting background process SMCO
Mon Apr 28 10:14:34 2014
SMCO started with pid=25, OS id=19764

www_xylove

你看一下你的初始化参数，是否有问题。

jackson198574

最近做过什么数据库迁移或者是参数改动操作吗？

counter1219

回复 3# jackson198574

怎么看有问题吗？
因为是多人使用的数据库，不清楚有没有什么修改额


   

counter1219

回复 2# www_xylove

oracle@cus39:/oracle/app/product/11g/db/dbs> cat initora01.ora
SPFILE='/oratbs/lv_ora_spfile'
oracle@cus39:/oracle/app/product/11g/db/dbs> cat /oratbs/lv_ora_spfile
ora11g.__db_cache_size=922746880
ora01.__db_cache_size=2030043136
ora11g.__java_pool_size=16777216
ora01.__java_pool_size=16777216
ora11g.__large_pool_size=16777216
ora01.__large_pool_size=16777216
ora01.__oracle_base='/oracle/app'#ORACLE_BASE set from environment
ora11g.__oracle_base='/oracle/app'#ORACLE_BASE set from environment
ora11g.__pga_aggregate_target=872415232
ora01.__pga_aggregate_target=3321888768
ora11g.__sga_target=1275068416
ora01.__sga_target=5268045824
ora11g.__shareCC"&yd_io_pool_size=0
ora01.__shared_io_pool_size=0
ora11g.__shared_pool_size=301989888
ora01.__shared_pool_size=3120562176
ora11g.__streams_pool_size=0
ora01.__streams_pool_size=33554432
*.archive_lag_target=7200
*.audit_file_dest='/oracle/app/admin/ora01/adump'
*.audit_trail='NONE'
*.compatible='11.1.0.0.0'
*.control_files='/oratbs/ora01/lv_ora_ctl01','/oratbs/ora01/lv_ora_ctl02','/oratbs/ora01/lv_ora_ctl03'
*.db_block_size=8192
*.db_domain=''
*.db_name='ora01'
'.db_recovery_file_dest='CC"
*.diagnostic_dest='/oracle/app'
*.fast_start_io_target=0
*.fast_start_mttr_target=1800
*.log_archive_dest_1='LOCATION=/oratbs/ora_arch'
*.log_archive_format='%t_%s_%r.dbf'
*.log_buffer=3145728
*.log_checkpoint_interval=0
*.log_checkpoint_timeout=0
*.max_dump_file_size='1024k'
*.memory_max_target=8589934592
*.memory_target=8589934592
*.nls_date_format='MM/DD/YYYY HH24:MI:SS'
*.open_cursors=300
*.parallel_max_servers=0
*.pga_aggregate_target=858783744
*.processes=1800
*.remote_listenCC"ser=''
*.remote_login_passwordfile='EXCLUSIVE'
*.remote_os_authent=TRUE
*.sessions=885
*.sga_max_size=8589934592
*.sga_target=5153751040
*.shared_pool_size=858783744
*.undo_retention=1800
*.undo_tablespace='UNDOTBS1'


   

www_xylove

有些参数已经废弃了，报了这个错误。

counter1219

请指点下具体是什么失效了啊？多谢！
我也明白是什么参数失效了，或者什么不正确，但是不明白怎么看呢？
回复 6# www_xylove


   

jackson198574

我觉得是这三个参数出现的问题：
fast_start_io_target     = 0
fast_start_mttr_target   = 1800
remote_os_authent 　＝　true

在客户的Oracle 10g生产环境里:
fast_start_io_target     = 0
fast_start_mttr_target   = 0
remote_os_authent 　＝  false

在我的Oracle 11g测试环境里：
[oracle@dbserver ~]$ sqlplus / as sysdba

SQL*Plus: Release 11.2.0.1.0 Production on Mon Apr 28 01:04:59 2014

Copyright (c) 1982, 2009, Oracle.  All rights reserved.

sh
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options


SQL> show parameter fast_start_io_target;

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
fast_start_io_target                 integer     0

SQL> show parameter fast_start_mttr_target;

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
fast_start_mttr_target               integer     0
SQL> show parameter remote_os_authent;

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
remote_os_authent                    boolean     FALSE

jackson198574

这几个参数有可能是后期有人因为某种需要手工修改的，建议楼主咨询一下相关的负责人或者是管理员，明确缘由后再进行操作。

counter1219

fast_start_io_target这个参数没有问题的吧？
回复 8# jackson198574