ORACLE 10.0 Import Export

ora-28009:connection as SYS should be as Sysdba

Afraid to forget can:

Click "Password Management", Open Password Management dialog box, such as figure, set SYS, and system user password, can be set to the same, username and password are the same, the role of DBA

Locate the Sh,scott, remove the lockout account and set the password oracleenterprise Manager Database control URL-(ORCL):

Http://localhost:1158/em

The database configuration file has been installed to E:\oracle\product\10.2.0, and other selected installation components have been installed to E:\oracle\product\10.2.0\db_1.

The Isql*plus URL is:

Http://localhost:5560/isqlplus

The Isql*plus DBA URL is:

Http://localhost:5560/isqlplus/dba

Today, when you connect to the database with the SYS user, isql*plus the ora-28009:connection as SYS should be as SYSDBA or sysoper, and don't know what's going on. Remember the time when the connection to the time of any error did not report on the past. It is possible to build a new library with DBCA, so it is not connected. From the Internet for a moment, the original text is as follows: http://linli.blogbus.com/logs/13337529.html

When you connect the database with Sql*plus, a dialog box appears asking for the username, password, and host string information. The first two are needless to say, I will fill in the right, but this host string seems to have not seen Ah, in fact, this string is our door in the installation of Oracle automatically generated, it is configured database connection service name, and database system identifier, but the two are different concepts can not be confused. This is generally the same as the global database name you set up during installation. I set the global database name is ORCL, so when connecting, should fill in the host string for ORCL as SYSDBA.
 If you do not add the following as SYSDBA, you will receive error:ora-28009:connection to SYS should as SYSDBA or Sysoper

 For example, with SYS as the user name, password as the password, SYSDBA log on to or connect to Sql*plus for connection, enter user name: sys, password: password, host string: ORCL as Sysdba

There 's no host string here. Enter the password directly in: SYS as SYSDBA------here, I'm connected.

It has been said very clearly, but I still do not understand why I use Sysoper and sys users in the Sqlplus also not even. is also an error, and prompted the information is not the same, Sysoper reported errors did not write down. Try to go back to school tomorrow.

SYS login Prompt "Connection as SYS should be as SYSDBA or sysoper" sys users have sysdba,sysoper permissions, logins can only be logged in both identities, and cannot be logged in as normal. is the highest user with Oracle permissions;
System can only log in as normal unless he is granted sysdba,sysoper rights;

There is no difference between the statement that creates the user, the difference is authorization;
The permissions granted to SYSDBA after the user is created can be logged in SYSDBA;

method One:

Step One: Install Oracle, set the Advanced administrator password when installing, for example, enter admin.

The system administrator password is: sys/admin

The address of the database is: SYS/ADMIN@ORCL (database name)

Step two: Establish an account import (optional)

Create user user_name identified by password;

Username,password is the account and password you set.

Step three: Authorize account DBA account to import (case-insensitive)

Step Four: Import commands

Imp System/manager@mycon file=usr1.dmp Fromuser=scott touser=

User_name Full=y

Imp System/manager@mycon file=usr1.dmp Fromuser=scott touser=

User_name "Recommended"

Scott is the account password for the export library.

==========================

Complete.... ‘

======================

Method Two: Forgot the Account method (reprint)

Http://blog.sina.com.cn/s/blog_4afa90610100xhsa.html

1 input Sqlplus/nolog can be:

A tip for modifying Oracle user passwords database version: 9.2.0.5

Sometimes we may not know a user's password, but also need to do some operations with this user, and can not modify the user's password, this time, you can use some tips to complete the operation.

The specific procedures are as follows:

Sql*plus:release 9.2.0.5.0-production on Sunday November 21 13:32:34 2004

Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.

Sql> Connect sys/oracle as Sysdba

is connected.

Sql> select Username,password from Dba_users;

USERNAME PASSWORD

------------------------------ ------------------------------

SYS 8a8f025737a9097a

SYSTEM 2D594E86F93B17A1

Dbsnmp E066D214D5421CCC

TOAD a1ba01cf0dd82695

Outln 4a3ba55e08595c81

Wmsys 7c9ba362f8314299

6 rows have been selected.

Sql> Connect system/oracle

is connected.

Sql> Connect sys/oracle as Sysdba

is connected.

Modify user System password to Manager

sql> alter user system identified by manager;

The user has changed.

Sql> select Username,password from Dba_users;

USERNAME PASSWORD

------------------------------ ------------------------------

SYS 8a8f025737a9097a

SYSTEM d4df7931ab130e37

Dbsnmp E066D214D5421CCC

TOAD a1ba01cf0dd82695

Outln 4a3ba55e08595c81

Wmsys 7c9ba362f8314299

6 rows have been selected.

Sql> Connect System/manager

is connected.

Then you can do whatever you want to do at this point.

Sql> Connect sys/oracle as Sysdba

is connected.

Modify user system password to previous value

sql> alter user system identified by values ' 2D594E86F93B17A1 ';

The user has changed.

Sql> Connect system/oracle

is connected.

Sql> Connect sys/oracle as Sysdba

is connected.

Sql> Connect System/manager

ERROR:

Ora-01017:invalid Username/password; Logon denied

Warning: You are no longer connected to ORACLE.--------

====================

Reproduced:

Oracle Create Tablespace

Note the point:

1. If open in Pl/sql and other tools, directly modify the following code [Italic bold section] to perform

2. To ensure that the path exists, such as "D:\oracle\oradata\Oracle9i\" is the path you want to save the file exists

/* is divided into four steps * *

/* 1th step: Create temporary table space/*

Create temporary tablespace user_temp

Tempfile ' D:\oracle\oradata\Oracle9i\user_temp.dbf '

Size 50m

Autoextend on

Next 50m maxsize 20480m

Extent management Local;

/* 2nd step: Create a datasheet space/*

Create Tablespace User_data