Login or Register to Ask a Question and Join Our Community


Shell Programming and Scripting

Ps -ef | grep oracle question

Login to Discuss or Reply to this Discussion in Our Community

 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Ps -ef | grep oracle question
# 1  
Old 02-21-2008
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
# 2  
Old 02-21-2008
You can issue a select on the db like this:
Code:
select s.machine from v$session s, v$process p where s.paddr=p.addr and spid=&ospid;

For finding the same info without the need to connect to the db, I think you may try with "pfiles <ospid>" and see the open sockets from which machine/IP address they come.
# 3  
Old 02-21-2008
I don't want to find out from oracle. How can I do that in UNix?

Thanks,
Vishal
# 4  
Old 02-21-2008
If you are on Solaris, use pfiles. Otherwise I really don't know and I think it depends on the platform. What's your OS?
# 5  
Old 02-21-2008
it is AIX 5.2
# 6  
Old 02-28-2008
You can try the listener.log. on Aix it should be in the $ORACLE_HOME/network/admin directory. It may help.
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. UNIX and Linux Applications

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... (2 Replies)
Discussion started by: Mr. Zer0
2 Replies

7. 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

8. 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

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