您需要在远程节点上执行
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@]