We are trying to build a test version of a production database by restoring the production backup using RMAN and renaming the database to
We've successfully restored and opened the database as production (with different IP from the real production server).
When using the
NID utility to rename the database to
test, we are encountering this error:
NID-00135: There are 1 active threads.
We've been having difficulty getting the database to shutdown normally using the
SHUTDOWN IMMEDIATE command. After an hour or so of waiting for the damn thing to die, we are forced to resort to grepping all the
ora_* processes and killing them.
We left the listener up, the SQLPlus thread running, the bash thread owned by the Oracle user running, but that's about it for all Oracle-owned processes.
We've even restarted the server.
Are we missing something here?