Oracle錯誤案例：ORA-00922

ORA-00922 missing or invalid option　

0RA-00922: 丟失或者無效的選項

Cause An invalid option was specified in defining a column or storage clause. The valid option in specifying a column is NOT NULL to specify that the column cannot contain any NULL values. Only constraints may follow the datatype. Specifying a maximum length on a DATE or LONG datatype also causes this error.

Action Correct the syntax. Remove the erroneous option or length specification from the column or storage specification.　

案例一：Oracle明文密碼漏洞

受影響系統：

Oracle Oracle10g Application Server 9.0.4.0

Oracle Oracle10g Application Server 10.1.0.2

描述：

Oracle Database是一款商業性質大型數據庫系統。

Oracle 10g存在包含明文密碼的全局可讀文件，本地攻擊者可以利用這個漏洞獲得對數據庫的訪問。

SYSMAN帳戶的密碼可在'$ORACLE_HOME/hostname_sid/sysman/config/emoms.properties'文件中獲得，此文件全局可讀。

另外如果安裝Oracle 10g時提供SYS, SYSTEM, DBSNMP和SYSMAN 帳戶密碼相同，並且密碼有驚歎號(如f00bar!!)，那麼當設置SYSMAN和DBSNMP密碼時DB安裝會出現錯誤，錯誤信息"postDBCreation.log"會記錄密碼：

alter user SYSMAN identified by f00bar!! account unlock

ERROR at line 1:

ORA-00922: missing or invalid option

alter user DBSNMP identified by f00bar!! account unlock

ERROR at line 1:

ORA-00922: missing or invalid option