oracle12c静默创建监听,LINUX环境下静默建库ORACLE11gR2 | 信春哥，系统稳，闭眼上线不回滚！...

[oracle@stream ~]$ vi database/response/dbca.rsp

RESPONSEFILE_VERSION = "11.2.0"

OPERATION_TYPE = "createDatabase"

GDBNAME = "STREAM"

SID = "stream"

TEMPLATENAME = "New_Database.dbt"

SYSPASSWORD = "oracle"

SYSTEMPASSWORD = "oracle"

SYSMANPASSWORD = "oracle"

DBSNMPPASSWORD = "oracle"

DATAFILEDESTINATION ="/u01/app/oracle/oradata/stream"

STORAGETYPE=FS

CHARACTERSET = "ZHS16GBK"

NATIONALCHARACTERSET= "AL16UTF16"

DATABASETYPE = "MULTIPURPOSE"

AUTOMATICMEMORYMANAGEMENT = "FALSE"

以上参数的含义如下：

RESPONSEFILE_VERSION：数据库版本信息。

OPERATION_TYPE：执行操作类型：创建数据库、根据DB创建模板、

创建克隆模板、删除数据库、配置数据库、添加实例(RAC环境下)、

删除实例(RAC环境下)

GDBNAME：指定Global Name

SID：指定SID

TEMPLATENAME：模板名称

SYSPASSWORD：SYS用户密码

SYSTEMPASSWORD：SYSTEM用户密码

SYSMANPASSWORD：SYSMAN用户的密码，当EM管理类型选择local的时候需要

DBSNMPPASSWORD：DBS的密码，当EM设置了之后需要

DATAFILEDESTINATION：数据库文件的存放目录

STORAGETYPE：数据库要创建在何种文件类型FS、ASM等

CHARACTERSET：数据库字符集

NATIONALCHARACTERSET：国家字符集

DATABASETYPE：指定数据库的类型，有OLTP或者warehouse

AUTOMATICMEMORYMANAGEMENT：是否开启AMM内存自动管理

2.配置好responseFile文件以后，就可以开始静默安装了。

[oracle@stream database]$ dbca -silent -responseFile

/home/oracle/database/response/dbca.rsp

Copying database files

1% complete

3% complete

37% complete

Creating and starting Oracle instance

40% complete

45% complete

50% complete

55% complete

56% complete

60% complete

62% complete

Completing Database Creation

66% complete

70% complete

73% complete

85% complete

96% complete

100% complete

Look at the log file "/u01/app/oracle/cfgtoollogs/dbca/STREAM/

STREAM.log" for further details.

数据库创建完成后，登录数据库，验证是否成功创建。

[oracle@stream database]$ sqlplus / as sysdba

SQL*Plus: Release 11.2.0.1.0 Production on Thu Mar 1 10:44:40 2012

Copyright (c) 1982, 2009, Oracle. All rights reserved.

Connected to:

Oracle Database 11g Enterprise Edition Release 11.2.0.1.0-Production

With the Partitioning, OLAP, Data Mining and Real Application

SQL> select status,instance_name from v$instance;

STATUS INSTANCE_NAME

------------ ----------------

OPEN stream

SQL> select name,OPEN_MODE,CURRENT_SCN,DBID,CREATED from v$database;

NAME OPEN_MODE DBID CREATED

--------- -------------------- ---------- ---------

STREAM READ WRITE 1542802256 01-MAR-12

SQL> select * from v$version;

BANNER

----------------------------------------------------------------

Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 -

Production PL/SQL Release 11.2.0.1.0 - Production

CORE 11.2.0.1.0 Production

TNS for Linux: Version 11.2.0.1.0 - Production

NLSRTL Version 11.2.0.1.0 – Production

SQL> show parameter spfile

NAME TYPE VALUE

---------- ----------- ------------------------------

spfile string /u01/app/oracle/product/11.2.0

/dbhome_1/dbs/spfilestream.ora

SQL> select name from v$datafile;

NAME

--------------------------------------------------

/u01/app/oracle/oradata/stream/STREAM/system01.dbf

/u01/app/oracle/oradata/stream/STREAM/sysaux01.dbf

/u01/app/oracle/oradata/stream/STREAM/undotbs01.dbf

/u01/app/oracle/oradata/stream/STREAM/users01.dbf

SQL> select * from v$tablespace;

TS# NAME INC BIG FLA ENC

---------- ------------------------------ --- --- --- ---

0 SYSTEM YES NO YES

1 SYSAUX YES NO YES

2 UNDOTBS1 YES NO YES

4 USERS YES NO YES

3 TEMP NO NO YES

SQL> show parameter control_files

NAME TYPE VALUE

------------- --------- ------------------------------

control_files string /u01/app/oracle/oradata/stream

/STREAM/control01.ctl, /u01/ap

p/oracle/flash_recovery_area/S

TREAM/control02.ctl

SQL> select GROUP#,SEQUENCE#,BYTES,MEMBERS,STATUS from v$log;

GROUP# SEQUENCE# BYTES MEMBERS STATUS

---------- ---------- ---------- ---------- --------

1 4 52428800 1 INACTIVE

2 5 52428800 1 CURRENT

3 3 52428800 1 INACTIVE

由于设置了AUTOMATICMEMORYMANAGEMENT = “FALSE”，所以数据库AMM自动内存管理没有使用。AMM是ORACLE11g的新特性，自动管理SGA+PGA部分的内存。

SQL> show parameter memory_

NAME TYPE VALUE

------------------------ ----------- -----

hi_shared_memory_address integer 0

memory_max_target big integer 0

memory_target big integer 0

shared_memory_address integer 0

3.静默配置监听。

如果使用DBCA图形界面创建数据库，在安装玩数据库软件后就需要创建监听，如果使用静默的方式创建数据库，则可以在创建数据库之后创建监听，静默创建监听也很简单，值需要修改$ORACLE_HOME/network/admin/ listener.ora文件即可，初始没有这个文件，需要手动创建。

[oracle@stream admin]$ vi listener.ora

LISTENER =

(DESCRIPTION =

(ADDRESS = (PROTOCOL = TCP)(HOST = stream)(PORT = 1521))

)

只需要在listener.ora文件里加入上面几行信息，即可启动监听。

[oracle@stream admin]$ lsnrctl start

在远程客户端的tnsnames.ora文件中加入以下内容。

STREAM_TEST =

(DESCRIPTION =

(ADDRESS_LIST =

(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.60.130)(PORT = 1521))

)

(CONNECT_DATA =

(SERVICE_NAME = stream)

)

)

远程客户端登录数据库测试。

D:Administrator>sqlplus system/ORACLE@STREAM_TEST

SQL*Plus: Release 11.2.0.1.0 Production on 星期四 3月 1 11:52:13 2012

Copyright (c) 1982, 2010, Oracle. All rights reserved.

连接到:

Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production

With the Partitioning, OLAP, Data Mining and Real Application

SQL> SHOW PARAMETER NAME

NAME TYPE VALUE

------------------------ ----------- ------

db_file_name_convert string

db_name string STREAM

db_unique_name string STREAM

global_names boolean FALSE

instance_name string stream

lock_name_space string

log_file_name_convert string

service_names string STREAM

SQL> SELECT DBID FROM V$DATABASE;

DBID

----------

1542802256

上文查过静默安装的数据库DBID为1542802256，证明数据库连接正确，静默配置的监听好用。