• 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 ~]$

  • 相关阅读:
    极简c++(4)类的静态成员
    Kernel源码笔记之文件系统:2. fuse——挂载
    Android ConstraintLayout
    C和指针 第12章 使用结构和指针 12.3 双链表
    信号发生器不会用?一篇文章教会你
    电源出口到国外需要做哪些检测认证?
    Windows 中 Chrome / Edge / Firefox 浏览器书签文件默认存储路径
    【数据结构与算法】总结篇:中缀表达式转后缀表达式 与 表达式树
    iOS-设置指定边圆角(左上、左下等)
    [附源码]计算机毕业设计JAVAjapm青篮汇篮球培训系统
  • 原文地址:https://blog.csdn.net/u011868279/article/details/127669069