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中怎么查询实例名与实例状态就分享到这里了,希望以上内容可以对大家有一定的帮助,可以学到更多知识。如果觉得文章不错,可以把它分享出去让更多的人看到。
当前名称:oracle中怎么查询实例名与实例状态
文章转载:http://pwwzsj.com/article/gpjses.html