1, directly with Sql*plus directly connected
DatabaseWhen 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, actually here this string is my door in the installation
Oracleis automatically generated, it is the configured database connection service name, consistent with the database system identifier, 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, the error:ora-28009:connection to SYS should is as SYSDBA or Sysoper will appear
For example, with SYS as the user name, password as the password, SYSDBA log on as a connection, or connect to Sql*plus, enter the user name: sys, password: password, host string: ORCL as Sysdba 2, enter DOS even Sql*plus, As shown in C:\Program files\oracle\bin>sqlplussql*plus:release 10.2.0.1.0-production on Wednesday November 21
15:33:30 2012Copyright (c) 1982, 2005, Oracle. All rights reserved.
Please enter user name: System as SYSDBA
Enter password: Connect to:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0-
Production
With the partitioning, OLAP and Data Mining options
Oracle sqlplus ORA-28009 Connection to SYS should be as SYSDBA or sysoper