Oracle EM start failure--oracle_unqname not defined

Source: Internet
Author: User

Customer's server can't start em

Error environment variable oracle_unqname not defined. Please set Oracle_unqname to database unique name.


Need to do a better job

TNS, LSN configuration file hostname in the 1,oracle directory

The hostname in 2,linux/etc/hosts.

3,oracle user under. bash_profile or. BASHRC

Whether the hostname can be configured in the same place

The problem with me is that the user has changed hostname, and Oracle's. Bash_profile declares that the HOSTANME and the Oracle database are inconsistent so error, change consistent

source. Bash_profile can use


If you confirm that the hostname and SID instance names are not wrong

Then we recommend that you perform the 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

Create an action

STARTED EMCA at May 10:37:01 AM
EM Configuration Assistant, Version 11.2.0.3.0 Production
Copyright (c) 2003, Oracle. All rights reserved.


Enter the following information:
Database Sid:oracle11
Log4j:warn No Appenders could is found for logger (emsdk.config).
Log4j:warn 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 a existing object---alarm This is the configuration is not clean


Use

$ emca-config Dbcontrol Db-repos recreate

Perform


Follow the steps


Finally, you can use EM


This article is from the "10999243" blog, please be sure to keep this source http://11009243.blog.51cto.com/10999243/1929962

Oracle EM start failed--oracle_unqname not defined

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.