Network Security Internet Technology Development Database Servers Mobile Phone Android Software Apple Software Computer Software News IT Information

In addition to Weibo, there is also WeChat

Please pay attention

WeChat public account

Shulou

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

2025-02-27 Update From: SLTechnology News&Howtos shulou NAV: SLTechnology News&Howtos > Database >

Share

Shulou(Shulou.com)06/01 Report--

Today, I want to start OEM under the installed test environment, but an error is reported when I start it as follows:

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

ORACLE_UNQNAME needs to be set according to the error prompt, so the su-oracle editing configuration file is as follows:

Soure .bash _ profile validates the file and reports another error when OEM is restarted

OC4J Configuration issue. / home/db/oracle/product/11.2.0/dbhome_1/oc4j/j2ee/OC4J_DBConsole_icsdb02_icsdb not found.

This is a wave of injustice, one wave after another, checking the process of examples and so on. Reading the wrong newspaper means that something has not been found.

Generally speaking, this is because the monitoring is not started, and if there is no problem with checking the monitoring, it is very likely that the configuration of the em database is incorrect or the dbcotrol is not properly configured and needs to be reconfigured.

Resolve:

[oracle@icsdb02 ~] $emca-repos recreate

EMCA began on 2017-3-2 10:29:45

EM Configuration Assistant, 11.2.0.3.0 official version

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

Enter the following information:

Database SID: icsdb

Listener port number: 1521

Password of the SYS user:

Password of the SYSMAN user:

Warning: when you delete the data archive, the database will enter silent mode.

Do you want to continue? [yes / No]: y

2017-3-2 10:33:42 oracle.sysman.emcp.EMConfig perform

Information: this operation is being logged to / home/db/oracle/cfgtoollogs/emca/icsdb/emca_2017_03_02_10_29_45.log.

2017-3-2 10:33:42 oracle.sysman.emcp.EMReposConfig invoke

Info: deleting EM data archive (this operation may take some time).

2017-3-2 10:35:15 oracle.sysman.emcp.EMReposConfig invoke

Information: data archive deleted successfully

2017-3-2 10:35:15 oracle.sysman.emcp.EMReposConfig createRepository

Information: EM data archive is being created (this operation may take some time).

2017-3-2 10:40:06 oracle.sysman.emcp.EMReposConfig invoke

Information: data archive created successfully

Successfully completed the configuration of Enterprise Manager

EMCA ends on 2017-3-2 10:40:06

Emca common commands are attached:

Create an EM database

Emca-repos create

Rebuild an EM database

Emca-repos recreate

Delete an EM database

Emca-repos drop

Configure the Database Control of the database

Emca-config dbcontrol db

Delete the Database Control configuration of the database

Emca-deconfig dbcontrol db

Reconfigure the port of db control. The default port is 1158

Emca-reconfig ports

Emca-reconfig ports-dbcontrol_http_port 1888

Emca-reconfig ports-agent_port 3940

After setting the ORACLE_SID environment variable, start the EM console service

Emctl start dbconsole

After setting the ORACLE_SID environment variable, stop the EM console service

Emctl stop dbconsole

After setting the ORACLE_SID environment variable, check the status of the EM console service

Steps to configure dbconsole

Emca-repos create

Emca-config dbcontrol db

Emctl start dbconsole

Steps to reconfigure dbconsole

Emca-repos drop

Emca-repos create

Emca-config dbcontrol db

Emctl start dbconsole

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.

Views: 0

*The comments in the above article only represent the author's personal views and do not represent the views and positions of this website. If you have more insights, please feel free to contribute and share.

Share To

Database

Wechat

© 2024 shulou.com SLNews company. All rights reserved.

12
Report