Create multiple listening ports in Oracle10G

Create a listening port (use OracleNetConfigurationAssistant and OracleNetManager to create and run the command to start it. Both methods have been tried ). Recreate

Create a listening port (using Oracle Net Configuration Assistant and Oracle Net Manager to create and start using commands. Both methods have been tried ). Recreate

Create a listening port (using Oracle Net Configuration Assistant and Oracle Net Manager to create and start using commands. Both methods have been tried ). Create a local service name and use tnsping. However, when creating a service name, the following error is prompted during the test:
ORA-12514: TNS: The Listener currently cannot identify the Service requested in the connection Descriptor

Solution:

By default, listener1 is created in the file

E: \ oracle \ product \ 10.2.0 \ db_1 \ NETWORK \ ADMIN \ listener. ora
The content is as follows:
LISTENER1 =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP) (HOST = test) (PORT = 1522 ))
)
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC) (KEY = EXTPROC2 ))
)
)

After testing, you need to manually add some content:

SID_LIST_LISTENER1 =
(SID_LIST =
(SID_DESC =
(GLOBAL_DBNAME = ORCL)
(ORACLE_HOME = E: \ Server \ oracle \ product \ 10.2.0 \ db_1)
(SID_NAME = ORCL)
)
(SID_DESC =
(PROGRAM = extproc)
(SID_NAME = PLSExtProc)
(ORACLE_HOME = E: \ Server \ oracle \ product \ 10.2.0 \ db_1)
)
)

After adding the listener, restart the listener1 listening service and run the test to prompt the user to be denied. After changing the password, the test succeeds immediately. Multiple attempts are successful.