手动建库

```
https://docs.oracle.com/en/database/oracle/oracle-database/
```

###1、设置环境变量
```
export ORACLE_HOME=/oracle/app/oracle/product/19c/db_1/
export ORACLE_BASE=/oracle/app/oracle
export ORACLE_SID=lianxi
```
###2、编辑init.ora,建目录，生成spfile
```
cat init.ora  |grep -v \#  > initLIANXI.ora

sed -i 's/ORCL/LIANXI/g' initlianxi.ora
sed -i 's/ORCL/LIANXI/g' initlianxi.ora
sed -i 's/orcl/lianxi/g' initlianxi.ora
sed -i 's/<ORACLE_BASE>/\/oracle\/app\/oracle/g' initlianxi.ora
sed -i "s/control_files = (ora_control1, ora_control2)/control_files = (\/oradata\/LIANXI\/controlfile\/ora_control1, \/oradata\/LIANXI\/controlfile\/ora_control2)/" initlianxi.ora
mkdir -p  /oracle/app/oracle/admin/lianxi/adump
mkdir -p /oradata/LIANXI/controlfile
mkdir -p /oracle/app/oracle/fast_recovery_area

```
###3、官方文档生成实例
```
BOOKS-ADMIN GUIDE-CREATE OR CONFIG DATABASE - CREATE DATABASE WITH ***statement - step9 issus
替换目录

CREATE DATABASE lianxi
   USER SYS IDENTIFIED BY sys_password
   USER SYSTEM IDENTIFIED BY system_password
   LOGFILE GROUP 1 ('/oradata/lianxi/redo01a.log') SIZE 100M BLOCKSIZE 512,
           GROUP 2 ('/oradata/lianxi/redo02a.log') SIZE 100M BLOCKSIZE 512,
           GROUP 3 ('/oradata/lianxi/redo03a.log') SIZE 100M BLOCKSIZE 512
   MAXLOGHISTORY 1
   MAXLOGFILES 16
   MAXLOGMEMBERS 3 
   MAXDATAFILES 1024
   CHARACTER SET AL32UTF8
   NATIONAL CHARACTER SET AL16UTF16
   EXTENT MANAGEMENT LOCAL
   DATAFILE '/oradata/lianxi/system01.dbf'
     SIZE 700M REUSE AUTOEXTEND ON NEXT 10240K MAXSIZE UNLIMITED
   SYSAUX DATAFILE '/oradata/lianxi/sysaux01.dbf'
     SIZE 550M REUSE AUTOEXTEND ON NEXT 10240K MAXSIZE UNLIMITED
   DEFAULT TABLESPACE users
      DATAFILE '/oradata/lianxi/users01.dbf'
      SIZE 500M REUSE AUTOEXTEND ON MAXSIZE UNLIMITED
   DEFAULT TEMPORARY TABLESPACE tempts1
      TEMPFILE '/oradata/lianxi/temp01.dbf'
      SIZE 20M REUSE AUTOEXTEND ON NEXT 640K MAXSIZE UNLIMITED
   UNDO TABLESPACE undotbs1
      DATAFILE '/oradata/lianxi/undotbs01.dbf'
      SIZE 200M REUSE AUTOEXTEND ON NEXT 5120K MAXSIZE UNLIMITED
   USER_DATA TABLESPACE usertbs
      DATAFILE '/oradata/lianxi/usertbs01.dbf'
      SIZE 200M REUSE AUTOEXTEND ON MAXSIZE UNLIMITED;
```
###4、执行脚本
```
@?/rdbms/admin/catalog.sql
@?/rdbms/admin/catproc.sql
```

DBLOG

导航1234

最近发表

友情链接