Common Error
Table of Contents

ORA-00600

The solution below don't seems to work anymore

I known that I got this error when I change the file :
/etc/hostname
of my system, but I still don't known how to get a working solution !

As I'm used to get Oracle on VM with xen, I need to change some settings, like IP, hostname, and so on…

Once, I get this error :

ORA-00600: internal error code, arguments: [keltnfy-ldmInit], [46], [1], [], [], [], [], []

when I wanted to start oracle on a new VM.
This did seems a really obscur reason at first, but it's only due to a wrong configuration in the file :

listener.ora

If the host running oracle has an IP of :

192.168.1.100

your file have to look something like this one :

# listener.ora Network Configuration File: /opt/oracle/10.2/network/admin/listener.ora
# Generated by Oracle configuration tools.

SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
      (SID_NAME = PLSExtProc)
      (ORACLE_HOME = /opt/oracle/10.2)
      (PROGRAM = extproc)
    )
  )

LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
      (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.100)(PORT = 1521))
    )
  )

The important line is this one :

(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.100)(PORT = 1521))

The ip address has to match to the ip address of the host running oracle.
You need also to edit these files :

/etc/hostname
/etc/hosts

and if you have done a image of a system, you will probably get the information about the old mac address of the vm. So, to don't get an error during the boot of the new VM, let's simply do :

  1. >/etc/udev/rules.d/z25_persistent-net.rules

Otherwise, you won't get an ip address in your vm.

EXP-00091

I got this error first when I wanted to do an export of an oracle database.
The full error code that I got was this one, if it could help you :

EXP-00091: Exporting questionable statistics.

What you needs to known, is that it doesn't affect your export, it isn't an error. So, you only have to add this :

statistics=none

to do you export, in your parameter file of on the command line.
If you want more information, you can go here.

Unless otherwise stated, the content of this page is licensed under Creative Commons Attribution-ShareAlike 3.0 License