为数据库设置多个服务名(通过SCOPE=both设置，同时修改参数文件)

SQL> show parameter service_names;

NAME TYPE VALUE

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

service_names string vmdb

SQL> alter system set service_names='vmdb,sn01,sn02' scope=both;

System altered.

重启监听后，监听状态并未显示服务sn01,sn02

[oracle@CentOS ~]$ lsnrctl stop

LSNRCTL ::

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

Connecting )))

The command completed successfully

[oracle@CentOS ~]$ lsnrctl start

LSNRCTL ::

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

Starting /dbhome_1/bin/tnslsnr: please wait...

TNSLSNR - Production

System parameter /dbhome_1/network/admin/listener.ora

Log messages written to /u01/app/oracle/diag/tnslsnr/CentOS/listener/alert/log.xml

Listening )))

Connecting )))

STATUS of the LISTENER

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

Alias LISTENER

Version TNSLSNR - Production

Start Date ::

Uptime days hr. sec

Trace Level off

Security ON: Local OS Authentication

SNMP OFF

Listener Parameter /dbhome_1/network/admin/listener.ora

Listener Log File /u01/app/oracle/diag/tnslsnr/CentOS/listener/alert/log.xml

Listening Endpoints Summary...

(DESCRIPTION)))

Services Summary...

Service "vmdb" has instance(s).

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

The command completed successfully

通过另一台机器通过服务名sn01连接可以连接上：

/sn01

SQL Production ::

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

ERROR:

ORA: the password will expire within days

Connected to:

Oracle - 64bit Production

With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL>

在数据库中可以查询v$session视图的service_name来判断会话是由通过哪个服务名连接创建的：

SQL> col paddr format a20

SQL

SQL> col username format a15

SQL> col service_name format a20

SQL> Select paddr,Sid,serial#,username,service_name From v$session Where username Is Not Null;

PADDR SID SERIAL# USERNAME SERVICE_NAME

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

000000008DC95250 SYS SYS$USERS

000000008DC98310 TEST vmdb

000000008DC96290 TEST sn01

000000008DC99350 TEST vmdb

重启数据库：

SQL> shutdown immediate;

Database closed.

Database dismounted.

ORACLE instance shut down.

SQL> startup

ORACLE instance started.

Total System Global Area bytes

Fixed Size bytes

Variable Size bytes

bytes

Redo Buffers bytes

Database mounted.

Database opened.

再次查看监听，sn01,sn02服务名显示出来了：

[oracle@CentOS ~]$ lsnrctl status

LSNRCTL ::

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

Connecting )))

STATUS of the LISTENER

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

Alias LISTENER

Version TNSLSNR - Production

Start Date ::

Uptime days hr. sec

Trace Level off

Security ON: Local OS Authentication

SNMP OFF

Listener Parameter /dbhome_1/network/admin/listener.ora

Listener Log File /u01/app/oracle/diag/tnslsnr/CentOS/listener/alert/log.xml

Listening Endpoints Summary...

(DESCRIPTION)))

Services Summary...

Service "sn01" has instance(s).

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

Service "sn02" has instance(s).

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

Service "vmdb" has instance(s).

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

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

Service "vmdbXDB" has instance(s).

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

The command completed successfully

但是监听配置文件里不会自动增加服务名sn01,sn02：

/dbhome_1/network/admin/listener.ora

# listener.ora Network Configuration /dbhome_1/network/admin/listener.ora

# Generated by Oracle configuration tools.

SID_LIST_LISTENER =

(SID_LIST =

(SID_DESC =

(GLOBAL_DBNAME = vmdb)

(ORACLE_HOME /dbhome_1)

(SID_NAME = vmdb)

)

)

LISTENER =

(DESCRIPTION =

(ADDRESS ))

)

ADR_BASE_LISTENER = /u01/app/oracle

随机推荐

NotePad++中如何出去闪烁的光标？

当在写代码时出现的光标闪烁(横线闪烁),在键盘上找 Insert ,按这个Insert就可以把横向闪烁光标( _ )修改成竖向闪烁光标样式( | ),横向光标会在你写代码的时候修改前面的代码,把光标移 ...

学习PYTHON之路， DAY 7 - PYTHON 基础 7 (面向对象基础)

面向对象三大特性 一.封装 封装,顾名思义就是将内容封装到某个地方,以后再去调用被封装在某处的内容. 所以,在使用面向对象的封装特性时,需要: 将内容封装到某处 从某处调用被封装的内容 第一步:将内容 ...

FZU 2144 Shooting Game

Shooting Game Time Limit:1000MS     Memory Limit:32768KB     64bit IO Format:%I64d & %I64u Submi ...

ngx_http_upstream_module模块学习笔记

ngx_http_upstream_module用于将多个服务器定义成服务器组,而由proxy_pass,fastcgi_pass等指令引用 (1)upstream name  {...} 定义一个后 ...

Windows 进程通信 之 DDE技术

DDE (Dynamic Data Exchange,DDE)动态数据交换,是一种进程间通信机制,它最早是随着Windows由微软提出的.当前大部分软件仍旧支持DDE,但最近十年里微软已经停止发展DD ...

PCB布线的地线干扰与抑制方法

1．地线的定义什么是地线?大家在教科书上学的地线定义是:地线是作为电路电位基准点的等电位体.这个定义是不符合实际情况的.实际地线上的电位并不是恒定的.如果用仪表测量一下地线上各点之间的电位,会发现地线 ...

python3 json数据格式的转换(dumps/loads的使用、dict to str/str to dict、json字符串/字典的相互转换)

在写网络爬虫的时候,有时候会抓取到一些json格式的字符串,想要通过python字典的方式对字串中的内容进行寻址,则需要将json字符串先转换为python字典. dumps()函数: loads() ...

统计字符串中字符出现的次数(||和&&的区别)

var str = "ProsperLee"; // || 返回第一个为真的表达式的值,若全为假则返回最后一个表达式的值 // && 返回第一个为假的表达式的值,若 ...

VUE-008-通过路由 router.push 传递 query 参数(路由 path 识别，请求链接显示参数传递)

在前端页面表单列表修改时,经常需要在页面切换的时候,传递需要修改的表单内容,通常可通过路由进行表单参数的传递. 首先,配置页面跳转路由.在 router/index.js 中配置相应的页面跳转路由,如 ...

Dockerfile指令详解

Dockerfile中包括FROM.MAINTAINER.RUN.CMD.EXPOSE.ENV.ADD.COPY.ENTRYPOINT.VOLUME.USER.WORKDIR.ONBUILD等13个指 ...