Still you have not given the complete listener.ora file.
I can able to replicate the error this side with a
change in my listener.ora file.
Post your listener.ora file.
Check whether you have anyother listener.ora file the system.
Printable View
Still you have not given the complete listener.ora file.
I can able to replicate the error this side with a
change in my listener.ora file.
Post your listener.ora file.
Check whether you have anyother listener.ora file the system.
have you tried playing it with the domain name?
I have only 1 instance running in this server.
I have only 1 listener file.
[oracle@oracle10g admin]$ cat listener.ora
# listener.ora Network Configuration File: /u01/app/oracle/product/10.1.0/db_1/network/admin/listener.ora
# Generated by Oracle configuration tools.
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = orcl)
(ORACLE_HOME = /u01/app/oracle/product/10.1.0/db_1)
(PROGRAM = extproc)
)
)
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = oracle10g.pdcindscape.com)(PORT = 1521))
)
)
)
Can you ping oracle10g.pdcindscape.com?:D
reydp
Thank u, because u were the one who solved this.
It was not pinging with oracle10g.pdcindscape.com.
It was ping with 192.168.1.35
I checked with sysadmin and then it was found the dns entry to this server was oracle10.pdcindscape.com
The DNS entry for this server was put as oracle10.pdcindscape.com
changed it and now its pinging and also showing the status of listener.
2 full days didnt get a clue of checking for DNS entry.
i did ping 192.168.1.35 and it was pinging.
i should have used ping -a 192.168.1.35 -t command at that moment would have got this .
anyway learnt something.
Thanks to all for posting replies.
thanks once again for ur time
Pinging oracle10g.pdcindscape.com [192.168.1.35] with 32 bytes of data:
Reply from 192.168.1.35: bytes=32 time<1ms TTL=255
Reply from 192.168.1.35: bytes=32 time<1ms TTL=255
Reply from 192.168.1.35: bytes=32 time<1ms TTL=255
Reply from 192.168.1.35: bytes=32 time<1ms TTL=255
We're glad to hear that. Well, that's what this forum is all about.
:):) :)
I have basically the same problem before, that is why your problem looks familiar to me and that is why my first question to you was to tackle with the Domain Name.Quote:
Originally posted by gajananpkini
reydp
Thank u, because u were the one who solved this.
It was not pinging with oracle10g.pdcindscape.com.
It was ping with 192.168.1.35
I checked with sysadmin and then it was found the dns entry to this server was oracle10.pdcindscape.com
The DNS entry for this server was put as oracle10.pdcindscape.com
changed it and now its pinging and also showing the status of listener.
2 full days didnt get a clue of checking for DNS entry.
i did ping 192.168.1.35 and it was pinging.
i should have used ping -a 192.168.1.35 -t command at that moment would have got this .
anyway learnt something.
Thanks to all for posting replies.
thanks once again for ur time
Pinging oracle10g.pdcindscape.com [192.168.1.35] with 32 bytes of data:
Reply from 192.168.1.35: bytes=32 time<1ms TTL=255
Reply from 192.168.1.35: bytes=32 time<1ms TTL=255
Reply from 192.168.1.35: bytes=32 time<1ms TTL=255
Reply from 192.168.1.35: bytes=32 time<1ms TTL=255
Though you only mentioned the DHCP server, you forgot to mention your DB server being part of the DNS Server. When Pando ask you to post the /etc/hosts, and your entry seems to be valid the only clue left was, something had overrides the name resolution of your hostname. And that could be DNS Server, because DNS Server has a high priority than a local host when network resolves hostname.
;)