Thursday, July 25, 2013

ORA error

ORACLE error messages:
1)
SQL> startup force
ORA-00845: MEMORY_TARGET not supported on this system

Solution: It uses /dev/shm on Linux, if max_target set over /dev/shm size.
as root
mount -o remount size=5G /dev/shm
Add into /etc/fstab:
Metalink:ORA-00845 When Starting Up An 11g Instance With AMM Configured

2) impdp - corrupt dump file
ORA-39246: cannot locate master table within provided dump files
ORA-39059: dump file set is incomplete

solution: Re-run expdp and copy to take valid dump files.

No comments:

Post a Comment