Oracle11g手工创建数据库.doc

- #- *1. Linux 下：- *01). 修改初始化参数文件：($ORACLE_HOME/dbs目录下)- inityktdora.ora-yktdora._db_cache_size=6576668672yktdora._java_pool_size=67108864yktdora._large_pool_size=67108864yktdora._oracle_base=/opt/oracle#ORACLE_BASE set from environmentyktdora._pga_aggregate_target=5435817984yktdora._sga_target=8120172544yktdora._shared_io_pool_size=0yktdora._shared_pool_size=1275068416yktdora._streams_pool_size=0*.audit_file_dest=/opt/oracle/admin/yktdora/adump*.audit_trail=db*.compatible=.0*.control_files=/data/oracle/oradata/yktdora/control01.ctl,/opt/oracle/flash_recovery_area/yktdora/control02.ctl*.db_block_size=32768*.db_domain=*.db_name=yktdora*.db_recovery_file_dest=/opt/oracle/flash_recovery_area*.db_recovery_file_dest_size=429496729600*.LOG_ARCHIVE_DEST_1=LOCATION=/opt/oracle/arch*.LOG_ARCHIVE_DEST_STATE_1=ENABLE*.LOG_ARCHIVE_FORMAT=%r_%t_%s.arc*.diagnostic_dest=/opt/oracle*.dispatchers=(PROTOCOL=TCP) (SERVICE=yktdoraXDB)*.memory_target.open_cursors=300*.processes=150*.remote_login_passwordfile=EXCLUSIVE*.star_transformation_enabled=TRUE*.undo_tablespace=UNDOTBS1- *02). 运行下面的脚本，创建数据库：(相关的目录事先创建好)- createdatabase.sqlstartup nomount;CREATE DATABASE yktdadv datafile /data/oraadv/oraadv_data/yktdadv/system01.dbf size 2048M autoextend on next 1024M extent management local sysaux datafile /data/oraadv/oraadv_data/yktdadv/sysaux01.dbf size 2048M undo tablespace undotbs1 datafile /data/oraadv/oraadv_data/yktdadv/undotbs01.dbf size 20480M default temporary tablespace temp tempfile /data/oraadv/oraadv_data/yktdadv/temp01.dbf size 20480M logfile group 1 (/data/oraadv/oraadv_data/yktdadv/redo01.log) size 1024M, group 2 (/data/oraadv/oraadv_data/yktdadv/redo02.log) size 1024M, group 3 (/data/oraadv/oraadv_data/yktdadv/redo03.log) size 1024M, group 4 (/data/oraadv/oraadv_data/yktdadv/redo04.log) size 1024M CHARACTER SET AL32UTF8 NATIONAL CHARACTER SET AL16UTF16user sys identified by bee56915user system identified by bee56915;- *03). 创建数据库默认表空间：CREATE TABLESPACE users datafile /data/oraadv/oraadv_data/yktdadv/users01.dbf size 2048M;alter database default tablespace users;- *04). 创建数据字典：/opt/oraadv/product/oraadv_11.2.0/db_2/rdbms/admin/catalog.sql- *05). 执行catproc创建包：/opt/oraadv/product/oraadv_11.2.0/db_2/rdbms/admin/catproc.sql/opt/oraadv/product/oraadv_11.2.0/db_2/rdbms/admin/catexp.sql- *06). 执行pupbld.sql脚本文件：/opt/oraadv/product/oraadv_11.2.0/db_2/sqlplus/admin/pupbld.sql- *07). 创建spfileSQL create spfile from pfile;- *08). 创建scott测试用户/opt/oraadv/product/oraadv_11.2.0/db_2/rdbms/admin/scott.sql- 核对数据库字符集：sysYKTDORA select * from v$nls_parameters;PARAMETER VALUE- -NLS_LANGUAGE AMERICANNLS_TERRITORY AMERICANLS_CURRENCY $NLS_ISO_CURRENCY AMERICANLS_NUMERIC_CHARACTERS .,NLS_CALENDAR GREGORIANNLS_DATE_FORMAT DD-MON-RRNLS_DATE_LANGUAGE AMERICANNLS_CHARACTERSET AL32UTF8NLS_SORT BINARYNLS_TIME_FORMAT HH.MI.SSXFF AMNLS_TIMESTAMP_FORMAT DD-MON-RR HH.MI.SSXFF AMNLS_TIME_TZ_FORMAT HH.MI.SSXFF AM TZRNLS_TIMESTAMP_TZ_FORMAT DD-MON-RR HH.MI.SSXFF AM TZRNLS_DUAL_CURRENCY $NLS_NCHAR_CHARACTERSET AL16UTF16NLS_COMP BINARYNLS_LENGTH_SEMANTICS BYTENLS_NCHAR_CONV_EXCP FALSE19 rows selected.- 1* select * from v$nls_parametersSQL /PARAMETER VALUE- -NLS_LANGUAGE AMERICANNLS_TERRITORY AMERICANLS_CURRENCY $NLS_ISO_CURRENCY AMERICANLS_NUMERIC_CHARACTERS .,NLS_CALENDAR GREGORIANNLS_DATE_FORMAT DD-MON-RRNLS_DATE_LANGUAGE AMERICANNLS_CHARACTERSET AL32UTF8NLS_SORT BINARYNLS_TIME_FORMAT HH.MI.SSXFF AMNLS_TIMESTAMP_FORMAT DD-MON-RR HH.MI.SSXFF AMNLS_TIME_TZ_FORMAT HH.MI.SSXFF AM TZRNLS_TIMESTAMP_TZ_FORMAT DD-MON-RR HH.MI.SSXFF AM TZRNLS_DUAL_CURRENCY $NLS_NCHAR_CHARACTERSET AL16UTF16NLS_COMP BINARYNLS_LENGTH_SEMANTICS BYTENLS_NCHAR_CONV_EXCP FALSE19 rows selected.-yktdadv._db_cache_size=6576668672yktdadv._java_pool_size=67108864yktdadv._large_pool_size=67108864yktdadv._oracle_base=/opt/oraadv#ORACLE_BASE set from environmentyktdadv._pga_aggregate_target=5435817984yktdadv._sga_target=8120172544yktdadv._shared_io_pool_size=0yktdadv._shared_pool_size=1275068416yktdadv._streams_pool_size=0*.audit_file_dest=/opt/oraadv/admin/yktdadv/adump*.audit_trail=db*.compatible=.0*.control_files=/data/oraadv/oraadv_data/yktdadv/control01.ctl,/data/oraadv/oraadv_data/yktdadv/control02.ctl*.db_block_size=32768*.db_domain=*.db_name=yktdadv*.db_recovery_file_dest=/opt/oraadv/flash_recovery_area*.db_recovery_file_dest_size=429496729600*.LOG_ARCHIVE_DEST_1=LOCATION=/opt/oraadv/arch*.LOG_ARCHIVE_DEST_STATE_1=ENABLE*.LOG_ARCHIVE_FORMAT=%r_%t_%s.arc*.diagnostic_dest=/opt/oraadv*.dispatchers=(PROTOCOL=TCP) (SERVICE=yktdadvXDB)*.memory_target.open_cursors=300*.processes=150*.remote_login_passwordfile=EXCLUSIVE*.star_transformation_enabled=TRUE*.undo_tablespace=UNDOTBS1- #- *2. Windows 下：- *02). 运行下面的脚本，创建数据库：(相关的目录事先创建好)- createdatabase.sqlCREATE DATABASE tdwora datafile D:appAdministratororadatatdworasystem01.dbf size 2048M autoextend on next 1024M extent management local sysaux datafile D:appAdministratororadatatdworasysaux01.dbf size 2048M undo tablespace undotbs1 datafile D:appAdministratororadatatdworaundotbs01.dbf size 20480M default temporary tablespace temp tempfile D:appAdministratororadatatdworatemp01.dbf size 20480M logfile group 1 (D:appAdministratororadatatdworaredo01.log) size 1024M, group 2 (D:appAdministratororadatatdworaredo02.log) size 1024M, group 3 (D:appAdministratororadatatdworaredo03.log) size 1024M, group 4 (D:appAdministratororadatatdworaredo04.log) size 1024M CHARACTER SET AL32UTF8 NATIONAL CHARACTER SET AL16UTF16user sys identified by bee56915user system identified by bee56915;- *03). 创建数据库默认表空间：CREATE TABLESPACE users datafile D:appAdministratororadatatdworausers01.dbf size 2048M;alter database default tablespace users;- *04). 创建数据字典：/opt/oraadv/product/oraadv_11.2.0/db_2/rdbms/admin/catalog.sql- *05). 执行catproc创建包：/opt/oraadv/product/oraadv_11.2.0/db_2/rdbms/admin/catproc.sql- *06). 执行pupbld.sql脚本文件：/opt/oraadv/product/oraadv_11.2.0/db_2/sqlplus/admin/pupbld.sql- *07). 创建spfileSQL create spfile from pfile;- *08). 创建scott测试用户/opt/oraadv/product/oraadv_11.2.0/db_2/rdbms/admin/scott.sql- 核对数据库字符集：sysYKTDORA select * from v$nls_parameters;- #- *1. Linux 下：- *01). 修改初始化参数文件：($ORACLE_HOME/dbs目录下)- inityktdtest.ora-yktdtest._db_cache_size=6576668672yktdtest._java_pool_size=67108864yktdtest._large_pool_size=67108864yktdtest._oracle_base=/opt/oracle/oraadv#ORACLE_BASE set from environmentyktdtest._pga_aggregate_target=5435817984yktdtest._sga_target=8120172544yktdtest._shared_io_pool_size=0yktdtest._shared_pool_size=1275068416yktdtest._streams_pool_size=0*.audit_file_dest=/opt/oracle/oraadv/admin/yktdtest/adump*.audit_trail=db*.compatible=.0*.control_files=/data/oraadv/oraadv_data/yktdtest/control01.ctl,/data/oraadv/oraadv_data/yktdtest/control02.ctl*.db_block_size=32768*.db_domain=*.db_name=yktdtest*.db_recovery_file_dest=/opt/oracle/oraadv/flash_recovery_area*.db_recovery_file_dest_size=429496729600*.LOG_ARCHIVE_DEST_1=LOCATION=/opt/oracle/oraadv/arch*.LOG_ARCHIVE_DEST_STATE_1=ENABLE*.LOG_ARCHIVE_FORMAT=%r_%t_%s.arc*.diagnostic_dest=/opt/oracle*.dispatchers=(PROTOCOL=TCP) (SERVICE=yktdtestXDB)*.memory_target.open_cursors=300*.processes=150*.remote_login_passwordfile=EXCLUSIVE*.star_transformation_enabled=TRUE*.undo_tablespace=UNDOTBS1- *02). 运行下面的脚本，创建数据库：(相关的目录事先创建好)- createdatabase.sqlCREATE DATABASE yktdtest datafile /data/oraadv/oraadv_data/yktdtest/system01.dbf size 2048M autoextend on next 1024M extent management local sysaux datafile /data/oraadv/oraadv_data/yktdtest/sysaux01.dbf size 2048M undo tablespace undotbs1 datafile /data/oraadv/oraadv_data/yktdtest/undotbs01.dbf size 20480M default temporary tablespace temp tempfile /data/oraadv/oraadv_data/yktdtest/temp01.dbf size 20480M logfile group 1 (/data/oraadv/oraadv_data/yktdtest/redo01.log) size 1024M, group 2 (/data/oraadv/oraadv_data/yktdtest/redo02.log) size 1024M, group 3 (/data/oraadv/oraadv_data/yktdtest/redo03.log) size 1024M, group 4 (/data/oraadv/oraadv_data/yktdtest/redo04.log) size 1024M CHARACTER SET AL32UTF8 NATIONAL CHARACTER SET AL16UTF16user sys identified by bee56915user system identified by bee56915;- *03). 创建数据库默认表空间：CREATE TABLESPACE users datafile /data/oraadv/oraadv_data/yktdtest/users01.dbf size 2048M;alter database default tablespace users;- *04). 创建数据字典：/opt/oracle/oraadv//db_1/rdbms/admin/catalog.sql- *05). 执行catproc创建包：/opt/oracle/oraadv//db_1/rdbms/admin/catproc.sql- *06). 执行pupbld.sql脚本文件：/opt/oracle/oraadv//db_1/sqlplus/admin/pupbld.sql- *07). 创建spfileSQL create spfile from pfile;- *08). 创建scott测试用户/opt/oracle/oraadv//db_1/rdbms/admin/scott.sql-ORATEST._db_cache_sizeRATEST._java_pool_size=268435456ORATEST._large_pool_size=201326592ORATEST._oracle_base=/data/11g/oratest#ORACLE_BASE set from environmentORATEST._pga_aggregate_target=32078036992ORATEST._sga_target=19461570560ORATEST._shared_io_pool_size=536870912ORATEST._shared_pool_size=4697620480ORATEST._streams_pool_size=268435456*._pga_max_size=4294967296*.audit_file_dest=/data/11g/oratest/admin/ORATEST/adump*.audit_sys_operations=TRUE*.audit_syslog_level=LOCAL1.WARNING*.audit_trail=OS*.compatible=.0*.control_files=/data/11g/oratest/oradata/ORATEST/control01.ctl,/data/11g/oratest/flash_recovery_area/ORATEST/control02.ctl#Restore Controlfile*.cursor_sharing=FORCE*.db_block_size=32768*.db_domain=com*.db_file_multiblock_read_count=512*.db_name=ORATEST*.db_recovery_file_dest=/data/11g/oratest/flash_recovery_area*.db_recovery_file_dest_size=42949672960*.db_securefile=PERMITTED*.db_unique_name=ORATESTDG1*.diagnostic_dest=/data/11g/oratest*.log_archive_dest_1=LOCATION=/data/11g/oratest/ora_arch*.LOG_ARCHIVE_DEST_STATE_1=ENABLE*.log_archive_format=%r_%t_%s.arc*.memory_max_target=45834574848*.memory_target=45834574848*.open_cursors=800*.open_links=60*.pga_aggregate_cesses=1200*.remote_login_passwordfile=EXCLUSIVE*.session_cached_cursors=80*.sga_max_size=12884901888*.sga_target=12884901888*.shared_pool_size=4294967296*.smtp_out_server=00:25*.standby_file_management=AUTO*.star_transformation_enabled=TRUE*.undo_retention=86400*.undo_tablespace=UNDOTBS1- createdatabase.sqlCREATE DATABASE oratest datafile /data/11g/oratest/oradata/ORATEST/system01.dbf size 2048M autoextend on next 1024M extent management local sysaux datafile /data/11g/oratest/oradata/ORATEST/sysaux01.dbf size 2048M undo tablespace undotbs1 datafile /data/11g/oratest/oradata/ORATEST/undotbs01.dbf size 20480M default temporary tablespace temp tempfile /data/11g/oratest/oradata/ORATEST/temp01.dbf size 20480M logfile group 1 (/data/11g/oratest/oradata/ORATEST/redo01.log) size 2048M, group 2 (/data/11g/oratest/oradata/ORATEST/redo02.log) size 2048M, group 3 (/data/11g/oratest/oradata/ORATEST