-
编辑 删除
ORA-01996
[oracle@lonion ~]$ oerr ora 01996ORA-01996：GRANT failed: password file '' is full 这种错误通常出现在给某用户授予SYSDBA权限时出现。查询视图V$PWFILE_USERS，看看拥有SYSDBA权限的用户是否超过了密钥文件里规定的个数。[@more@]
-
编辑 删除
ORA-01078
[oracle@lonion ~]$ oerr ora 01078 【案例出现在Oracle11g】ORA-01078:failure in processing system parameters// *Cause:Failure during processing of INIT.ORA parameters during system startup.// *Action:Further diagnostic information should be in the error stack.附带的错误LRM-00109: could not open parameter file '.......'出现错误的原因：在修改oracle用户环境变量的时候指定export ORACLE_SID=lonion,但是在安装数据库是却将数据库SID指定为另一个名称(假定是oracle11g)，这就是错误所在。解决办法尝试重新修改oracl
-
编辑 删除
ORA-27102
[oracle@lonion ~]$ oerr ora 27102 【案例出现在Oracle11g】ORA-27102：out of memory// *Cause: Out of memory// *Action: Consult the trace file for details这个问题是安装好Oracle11g后启动数据库时出现的，当时是这样子解决的：修改操作系统的内核参数设置# vi /etc/sysctl.conf将kernel.shmmax = （物理内存的一半G）*1024*1024*1024(采用三思的建议)[@more@]
-
编辑 删除
ORA-01536
[oracle@lonion ~]$ oerr ora 01536 【案例出现在Oracle11g】ORA-01536: space quota exceeded for tablespace 'string' // *Cause: The space quota for the segment owner in the tablespace has been exhausted and the operation attempted the creation of a new segment extent in the tablespace.// *Action: Either drop unnecessary objects in the tablespace to reclaim space or have a privileged user increase the quota on this tablespace for the segment owner.出现的原因可能：使用REVOKE UNLIMITED TABLESPACE命令后
-
编辑 删除
ORA-00845
[oracle@lonion ~]$ oerrora 00845（通常在IMP导入数据时出现）【案例出现在Oracle11g】ORA-00845: MEMORY_TARGET not supported on this system// *Cause:The MEMORY_TARGET parameter wasnot supportedon this operatingsystem or /dev/shm wasnot sized correctlyon Linux.// *Action: Referto documentationfor alist of supported operating systems.Or,size /dev/shmto beat least the SGA_MAX_SIZEon each Oracleinstance runningon the system.出现的原因可能：Oracle 11g的Linux版本在修改了MEMORY_TARGET或者SGA_TARGET后启动可
-
编辑 删除
ORA-08189
[oracle@lonion ~]$ oerr ora 08189ORA-08189: cannot flashback the table because row movement is not enabledORA-08189：不能闪回表，因为未启用行移动功能08189, 00000, "cannot flashback the table because row movement is not enabled"// *Cause: An attempt was made to perform Flashback Table operation on a table for which row movement has not been enabled. Because the Flashback Table does not preserve the rowids, it is necessary that row movement be enabled on the table.// *Action: Enable row
