SQL> conn sys/sys@vm_sigle as sysdba; 報ORA-01031: insufficient privileges錯誤

客戶端配製tnsname.ora,如下:

vm_sigle =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.16.11.149)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = lijp)
)
)

普通使用者連線:

SQL> conn ;
已連線。
SQL>

sys使用者連線:

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

SQL>

發現密碼檔案丟失了,建立密碼檔案,解決問題.

[oracle@localhost dbs]$ orapwd file=orapwlijp password=sys entries=10
[oracle@localhost dbs]$

注意:

引起這個錯誤的原因很多,相關引數.

SQL> show parameter password

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
remote_login_passwordfile string EXCLUSIVE
SQL>
SQL>

[@more@]