建库时有一个参数设置:
CREATE DATABASE [database]
[MAXINSTANCES integer]
教材中对MAXINSTANCES的解释为:
is the maximum number of instances that can simultaneously mount and open the database
8i不是不允许多个INSTANCE同时登录DB吗?
什么情况是多个INSTANCE同时登录DB,哪位前辈能给小弟举个实际例子。
谢谢
A database can serve multiple instances, and the SID parameter in the connect descriptor has been replaced by SERVICE_NAME and INSTANCE_NAME. The SERVICE_NAME is typically set to the global database name, which consists of the database name and the domain name. The parameter INSTANCE_NAME is required only for a parallel server configuration.
一台机器上,装一个Oracle,可以建立多个instances 。只是具有不同的ORACLE_SID和ORACLE_HOME。