on 03-19-2009 10:32 AM
Hi,
Whilst doing a SAP system copy, I'm trying to create a new controlfile on the target system, but I get the following error:
SQL> @QAS_control.sql
ORACLE instance started.
Total System Global Area 1241513984 bytes
Fixed Size 2075856 bytes
Variable Size 595591984 bytes
Database Buffers 629145600 bytes
Redo Buffers 14700544 bytes
CREATE CONTROLFILE REUSE SET DATABASE "QAS" RESETLOGS ARCHIVELOG
*
ERROR at line 1:
ORA-01503: CREATE CONTROLFILE failed
ORA-00600: internal error code, arguments: [krhcvt_filhdr_v10_01], [], [], [],
[], [], [], []
Can anybody please advise what this particular ORA-00600 error message means and possibly how to resolve the issue?
Thanks,
Wes
Hello Wes,
in the most reasons, the ORA-600 argument krhcvt_filhdr_v10_01 is pointing to a problem with the temporary tablespace.
Can you try to recreate your control file without the temp files? Just delete / exclude the corresponding entries in the sql script.
Regards
Stefan
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
What do you mean create a new controlfile? Are you trying to multiplex your controlfies (i.e. have 2 or 3 copies of it)?
If you're using an spfile, you can alter your control_file init parameter to include the new controlfile, shutdown the DB, copy an existing controlfile to the new location, then start the DB back up.
See:
http://www.siue.edu/~dbock/cmis565/module7-control_file.htm
If you're looking for something else.. here is the create controlfile command:
http://download.oracle.com/docs/cd/B19306_01/server.102/b14200/statements_5003.htm#SQLRF01203
You can find a corresponding trace file in your bdump directory that will have more information on your error. Then, you can take that ORA-600, login to Metalink (My Oracle Support now), and they have an ORA-600 information tool. That can assist you.
Search Metalink for ORA-600/ORA-7445 Troubleshooter
hi,
You provide not much information.
Nevertheless, that OERI is not documented in any SAP note.
Therefore the proper advice is to open a message at SAP.
It is an internal oracle error
it is not documented
It may have something to do with a corruption on a temporal datafile.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
95 | |
11 | |
10 | |
9 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.