docker oracle 创建实例

docker oracle 创建实例

docker run -d -p 1521:1521 --name oracle --restart always --privileged=true registry.cn-hangzhou.aliyuncs.com/helowin/oracle_11g

Linux中新增一个Oracle实例
--命令行建数据库实例
dbca -silent -createDatabase -templateName $ORACLE_HOME/assistants/dbca/templates/Transaction_Processing.dbc -gdbName hua -sid hua -characterSet ZHS16GBK -sysPassword oracle -systemPassword oracle -responseFile NO_VALUE -datafileDestination $ORACLE_BASE/oradata/hua

使用参数说明：
-silent指以静默方式执行dbca命令
-createDatabase指使用dbca
-templateName指定用来创建数据库的模板名称，这里指定为General_Purposedbc，即一般用途的数据库模板
-gdbname指定创建的全局数据库名称，这里指定名称为ocp11g
-sid 指定数据库系统标识符，这里指定为ocp11g，与数据库同名
-responseFile 指定安装响应文件，NO_VALUE表示没有指定响应文件
-characterSet 指定数据库使用的字符集，这里指定为AL32UTF8
-memoryPercentage 指定用于oracle的物理内存的百分比，这里指定为30%
-emConfiguration 指定Enterprise Management的管理选项。LOCAL表示数据库由Enterprise Manager本地管理

cd $ORACLE_BASE/admin
mkdir hua
cd hua
mkdir dpdump adump pfile
cd $ORACLE_BASE/oradata
mkdir hua
cd $ORACLE_BASE/flash_recovery_area
mkdir hua

 

cd $ORACLE_HOME/dbs

cp inithelowin.ora inithua.ora #复制一个原有的ora文件

vi inithua.ora #修改里面的内容

hua.__db_cache_size=1191182336
hua.__java_pool_size=16777216
hua.__large_pool_size=16777216
hua.__oracle_base='/home/oracle/app/oracle'#ORACLE_BASE set from environment
hua.__pga_aggregate_target=1744830464
hua.__sga_target=1610612736
hua.__shared_io_pool_size=0
hua.__shared_pool_size=369098752
hua.__streams_pool_size=0
*.audit_file_dest='/home/oracle/app/oracle/admin/hua/adump'
*.audit_trail='db'
*.compatible='11.2.0.0.0'
*.control_files='/home/oracle/app/oracle/oradata/hua/control01.ctl','/home/oracle/app/oracle/flash_recovery_area/hua/control02.ctl'
*.db_block_size=8192
*.db_domain=''
*.db_name='hua'
*.db_recovery_file_dest='/home/oracle/app/oracle/flash_recovery_area'
*.db_recovery_file_dest_size=4070572032
*.diagnostic_dest='/home/oracle/app/oracle'
*.dispatchers='(PROTOCOL=TCP) (SERVICE=huaXDB)'
*.local_listener='LISTENER_HUA'
*.open_cursors=300
*.pga_aggregate_target=1741684736
*.processes=150
*.remote_login_passwordfile='EXCLUSIVE'
*.sga_target=1610612736
*.undo_tablespace='UNDOTBS1'

cd $ORACLE_BASE/product/11.2.0/dbhome_2/network/admin

vi listener.ora 或 vi tnsnames.ora(优先tnsnames.ora）

增加节点：

(SID_DESC =
(GLOBAL_DBNAME = orcl)
(ORACLE_HOME = /oracle/app/product/11.2.0/dbhome_2)
(SID_NAME = orcl)
)

创建为模板：
vi createdb.sql
#以下为create.sql的内容
CREATE DATABASE hua
MAXINSTANCES 8
MAXLOGHISTORY 1
MAXLOGFILES 16
MAXLOGMEMBERS 3
MAXDATAFILES 100
DATAFILE '/home/oracle/app/oracle/oradata/hua/system01.dbf' size 100m reuse autoextend on next 1m maxsize unlimited extent management local
sysaux datafile '/home/oracle/app/oracle/oradata/hua/sysaux01.dbf' size 100m reuse autoextend on next 1m maxsize unlimited
default temporary tablespace TEMP tempfile '/home/oracle/app/oracle/oradata/hua/temp01.dbf' size 20m reuse autoextend on next 640k maxsize unlimited
undo tablespace UNDOTBS1 datafile '/home/oracle/app/oracle/oradata/hua/undo01.dbf' size 20m reuse autoextend on next 5M maxsize unlimited
logfile
GROUP 1 ('/home/oracle/app/oracle/oradata/hua/redo1.dbf') size 10m,
GROUP 2 ('/home/oracle/app/oracle/oradata/hua/redo2.dbf') size 10m,
GROUP 3 ('/home/oracle/app/oracle/oradata/hua/redo3.dbf') size 10m
CHARACTER SET ZHS16GBK
NATIONAL CHARACTER SET AL16UTF16;

 

 

 

chmod 777 createdb.sql

export ORACLE_SID=hua

sqlplus / as sysdba

SQL>startup nomount;

SQL>@/home/oracle/app/oracle/product/11.2.0/dbhome_2/dbs/createdb.sql

SQL>@?/rdbms/admin/catalog.sql;

SQL>@?/rdbms/admin/catproc.sql;

SQL>@?/sqlplus/admin/pupbld.sql;

SQL>startup force;

SQL>exit;

 

 

重启监听

lsnrctl stop

lsnrctl start

SQL>create user hua identified by 123456; 创建用户

SQL>grant connect,resource,dba to hua; 授权