oracle 手工创建数据库
1, 创建pfile，通cat命令将以#和空格开头的行过滤掉，放到initSID.ora文件中 pfile文件格式为init(sid).oracd $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')>
group 2 ('/u02/oradata/TESTSVR/onlinelog/redo2.log')>
group 3 ('/u02/oradata/TESTSVR/onlinelog/redo3.log')>
datafile '/u02/datafile/dbf/system.dbf'>
sysaux datafile '/u02/datafile/dbf/sysaux.dbf'>
default temporary tablespace temp tempfile '/u02/datafile/dbf/temp01.dbf'>
undo tablespace undotbs1 datafile '/u02/datafile/dbf/undotbs1.dbf'>
USER SYS> 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
页:
[1]