Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
Error with DBNEWID (""NID-00600") when cloning Oracle 9i database with SMO 3.0.1
2009-08-08
05:26 AM
4,271 Views
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
hi
we tried to clone an Oracle Datbase on NFS (AIX 5.3 and Oracle 9.2.0.8) with SMO 3.0.1
all went well until SMO called the "NID" Oracle utility in order to change the SID database in the clone. At this step we got an error "NID-00600: Internal Error - [23] [0] [0] [0]"
it seems that the Oracle NID utility does not work on this server
we tried another Oracle 9i server and launch the nid tool outside SMO and we got the same error
has anyone got the same issue ? is there a workaround ?
we do not want to wait for a fix from Oracle if there is a valid workaround through SMO.
thanks for your help.
3 REPLIES 3
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
What is the specific version of 9i that you are running? I believe there are Oracle bugs that require you to have at least 9.2.0.8.
We've seen a few different dbnewid-related failures that I can recall. Number of open cursors configured, and a file permissions issue come to mind.
I can look into this more when I am online but that is going to be much later in the day.
Given this particular error (NID-) is coming from Oracle, I would suggest going to Oracle Metalink to see if you can find that particular error. Same applies to a NetApp NOW search of our BURT tracking system and depending on your level of access.
-Mark
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
This error (NID-00600) can also occur on "Oracle Server - Enterprise Edition - Version 9.2.0.1 to 9.2.0.5", because of few data files in "offline dropped" state. Please refer to oracle metalink document ID: 292327.1 for more details.
Thanks,
Vrishali
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
hi Vrishali and MArk
thanks for your answer
we used the Oracle 9.2.0.8 version of Oracle.
the customer opend a ticket at Oracle support.
But if you have already faced this issue or any useful information to solve this issue, i would apreciate.
we also tried to run the Oracle "nid" tool and in the nid.log file, it seemed that the tool was blocked on a particular data file (index file). We noticed then that this particular file has a size different than the other files associated with the same tablespace. Maybe this file is corrupted but we could not prove that yet
thanks again.
