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

This article mainly shows you "what to do when em startup fails in oracle", which is easy to understand and clear. I hope it can help you solve your doubts. Let the editor lead you to study and learn this article "what to do when em startup fails in oracle".

The customer's server cannot start em

Report an error Environment variable ORACLE_UNQNAME not defined. Please set ORACLE_UNQNAME to database unique name.

The comparison that needs to be done

1 TNS, LSN configuration file hostname under the Oracle directory

2 hostname in Linux / etc/hosts

3 under the user .bash _ profile or .bashrc

Is it consistent where hostname can be configured?

The problem I have is that the user has changed the inconsistency between the hostanme and oracle databases under hostname, oracle. Bash_profile, so the error is reported and the modification is consistent.

Source .bash _ profile can be used

If you confirm that both the hostname and sid instance names are correct

Then it is recommended that you perform an emc rebuild operation.

$sqlplus / as sysdba

SQL > alter user dbsnmp identified by py123456

User altered.

SQL > drop role MGMT_USER

Role dropped.

SQL > drop user MGMT_VIEW cascade

User dropped.

SQL > drop user sysman cascade

User dropped.

SQL > drop user sysman cascade

SQL > drop PUBLIC SYNONYM MGMT_TARGET_BLACKOUTS

Synonym dropped.

SQL > drop public synonym SETEMVIEWUSERCONTEXT

Synonym dropped.

SQL > quit

$emca-config dbcontrol db-repos create

Perform the create operation

STARTED EMCA at May 26, 2017 10:37:01 AM

EM Configuration Assistant, Version 11.2.0.3.0 Production

Copyright (c) 2003, 2011, Oracle. All rights reserved.

Enter the following information:

Database SID: oracle11

Log4j:WARN No appenders could be found for logger (emSDK.config).

Log4j:WARN Please initialize the log4j system properly.

Listener port number:

Listener ORACLE_HOME []:

Password for SYS user:

Password for DBSNMP user:

Password for SYSMAN user:

Email address for notifications (optional):

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

WARNING: ORA-00955: name is already used by an existing object--- alarm if the configuration is not cleared

Use

$emca-config dbcontrol db-repos recreate

Execution

Follow the steps

Finally, you can use em

The above is all the contents of the article "what to do if em starts up failed in oracle". Thank you for reading! I believe we all have a certain understanding, hope to share the content to help you, if you want to learn more knowledge, welcome to follow the industry information channel!

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.