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

First, view the instance name, table, etc.

[oracle@shoubashou.com ~] $sqlplus scott/tiger@orcl

SQL > show user

USER is "SCOTT"

SQL > select * from tab

TNAME TABTYPE CLUSTERID

BONUS TABLE

DEPT TABLE

EMP TABLE

SALGRADE TABLE

SQL > conn sys/oracle@orcl as sysdba

Connected to Oracle Database 11g Enterprise Edition Release 11.2.0.3.0

Connected as sys@orcl AS SYSDBA

SQL > select name from v$database

NAME

-

ORCL

SQL > select * from global_name; # database global name

GLOBAL_NAME

ORCL

SQL > show parameter global_names

NAME TYPE VALUE

-

Global_names boolean FALSE

SQL > select status from v$instance

STATUS # handle

-

OPEN

Second, start several stage state experiments.

1. Nomount

SQL > startup nomount

ORACLE instance started.

Total System Global Area 1286066176 bytes

Fixed Size 2228024 bytes

Variable Size 352321736 bytes

Database Buffers 922746880 bytes

Redo Buffers 8769536 bytes

SQL > select status from v$instance

STATUS

-

STARTED

SQL > select open_mode from v$database

Select open_mode from v$database

*

ERROR at line 1:

ORA-01507: database not mounted

2. Mount

SQL > alter database mount

Database altered.

SQL > select status from v$instance

STATUS

-

MOUNTED

SQL > select open_mode from v$database

OPEN_MODE

-

MOUNTED

3.open

SQL > alter database open

Database altered.

SQL > select status from v$instance

STATUS

-

OPEN

SQL > select open_mode from v$database

OPEN_MODE

-

READ WRITE

4. Close

SQL > alter database close

Database altered.

SQL > select status from v$instance

STATUS

-

MOUNTED

SQL > select open_mode from v$database

OPEN_MODE

-

MOUNTED

# read only and read write of database open_mode, changing the need to restart the database.

Original text transferred from: https://www.shoubashou.com/db/oracle/95.html

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.