- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- Re: Status of Oracle Process
Categories
Company
Local Language
Forums
Discussions
Forums
- Data Protection and Retention
- Entry Storage Systems
- Legacy
- Midrange and Enterprise Storage
- Storage Networking
- HPE Nimble Storage
Discussions
Discussions
Discussions
Forums
Forums
Discussions
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
- BladeSystem Infrastructure and Application Solutions
- Appliance Servers
- Alpha Servers
- BackOffice Products
- Internet Products
- HPE 9000 and HPE e3000 Servers
- Networking
- Netservers
- Secure OS Software for Linux
- Server Management (Insight Manager 7)
- Windows Server 2003
- Operating System - Tru64 Unix
- ProLiant Deployment and Provisioning
- Linux-Based Community / Regional
- Microsoft System Center Integration
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Community
Resources
Forums
Blogs
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО12-05-2005 04:58 PM
тАО12-05-2005 04:58 PM
we are working on HP-UX 11i with oracle 9i
when we run ps -ef | grep pmon the output is as follows ---
# ps -ef | grep pmon
oracle 26419 1 0 Oct 1 ? 8:46 ora_pmon_aaaa
oracle 7653 1 0 Nov 10 ? 3:25 ora_pmon_bbbbb
oracle 28014 1 0 Oct 1 ? 9:01 ora_pmon_ccccc
oraias 25396 1 0 Sep 23 ? 10:46 ora_pmon_dddd
root 24074 23924 1 11:14:55 pts/1 0:00 grep pmon
We want to know what does the Question Mark signifies. Will it or is it causing some pb.
All the DBs are running on Archive Mode
SQL> archive log list
Database log mode Archive Mode
Automatic archival Enabled
Archive destination /abd/sadf/archive
Oldest online log sequence 11363
Next log sequence to archive 11365
Current log sequence 11365
Thanks in Adv
Regds,
Wish
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО12-05-2005 05:06 PM
тАО12-05-2005 05:06 PM
Re: Status of Oracle Process
===>
No it is not. It is denoting the terminal which controlling that process. If it is having that information then gives that. If it is running in schedular's or scripts then it will take that ? mark.
see ps man page for TTY
hth.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО12-05-2005 05:12 PM
тАО12-05-2005 05:12 PM
Re: Status of Oracle Process
cheers!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО12-05-2005 05:47 PM
тАО12-05-2005 05:47 PM
Re: Status of Oracle Process
the processes with ? r actually backup processes which requires no terminal, i.e. tty. run "ps -ef" and u will know what i mean.
please also do something abt your assignment of points.
http://forums1.itrc.hp.com/service/forums/pageList.do?userId=CA1237332&listType=unassigned&forumId=1
regards.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО12-05-2005 07:09 PM
тАО12-05-2005 07:09 PM
SolutionWhen you run ps -ef | grep pmon the output shown where you have the ? is the terminal that is controlling the background process.
Oracle background processes manage the Oracle RDBMS. Some must always be running for the server to be available, others are optional on all platforms, and some are optional and specific to certain platforms.
A separate operating system process is created to run each of the background functions listed above.
These background process do not require a terminal to run. So you see the ? as others also mentioned. And it is of no harm. You database is fine and is running in archivelog mode.
Attached is a text that lists the various background process and their requirements. In Oracle 10g there are few more than the earlier relaeases.
Indira A
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО12-05-2005 07:34 PM
тАО12-05-2005 07:34 PM
Re: Status of Oracle Process
IA
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО12-07-2005 04:05 AM
тАО12-07-2005 04:05 AM
Re: Status of Oracle Process
whith the following query
select process, machine, terminal from v$session where type = 'BACKGROUND';
example:
process, machine, terminal,
19876 orasrv2 UNKNOWN
So that confirms is is a background
job without a terminal and that is okay.
rgds,