首页 / ORACLE / Oracle手动创建数据库
Oracle手动创建数据库
内容导读
互联网集市收集整理的这篇技术教程文章主要介绍了Oracle手动创建数据库,小编现在分享给大家,供广大互联网技能从业者学习和参考。文章包含4542字,纯文字阅读大概需要7分钟。
内容图文
![Oracle手动创建数据库](/upload/InfoBanner/zyjiaocheng/546/a9f9352ab81e45a3ae623aadd6d4b4a5.jpg)
安装oracle客户端软件:root账户执行:#groupaddoinstall#groupadddba#useradd-goinstall-Gdbaoracle#passwdoracle创建oracle基本目录:#mkdir-p/u01/app/oracle
root账户执行:
#groupadd oinstall
#groupadd dba
#useradd -g oinstall -G dba oracle
#passwd oracle
#mkdir -p /u01/app/oracle
#chown -R oracle:oinstall /u01
#chmod -R 775 /u01
/u01 由根目录拥有。
/u01/app 由根目录拥有。
配置内核参数
#vi /etc/sysctl
kernel.shmmax = 4294967295
kernel.shmall = 268435456
kernel.shmmni = 4096
kernel.sem = 250 32000 100 128
fs.file-max = 65536
net.ipv4.ip_local_port_range = 1024 65000
net.core.rmem_default=1048576
net.core.rmem_max=1048576
net.core.wmem_default=262144
net.core.wmem_max=262144
启动生效
#sysctl -p
最大打开文件描述符数 nofile 65536
可用于单个用户的最大进程数 nproc 16384
#cat >> /etc/security/limits.conf <<EOF
oracle soft nproc 2047
oracle hard nproc 16384
oracle soft nofile 1024
oracle hard nofile 65536
EOF
#cat >> /etc/pam.d/login <<EOF
session required /lib/security/pam_limits.so
session required pam_limits.so
EOF
#cat >> /etc/profile <<EOF
if [ \$USER = "oracle" ]; then
if [ \$SHELL = "/bin/ksh" ]; then
ulimit -p 16384
ulimit -n 65536
else
ulimit -u 16384 -n 65536
fi
umask 022
fi
EOF
#su - oracle
安装客户端:
$vi ~/.bash_profile
export ORALCE_BASE=/u01/app/oracle
export ORALCE_HOME=$ORACLE_BASE/product/10.2.0/db_1
export ORALCE_SID=orcl
export PATH=$ORACLE_HOME/bin:$PATH
生效环境变量:
$source ~/.bash_profile
手动创建库:
vi initorcl.ora
orcl.__java_pool_size=4194304
orcl.__large_pool_size=4194304
orcl.__shared_pool_size=226492416
orcl.__streams_pool_size=0
*.audit_file_dest='/u01/app/oracle/admin/orcl/adump'
*.background_dump_dest='/u01/app/oracle/admin/orcl/bdump'
*.compatible='10.2.0.1.0'
*.control_files='/u01/app/oracle/oradata/orcl/control01.ctl','/u01/app/oracle/oradata/orcl/control02.ctl','/u01/app/oracle/oradata/orcl/control03.ctl'
*.core_dump_dest='/u01/app/oracle/admin/orcl/cdump'
*.db_block_size=8192
*.db_domain=''
*.db_file_multiblock_read_count=16
*.db_name='orcl'
*.db_recovery_file_dest='/u01/app/oracle/flash_recovery_area'
*.db_recovery_file_dest_size=2147483648
*.dispatchers='(PROTOCOL=TCP) (SERVICE=orclXDB)'
*.job_queue_processes=10
*.log_archive_dest_1='location=/u01/app/oracle/arch'
*.log_archive_dest_2='location=usr_db_recovery_file_dest'
*.open_cursors=300
*.pga_aggregate_target=299892736
*.processes=150
*.remote_login_passwordfile='EXCLUSIVE'
*.sga_target=901775360
*.undo_management='AUTO'
*.undo_tablespace='UNDOTBS1'
*.user_dump_dest='/u01/app/oracle/admin/orcl/udump'
创建数据库脚本文件:
dbca.sql
CREATE DATABASE orcl
USER SYS IDENTIFIED BY tiger
USER SYSTEM IDENTIFIED BY tiger
LOGFILE GROUP 1 ('/u01/app/oracle/oradata/orcl/redo01.log') SIZE 100M,
GROUP 2 ('/u01/app/oracle/oradata/orcl/redo02.log') SIZE 100M,
GROUP 3 ('/u01/app/oracle/oradata/orcl/redo03.log') SIZE 100M
MAXLOGFILES 5
MAXLOGMEMBERS 5
MAXLOGHISTORY 1
MAXDATAFILES 100
MAXINSTANCES 1
CHARACTER SET US7ASCII
NATIONAL CHARACTER SET AL16UTF16
DATAFILE '/u01/app/oracle/oradata/orcl/system01.dbf' SIZE 325M REUSE
EXTENT MANAGEMENT LOCAL
SYSAUX DATAFILE '/u01/app/oracle/oradata/orcl/sysaux01.dbf' SIZE 325M REUSE
DEFAULT TEMPORARY TABLESPACE tempts1
TEMPFILE '/u01/app/oracle/oradata/orcl/temp01.dbf'
SIZE 20M REUSE
UNDO TABLESPACE undotbs1
DATAFILE '/u01/app/oracle/oradata/orcl/undotbs01.dbf'
SIZE 200M REUSE AUTOEXTEND ON MAXSIZE UNLIMITED;
创建密码文件:
$orapwd file=$ORACLE_HOME/dbs/orapwdorcl password=tiger entries=10
创建数据库基本目录:
$mkdir -p /u01/app/oracle/admin/orcl/adump
$mkdir -p /u01/app/oracle/admin/orcl/bdump
$mkdir -p /u01/app/oracle/admin/orcl/udump
$mkdir -p /u01/app/oracle/admin/orcl/cdump
$mkdir -p /u01/app/oracle/flash_recovery_area
$mkdir -p /u01/app/oracle/arch
$mkdir -p /u01/app/oracle/oradata/orcl
#sqlplus "/ as sysdba"
#startup nomount pfile=/soft/initorcl.ora
创建表空间:
CONNECT SYS/password AS SYSDBA
-- create a user tablespace to be assigned as the default tablespace for users
CREATE TABLESPACE users LOGGING
DATAFILE '/u01/app/oracle/oradata/orcl/users01.dbf'
SIZE 25M REUSE AUTOEXTEND ON NEXT 1280K MAXSIZE UNLIMITED
EXTENT MANAGEMENT LOCAL;
-- create a tablespace for indexes, separate from user tablespace
CREATE TABLESPACE indx LOGGING
DATAFILE '/u01/app/oracle/oradata/orcl/indx01.dbf'
SIZE 25M REUSE AUTOEXTEND ON NEXT 1280K MAXSIZE UNLIMITED
EXTENT MANAGEMENT LOCAL;
alter database default tablespace users;
运行脚本:
CONNECT SYS/password AS SYSDBA
@/u01/app/oracle/product/10.2.0/db_1/rdbms/admin/catalog.sql
@/u01/app/oracle/product/10.2.0/db_1/rdbms/admin/catproc.sql
EXIT
脚本描述:
内容总结
以上是互联网集市为您收集整理的Oracle手动创建数据库全部内容,希望文章能够帮你解决Oracle手动创建数据库所遇到的程序开发问题。 如果觉得互联网集市技术教程内容还不错,欢迎将互联网集市网站推荐给程序员好友。
内容备注
版权声明:本文内容由互联网用户自发贡献,该文观点与技术仅代表作者本人。本站仅提供信息存储空间服务,不拥有所有权,不承担相关法律责任。如发现本站有涉嫌侵权/违法违规的内容, 请发送邮件至 gblab@vip.qq.com 举报,一经查实,本站将立刻删除。
内容手机端
扫描二维码推送至手机访问。