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

  • 相关阅读:
    一年拿两证?初级会计和中级会计可以同时报考吗?
    Spring Cloud Alibaba:Nacos服务治理平台
    Linux初级知识大全(一)
    【半导体行业革新】一键体验智能门户,在线客服+试用申请,效率翻倍!
    【Qt之json文件】json文件介绍及相关读写类介绍、示例
    故障分析 | OceanBase Proxy 无法连接 OBserver 集群
    补坑:Java的字符串String类(1)
    Linux相关命令
    Python学习基础笔记七——元组
    EXPLAIN详解(MySQL)
  • 原文地址:https://blog.csdn.net/u011868279/article/details/127669069