Listerner Problems

[luggage316]

I am currently having various listerner issues with all the PC's trying to connect to my Oracle server. Each one claims that there is no Listerner. However if I create a Listerner on some of the host PC's they can suddenly see the listerner on the server. However on other Host PC's even with the Listerner setup I can sometimes connect to the Oracle Server and other times the Listerner again seems to be invisable. Has any one ever seen this problem before or could maybe give me an idea as to what may be causing this.

Thanks in advance

Jai

[jovery]

Is the tnsnames.ora and sqlnet.ora file correct on the client PC's also what is the exact error you are receiving.

Regards

[luggage316]

The Exact message is as follows:

ORA - 12541 TNS: no listerner

The wierd thing on these PC's is that you can connect once to a database with no problems however if you try to create a new connection or disconnect and reconnect you get the above error. However if you wait about 10 minutes you will be able to connect again but as with the previous attempts it is a one time only deal.

[jovery]

If you try and tnsping from the client do you get the same flaky responses?

Are you sure that the listener process is stable on your server and are there any errors being reported in the listerner.log file?

Regards

[luggage316]

I have found this error message in the Log file which seems reletive:

TNS - 12502 TNS : Listerner received no connect_data from client.

[pipo]

can you post your listener.ora file and the matching tnsnames.ora entry ?

[luggage316]

Below are both files from our server.





# TNSNAMES.ORA Network Configuration File: D:\Oracle\Ora81\NETWORK\ADMIN\tnsnames.ora
# Generated by Oracle configuration tools.

PCMS.FAREHAM.SLB.COM =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = ORA_FH_UK)(PORT = 1521))
)
(CONNECT_DATA =
(SID = PCMS)
)
)






# LISTENER.ORA Network Configuration File: D:\Oracle\Ora81\NETWORK\ADMIN\listener.ora
# Generated by Oracle configuration tools.

LISTENER1 =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 199.10.1.1)(PORT = 1521))
)
)

SID_LIST_LISTENER1 =
(SID_LIST =
(SID_DESC =
(GLOBAL_DBNAME = pcms.fareham.slb.com)
(ORACLE_HOME = D:\Oracle\Ora81)
(SID_NAME = pcms)
)
)

LISTENER2 =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 134.32.106.86)(PORT = 1526))
)
)

SID_LIST_LISTENER2 =
(SID_LIST =
(SID_DESC =
(GLOBAL_DBNAME = pcms.fareham.slb.com)
(ORACLE_HOME = D:\Oracle\Ora81)
(SID_NAME = pcms)
)
)

[arjun]

Is there a firewall of any kind on host ORA_FH_UK (IP:199.10.1.1) ?

[pipo]

so your server's name is ORA_FH_UK, it's IP is 199.10.1.1, and the running listener is listener1.

nevertheless the tnsnames.ora file which is interesting is not the one from the server, but the client side one.

your server seems to have 2 network cards and to be on the 2 networks, my question is which subnet do your clients belong to ?

you didn't answer jovery questions : what does the client side sqlnet.ora file contains, and can you tnsping your server from the client ?

[adewri]

keep tnsnames.ora on the client pcs.

here im assuming that ORA_FH_UK is the hostname of the machine which has the Oracle server.

PCMS.FAREHAM.SLB.COM =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = ORA_FH_UK)(PORT = 1521))
)
(CONNECT_DATA =
(SID = PCMS)
)
)


Keep listener.ora on the server machine only which has the database installed

# LISTENER.ORA Network Configuration File: D:\Oracle\Ora81\NETWORK\ADMIN\listener.ora
# Generated by Oracle configuration tools.

LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = ORA_FH_UK)(PORT = 1521))
)
)

SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(GLOBAL_DBNAME = pcms.fareham.slb.com)
(ORACLE_HOME = D:\Oracle\Ora81)
(SID_NAME = pcms)
)
)

HTH