oracle database and instance and oracle SID
来源:互联网 发布:mac jdk dmg安装教程 编辑:程序博客网 时间:2024/05/06 16:42
Database:
A collection of physical operating system files or disks, When using Oracle Automatic Storage Management or RAW patitions, the database
may not appear individual, separate files in the operating system, but the definition remains the same
Instance:
A set of Oracle background processes or theads and a shared memory area, which is memory that is shared across those threads or processes running on a single computer.This is the place for volatile, nonpersistent stuf,some of which gets flushed to disk, A database instance can exist without any disk storage whatsover.It might not be the most useful thing in the world, but thinking about it that way definitely helps draw the line between the instance and the database;The two terms are sometimes used interchangeably,but they embrace very different comncepts. The relationship between them is that a database may be mounted and opened by many instances.an instance may mount and open just a single database at any point in time
Oracle SID:
The SID is a site identifier. It and ORACLE_HOME are hashed together in unix to create a unique key name for creating or attaching a Shared GLobal Area memory region. If your ORACLE_SID or ORACLE_HOME is not set correctly,you will get the ORACLE NOT AVALABLE error, since you can not attach to a shared memory segment that is identified by this unique key. On windows,shared memory isn't used in the same fashion as on unix,but the SID is still important. you can have more than one database under the same ORACLE_HOME, so you need a way to uniquely identify the instance associated with each one, along with their configuration files
- oracle database and instance and oracle SID
- You are managing an Oracle Database 11g instance and an Oracle Database 10g instance on the same mac
- Defining Database and Instance
- Oracle Database Information and Performance
- Oracle database link and synonym
- 10g Manual Database Creation in Oracle (Single Instance and RAC) (文档 ID 240052.1)
- Oracle Database Instance
- Oracle Database - System Identifier (SID)
- Oracle Database - System Identifier (SID)
- oracle server+oracle instance+oracle database
- oracle基本概念:Database vs Instance
- Manual Create Oracle Database Instance
- Oracle database configuration and i/o issues
- Oracle Flashback Database and Restore Points 说明
- How to export Oracle Database and packages
- Installing Oracle Software and Building the Database
- compatibilities between Oracle database servers and clients
- Overview of Installing Oracle Database Software and Creating a Database
- SIP消息
- Linux系统调用
- 说话的艺术
- java中classpath和路径的使用
- Linux常用命令
- oracle database and instance and oracle SID
- 在D盘生成Happy 再生成sad
- 学生信息管理系统总结
- WIN7输入法不能切换
- c语言头文件
- 平面构成基础知识(补习资料)
- 老感觉C#不爽的很啊
- 选择合适的MySQL存储引擎
- PROE 提高运行效率的方法