ITPub博客

两种启动数据库的方式

原创 Linux操作系统 作者:paulyibinyi 时间:2007-12-18 11:58:40 0 删除 编辑

1.使用操作系统验证
D:\oracle\ora92\network\admin
SQLNET.AUTHENTICATION_SERVICES = (NTS)  --启用
C:\Documents and Settings\Paul Yi>sqlplus "/as sysdba"

SQL*Plus: Release 9.2.0.4.0 - Production on Tue Dec 18 12:10:18 2007

Copyright (c) 1982, 2002, Oracle Corporation.  All rights reserved.

Connected to an idle instance.

SQL> startup;
ORACLE instance started.

Total System Global Area  101785252 bytes
Fixed Size                   454308 bytes
Variable Size              75497472 bytes
Database Buffers           25165824 bytes
Redo Buffers                 667648 bytes
Database mounted.
Database opened.

2.使用密码验证
D:\oracle\ora92\network\admin
# SQLNET.AUTHENTICATION_SERVICES = (NTS)  --注释掉
使用操作系统登录方法时就报以下错误
C:\Documents and Settings\Paul Yi>sqlplus "/as sysdba"

SQL*Plus: Release 9.2.0.4.0 - Production on Tue Dec 18 12:04:05 2007

Copyright (c) 1982, 2002, Oracle Corporation.  All rights reserved.

ERROR:
ORA-01031: insufficient privileges


Enter user-name:
ERROR:

C:\Documents and Settings\Paul Yi>sqlplus /nolog

SQL*Plus: Release 9.2.0.4.0 - Production on Tue Dec 18 12:04:50 2007

Copyright (c) 1982, 2002, Oracle Corporation.  All rights reserved.

SQL> conn sys/abcdefg as sysdba
Connected.
--看到密码输错,就登录不成功,所以密码验证生效
SQL> conn sys/abcde as sysdba
ERROR:
ORA-01017: invalid username/password; logon denied


Warning: You are no longer connected to ORACLE.
SQL> startup;
ORACLE instance started.

Total System Global Area  101785252 bytes
Fixed Size                   454308 bytes
Variable Size              75497472 bytes
Database Buffers           25165824 bytes
Redo Buffers                 667648 bytes
Database mounted.
Database opened.

来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/7199859/viewspace-796/,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论
oracle 10g ocm oracle 10g/11g/12c ocp aix 6.1 administrator,ogg expert,ITSS 技术交流群 201703254 微信公众号 paulyibin 探讨技术,开心工作 电话 13719354869 ,深入研究数据库和开始研究big data

注册时间:2007-12-11

  • 博文量
    905
  • 访问量
    6482333