Oudated alert log [message #445769] |
Thu, 04 March 2010 00:49 |
reym21
Messages: 241 Registered: February 2010 Location: Philippines
|
Senior Member |
|
|
Our dev server has 7 instances on it (in one box). I noticed that most of it's alert logs are not up-to-date (generation is delayed by almost 1 week). What should I supposed to do with it?
Thanks.
|
|
|
|
|
|
|
Re: Oudated alert log [message #445960 is a reply to message #445954] |
Thu, 04 March 2010 22:30 |
|
BlackSwan
Messages: 26766 Registered: January 2009 Location: SoCal
|
Senior Member |
|
|
aaa-dev:/appl1/home/oracle734>date
Fri Mar 5 10:55:34 GMT 2010
aaa-dev:/appl1/home/oracle734>env | sort
AFS_DIR=/APPL/u03/devt/afs
ARS_DIR=/APPL/u03/devt/ars
AUD_DIR=/APPL/u03/devt/aud
BACKUP_TOOLS=/u01/dev/bin/itsdev01/backup
CASE_PS_CMD=lpr -Php
CASE_RESOURCE=case_aaa:vt100
CBR_DIR=/APPL/u03/devt/cbr
CGEN_HOME=/appl1/home/oracle/cgen20
CMS_DIR=/APPL/u03/devt/cms
DATESTAMP=05Mar10
DBA_TOOLS=/u01/appl/its/dba/tools
DBA_UTILS=/u01/appl/its/dba/tools
DEVFS=/u01/dev
EDITOR=vi
EREG_DIR=/APPL/u03/devt/ereg
EXINIT=set directory=/tmp
FORMS30PATH=/appl1/home/oracle/forms30/admin/resource/FRM
HOME=/appl1/home/oracle734
ITS_HOME=/APPL/u03/devt
LD_LIBRARY_PATH=/appl1/home/oracle734/lib
LOGNAME=oracle
MAIL=/var/mail//oracle
MANPATH=/usr/man:/usr/openwin/share/man:/opt/SUNWvxva/man:/opt/SUNWvxvm/man
MENU5PATH=/appl1/home/oracle/forms30/admin/resource/MNU
ORACLE_BASE=/appl1/home
ORACLE_HOME=/appl1/home/oracle734
ORACLE_PATH=/APPL/u03/devt/tec/bin:/APPL/u03/devt/reg/bin:/APPL/u03/devt/cbr/bin:/APPL/u03/devt/tas/bin:/APPL/u03/devt/rps/bin:/APPL/u03/devt/ars/bin:/APPL/u03/devt/cms/bin:/APPL/u03/devt/aud/bin:/APPL/u03/devt/afs/bin:/APPL/u03/devt/ereg/bin
ORACLE_SID=itsdev01
ORACLE_TERM=vt100
ORAENV_ASK=YES
ORAKITPATH=/appl1/home/oracle/dict50/admin/etc
ORATERMPATH=/appl1/home/oracle/forms30/admin/resource
PATH=/appl1/home/oracle734/bin:/usr/ccs/bin:/usr/bin:/usr/ucb:/etc:/appl1/home/oracle/bin:/APPL/u01/dev/util/pakawalan:.:/bin:/appl1/home/oracle/bin:/appl1/home/oracle734/bin:/appl1/home/oracle/bin:/APPL/u03/devt/tec/bin:/APPL/u03/devt/reg/bin:/APPL/u03/devt/cbr/bin:/APPL/u03/devt/tas/bin:/APPL/u03/devt/rps/bin:/APPL/u03/devt/ars/bin:/APPL/u03/devt/cms/bin:/APPL/u03/devt/aud/bin:/APPL/u03/devt/afs/bin:/APPL/u03/devt/ereg/bin:/APPL/u01/dev/util:/usr/ccs/bin:/u01/appl/its/dba/tools:/u01/home/database/scripts:/tmp:/appl1/home/oracle734/bin
PS1=aaa-dev:$PWD>
PWD=/appl1/home/oracle734
RPS_DIR=/APPL/u03/devt/rps
SDD_HOME=/appl1/home/oracle/dict50/admin
SDD_PRINT=lp -o nobanner -dhp
SDD_WPRINT=textps -landscape -printer hp
SHELL=/bin/ksh
SQLPATH=/u01/appl/its/dba/tools
SRW_TMP=/tmp
SSH_CLIENT=999.99.9.99 1868 22
SSH_CONNECTION=999.99.9.99 1868 xxx.xx.xx.xx 22
SSH_TTY=/dev/pts/19
SYSFS=/u01/sys
TAS_DIR=/APPL/u03/devt/tas
TEC_DIR=/APPL/u03/devt/tec
TERM=vt100
TMPDIR=/tmp
TRGFS=/u01/itstrg01
TZ=GMT+8
USER=oracle
_=/usr/bin/env
aaa-dev:/appl1/home/oracle734>uptime
10:55am 11 users, load average: 44.83, 43.36, 42.05
aaa-dev:/appl1/home/oracle734>ps -ef| grep -i pmon
oracle 4464 2988 0 11:09:38 pts/19 0:00 grep -i pmon
oracle 25925 1 0 Feb 24 ? 0:00 ora_pmon_ltd
oracle 28762 1 0 Feb 23 ? 0:00 ora_pmon_itsdev01
oracle 1232 1 0 Feb 23 ? 0:00 ora_pmon_stgmla
oracle 15717 1 0 Feb 23 ? 0:00 ora_pmon_cdf
oracle 23936 1 0 Feb 23 ? 0:00 ora_pmon_r1_rdc
oracle 20923 1 0 Feb 23 ? 0:00 ora_pmon_makati
oracle 17979 1 0 Feb 23 ? 0:00 ora_pmon_cdf_2
oracle 26353 1 0 Feb 23 ? 0:00 ora_pmon_r1_no
aaa-dev:/appl1/home/oracle734>lsnrctl service
LSNRCTL for Solaris: Version 2.3.4.0.0 - Production on 05-MAR-10 10:55:56
Copyright (c) Oracle Corporation 1994. All rights reserved.
Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=aaa-dev)(PORT=xxxx))
Services Summary...
cdf has 5 service handler(s)
DEDICATED SERVER established:1 refused:0
DISPATCHER established:4088 refused:0 current:0 max:60 state:ready
D000 (machine: aaa-dev, pid: 16252)
(ADDRESS=(PROTOCOL=tcp)(DEV=x)(HOST=xxx.xx.xx.xx)(PORT=xxxxx))
DISPATCHER established:5286 refused:0 current:0 max:60 state:ready
D001 (machine: aaa-dev, pid: 16297)
(ADDRESS=(PROTOCOL=tcp)(DEV=x)(HOST=xxx.xx.xx.xx)(PORT=xxxxx))
DISPATCHER established:754 refused:0 current:0 max:60 state:ready
D002 (machine: aaa-dev, pid: 16349)
(ADDRESS=(PROTOCOL=tcp)(DEV=x)(HOST=xxx.xx.xx.xx)(PORT=xxxxx))
DISPATCHER established:994 refused:0 current:0 max:60 state:ready
D003 (machine: aaa-dev, pid: 16391)
(ADDRESS=(PROTOCOL=tcp)(DEV=x)(HOST=xxx.xx.xx.xx)(PORT=xxxxx))
cdf_2 has 5 service handler(s)
DEDICATED SERVER established:0 refused:0
DISPATCHER established:32 refused:0 current:0 max:82 state:ready
D000 (machine: aaa-dev, pid: 18527)
(ADDRESS=(PROTOCOL=tcp)(DEV=x)(HOST=xxx.xx.xx.xx)(PORT=xxxxx))
DISPATCHER established:21 refused:0 current:0 max:82 state:ready
D001 (machine: aaa-dev, pid: 18572)
(ADDRESS=(PROTOCOL=tcp)(DEV=x)(HOST=xxx.xx.xx.xx)(PORT=xxxxx))
DISPATCHER established:7 refused:0 current:0 max:82 state:ready
D002 (machine: aaa-dev, pid: 18601)
(ADDRESS=(PROTOCOL=tcp)(DEV=x)(HOST=xxx.xx.xx.xx)(PORT=xxxxx))
DISPATCHER established:6 refused:0 current:0 max:82 state:ready
D003 (machine: aaa-dev, pid: 18661)
(ADDRESS=(PROTOCOL=tcp)(DEV=x)(HOST=xxx.xx.xx.xx)(PORT=xxxxx))
itsdev01 has 4 service handler(s)
DEDICATED SERVER established:0 refused:0
DISPATCHER established:87 refused:0 current:0 max:170 state:ready
D000 (machine: aaa-dev, pid: 29512)
(ADDRESS=(PROTOCOL=tcp)(DEV=x)(HOST=xxx.xx.xx.xx)(PORT=xxxxx))
DISPATCHER established:46 refused:0 current:0 max:170 state:ready
D001 (machine: aaa-dev, pid: 29561)
(ADDRESS=(PROTOCOL=tcp)(DEV=x)(HOST=xxx.xx.xx.xx)(PORT=xxxxx))
DISPATCHER established:44 refused:0 current:0 max:170 state:ready
D002 (machine: aaa-dev, pid: 29601)
(ADDRESS=(PROTOCOL=tcp)(DEV=x)(HOST=xxx.xx.xx.xx)(PORT=xxxxx))
ltd has 5 service handler(s)
DEDICATED SERVER established:17 refused:0
DISPATCHER established:73 refused:0 current:1 max:200 state:ready
D000 (machine: aaa-dev, pid: 26560)
(ADDRESS=(PROTOCOL=tcp)(DEV=x)(HOST=xxx.xx.xx.xx)(PORT=xxxxx))
DISPATCHER established:58 refused:0 current:0 max:200 state:ready
D001 (machine: aaa-dev, pid: 26620)
(ADDRESS=(PROTOCOL=tcp)(DEV=x)(HOST=xxx.xx.xx.xx)(PORT=xxxxx))
DISPATCHER established:55 refused:0 current:0 max:200 state:ready
D002 (machine: aaa-dev, pid: 26676)
(ADDRESS=(PROTOCOL=tcp)(DEV=x)(HOST=xxx.xx.xx.xx)(PORT=xxxxx))
DISPATCHER established:38 refused:0 current:0 max:200 state:ready
D003 (machine: aaa-dev, pid: 26724)
(ADDRESS=(PROTOCOL=tcp)(DEV=x)(HOST=xxx.xx.xx.xx)(PORT=xxxxx))
makati has 5 service handler(s)
DEDICATED SERVER established:0 refused:0
DISPATCHER established:455 refused:0 current:3 max:300 state:ready
D000 (machine: aaa-dev, pid: 21463)
(ADDRESS=(PROTOCOL=tcp)(DEV=x)(HOST=xxx.xx.xx.xx)(PORT=xxxxx))
DISPATCHER established:341 refused:0 current:3 max:300 state:ready
D001 (machine: aaa-dev, pid: 21509)
(ADDRESS=(PROTOCOL=tcp)(DEV=x)(HOST=xxx.xx.xx.xx)(PORT=xxxxx))
DISPATCHER established:356 refused:0 current:3 max:300 state:ready
D002 (machine: aaa-dev, pid: 21553)
(ADDRESS=(PROTOCOL=tcp)(DEV=x)(HOST=xxx.xx.xx.xx)(PORT=xxxxx))
DISPATCHER established:352 refused:0 current:2 max:300 state:ready
D003 (machine: aaa-dev, pid: 21601)
(ADDRESS=(PROTOCOL=tcp)(DEV=x)(HOST=xxx.xx.xx.xx)(PORT=xxxxx))
r1_no has 5 service handler(s)
DEDICATED SERVER established:0 refused:0
DISPATCHER established:47 refused:0 current:0 max:115 state:ready
D000 (machine: aaa-dev, pid: 26896)
(ADDRESS=(PROTOCOL=tcp)(DEV=x)(HOST=xxx.xx.xx.xx)(PORT=xxxxx))
DISPATCHER established:40 refused:0 current:0 max:115 state:ready
D001 (machine: aaa-dev, pid: 26931)
(ADDRESS=(PROTOCOL=tcp)(DEV=x)(HOST=xxx.xx.xx.xx)(PORT=xxxxx))
DISPATCHER established:18 refused:0 current:0 max:115 state:ready
D002 (machine: aaa-dev, pid: 26964)
(ADDRESS=(PROTOCOL=tcp)(DEV=x)(HOST=xxx.xx.xx.xx)(PORT=xxxxx))
DISPATCHER established:12 refused:0 current:0 max:115 state:ready
D003 (machine: aaa-dev, pid: 27031)
(ADDRESS=(PROTOCOL=tcp)(DEV=x)(HOST=xxx.xx.xx.xx)(PORT=xxxxx))
r1_rdc has 1 service handler(s)
DEDICATED SERVER established:159 refused:0
stgmla has 1 service handler(s)
DEDICATED SERVER established:632 refused:0
The command completed successfully
aaa-dev:/appl1/home/oracle734>uname -a
SunOS aaa-dev 5.8 Generic_117350-25 sun4u sparc SUNW,Ultra-4
I was not expecting to see SHARED SEVER.
racle 25925 1 0 Feb 24 ? 0:00 ora_pmon_ltd
oracle 28762 1 0 Feb 23 ? 0:00 ora_pmon_itsdev01
oracle 1232 1 0 Feb 23 ? 0:00 ora_pmon_stgmla
oracle 15717 1 0 Feb 23 ? 0:00 ora_pmon_cdf
oracle 23936 1 0 Feb 23 ? 0:00 ora_pmon_r1_rdc
oracle 20923 1 0 Feb 23 ? 0:00 ora_pmon_makati
oracle 17979 1 0 Feb 23 ? 0:00 ora_pmon_cdf_2
oracle 26353 1 0 Feb 23 ? 0:00 ora_pmon_r1_no
To 4 decimal places what are versions of each?
[Updated on: Thu, 04 March 2010 22:43] Report message to a moderator
|
|
|
|