TNSPING was taking long time. Even connection from any oracle client was taking too much time. Somewhere I found this is the problem of network. But after conversation with network team and all, I got no solution.
After verify, I found the listener file size is of 4GB, that was creating problem. I just renamed this file, a new listener log file automatically created and problem resolved.
(In fact many operating systems and their underlying file system implementation used 32 bit integers to represent file sizes and positions. So, no file could be larger that 2^32-1 bytes i.e 4GB. So, if file size reaches size of 4GB on 32 bit operating system, it created problem in read and write. This problem is basically with FAT file system.)
After verify, I found the listener file size is of 4GB, that was creating problem. I just renamed this file, a new listener log file automatically created and problem resolved.
(In fact many operating systems and their underlying file system implementation used 32 bit integers to represent file sizes and positions. So, no file could be larger that 2^32-1 bytes i.e 4GB. So, if file size reaches size of 4GB on 32 bit operating system, it created problem in read and write. This problem is basically with FAT file system.)
Comments
Post a Comment