ORA-00600: internalerrorcode, arguments: [4194], ORA-00607

Source: Internet
Author: User
ORA-00600: internalerrorcode, arguments: [4194], ORA-00607

ORA-00600: internal error code, arguments: [4194], ORA-00607

Today, a boy shoes says that his client cannot connect to the server.

I was not able to solve the problem through oral guidance, but I was still angry with the Oracle net issue for such a long time.
Send the recipient to me remotely
The server of kids shoes is windows. The first thing that comes in is sqlplus/as sysdba.
The empty instance is popped out .. I was so angry...
SQL> startup
When mount is about to open
Two errors are reported.
Ora607
Ora600
These are two classic errors.
I asked the client about what happened to the database. He said it was a test database (I was more confident and bold), and a sudden power failure occurred ..
Then we can understand that a block in the data file in the undo tablespace (the next heap on the windows interface ?? The character set does not match. I am too lazy to check it again)
The required operation steps are available on the Internet, but I still write them down.

Step 1: Go to the mount stage, view undo, and change the undo tablespace to manual allocation.

SQL> startup mount;
ORACLE instance started.

Total System Global Area 285212672 bytes
Fixed Size 1218992 bytes
Variable Size 100664912 bytes
Database Buffers 180355072 bytes
Redo Buffers 2973696 bytes
Database mounted.
SQL> show parameter undo

NAME TYPE VALUE
-----------------------------------------------------------------------------
Undo_management string AUTO
Undo_retention integer 900
Undo_tablespace string UNDOTBS1

SQL> alter system set undo_management = manual scope = spfile;

System altered.

Step 2: restart the database, create a new undotbs, replace the default undotbs, and change undo_management back to auto

SQL> shutdown immediate;
ORA-01109: database not open


Database dismounted.
ORACLE instance shut down.

SQL> startup
ORACLE instance started.

Total System Global Area 285212672 bytes
Fixed Size 1218992 bytes
Variable Size 100664912 bytes
Database Buffers 180355072 bytes
Redo Buffers 2973696 bytes
Database mounted.
Database opened.

SQL> create undo tablespace undotbs02 datafile '/s01/oradata/orcl/undotbs02.dbf' size 50 m autoextend on next 10; -- the path is based on select name from v $ datafile;

Tablespace created.

SQL> alter system set undo_tablespace = undotbs02 scope = spfile;

System altered.

SQL> alter system set undo_management = auto scope = spfile;

System altered.

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.