Copyright (c) 1991, 2009, Oracle. All rights reserved.
Starting /u01/app/oracle/product/11.2.0/dbhome_1/bin/tnslsnr: please wait...
TNSLSNR for Linux: Version 11.2.0.1.0 - Production System parameter file is /u01/app/oracle/product/11.2.0/dbhome_1/network/admin/listener.ora Log messages written to /u01/app/oracle/diag/tnslsnr/dbhost/listener/alert/log.xml Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=173.0.2.113)(PORT=1521)))
DCCB1 = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 173.0.2.113)(PORT =
1521)) ) (CONNECT_DATA = (SERVICE_NAME = dccb1) )
)
DCCB = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 173.0.2.113)(PORT =
件。
[oracle@dbhost admin]$ more listener.ora # listener.ora Network Configuration File: /u01/app/oracle/product/11.2.0/dbhome_1/network/admin/listener.ora # Generated by Oracle configuration tools.
Total System Global Area 1603411968 bytes
Fixed Size
2213776 bytes
Variable Size
989857904 bytes
Database Buffers
603979776 bytes
Redo Buffers
7360512 bytes
Database mounted.
network : snaumihi_inithostinfo network : snaumbg_gmt network : naedpwd_encrypt network : naumbsb_bld_singlebyte network : ztapis
network : nlgh
2. 编辑 ORACLE_HOME 下的 network/admin/下的 listener.ora 文
Connecting to
(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=173.0.2.113)(PORT=1521)))
STATUS of the LISTENER
------------------------
Alias
LISTENER
Version
TNSLSNR for Linux: Version 11.2.0.1.0 - Production
Listener Log File
/u01/app/oracle/diag/tnslsnr/dbhost/listener/alert/log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=173.0.2.113)(PORT=1521)))
Oracle 数据库 一个监听多个实例设置
Edit by shuyun
有时，为了测试数据库，我们需要在同一台服务器建两个数 据库实例，用同一个监听远程访问这俩数据库，这样我们就要做一些 配置。
图形界面下： 使用网络配置工具的方法 一、 打开网络配置工具
二、 设置 Profile，至少选择 tnsname 和 h个 Service Name
五、 配置监听
在 shell 下就分一下几个步骤：
1. 编辑 ORACLE_HOME 下的 network/admin/下的 shrept.lst 文件
[oracle@dbhost admin]$ more shrept.lst # function entry points for genclntsh.sh
Database opened.
SQL>
4. 连接 dccb 试试
SQL> conn sys/system@dccb as sysdba Connected.
5. 连接 dccb1 并启动
SQL> conn sys/system@dccb1 as sysdba Connected to an idle instance. SQL> startup; ORACLE instance started.
Start Date
11-NOV-2015 17:28:47
Uptime
0 days 0 hr. 0 min. 0 sec
Trace Level
off
Security
ON: Local OS Authentication
SNMP
OFF
Listener Parameter File
/u01/app/oracle/product/11.2.0/dbhome_1/network/admin/listener.ora
SQL*Plus: Release 11.2.0.1.0 Production on Wed Nov 11 17:29:38 2015
Copyright (c) 1982, 2009, Oracle. All rights reserved.
SQL>
3. 连接并启动数据库
SQL> conn /as sysdba Connected to an idle instance. SQL> startup; ORACLE instance started.
(GLOBAL_DBNAME = dccb1) (ORACLE_HOME = /u01/app/oracle/product/11.2.0/dbhome_1) (SID_NAME = dccb1) ) )
LISTENER = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 173.0.2.113)(PORT =
Total System Global Area 1202556928 bytes
Fixed Size
2212816 bytes
Variable Size
369101872 bytes
Database Buffers
822083584 bytes
Redo Buffers
9158656 bytes
Database mounted.
1521)) ) (CONNECT_DATA = (SERVICE_NAME = dccb) )
)
这样就 OK 了！
我们来测试一下连接:
1. 首先启动监听
[root@dbhost ~]# su - oracle [oracle@dbhost ~]$ lsnrctl start
LSNRCTL for Linux: Version 11.2.0.1.0 - Production on 11-NOV-2015 17:28:46
SID_LIST_LISTENER = (SID_LIST = (SID_DESC = (GLOBAL_DBNAME = dccb) (ORACLE_HOME =
/u01/app/oracle/product/11.2.0/dbhome_1) (SID_NAME = dccb)
) (SID_DESC =
1521)) )
ADR_BASE_LISTENER = /u01/app/oracle
3. 编辑 ORACLE_HOME 下的 network/admin/下的 tnsnames.ora
文件。
[oracle@dbhost admin]$ more tnsnames.ora # tnsnames.ora Network Configuration File: /u01/app/oracle/product/11.2.0/dbhome_1/network/admin/tnsnames.or a # Generated by Oracle configuration tools.
Database opened.
6. 连接 dccb1 试试
SQL> conn sys/system@dccb1 as sysdba Connected.
Services Summary...
Service "dccb" has 1 instance(s).
Instance "dccb", status UNKNOWN, has 1 handler(s) for this service...
Service "dccb1" has 1 instance(s).
Instance "dccb1", status UNKNOWN, has 1 handler(s) for this service...
The command completed successfully
2. 进入 sqlplus