Hi,

The Oracle software was installed properly and we were working with the databases etc...
All of a sudden, this problem came.

I have encountered this situation a few times before. I had discussed with a few of my Sr. DBA's too.
The answer I got was.........REINSTALL.

Can u tell me what u did?

Vijay.