Solaris Ten (x86) build Oracle 10g RAC--build database

Solaris Ten (x86) build Oracle 10g RAC--build database

System environment:

Operating system: Solaris ten (X86-64)

Cluster:oracle CRS 10.2.0.1.0

Oracle:oracle 10.2.0.1.0

650) this.width=650; "src=" Http://s3.51cto.com/wyfs02/M01/58/E3/wKiom1S_b-OSHjhcAAGktznT6W4920.jpg "title=" Rac.jpg "alt=" wkiom1s_b-oshjhcaagktznt6w4920.jpg "width=" 650 "style=" padding:0px;margin:0px;vertical-align:top; Border:none; "/>

Iv. building a listener through NETCA

for listener can be established by NETCA before the library is built, or can be built when using DBCA.

650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M00/58/E7/wKioL1TAl56xSNlmAALoQZqnPW0979.jpg "style=" float: none; "title=" N1.png "alt=" Wkiol1tal56xsnlmaaloqzqnpw0979.jpg "/>

650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M02/58/E7/wKioL1TAl5-C1eceAAMJCYaIYt4401.jpg "style=" float: none; "title=" N2.png "alt=" Wkiol1tal5-c1eceaamjcyaiyt4401.jpg "/>

Listener establish success, verify:

[[email protected]:/]# crs_stat -tname            Type           Target     State     Host        ----------------- -------------------------------------------ora .... e1.lsnr application    online    online     node1       ora.node1.gsd  application     online    online    node1        ora.node1.ons  application    online    online     node1       ora.node1.vip  application     online    online    node1  &Nbsp;    ora .... e2.lsnr application    online    online     node2       ora.node2.gsd  application     online    online    node2        ora.node2.ons  application    online    online     node2       ora.node2.vip  application     ONLINE    ONLINE    node2        [[email protected]:/]# su - oracleOracle Corporation       SunOS 5.10      Generic Patch    january 2005[[email protected]:/export/home/oracle]$ lsnrctl statuslsnrctl for  Solaris: version 10.2.0.1.0 - production on 21-jan-2015 15:51:45copyright   (c)  1991, 2005, oracle.  all rights reserved. connecting to  (address= (protocol=tcp) (host=) (port=1521)) status of the  LISTENER------------------------alias                      LISTENER_NODE1Version                    TNSLSNR for  solaris: version 10.2.0.1.0 - productionstart date                 21-JAN-2015 15:50:43Uptime                     0  days 0 hr. 1 min. 2 sectrace&nbSp Level               offsecurity                   on : local os authenticationsnmp                       OFFListener Parameter File    /export/home/ora10/product/10.2.0/db_1/network/admin/listener.oraListener Log File          /export/home/ora10/product/10.2.0/db_1/network/log/listener_ node1.loglistening endpoints summary...   (description= (address= (PROTOCOL=tcp) (HOST= 192.168.8.13) (port=1521))    (description= (address= (protocol=tcp) (host=192.168.8.11) (port=1521))) Services summary ... service  "Plsextproc"  has 1 instance (s) .  instance  "PLSExtProc",  status &nBsp Unknown, has 1 handler (s)  for this service ... The command completed successfully

V. Establishment of a database through DBCA

650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M00/58/E7/wKioL1TAmEewikJBAAMMuS4G2SA257.jpg "style=" float: none; "title=" D1.png "alt=" Wkiol1tameewikjbaammus4g2sa257.jpg "/>

Building a cluster library

650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M01/58/E7/wKioL1TAmEnSnie_AAHnRU_RlQM456.jpg "style=" float: none; "title=" D2.png "alt=" Wkiol1tamensnie_aahnru_rlqm456.jpg "/>

650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M01/58/EA/wKiom1TAl3OjMxTyAAKyoesYAcM960.jpg "style=" float: none; "title=" D3.png "alt=" Wkiom1tal3ojmxtyaakyoesyacm960.jpg "/>

650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M02/58/E7/wKioL1TAmEuhQWgSAAM-ZXZvCcU142.jpg "style=" float: none; "title=" D4.png "alt=" Wkiol1tameuhqwgsaam-zxzvccu142.jpg "/>

Database Storage ASM Devices

650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M02/58/EA/wKiom1TAl3bDPaEdAANlFEJKxDc609.jpg "style=" float: none; "title=" D5.png "alt=" Wkiom1tal3bdpaedaanlfejkxdc609.jpg "/>

Establishment of ASM Instance Pfile

650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M00/58/E7/wKioL1TAmE3waBgIAAJWPTAdi1Q655.jpg "style=" float: none; "title=" D6.png "alt=" Wkiol1tame3wabgiaajwptadi1q655.jpg "/>

Build ASM DiskGroup

650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M00/58/E7/wKioL1TAmE2wAqafAALmC3k8qqM358.jpg "style=" float: none; "title=" D7.png "alt=" Wkiol1tame2waqafaalmc3k8qqm358.jpg "/>

Build ASM DiskGroup with raw

650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M00/58/EA/wKiom1TAl3jAhkF8AAKwqddg3lc157.jpg "style=" float: none; "title=" D8.png "alt=" Wkiom1tal3jahkf8aakwqddg3lc157.jpg "/>

650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M00/58/EA/wKiom1TAl3jTRkltAAKWNeaILM4231.jpg "style=" float: none; "title=" D9.png "alt=" Wkiom1tal3jtrkltaakwneailm4231.jpg "/>

650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M01/58/E7/wKioL1TAmFCi7sKTAALd6GH0Et0509.jpg "style=" float: none; "title=" D10.png "alt=" Wkiol1tamfci7sktaald6gh0et0509.jpg "/>

650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M01/58/EA/wKiom1TAl3vxsJe0AAKYrJDxKG4772.jpg "style=" float: none; "title=" D11.png "alt=" Wkiom1tal3vxsje0aakyrjdxkg4772.jpg "/>

650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M02/58/E7/wKioL1TAmFPiFDT8AAKmLOppX9I679.jpg "style=" float: none; "title=" D12.png "alt=" Wkiol1tamfpifdt8aakmloppx9i679.jpg "/>

650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M02/58/EA/wKiom1TAl32RthFPAAL4Zts5ZF4375.jpg "style=" float: none; "title=" D13.png "alt=" Wkiom1tal32rthfpaal4zts5zf4375.jpg "/>

650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M00/58/E7/wKioL1TAmFWCcxxZAAMw_tE4vz0963.jpg "style=" float: none; "title=" D14.png "alt=" Wkiol1tamfwccxxzaamw_te4vz0963.jpg "/>

Verify:

[[email protected]:/]# crs_stat -tname            Type           Target     State     Host        ----------------- -------------------------------------------ora .... sm1.asm application    online    online     Node1       ora .... e1.lsnr application    online    online     node1       ora.node1.gsd  application     online    online    node1        ora.node1.ons  application    online    online     node1       ora.node1.vip  application    ONLINE     online    node1       ora .... sm2.asm application    online    online     Node2       ora .... e2.lsnr application    online    online     node2       ora.node2.gsd  application     online    online    node2        ora.node2.ons  application    online    online     node2       ora.node2.vip  application     online    online    node2       ora.prod.db    application    online     ONLINE    node2       ora....d1.inst  application    online    online    node1        ora....d2.inst application    ONLINE     ONLINE    node2   Enquiry Asm diskgroup:sql> col name  for a20sql> select group_number,name,state,total_mb,free_mb,type from v$asm_ diskgroupgroup_number name                  STATE         TOTAL_MB     free_mb type------------ -------------------- ----------- ---------- ----------  ------           1 dg1                   MOUNTED           10244       5962 NORMAL            2 RCY1                  MOUNTED            8204       7268 normal Query rdbms instance:[[email  protected]:/export/home/oracle]$ sqlplus  '/as sysdba ' sql*plus: release 10.2.0.1.0  - Production on Wed Jan 21 17:13:50 2015Copyright  (c)  1982,  2005, oracle.  all rights reserved. Connected to:oracle database 10g enterprise edition release 10.2.0.1.0 - productionwith the partitioning, real  application clusters, olap and data mining optionssql> select  Instance_name,status from gv$instance;instance_name    status----------------  ------------prod1            openprod2             opensql> alter user scott  identified by tiger account unlock; User altered. sql> conn scott/tigerconnected.sql> select * from tab; tname                           TABTYPE   Clusterid------------------------------ ------- ----------dept                             TABLEEMP                             TABLEBONUS                            TABLESALGRADE                        table

At this point, the entire Oracle 10g RAC has been architected!

This article is from the "Tianya blog," Please make sure to keep this source http://tiany.blog.51cto.com/513694/1606987

Solaris Ten (x86) build Oracle 10g RAC--build database