Oracle11g⼿动创建数据库⽅法Oracle11g⼿动创建数据库⽅法
安装路径
我的安装路径是：E:\app\admin\product\11.2.0\dbhome_1
DATABASE NAME、实例名以及ORACLE_SID：名字全部都是MYDB
SYS和SYSTEM等⽤户的密码：123456
1：创建⽂件夹
2：创建初始化参数⽂件
3：创建执⾏建库脚本
4：设置环境变量
5: 创建实例
6：创建⼝令⽂件
7：启动数据库NOMOUNT状态
8：执⾏建库脚本 MYDB.sql （MYDB.sql放在E盘⽬录下）
9：运⾏脚本创建数据字典试图
1：创建⽂件夹
拒绝访问的话，原因是win7要以管理员⾝份运⾏。
2：创建初始化参数⽂件
将a⽂件拷贝到桌⾯修改好后取名为a，拷贝到
E:\app\admin\product\11.2.0\dbhome_1\database
内容如下：
#
# $Header: rdbms/a /main/23 2009/05/15 13:35:38 ysarig Exp $
#
# Copyright (c) 1991, 1997, 1998 by Oracle Corporation
# NAME
# a
# FUNCTION
# NOTES
# MODIFIED
# ysarig 05/14/09 - Updating compatible to 11.2
# ysarig 08/13/07 - Fixing the sample for 11g
# atsukerm 08/06/98 - fix for 8.1.
# hpiao 06/05/97 - fix for 803
# glavash 05/12/97 - add oracle_trace_enable comment
# hpiao 04/22/97 - remove ifile=, events=, etc.
# alingelb 09/19/94 - remove vms-specific stuff
# dpawson 07/07/93 - add more comments regarded archive start
# maporter 10/29/92 - Add vms_sga_use_gblpagfile=TRUE
# jloaiza 03/07/92 - change ALPHA to BETA
# danderso 02/26/92 - change db_block_cache_protect to _db_block_cache_p
# ghallmar 02/03/92 - db_directory -> db_domain
# maporter 01/12/92 - merge changes from branch 1.8.308.1
# maporter 12/21/91 - bug 76493: Add control_files parameter
# wbridge 12/03/91 - use of %c in archive format is discouraged
# ghallmar 12/02/91 - add global_names=true, db_directory=us.acme
# thayes 11/27/91 - Change default for cache_clone
# jloaiza 08/13/91 - merge changes from branch 1.7.100.1
# jloaiza 07/31/91 - add debug stuff
# rlim 04/29/91 - removal of char_is_varchar2
# Bridge 03/12/91 - log_allocation no longer exists
# Wijaya 02/05/91 - remove obsolete parameters
#
>>>>>>>>>>>>>>>### # Example INIT.ORA file
#
# This file is provided by Oracle Corporation to help you start by providing
# a starting point to customize your RDBMS installation for your site.
#
# NOTE: The values that are used in this file are only intended to be used
# as a starting point. You may want to adjust/tune those values to your
# specific hardware and needs. You may also consider using Database
# Configuration Assistant tool (DBCA) to create INIT file and to size your
# initial set of tablespaces based on the user input.
>>>>>>>>>>>>>>>####
# Change '<ORACLE_BASE>' to point to the oracle base (the one you specify at
# install time)
db_name='MYDB'
memory_target=1G
processes = 150
audit_file_dest='E:/app/admin/product/11.2.0/dbhome_1/admin/MYDB/adump'
audit_trail ='db'
db_block_size=8192
db_domain=''
db_recovery_file_dest='E:/app/admin/flash_recovery_area'
db_recovery_file_dest_size=2G
diagnostic_dest='E:\app\admin\product\11.2.0\dbhome_1\oradata'
dispatchers='(PROTOCOL=TCP) (SERVICE=ORCLXDB)'
open_cursors=300
remote_login_passwordfile='EXCLUSIVE'
undo_tablespace='UNDOTBS1'
# You may want to ensure that control files are created on separate physical
# devices
control_files = (ora_control1, ora_control2)
compatible ='11.2.0'
3：创建建库脚本
新建⽂本⽂件内容如下：
create database MYDB
datafile 'E:/app/admin/product/11.2.0/dbhome_1/oradata/MYDB/system01.dbf' size 300M reuse autoextend on next 10240K maxsize unlimited extent management local
sysaux datafile 'E:/app/admin/product/11.2.0/dbhome_1/oradata/MYDB/sysaux01.dbf' size 120M reuse autoextend on next 10240K maxsize unlimited default temporary tablespace temp
tempfile 'E:/app/admin/product/11.2.0/dbhome_1/oradata/MYDB/temp01.dbf' size 20M reuse autoextend on next 640K maxsize unlimited
undo tablespace "UNDOTBS1"
datafile 'E:/app/admin/product/11.2.0/dbhome_1/oradata/MYDB/undotbs1.dbf' size 20M reuse autoextend on next 5120K maxsize unlimited
logfile
group 1 ('E:/app/admin/product/11.2.0/dbhome_1/oradata/MYDB/redo01.log') size 10M,
group 2 ('E:/app/admin/product/11.2.0/dbhome_1/oradata/MYDB/redo02.log') size 10M,
group 3 ('E:/app/admin/product/11.2.0/dbhome_1/oradata/MYDB/redo03.log') size 10M;
然后另存为.sql格式
4：设置环境变量
set oracle_sid=MYDB
5：创建实例
oradim -new -sid MYDB
6：创建⼝令⽂件
orapwd file=E:\app\admin\product\11.2.0\dbhome_1\a password=123456 entries=2
7：启动数据库NOMOUNT状态
sqlplus /nolog
conn sys/abcdef as sysdba
startup nomount
8：执⾏脚本 MYDB.sql （MYDB.sql放在E盘⽬录下）
oracle建立数据库连接
@ E:\MYDB.sql;
9：运⾏脚本创建数据字典视图
SQL>@E:\app\admin\product\11.2.0\dbhome_1\RDBMS\ADMIN\catproc.sql
版权声明：本站内容均来自互联网，仅供演示用，请勿用于商业和其他非法用途。如果侵犯了您的权益请与我们联系QQ:729038198，我们将在24小时内删除。
如何新建oracle数据库,图文流程。
« 上一篇
发表评论