oracle中怎么查询实例名与实例状态

这篇文章给大家介绍oracle中怎么查询实例名与实例状态，内容非常详细，感兴趣的小伙伴们可以参考借鉴，希望对大家能有所帮助。

创新互联建站长期为上千多家客户提供的网站建设服务，团队从业经验10年，关注不同地域、不同群体，并针对不同对象提供差异化的产品和服务；打造开放共赢平台，与合作伙伴共同营造健康的互联网生态环境。为泰州企业提供专业的成都网站建设、网站制作，泰州网站改版等技术服务。拥有十载丰富建站经验和众多成功案例,为您定制开发。

一、查看实例名、表等

[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; #数据库全局名称

GLOBAL_NAME

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

ORCL

SQL> show parameter global_names;

NAME TYPE VALUE

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

global_names boolean FALSE

SQL> select status from v$instance;

STATUS # 手把手

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

OPEN

二、启动几个阶段状态实验

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

# 数据库open_mode的read only和read write，改变了需要重新启动数据库。

关于oracle中怎么查询实例名与实例状态就分享到这里了，希望以上内容可以对大家有一定的帮助，可以学到更多知识。如果觉得文章不错，可以把它分享出去让更多的人看到。