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

Solve the problem of oracle reporting to Environment variable ORACLE_UNQNAME not defined

Just reconfigure em, and be sure to set the Oracle_SID environment variable.

1. Modify the DBSNMP password:

To reconfigure DBCONSOLE, you need to enter the DBSNMP password, but any password will display an error and need to be modified in advance.

C:\ Users\ Administrator > sqlplus / nolog

SQL*Plus: Release 11.2.0.1.0 Production on Tuesday October 16 19:24:32 2018

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

Sql > sqlplus / as sysdba

Sql > alter user dbsnmp identified by xxx

2. Delete the users created earlier by DBCONSOLE:

Sql > drop role MGMT_USER

Sql > drop user MGMT_VIEW cascade

Sql > drop user sysman cascade

3. Delete the objects created earlier by DBCONSOLE:

Sql > drop PUBLIC SYNONYM MGMT_TARGET_BLACKOUTS

Sql > drop public synonym SETEMVIEWUSERCONTEXT

Sql > drop public synonym MGMT_AVAILABILITY

Sql > drop public synonym MGMT_CURRENT_AVAILABILITY

Sql > drop public synonym MGMT_SEVERITY_OBJ

4. Recreate the DBCONSOLE:

Sql > $emca-config dbcontrol db-repos recreate

According to the prompt, enter SID first, and then Y to continue

Enter port 1521, enter SYS password, enter DBSNMP password, enter SYSMAN password, enter Y to continue

Wait for the configuration to complete.

Configure Oracle_SID

In the computer-properties-advanced-environment variables

Add an environment variable

Variable name: ORACLE_SID

Variable value: orcl (enter the instance name of the database)

View em status

C:\ Users\ Administrator > emctl status

Stop em

C:\ Users\ Administrator > emctl stop

Start em

C:\ Users\ Administrator > emctl start

Finally, test access to 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.