背景为一台服务器上已有一数据库实例，现需要新建一个新的实例
## 1. copy 密码文件
```
cp orapworcl orapwjf3x
```
## 2. copy 参数文件
```
cp initorcl.ora initjf3x.ora
```
## 3. 修改参数文件
修改数据库名，控制文件位置，SGA PGA参数,audit目录等
## 4. 建立不存在的目录
## 5.启动至nomount
```
export ORACLE_SID=jf3x
sqlplus / as sysdba
startup nomount
```
## 6. 创建数据库
```
CREATE DATABASE jf3x
USER SYS IDENTIFIED BY sys_password
USER SYSTEM IDENTIFIED BY system_password
LOGFILE GROUP 1 ('/nas/oradata/jf3x/redo01a.log','/nas/oradata/jf3x/redo01b.log') SIZE 100M,
GROUP 2 ('/nas/oradata/jf3x/redo02a.log','/nas/oradata/jf3x/redo02b.log') SIZE 100M,
GROUP 3 ('/nas/oradata/jf3x/redo03a.log','/nas/oradata/jf3x/redo03b.log') SIZE 100M
MAXLOGFILES 5
MAXLOGMEMBERS 5
MAXLOGHISTORY 1
MAXDATAFILES 100
CHARACTER SET AL32UTF8
NATIONAL CHARACTER SET AL16UTF16
EXTENT MANAGEMENT LOCAL
DATAFILE '/nas/oradata/jf3x/system01.dbf' SIZE 325M REUSE
SYSAUX DATAFILE '/nas/oradata/jf3x/sysaux01.dbf' SIZE 325M REUSE
DEFAULT TABLESPACE users
DATAFILE '/nas/oradata/jf3x/users01.dbf'
SIZE 6144M REUSE AUTOEXTEND ON MAXSIZE UNLIMITED
DEFAULT TEMPORARY TABLESPACE tempts1
TEMPFILE '/nas/oradata/jf3x/temp01.dbf'
SIZE 200M REUSE
UNDO TABLESPACE undotbs1
DATAFILE '/nas/oradata/jf3x/undotbs01.dbf'
SIZE 512M REUSE AUTOEXTEND ON MAXSIZE UNLIMITED;
```
## 7. 更改sys密码(如果需要)
```
alter user sys identified by oracle123;
```
## 8. 重建视图
```
@?/rdbms/admin/catalog.sql
@?/rdbms/admin/catproc.sql
@?/sqlplus/admin/pupbld.sql
EXIT
```