手动创建Oracle数据库实例

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

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;
status
------------------------------------
open
[oracle@myorcl ~]$ lsnrctl status
lsnrctl for linux: version 10.2.0.1.0 - production on 05-jul-2013 00:30:43
copyright (c) 1991, 2005, oracle.all rights reserved.
connecting to (description=(address=(protocol=ipc)(key=extproc1)))
status of the listener
------------------------
aliaslistener
versiontnslsnr for linux: version 10.2.0.1.0 - production
start date04-jul-2013 19:58:59
uptime0 days 4 hr. 31 min. 44 sec
trace leveloff
securityon: local os authentication
snmpoff
listener parameter file/u01/app/oracle/product/10.2.0/db_1/network/admin/listener.ora
listener log file/u01/app/oracle/product/10.2.0/db_1/network/log/listener.log
listening endpoints summary...
(description=(address=(protocol=ipc)(key=extproc1)))
(description=(address=(protocol=tcp)(host=myorcl.oracle.com)(port=1521)))
services summary...
service "plsextproc" has 1 instance(s).
instance "plsextproc", status unknown, has 1 handler(s) for this service...
service "manual" has 1 instance(s).
instance "manualorcl", status ready, has 1 handler(s) for this service...
service "manual_xpt" has 1 instance(s).
instance "manualorcl", status ready, has 1 handler(s) for this service...
service "orcl" has 1 instance(s).
instance "orcl", status ready, has 1 handler(s) for this service...
service "orclxdb" has 1 instance(s).
instance "orcl", status ready, has 1 handler(s) for this service...
service "orcl_xpt" has 1 instance(s).
instance "orcl", status ready, has 1 handler(s) for this service...
the command completed successfully

PHP Apache和MySQL 网页开发初步

本书全面介绍PHP脚本语言和MySOL数据库这两种目前最流行的开源软件，主要包括PHP和MySQL基本概念、PHP扩展与应用库、日期和时间功能、PHP数据对象扩展、PHP的mysqli扩展、MySQL 5的存储例程、解发器和视图等。本书帮助读者学习PHP编程语言和MySQL数据库服务器的最佳实践，了解如何创建数据库驱动的动态Web应用程序。

385

查看详情