Articles Comments

AskDba.org Weblog » Entries tagged with "ORA-600"

Recreating Database Link

January 18th, 2009 | 4 Comments

I was trying to recreate database links as part of database migration activity. This involved mixture of 8i,9i and 10g database. In case of 8i/9i it is very easy to find the old password which was used to create database link as passwords for database links are stored in Clear Text (decrypted format) in SYS.LINK$ .As a result we can easily re-create database links. Find below steps to perform the same SQL> set pages 1000 lines 80 SQL> col db_link for a20 SQL> col host for a20 SQL> col user_id for a20 SQL> SELECT NAME,HOST,USERID,PASSWORD FROM SYS.LINK$; NAME HOST USERID … Read entire article »

Filed under: database, oracle

ORA-00600 [12333]

May 20th, 2008 | Add a Comment

ORA-00600 with [12333] is an error that I have encountered on multiple occasions. This post is to shed some light on what this error is all about. To start with let us try to understand when does oracle report ora-00600 error. An ora-00600 error is raised in the exception handler section of Oracle’s c-program code. i.e. Coders have forseen certain exceptional situation that are potential threats to data integrity or memory integrity and written appropriate exceptional handlers to report a ora-00600 error with appropriate information about the exception condition. Details like [12333] indicate or provide hints as to what caused the exception. ora-00600 [12333] is reported when the server recieves data from a client and the server cannot recognize the data format. This error mostly is because of issues with network and … Read entire article »

Filed under: database, oracle