Oracle Database Discussions

Hi,

I have two Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 (two hosts) OS: Windows XP Profesional.

Server:
192.168.1.102
Client:
192.168.1.100

Trying on the client side:

client> tnsping 192.168.1.102:1521
client>"Uzyto adaptera EZCONNECT w celu rozstrzygniecia tego aliasu
Proba skontaktowanie się z (DESCRPITION=(CONNECT_DATA=SERVICE_NAME=))(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.1.102)(PORT=1521)))
TNS-12541: TNS: brak nasluchu"

Server>lsnrctl status

LSNRCTL for 32-bit Windows: Version 11.2.0.1.0 - Production on 30-LIP-2010 15:20
:30

Copyright (c) 1991, 2010, Oracle. All rights reserved.

ú╣czenie z (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521)))
STAN NASúUCHU
------------------------
Alias LISTENER
Wersja TNSLSNR for 32-bit Windows: Version 11.2.0.1.0 - Produc
tion
Data rozpoczŕcia 30-LIP-2010 13:55:26
Czas dzia│ania 0 dni 1 h 25 min. 6 s
Poziom ťladu off
Zabezpieczenie ON: Local OS Authentication
SNMP OFF
Plik parametrˇw nas│uchu D:\app\Marta\product\11.2.0\dbhome_1\network\admin\li
stener.ora
Plik dziennika nas│uchu d:\app\marta\diag\tnslsnr\marta-pc\listener\alert\log.xm
l
Nas│uch punktˇw ko˝cowych - podsumowanie...
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC1521ipc)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=1521)))
Podsumowanie us│ug...
Us│uga "CLRExtProc" ma liczbŕ instancji rˇwn╣ 1.
Instancja "CLRExtProc", stan UNKNOWN, ma dla tej us│ugi 1 procedur(-ŕ, -y) obs
│ugi...
Us│uga "centraldb" ma liczbŕ instancji rˇwn╣ 1.
Instancja "centraldb", stan READY, ma dla tej us│ugi 1 procedur(-ŕ, -y) obs│ug
i...
Us│uga "centraldbXDB" ma liczbŕ instancji rˇwn╣ 1.
Instancja "centraldb", stan READY, ma dla tej us│ugi 1 procedur(-ŕ, -y) obs│ug
i...
Polecenie zako˝czone powodzeniem

Server Listener.ora:

# listener.ora Network Configuration File: D:\app\Marta\product\11.2.0\dbhome_1\network\admin\listener.ora
# Generated by Oracle configuration tools.

SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = CLRExtProc)
(ORACLE_HOME = D:\app\Marta\product\11.2.0\dbhome_1)
(PROGRAM = extproc)
(ENVS = "EXTPROC_DLLS=ONLY:D:\app\Marta\product\11.2.0\dbhome_1\bin\oraclr11.dll")
)
)

LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
)
)

ADR_BASE_LISTENER = D:\app\Marta

Do you have any ideas where he may be a problem( whay i get this error - tns-12541: no listener) and how can I solve it?

P.S. Sorry for the Polish word;)

Edited by: user13115204 on 2010-07-30 06:26