Execute cmd.exe command on Windows
oradebug call system "dir>oradebug.out"
Find file in c:\…\…\database
directory:
C:\> dir c:\…\…\datbase\oradebug*
ORA-07443: function … not found
Trying to call a function that is not known by
oradebug causes the error message
ORA-07443
(function … not found) to be thrown.
Thus, it is possible to dump the call stack when this error is thrown with something like
oradebug setmypid
oradebug event 7443 trace("ORA-07443: %\n", shortstack())
oradebug call doesNotExist
oradebug tracefile_name
On
Windows, Oracle 19, the callstack is
- dbgePostErrorKGE
- dbkePostKGE_kgsf
- kgeade
- kgeselv
- ksesec1
- skdxcall
- ksdxen_int
- ksdxen
- opiodr
- ttcpip
- opitsk
- opiino
- opiodr
- opidrv
- sou2o
- opimai_real
- opimai
- OracleThreadStart
Instead of using the shortstack()
action, it is also possible to call
oradebug event 7443 callstack(1)