oracle+手工创建pfile,oracle 手工创建数据库

1, 创建pfile，通cat命令将以#和空格开头的行过滤掉，放到initSID.ora文件中 pfile文件格式为init(sid).ora

cd $ORACLE_HOME/dbs

cat init.ora |grep -v ^# |grep -v ^$>initTESTSVR.ora

2, 修改pfile关键参数,然后创建参数文件中相关的文件夹

*.db_name='TESTSVR'

*.memory_target=400M

*.processes = 150

*.audit_file_dest='/u01/app/oracle/admin/TESTSVR/adump'

*.background_dump_dest='/u01/app/oracle/admin/TESTSVR/bdump'

*.core_dump_dest='/u01/app/oracle/admin/TESTSVR/cdump'

#audit_trail ='db'

*.db_block_size=8192

*.db_domain=''

*.db_recovery_file_dest='/u01/app/oracle/flash_recovery_area'

*.db_recovery_file_dest_size=2G

*.diagnostic_dest='/u01/app/oracle'

*.dispatchers='(PROTOCOL=TCP) (SERVICE=ORCLXDB)'

*.open_cursors=300

*.remote_login_passwordfile='EXCLUSIVE'

*.undo_tablespace='UNDOTBS1'

*.control_files = (/u02/datafile/ora_control01,/u02/datafile/ora_control02)

*.compatible ='11.2.0'

3, 使用pfile启动到nomount状态，通过create database命令创建数据库

create spfile from pfile

create database TESTSVR

CONTROLFILE REUSE

MAXINSTANCES 8

MAXDATAFILES 100

MAXLOGHISTORY 1

MAXLOGFILES 16

MAXLOGMEMBERS 5

character set UTF8 national character set UTF8

logfile group 1 ('/u02/oradata/TESTSVR/onlinelog/redo1.log') size 50M reuse,

group 2 ('/u02/oradata/TESTSVR/onlinelog/redo2.log') size 50M reuse,

group 3 ('/u02/oradata/TESTSVR/onlinelog/redo3.log') size 50M reuse

datafile '/u02/datafile/dbf/system.dbf' size 500M reuse autoextend on next 10M maxsize unlimited extent management local

sysaux datafile '/u02/datafile/dbf/sysaux.dbf' size 100M autoextend on next 10M maxsize unlimited

default temporary tablespace temp tempfile '/u02/datafile/dbf/temp01.dbf' size 100M reuse autoextend on next 10M maxsize unlimited

undo tablespace undotbs1 datafile '/u02/datafile/dbf/undotbs1.dbf' size 100M reuse autoextend on next 10M maxsize unlimited

USER SYS IDENTIFIED BY "oracle" USER SYSTEM IDENTIFIED BY "oracle";

4, 创建完成后数据库自动open，执行下面2个脚本

SQL>@$ORACLE_HOME/rdbms/admin/catalog.sql

SQL>@$ORACLE_HOME/rdbms/admin/catproc.sql

5, 使用spfile自动数据库

SQL> select status from v$instance;

STATUS

------------

OPEN

1 row selected.

SQL> create spfile from pfile;

File created.

SQL> shutdown immediate;

SQL> startup;

SQL> show parameter spfile;

NAME TYPE VALUE

------------------------------------ ----------- ------------------------------

_restore_spfile string

spfile string /u01/product/10.2.0/db_2/dbs/s

pfileTESTSVR.ora