I recently studied Oracle10G. Let's start with the installation. During the installation, the default port 1521 is occupied by other programs. After oracle is installed, the port is changed to 1522.
I recently studied Oracle 10G. Let's start with the installation. During the installation, since the default port 1521 has been occupied by other programs, after oracle is installed, the port is changed to 1522.
I recently studied Oracle 10G. Let's start with the installation. During the installation, the default port 1521 is occupied by other programs. After installing oracle, the port is changed to 1522.
1. So I changed the port to 1521 again. At that time, I could restart it, and the port also changed from 1522 to 1521. However, it didn't take long before the nagios Monitoring Alarm showed that port 1521 was disabled ~~~~ (>_< )~~~~ .
An error is reported when oracle listening is started. Finally, I found an article on the Internet, but I didn't write down the source at the time. Now I am in trouble looking for it. The following is my solution:
The reason for the failure is that we modified the listener. ora and other files. Listener. ora
The content of the original file is as follows:
/Home/oracle/10.2.0/db_1/network/admin/listener. ora
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME =/home/oracle/product/10.2.0/db_1)
(PROGRAM = extproc)
)
)
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC) (KEY = EXTPROC2 ))
(ADDRESS = (PROTOCOL = TCP) (HOST = localhost. localdomain) (PORT =
1521 ))
)
2. After correct modification, it is like this: [This is a modified configuration that enables oracle listening]
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(ORACLE_HOME =/home/oracle/product/10.2.0/db_1)
(SID_NAME = orcl)
)
)
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC) (KEY = EXTPROC1 ))
(ADDRESS = (PROTOCOL = TCP) (HOST = localhost. localdomain) (PORT =
1521 ))
)
)
For more information about Oracle, see the Oracle topic page? Tid = 12