oracle实例名查询、实例状态查询等
创新互联建站是一家以网站建设公司、网页设计、品牌设计、软件运维、网站推广、小程序App开发等移动开发为一体互联网公司。已累计为自上料搅拌车等众行业中小客户提供优质的互联网建站和软件开发服务。 一、查看实例名、表等
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. mountSQL> 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,改变了需要重新启动数据库。 原文转自:https://www.shoubashou.com/db/oracle/95.html
|
当前文章:oracle实例名查询、实例状态查询等
当前地址:http://pwwzsj.com/article/gddjeo.html