Topic: TNS-12542 address already in use [offset] ORACLE
And again all good afternoon.
I need your council, respected DBA.
Situation following, periodically users cannot to a DB.
Revealed that an error ORA-12542: TNS:address already in use [offset ]
On windows server 2012r2 to be twisted as a matter of fact only one basis of Oracle 11g2. BUT ALSO from it discards users.
(SID_NAME = CLRExtProc)
(ORACLE_HOME = D:\oracle\delo\product\11.2.0\dbhome)
(PROGRAM = extproc)
(ENVS = "EXTPROC_DLLS=ONLY:D:\oracle\delo\product\11.2.0\dbhome\bin\oraclr11.dll")
(ADDRESS = (PROTOCOL = TCP) (HOST = DeloDB-server.papa.com.by) (PORT = 1521))
(ADDRESS = (PROTOCOL = IPC) (KEY = EXTPROC1521))
ADR_BASE_LISTENER = D:\oracle\delo
I ask council.
Because of what this error and as it to correct went.
In advance all many thanks!