1) You need to be root user to perform steps.
[blog@ask4it]$ su -
2) Go to Directory Where your kernel drivers stored. Follow exact command.
[root@ask4it]# cd /lib/modules/$(uname -r)/kernel/drivers/cdrom
3) Now list directory.
[root@ask4it cdrom]# ls
cdrom.ko
cdrom.ko
4) Now rename or delete cdrom.ko file with following command.
[root@ask4it cdrom]# mv cdrom.ko cdrom.ko-ok
To Delete file execute below command
[root@ask4it cdrom]# rm -rf cdrom.ko
5) Now reboot your computer and Insert CD or DVD into Drive. It will not detect.
6) If you dont want to reboot your computer then just execute below command.
modprobe -r sr_mod
Hope this helps you