oracle 11g rac配置em dbconsole ORA-12514

最新推荐文章于 2023-05-15 16:55:02 发布

你好我是李白

最新推荐文章于 2023-05-15 16:55:02 发布

阅读量361

点赞数

分类专栏： Oracle Err 文章标签： em dbconsole ora-12514

本文链接：https://blog.youkuaiyun.com/jwocnimabi/article/details/115693431

版权

本文档详细介绍了在Oracle 11g RAC环境中配置Enterprise Manager (EM) Database Console时遇到ORA-12514错误的解决过程，包括问题描述、解决步骤以及重新运行的注意事项。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

oracle 11g rac配置em dbconsole ORA-12514

1. 问题

[oracle@db-oracle-node1 log]$ emca -config dbcontrol db -repos recreate -cluster

STARTED EMCA at Apr 14, 2021 9:56:06 AM
EM Configuration Assistant, Version 11.2.0.3.0 Production
Copyright (c) 2003, 2011, Oracle.  All rights reserved.

Enter the following information:
Database unique name: honor
Service name: honor
Listener ORACLE_HOME [ /u01/app/11.2/grid ]: 
Password for SYS user:  
Database Control is already configured for the database honor
You have chosen to configure Database Control for managing the database honor
This will remove the existing configuration and the default settings and perform a fresh configuration
----------------------------------------------------------------------
WARNING : While repository is dropped the database will be put in quiesce mode.
----------------------------------------------------------------------
Do you wish to continue? [yes(Y)/no(N)]: yes
Password for DBSNMP user:  
Password for SYSMAN user:  
Password for SYSMAN user: Cluster name: db-orac-cluster
Email address for notifications (optional): 
Outgoing Mail (SMTP) server for notifications (optional): 
ASM ORACLE_HOME [ /u01/app/11.2/grid ]: 
ASM port [ 1521 ]: 
ASM username [ ASMSNMP ]: 
ASM user password:  
Apr 14, 2021 9:59:53 AM oracle.sysman.emcp.util.GeneralUtil initSQLEngineRemotely
WARNING: Error during db connection : ORA-12514: TNS:listener does not currently know of service requested in connect descriptor

2. 问题解决

这个问题为ASM实例未注册到SCAN Listener导致。

[grid@db-oracle-node1 trace]$ lsnrctl status listener_scan1

LSNRCTL for Linux: Version 11.2.0.4.0 - Production on 14-APR-2021 10:01:05

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

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER_SCAN1)))
STATUS of the LISTENER
------------------------
Alias                     LISTENER_SCAN1
Version                   TNSLSNR for Linux: Version 11.2.0.4.0 - Production
Start Date                14-APR-2021 08:15:09
Uptime                    0 days 1 hr. 45 min. 56 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
Listener Parameter File   /u01/app/11.2/grid/network/admin/listener.ora
Listener Log File         /u01/app/11.2/grid/log/diag/tnslsnr/db-oracle-node1/listener_scan1/alert/log.xml
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=LISTENER_SCAN1)))
  (DESCRIPTION=(ADDRESS=(PROTOC

最低0.47元/天解锁文章