易截截图软件、单文件、免安装、纯绿色、仅160KB

11g的Oracle Grid Infrastructure

2010年05月2号  | 
23:59分类:Linux&Unix
, 管理维护
  |  编辑
  |  标签:11g
、grid

本文出自 “inthirties(男
人三十)
”博客,转载请务必注明作者和保留出处。
11g里出现了一个新角色。
Oracle Grid Infrastructure
http://download.oracle.com/docs/cd/E11882_01/install.112/e10840/oraclerestart.htm#LADBI999
The Oracle grid infrastructure for a standalone server is the Oracle
software that provides system support for an Oracle database including
volume management, file system, and automatic restart capabilities. If
you plan to use Oracle Restart or Automatic Storage Management, you must
install the grid infrastructure before installing your database. The
grid infrastructure for a standalone server is the software that
includes Oracle Restart and Automatic Storage Management. Oracle
combined the two infrastructure products into a single set of binaries
that is installed as the grid infrastructure home. The grid
infrastructure should be installed before installing Oracle Database 11g
Release 2.
Automatic Storage Management is a volume manager and a file system
for Oracle database files that supports single-instance Oracle Database
and Oracle Real Application Clusters (Oracle RAC) configurations.
Automatic Storage Management also supports a general purpose file system
for your application needs including Oracle Database binaries.
Automatic Storage Management is Oracle’s recommended storage management
solution that provides an alternative to conventional volume managers,
file systems, and raw devices.
Oracle Restart improves the availability of your Oracle database by
providing the following:
When there is a hardware or a software failure, Oracle Restart
automatically starts all Oracle components, including Oracle database
instance, Oracle Net Listener, database services, and Automatic Storage
Management.
Oracle Restart starts up components in the pro


相关文档:

转 SQL server 与Oracle开发比较

原文地址:http://www.cnblogs.com/wangxiaohuo/archive/2008/04/20/1162631.html
 
本文档主要从oracle与sql server语法上进行差异性比较,诸如两者在管理,性能,优化等方面的差异不作比较。
●概念上区别
   1.Oracle 是一种对象关系数据库管理系统(ORDBMS),而Sql server 只是关系型数据库管
&nbs ......

访问oracle数据库

1。web.config ----appSettings--<add key="LimsConnection" value="data source=yzlims;user id=lims;password = lims"/>
2.  c#代码中
using System.Data.OracleClient;     
public DataTable  GetLimsTimeInSpace(string S_SAMPLE_NAME, string S_SAMPLING_P_N,Date ......

关于Oracle事务的总结

关于Oracle事务的总结
1.什么是事务,事务的特性是什么?
事务的任务便是使数据库从一种状态变换成为另一种状态,这不同于文件系统,它是数据库所特用的。它的特性有四个:TOM总结为ACID即
原子性atomicity:语句级原子性,过程级原子性,事务级原子性
一致性consistency:状态一致,同一事务中不会有两种状态
隔离性iso ......

oracle 遍历树

oracle 怎么来遍历一个树,相比较其他方法,oracle的connect语法更能很便利的解决问题。
语法格式:
select ...
from ...
start with...
connect by prior expr=expr
order siblings by ..
start with 的功能类似于where,指明从哪个分支开始便利;
connect by 指明父节点和子节点地连接方式,关键字prior放在父节 ......
© 2009 ej38.com All Rights Reserved. 关于E健网联系我们 | 站点地图 | 赣ICP备09004571号