oracle實(shí)例名查詢、實(shí)例狀態(tài)查詢等

創(chuàng)新互聯(lián)建站是一家以網(wǎng)站建設(shè)公司、網(wǎng)頁(yè)設(shè)計(jì)、品牌設(shè)計(jì)、軟件運(yùn)維、網(wǎng)站推廣、小程序App開發(fā)等移動(dòng)開發(fā)為一體互聯(lián)網(wǎng)公司。已累計(jì)為自上料攪拌車等眾行業(yè)中小客戶提供優(yōu)質(zhì)的互聯(lián)網(wǎng)建站和軟件開發(fā)服務(wù)。

一、查看實(shí)例名、表等

[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; #數(shù)據(jù)庫(kù)全局名稱

GLOBAL_NAME

--------------------------------------------------------------------------------

ORCL

SQL> show parameter global_names;

NAME                                 TYPE        VALUE

------------------------------------ ----------- ------------------------------

global_names                         boolean     FALSE

SQL> select status from v$instance;

STATUS  #  手把手

------------

OPEN
 

二、啟動(dòng)幾個(gè)階段狀態(tài)實(shí)驗(yàn)

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

# 數(shù)據(jù)庫(kù)open_mode的read only和read write，改變了需要重新啟動(dòng)數(shù)據(jù)庫(kù)。

原文轉(zhuǎn)自：https://www.shoubashou.com/db/oracle/95.html