1

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.
listener.ora:
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(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")
)
)
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(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!

2

Re: TNS-12542 address already in use [offset] ORACLE

http://www.sql.ru/forum/759641/tns-1254 … e?hl=12542

3

Re: TNS-12542 address already in use [offset] ORACLE

Viewer;
I read it. Only, alas, it became more clear not.
I am am confused simply with various protocols in  address

4

Re: TNS-12542 address already in use [offset] ORACLE

tosha_louie;
Stop. Whether instead of in that an error that are simultaneously fulfilled set of parallel requests.
Simply tell yes or I should dig further.
In advance thanks

5

Re: TNS-12542 address already in use [offset] ORACLE

tosha_louie wrote:

tosha_louie;
Whether instead of in that an error that are simultaneously fulfilled set of parallel requests.

No. A cause of error somewhere in other.
Antivirus? That at basis in Alert.log? What, generally, the DBMS version?