Oracle 11g RAC OEM配置

超、凢脫俗 2022-06-12 09:18 288阅读 0赞

今天搭建了一套RAC环境，安装完之后，想配置OEM,结果在配置的过程中遇到下面的问题：

ORA-12514: TNS:listener does not currently know of service requested in connect descriptor

环境：rac 11g  
OS:Centos 6.5

1.开始配置OEM

cebpm1:/home/oracle@rac1>emca -config dbcontrol db -repos create -cluster

EMCA 开始于 2017-7-20 11:52:44  
EM Configuration Assistant, 11.2.0.3.0 正式版  
版权所有 (c) 2003, 2011, Oracle。保留所有权利。

输入以下信息:  
数据库的唯一名称: cebpm  
服务名: cebpm  
监听程序 ORACLE\_HOME \[ /u01/app/11.2.0/grid\_1 \]:  
SYS 用户的口令:   
已为数据库 cebpm 配置了 Database Control  
您已选择配置 Database Control, 以便管理数据库 cebpm  
此操作将移去现有配置和默认设置, 并重新执行配置  
是否继续? \[是(Y)/否(N)\]: y  
DBSNMP 用户的口令:   
SYSMAN 用户的口令:   
集群名称: rac-cluster  
通知的电子邮件地址 (可选):  
通知的发件 (SMTP) 服务器 (可选):  
ASM ORACLE\_HOME \[ /u01/app/11.2.0/grid\_1 \]:  
ASM 端口 \[ 1521 \]:  
ASM 用户名 \[ ASMSNMP \]:  
ASM 用户口令:   
2017-7-20 11:54:47 oracle.sysman.emcp.util.GeneralUtil initSQLEngineRemotely  
警告: Error during db connection : ORA-12514: TNS:listener does not currently know of service requested in connect descriptor

2.查看监听信息  
\+ASM1:/u01/app/11.2.0/grid\_1/network/admin@rac1>ps -ef|grep lsn  
grid       3571      1  0 11:40 ?        00:00:00 /u01/app/11.2.0/grid\_1/bin/tnslsnr LISTENER -inherit  
grid       6818   6248  0 12:12 pts/1    00:00:00 grep lsn

\+ASM1:/u01/app/11.2.0/grid\_1/network/admin@rac1>lsnrctl status listener

LSNRCTL for Linux: Version 11.2.0.4.0 - Production on 20-JUL-2017 12:12:41

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER)))  
STATUS of the LISTENER  
\------------------------  
Alias                     LISTENER  
Version                   TNSLSNR for Linux: Version 11.2.0.4.0 - Production  
Start Date                20-JUL-2017 11:40:01  
Uptime                    0 days 0 hr. 32 min. 40 sec  
Trace Level               off  
Security                  ON: Local OS Authentication  
SNMP                      OFF  
Listener Parameter File   /u01/app/11.2.0/grid\_1/network/admin/listener.ora  
Listener Log File         /u01/app/grid/diag/tnslsnr/rac1/listener/alert/log.xml  
Listening Endpoints Summary...  
  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=LISTENER)))  
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.1.160)(PORT=1521)))  
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.1.200)(PORT=1521)))  
Services Summary...  
Service "+ASM" has 1 instance(s).  
  Instance "+ASM1", status READY, has 1 handler(s) for this service...  
Service "cebpm" has 1 instance(s).  
  Instance "cebpm1", status READY, has 1 handler(s) for this service...  
Service "cebpmXDB" has 1 instance(s).  
  Instance "cebpm1", status READY, has 1 handler(s) for this service...  
The command completed successfully

\+ASM1:/u01/app/11.2.0/grid\_1/network/admin@rac1>sqlplus asmsnmp/oracle@rac-scan:1521/+ASM as sysdba

SQL\*Plus: Release 11.2.0.4.0 Production on Thu Jul 20 12:13:57 2017

ERROR:  
ORA-12514: TNS:listener does not currently know of service requested in connect  
descriptor

\+ASM1:/u01/app/11.2.0/grid\_1/network/admin@rac1>sqlplus asmsnmp/oracle@192.168.1.201:1521/+ASM as sysdba

SQL\*Plus: Release 11.2.0.4.0 Production on Thu Jul 20 12:14:29 2017

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> exit

\+ASM1:/u01/app/11.2.0/grid\_1/network/admin@rac1>cat listener.ora  
LISTENER=(DESCRIPTION=(ADDRESS\_LIST=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER))))  \# line added by Agent  
LISTENER\_SCAN1=(DESCRIPTION=(ADDRESS\_LIST=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER\_SCAN1))))  \# line added by Agent  
ENABLE\_GLOBAL\_DYNAMIC\_ENDPOINT\_LISTENER\_SCAN1=ON  \# line added by Agent  
ENABLE\_GLOBAL\_DYNAMIC\_ENDPOINT\_LISTENER=ON  \# line added by Agent  
\+ASM1:/u01/app/11.2.0/grid\_1/network/admin@rac1>

\+ASM1:/u01/app/11.2.0/grid\_1/network/admin@rac1>cat endpoints\_listener.ora  
LISTENER\_RAC1=(DESCRIPTION=(ADDRESS\_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=rac1-vip)(PORT=1521))(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.1.160)(PORT=1521)(IP=FIRST))))       \# line added by Agent  
\+ASM1:/u01/app/11.2.0/grid\_1/network/admin@rac1>

发现ASM的监听跑在LISTENER上面，没有注册到LISTENER\_SCAN1里面，而OEM使用提LISTENER\_SCAN1监听。

3.手动注册监听，并查看状态

\+ASM1:/u01/app/11.2.0/grid\_1/network/admin@rac1>sqlplus / as sysdba

SQL\*Plus: Release 11.2.0.4.0 Production on Thu Jul 20 12:17:34 2017

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='rac-scan:1521' scope=both sid='\*';

System altered.

SQL> show parameter remote

NAME         TYPE  VALUE  
\------------------------------------ ----------- ------------------------------  
remote\_listener        string  rac-scan:1521  
remote\_login\_passwordfile      string  EXCLUSIVE  
remote\_os\_authent       boolean  FALSE  
remote\_os\_roles        boolean  FALSE  
SQL> alter system register;

System altered.

SQL> exit

\+ASM1:/u01/app/11.2.0/grid\_1/network/admin@rac1>ps -ef |grep lsn  
grid       7139      1  0 12:15 ?        00:00:00 /u01/app/11.2.0/grid\_1/bin/tnslsnr LISTENER -inherit  
grid       7455   7036  0 12:19 pts/3    00:00:00 grep lsn  
\+ASM1:/u01/app/11.2.0/grid\_1/network/admin@rac1>lsnrctl start listener\_scan1

LSNRCTL for Linux: Version 11.2.0.4.0 - Production on 20-JUL-2017 12:19:17

Starting /u01/app/11.2.0/grid\_1/bin/tnslsnr: please wait...

TNSLSNR for Linux: Version 11.2.0.4.0 - Production  
System parameter file is /u01/app/11.2.0/grid\_1/network/admin/listener.ora  
Log messages written to /u01/app/grid/diag/tnslsnr/rac1/listener\_scan1/alert/log.xml  
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=LISTENER\_SCAN1)))

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                20-JUL-2017 12:19:19  
Uptime                    0 days 0 hr. 0 min. 0 sec  
Trace Level               off  
Security                  ON: Local OS Authentication  
SNMP                      OFF  
Listener Parameter File   /u01/app/11.2.0/grid\_1/network/admin/listener.ora  
Listener Log File         /u01/app/grid/diag/tnslsnr/rac1/listener\_scan1/alert/log.xml  
Listening Endpoints Summary...  
  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=LISTENER\_SCAN1)))  
The listener supports no services  
The command completed successfully

\+ASM1:/u01/app/11.2.0/grid\_1/network/admin@rac1>ps -ef |grep lsn  
grid       7139      1  0 12:15 ?        00:00:00 /u01/app/11.2.0/grid\_1/bin/tnslsnr LISTENER -inherit  
grid       7461      1  0 12:19 ?        00:00:00 /u01/app/11.2.0/grid\_1/bin/tnslsnr listener\_scan1 -inherit  
grid       7500   7036  0 12:19 pts/3    00:00:00 grep lsn

4.再次配置OEM  
cebpm1:/home/oracle@rac1>emca -config dbcontrol db -repos recreate -cluster

输入以下信息:  
数据库的唯一名称: cebpm  
服务名: cebpm  
监听程序 ORACLE\_HOME \[ /u01/app/11.2.0/grid\_1 \]:  
SYS 用户的口令:   
已为数据库 cebpm 配置了 Database Control  
您已选择配置 Database Control, 以便管理数据库 cebpm  
此操作将移去现有配置和默认设置, 并重新执行配置  
\----------------------------------------------------------------------  
警告: 当删除资料档案库时, 数据库将进入静默模式。  
\----------------------------------------------------------------------  
是否继续? \[是(Y)/否(N)\]: y  
DBSNMP 用户的口令:   
SYSMAN 用户的口令:   
集群名称: rac-cluster  
通知的电子邮件地址 (可选):  
通知的发件 (SMTP) 服务器 (可选):  
ASM ORACLE\_HOME \[ /u01/app/11.2.0/grid\_1 \]:  
ASM 端口 \[ 1521 \]:  
ASM 用户名 \[ ASMSNMP \]:  
ASM 用户口令:   
\-----------------------------------------------------------------

已指定以下设置

数据库 ORACLE\_HOME ................ /u01/app/oracle/product/11.2.0/db\_1

数据库实例主机名 ................ 监听程序 ORACLE\_HOME ................ /u01/app/11.2.0/grid\_1  
监听程序端口号 ................ 1521  
集群名称 ................ rac-cluster  
数据库的唯一名称 ................ cebpm  
通知的电子邮件地址 ...............  
通知的发件 (SMTP) 服务器 ...............  
ASM ORACLE\_HOME ................ /u01/app/11.2.0/grid\_1  
ASM 端口 ................ 1521  
ASM 用户角色 ................ SYSDBA  
ASM 用户名 ................ ASMSNMP

\-----------------------------------------------------------------  
\----------------------------------------------------------------------  
警告: 当删除资料档案库时, 数据库将进入静默模式。  
\----------------------------------------------------------------------  
是否继续? \[是(Y)/否(N)\]: y  
2017-7-20 12:31:48 oracle.sysman.emcp.EMConfig perform  
信息: 正在将此操作记录到 /u01/app/oracle/cfgtoollogs/emca/cebpm/emca\_2017\_07\_20\_12\_31\_14.log。  
2017-7-20 12:31:51 oracle.sysman.emcp.util.PortManager isPortInUse  
警告: 指定的端口 5540 已在使用。  
2017-7-20 12:31:51 oracle.sysman.emcp.util.PortManager isPortInUse  
警告: 指定的端口 5520 已在使用。  
2017-7-20 12:31:51 oracle.sysman.emcp.util.PortManager isPortInUse  
警告: 指定的端口 1158 已在使用。  
2017-7-20 12:31:51 oracle.sysman.emcp.util.DBControlUtil stopOMS  
信息: 正在停止 Database Control (此操作可能需要一段时间)...  
2017-7-20 12:32:01 oracle.sysman.emcp.EMReposConfig invoke  
信息: 正在删除 EM 资料档案库 (此操作可能需要一段时间)...  
2017-7-20 12:43:09 oracle.sysman.emcp.EMReposConfig invoke  
信息: 已成功删除资料档案库  
2017-7-20 12:43:12 oracle.sysman.emcp.EMReposConfig createRepository  
信息: 正在创建 EM 资料档案库 (此操作可能需要一段时间)...  
2017-7-20 12:57:17 oracle.sysman.emcp.EMReposConfig invoke  
信息: 已成功创建资料档案库  
2017-7-20 12:57:42 oracle.sysman.emcp.EMReposConfig uploadConfigDataToRepository  
信息: 正在将配置数据上载到 EM 资料档案库 (此操作可能需要一段时间)...  
2017-7-20 12:59:09 oracle.sysman.emcp.EMReposConfig invoke  
信息: 已成功上载配置数据  
2017-7-20 12:59:16 oracle.sysman.emcp.EMDBCConfig instantiateOC4JConfigFiles  
信息: 正在将 /u01/app/oracle/product/11.2.0/db\_1/oc4j/j2ee/OC4J\_DBConsole\_rac1\_cebpm 传播到远程节点...  
2017-7-20 12:59:17 oracle.sysman.emcp.EMDBCConfig instantiateOC4JConfigFiles  
信息: 正在将 /u01/app/oracle/product/11.2.0/db\_1/oc4j/j2ee/OC4J\_DBConsole\_rac2\_cebpm 传播到远程节点...  
2017-7-20 12:59:33 oracle.sysman.emcp.EMAgentConfig deployStateDirs  
信息: 正在将 /u01/app/oracle/product/11.2.0/db\_1/rac1\_cebpm 传播到远程节点...  
2017-7-20 12:59:35 oracle.sysman.emcp.EMAgentConfig deployStateDirs  
信息: 正在将 /u01/app/oracle/product/11.2.0/db\_1/rac2\_cebpm 传播到远程节点...  
2017-7-20 12:59:37 oracle.sysman.emcp.util.DBControlUtil secureDBConsole  
信息: 正在保护 Database Control (此操作可能需要一段时间)...  
2017-7-20 13:00:13 oracle.sysman.emcp.util.DBControlUtil startOMS  
信息: 正在启动 Database Control (此操作可能需要一段时间)...  
2017-7-20 13:14:24 oracle.sysman.emcp.EMDBPostConfig performConfiguration  
信息: 已成功启动 Database Control  
2017-7-20 13:14:31 oracle.sysman.emcp.EMDBPostConfig performConfiguration  
信息: >>>>>>>>>>> Database Control URL 为 https://rac1:1158/em <<<<<<<<<<<  
2017-7-20 13:19:30 oracle.sysman.emcp.util.PlatformInterface executeCommand  
警告: 执行 /u01/app/oracle/product/11.2.0/db\_1/bin/emctl config emkey -remove\_from\_repos  时出错  
2017-7-20 13:19:30 oracle.sysman.emcp.util.DBControlUtil secureEmkey  
信息: 无法从管理资料档案库中删除 EM 密钥。  
2017-7-20 13:20:29 oracle.sysman.emcp.EMDBPostConfig showClusterDBCAgentMessage  
信息:  
\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*  当前配置 \*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*  
 INSTANCE            NODE           DBCONTROL\_UPLOAD\_HOST  
\----------        ----------        ---------------------

cebpm             rac1             rac1  
cebpm             rac2             rac1

已成功完成 Enterprise Manager 的配置  
EMCA 结束于 2017-7-20 13:20:33

5.查看运行状态。

cebpm1:/home/oracle@rac1>emca -displayConfig dbcontrol -cluster

输入以下信息:  
数据库的唯一名称: cebpm  
服务名: cebpm  
是否继续? \[是(Y)/否(N)\]: y  
2017-7-20 16:44:28 oracle.sysman.emcp.EMConfig perform  
信息: 正在将此操作记录到 /u01/app/oracle/cfgtoollogs/emca/cebpm/emca\_2017\_07\_20\_16\_44\_14.log。  
2017-7-20 16:44:57 oracle.sysman.emcp.EMDBPostConfig showClusterDBCAgentMessage  
信息:  
\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*  当前配置 \*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*  
 INSTANCE            NODE           DBCONTROL\_UPLOAD\_HOST  
\----------        ----------        ---------------------

cebpm             rac1             rac1  
cebpm             rac2             rac1

已成功完成 Enterprise Manager 的配置  
EMCA 结束于 2017-7-20 16:44:57