关闭

oracle9i用脚本创建数据库在LINUX下

723人阅读 评论(0) 收藏 举报

 

 

 

注:以下步骤是一个实例,参考者注意修改参数值,比如用户名,SID,端口等(注意红色部分)! 

  

1. 创建帐务数据库用户:ora_bill
useradd 
-/LCdisk/oradata/bill -g dba ora_bill
root:
/LCdisk/oradata/bill>passwd ora_bill
su – ora_bill
2. 创建环境变量ORACLE_SID=testbill;
3.创建文件
    
oracle:
/home/oracle/product/9.2.0/dbs>more inittestacct.ora>inittestbill.ora
root:
/home/oracle/product/9.2.0/dbs>chown ora_bill inittestbill.ora
添加该文件内容
 
#cache 
and I/O
DB_BLOCK_SIZE
=8192
DB_CACHE_SIZE
=20971520
# Cursors 
and Library Cache
#CURSOR_SHARING
=SIMILAR
OPEN_CURSORS
=300
# Diagnostics 
and Statistics
BACKGROUND_DUMP_DEST
='/LCdisk/oradata/bill/admin/bdump'
CORE_DUMP_DEST
=/LCdisk/oradata/bill/admin/cdump
#TIMED_STATISTICS
=TRUE
USER_DUMP_DEST
='/LCdisk/oradata/bill/admin/udump'
# Control 
File Configuration
control_files 
= ("/LCdisk/oradata/bill/ctlfile1", "/LCdisk/oradata/bill/ctlfile2")
# Archive
LOG_ARCHIVE_DEST_1
='LOCATION=/LCdisk/oradata/bill/archive'
LOG_ARCHIVE_FORMAT
=%t_%s.dbf
LOG_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)'
# Miscellaneous
COMPATIBLE
=9.2.0
DB_NAME=testbill
INSTANCE_NAME
=testbill
Manually Creating an Oracle 
Database
# Pools
JAVA_POOL_SIZE
=31457280
LARGE_POOL_SIZE
=1048576
SHARED_POOL_SIZE
=52428800
# Processes 
and Sessions
PROCESSES
=150
# Redo 
Log and Recovery
#FAST_START_MTTR_TARGET
=300
# Resource Manager
#RESOURCE_MANAGER_PLAN
=SYSTEM_PLAN
# Sort, Hash Joins, Bitmap Indexes
SORT_AREA_SIZE
=524288
# Automatic Undo Management
UNDO_MANAGEMENT
=AUTO
UNDO_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 -777 admin
root:
/LCdisk/oradata/bill/admin>su - ora_bill
7.创建数据库实例
 
ora_bill:
/LCdisk>sqlplus /nolog
SQL
> conn / as sysdba
SQL
> startup nomount
SQL
> 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 sysdba
Connected.
 
SQL
> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
 
SQL
> startup
ORACLE instance started.
 
Total System Global Area 
131563864 bytes
Fixed Size                   
741720 bytes
Variable Size             
109051904 bytes
Database Buffers           20971520 bytes
Redo Buffers                 
798720 bytes
Database mounted.
Database opened.
 
0
0

查看评论
* 以上用户言论只代表其个人观点,不代表CSDN网站的观点或立场
    个人资料
    • 访问:214122次
    • 积分:3498
    • 等级:
    • 排名:第9817名
    • 原创:140篇
    • 转载:8篇
    • 译文:0篇
    • 评论:14条
    JAVA JSP