注：以下步骤是一个实例，参考者注意修改参数值，比如用户名，SID,端口等(注意红色部分)！ 1 ． 创建帐务数据库用户:ora_billuseradd - d / LCdisk / oradata / bill - g dba ora_billroot: / LCdisk / oradata / bill > passwd ora_billsu – ora_bill 2 ． 创建环境变量ORACLE_SID = testbill; 3 .创建文件 oracle: / home / oracle / product / 9.2 . 0 / dbs > more inittestacct.ora > inittestbill.oraroot: / home / oracle / product / 9.2 . 0 / dbs > chown ora_bill inittestbill.ora添加该文件内容 #cache and I / ODB_BLOCK_SIZE = 8192 DB_CACHE_SIZE = 20971520 # Cursors and Library Cache#CURSOR_SHARING = SIMILAROPEN_CURSORS = 300 # Diagnostics and Statistics BACKGROUND_DUMP_DEST = ' /LCdisk/oradata/bill/admin/bdump ' CORE_DUMP_DEST =/ LCdisk / oradata / bill / admin / cdump#TIMED_STATISTICS = TRUEUSER_DUMP_DEST = ' /LCdisk/oradata/bill/admin/udump ' # Control File Configurationcontrol_files = (" / LCdisk / oradata / bill / ctlfile1", " / LCdisk / oradata / bill / ctlfile2")# ArchiveLOG_ARCHIVE_DEST_1 = ' LOCATION=/LCdisk/oradata/bill/archive ' LOG_ARCHIVE_FORMAT =% t_ % s.dbfLOG_ARCHIVE_START = FALSE# Shared Server# Uncomment and use first DISPATCHES parameter below when your listener is # configured for SSL# (listener.ora and sqlnet.ora)# DISPATCHERS = "(PROTOCOL = TCPS)(SER = MODOSE)",dispatchers = ' (PROTOCOL=TCP) (SERVICE=testbillXDB) ' # MiscellaneousCOMPATIBLE = 9.2 . 0 DB_NAME = testbillINSTANCE_NAME = testbillManually Creating an Oracle Database # PoolsJAVA_POOL_SIZE = 31457280 LARGE_POOL_SIZE = 1048576 SHARED_POOL_SIZE = 52428800 # Processes and SessionsPROCESSES = 150 # Redo Log and Recovery#FAST_START_MTTR_TARGET = 300 # Resource Manager#RESOURCE_MANAGER_PLAN = SYSTEM_PLAN# Sort, Hash Joins, Bitmap IndexesSORT_AREA_SIZE = 524288 # Automatic Undo ManagementUNDO_MANAGEMENT = AUTOUNDO_TABLESPACE = undotbs 4 .修改文件ora_bill: / home / oracle / product / 9.2 . 0 / network / admin > vi listener.ora添加内容 LISTENER3 = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 10.100 . 8.91 )(PORT = 1525 )) ) SID_LIST_LISTENER3 = (SID_LIST = (SID_DESC = (GLOBAL_DBNAME = testbill) (ORACLE_HOME = / home / oracle / product / 9.2 . 0 ) (SID_NAME = testbill) ) ) 5 .修改文件ora_bill: / home / oracle / product / 9.2 . 0 / network / admin > vi tnsnames.ora添加内容 TESTBILL = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 10.100 . 8.91 )(PORT = 1525 )) ) (CONNECT_DATA = (SERVICE_NAME = testbill) ) ) 6 .创建目录 ora_bill: / LCdisk / oradata / bill / admin / udump > ora_bill: / LCdisk / oradata / bill / admin / bdump > ora_bill: / LCdisk / oradata / bill / admin / cdump > root: / LCdisk / oradata / bill / admin > chown oracle * root: / LCdisk / oradata / bill > chmod - R 777 adminroot: / LCdisk / oradata / bill / admin > su - ora_bill 7 .创建数据库实例 ora_bill: / LCdisk > sqlplus / nologSQL > conn / as sysdbaSQL > startup nomountSQL > CREATE DATABASE TESTBILL 2 USER SYS IDENTIFIED BY hncs 3 USER SYSTEM IDENTIFIED BY hncs 4 LOGFILE GROUP 1 ( ' /LCdisk/oradata/bill/redo01.log ' ) SIZE 256M, 5 GROUP 2 ( ' /LCdisk/oradata/bill/redo02.log ' ) SIZE 256M, 6 GROUP 3 ( ' /LCdisk/oradata/bill/redo03.log ' ) SIZE 256M 7 MAXLOGFILES 5 8 CHARACTER SET ZHS16GBK 9 NATIONAL CHARACTER SET AL16UTF16 10 DATAFILE ' /LCdisk/oradata/bill/system01.dbf ' SIZE 1024M REUSE 11 DEFAULT TEMPORARY TABLESPACE tempts1 12 TEMPFILE ' /LCdisk/oradata/bill/temp01.dbf ' 13 SIZE 4096M REUSE 14 UNDO TABLESPACE undotbs 15 DATAFILE ' /LCdisk/oradata/bill/undotbs01.dbf ' 16 SIZE 4096M REUSE AUTOEXTEND ON NEXT 5120K MAXSIZE UNLIMITED; Database created. SQL > create user testbill identified by " 1234 "; 2 / User created. SQL > grant dba to testbill; Grant succeeded. SQL > grant connect to testbill; Grant succeeded. 8 . 运行脚本（创建系统对象） -- -------------------------------------------------------------------------------- @ / home / oracle / product / 9.2 . 0 / rdbms / admin / catalog.sql; @ / home / oracle / product / 9.2 . 0 / rdbms / admin / catexp7.sql; @ / home / oracle / product / 9.2 . 0 / rdbms / admin / catblock.sql; @ / home / oracle / product / 9.2 . 0 / rdbms / admin / catproc.sql; @ / home / oracle / product / 9.2 . 0 / rdbms / admin / catoctk.sql; @ / home / oracle / product / 9.2 . 0 / rdbms / admin / owminst.plb;connect SYSTEM / manager @ / home / oracle / product / 9.2 . 0 / sqlplus / admin / pupbld.sql; -- --------------------------------------------------------------------- connect SYSTEM / manager @ / home / oracle / product / 9.2 . 0 / sqlplus / admin / help / hlpbld.sql; (param:helpus) -- //.sql) 9 .重启数据库 SQL > conn / as sysdbaConnected. SQL > shutdown immediate Database closed. Database dismounted.ORACLE instance shut down. SQL > startupORACLE instance started. Total System Global Area 131563864 bytesFixed Size 741720 bytesVariable Size 109051904 bytes Database Buffers 20971520 bytesRedo Buffers 798720 bytes Database mounted. Database opened.
