Aron Tunzi wrote:There is no danger in psoting 192.168 address range addresses. These are private addresses and do not exist on the Internet.
Wow, I can ping your DB :-) ... ok not true but pay attention posting IP addresses!
Phani wrote:Why use port 1522?
ifconfigWhy are you using bonding? How many bonded interfaces are there and now many physical NICs? Bond6 alludes that it is the 7th bonded interface - and at 2 NICs per bonded interface it implies that your server has 14 physical Ethernet interfaces. Which I doubt is true.
bond6 Link encap:Ethernet HWaddr 00:26:55:D3:02:B6
RX packets:1309675596 errors:5 dropped:0 overruns:0 frame:3Not good to see any errors. What does ethtool stats show? Also check that the physical interfaces are enabled for full duplex. Some Cisco switches do not negotiate it properly and the NIC could be running half duplex.
Phani wrote:I did not post a actual Linux command, but a function - as in list the stats of the underlying bonded interfaces using the command ethtool. E.g. command:
hi this is the ouput of ethtool stats
OS admin checked and found that one NIC card is down(redundancy) and got it up by resetting the connections. Eventhough the problem is same.If the connectivity problem is not due to a network issue, then it could be the time it takes for the listener to create an Oracle dedicated server process to service the client connection. This can be traced via the listener by enabling debug tracing and making a client connection.
From my part changed the TNSADMIN location to another home where this connectivity is working fine for other databases, recreated the listner service and started. but for this database connectivity is remained slow only. tnsping response is nomal in all cases. but while connecting only I am getting delayed.