{"id":776,"date":"2023-11-23T21:27:06","date_gmt":"2023-11-23T21:27:06","guid":{"rendered":"https:\/\/test.samplewebsitelink.com\/ordba\/?p=776"},"modified":"2023-11-23T21:27:08","modified_gmt":"2023-11-23T21:27:08","slug":"pid-for-oradebug","status":"publish","type":"post","link":"https:\/\/test.samplewebsitelink.com\/ordba\/2023\/11\/23\/pid-for-oradebug\/","title":{"rendered":"PID FOR ORADEBUG"},"content":{"rendered":"\n
\"\"\/<\/figure>\n\n\n\n

PID FOR ORADEBUG<\/p>\n\n\n\n

PID FOR ORADEBUG<\/h2>\n\n\n\n

 How to find PID for setospid in oradebug?<\/strong><\/p>\n\n\n\n

Doc ID: Note:105395.1<\/p>\n\n\n\n

PURPOSE<\/p>\n\n\n\n

The purpose of this bulletin is to instruct the user how to
get the correct pid for the oradebug command:<\/p>\n\n\n\n

oradebug setospid<\/p>\n\n\n\n

SCOPE & APPLICATION<\/strong><\/p>\n\n\n\n

This bulletin is directed to anyone using oradebug, possibly
to troubleshoot hanging issues.<\/p>\n\n\n\n

How to Find the Right PID for oradebug setospid<\/p>\n\n\n\n

There are ways to find the correct os pid from the Oracle
database, by querying v$session and v$process, but this method
gets the information strictly from the os.<\/p>\n\n\n\n

1) At the Unix prompt, type who am i. For example:<\/p>\n\n\n\n

[tiger5]\/app\/oracle\/product\/8.1.6> who am i
kfarmer pts\/25 Apr 13 10:37 (rociblj-ppp-9.us.oracle.com)<\/p>\n\n\n\n

Take note of the terminal, in this case pts\/25.<\/p>\n\n\n\n

2) Start server manager and connect internal.<\/p>\n\n\n\n

[tiger5]\/app\/oracle\/product\/8.1.6> svrmgrl<\/p>\n\n\n\n

Oracle Server Manager Release 3.1.6.0.0 – Production<\/p>\n\n\n\n

Copyright (c) 1997, 1999, Oracle Corporation. All Rights Reserved.<\/p>\n\n\n\n

Oracle8i Enterprise Edition Release 8.1.6.0.0 – Production
With the Partitioning option
JServer Release 8.1.6.0.0 – Production<\/p>\n\n\n\n

SVRMGR> connect internal
Connected.<\/p>\n\n\n\n

3) Issue this command from svrmgrl:
!ps -ef | grep svrmgrl<\/p>\n\n\n\n

Your output will look something like this:<\/p>\n\n\n\n

SVRMGR> !ps -ef | grep svrmgrl
kfarmer 3705 25983 0 15:27:52 pts\/25 0:00 svrmgrl
kfarmer 2504 24262 0 14:43:57 pts\/18 0:00 svrmgrl
kfarmer 3759 3757 0 15:29:52 pts\/25 0:00 grep svrmgrl
jharwell 28026 27944 0 16:42:25 pts\/17 0:00 svrmgrl<\/p>\n\n\n\n

Look for the terminal that matches your terminal from the ‘who am i’
command. Note the pid that goes with it, in this case 3705. There will
be another process connected with this terminal, too, but that is the
grep, not server manager.<\/p>\n\n\n\n

4) Issue this command from svrmgrl:
!ps -ef | grep 3705
Your output will look something like this:
SVRMGR> !ps -ef | grep 3705
oracle 3706 3705 0 15:27:52 ? 0:00 oracleV816 (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))
kfarmer 3705 25983 0 15:27:52 pts\/25 0:00 svrmgrl
kfarmer 3856 3705 0 15:33:37 pts\/25 0:00 [ sh ]
kfarmer 3859 3857 0 15:33:37 pts\/25 0:00 grep 3705
5) Look for a process that has a parent process of 3705. There are 2 here.
One is 3706, a sqlnet connection, and 3856, a shell. In this case, I’m
searching for the sqlnet connection which is running svrmgrl, process
3706. This is the pid I would use for my oradebug setospid command:<\/p>\n\n\n\n

oradebug setospid 3706<\/p>\n","protected":false},"excerpt":{"rendered":"

PID FOR ORADEBUG PID FOR ORADEBUG  How to find PID for setospid in oradebug? Doc ID: Note:105395.1 PURPOSE The purpose of this bulletin is to instruct the user how toget the correct pid for the oradebug command: oradebug setospid SCOPE & APPLICATION This bulletin is directed to anyone using oradebug, possiblyto troubleshoot hanging issues. How …<\/p>\n

PID FOR ORADEBUG<\/span> Read More »<\/a><\/p>\n","protected":false},"author":1,"featured_media":504,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"site-sidebar-layout":"default","site-content-layout":"","ast-site-content-layout":"","site-content-style":"default","site-sidebar-style":"default","ast-global-header-display":"","ast-banner-title-visibility":"","ast-main-header-display":"","ast-hfb-above-header-display":"","ast-hfb-below-header-display":"","ast-hfb-mobile-header-display":"","site-post-title":"","ast-breadcrumbs-content":"","ast-featured-img":"","footer-sml-layout":"","theme-transparent-header-meta":"","adv-header-id-meta":"","stick-header-meta":"","header-above-stick-meta":"","header-main-stick-meta":"","header-below-stick-meta":"","astra-migrate-meta-layouts":"","ast-page-background-enabled":"default","ast-page-background-meta":{"desktop":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-gradient":""},"tablet":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-gradient":""},"mobile":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-gradient":""}},"ast-content-background-meta":{"desktop":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-gradient":""},"tablet":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-gradient":""},"mobile":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-gradient":""}},"footnotes":""},"categories":[10],"tags":[],"class_list":["post-776","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-oracle"],"yoast_head":"\nPID FOR ORADEBUG - Ordba<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/test.samplewebsitelink.com\/ordba\/2023\/11\/23\/pid-for-oradebug\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"PID FOR ORADEBUG - Ordba\" \/>\n<meta property=\"og:description\" content=\"PID FOR ORADEBUG PID FOR ORADEBUG  How to find PID for setospid in oradebug? Doc ID: Note:105395.1 PURPOSE The purpose of this bulletin is to instruct the user how toget the correct pid for the oradebug command: oradebug setospid SCOPE & APPLICATION This bulletin is directed to anyone using oradebug, possiblyto troubleshoot hanging issues. How … PID FOR ORADEBUG Read More »\" \/>\n<meta property=\"og:url\" content=\"https:\/\/test.samplewebsitelink.com\/ordba\/2023\/11\/23\/pid-for-oradebug\/\" \/>\n<meta property=\"og:site_name\" content=\"Ordba\" \/>\n<meta property=\"article:published_time\" content=\"2023-11-23T21:27:06+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2023-11-23T21:27:08+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/test.samplewebsitelink.com\/ordba\/wp-content\/uploads\/2023\/11\/article-3-1.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"700\" \/>\n\t<meta property=\"og:image:height\" content=\"700\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"ordba\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"ordba\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/test.samplewebsitelink.com\/ordba\/2023\/11\/23\/pid-for-oradebug\/\",\"url\":\"https:\/\/test.samplewebsitelink.com\/ordba\/2023\/11\/23\/pid-for-oradebug\/\",\"name\":\"PID FOR ORADEBUG - Ordba\",\"isPartOf\":{\"@id\":\"https:\/\/test.samplewebsitelink.com\/ordba\/#website\"},\"datePublished\":\"2023-11-23T21:27:06+00:00\",\"dateModified\":\"2023-11-23T21:27:08+00:00\",\"author\":{\"@id\":\"https:\/\/test.samplewebsitelink.com\/ordba\/#\/schema\/person\/7365beabb32b7aa77cf0e890ee90ea0f\"},\"breadcrumb\":{\"@id\":\"https:\/\/test.samplewebsitelink.com\/ordba\/2023\/11\/23\/pid-for-oradebug\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/test.samplewebsitelink.com\/ordba\/2023\/11\/23\/pid-for-oradebug\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/test.samplewebsitelink.com\/ordba\/2023\/11\/23\/pid-for-oradebug\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/test.samplewebsitelink.com\/ordba\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"PID FOR ORADEBUG\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/test.samplewebsitelink.com\/ordba\/#website\",\"url\":\"https:\/\/test.samplewebsitelink.com\/ordba\/\",\"name\":\"Ordba\",\"description\":\"\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/test.samplewebsitelink.com\/ordba\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/test.samplewebsitelink.com\/ordba\/#\/schema\/person\/7365beabb32b7aa77cf0e890ee90ea0f\",\"name\":\"ordba\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/test.samplewebsitelink.com\/ordba\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/dd4335bb4e225c36ce7c56a0aff84bb202ebb523ebdc5d1e1a11cc3f3e6085f3?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/dd4335bb4e225c36ce7c56a0aff84bb202ebb523ebdc5d1e1a11cc3f3e6085f3?s=96&d=mm&r=g\",\"caption\":\"ordba\"},\"sameAs\":[\"https:\/\/test.samplewebsitelink.com\/ordba\"],\"url\":\"https:\/\/test.samplewebsitelink.com\/ordba\/author\/ordba\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"PID FOR ORADEBUG - Ordba","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/test.samplewebsitelink.com\/ordba\/2023\/11\/23\/pid-for-oradebug\/","og_locale":"en_US","og_type":"article","og_title":"PID FOR ORADEBUG - Ordba","og_description":"PID FOR ORADEBUG PID FOR ORADEBUG  How to find PID for setospid in oradebug? Doc ID: Note:105395.1 PURPOSE The purpose of this bulletin is to instruct the user how toget the correct pid for the oradebug command: oradebug setospid SCOPE & APPLICATION This bulletin is directed to anyone using oradebug, possiblyto troubleshoot hanging issues. How … PID FOR ORADEBUG Read More »","og_url":"https:\/\/test.samplewebsitelink.com\/ordba\/2023\/11\/23\/pid-for-oradebug\/","og_site_name":"Ordba","article_published_time":"2023-11-23T21:27:06+00:00","article_modified_time":"2023-11-23T21:27:08+00:00","og_image":[{"width":700,"height":700,"url":"https:\/\/test.samplewebsitelink.com\/ordba\/wp-content\/uploads\/2023\/11\/article-3-1.jpg","type":"image\/jpeg"}],"author":"ordba","twitter_card":"summary_large_image","twitter_misc":{"Written by":"ordba","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/test.samplewebsitelink.com\/ordba\/2023\/11\/23\/pid-for-oradebug\/","url":"https:\/\/test.samplewebsitelink.com\/ordba\/2023\/11\/23\/pid-for-oradebug\/","name":"PID FOR ORADEBUG - Ordba","isPartOf":{"@id":"https:\/\/test.samplewebsitelink.com\/ordba\/#website"},"datePublished":"2023-11-23T21:27:06+00:00","dateModified":"2023-11-23T21:27:08+00:00","author":{"@id":"https:\/\/test.samplewebsitelink.com\/ordba\/#\/schema\/person\/7365beabb32b7aa77cf0e890ee90ea0f"},"breadcrumb":{"@id":"https:\/\/test.samplewebsitelink.com\/ordba\/2023\/11\/23\/pid-for-oradebug\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/test.samplewebsitelink.com\/ordba\/2023\/11\/23\/pid-for-oradebug\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/test.samplewebsitelink.com\/ordba\/2023\/11\/23\/pid-for-oradebug\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/test.samplewebsitelink.com\/ordba\/"},{"@type":"ListItem","position":2,"name":"PID FOR ORADEBUG"}]},{"@type":"WebSite","@id":"https:\/\/test.samplewebsitelink.com\/ordba\/#website","url":"https:\/\/test.samplewebsitelink.com\/ordba\/","name":"Ordba","description":"","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/test.samplewebsitelink.com\/ordba\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/test.samplewebsitelink.com\/ordba\/#\/schema\/person\/7365beabb32b7aa77cf0e890ee90ea0f","name":"ordba","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/test.samplewebsitelink.com\/ordba\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/dd4335bb4e225c36ce7c56a0aff84bb202ebb523ebdc5d1e1a11cc3f3e6085f3?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/dd4335bb4e225c36ce7c56a0aff84bb202ebb523ebdc5d1e1a11cc3f3e6085f3?s=96&d=mm&r=g","caption":"ordba"},"sameAs":["https:\/\/test.samplewebsitelink.com\/ordba"],"url":"https:\/\/test.samplewebsitelink.com\/ordba\/author\/ordba\/"}]}},"_links":{"self":[{"href":"https:\/\/test.samplewebsitelink.com\/ordba\/wp-json\/wp\/v2\/posts\/776","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/test.samplewebsitelink.com\/ordba\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/test.samplewebsitelink.com\/ordba\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/test.samplewebsitelink.com\/ordba\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/test.samplewebsitelink.com\/ordba\/wp-json\/wp\/v2\/comments?post=776"}],"version-history":[{"count":1,"href":"https:\/\/test.samplewebsitelink.com\/ordba\/wp-json\/wp\/v2\/posts\/776\/revisions"}],"predecessor-version":[{"id":777,"href":"https:\/\/test.samplewebsitelink.com\/ordba\/wp-json\/wp\/v2\/posts\/776\/revisions\/777"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/test.samplewebsitelink.com\/ordba\/wp-json\/wp\/v2\/media\/504"}],"wp:attachment":[{"href":"https:\/\/test.samplewebsitelink.com\/ordba\/wp-json\/wp\/v2\/media?parent=776"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/test.samplewebsitelink.com\/ordba\/wp-json\/wp\/v2\/categories?post=776"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/test.samplewebsitelink.com\/ordba\/wp-json\/wp\/v2\/tags?post=776"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}