Problem solve
Get help with specific problems with your technologies, process and projects.
'ORA 12542: TNS: address already in use' error
How do I resolve this error please:
'ORA 12542: TNS: address already in use'. OraOLEDB error 80004005
The Listener configuration file, LISTENER.ORA contains an address entry that may look something like this:
(ADDRESS = (PROTOCOL = TCP)
(HOST = dbserver.mycompany.com)
(PORT = 1526)
)
That combination of address configuration information is already in use (most likely the port is already being used by some software). Change your configuration to be unique for this listener and then you will be able to start it.
Dig Deeper on Oracle database design and architecture
-
![]()
How to connect to a pluggable database in Oracle Multitenant
By: Brian Peasland
-
![]()
Battle through the recurring Oracle TNS mistakes admins make
By: Brian Peasland
-
![]()
Why won't TNS listener connect with Oracle Database 11g 32-bit?
By: Brian Peasland
-
![]()
Why am I receiving the ORA-12535 error when using a remote database?
