Microsoft Windows XP [版本 5.1.2600] (C) 版权所有 1985-2001 Microsoft Corp.C:\Documents and Settings\Administrator>sqlplus / as sysdba; -- / 前后都要空格SQL*Plus: Release 10.2.0.1.0 - Production on 星期二 3月 22 14:01:29 2011Copyright (c) 1982, 2005, Oracle. All rights reserved. 连接到: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production With the Partitioning, OLAP and Data Mining optionssys@YPCOST>SQL*Plus: Release 10.2.0.1.0 - Production on 星期二 3月 22 14:00:36 2011Copyright (c) 1982, 2005, Oracle. All rights reserved. 连接到: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production With the Partitioning, OLAP and Data Mining optionsscott@YPCOST> conn / as sysdba; 已连接。 sys@YPCOST>
你看我这是什么情况?C:\Documents and Settings\mao weiting>sqlplus / as sysdbaSQL*Plus: Release 10.2.0.1.0 - Production on 星期二 3月 22 14:10:46 2011Copyright (c) 1982, 2005, Oracle. All rights reserved.ERROR: ORA-01031: insufficient privileges下面这种情况就可以 C:\Documents and Settings\mao weiting>sqlplus sys/oracle as sysdbaSQL*Plus: Release 10.2.0.1.0 - Production on 星期二 3月 22 14:12:31 2011Copyright (c) 1982, 2005, Oracle. All rights reserved. 连接到: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production With the Partitioning, OLAP and Data Mining options
C:\Documents and Settings\Administrator>sqlplus / as sysdbaSQL*Plus: Release 10.2.0.1.0 - Production on 星期二 3月 22 14:36:21 2011Copyright (c) 1982, 2005, Oracle. All rights reserved.ERROR: ORA-01031: insufficient privileges
# sqlnet.ora Network Configuration File: E:\oracle10g\network\admin\sqlnet.ora # Generated by Oracle configuration tools.# This file is actually generated by netca. But if customers choose to # install "Software Only", this file wont exist and without the native # authentication, they will not be able to connect to the database on NT.SQLNET.AUTHENTICATION_SERVICES= (NTS)NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT)看我的sqlnet.ora 这样的
Microsoft Windows XP [版本 5.1.2600]
(C) 版权所有 1985-2001 Microsoft Corp.C:\Documents and Settings\Administrator>sqlplus / as sysdba; -- / 前后都要空格SQL*Plus: Release 10.2.0.1.0 - Production on 星期二 3月 22 14:01:29 2011Copyright (c) 1982, 2005, Oracle. All rights reserved.
连接到:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining optionssys@YPCOST>SQL*Plus: Release 10.2.0.1.0 - Production on 星期二 3月 22 14:00:36 2011Copyright (c) 1982, 2005, Oracle. All rights reserved.
连接到:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining optionsscott@YPCOST> conn / as sysdba;
已连接。
sys@YPCOST>
ORA-01031: insufficient privileges下面这种情况就可以
C:\Documents and Settings\mao weiting>sqlplus sys/oracle as sysdbaSQL*Plus: Release 10.2.0.1.0 - Production on 星期二 3月 22 14:12:31 2011Copyright (c) 1982, 2005, Oracle. All rights reserved.
连接到:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options
而你的oracle的sys用户是和计算机管理员一个组的你用administration 登录计算机应该就可以了
ORA-01031: insufficient privileges
$ORACLE_HOME/network/admin/sqlnet.ora 文件中增加下面一行
SQLNET.AUTHENTICATION_SERVICES=(NTS)
如果有效纯属巧合~
设置其中 SQLNET.AUTHENTICATION_SERVICES=(NTS) PS:现在可能是NONE.
# Generated by Oracle configuration tools.# This file is actually generated by netca. But if customers choose to
# install "Software Only", this file wont exist and without the native
# authentication, they will not be able to connect to the database on NT.SQLNET.AUTHENTICATION_SERVICES= (NTS)NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT)看我的sqlnet.ora 这样的
1、看看你的用户是否在操作系统的dba组里(dba组是安装数据库时自动创建的组,没有的话加进去)
2、在sqlnet.ora文件中,SQLNET.AUTHENTICATION_SERVICES=(NONE),将NONE改为 NTS
3、修改oracle参数 remote_login_password=exclusive(允许远程sysdba身份登录)不影响本机