SQL*Plus: Release 10.2.0.4.0 - Production on Thu Aug 6 10:39:23 2009
Copyright (c) 1982, 2007, Oracle. All Rights Reserved.
ERROR:
ORA-01031: insufficient privileges
uid=1009(oracle) gid=998(oinstall) groups=998(oinstall),1000(omcsysm)如上顯示oracle用戶沒有添加到DBA用戶組。
# usermod -g oinstall -G dba,omcsysm -i oracle
退出登錄。# exit
以oracle用戶登錄數據庫所在機器。 以sysdba用戶連接數據庫。% sqlplus / as sysdba
登錄成功,系統顯提示如下信息:
SQL*Plus: Release 10.2.0.4.0 - Production on Thu Aug 6 16:32:06 2009
Copyright (c) 1982, 2007, Oracle. All Rights Reserved.
Connected to an idle instance.