?
?
?
12 验证
[grid@12cAsm bin]$ crsctl status res -t
--------------------------------------------------------------------------------
Name Target State Server Statedetails
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.DATA.dg
ONLINE ONLINE 12casm STABLE
ora.asm
ONLINE ONLINE 12casm Started,STABLE
ora.ons
OFFLINE OFFLINE 12casm STABLE
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.cssd
1 ONLINE ONLINE 12casm STABLE
ora.dave.db
1 ONLINE ONLINE 12casm Open,STABLE
ora.diskmon
1 OFFLINE OFFLINE STABLE
ora.evmd
1 ONLINE ONLINE 12casm STABLE
--------------------------------------------------------------------------------
[grid@12cAsm bin]$
?
?
[oracle@12cAsm ~]$ sqlplus / as sysdba
?
SQL*Plus: Release 12.1.0.2.0 Production onSat Nov 29 15:09:37 2014
?
Copyright (c) 1982, 2014, Oracle. All rights reserved.
?
?
Connected to:
Oracle Database 12c Enterprise EditionRelease 12.1.0.2.0 - 64bit Production
With the Partitioning, Automatic StorageManagement, OLAP, Advanced Analytics
and Real Application Testing options
?
SQL> set lin 140
SQL> select * from v$version;
?
BANNER CON_ID
------------------------------------------------------------------------------------------
OracleDatabase 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production 0
PL/SQLRelease 12.1.0.2.0 - Production 0
CORE 12.1.0.2.0 Production 0
TNSfor Linux: Version 12.1.0.2.0 - Production 0
NLSRTLVersion 12.1.0.2.0 - Production 0
?
SQL> show con_name
?
CON_NAME
------------------------------
CDB$ROOT
SQL> col pdb_name for a20
SQL> select PDB_NAME,CON_UID,pdb_id,status from dba_pdbs;
?
PDB_NAME CON_UID PDB_ID STATUS
-------------------- ---------- -------------------
PDAVE 1778789142 3 NORMAL
PDB$SEED 1845119286 2 NORMAL
?
SQL> select con_id,dbid,NAME,OPEN_MODEfrom v$pdbs;
?
CON_ID DBID NAME OPEN_MODE
---------- ---------------------------------------- ----------
2 1845119286 PDB$SEED READ ONLY
3 1778789142 PDAVE READ WRITE
?
SQL>
?
?
?
?
?
?
--------------------------------------------------------------------------------------------
版权所有，文章允许转载，但必须以链接方式注明源地址，否则追究法律责任!
?
AboutDave:
--------------------------------------------------------------------------------------------
QQ: 251097186
Email: tianlesoftware@gmail.com
Blog: http://blog.csdn.net/tianlesoftware
Weibo: http://weibo.com/tianlesoftware
Twitter: http://twitter.com/tianlesoftware
Facebook: http://www.facebook.com/tianlesoftware
Linkedin: http://cn.linkedin.com/in/tianlesoftware