Oracle DB Question


 
Thread Tools Search this Thread
Special Forums UNIX and Linux Applications Oracle DB Question
# 1  
Old 09-21-2010
Oracle DB Question

Hi,

Where do i post Oracle DB related questions??

I basically have 2 questions -

1. What is pmon and smon? Difference between them? If either or both process fail then how can we monitor them?

2. Is lsnrctl same as tnslsnr? if i want to check for listener status then how would i do that?
Code:
lsnrctl status

will give me the status
but is grepping tnslsnr same as the above?
# 2  
Old 09-21-2010
Moderator's Comments:
Mod Comment The correct forum is here, UNIX and Linux Applications. Moved.
# 3  
Old 09-21-2010
Quote:
Originally Posted by Mr. Zer0
Hi,

Where do i post Oracle DB related questions??

I basically have 2 questions -

1. What is pmon and smon? Difference between them? If either or both process fail then how can we monitor them?

2. Is lsnrctl same as tnslsnr? if i want to check for listener status then how would i do that?
Code:
lsnrctl status

will give me the status
but is grepping tnslsnr same as the above?
After a quick google...
pmon is a process monitor for Oracle that wakes up every few seconds and does housekeeping on certain processes, killing orphaned user processes, etc.

smon is a system monitor for Oracle that wakes up every 5 minutes and performs other housekeeping tasks, instance recovery, cleans up after a dirty shutdown, etc.

tnslsnr is the actual listener process for Oracle and must be running for users to connect to the db.

lsnrctl is a command for controlling that listener (start, stop, etc). The status command will give you more detail than simply grepping the process.

If either process, pmon or smon fails, your database instance will terminate.
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. UNIX for Advanced & Expert Users

Question related to UNIX and Oracle DB

I have one application server, which is Solaris non global zone (dsapid02-dt3d02 - 10.63.76.96) and a database server, which is Linux (db1-serv26 - 10.63.36.117 & 10.63.36.118). Whenever database admin is starting listener, it starts filling listener log file. Within minutes, it will make file in... (6 Replies)
Discussion started by: solaris_1977
6 Replies

2. Programming

Oracle TRICk Question

HI Guys , Below are the two columns ITEMS and STATE of table . ITEMS STATE '2345','ggdh','k5tg','dgyt','hFF' DF '1234','ghyt','DDD','GHTD','ABF' PQ Can we get output in PL/SQL in below way ?... (7 Replies)
Discussion started by: Perlbaby
7 Replies

3. Programming

Oracle Loop question

HI , Please guide to get the PL/SQL logic to retrieve parameter VALUES passed IN variable seperated with comma(,) Say items =(MTH,WKL,DLY,QTR) It should send above parameters seperatly USING LOOP condition IN the below IN clause SELECT * FROM tb_data_storage WHERE items IN... (4 Replies)
Discussion started by: Perlbaby
4 Replies

4. Hardware

Sun/Oracle M5000 Question

I have an M5K with disk issues I'm trying to troubleshoot, and it's causing me some confusion. I know the host has four on-board HDDs, but the format command's output shows c0t0d0, c0t1d0, c3t0d0, and c3t1d0. cfgadm -al shows c0t3d0 as the DVD-ROM drive, and c1 and c2 as SAN disks. Confused yet? ... (2 Replies)
Discussion started by: desertdenizen
2 Replies

5. Shell Programming and Scripting

PERL and Oracle 11.2 question

Hi, we have PERL 64-bit build with Oracle 10g DBD . PERL database connection are working fine. Database upgraded to 11.2 and in PERL documents it says still use 10g DBD to connect to 11.2. when I try some test connections, I am getting this error . Did anyone see this error before . I set the... (2 Replies)
Discussion started by: talashil
2 Replies

6. Solaris

Oracle Database 10g installation question

I wanted to ask how do i assign the control files and archive log to be stored in different volume? I didn't come through any selection for that during the GUI installation. :) Thanks in advance for any reply. p/s: I will appreciate it also if anyone can provide me a link for me to go... (1 Reply)
Discussion started by: beginningDBA
1 Replies

7. Shell Programming and Scripting

Question for calling oracle function from perl

Dear Sir/Madam, I use the following way to call the oracle stored procedure in a perl script, but I do not know how to call a oracle function by the following way ? # ARGV is the oracle stored procedure name with parameters $str = "sqlplus -s <<-eof \n" . "$db_login... (0 Replies)
Discussion started by: ili
0 Replies

8. Shell Programming and Scripting

Ps -ef | grep oracle question

Hi All, I have issued ps -ef | grep oracle command and i got these result oracle 356394 1 0 09:32:06 - 0:03 oracleCMS (LOCAL=NO) Now I can see user from here but I can not from which machine they are running this process. How can I see that? Thanks, Vishal (5 Replies)
Discussion started by: vishalpatel03
5 Replies

9. Red Hat

ORACLE RAC ASM disk question

Perhaps someone here has some experience with this. machine os RHE 4 6 oracle 10g RAC disk is SAN attached clariion. I have presented new disks to the host, so the machine sees all needed LUNS. powermt shows them, they are labeled and i have fdisk'd them. They are visible across all RAC... (5 Replies)
Discussion started by: Eronysis
5 Replies

10. UNIX for Dummies Questions & Answers

oracle and loop question

Hi All, I have a 2 questions; 1 is oracle and another is korn shell say TIME=20060928 desired output: 20060927 say TIME=20061001 DESIRED output: 20060930 If i substract one day from 'TIME' i am looking for previous day. can anyone please suggest me how do i do this is SQL. i... (4 Replies)
Discussion started by: pavan_test
4 Replies
Login or Register to Ask a Question