ORA-xxxxxx
jxzkin
这个作者很懒,什么都没留下…
展开
-
ORA-01185 logfile group number *** is invalid
SELECT *FROMv$controlfile_record_sectionWHERE TYPE='REDO LOG'; CHECK THE BELOW VALUES:records_total records_used原创 2011-09-23 12:46:57 · 987 阅读 · 0 评论 -
ORA-01031: insufficient privileges
sqlplus '/as sysdba'show parameter passwordselect * from v$pwfile_users;cd $ORACLE_HOME/dbsorapwdorapwd file=orapwkin entries=10 password=manager原创 2014-12-09 15:58:38 · 781 阅读 · 0 评论 -
ORA-19815-Oracle11g RAC 停机
平台:OS:Red Hat Enterprise Linux Server release 5.5DB:Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production现象: space space reclm limit used原创 2012-10-26 11:23:40 · 1183 阅读 · 0 评论 -
ORA-19815: WARNING: db_recovery_file_dest_size of 5218762752 bytes is 100.00% used
平台:OS:CentOS release 5.5 (Final) 64bitDB Version:Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production RAC 现象:磁盘空间100%,adump目录一直增长查看alert.log文件ORA-19815: WARNING原创 2012-07-20 10:38:14 · 1909 阅读 · 0 评论 -
ORA-00054:resource busy and acquire with nowait specified
1.SELECT t2.username, t2.SID, t2.serial#, t2.logon_time FROM v$locked_object t1, v$session t2 WHERE t1.session_id = t2.SIDORDER BY t2.logon_time; 2.SELECT sql_text FROM v$s原创 2012-05-09 10:57:02 · 609 阅读 · 0 评论 -
ORA-14452: attempt to create, alter or drop an index on temporary table already in use
ORA-14452: attempt to create, alter or drop an index on temporary table already in useStep:1>select object_id from user_objects where object_name=&object_name;2>select * from v$lock where id1=原创 2012-04-18 18:25:17 · 1643 阅读 · 0 评论 -
Oracle 10g ORA-07445和ORA-00108
Solution:remove *.dispatchers='(PROTOCOL=TCP) (SERVICE=orclXDB)' from parameter file.原创 2011-12-30 18:24:57 · 700 阅读 · 0 评论 -
ORA-27046 Solution
$ strings spfile.ora > init.ora Extract the parameters either from the alert log or the corrupted spfile and create a new pfile from that. SQL> create spfile from pfile; You can now use the原创 2012-01-12 11:00:55 · 650 阅读 · 0 评论 -
ORA-18008
SOLUTION: ALTER TRIGGER MDSYS.sdo_st_syn_create DISABLE;CREATE USER outln IDENTIFIED BY outlnDEFAULT TABLESPACE SYSTEMTEMPORARY TABLESPACE temp PROFILE DEFAULT ACCOUNT UNLOCK;GRANT RESOURCE转载 2011-11-25 14:49:12 · 537 阅读 · 0 评论 -
ORA-12801 15154 Oracle 10g Logical Standby
今天Oracle 10g Logical Standby 无法同步,检查Alert Log apply进程可正常开启,但随后马上关闭并报ORA-ORA-12801: error signaled in parallel query server P007ORA-12154原创 2011-10-18 10:24:46 · 2033 阅读 · 0 评论 -
ORA-29701 :unable to connect to Cluster Manager
OS:Linux RHEL 4 AS Version:10.2.0.1SYMTOM:When startup the ASM instance, an error was encountered.CauseConnect to CM failed or原创 2011-09-28 13:45:04 · 935 阅读 · 0 评论 -
ORA-18008
ALTER TRIGGER MDSYS.sdo_st_syn_create DISABLE;CREATE USER outln IDENTIFIED BY outlnDEFAULT TABLESPACE SYSTEMTEMPORARY TABLESPACE temp原创 2011-08-29 09:03:08 · 667 阅读 · 0 评论 -
ORA-0131:Insufficient privileges
grant debug connect session to kin;原创 2015-08-19 09:29:56 · 995 阅读 · 0 评论