客户端配制tnsname.ora,如下:

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

普通用户连接:

SQL> conn lijp/lijp@vm_sigle;
已连接。
SQL>

sys用户连接:

SQL> conn sys/sys@vm_sigle 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@]

ITPub博客

SQL> conn sys/sys@vm_sigle as sysdba; 报ORA-01031: insufficient privileges错误

最新文章