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

ORA-00600: internal error code, arguments: [4194], ORA-00607 solve today there is a kid shoes said their client connection is not on the server end through oral guidance really cannot be done, at that time, I was still angry with the oracle net issue. It took so long for the other party to send a remote message to my children's shoes on the windows server, the first thing that comes in is that sqlplus/as sysdba directly jumps out of the empty instance .. I was so angry... SQL> startup looked at the crash when mount was about to open. Two errors were reported: ora607ora600. These two errors are classic errors. I asked the client about this database, he said it was a test database (which I was more confident about) and was suddenly powered off .. 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, and I am too lazy to check it again) the required operation steps are available on the Internet, but I still write down the first step: Enter the mount stage, view undo, then, change the undo tablespace to manually allocate [SQL] 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 to open the database, create a new undotbs, replace the default undotbs, change undo_management back to auto [SQL] SQL> shutdown immediate; ORA-01109: Database not open database dismounted. ORACLE instance shut down. SQL> startup ORACLE instance started. total System Gl Obal 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; -- path according to select name from v $ datafile; Tablespace created. SQL> alter system set undo_tablespace = undotbs02 scope = sp File; System altered. SQL> alter system set undo_management = auto scope = spfile; System altered. step 3: restart and delete the old undotbs [SQL] SQL> shutdown immediate; Database closed. 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 2973 696 bytes Database mounted. database opened. SQL> drop tablespace undotbs1 including contents and datafiles; Tablespace dropped. SQL> finished. You can show parameter, enter a test user to see [SQL] SQL> show parameter undo name type value ------------- ------------------------------ undo_management string AUTO undo_retention integer 900 undo_tablespace string UNDOTBS02 SQL> conn scott/tig Er Connected. SQL> desc emp; Name Null? Type verification -------- invalid empno number (4) ENAME VARCHAR2 (10) JOB VARCHAR2 (9) mgr number (4) hiredate date sal number (7,2) comm number (7,2) deptno number (2) closed