$ . oraenv
ORACLE_SID = [orcl] ? +ASM
The Oracle base
for
ORACLE_HOME=
/u01/app/oracle/product/11
.2.0
/grid
is
/u01/app/oracle
$ crs_stat -t
Name Type Target State Host
------------------------------------------------------------
ora.DATA.dg ora....up.
type
ONLINE ONLINE ora11g
ora.FRA.dg ora....up.
type
ONLINE ONLINE ora11g
ora....ER.lsnr ora....er.
type
ONLINE ONLINE ora11g
ora.asm ora.asm.
type
ONLINE ONLINE ora11g
ora.cssd ora.cssd.
type
ONLINE ONLINE ora11g
ora.diskmon ora....on.
type
ONLINE ONLINE ora11g
ora.orcl.db ora....se.
type
ONLINE ONLINE ora11g
$ sqlplus / as sysdba
SQL*Plus: Release 11.2.0.1.0 Production on Thu Jun 13 21:49:34 2013
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>
select
status from
v
$instance;
STATUS
------------------------------------
STARTED
SQL>
exit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Automatic Storage Management option
[oracle@ora11g ~]$ . 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@ora11g ~]$ sqlplus / as sysdba
SQL*Plus: Release 11.2.0.1.0 Production on Thu Jun 13 21:50:45 2013
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>
select
status from
v
$instance;
STATUS
------------
OPEN
