NID issue
NayasMay 4 2011 — edited May 4 2011Hi All,
First of all, we use rdbms 10.2.0.4.
The issue is, during refresh, from prod to dev, the rman restore got an eror due to NID. The NID error was "Maximum open cursors exceeded".
I modified the init$SID.ora and increased the number of cursor.
I then shutdown the database and then mounted it.
When I reran the nid command (as follow: nid target=/ dbname=dev setname=yes logfile=myfile.log), it says "NID-00135: There are 1 active threads".
My question is, I shut it down clean. Listener is not running. I know for sure no one is trying to access the database. When I check at O/S level (red hat), there are no processes beside the background process. What could be that "1 active threads"? How can I close that thread and run the NID command?
Thank you,
Naya~