Chinaunix

标题: AIX5.1上装的Oracle9.2无法用sqlplus "/as sysdba"登 [打印本页]

作者: Zodix    时间: 2005-07-28 19:11
标题: AIX5.1上装的Oracle9.2无法用sqlplus "/as sysdba"登
数据库是从别的机上tar过来的,现在可以用sqlplus /nolog,conn sys/change_on_install as sysdba登录,并且可以正常启动数据库.但是不能用sqlplus "/as sysdba"登录.

报的错误是:
ORA-01031: insufficient privileges

错误详细说明是:
01031, 00000, "insufficient privileges"
*Cause: An attempt was made to change the current username or password without the appropriate privilege. This error also occurs if attempting to install a database without the necessary operating system privileges.
    When Trusted Oracle is configure in DBMS MAC, this error may occur  if the user was granted the necessary privilege at a higher label than the current login.
// *Action: Ask the database administrator to perform the operation or grant
//          the required privileges.
//          For Trusted Oracle users getting this error although granted the
//          the appropriate privilege at a higher label, ask the database
//          administrator to regrant the privilege at the appropriate label.

请教解决方法!
作者: Zodix    时间: 2005-07-28 20:45
标题: AIX5.1上装的Oracle9.2无法用sqlplus "/as sysdba"登
搞定了!
在AIX中新建组,组名为dba,把oracle的属主oracle归属进这个叫dba的组就OK了!




欢迎光临 Chinaunix (http://bbs.chinaunix.net/) Powered by Discuz! X3.2