Default username and password for Oracle

I changed one machine before, And I installed all the software again, and re-configured the development environment (vs2003, vs2008, Oracle ......), It is really not easy. During this period, many problems have been encountered, but they are easy to solve. However, during Oracle installation, a database is created, and the user name and password are also set during installation. However, the login is unsuccessful and the user authorization problem is found, therefore, you can also use the Oracle system to manage user login to authorize the previous user name.

The following table lists the Default usernames and passwords in Oracle:

User name/Password	Logon identity	Description
Sys/change_on_install	Sysdba or sysoper	Normal logon is not allowed. It can be used as the default system administrator.
System/Manager	Sysdba or normal	You cannot log on with sysoper as the default system administrator.
Sysman/oem_temp		Sysman is the OMS User Name
Scott/Tiger	Normal	Common User
Aqadm/aqadm	Sysdba or normal	Advanced queue Administrator
Dbsnmp/Dbsnmp	Sysdba or normal	Copy the username that the postmaster sysman is OMS.
Scott/Tiger	Normal	Common User
Aqadm/aqadm	Sysdba or normal	Advanced queue Administrator
Dbsnmp/Dbsnmp	Sysdba or normal	Copy Administrator

 

Some simple operations:

Run-> Enter cmd-> enter sqlplus

In this case, you need to enter the user name and password to Use System

1. Create a temporary tablespace:
Create temporary tablespace test_temp
Tempfile '/Oracle/product/10.2.0/oradata/test/test_temp01.dbf'// The directory must exist.
Size 32 m
Autoextend on
Next 32 m maxsize 1024 m
Extent management local;
2. Create a data table space:
Create temporary tablespace test_data
Tempfile '/Oracle/product/10.2.0/oradata/test/test_data01.dbf'// The directory must exist.
Size 32 m
Autoextend on
Next 32 m maxsize 1024 m
Extent management local;

3. Create a user

Create User Username identified by password

Default tablespace test_data
Temporary tablespace test_temp;

4. grant permissions to users

Grant connect, resource ,...... To user name;

5. Unlock the user

Alter user system account unlock;

6. delete a user

Drop User Username cascade;