各種報錯處理方法

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

更改引數檔案中的一些引數路徑，部分路徑不存在或錯誤