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 :
- >/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.