ORA-
文章平均质量分 58
EVISWANG
这个作者很懒,什么都没留下…
展开
-
ORA-00439: feature not enabled: Real Application Clusters
还原spfile后启动到nomountSQL> startup nomountORA-00439: feature not enabled: Real Application ClustersSQL> 这是由于主库集群参数SQL> show parameter cluster_database NAME TYPE原创 2016-04-01 09:17:41 · 5521 阅读 · 0 评论 -
SQL> set autotrace traceonly SP2-0618: Cannot find the Session Identifier. Check PLUSTRACE role is
SQL> set autotrace traceonlySP2-0618: Cannot find the Session Identifier. Check PLUSTRACE role is enabledSP2-0611: Error enabling STATISTICS reportSQL>没 plustrace 角色权限原创 2016-05-04 16:25:07 · 623 阅读 · 0 评论 -
PRCR-1079 CRS-5017 ORA-01031 DBCA
CRS-5017: The resource action "ora.webp2p.db start" encountered the following error: ORA-01031: insufficient privileges. For details refer to "(:CLSN00107:)" in "/u01/11.2.0/ghome/log/node1/agent/原创 2016-10-27 10:32:22 · 2676 阅读 · 0 评论 -
ORA-00604: error occurred at recursive SQL level ORA-04024: self-deadlock detected while trying to
[oracle@ ~]$ sqlplus / as sysdbaSQL*Plus: Release 12.2.0.1.0 Production on Fri Nov 9 14:30:17 2018Copyright (c) 1982, 2016, Oracle. All rights reserved.Connected to:Oracle Database 12c Enter...原创 2018-11-09 15:44:27 · 2071 阅读 · 0 评论 -
ORA-00059: maximum number of DB_FILES exceeded
SQL> alter tablespace XNCBS add datafile '+DATRP' SIZE 5g autoextend on next 200MERROR at line 1:ORA-00059: maximum number of DB_FILES exceededSQL> SELECT name, issys_modifiable from v$pa...原创 2018-11-16 15:23:51 · 394 阅读 · 0 评论 -
SGA size can not be greater than maximum shared memeory segment size
[root@Tdb1 ~]# vi /etc/sysctl.confkernel.shmmax = 4294967296这个值修改为 kernel.shmmax = 88719476736原创 2018-11-16 15:39:48 · 413 阅读 · 0 评论