Oracle 10g Learning Series (1)

Recently there is time to learn Oracle, the process of learning to organize out, the long learning path, now just start.

1. #su-oracle

2. Start monitoring

$ lsnrctl Start

3. Start EM

$ emctl Start Dbconsole

http://192.168.88.139:1158/em/

4. Start Isql*plus

$ isqlplusctl Start

http://192.168.88.139:5560/isqlplus/

5. Connect to the database

[Email protected] ~]$ Sqlplus/as SYSDBA

Sql*plus:release 10.2.0.1.0-production on Mon Dec 22 07:01:37 2014

Copyright (c) 1982, 2005, Oracle. All rights reserved.

Connected to an idle instance.

Sql>

6. Start the database

Sql> startup;

7. Create user bob, password admin

Sql>create user Bob identified by admin;

8. Give the DBA authority to Bob

Sql>grant DBA to Bob;

9. Cancellation of Authorization

Sql>revoke dba from Bob;

10. Delete a user

Sql>drop user Bob;

This article is from "Kaka West" blog, please be sure to keep this source http://whnba.blog.51cto.com/1215711/1592757

Oracle 10g Learning Series (1)