Connect SQLplus in oracle

oracle sqlplus
Sopolin picture Sopolin · Jun 13, 2009 · Viewed 78.4k times · Source

I want to connect user sys in sqlplus of oracle but after I connect, I type like this:

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?

Answer

Steve Broberg picture Steve Broberg · Jun 14, 2009

Your example looks a little garbled; to connect to sqlplus via the command line, with a user sys and password 123456:

sqlplus sys/123456 as sysdba

or 

sqlplus "sys/123456 as sysdba"

prior to Oracle 10. If you are already inside sqlplus (as I assume from the fact that your example starts with a SQL>), you use the connect command:

SQL> connect sys/123456 as sysdba

In all cases, if you haven't set the environment variable ORACLE_SID, you need to specify that after the password, like this:

sqlplus sys/123456@<mydbname> as sysdba

where <mydbname> is either of the form <hostname>/<sid>, if you're using Oracle 10 or later, or a valid entry from your tnsnames.ora file (located in $ORACLE_HOME/network/admin) for all versions.

Related questions

ORA-12514 TNS:listener does not currently know of service requested in connect descriptor

We have an application running locally where we're experiencing the following error: ORA-12514: TNS:listener does not currently know of service requested in connect descriptor I've tested the connection using TNSPing which resolved correctly and I tried SQLPlus to try …

Read More
How do I spool to a CSV formatted file using SQLPLUS?

I want to extract some queries to a CSV output format. Unfortunately, I can't use any fancy SQL client or any language to do it. I must use SQLPLUS. How do I do it?

Read More
How to display databases in Oracle 11g using SQL*Plus

With help of this command show databases; I can see databases in MySQL. How to show the available databases in Oracle?

Read More