Search Results

hello

can help to script to find the listener is up or down for diferent db

i have 2 listener

ps -fea |grep tns
root 17333 17559 0 12:26:38 pts/3 0:00 grep tns
oracle 3800 ...

hello

its windows server 2003

how to find the user owner to install the oracle

on linux ps -fea | grep pmon

$ps -fea| grep pmon
oracle 2950 1 0 Sep 13 ? 262:19...

hello Cero.


the oratab is not configured almost all servers.

i try to execute but its not work only find one

My db :
My home:
Error 6 initializing SQL*Plus
Message file sp1<lang>.msb...

Hello Cero


I will try another server and it works.
but in some the oracle_home short puts the address
example:

My db : DB2
my Home: /opt/oracle


another database
correct

My db :...

hello Cero

thanks a lot.

it works.

:D:b:

hello Scrutinizer.

in my script I have this result:

10286 ora_pmon_bd1 => /oracle/10.2
10431 ora_pmon_bd2 => /oracle/10.2
11728 ora_pmon_bd3 => /oracle/10.2
11882 ora_pmon_bd4 =>...

query
pgrep -lf ora_pmon |
> while read p a; do
> printf '%s %-15s => %s\n' "$p" "$a" \
> "$( dbhome "${a#ora_pmon_}" )"
> done


10286 ora_pmon_bd1 => /oracle/10.2
10431 ora_pmon_bd2 =>...

hello
i try to made a report to conect all database to diferent OS
HP-UX/LINUX/SOLARIS/AIX
this is my example
i have 5 db
OS are HP-UX
ps -fea | grep pmon
root 1120 1 0 Nov 29 ? ...

Hello Don Cragun,

its Works

thanks!

hi yoda

this is result
pgrep -fl _pmon_ | sed 's#.*_pmon_##'
/usr/bin/ksh: pgrep: not found

=(
OS HP-UX

hello
when a write this code
[oracle9i]$ ps -fea | grep pmon
result:
root 1515 1 0 Feb 9 ? 0:10 ipmon -sD
oracle9i 18357 1 0 Feb 9 ? 1:04 ora_pmon_db1_PROD...