ORACLE Database Simple test

ORACLE Database Simple test

Operating system: Windows 7–

Oracle:oracle Database 10.2.0.4

First, the purpose

Test the startup listener, the database is not the same user, whether the user can log on to the database

Ii. Introduction of the environment

Operating system: Windows 7

Oracle:oracle Database 10.2.0.4

Third, the test steps

1.1 Creating a User (Rights Manager)

1.1.1.1 Checking all current users

1.1.1.2 New test User

1.1.1.3 confirm the current user

1.1.1.4 creating a password for test users

1.2 Database Mount Status

1.2.1 Current user Parim boot database to mount state

1.2.2 Restarting the Listener

1.2.3 PARIM01 User Login Database

Error: ORA-01033

Check the current database status

Thu Nov 27 10:54:23 2014

Database mounted in Exclusive Mode

Completed:alter DATABASE MOUNT

Current database is Mount state

1.3 Database Open State

1.3.1 PARIM01 user Test Login Database

Can log in normally

Check the alarm log:

Thu Nov 27 11:03:28 2014

Completed:alter DATABASE OPEN

Current database is open state

Iv. Conclusion

The database enters Mount state, in fact it is an exclusive mode, it will block other non-users of all connections. Therefore, in this case, the non-startup database himself prohibits connection to the database

Please refine your conclusion!

ORACLE Database Simple test