刚装上的oracle9i,用默认的DBA账号登录，出现ORA-01031：insufficient privilege错误？？

[hdczf]

全部默认的DBA账号都试过了，错误依然！请大家指教！

[ATCG]

编辑sqlnet.ora，加入：SQLNET.AUTHENTICATION_SERVICES= (NTS)

[hdczf]

sqlnet.ora中，已经有SQLNET.AUTHENTICATION_SERVICES= (NTS)这条语句了，还是不行！

[feirulin]

不懂，学习ing!!!!!

[lishuguang]

你是用SQLPLUS还是DGMGRL登录数据库，如果用DGMGRL登录数据库需要是有DBA权限的用户才能登录，这也是ORACLE9与ORACLE8的区别

[hdczf]

在sqlplus中使用默认账户登录，都不成功，在Enterprise Manager Console中，独立启动，使用默认账号也不行。

oracle9i中用户存放哪个文件呀，能不能直接向这个文件添加用户，然后以此用户登录。

[ycdch]

Hi,
我也碰到该问题，不知如何解决！
OS: HPUX11.00
DB: ORACLE 816

$id
uid=603(oradba) gid=100(dba)
$sqlplus /nolog

SQL*Plus: Release 8.1.6.0.0 - Production on Sat Nov 8 17:35:38 2003

(c) Copyright 1999 Oracle Corporation. All rights reserved.

SQL> conn / as sysdba;
ERROR:
ORA-01031: insufficient privileges

[Drate]

ORA-01031 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 appropriate privilege at a higher label, ask the database administrator to regrant the privilege at the appropriate label.

[chanet]

查看具有 sysdba 权限的用户
select * from v$pwfile_users;

[lingye]

"编辑sqlnet.ora"什么意思啊？？？

[dql_77]

就是要
编辑sqlnet.ora，加入：SQLNET.AUTHENTICATION_SERVICES= (NTS)

[chanet]

Oracle 8i 可以用 internal

SQL>connect internal/oracle;
SQL>grant sysdba to system;

[ycdch]

我的问题，已经解决了，方法如下：
$ORACLE_HOME/rdbms/lib/config.c
中指定os_dba 为 oinstall, 该了之后，重新启动oracle, ok!

以飨看客