ITPub博客

首页 > Linux操作系统 > Linux操作系统 > Part1-数据库安装步骤1-3

Part1-数据库安装步骤1-3

原创 Linux操作系统 作者:dl0218 时间:2008-09-16 08:19:18 0 删除 编辑

oracle安装步骤
Task 1: Evaluate the Database Server Hardware  估计服务器的硬件
Evaluate how Oracle Database and its applications can best use the available computer resources. This evaluation should reveal the following information:   估计oracle和应用软件最好的可用状态消耗的资源。评估的信息应如下:


 How many disk drives are available to the Oracle products
 需要多少的硬盘驱动器给oracle数据库。
 How many, if any, dedicated tape drives are available to Oracle products
 需要多少专用磁带驱动器给oracle
 How much memory is available to the instances of Oracle Database you will run (see your system configuration documentation)
 需要多少内存给oracle实例(参考你的系统配置文件)

个人认为这里主要是依靠经验,首先看看你数据的年增长量,看看并发数量,系统响应时间要求。

 

Task 2: Install the Oracle Database Software  安装oracle数据库软件


As the database administrator, you install the Oracle Database server software and any front-end tools and database applications that access the database. 作为数据库管理员,你安装oracle数据库服务器软件,任何前端工具,数据库应用链结到数据库。
In some distributed processing installations, the database is controlled by a central computer (database server) and the database tools and applications are executed on remote computers (clients). 在一些分布式处理的安装,数据库是中心电脑,数据库工具和应用执行在客户机。
In this case, you must also install the Oracle Net components
necessary to connect the remote machines to the computer that executes Oracle Database.这个案例,你必须安装Oracle Net组件为了链接和执行到远程的数据库。

Task 3: Plan the Database 数据库规划


As the database administrator, you must plan:
作为数据库管理员, 你必须做下列规划
 The logical storage structure of the database 数据库的逻辑存储结构
 The overall database design 数据库总体设计
 A backup strategy for the database 数据库的备份策略
It is important to plan how the logical storage structure of the database will affect system performance and various database management operations.这个计划十分重要,数据库的逻辑存储结构将影响数据库的性能和数据库的管理操作。
For example, before creating any tablespaces for your database, you should know how many datafiles will make up the tablespace, what type of information will be stored in each tablespace, and on which disk drives the datafiles will be physically stored.
例如:创建任意一个表空间,表空间上数据文件使用那个驱动器的物理存储。
When planning the overall logical storage of the database structure, take into account the effects that this structure will have when the database is actually created and running.
当编制总体数据库逻辑结构计划,这个计划的重要性在于,它将会影响数据库的创建与运行。
Consider how the logical storage structure of the database will affect:
考虑数据库的逻辑存储结构影响如下:
 The performance of the computer executing running Oracle Database
oracle数据库的运行性能
 The performance of the database during data access operations
数据库的数据存取性能。
 The efficiency of backup and recovery procedures for the database
数据库备份与恢复程序的效率
Plan the relational design of the database objects and the storage characteristics for each of these objects.
计划的相关设计包括;数据库对象和每个对象的存储特征。
By planning the relationship between each object and its physical storage before creating it, you can directly affect the performance of the database as a unit.
通过这个计划关系到每个对象之间的和它们的物理结构在创建它们之前,计划能直接的影响数据库的整体性能。
Be sure to plan for the growth of the database.
当然这个计划要为数据库增长打算。
In distributed database environments, this planning stage is extremely important. The physical location of frequently accessed data dramatically affects application performance.分布式数据库环境,它计划的编制十分重要。经常的物理访问位置显著的影响数据库的性能。
During the planning stage, develop a backup strategy for the database.

You can alter the logical storage structure or design of the database to improve backup efficiency.
你能改变数据库的逻辑存储结构和设计,提高数据备份效率。
It is beyond the scope of this book to discuss relational and distributed database design.
If you are not familiar with such design issues, please refer to accepted industry-standard documentation. Part II, "Oracle Database Structure and Storage", and Part IV, "Schema Objects", provide specific information on creating logical storage structures, objects, and integrity constraints for your database.

个人认为这里主要表空间分开放,undo、log、归档、数据文件等等。根据业务情况设置表空间的存储特征。

来自 “ ITPUB博客 ” ,链接:https://blog.itpub.net/23226/viewspace-448497/ ,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论

注册时间:2008-05-09

  • 博文量
    4
  • 访问量
    4874