Oracle 8i 中如何创建数据库? 1)建议使用 database configuration assistant.2)如果你是为了做练习,你还需要多了解有关Oracle 的知识,才实现手工 创建数据库 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 database configuration assistant. database configuration assistant很好用的。(你在安Oracle8i的时候,把所有的选项都选上,完全安装,不易出错;Oracle8i因为安装不全而导致的后来一些问题还是挺多的。。建议而已) 在已有一个数据库的情况下,手工创建数据库:1、本机已有的实例及数据库名均为ORCL,新创建立的实例和数据库名为ORCL2,字符集为:2、设置环境:C:\>set oracle_sid=orcl2创建一个新的Instance服务(internal口令为oracle):C:\>oradim -new -sid orcl2 -intpwd oracle3、准备初始化参数文件initOrcl2.ora:(将现存数据库参数文件拷贝后略作改动,保存在%ORACLE_HOME%\Database目录下)db_name = "ORCL2"instance_name = ORCL2service_names = ORCL2db_files = 1024 # INITIALcontrol_files = ("D:\oracle\oradata\ORCL2\control01.ctl", "D:\oracle\oradata\ORCL2\control02.ctl", "D:\oracle\oradata\ORCL2\control03.ctl")open_cursors = 300max_enabled_roles = 30db_file_multiblock_read_count = 8 # INITIALdb_block_buffers = 2048 # INITIALshared_pool_size = 31457280 # INITIALlarge_pool_size = 614400java_pool_size = 20971520log_checkpoint_interval = 10000log_checkpoint_timeout = 1800processes = 150 # INITIALparallel_max_servers = 5 # SMALLlog_buffer = 32768 # INITIALmax_dump_file_size = 10240 # limit trace file size to 5M eachglobal_names = trueoracle_trace_collection_name = ""background_dump_dest = D:\oracle\admin\ORCL2\bdumpuser_dump_dest = D:\oracle\admin\ORCL2\udumpdb_block_size = 8192remote_login_passwordfile = exclusiveos_authent_prefix = ""job_queue_processes = 4job_queue_interval = 10open_links = 4distributed_transactions = 500mts_dispatchers = "(PROTOCOL=TCP)(PRE=oracle.aurora.server.SGiopServer)"compatible = 8.1.0sort_area_size = 65536sort_area_retained_size = 655364、启动实例,创建立数据库:C:\>sqlplus /nologSQL*Plus: Release 8.1.7.0.0 - Production on Fri Nov 28 16:49:44 2003(c) Copyright 2000 Oracle Corporation. All rights reserved.SP2-0640: Not connectedSQL> connect internal/oracle as sysdbaConnected to an idle instance.SQL> startup nomount pfile=D:\oracle\ora81\database\initOrcl2.oraORACLE instance started.Total System Global Area 73701404 bytesFixed Size 75804 bytesVariable Size 56770560 bytesDatabase Buffers 16777216 bytesRedo Buffers 77824 bytesSQL> create database orcl2 2 maxlogmembers 5 3 maxdatafiles 100 4 maxloghistory 100 5 logfile 6 'D:\oracle\oradata\ORCL2\redo01.log' size 1M, 7 'D:\oracle\oradata\ORCL2\redo02.log' size 1M, 8 'D:\oracle\oradata\ORCL2\redo03.log' size 1M 9 datafile 'D:\oracle\oradata\ORCL2\system01.dbf' size 50M autoextend on10* character set US7ASCIISQL> /Database created.SQL>SQL> select * from v$logfile; GROUP# STATUS---------- -------MEMBER------------------------------------- 1D:\ORACLE\ORADATA\ORCL2\REDO01.LOG 2D:\ORACLE\ORADATA\ORCL2\REDO02.LOG 3D:\ORACLE\ORADATA\ORCL2\REDO03.LOG也可以参考一下%ORACLE_HOME%\RDBMS\Admin\build_db.sql。 http://www.oradb.net/setup/dbcreate_001.htm 闪回操作 怎么样写ORACLE自定义函数返回表? 那位知道JOB调用带参数存储过程时,想传空值及字 符如何传 我Oracle初学者,介绍本教程呀! 在SQLPlus Worksheet里面,输出的错误信息是乱码,要修改哪里才能正确显示? 下面的语句在oracle中应该怎么改写(用于判断处键引用) 帮忙!!本机设为域后,asp连不上oracle9i 急问:MYSQL 中有何种锁和并发控制?谢谢!! 哪边有PL/sql 语法教程?万分感激! 我是新手,请帮我一把 怎么样一下执行所有写好的SQL语句 改变本机IP及计算机名后,如何启动managermentserver 和tnslistener服务
很好用的。
(你在安Oracle8i的时候,把所有的选项都选上,完全安装,不易出错;Oracle8i因为安装不全而导致的后来一些问题还是挺多的。。建议而已)
C:\>set oracle_sid=orcl2
创建一个新的Instance服务(internal口令为oracle):
C:\>oradim -new -sid orcl2 -intpwd oracle3、准备初始化参数文件initOrcl2.ora:(将现存数据库参数文件拷贝后略作改动,保存在%ORACLE_HOME%\Database目录下)
db_name = "ORCL2"
instance_name = ORCL2
service_names = ORCL2
db_files = 1024 # INITIAL
control_files = ("D:\oracle\oradata\ORCL2\control01.ctl", "D:\oracle\oradata\ORCL2\control02.ctl", "D:\oracle\oradata\ORCL2\control03.ctl")
open_cursors = 300
max_enabled_roles = 30
db_file_multiblock_read_count = 8 # INITIAL
db_block_buffers = 2048 # INITIAL
shared_pool_size = 31457280 # INITIAL
large_pool_size = 614400
java_pool_size = 20971520
log_checkpoint_interval = 10000
log_checkpoint_timeout = 1800
processes = 150 # INITIAL
parallel_max_servers = 5 # SMALL
log_buffer = 32768 # INITIAL
max_dump_file_size = 10240 # limit trace file size to 5M each
global_names = true
oracle_trace_collection_name = ""
background_dump_dest = D:\oracle\admin\ORCL2\bdump
user_dump_dest = D:\oracle\admin\ORCL2\udump
db_block_size = 8192
remote_login_passwordfile = exclusive
os_authent_prefix = ""
job_queue_processes = 4
job_queue_interval = 10
open_links = 4
distributed_transactions = 500
mts_dispatchers = "(PROTOCOL=TCP)(PRE=oracle.aurora.server.SGiopServer)"
compatible = 8.1.0
sort_area_size = 65536
sort_area_retained_size = 655364、启动实例,创建立数据库:
C:\>sqlplus /nolog
SQL*Plus: Release 8.1.7.0.0 - Production on Fri Nov 28 16:49:44 2003
(c) Copyright 2000 Oracle Corporation. All rights reserved.
SP2-0640: Not connected
SQL> connect internal/oracle as sysdba
Connected to an idle instance.
SQL> startup nomount pfile=D:\oracle\ora81\database\initOrcl2.ora
ORACLE instance started.Total System Global Area 73701404 bytes
Fixed Size 75804 bytes
Variable Size 56770560 bytes
Database Buffers 16777216 bytes
Redo Buffers 77824 bytes
SQL> create database orcl2
2 maxlogmembers 5
3 maxdatafiles 100
4 maxloghistory 100
5 logfile
6 'D:\oracle\oradata\ORCL2\redo01.log' size 1M,
7 'D:\oracle\oradata\ORCL2\redo02.log' size 1M,
8 'D:\oracle\oradata\ORCL2\redo03.log' size 1M
9 datafile 'D:\oracle\oradata\ORCL2\system01.dbf' size 50M autoextend on
10* character set US7ASCII
SQL> /Database created.SQL>SQL> select * from v$logfile; GROUP# STATUS
---------- -------
MEMBER
------------------------------------- 1
D:\ORACLE\ORADATA\ORCL2\REDO01.LOG 2
D:\ORACLE\ORADATA\ORCL2\REDO02.LOG 3
D:\ORACLE\ORADATA\ORCL2\REDO03.LOG也可以参考一下%ORACLE_HOME%\RDBMS\Admin\build_db.sql。