Home PC Games Linux Windows Database Network Programming Server Mobile  
  Home \ Database \ ORA-600 [kcbz_check_objd_typ] Error Handling     - Linux environment variable settings and save places (Linux)

- Ubuntu 14.10 Apache installation and configuration (Server)

- Java deserialization test (Programming)

- To install Xen in Ubuntu 12.04 (Linux)

- 22 Port weak passwords and SSH connection program of the Linux server (Linux)

- How Glances monitoring system on Ubuntu (Linux)

- Linux ldconfig command (Linux)

- Connect to the Oracle Database Help class (Database)

- CentOS 6.4 under PXE + Kickstart unattended operating system installation (Programming)

- Open container cluster management system architecture and components introduced Kubernetes (Server)

- Linux firewall settings instance (Linux)

- The correct way to open Xcode - Debugging (Programming)

- Asynchronous JavaScript loading (Programming)

- On the PC goes heavy security watch your startup items (Linux)

- Setting Wetty do not need an account login command line operations (Linux)

- Iptables use examples (Linux)

- Linux cd command Detailed (Linux)

- 17 How to install the Ubuntu 14.04 and Linux Mint Kodi14 (XBMC) (Linux)

- Error: Unable to establish connection with FTP SFTP server (Server)

- Android main thread message system (Handler Looper) (Linux)

  ORA-600 [kcbz_check_objd_typ] Error Handling
  Add Date : 2018-11-21      
  Basic elements
There are channels for feedback, HIS software in the data saved, prompted ORA-600 errors, detailed error information is as follows:

[Microsoft] [ODBC driver forOracle] [Oracle] ORA-20999: ORA-00600: internal error code, arguments: [kcbz_check_objd_typ], [0], [0], [1], [], [], [], [], [], [], [], []

ORA-06512: at "ZLHIS.ZL_ERRORCENTER", line 73

ORA-06512: at "ZLHIS.ZL_ patient XX Print _UPDATE", line 231

ORA-06512: at line 1

        This error can not be skipped, resulting in service can not function properly.

problem analysis
Step one: Follow the prompts analysis 'stored procedures'
        Logically, this tip is quite clear, the judge may be based on experience ZL_ patient XX print _UPDATE may be a problem, combined with ORA-06512 error, try to re-create the process and synonyms perform the above operation problem persists.

Step Two: Analysis ora-600 error
        Next Analysis ORA-600 [kcbz_check_objd_typ] bug in accordance with the interpretation on Baidu is due to Oracle in the inspection data in memory block, object number found on the data block is wrong, throws this error message, further analysis of the problem found in access (print patient XX) table when an error is thrown, we analyze the table separately, we the table full-table queries, suggesting ora-08103 errors, but only if the query part of the table, the query correctly.

  We then troubleshoot the structure of the table, find the index of the table it is similar to the name of the BIN $, prove that the table is carried out by way of flashback recovery operation, here we finally located the problem lies.

        The root cause of the problem is because the operator misuse of patient care print a drop table operation, and then the way the flashback recovery, but for some reason, could lead to data recovery, but the database dictionary table content appears error (or called mismatch), thus resulting in the database table to do anything, will prompt an error, as we ZLHIS user statistics collection

Resolution process
Step one: error renaming the table, a new table of the same name
        By rename operation, (patient XX print) to rename the table, and then re-built a (patient XX print) table by inserting statements to insert data into a new table, we should pay attention here, because there is a problem accessing the old table so we have to use cycle insertion mode, as follows:

l rename the table

rename patient to patient XX XX print original print _

l create a new table

create table print patient XX XX patient as select * from the original print _ where 1 = 2


Step two: The process data of the original table into the new table
        In the insert, we can not access through a full table scan to access the original table, but fortunately, they can access the ROWID through the whole table, we will create a table holding ROWID original table, and then one by one by matching ROWID inserted into the new table ,as follows

l create a save rowid table

create table print patient XX XX patient _rowid asselect rowed from the original print _

l process one by one insert

  for cursor_rowid in (select rrowid from patient XX Print _rowid) loop
    insert into select * from print patient XX XX patient original print _ where rowid = CHARTOROWID (cursir_rowid.rrowid);
end loop;

        By the above operation, the last nearly 30 records can not be transferred to the new table, but does not affect use.
- Git build a team development environment operating drills (Linux)
- The Java way to stop a thread of execution (Programming)
- Ubuntu use three methods to install Ruby (Linux)
- CentOS 7.1 install NTFS-3G (Linux)
- LAN in Ubuntu shared folders to Windows (Linux)
- Bash command substitution (Programming)
- Oracle Data Guard LOG_ARCHIVE_DEST_n optional attribute parameters (Database)
- Let's Encrypt with semiautomatic into Nginx configuration https (Server)
- How to query the role of Linux services (Linux)
- Try the command ip, ifconfig is obsolete under Linux (Linux)
- CentOS build JDK environment (Linux)
- Use exp exported EXP-00091 error (Database)
- How to install or upgrade to the Linux kernel in Ubuntu 4.2 (Linux)
- Enterprise Hadoop cluster architecture - NFS installation (Server)
- Build a super simple "hardware" firewall router (Linux)
- High-performance JavaScript reflows and repaints (Programming)
- Detailed Linux network security policies and protection measures (Linux)
- How to configure security management services under Linux (Linux)
- Android Studio 1.0.2 set the memory size (Linux)
- Simple comparison of MySQL and Oracle in a sql analytical details (Database)
  CopyRight 2002-2022 newfreesoft.com, All Rights Reserved.