Wednesday, July 9, 2008

Listener forks on 10.2.0.3 if LD_ASSUME_KERNEL is set

Found an interesting problem.

If the .bash_profile has LD_ASSUME_KERNEL parameter the listener forks itself as given below:
oratest 13305 1 0 16:59 ? 00:00:00 /u04/oracle/testdb/10.2.0//bin/tnslsnr TEST -inheritoratest 13306 13305 0 16:59 ? 00:00:00 /u04/oracle/testdb/10.2.0//bin/tnslsnr TEST -inheritoratest 13307 13306 0 16:59 ? 00:00:00 /u04/oracle/testdb/10.2.0//bin/tnslsnr TEST -inheritoratest 13308 13306 0 16:59 ? 00:00:00 /u04/oracle/testdb/10.2.0//bin/tnslsnr TEST -inherit

If this parameter is removed and the env file is resourced the listener behaves properly.

oratest 13370 1 0 17:01 ? 00:00:00 /u04/oracle/testdb/10.2.0//bin/tnslsnr TEST -inheritoratest 13374 13339 0 17:01 pts/4 00:00:00 grep tnslsnr

I also have another database which is running on 10.1.04 and I see the listener forking (this does not have the parameter in the .bash_profile)

oradev 12971 1 0 15:07 ? 00:00:00 /u01/oracle/devdb/10.1.0/bin/tnslsnr DEV -inheritoradev 12972 12971 0 15:07 ? 00:00:00 /u01/oracle/devdb/10.1.0/bin/tnslsnr DEV -inheritoradev 12973 12972 0 15:07 ? 00:00:00 /u01/oracle/devdb/10.1.0/bin/tnslsnr DEV -inheritoradev 12974 12972 0 15:07 ? 00:00:00 /u01/oracle/devdb/10.1.0/bin/tnslsnr DEV -inherit

I guess I have to get a patch from oracle for this or upgrade the same to 10.2.0.2.