Shulou(Shulou.com)05/31 Report--

This article mainly introduces how Oracle 11gR2 RAC Database uses emca to configure cluster dbconsole, which has a certain reference value. Interested friends can refer to it. I hope you can learn a lot after reading this article.

1. Database environment.

Oracle Exadata Machine x4-2

Oracle RAC Database 11.2.0.4.6 for Linux x86_64bit

[root@dm01db01 ~] # uname-r

2.6.39-400.126.1.el5uek

two。 Create an EM using EMCA.

[root@dm01db01 ~] # su-oracle

[oracle@dm01db01 ~] $emca-config dbcontrol db-repos create-cluster

.

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

.

Received an error from ORA-12514.

The log output from the emca tool is stored in the $GRID_BASE/cfgtoollogs/emca directory.

View / u01/app/grid/cfgtoollogs/emca/emca_2014_06_18_10_26_50.log log:

.

Jun 18, 2014 10:27:17 AM oracle.sysman.emcp.util.GeneralUtil initSQLEngineRemotely

CONFIG: SQLEngine connecting with Service Name: + ASM, oracleHome: / u01/app/11.2.0.4/grid, and user: ASMSNMP scan name: dm01-scan scan port: 1521

Jun 18, 2014 10:27:17 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

Jun 18, 2014 10:27:17 AM oracle.sysman.emcp.util.GeneralUtil initSQLEngineRemotely

CONFIG: Waiting for 5 second before reconnection

Jun 18, 2014 10:27:22 AM oracle.sysman.emcp.util.GeneralUtil initSQLEngineRemotely

CONFIG: SQLEngine connecting with Service Name: + ASM, oracleHome: / u01/app/11.2.0.4/grid, and user: ASMSNMP host: dm01db02 port: 1521

Jun 18, 2014 10:27:22 AM oracle.sysman.emcp.util.GeneralUtil initSQLEngineRemotely

CONFIG: SQLEngine created successfully and connected

Jun 18, 2014 10:27:22 AM oracle.sysman.emcp.ParamsManager setParam

CONFIG: Setting param: CONFIRMATION ANSWER value:

Jun 18, 2014 10:27:28 AM oracle.sysman.emcp.ParamsManager setParam

CONFIG: Setting param: CONFIRMATION ANSWER value: no

As can be seen from the log on the last side, the reason for reporting the ORA-12514 error is that the ASM instance cannot be connected through SCAN LISTENER, indicating that the ASM instance is not dynamically registered with SCAN LISTENER.

The 3.ASM instance is dynamically registered with SCAN LISTENER.

[root@dm01db01 ~] # su-grid

[grid@dm01db01 ~] $sqlplus / as sysasm

SQL*Plus: Release 11.2.0.4.0 Production on Wed Jun 18 23:18:09 2014

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

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 spfile

NAME TYPE

VALUE

-

Spfile string

+ DBFS_DG/cluster-clu1/asmparam

Eterfile/registry.253.84996746

five

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='dm01-scan:1521'

System altered.

SQL > alter system register

System altered.

SQL > show parameter remote_listener

NAME TYPE

VALUE

-

Remote_listener string

Dm01-scan:1521

SQL > exit

Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.4.0-64bit Production

With the Real Application Clusters and Automatic Storage Management options

[grid@dm01db01 ~] $lsnrctl status listener_scan1

LSNRCTL for Linux: Version 11.2.0.4.0-Production on 18-JUN-2014 23:19:09

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 17-JUN-2014 12:25:14

Uptime 1 days 10 hr. 53 min. 55 sec

Trace Level off

Security ON: Local OS Authentication

SNMP OFF

Listener Parameter File / u01/app/11.2.0.4/grid/network/admin/listener.ora

Listener Log File / u01/app/11.2.0.4/grid/log/diag/tnslsnr/dm01db01/listener_scan1/alert/log.xml

Listening Endpoints Summary...

(DESCRIPTION= (ADDRESS= (PROTOCOL=ipc) (KEY=LISTENER_SCAN1)

(DESCRIPTION= (ADDRESS= (PROTOCOL=tcp) (HOST=10.0.3.16) (PORT=1521))

Services Summary...

Service "+ ASM" has 2 instance (s).

Instance "+ ASM1", status READY, has 1 handler (s) for this service...

Instance "+ ASM2", status READY, has 1 handler (s) for this service...

Service "tequdb" has 2 instance (s).

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

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

The command completed successfully

4. Use EMCA to create the EM again.

[root@dm01db01 ~] # su-oracle

[oracle@dm01db01 ~] $emca-config dbcontrol db-repos create-cluster

STARTED EMCA at Jun 18, 2014 11:19:44 PM

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: tequdb

Service name: tequdb

Listener port number: 1521

Listener ORACLE_HOME [/ u01/app/11.2.0.4/grid]:

Password for SYS user:

Password for DBSNMP user:

Password for SYSMAN user:

Cluster name: cluster-clu1

Email address for notifications (optional):

Outgoing Mail (SMTP) server for notifications (optional):

ASM ORACLE_HOME [/ u01/app/11.2.0.4/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.0.4/dbhome_1

Database instance hostname. Listener ORACLE_HOME. / u01/app/11.2.0.4/grid

Listener port number. 1521

Cluster name. Cluster-clu1

Database unique name. Tequdb

Email address for notifications.

Outgoing Mail (SMTP) server for notifications.

ASM ORACLE_HOME. / u01/app/11.2.0.4/grid

ASM port. 1521

ASM user role. SYSDBA

ASM username. ASMSNMP

-

Do you wish to continue? [yes (Y) / no (N)]: y

Jun 18, 2014 11:20:26 PM oracle.sysman.emcp.EMConfig perform

INFO: This operation is being logged at / u01/app/oracle/cfgtoollogs/emca/tequdb/emca_2014_06_18_23_19_44.log.

Jun 18, 2014 11:20:40 PM oracle.sysman.emcp.EMReposConfig createRepository

INFO: Creating the EM repository (this may take a while)...

Jun 18, 2014 11:20:40 PM oracle.sysman.emcp.EMReposConfig createRepository

WARNING: ORA-28003: password verification for the specified password failed

ORA-20006: Password too simple

Jun 18, 2014 11:20:40 PM oracle.sysman.emcp.EMReposConfig invoke

SEVERE: Error creating the repository

Jun 18, 2014 11:20:40 PM oracle.sysman.emcp.EMReposConfig invoke

INFO: Refer to the log file at / u01/app/oracle/cfgtoollogs/emca/tequdb/emca_repos_create_.log for more details.

Jun 18, 2014 11:20:40 PM oracle.sysman.emcp.EMConfig perform

SEVERE: Error creating the repository

Refer to the log file at / u01/app/oracle/cfgtoollogs/emca/tequdb/emca_2014_06_18_23_19_44.log for more details.

Could not complete the configuration. Refer to the log file at / u01/app/oracle/cfgtoollogs/emca/tequdb/emca_2014_06_18_23_19_44.log for more details.

For this alarm, please refer to the following MOS article:

EMCA: RepManager Fails With Password Verification Error ORA-28003 (document ID 779098.1)

Modification time: 2013-10-23 Type: PROBLEM

In this Document

Symptoms

Cause

Solution

ReferencesThis document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.APPLIES TO:

Enterprise Manager Base Platform-Version 10.2.0.1 to 10.2.0.5 [Release 10.2]

Information in this document applies to any platform.

Checked for relevance on 22-Oct-2013

SYMPTOMS

While using EMCA to create DB Console repository, this fails with:

CONFIG: ORA-28003: password verification for the specified password failed

ORA-20003: Password should contain at least one\

CAUSE

This is treated in internal BUG 4195090.

SOLUTION

A) Disable the Password verification

B) Create the Repository

C) Enable the password verification.

Note: For disabling the password verification function, Note 114930.1 can be used. For example:

SQL > alter profile default limit password_verify_function null

5. Disable the password authentication function.

[root@dm01db01 ~] # su-oracle

[oracle@dm01db01 ~] $sql

SQL*Plus: Release 11.2.0.4.0 Production on Wed Jun 18 23:29:28 2014

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

Connected to:

Oracle Database 11g Enterprise Edition Release 11.2.0.4.0-64bit Production

With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP

Data Mining and Real Application Testing options

SQL > set linesize 200

SQL > set pagesize 200

SQL > select * from dba_profiles where profile='DEFAULT'

PROFILE RESOURCE_NAME RESOURCE LIMIT

DEFAULT COMPOSITE_LIMIT KERNEL UNLIMITED

DEFAULT SESSIONS_PER_USER KERNEL UNLIMITED

DEFAULT CPU_PER_SESSION KERNEL UNLIMITED

DEFAULT CPU_PER_CALL KERNEL UNLIMITED

DEFAULT LOGICAL_READS_PER_SESSION KERNEL UNLIMITED

DEFAULT LOGICAL_READS_PER_CALL KERNEL UNLIMITED

DEFAULT IDLE_TIME KERNEL UNLIMITED

DEFAULT CONNECT_TIME KERNEL UNLIMITED

DEFAULT PRIVATE_SGA KERNEL UNLIMITED

DEFAULT FAILED_LOGIN_ATTEMPTS PASSWORD 10

DEFAULT PASSWORD_LIFE_TIME PASSWORD UNLIMITED

DEFAULT PASSWORD_REUSE_TIME PASSWORD UNLIMITED

DEFAULT PASSWORD_REUSE_MAX PASSWORD UNLIMITED

DEFAULT PASSWORD_VERIFY_FUNCTION PASSWORD VERIFY_FUNCTION_11G

DEFAULT PASSWORD_LOCK_TIME PASSWORD 1

DEFAULT PASSWORD_GRACE_TIME PASSWORD 7

16 rows selected.

SQL > alter profile default limit password_verify_function null

Profile altered.

6. Create an EM using EMCA.

[oracle@dm01db01 ~] $emca-config dbcontrol db-repos create-cluster

STARTED EMCA at Jun 18, 2014 11:30:26 PM

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: tequdb

Service name: tequdb

Listener port number: 1521

Listener ORACLE_HOME [/ u01/app/11.2.0.4/grid]:

Password for SYS user:

Password for DBSNMP user:

Password for SYSMAN user:

Cluster name: cluster-clu1

Email address for notifications (optional):

Outgoing Mail (SMTP) server for notifications (optional):

ASM ORACLE_HOME [/ u01/app/11.2.0.4/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.0.4/dbhome_1

Database instance hostname. Listener ORACLE_HOME. / u01/app/11.2.0.4/grid

Listener port number. 1521

Cluster name. Cluster-clu1

Database unique name. Tequdb

Email address for notifications.

Outgoing Mail (SMTP) server for notifications.

ASM ORACLE_HOME. / u01/app/11.2.0.4/grid

ASM port. 1521

ASM user role. SYSDBA

ASM username. ASMSNMP

-

Do you wish to continue? [yes (Y) / no (N)]: y

Jun 18, 2014 11:31:01 PM oracle.sysman.emcp.EMConfig perform

INFO: This operation is being logged at / u01/app/oracle/cfgtoollogs/emca/tequdb/emca_2014_06_18_23_30_26.log.

Jun 18, 2014 11:31:14 PM oracle.sysman.emcp.EMReposConfig createRepository

INFO: Creating the EM repository (this may take a while)...

Jun 18, 2014 11:33:54 PM oracle.sysman.emcp.EMReposConfig invoke

INFO: Repository successfully created

Jun 18, 2014 11:34:03 PM oracle.sysman.emcp.EMReposConfig uploadConfigDataToRepository

INFO: Uploading configuration data to EM repository (this may take a while)...

Jun 18, 2014 11:34:50 PM oracle.sysman.emcp.EMReposConfig invoke

INFO: Uploaded configuration data successfully

Jun 18, 2014 11:34:50 PM oracle.sysman.emcp.EMDBCConfig instantiateOC4JConfigFiles

INFO: Propagating / u01/app/oracle/product/11.2.0.4/dbhome_1/oc4j/j2ee/OC4J_DBConsole_dm01db01_tequdb to remote nodes...

Jun 18, 2014 11:34:52 PM oracle.sysman.emcp.EMDBCConfig instantiateOC4JConfigFiles

INFO: Propagating / u01/app/oracle/product/11.2.0.4/dbhome_1/oc4j/j2ee/OC4J_DBConsole_dm01db02_tequdb to remote nodes...

Jun 18, 2014 11:34:54 PM oracle.sysman.emcp.EMAgentConfig deployStateDirs

INFO: Propagating / u01/app/oracle/product/11.2.0.4/dbhome_1/dm01db01_tequdb to remote nodes...

Jun 18, 2014 11:34:55 PM oracle.sysman.emcp.EMAgentConfig deployStateDirs

INFO: Propagating / u01/app/oracle/product/11.2.0.4/dbhome_1/dm01db02_tequdb to remote nodes...

Jun 18, 2014 11:34:58 PM oracle.sysman.emcp.util.DBControlUtil secureDBConsole

INFO: Securing Database Control (this may take a while)...

Jun 18, 2014 11:35:39 PM oracle.sysman.emcp.util.DBControlUtil startOMS

INFO: Starting Database Control (this may take a while)...

Jun 18, 2014 11:36:03 PM oracle.sysman.emcp.EMDBPostConfig performConfiguration

INFO: Database Control started successfully

Jun 18, 2014 11:36:03 PM oracle.sysman.emcp.EMDBPostConfig performConfiguration

INFO: > The Database Control URL is https://dm01db01.tequ.com:1158/em

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.