标签 报错 下的文章

Oracle 错误号解释大全

ORA-00001: 违反唯一约束条件 (.)
ORA-00017: 请求会话以设置跟踪事件
ORA-00018: 超出最大会话数
ORA-00019: 超出最大会话许可数
ORA-00020: 超出最大进程数 ()
ORA-00021: 会话附属于其它某些进程;无法转换会话
ORA-00022: 无效的会话 ID;访问被拒绝
ORA-00023: 会话引用进程私用内存;无法分离会话








---阅读剩余部分---

ORA-32004: obsolete or deprecated parameter(s) specified for RDBMS instance报错解决方法

服务器来电启动的oracle的时候报错ORA-32004: obsolete or deprecated parameter(s) specified for RDBMS instance
ORACLE instance started.,详细信息如下:

[root@hch_test_pd_121_217 local]$su - oracle
[oracle@hch_test_pd_121_217 ~]$rlwrap sqlplus / as sysdba

SQL*Plus: Release 11.2.0.1.0 Production on Sat Mar 17 15:08:08 2018

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

Connected to an idle instance.

SQL> startup
ORA-32004: obsolete or deprecated parameter(s) specified for RDBMS instance
ORACLE instance started.

Total System Global Area 3.0198E+10 bytes
Fixed Size                  2214456 bytes
Variable Size            1.3959E+10 bytes
Database Buffers         1.6106E+10 bytes
Redo Buffers              130793472 bytes
Database mounted.
Database opened.

查看数据库弃用的系统参数:

SQL> select name from v$parameter where isdeprecated = 'TRUE';

NAME
--------------------------------------------------------------------------------
lock_name_space
instance_groups
resource_manager_cpu_allocation
active_instance_count
buffer_pool_keep
buffer_pool_recycle
log_archive_start
standby_archive_dest
log_archive_local_first
parallel_server
parallel_server_instances

NAME
--------------------------------------------------------------------------------
fast_start_io_target
serial_reuse
max_enabled_roles
remote_os_authent
global_context_pool_size
cursor_space_for_time
plsql_v2_compatibility
plsql_debug
background_dump_dest
user_dump_dest
commit_write

NAME
--------------------------------------------------------------------------------
sql_trace
parallel_automatic_tuning
parallel_io_cap_enabled

25 rows selected.

ora-32004错误不影响数据库的使用,报错信息为参数过期,可以看alter_orcl.log 日志文件那个参数过期

SQL> show parameter background_dump_dest;
NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
background_dump_dest                 string      /oracle/app/oracle/diag/rdbms/
                                                 pdunq/powerdes/trace

新开ssh窗口,直接查看alert日志:

tail -f /oracle/app/oracle/diag/rdbms/pdunq/powerdes/trace/alert_powerdes.log

具体日志内容:

  dispatchers              = "(PROTOCOL=TCP) (SERVICE=powerdes)"
  job_queue_processes      = 1000
  _system_trig_enabled     = FALSE
  audit_file_dest          = "/oracle/app/oracle/admin/powerdes/adump"
  audit_trail              = "NONE"
  db_name                  = "powerdes"
  db_unique_name           = "pdunq"
  open_cursors             = 3000
  optimizer_mode           = "FIRST_ROWS"
  optimizer_index_cost_adj = 25
  optimizer_index_caching  = 90
  _optim_peek_user_binds   = FALSE
  pga_aggregate_target     = 5591424409
  diagnostic_dest          = "/oracle/app/oracle"
Deprecated system parameters with specified values:
  log_archive_start        
End of deprecated system parameter listing

重点看Deprecated system parameters with specified values,其中log_archive_start为相关的参数,
查看log_archive_start参数的值

SQL> show parameter log_archive_start;

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
log_archive_start                    boolean     FALSE

将log_archive_start参数重置为系统默认值

SQL> alter system reset log_archive_start;

System altered.

最后在重启数据库,

SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup
Total System Global Area 3.0198E+10 bytes
Fixed Size                  2214456 bytes
Variable Size            1.3959E+10 bytes
Database Buffers         1.6106E+10 bytes
Redo Buffers              130793472 bytes
Database mounted.
Database opened.
SQL> 

没有报ORA-32004错误问题解决.

最新

分类

归档

评论

  • 安安: 都是af
  • Liang: 嗯,有点不通顺·
  • 王庭威: “MySQL互为主从...
  • Liang: 贴下编译参数和步骤,...
  • shao3911: 您好,为什么我在编译...
  • aliang: 先看是yum安装还是...
  • aliang: 将原来的nginx安...
  • yen: 3、如果要回滚的话,...
  • yen: 刚好需要升级ngin...
  • 文雨: 一些新的method...

其它