Shulou(Shulou.com)06/01 Report--

Recently there is time to learn oracle, sort out the learning process, a long way to learn, and now it is just the beginning.

1.#su-oracle

two。 Initiate 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

[oracle@localhost ~] $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 dba permission to bob

SQL > grant dba to bob

9. Cancel authorization

SQL > revoke dba from bob

10. Delete a user. If the user already has an object (such as TABLE,VIEW, etc.), he / she needs to take cascade.

SQL > drop user bob cascade

11. Delete ORACLE tablespace

SQL > drop tablespace tablespacename including contents and datafiles

twelve。 Unlock oracle user bob

SQL > show user

USER is "SYS"

SQL > alter user bob account unlock

SQL > conn bob/qazwsx

Connected.

SQL > show user

USER is "BOB"

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.