各种报错处理方法

1、EXPDP/IMPDP报错

ORA-39002: invalid operation  

ORA-39070: Unable to open the log file.  

ORA-29283: invalid file operation  

ORA-06512: at "SYS.UTL_FILE", line 475  

ORA-29283: invalid file operation  

当遇到这种报错时，需要查看diretory目录是否设置错误。

2、使用runinstall安装数据库遇到报错

准备从以下地址启动 Oracle Universal Installer /tmp/OraInstall2016-05-24_03-54-17PM. 请稍候... Exception in thread "main" java.lang.NoClassDefFoundError
 at java.lang.Class.forName0(Native Method)
 at java.lang.Class.forName(Class.java:164)
 at java.awt.Toolkit$2.run(Toolkit.java:821)
 at java.security.AccessController.doPrivileged(Native Method)
 at java.awt.Toolkit.getDefaultToolkit(Toolkit.java:804)
 at javax.swing.UIManager.initialize(UIManager.java:1262)
 at javax.swing.UIManager.maybeInitialize(UIManager.java:1245)
 at javax.swing.UIManager.getUI(UIManager.java:851)
 at javax.swing.JPanel.updateUI(JPanel.java:104)
 at javax.swing.JPanel.(JPanel.java:64)
 at javax.swing.JPanel.(JPanel.java:87)
 at javax.swing.JPanel.(JPanel.java:95)
 at oracle.sysman.oii.oiif.oiifo.OiifoOCMUI.(OiifoOCMUI.java:125)
 at oracle.sysman.oii.oiif.oiifo.OiifoOCMInterfaceManager.(OiifoOCMInterfaceManager.java:79)
 at oracle.sysman.oii.oiif.oiifo.OiifoOCMInterfaceManager.getInstance(OiifoOCMInterfaceManager.java:124)
 at oracle.install.ivw.db.driver.DBInstaller.run(DBInstaller.java:123)
 at oracle.install.commons.util.Application.startup(Application.java:869)
 at oracle.install.commons.flow.FlowApplication.startup(FlowApplication.java:164)
 at oracle.install.commons.flow.FlowApplication.startup(FlowApplication.java:181)
 at oracle.install.commons.base.driver.common.Installer.startup(Installer.java:265)
 at oracle.install.ivw.db.driver.DBInstaller.startup(DBInstaller.java:114)
 at oracle.install.ivw.db.driver.DBInstaller.main(DBInstaller.java:132)

 输入命令：unset DISPLAY


3、（手工建库时）启动数据库报错

SQL> startup

ORA-00845: MEMORY_TARGET not supported on this system

改变/dev/shm大小或者改变memory_target大小。
meomory_target大小要小于/dev/shm。
/dev/shm可以在/etc/fstab修改设置，如
tmpfs                   /dev/shm                tmpfs   defaultsi, size=1G
修改完后要重新挂载
或者使用以下命令：
mount -o size=1024M -o nrinodes=1000000 -o noatime,nodiratime -o remount /dev/shm


4、启动数据库报错
ORA-09925: Unable to create audit trail file

更改参数文件中的一些参数路径，部分路径不存在或错误

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

转载于:http://blog.itpub.net/28371090/viewspace-2106169/