小游戏分享功能设计指南,实现病毒式传播的五大技巧
449
2024-01-03
这篇文章将为大家详细讲解有关oracle如何手动建库,小编觉得挺实用的,因此分享给大家做个参考,希望大家阅读完这篇文章后可以有所收获。
1、-- 查看服务器 ORA 环境变量情况
[oracle@orastb ~]$ env|grep ORA
ORACLE_BASE=/u01/app/oracle
ORACLE_HOME=/u01/app/oracle/product/11.2.0/dbhome_12、-- 创建参数文件
[oracle@orastb ~]$ cd /u01/app/oracle/product/11.2.0/dbhome_1/dbs
[oracle@orastb dbs]$ ls
afiedt.buf hc_testdb.dat lkTESTDB2 spfiletestdb1.ora
hc_boncstb.dat inittestdb1.ora orapwboncstb spfiletestdb2.ora
hc_OMS.dat inittestdb2.ora orapwtestdb1
hc_testdb1.dat lkBONCSTB orapwtestdb2
hc_testdb2.dat lkTESTDB1 spfileboncstb.ora
[oracle@orastb dbs]$ touch initqixindb.ora
[oracle@orastb dbs]$ cat initqixindb.oramemory_target=17179870000
*.db_name=QIXINDB
*.processes = 300
*.audit_file_dest=/u01/app/oracle/admin/qixindb/adump
*.audit_trail =db
*.db_block_size=8192
*.db_domain=
*.db_recovery_file_dest=/u01/app/oracle/flash_recovery_area
*.db_recovery_file_dest_size=10G
*.diagnostic_dest=/u01/app/oracle
*.dispatchers=(PROTOCOL=TCP) (SERVICE=ORCLXDB)
*.open_cursors=300
*.remote_login_passwordfile=EXCLUSIVE
*.undo_tablespace=undotbs01
# You may want to ensure that control files are created on separate physical
# devices
*.control_files=/oradata/qixindb/control01.ctl,/oradata/flash_recovery_area_qixindb/qixindb/control02.ctl
*.compatible =11.2.03、-- 创建参数文件及建库所需目录
[oracle@orastb dbs]$ mkdir -p /u01/app/oracle/admin/qixindb/adump
[oracle@orastb dbs]$ mkdir -p /u01/app/oracle/flash_recovery_area
[oracle@orastb dbs]$ mkdir -p /oradata/qixindb/
[oracle@orastb dbs]$ mkdir -p /oradata/flash_recovery_area_qixindb/qixindb/
[oracle@orastb dbs]$ mkdir -p /oradata/qixindb/redolog/4、 -- 登录,启动数据库到nomount , 执行手工建库脚本
[oracle@orastb ~]$ sqlplus / as sysdba
Connected to an idle instance.(11G)SYS@qixindb> startup nomount;
ORACLE instance started.
Total System Global Area 1.7170E+10 bytes
Fixed Size 2260128 bytes
Variable Size 9261024096 bytes
Database Buffers 7851737088 bytes
Redo Buffers 54951936 bytes(11G)SYS@qixindb> show parameter memory_
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
hi_shared_memory_address integer 0
memory_max_target big integer 16448M
memory_target big integer 16448M
shared_memory_address integer 0(11G)SYS@qixindb>
CREATE DATABASE qixindb
USER SYS IDENTIFIED BY BOnc#oracle123
USER SYSTEM IDENTIFIED BY BOnc#oracle123
LOGFILE GROUP 1 (/oradata/qixindb/redolog/redo01a.log,/oradata/qixindb/redolog/redo01b.log) SIZE 1G BLOCKSIZE 512,
GROUP 2 (/oradata/qixindb/redolog/redo02a.log,/oradata/qixindb/redolog/redo02b.log) SIZE 1G BLOCKSIZE 512,
GROUP 3 (/oradata/qixindb/redolog/redo03a.log,/oradata/qixindb/redolog/redo03b.log) SIZE 1G BLOCKSIZE 512,
GROUP 4 (/oradata/qixindb/redolog/redo04a.log,/oradata/qixindb/redolog/redo04b.log) SIZE 1G BLOCKSIZE 512,
GROUP 5 (/oradata/qixindb/redolog/redo05a.log,/oradata/qixindb/redolog/redo05b.log) SIZE 1G BLOCKSIZE 512,
GROUP 6 (/oradata/qixindb/redolog/redo06a.log,/oradata/qixindb/redolog/redo06b.log) SIZE 1G BLOCKSIZE 512
MAXLOGFILES 15
MAXLOGMEMBERS 3
MAXLOGHISTORY 1
MAXDATAFILES 300
CHARACTER SET AL32UTF8
NATIONAL CHARACTER SET AL16UTF16
EXTENT MANAGEMENT LOCAL
DATAFILE /oradata/qixindb/system01.dbf SIZE 8G REUSE
SYSAUX DATAFILE /oradata/qixindb/sysaux01.dbf SIZE 8G REUSE
DEFAULT TABLESPACE users
DATAFILE /oradata/qixindb/users01.dbf
SIZE 500M REUSE AUTOEXTEND OFF
DEFAULT TEMPORARY TABLESPACE tempts01
TEMPFILE /oradata/qixindb/temp01.dbf
SIZE 30G REUSE
UNDO TABLESPACE undotbs01
DATAFILE /oradata/qixindb/undotbs01.dbf
SIZE 30G REUSE AUTOEXTEND OFF;Database created.
(11G)SYS@qixindb> select open_mode from v$database;
OPEN_MODE
--------------------
READ WRITE(11G)SYS@qixindb> shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
(11G)SYS@qixindb> startup;
ORACLE instance started.Total System Global Area 1.7170E+10 bytes
Fixed Size 2260128 bytes
Variable Size 9261024096 bytes
Database Buffers 7851737088 bytes
Redo Buffers 54951936 bytes
Database mounted.
Database opened.[oracle@orastb dbs]$ orapwd file=/u01/app/oracle/product/11.2.0/dbhome_1/dbs/orapwqixindb password=BOnc#oracle123
[oracle@orastb dbs]$ ll orapwqixindb
-rw-r-----. 1 oracle oinstall 1536 Aug 30 16:09 orapwqixindb(11G)SYS@qixindb> show parameter pfile
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
spfile string(11G)SYS@qixindb> create spfile from pfile;
File created.(11G)SYS@qixindb> shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.(11G)SYS@qixindb> startup;
ORACLE instance started.
Total System Global Area 1.7170E+10 bytes
Fixed Size 2260128 bytes
Variable Size 9261024096 bytes
Database Buffers 7851737088 bytes
Redo Buffers 54951936 bytes
Database mounted.
Database opened.-- 建库完成后,跑三个脚本
-- sys用户登录
In SQL*Plus, connect to your Oracle Database instance with the SYSDBA administrative privilege:
@?/rdbms/admin/catalog.sql
@?/rdbms/admin/catproc.sql-- system用户登录
In SQL*Plus, connect to your Oracle Database instance as SYSTEM user:
@?/sqlplus/admin/pupbld.sql关于“oracle如何手动建库”这篇文章就分享到这里了,希望以上内容可以对大家有一定的帮助,使各位可以学到更多知识,如果觉得文章不错,请把它分享出去让更多的人看到。
版权声明:本文内容由网络用户投稿,版权归原作者所有,本站不拥有其著作权,亦不承担相应法律责任。如果您发现本站中有涉嫌抄袭或描述失实的内容,请联系我们jiasou666@gmail.com 处理,核实后本网站将在24小时内删除侵权内容。
发表评论
暂时没有评论,来抢沙发吧~