Connect sqlplus in oracle

Question

I want to connect user sys in sqlplus of Oracle. But after I connect, I type like this:

SQL>sqlplus sys as sysdba password:123456

Error: ORA-01030:insufficient privilege warning:You are no longer to connect oracle.

Does anyone help me to solve my problem?

Thanks!

Answer 1

If you want to connect as sysdba, you must, in addition to be a member of privileged group and sqlnet.ora properly configured - use a password file and corresponding parameter configured in the parameter file.

Here are two useful links from the documentation:

• Oracle Database Reference - REMOTE_LOGIN_PASSWORDFILE
• Oracle Database Administrator's Guide - Using Password File Authentication