Shulou(Shulou.com)05/31 Report--

This article mainly shows you the "Oracle remote login error ora-01031 how to do", the content is easy to understand, clear, hope to help you solve doubts, the following let the editor lead you to study and learn "Oracle remote login error ora-01031 how to do" this article.

Database snooping is normal.

It is normal to log in remotely with an ordinary user, but an error is reported by a sys user. Login tool PLSQL Developer

Error message: ora-01031:insufficient privileges

If prompted, the representative does not have permission.

Give sysdba permissions to sys users:

SQL > grant sysdba to sys

Grant sysdba to sys

*

ERROR at line 1:

ORA-01994: GRANT failed: password file missing or disabled

Error report: the password file is missing and there is no password file under $ORACLE_HOME/dbs.

Create a password file:

Orapwd file=orapw$ORACLE_SID password=oracle entries=30

Re-empower:

SQL > grant sysdba to sys

Grant succeeded.

SQL > select * from v$pwfile_users

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.