ORACLE 手动建库
--1、生成初始化参数文件$ cd /home/oracle/admin/test/pfile
$ vi init.ora
db_block_size=8192
db_file_multiblock_read_count=8
open_cursors=300
db_domain=""
db_name=test
background_dump_dest=/home/oracle/admin/test/bdump
core_dump_dest=/home/oracle/admin/test/cdump
user_dump_dest=/home/oracle/admin/test/udump
control_files=("/home/oracle/oradata/test/control01.ctl", "/home/oracle/oradata/test/control02.ctl", "/home/oracle/oradata/test/control03.ctl")
job_queue_processes=100
compatible=10.2.0.3.0
processes=500
sga_target=274726912
audit_file_dest=/home/oracle/admin/test/adump
remote_login_passwordfile=EXCLUSIVE
dispatchers="(PROTOCOL=TCP) (SERVICE=testXDB)"
pga_aggregate_target=91226112
undo_management=AUTO
undo_tablespace=UNDOTBS1
--2、连接ORACLE_SID=test实例，并以spfile启动数据库到nomount状态
$ sqlplus / as sysdba
SQL*Plus:>
Copyright (c) 1982, 2007, Oracle.All Rights Reserved.
Connected to an>
SQL> create spfile='$ORACLE_HOME/dbs/spfiletest.ora' from pfile='$ORACLE_BASE/admin/test/pfile/init.ora';
File created.
SQL> startup nomount
ORACLE instance started.
Total System Global Area276824064 bytes
Fixed>
Variable>
Database Buffers 167772160 bytes
Redo Buffers 6303744 bytes
页:
[1]