• oracle11g grid 单实例数据库停止启动


     停止数据库

    [oracle@localhost ~]$ . oraenv
    ORACLE_SID = [orcl] ? orcl
    The Oracle base for ORACLE_HOME=/u01/app/oracle/product/11.2.0/dbhome_1 is /u01/app/oracle
    [oracle@localhost ~]$
    [oracle@localhost ~]$ sqlplus / as sysdba

    SQL*Plus: Release 11.2.0.1.0 Production on Wed Nov 2 22:50:37 2022

    Copyright (c) 1982, 2009, Oracle.  All rights reserved.


    Connected to:
    Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
    With the Partitioning, Automatic Storage Management, OLAP, Data Mining
    and Real Application Testing options

    SQL>
    SQL>
    SQL> shutdown immediate;
    Database closed.
    Database dismounted.
    ORACLE instance shut down.

    SQL> exit
    Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
    With the Partitioning, Automatic Storage Management, OLAP, Data Mining
    and Real Application Testing options
    [oracle@localhost ~]$
    [oracle@localhost ~]$ . oraenv
    ORACLE_SID = [orcl] ? +ASM
    The Oracle base for ORACLE_HOME=/u01/app/oracle/product/11.2.0/grid is /u01/app/oracle
    [oracle@localhost ~]$
    [oracle@localhost ~]$
    [oracle@localhost ~]$ sqlplus / as sysasm

    SQL*Plus: Release 11.2.0.1.0 Production on Wed Nov 2 22:54:57 2022

    Copyright (c) 1982, 2009, Oracle.  All rights reserved.


    Connected to:
    Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
    With the Automatic Storage Management option

    SQL> shutdown immediate;
    ORA-15097: cannot SHUTDOWN ASM instance with connected client
    SQL> shutdown immediate;
    ORA-15097: cannot SHUTDOWN ASM instance with connected client
    SQL> shutdown immediate;
    ORA-15097: cannot SHUTDOWN ASM instance with connected client
    SQL> exit
    Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
    With the Automatic Storage Management option
    [oracle@localhost ~]$
    [oracle@localhost ~]$
    [oracle@localhost ~]$ . oraenv
    ORACLE_SID = [+ASM] ? orcl
    The Oracle base for ORACLE_HOME=/u01/app/oracle/product/11.2.0/dbhome_1 is /u01/app/oracle
    [oracle@localhost ~]$ . oraenv
    ORACLE_SID = [orcl] ? orcl2
    The Oracle base for ORACLE_HOME=/u01/app/oracle/product/11.2.0/dbhome_1 is /u01/app/oracle
    [oracle@localhost ~]$ sqlplus / as sysdba

    SQL*Plus: Release 11.2.0.1.0 Production on Wed Nov 2 22:57:37 2022

    Copyright (c) 1982, 2009, Oracle.  All rights reserved.


    Connected to:
    Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
    With the Partitioning, Automatic Storage Management, OLAP, Data Mining
    and Real Application Testing options

    SQL> shutdown immediate;
    Database closed.
    Database dismounted.
    ORACLE instance shut down.

    SQL> exit
    Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
    With the Partitioning, Automatic Storage Management, OLAP, Data Mining
    and Real Application Testing options
    [oracle@localhost ~]$
    [oracle@localhost ~]$ . oraenv
    ORACLE_SID = [orcl2] ? +ASM
    The Oracle base for ORACLE_HOME=/u01/app/oracle/product/11.2.0/grid is /u01/app/oracle
    [oracle@localhost ~]$
    [oracle@localhost ~]$
    [oracle@localhost ~]$ sqlplus / as sysasm

    SQL*Plus: Release 11.2.0.1.0 Production on Wed Nov 2 22:58:27 2022

    Copyright (c) 1982, 2009, Oracle.  All rights reserved.


    Connected to:
    Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
    With the Automatic Storage Management option

    SQL> shutdown immediate;
    ASM diskgroups dismounted
    ASM instance shutdown

    SQL> exit
    Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
    With the Automatic Storage Management option
    [oracle@localhost ~]$

    启动数据库:

    [oracle@localhost ~]$
    [oracle@localhost ~]$
    [oracle@localhost ~]$ . oraenv
    ORACLE_SID = [+ASM] ? +ASM
    The Oracle base for ORACLE_HOME=/u01/app/oracle/product/11.2.0/grid is /u01/app/oracle
    [oracle@localhost ~]$
    [oracle@localhost ~]$ sqlplus / as sysasm

    SQL*Plus: Release 11.2.0.1.0 Production on Wed Nov 2 23:08:56 2022

    Copyright (c) 1982, 2009, Oracle.  All rights reserved.

    Connected to an idle instance.

    SQL> startup
    ASM instance started

    Total System Global Area  283930624 bytes
    Fixed Size                  2212656 bytes
    Variable Size             256552144 bytes
    ASM Cache                  25165824 bytes
    ASM diskgroups mounted

    SQL>
    SQL> exit
    Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
    With the Automatic Storage Management option
    [oracle@localhost ~]$
    [oracle@localhost ~]$ . oraenv
    ORACLE_SID = [+ASM] ? orcl
    The Oracle base for ORACLE_HOME=/u01/app/oracle/product/11.2.0/dbhome_1 is /u01/app/oracle
    [oracle@localhost ~]$
    [oracle@localhost ~]$ sqlplus / as sysdba

    SQL*Plus: Release 11.2.0.1.0 Production on Wed Nov 2 23:10:53 2022

    Copyright (c) 1982, 2009, Oracle.  All rights reserved.

    Connected to an idle instance.

    SQL> startup
    ORACLE instance started.

    Total System Global Area 2304909312 bytes
    Fixed Size                  2215464 bytes
    Variable Size            1375732184 bytes
    Database Buffers          922746880 bytes
    Redo Buffers                4214784 bytes
    Database mounted.
    Database opened.

    SQL>
    SQL> exit
    Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
    With the Partitioning, Automatic Storage Management, OLAP, Data Mining
    and Real Application Testing options
    [oracle@localhost ~]$
    [oracle@localhost ~]$ . oraenv
    ORACLE_SID = [orcl] ? orcl2
    The Oracle base for ORACLE_HOME=/u01/app/oracle/product/11.2.0/dbhome_1 is /u01/app/oracle
    [oracle@localhost ~]$
    [oracle@localhost ~]$ sqlplus / as sysdba

    SQL*Plus: Release 11.2.0.1.0 Production on Wed Nov 2 23:15:35 2022

    Copyright (c) 1982, 2009, Oracle.  All rights reserved.

    Connected to an idle instance.

    SQL> startup
    ORACLE instance started.

    Total System Global Area 1603411968 bytes
    Fixed Size                  2213776 bytes
    Variable Size             419432560 bytes
    Database Buffers         1174405120 bytes
    Redo Buffers                7360512 bytes
    Database mounted.
    Database opened.

    SQL> exit
    Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
    With the Partitioning, Automatic Storage Management, OLAP, Data Mining
    and Real Application Testing options
    [oracle@localhost ~]$
    [oracle@localhost ~]$

  • 相关阅读:
    学姐想学SpringBoot?连夜整理了一份SpringBoot高阶笔记,涵盖六大核心专题
    redis使用rightPushAll保存List,List的size为1
    前端知识案例101-javascript基础语法-捕获介绍
    Oracle Analytics BIEE 操作方法(六)数据格式1:百分比
    分布式锁的实现
    GaussDB数据库SQL系列-游标管理
    HTML5day02综合案例2
    浅谈One API
    【Android知识笔记】Webview专题
    数据库基本概念
  • 原文地址:https://blog.csdn.net/u011868279/article/details/127669069