MERCADOS FINANCIEROS

martes, 7 de julio de 2020

SRVCTL BAJAR Y SUBIR INSTANCIA ORACLE - GRID INFRAESTRUCTURE

$ srvctl stop database -d acme -o immediate
$ srvctl start database -d acme -o open

[oracle@localhost ~]$ srvctl stop database -d acme -o immediate
[oracle@localhost ~]$ ps -fea | grep pmon
oracle    3522     1  0 Nov13 ?        00:02:33 asm_pmon_+ASM
oracle    5516     1  0 Nov13 ?        00:02:23 ora_pmon_orcl
oracle   26152  3769  0 21:34 pts/3    00:00:00 grep pmon
[oracle@localhost ~]$ 
[oracle@localhost ~]$ srvctl start database -d acme -o open
[oracle@localhost ~]$ ps -fea | grep pmon
oracle    3522     1  0 Nov13 ?        00:02:33 asm_pmon_+ASM
oracle    5516     1  0 Nov13 ?        00:02:23 ora_pmon_orcl
oracle   26188     1  0 21:34 ?        00:00:00 ora_pmon_acme
oracle   26316  3769  0 21:35 pts/3    00:00:00 grep pmon
[oracle@localhost ~]$ . oraenv
ORACLE_SID = [orcl] ? acme
The Oracle base remains unchanged with value /u01/app/oracle
[oracle@localhost ~]$ sqlplus / as sysdba

SQL*Plus: Release 12.1.0.1.0 Production on Mon Nov 23 21:35:23 2020

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


Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.1.0 - 64bit Production
With the Partitioning, Automatic Storage Management, OLAP, Advanced Analytics
and Real Application Testing options

SQL> select open_mode from v$database;  

OPEN_MODE
--------------------
READ WRITE

No hay comentarios: