往期专题请查看www.zhaibibei.cn 这是一个坚持Oracle,Python,MySQL原创内容的公众号
背景为一台服务器上已有一数据库实例,现需要新建一个新的实例 1. copy 密码文件cp orapworcl orapwjf3x
2. copy 参数文件cp initorcl.ora initjf3x.ora
3. 修改参数文件修改数据库名,控制文件位置,SGA PGA参数,audit目录等4. 建立不存在的目录5.启动至nomountexport 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
|