Home / server / Questions / 25159
Accepted
Sopolin
Asked: 2009-06-13 21:41:04 +0800 CST

Connect sqlplus in oracle

  • 772

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!

database oracle

1 Answers

  1. Best Answer

    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:

    • 3