| listener running, but unable to listen client [message #222512] |
Mon, 05 March 2007 04:38  |
aboodlardy
Messages: 80
Registered: November 2006
Location: India
|
Member |
|
|
Hi
I have install oracle 10gR2 on linux machine and oracle 9i on windows machine and connected both machines(verified using ping).
I created a database on linux machine using dbca, and i dont have any database on windows machine i just installed the software. I configure listener.ora on linux using default file just made the changes to sid and oracle_home.
I started the listener.
On window machine using netca i created netservice name(all information of linux machine given correctly) but when i test this connection using netca i am getting following error
ora:012560:tns protocol adapter error.
plz help
any suggestions.(sorry , posted twice but need ur help)
[Updated on: Mon, 05 March 2007 04:56] Report message to a moderator |
|
|
|
|
|
| Re: listener running, but unable to listen client [message #222605 is a reply to message #222541] |
Mon, 05 March 2007 11:03  |
aboodlardy
Messages: 80
Registered: November 2006
Location: India
|
Member |
|
|
Hi
Yes I have started the database. It is running. sitll i am getting the same error.
But when I tnsping from client, i am getting following output.
C:\DOCUME~1\SULEMAN>TNSPING 192.168.10.5(server i.e. linux)
TNS Ping Utility for 32-bit Windows: Version 9.0.1.1.1 - Production on 05-MAR-20
07 23:25:28
Copyright (c) 1997 Oracle Corporation. All rights reserved.
Used parameter files:
Used HOSTNAME adapter to resolve the alias
Attempting to contact (DESCRIPTION=(CONNECT_DATA=(SID=*)(SERVICE_NAME=192.168.10
.5))(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.10.5)(PORT=1521)))
TNS-12560: TNS:protocol adapter error
C:\DOCUME~1\SULEMAN>
[Updated on: Mon, 05 March 2007 12:02] Report message to a moderator |
|
|
|
|
|
|
|
|
|
|
|
| Re: listener running, but unable to listen client [message #222733 is a reply to message #222677] |
Tue, 06 March 2007 04:32 |
aboodlardy
Messages: 80
Registered: November 2006
Location: India
|
Member |
|
|
Sorry Taj,
I posted incomplete command output.
Here it is complete one.
LSNRCTL> status listener
Connecting to (DESCRIPTOR=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1)))
STATUS of the LISTENER
----------------------
Alias listener
Version TNSLSNR for Linux: version 10.2.0.1.0-Production
Start Date 06-mar-2007 09:00:90
Uptime 0 days 0 hr. 0 min 24 sec
Trace Level 0ff
Security on : Local os authentication
SNMP off
Listener parameterfile /opt/app/network/admin/listener.ora
Listener logfile /opt/app/nerwork/log/listener.log
Listening Endpoints Summary..
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=localhost.localdomain)(PORT=1521)))
Services Summary....
Serviece "mydata" has 1 instace(s).
Instance "mydata" , status UNKNOWN, has 1 handler(s) for this service...
The command completed succesfully.
LSNRCTL>
sorry to anacedent too.
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
