ORA-00072 , ORA-00074 while trying to debug ospid (Doc ID 1683815.1)

Last updated on SEPTEMBER 21, 2016

Applies to:

Oracle Database - Enterprise Edition - Version 9.2.0.1 to 9.2.0.1 [Release 9.2]
Microsoft Windows x64 (64-bit)

Goal

 Trying to debug OSPID getting ORA-00072 , ORA-00074

  SQL> select username, sid, serial#, paddr from v$session where username='CACSA';

USERNAME SID SERIAL# PADDR
-----------------------------------------------------------------------------------------
CACSA 16 11219 3B22584C


SQL> select ADDR, PID, SPID FROM V$PROCESS WHERE ADDR = '3B22584C';

ADDR PID SPID
--------------------------------------------
3B22584C 15 580

SQL> oradebug setospid 580
ORA-00072: el proceso "Windows thread id: 580, image: " no está activo
SQL> oradebug event 10046 trace name context forever, level 4
ORA-00074: has not specified any process

Solution

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms