错误解决ORA-32004报错

启动数据库报错

 

SQL> startup

ORA-32004: obsolete or deprecated parameter(s) specified for RDBMS instance

ORACLE instance started.

 

Total System Global Area 1670221824 bytes

Fixed Size                  2213936 bytes

Variable Size             419432400 bytes

Database Buffers         1241513984 bytes

Redo Buffers                7061504 bytes

Database mounted.

Database opened.

 

解决：

1.查看alert_orcl.log

Using parameter settings in server-side spfile /u01/app/oracle/product/11.2.0/dbhome_1/dbs/spfileorcl.ora

System parameters with non-default values:

  processes                = 150

  sga_max_size             = 1600M

  large_pool_size          = 16M

  java_pool_size           = 32M

  streams_pool_size        = 16M

  nls_language             = "SIMPLIFIED CHINESE"

  nls_territory            = "CHINA"

  memory_target            = 2560M

  control_files            = "/u01/app/oracle/oradata/orcl/control01.ctl"

  control_files            = "/u01/app/oracle/oradata/orcl/control02.ctl"

  db_block_size            = 8192

  db_writer_processes      = 1

  compatible               = "11.2.0.0.0"

  log_archive_start        = TRUE

  log_archive_dest         = "/u01/app/oracle/oradata/orcl/archivelog"

  undo_tablespace          = "UNDOTBS1"

  remote_login_passwordfile= "EXCLUSIVE"

  db_domain                = ""

  dispatchers              = "(PROTOCOL=TCP) (SERVICE=orclXDB)"

  job_queue_processes      = 0

  audit_file_dest          = "/u01/app/oracle/admin/orcl/adump"

  audit_trail              = "DB"

  db_name                  = "orcl"

  open_cursors             = 300

  aq_tm_processes          = 0

  diagnostic_dest          = "/u01/app/oracle"

Deprecated system parameters with specified values:

  log_archive_start       

End of deprecated system parameter listing

 

提示过时的系统参数。

2.执行SQL创建pfile参数文件

SQL> create pfile from spfile;

关闭数据库

SQL> shutdown immediate

3.修改pfile文件，删除log_archive_start = TRUE 参数。

SQL> create spfile from pfile;

4.启动数据库，问题解决

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

转载于:http://blog.itpub.net/13709049/viewspace-1102406/