# 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

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=(PROTOCOL=tcp)(HOST=192.168.204.200)(PORT=1521)))
Services Summary...
Service "honor" has 1 instance(s).
  Instance "honor1", status READY, has 1 handler(s) for this service...
Service "honorXDB" has 1 instance(s).
  Instance "honor1", status READY, has 1 handler(s) for this service...
The command completed successfully

[grid@db-oracle-node1 trace]$ sqlplus / as sysasm

SQL*Plus: Release 11.2.0.4.0 Production on Wed Apr 14 10:01:38 2021

Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Real Application Clusters and Automatic Storage Management options

SQL> show parameter remote;

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
remote_listener                      string
remote_login_passwordfile            string      EXCLUSIVE
remote_os_authent                    boolean     FALSE
remote_os_roles                      boolean     FALSE
SQL> alter system set remote_listener='(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.204.200)(PORT=1521)))','(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.204.181)(PORT=1521)))';

System altered.

SQL> !lsnrctl status listener_scan1;

LSNRCTL for Linux: Version 11.2.0.4.0 - Production on 14-APR-2021 10:02:48

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. 47 min. 39 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=(PROTOCOL=tcp)(HOST=192.168.204.200)(PORT=1521)))
Services Summary...
Service "+ASM" has 1 instance(s).
  Instance "+ASM1", status READY, has 1 handler(s) for this service...
Service "honor" has 1 instance(s).
  Instance "honor1", status READY, has 1 handler(s) for this service...
Service "honorXDB" has 1 instance(s).
  Instance "honor1", status READY, has 1 handler(s) for this service...
The command completed successfully

```

## 3. 重新執行

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

STARTED EMCA at Apr 14, 2021 10:02:56 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:  
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:  
-----------------------------------------------------------------

You have specified the following settings

Database ORACLE_HOME ................ /u01/app/oracle/product/11.2/db_1

Database instance hostname ................ Listener ORACLE_HOME ................ /u01/app/11.2/grid
Listener port number ................ 1521
Cluster name ................ db-orac-cluster
Database unique name ................ honor
Email address for notifications ............... 
Outgoing Mail (SMTP) server for notifications ............... 
ASM ORACLE_HOME ................ /u01/app/11.2/grid
ASM port ................ 1521
ASM user role ................ SYSDBA
ASM username ................ ASMSNMP

-----------------------------------------------------------------
----------------------------------------------------------------------
WARNING : While repository is dropped the database will be put in quiesce mode.
----------------------------------------------------------------------
Do you wish to continue? [yes(Y)/no(N)]: yes
Apr 14, 2021 10:07:25 AM oracle.sysman.emcp.EMConfig perform
INFO: This operation is being logged at /u01/app/oracle/cfgtoollogs/emca/honor/emca_2021_04_14_10_02_56.log.
Apr 14, 2021 10:07:28 AM oracle.sysman.emcp.util.DBControlUtil stopOMS
INFO: Stopping Database Control (this may take a while) ...
Apr 14, 2021 10:07:52 AM oracle.sysman.emcp.EMReposConfig invoke
INFO: Dropping the EM repository (this may take a while) ...
Apr 14, 2021 10:11:58 AM oracle.sysman.emcp.EMReposConfig invoke
INFO: Repository successfully dropped
Apr 14, 2021 10:12:00 AM oracle.sysman.emcp.EMReposConfig createRepository
INFO: Creating the EM repository (this may take a while) ...
Apr 14, 2021 10:21:59 AM oracle.sysman.emcp.EMReposConfig invoke
INFO: Repository successfully created
Apr 14, 2021 10:22:10 AM oracle.sysman.emcp.EMReposConfig uploadConfigDataToRepository
INFO: Uploading configuration data to EM repository (this may take a while) ...
Apr 14, 2021 10:23:46 AM oracle.sysman.emcp.EMReposConfig invoke
INFO: Uploaded configuration data successfully
Apr 14, 2021 10:23:48 AM oracle.sysman.emcp.EMDBCConfig instantiateOC4JConfigFiles
INFO: Propagating /u01/app/oracle/product/11.2/db_1/oc4j/j2ee/OC4J_DBConsole_db-oracle-node1_honor to remote nodes ...
Apr 14, 2021 10:24:00 AM oracle.sysman.emcp.EMAgentConfig deployStateDirs
INFO: Propagating /u01/app/oracle/product/11.2/db_1/db-oracle-node1_honor to remote nodes ...
Apr 14, 2021 10:24:01 AM oracle.sysman.emcp.util.DBControlUtil secureDBConsole
INFO: Securing Database Control (this may take a while) ...
Apr 14, 2021 10:24:02 AM oracle.sysman.emcp.util.PlatformInterface executeCommand
WARNING: Error executing /u01/app/oracle/product/11.2/db_1/bin/emctl config emkey -repos -host db-oracle-node1 -sid honor 
Apr 14, 2021 10:24:02 AM oracle.sysman.emcp.util.DBControlUtil secureDBConsole
WARNING: Configuring EM-Key failed for node db-oracle-node1.
Apr 14, 2021 10:24:02 AM oracle.sysman.emcp.EMDBPostConfig setRACWarnMsg
INFO: Error securing Database Control. Database Control has not been brought-up on nodes db-oracle-node1 . Execute the following command(s) on nodes: db-oracle-node1 . 
 
 1) Set the environment variable ORACLE_UNQNAME to Database unique name 
 2) /u01/app/oracle/product/11.2/db_1/bin/emctl config emkey -repos -sysman_pwd < Password for SYSMAN user > -host <node> -sid < Database unique name > 
 3) /u01/app/oracle/product/11.2/db_1/bin/emctl secure dbconsole -sysman_pwd < Password for SYSMAN user > -host <node> -sid < Database unique name > 
 4) /u01/app/oracle/product/11.2/db_1/bin/emctl start dbconsole 
 
To secure Em Key, run /u01/app/oracle/product/11.2/db_1/bin/emctl config emkey -remove_from_repos -sysman_pwd < Password for SYSMAN user >
Apr 14, 2021 10:24:04 AM oracle.sysman.emcp.EMDBPostConfig performConfiguration
INFO: >>>>>>>>>>> The Database Control URL is http://db-oracle-node1:1158/em <<<<<<<<<<<
Apr 14, 2021 10:24:04 AM oracle.sysman.emcp.EMDBPostConfig showClusterDBCAgentMessage
INFO: 
****************  Current Configuration  ****************
 INSTANCE            NODE           DBCONTROL_UPLOAD_HOST
----------        ----------        ---------------------

honor             db-oracle-node1             db-oracle-node1

Error securing Database Control. Database Control has not been brought-up on nodes db-oracle-node1 . Execute the following command(s) on nodes: db-oracle-node1 . 
 
 1) Set the environment variable ORACLE_UNQNAME to Database unique name 
 2) /u01/app/oracle/product/11.2/db_1/bin/emctl config emkey -repos -sysman_pwd < Password for SYSMAN user > -host <node> -sid < Database unique name > 
 3) /u01/app/oracle/product/11.2/db_1/bin/emctl secure dbconsole -sysman_pwd < Password for SYSMAN user > -host <node> -sid < Database unique name > 
 4) /u01/app/oracle/product/11.2/db_1/bin/emctl start dbconsole 
 
To secure Em Key, run /u01/app/oracle/product/11.2/db_1/bin/emctl config emkey -remove_from_repos -sysman_pwd < Password for SYSMAN user >
[oracle@db-oracle-node1 log]$ 
```

```
[oracle@db-oracle-node1 ~]$ /u01/app/oracle/product/11.2/db_1/bin/emctl config emkey -repos -sysman_pwd 111111 -host db-oracle-node1 -sid honor
Oracle Enterprise Manager 11g Database Control Release 11.2.0.4.0 
Copyright (c) 1996, 2013 Oracle Corporation.  All rights reserved.

The Em Key has been configured successfully.

[oracle@db-oracle-node1 ~]$ /u01/app/oracle/product/11.2/db_1/bin/emctl secure dbconsole -sysman_pwd 111111 -host db-oracle-node1 -sid honor
Oracle Enterprise Manager 11g Database Control Release 11.2.0.4.0 
Copyright (c) 1996, 2013 Oracle Corporation.  All rights reserved.
http://db-oracle-node1:1158/em/console/aboutApplication
DBCONSOLE already stopped...   Done.
Agent is already stopped...   Done.
Securing dbconsole...   Started.
Please enter repository schema password:  
Securing dbconsole...   Sucessful.

[oracle@db-oracle-node1 ~]$ /u01/app/oracle/product/11.2/db_1/bin/emctl start dbconsole
Oracle Enterprise Manager 11g Database Control Release 11.2.0.4.0 
Copyright (c) 1996, 2013 Oracle Corporation.  All rights reserved.
https://db-oracle-node1:1158/em/console/aboutApplication
Starting Oracle Enterprise Manager 11g Database Control ......... started. 
------------------------------------------------------------------
Logs are generated in directory /u01/app/oracle/product/11.2/db_1/db-oracle-node1_honor/sysman/log 
```</node></node></node></node>

oracle 11g rac配置em dbconsole ORA-12514

相關文章