Error: Ora-28009:connection as SYS should be as SYSDBA or sysoper solution--reproduced but can be used after verification

Today, with the isql*plus to the SYS user to connect to the database when the ora-28009:connection as SYS should be as SYSDBA or sysoper error, do not know what is going on, Remember when the connection of the time when the error did not report on the past. It is possible that a new library has been built with DBCA, so it is not connected. From the Internet to find a bit, the original text as follows: http://linli.blogbus.com/logs/13337529.html

When using Sql*plus to connect to the database, a dialog box is required to fill in the user name, password, and host string information. The former two needless to say, I will fill in the right, but this host string seems to have not seen Ah, in fact, this string is my door when installing Oracle automatically generated, it is the configured database connection service name, and the database system identifier consistent, but the two are different concepts can not be confused. It is generally consistent with the global database name that you set at installation time. I set the global database name to ORCL, so when connecting, you should fill in the host string as ORCL as SYSDBA. If you do not add the following as SYSDBA, then the error:ora-28009:connection to SYS should is as SYSDBA or Sysoper for example, the SYS is the user name, password is the password, SYSDBA is the connection body Login or connect to Sql*plus, enter the user name: sys, password: password, host string: ORCL as Sysdba

I don't see the host string entered directly in the password: SYS as SYSDBA------here I'm connected.

The above is very clear, but I do not want to understand why I use Sysoper and sys users in the sqlplus can not even? is also an error, and the message is not the same, Sysoper reported the error has not been written down. Go back to school tomorrow and try it.

(A workaround when you add your own Java Connection database)

Java code:

String userName = "sys as SYSDBA"; The SYS here is the global database name that you set when you installed Oracle

String userpass = "TP"; Here is your own password

String drivername = "Oracle.jdbc.driver.OracleDriver"; Oracle's Drivers

String Databaseurl = "Jdbc:oracle:thin: @localhost: 1521:ORCL"; Database connection address, local connection here

Error: Ora-28009:connection as SYS should be as SYSDBA or sysoper solution-reproduced but can be used after verification