安裝oracle 11.2.0.1 windows 2008 x64 rac 的一點記錄

資料庫配置檔案已經安裝到 D:appAdministrator,同時其他選定的安裝元件也已經安裝到 D:appAdministratorproduct11.2.0dbhome_1。

您需要在遠端節點上執行 binselecthome.bat 以啟用以下產品:
Oracle Data Provider for .NET
Oracle Provider for OLE DB
Oracle Objects for OLE
Oracle Counters for Windows Performance Monitor
Oracle Administration Assistant

Microsoft Windows [版本 6.1.7600]
版權所有 (c) 2009 Microsoft Corporation。保留所有權利。

C:UsersAdministrator>sqlplus / as sysdba

SQL*Plus: Release 11.2.0.1.0 Production on 星期四 7月 21 18:48:59 2011

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


連線到:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management,
OLAP,
Data Mining and Real Application Testing options

SQL> show parameter defer

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
deferred_segment_creation boolean TRUE
SQL> create pfile='c:pfile0721.ora' from spfile;

檔案已建立。

SQL> alter system set deferred_segment_creation=false;

系統已更改。

SQL> create pfile='c:pfile0721.ora' from spfile;

檔案已建立。

SQL> show parameter defer

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
deferred_segment_creation boolean FALSE
SQL> exit
從 Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management,
OLAP,
Data Mining and Real Application Testing options 斷開

C:UsersAdministrator>crs_stat -t
名稱 型別 目標 狀態 主機
------------------------------------------------------------
ora.CRS.dg ora....up.type ONLINE ONLINE server1
ora.DATA.dg ora....up.type ONLINE ONLINE server1
ora....ER.lsnr ora....er.type ONLINE ONLINE server1
ora....N1.lsnr ora....er.type ONLINE ONLINE server1
ora.asm ora.asm.type ONLINE ONLINE server1
ora.eons ora.eons.type ONLINE ONLINE server1
ora.gsd ora.gsd.type OFFLINE OFFLINE
ora....network ora....rk.type ONLINE ONLINE server1
ora.oc4j ora.oc4j.type OFFLINE OFFLINE
ora.ons ora.ons.type ONLINE ONLINE server1
ora.orcl.db ora....se.type ONLINE ONLINE server1
ora.scan1.vip ora....ip.type ONLINE ONLINE server1
ora....SM1.asm application ONLINE ONLINE server1
ora....R1.lsnr application ONLINE ONLINE server1
ora....er1.gsd application OFFLINE OFFLINE
ora....er1.ons application ONLINE ONLINE server1
ora....er1.vip ora....t1.type ONLINE ONLINE server1
ora....SM2.asm application ONLINE ONLINE server2
ora....R2.lsnr application ONLINE ONLINE server2
ora....er2.gsd application OFFLINE OFFLINE
ora....er2.ons application ONLINE ONLINE server2
ora....er2.vip ora....t1.type ONLINE ONLINE server2

C:UsersAdministrator>[@more@]