db_name/db_unique_name/instance_name/service_names

最新推荐文章于 2024-08-15 01:26:58 发布
最新推荐文章于 2024-08-15 01:26:58 发布
阅读量86 收藏
点赞数
文章标签： 数据库 网络
http://www.oracle-home.ro/Oracle_Database/Architecture/Oracle-service-name.html

Look at these cases and see how an Oracle service is named function of the pfile/ spfile parameters. Listener.ora could add services as well.

 

Case nr. 1

 

DB_NAME                       = 'myDB'

DB_DOMAIN                   - not set in the pfile
DB_UNIQUE_NAME       - not set in the pfile
INSTANCE_NAME         - not set in the pfile

SERVICE_NAMES           - not set in the pfile

 

 

C:\>lsnrctl status

LSNRCTL for 32-bit Windows: Version 10.2.0.1.0 - Production on 21-AUG-2010 11:43:17

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

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=cata1)(PORT=1521)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for 32-bit Windows: Version 10.2.0.1.0 - Production
Start Date 21-AUG-2010 11:27:43
Uptime 0 days 0 hr. 15 min. 34 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File D:\Oracle10g\OH\network\admin\listener.ora
Listener Log File D:\Oracle10g\OH\network\log\listener.log
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=cata1)(PORT=1521)))
Services Summary...
Service "myDB_XPT" has 1 instance(s).
Instance "mydb", status READY, has 1 handler(s) for this service...
Service "mydb" has 1 instance(s).
Instance "mydb", status READY, has 1 handler(s) for this service...
The command completed successfully
 

 

Case nr. 2

 

DB_NAME                         = 'myDB'

DB_DOMAIN                   - not set in the pfile
DB_UNIQUE_NAME       - not set in the pfile
INSTANCE_NAME         - not set in the pfile

SERVICE_NAMES           = 'myDB'

 

The result is the same as in the case nr. 1

 

 

Case nr. 3

 

DB_NAME                         = 'myDB'

DB_DOMAIN                   - not set in the pfile
DB_UNIQUE_NAME       - not set in the pfile
INSTANCE_NAME         - not set in the pfile

SERVICE_NAMES           = 'myDB2'

 

C:\>lsnrctl status

LSNRCTL for 32-bit Windows: Version 10.2.0.1.0 - Production on 21-AUG-2010 12:03:38

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

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=cata1)(PORT=1521)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for 32-bit Windows: Version 10.2.0.1.0 - Production
Start Date 21-AUG-2010 12:03:19
Uptime 0 days 0 hr. 0 min. 19 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File D:\Oracle10g\OH\network\admin\listener.ora
Listener Log File D:\Oracle10g\OH\network\log\listener.log
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=cata1)(PORT=1521)))
Services Summary...
Service "myDB2" has 1 instance(s).
Instance "mydb", status READY, has 1 handler(s) for this service...
Service "myDB_XPT" has 1 instance(s).
Instance "mydb", status READY, has 1 handler(s) for this service...
Service "mydb" has 1 instance(s).
Instance "mydb", status READY, has 1 handler(s) for this service...
The command completed successfully

 

 

Case nr. 4

 

DB_NAME                        = 'myDB'

DB_DOMAIN                   = 'myDomain.ca'
DB_UNIQUE_NAME       - not set in the pfile
INSTANCE_NAME         - not set in the pfile

SERVICE_NAMES           - not set in the pfile

 

C:\>lsnrctl status

 

LSNRCTL for 32-bit Windows: Version 10.2.0.1.0 - Production on 21-AUG-2010 12:08:10

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

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=cata1)(PORT=1521)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for 32-bit Windows: Version 10.2.0.1.0 - Production
Start Date 21-AUG-2010 12:07:58
Uptime 0 days 0 hr. 0 min. 12 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File D:\Oracle10g\OH\network\admin\listener.ora
Listener Log File D:\Oracle10g\OH\network\log\listener.log
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=cata1)(PORT=1521)))
Services Summary...
Service "myDB.myDomain.ca" has 1 instance(s).
Instance "mydb", status READY, has 1 handler(s) for this service...
Service "myDB_XPT.myDomain.ca" has 1 instance(s).
Instance "mydb", status READY, has 1 handler(s) for this service...
The command completed successfully
 

 

Case nr. 5

 

DB_NAME                        = 'myDB'

DB_DOMAIN                   - not set in the pfile
DB_UNIQUE_NAME      = 'myUniqueDB'
INSTANCE_NAME         - not set in the pfile

SERVICE_NAMES           - not set in the pfile

 

C:\>lsnrctl status

 

LSNRCTL for 32-bit Windows: Version 10.2.0.1.0 - Production on 21-AUG-2010 12:20:19

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

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=cata1)(PORT=1521)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for 32-bit Windows: Version 10.2.0.1.0 - Production
Start Date 21-AUG-2010 12:20:08
Uptime 0 days 0 hr. 0 min. 10 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File D:\Oracle10g\OH\network\admin\listener.ora
Listener Log File D:\Oracle10g\OH\network\log\listener.log
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=cata1)(PORT=1521)))
Services Summary...
Service "myUniqueDB" has 1 instance(s).
Instance "mydb", status READY, has 1 handler(s) for this service...
Service "myUniqueDB_XPT" has 1 instance(s).
Instance "mydb", status READY, has 1 handler(s) for this service...
The command completed successfully
 

 

Case nr. 6

 

DB_NAME                        = 'myDB'

DB_DOMAIN                   = 'myDomain.ca'
DB_UNIQUE_NAME      = 'myUniqueDB'
INSTANCE_NAME         - not set in the pfile

SERVICE_NAMES           - not set in the pfile

 

C:\>lsnrctl status

 

LSNRCTL for 32-bit Windows: Version 10.2.0.1.0 - Production on 21-AUG-2010 12:23:48

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

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=cata1)(PORT=1521)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for 32-bit Windows: Version 10.2.0.1.0 - Production
Start Date 21-AUG-2010 12:23:37
Uptime 0 days 0 hr. 0 min. 11 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File D:\Oracle10g\OH\network\admin\listener.ora
Listener Log File D:\Oracle10g\OH\network\log\listener.log
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=cata1)(PORT=1521)))
Services Summary...
Service "myUniqueDB.myDomain.ca" has 1 instance(s).
Instance "mydb", status READY, has 1 handler(s) for this service...
Service "myUniqueDB_XPT.myDomain.ca" has 1 instance(s).
Instance "mydb", status READY, has 1 handler(s) for this service...
The command completed successfully
 

 

Case nr. 7

 

DB_NAME                          = 'myDB'

DB_DOMAIN                    = 'myDomain.ca'
DB_UNIQUE_NAME        = 'myUniqueDB'
INSTANCE_NAME           = 'myInstance'

SERVICE_NAMES           - not set in the pfile

 

C:\>lsnrctl status

 

LSNRCTL for 32-bit Windows: Version 10.2.0.1.0 - Production on 21-AUG-2010 12:26:27

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

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=cata1)(PORT=1521)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for 32-bit Windows: Version 10.2.0.1.0 - Production
Start Date 21-AUG-2010 12:26:19
Uptime 0 days 0 hr. 0 min. 10 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File D:\Oracle10g\OH\network\admin\listener.ora
Listener Log File D:\Oracle10g\OH\network\log\listener.log
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=cata1)(PORT=1521)))
Services Summary...
Service "myUniqueDB.myDomain.ca" has 1 instance(s).
Instance "myInstance", status READY, has 1 handler(s) for this service...
Service "myUniqueDB_XPT.myDomain.ca" has 1 instance(s).
Instance "myInstance", status READY, has 1 handler(s) for this service...
The command completed successfully
 

 listener.ora is always:

 

LISTENER =
   (DESCRIPTION_LIST =
             (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = cata1)(PORT = 1521))
              )
   )

 

for these cases.

 

Case nr. 8 - listener.ora can add services to the Oracle database

 

DB_NAME                           = 'myDB'

DB_DOMAIN                      = 'myDomain.ca'
DB_UNIQUE_NAME          = 'myUniqueDB'
INSTANCE_NAME             = 'myInstance'

SERVICE_NAMES              = 'myService'

 

listener.ora is

-- The listener.ora defines the service names for the database (using GLOBAL_DBNAME in the listener definition).

 

LISTENER =
   (DESCRIPTION_LIST =
       (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = cata1)(PORT = 1521))
       )
   )

SID_LIST_LISTENER=
    (SID_LIST=
             (SID_DESC= (GLOBAL_DBNAME=DB10.myDomanin.fr)(ORACLE_HOME=D:\ORACLE\db10)(SID_NAME=myDB))
             (SID_DESC= (GLOBAL_DBNAME=myDB2)(ORACLE_HOME=D:\ORACLE\db10)(SID_NAME=myDB)))
 

 

C:\>lsnrctl status

 

LSNRCTL for 32-bit Windows: Version 10.2.0.1.0 - Production on 21-AUG-2010 12:50:01

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

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=cata1)(PORT=1521)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for 32-bit Windows: Version 10.2.0.1.0 - Production
Start Date 21-AUG-2010 12:45:54
Uptime 0 days 0 hr. 4 min. 7 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File D:\Oracle10g\OH\network\admin\listener.ora
Listener Log File D:\Oracle10g\OH\network\log\listener.log
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=cata1)(PORT=1521)))
Services Summary...
Service "DB10.myDomanin.fr" has 1 instance(s).
Instance "myDB", status UNKNOWN, has 1 handler(s) for this service...
Service "myDB2" has 1 instance(s).
Instance "myDB", status UNKNOWN, has 1 handler(s) for this service...
Service "myService.myDomain.ca" has 1 instance(s).
Instance "myInstance", status READY, has 1 handler(s) for this service...
Service "myUniqueDB.myDomain.ca" has 1 instance(s).
Instance "myInstance", status READY, has 1 handler(s) for this service...
Service "myUniqueDB_XPT.myDomain.ca" has 1 instance(s).
Instance "myInstance", status READY, has 1 handler(s) for this service...
The command completed successfully

 

 

Notes:

 

1) It is possible to force the service registration with the listener using:

    alter system register

 

2) These cases are tested on Oracle 10.2


来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/228190/viewspace-677327/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/228190/viewspace-677327/

cqlilinfeng2009
关注
  • 0
    点赞
  • 踩
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
Oracle9个_name介绍
05-11
### Oracle中的九个_Name参数详解 #### 一、db_name：数据库名称 ...特别是`db_name`、`instance_name`、`service_name`和`listener`等参数，在日常管理和维护中使用频率较高，是必须掌握的核心概念。
Oracle 数据库监听分析及其说明
11-19
- **DB_UNIQUE_NAME**: 在单实例环境下，等同于 DB_NAME；而在 DG 环境中，则代替 DB_NAME 成为唯一的数据库标识符。 #### 监听器的配置文件 监听器的核心功能由三个主要的配置文件来定义： 1. **listener.ora** ...
DBID,SID,DB_NAME,DB_DOMAIN,INSTANCE_NAME,DB_UNIQUE_NAME,SERVICE_NAMES 及监听参数的说明
小宝老豆的专栏
09-28 945
这篇文章中要讲的几个参数：        DB 相关的： DBID, SID        PFILE中的参数：DB_NAME，DB_DOMAIN,  INSTANCE_NAME，                             DB_UNIQUE_NAME,SERVICE_NAMES,                             GLOBAL_NAME，GLOBAL_
DB_NAME、DB_UNIQUE_NAME、SERVICE_NAME和INSTANCE_NAME等的区别
思维空间
03-13 678
搭建DG时，突然想起oracle这些为数众多的name，以下是概念整理，仅代表个人观点 DB_NAME： ①是数据库名，长度不能超过8个字符，记录在datafile、redolog和control file中 ②在DataGuard环境中DB_NAME相同而DB_UNIQUE_NAME不同 ③在RAC环境中，各个节点的DB_NAME 都相同，但是INSTANCE_NAME不同
SID、ORACLE_SID、INSTANCE_NAME、DB_NAME、SERVER_NAMES、GLOBAL_DBNAME等区别
lusklusklusk的博客
09-03 864
监听中动态注册时的服务名(即lsnrctl status显示的的service对应的名称)： （优先级别service_names.db_domain=db_unique_name.db_domain>db_name.db_domain） 如果有参数值service_names\db_unique_name， 则拼接service_names、db_unique_name参数值和db_domain参数值注册到监听，即两个值 如果只有参数值service_names，且值和db_name值不一样 则拼接
oracle19c单机修改DB_NAME INSTANCE_NAME、PDB
qq_41270538的博客
06-05 1821
oracle 19C 单实例修改DB_NAME、INSTANCE_NAME、PDB
oracle修改了服务名,Oracle修改instance_name、db_name、db_unique_name、service_names
weixin_29765949的博客
04-04 455
Oracle修改instance_name、db_name、db_unique_name、service_names查看当前信息SQL> show parameter nameNAMETYPEVALUE------------------------------------ ----------- ------------------------------db_namestringdapu...
Oracle 19c 修改db_name
weixin_69821704的博客
07-22 381
Oracle数据库使用nid修改db_name
oracle数据库根据名字,Oracle的db_name,service_names,instance_name等参数解析
weixin_34163098的博客
04-03 509
Oracle中有很多与名字相关的参数，有时会让人觉得迷惑，这个参数都有什么作用，它们之间的区别又是什么呢？下面我们先来看一看都有哪些参数与名字相关参数文件中有db_name,instance_name,service_names,db_unique_name环境变量中有oracle_sid在listener.ora中有sid_name,global_dbname(静态注册的情况下)在tnsname...
RAC日常检查.doc
09-09
2. **服务名称和服务实例**：`service_names` 指定数据库提供的服务，而 `Instance` 是运行在每个节点上的数据库实例，如 `orcl1` 和 `orcl2`。 3. **主机名和IP地址**：`hporcl1` 和 `hporcl2` 是节点的主机名，...
数据库运维说明书.docx
10-03
2. **数据库唯一名称**：查询`SELECT db_unique_name FROM v$database`可得到数据库的全局唯一名称。 3. **数据库ID**：`SELECT dbid FROM v$database`用于获取数据库的唯一标识符。 4. **创建时间**：`SELECT to_...
webjs 数据库 离线读取本地数据库源码-SAAS 本地化及未来之窗行业应用跨平台架构
最新发布
cybersnow精通 28 门计算机语言，凭借其超凡的技术能力，成功开发过上万个应用，广泛涉及政府、商业、个人等众多领域，甚至在检察院、环保局、公安局等专业场景中也大放异彩。不仅熟练掌握单片机和物联网开发，在软件架构设计方面更是独树一帜，自创了跨平台软件
08-15 169
【代码】webjs 数据库 离线读取本地数据库源码-SAAS 本地化及未来之窗行业应用跨平台架构。
[Qt][Qt窗口][下]详细讲解
SnowK博客
08-13 3671
[Qt][Qt窗口][下]详细讲解
mysql介绍
weixin_57763462的博客
08-14 295
丰富的存储引擎：MySQL 提供了多种存储引擎，如 InnoDB、MyISAM、Memory 等，每种存储引擎都有其特定的应用场景和优势。多语言支持：MySQL 支持多种编程语言，包括 C、C++、Python、Java、Perl、PHP 等，并提供了相应的 API。安全性：MySQL 提供了灵活的权限和密码系统，支持基于主机的验证，并且所有的密码传输都采用加密形式，确保了数据的安全性。管理工具：MySQL 提供了丰富的管理工具，如命令行客户端、图形界面管理工具等，方便用户进行数据库的管理和维护。
贷齐乐系统sql注入漏洞
banliyaoguai的博客
08-12 672
然后在这里取值的时候.和_会区分开，然后我们可以在第一个i_d写我们的payload，在i.d写正常数据用来绕过waf。可以使用使用php小特性和全局污染绕过，在这里的时候会将.转换成下划线，然后桡骨第一个waf。这里由于等号被过滤乐所以使用like，然后查表名的时候由于'被过滤所以使用了16进制编码。首先php在遇到两个相同名字参数时，php是取后一个的,如下图最终i_d的值为1。代码先走这里将输入的数据进行过滤。然后再继续往下走，再进行一个查询。然后继续往下，用=进行分割。
健身房管理系统
寒夜
08-13 832
【代码】springboot健身房管理系统
DB_NAME="your_database_name"
05-05
'NAME': os.environ.get('DB_NAME'), 'USER': 'your_database_user', 'PASSWORD': 'your_database_password', 'HOST': 'localhost', 'PORT': '5432', } } ``` 这将使用名为 "your_database_name" 的数据库...
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值