配置oracle实例,oracle的环境配置-单独创建数据库实例-CSDN博客

单独创建数据库实例

数据库1 数据库2

ORCL LAW ------RDBMS(服务)

| |

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

安装数据库软件(DBMS)

单独再创建一个RDBMS--LAW

[[email protected] ~]# xhost +

access control disabled, clients can connect from any host --自动启动了xmanager passive

[[email protected] ~]# su - oracle

[[email protected] ~]$ export DISPLAY="10.1.1.250:0.0"

[[email protected] ~]$ export LANG=en_US

[[email protected] ~]$ dbca --注意：选择字符集为UTF8 不创建LAW的OEM

[[email protected] ~]$ lsnrctl

LSNRCTL for Linux: Version 10.2.0.1.0 - Production on 05-JUN-2014 14:31:51

Welcome to LSNRCTL, type "help" for information.

LSNRCTL> status

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1)))

STATUS of the LISTENER

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

Alias LISTENER

Version TNSLSNR for Linux: Version 10.2.0.1.0 - Production

Start Date 05-JUN-2014 11:30:50

Uptime 0 days 3 hr. 1 min. 2 sec

Trace Level off

Security ON: Local OS Authentication

SNMP OFF

Listener Parameter File /u01/oracle/product/10.2.0/db_1/network/admin/listener.ora

Listener Log File /u01/oracle/product/10.2.0/db_1/network/log/listener.log

Listening Endpoints Summary...

(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1)))

(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=oracle3)(PORT=1521)))

Services Summary...

Service "LAW" has 1 instance(s). --监听的第一个实例LAW

Instance "LAW", status READY, has 1 handler(s) for this service...

Service "LAWXDB" has 1 instance(s).

Instance "LAW", status READY, has 1 handler(s) for this service...

Service "LAW_XPT" has 1 instance(s).

Instance "LAW", status READY, has 1 handler(s) for this service...

Service "ORCL" has 1 instance(s). --监听的第二个实例ORCL

Instance "ORCL", status READY, has 1 handler(s) for this service...

Service "ORCLXDB" has 1 instance(s).

Instance "ORCL", status READY, has 1 handler(s) for this service...

Service "ORCL_XPT" has 1 instance(s).

Instance "ORCL", status READY, has 1 handler(s) for this service...

Service "PLSExtProc" has 1 instance(s).

Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...

The command completed successfully

ORCL LAW(创建了不一定要在内存中存在，除非启动它)

| |

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

listener：1521

---------Linux----port：1521---------

外部连接

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

手工配置LAW的OEM

0、临时修改环境变量

[[email protected] ~]$ export ORACLE_SID=LAW

1、首先要启动LAW实例

2、运行配置工具配置

[[email protected] ~]$ emca -config dbcontrol db -repos recreate

EMCA 开始于 2014-6-5 15:40:12

EM Configuration Assistant 10.2.0.1.0 正式版

输入以下信息:

数据库 SID: LAW

监听程序端口号: 1521

SYS 用户的口令:

DBSNMP 用户的口令:

SYSMAN 用户的口令:

通知的电子邮件地址 (可选):

通知的发件 (SMTP) 服务器 (可选):

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

已指定以下设置

数据库 ORACLE_HOME ................ /u01/oracle/product/10.2.0/db_1

数据库主机名 ................ oracle3

监听程序端口号 ................ 1521

数据库 SID ................ LAW

通知的电子邮件地址 ...............

通知的发件 (SMTP) 服务器 ...............

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

是否继续? [yes(Y)/no(N)]: Y

2014-6-5 15:40:31 oracle.sysman.emcp.EMConfig perform

信息: 正在将此操作记录到 /u01/oracle/product/10.2.0/db_1/cfgtoollogs/emca/LAW/emca_2014-06-05_03-40-12-下午.log。

2014-6-5 15:40:32 oracle.sysman.emcp.EMReposConfig dropRepository

信息: 正在删除 EM 资料档案库 (此操作可能需要一段时间)...

2014-6-5 15:40:32 oracle.sysman.emcp.EMReposConfig invoke

信息: 已成功删除资料档案库

2014-6-5 15:40:32 oracle.sysman.emcp.EMReposConfig createRepository

信息: 正在创建 EM 资料档案库 (此操作可能需要一段时间)...

2014-6-5 15:41:59 oracle.sysman.emcp.EMReposConfig invoke

信息: 已成功创建资料档案库

2014-6-5 15:42:01 oracle.sysman.emcp.util.DBControlUtil startOMS

信息: 正在启动 Database Control (此操作可能需要一段时间)...

2014-6-5 15:43:43 oracle.sysman.emcp.EMDBPostConfig performConfiguration

信息: 已成功启动 Database Control

2014-6-5 15:43:43 oracle.sysman.emcp.EMDBPostConfig performConfiguration

信息: >>>>>>>>>>> Database Control URL 为 http://oracle3:5500/em <<<<<<<<<<<

已成功完成 Enterprise Manager 的配置

EMCA 结束于 2014-6-5 15:43:43

http://10.1.3.3:5500/em/console/aboutApplication

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

删除一个数据库实例

[[email protected] ~]$ export ORACLE_SID=LAW

[[email protected] ~]$ dbca --删除实例LAW

原文：http://fengsonglin.blog.51cto.com/9860507/1615202