Thanks Nagarjuna. There was only one database instance on this machine. Does ORACLE_SID setting still matter in this case? I did the above steps number of times before but never had this problems. I happen to reboot the machine and it worked fine.
Thanks.




Reply With Quote