ORA-00072 , ORA-00074 while trying to debug ospid
(Doc ID 1683815.1)
Last updated on JANUARY 09, 2025
Applies to:
Oracle Database - Enterprise Edition - Version 9.2.0.1 to 9.2.0.1 [Release 9.2]Oracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
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
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
| Goal |
| Solution |
| References |