ORA-01031: insufficient privileges

Arcsight安裝完arcsight db後，要安裝arcsight manager..
但出現

SQL> conn /
ERROR:
ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
Linux Error: 2: No such file or directory


網路上找了一些解決方法，簡單的有為重起instance..
但我重起的時候發生

ORA-01031: insufficient privileges




後來發現arcsight db安裝oracle 預設的user/group是oracle/oracle..
但大概我在安裝arcsight db前就先把oracle環境用好(包含add oracle user)，所以設到oracle user group為oinstall...

故後續更改了oracle user group就解決了~~

....繼續閱讀

OC4J Configuration issue.

前些日重灌oracle環境，下達emctl status dbconsole看oem狀態~
出現

[oracle@localhost bin]$ ./emctl start dbconsole
TZ set to ROC
OC4J Configuration issue. /home/oracle/product/10.2.0/db_1/oc4j/j2ee/OC4J_DBConsole_localhost.localdomain_ORCL not found.




結果原因為$ORACLE_SID變數未設定，而且預設的orcl db為小寫的
，設成大寫的會有問題，記錄一下。

....繼續閱讀

adump、bdump.....etc

*.audit_file_dest='/export/home/oracle/admin/ora10g/adump'
*.background_dump_dest='/export/home/oracle/admin/ora10g/bdump'
*.core_dump_dest='/export/home/oracle/admin/ora10g/cdump'
*.user_dump_dest='/export/home/oracle/admin/ora10g/udump' ....繼續閱讀