- UID
- 130843
- 积分
- 0
- 精华
- 贡献
-
- 威望
-
- 活跃度
-
- D豆
-
- 在线时间
- 小时
- 注册时间
- 2004-4-27
- 最后登录
- 1970-1-1
|
发表于 2004-12-31 18:48:12
|
显示全部楼层
本人安装了多个PDS 的oracle数据库,经验如下,只需要对表空间大小进行更改,别的没有必要动。可参照以下参数:
The procedure to finish the installation of the database is described below:
From the Start Menu, pick Oracle –OraHome92 > Configuration and Migration Tools -> Database Configuration Assistant. In the Welcome Screen, click Next.
Step 1 - Choose Create Database and then Next.
Step 2 - (Database Templete) - Choose New Database, Next.
Step 3 - (Database Identification) - Enter the Gobal Database Name (name.domain - ex. pds.intergraph.com), click Next.
Step 4 - (Database Options) - Remove checks from Oracle Ultra Search, Example Schemas, Human Resources, Sales History. Click Next.
Step 5 - (Database Connection Options) - Select Dedicated Server Mode and click Next.
Step 6 - (Initializaion Parameters) - accept the defaults for Archive, DB Sizing and File Locations. Click Next.
Step 7 - (Database Storage) - Expand Tablespaces. For each of the tablespaces turn off Autoextend.
a) System. On the Storage tab, select Managed in Dictionary, change Initial to 100KB, Next 100KB, Minimum Size 0KB, Increment size by 1%, Minimum number 1, Max number 121.
b) Users. Change name to PDS, size to 300MB. Under Storage, select Managed in Dictionary, change Initial to 50KB, Next 50KB, Minimum Size 0KB, Increment Size By 1%, Minimum number 1, Max number 121.
c) Rollback_segs. Create a rollback_segs tablespace size 50MB. Under Storage, select Managed in Dictionary, change Initial to 512KB, Next 512KB, Minimum Size 0KB, Increment Size By 1%, Minimum number 2, Max number 4096.
d) Delete the INDX tablespace.
e) Temporary. Change name to Temp_Segs size 30MB. Under Storage, select Managed in Dictionary, change Initial to 100KB, Next 100KB, Minimum Size 0KB, Increment Size By 1%, Minimum number 1, Max number 121.
f) Create 20 rollback segments in the rollback_segs tablespace. Click Next
Step 8 (Creation Options) - verify that Create Database is checked, click Finish.
Step 9 (Summary) - click OK to create the database. (Database will take approximately 10 to 20 minutes to complete.)
Step 10 (Finish) – change the default passwords and click |
|