Oracle installation encountered enterprise manager configuration failure

Time:2021-4-10

When installing oracle on a new application server, when creating a database instance, the enterprise manager configuration failed and the remote connection could not be made.

Operating system: Windows Server 2008 R2 opened the firewall, set 1521 inbound and outbound rules, no other settings.

Oracle version: 11.2.0.4

QQ截图20201229145600

resolvent:

After checking, it is found that it is an Oracle monitoring problem. Restart monitoring after modification.

The modification method is described on the Internet as adding an address to the monitor. However, when I save the added address, I will prompt that 1521 has been monitored and cannot be saved. I simply modify the host IP to the machine name and restart the monitor after modification. The specific steps are as follows:

Enter netmanager from the start menu

imageimage

In monitoring, set the host IP as the host machine name, save and restart the monitoring service.

After the service is restarted, the database instance can be deleted and rebuilt through the database configuration assistant. In the process of reconstruction, if there is no need for special settings such as character set, the default settings can be used all the way.

imageimage

In addition, there are two ways to deal with it. If the above methods are not useful, you can try them

1. Add the address in the monitor, set the host name as the machine name and the port as 1521;

2. The method provided by colleagues can directly modify the listening configuration file( listener.ora , in D: app, administrator, product, 11.2.0, dbhome_ 1, please search according to their respective installation directory).

image

Recommended Today

Review of SQL Sever basic command

catalogue preface Installation of virtual machine Commands and operations Basic command syntax Case sensitive SQL keyword and function name Column and Index Names alias Too long to see? Space Database connection Connection of SSMS Connection of command line Database operation establish delete constraint integrity constraint Common constraints NOT NULL UNIQUE PRIMARY KEY FOREIGN KEY DEFAULT […]