1200字范文 > 手动创建Oracle数据库实例

手动创建Oracle数据库实例

时间：2019-06-09 14:43:27

相关推荐

手动创建Oracle数据库实例

数据库|mysql教程

Oracle数据库,手动创建Oracle数据库实例,数据库,

数据库-mysql教程

java 发邮件源码,vscode自动补全怎么用,ubuntu的库,tomcat无法找到包,爬虫邮箱软件,php 输出到html,衡阳360seo优化公司,宽屏企业网站源码中英php,ecshop 专题页面模板lzw

1、首先设置Oracle_SID=manual2、创建密码文件进入/u01/app/oracle/product/10.2.0/db_1/dbs目录下，执行命令创建数据库密码文件

crm源码怎么安装,vscode查找模糊匹配,ubuntu重启提示,tomcat ad域登录,sqlite最好的管理工具,异步爬虫和同步爬虫,php 返回状态码,舟山seo推广哪家便宜,网站域名 admin.php,穿越火线网页模板lzw

优酷下载网站源码,编辑ubuntu更新源,访问tomcat资源文件,python 爬虫引擎,php表结构,关键词霸屏怎么选seo平台lzw

1、首先设置Oracle_SID=manual

2、创建密码文件

进入/u01/app/oracle/product/10.2.0/db_1/dbs目录下，执行命令创建数据库密码文件

[oracle@myorcl dbs]$ orapwd file=orapmanual password=oracle

3、创建所需的目录结构

[oracle@myorcl dbs]$ cd /u01/app/oracle/admin/

[oracle@myorcl admin]$ mkdir manual

然后进入manual目录创建一下文件

[oracle@myorcl manual]$ ls

adumpbdumpcdumppfileudump

4、创建所需的参数文件

[oracle@myorcl ~]$ cd /u01/app/oracle/admin/manual/pfile/

[oracle@myorcl pfile]$ vi init.ora

db_name=manual

db_domain=””

sga_target=285212672

pga_aggregate_target=94371840

db_block_size=8192

db_file_multiblock_read_count=16

open_cursors=300

processes=150

background_dump_dest=/u01/app/oracle/admin/manual/bdump

core_dump_dest=/u01/app/oracle/admin/manual/cdump

user_dump_dest=/u01/app/oracle/admin/manual/udump

audit_file_dest=/u01/app/oracle/admin/manual/adump

control_files=(“/u01/app/oracle/oradata/manual/control01.ctl”,/u01/app/oracle/oradata/manual/control02.ctl)

db_recovery_file_dest=/u01/app/oracle/flash_recovery_area/manual/

db_recovery_file_dest_size=2147483648

log_archive_format=%t_%s_%r.dbf

compatible=10.2.0.1.0

remote_login_passwordfile=EXCLUSIVE

undo_management=AUTO

undo_tablespace=UNDOTBS1

5、使用已创建的参数文件启动数据库实例到nomount状态

SQL>startup nomount pfile=/u01/app/oracle/admin/manual/pfile/init.ora

ORACLE instance started.

Total System Global Area285212672 bytes

Fixed Size1218992 bytes

Variable Size92276304 bytes

Database Buffers188743680 bytes

Redo Buffers2973696 bytes

6、然后执行SQL语句创建数据库

SQL> create database manual

2datafile ‘/u01/app/oracle/oradata/manual/system01.dbf’ size 300m reuse

3autoextend on next 10240K maxsize unlimited

4extent management local

5sysaux datafile ‘/u01/app/oracle/oradata/manual/sysaux01.dbf’ size 120m reuse

6autoextend on next 1024k maxsize unlimited

7smallfile default temporary tablespace

8temp tempfile ‘/u01/app/oracle/oradata/manual/temp01.dbf’ size 20m reuse

9autoextend on next 640k maxsize unlimited

smallfile undo tablespace “UNDOTBS1″datafile ‘/u01/app/oracle/oradata/manual/undotbs01.dbf’ size 200m reuse autoextend on next 5120k maxsize unlimited

11character set ZHS16GBK

12NATIONAL CHARACTER SET AL16UTF16

13logfile group 1(‘/u01/app/oracle/oradata/manual/redo01.log’) size 51200k,

14group 2(‘/u01/app/oracle/oradata/manual/redo02.log’) size 51200k,

15group 3(‘/u01/app/oracle/oradata/manual/redo03.log’) size 51200k

16user sys identified by oracle

17user system identified by oracle;

Database created.

7、创建用户默认表空间users

SQL> create smallfile tablespace users logging datafile ‘/u01/app/oracle/oradata/manual/user01.dbf’ size 5M reuse autoextend on next 1280K maxsize unlimited extent management local segment space management auto;

8、指定用户默认表空间为users

SQL> alter database default tablespace users;

9、安装数据字典

SQL> @/u01/app/oracle/product/10.2.0/db_1/rdbms/admin/catalog.sql

SQL> @/u01/app/oracle/product/10.2.0/db_1/rdbms/admin/catproc.sql

10、以system用户创建PL/SQL资源集

SQL> connect system/oracle

Connected.

SQL> @/u01/app/oracle/product/10.2.0/db_1/sqlplus/admin/pupbld.sql

SQL> @/u01/app/oracle/product/10.2.0/db_1/sqlplus/admin/help/hlpbld.sql helpus.sql

一个简化版的数据库创建完成

SQL> select status from v$instance;