兩種啟動資料庫的方式

paulyibinyi發表於2007-12-18

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/,如需轉載,請註明出處,否則將追究法律責任。

相關文章