（一些重点需要修改的地方我做的笔记并截图，放在文章最后。）
安装数据库软件并设置环境变量就不说了
点击(此处)折叠或打开
- $ cd $ORACLE_HOME/dbs
- $ orapwd file=orapwdPROD1 password=oracle
点击(此处)折叠或打开
- $ cd $ORACLE_HOME/dbs
- $ cat init.ora |grep -v ^# |grep -v ^$ >initPROD1.orp
- $ vi initPROD1.orp
- db_name='PROD1'
- memory_target=1G
- processes = 150
- audit_file_dest='/u01/app/oracle/admin/PROD1/adump'
- audit_trail ='db'
- db_block_size=8192
- db_domain=''
- db_recovery_file_dest='/u01/app/oracle/fast_recovery_area'
- db_recovery_file_dest_size=2G
- diagnostic_dest='/u01/app/oracle'
- dispatchers='(PROTOCOL=TCP) (SERVICE=PROD1XDB)'
- open_cursors=300
- remote_login_passwordfile='EXCLUSIVE'
- undo_tablespace='UNDOTBS1'
- control_files = (/u01/app/oracle/oradata/PROD1/control01.ctl,/u01/app/oracle/fast_recovery_area/PROD1/control02.ctl)
- compatible ='11.2.0'
点击(此处)折叠或打开
- $ mkdir -p /u01/app/oracle/admin/PROD1/adump
- $ mkdir -p /u01/app/oracle/oradata/PROD1
- $ mkdir -p /u01/app/oracle/fast_recovery_area/PROD1/
点击(此处)折叠或打开
- 编辑glogin并添加一下行
- $ vi $ORACLE_HOME/sqlplus/admin/glogin.sql
- DEFINE _EDITOR = vi
点击(此处)折叠或打开
-
$ export ORACLE_SID=PROD1
-
$ sqlplus / as sysdba
-
SQL> startup nomount
- SQL> select * from dual;
点击(此处)折叠或打开
- SQL> ed
点击(此处)折叠或打开
-
CREATE DATABASE PROD1
-
USER SYS IDENTIFIED BY sys_password
-
USER SYSTEM IDENTIFIED BY system_password
-
LOGFILE GROUP 1 ('/u01/app/oracle/oradata/PROD1/redo01a.log') SIZE 100M BLOCKSIZE 512,
-
GROUP 2 ('/u01/app/oracle/oradata/PROD1/redo02a.log') SIZE 100M BLOCKSIZE 512,
-
GROUP 3 ('/u01/app/oracle/oradata/PROD1/redo03a.log') SIZE 100M BLOCKSIZE 512
-
MAXLOGFILES 5
-
MAXLOGMEMBERS 5
-
MAXLOGHISTORY 1
-
MAXDATAFILES 100
-
CHARACTER SET AL32UTF8
-
NATIONAL CHARACTER SET AL16UTF16
-
EXTENT MANAGEMENT LOCAL
-
DATAFILE '/u01/app/oracle/oradata/PROD1/system01.dbf' SIZE 325M REUSE
-
SYSAUX DATAFILE '/u01/app/oracle/oradata/PROD1/sysaux01.dbf' SIZE 325M REUSE
-
DEFAULT TABLESPACE users
-
DATAFILE '/u01/app/oracle/oradata/PROD1/users01.dbf'
-
SIZE 500M REUSE AUTOEXTEND ON MAXSIZE UNLIMITED
-
DEFAULT TEMPORARY TABLESPACE tempts1
-
TEMPFILE '/u01/app/oracle/oradata/PROD1/temp01.dbf'
-
SIZE 20M REUSE
-
UNDO TABLESPACE undotbs1
-
DATAFILE '/u01/app/oracle/oradata/PROD1/undotbs01.dbf'
-
SIZE 200M REUSE AUTOEXTEND ON MAXSIZE UNLIMITED
-
- /
点击(此处)折叠或打开
-
SQL> /
-
- Database created.
点击(此处)折叠或打开
- SQL> @?/rdbms/admin/catalog.sql
点击(此处)折叠或打开
- SQL> @?/rdbms/admin/catproc.sql
点击(此处)折叠或打开
- SQL> @?/sqlplus/admin/pupbld.sql
创建建库脚本部分
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/30606032/viewspace-1870861/ ，如需转载，请注明出处，否则将追究法律责任。
上一篇：
没有了~
下一篇：
没有了~
请登录后发表评论
登录
全部评论
