Oracle非图形化界面创建数据库

背景为一台服务器上已有一数据库实例，现需要新建一个新的实例

cp orapworcl orapwjf3x

cp initorcl.ora initjf3x.ora

修改数据库名，控制文件位置，SGA PGA参数,audit目录等

export ORACLE_SID=jf3x sqlplus / as sysdbastartup nomount

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;

alter user sys identified by oracle123;

@?/rdbms/admin/catalog.sql
@?/rdbms/admin/catproc.sql
@?/sqlplus/admin/pupbld.sql
EXIT