Home » RDBMS Server » Server Administration » Oudated alert log (Oracle 7.3.4, Solaris 8)
Oudated alert log [message #445769] Thu, 04 March 2010 00:49 Go to next message
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 #445773 is a reply to message #445769] Thu, 04 March 2010 01:21 Go to previous messageGo to next message
Michel Cadot
Messages: 68711
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
Explain what you mean with " I noticed that most of it's alert logs are not up-to-date (generation is delayed by almost 1 week)."
How do you notice that?
Where do you notice that?
What do you actually notice?

Regards
Michel
Re: Oudated alert log [message #445944 is a reply to message #445773] Thu, 04 March 2010 18:29 Go to previous messageGo to next message
reym21
Messages: 241
Registered: February 2010
Location: Philippines
Senior Member

We always monitor our alert logs re: $ORACLE_HOME/admin/<SID>/bdump, what I noticed was that the generation of alert log should be in the same day (ex. right now's current date is Mar 5, 2010, but the generation date of most of our alert log is way back Feb. 26, 2010). See captured screen shot.

Thanks.
Re: Oudated alert log [message #445945 is a reply to message #445944] Thu, 04 March 2010 18:37 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
post results from following commands
CUT lines below & PASTE into terminal window

date
env | sort
uptime
ps -ef | grep -i pmon
lsnrctl service
uname -a
date

CUT the results & PASTE all back here
Re: Oudated alert log [message #445954 is a reply to message #445769] Thu, 04 March 2010 21:39 Go to previous messageGo to next message
reym21
Messages: 241
Registered: February 2010
Location: Philippines
Senior Member

As requested... pls. find attached file.

Thanks very much.
Re: Oudated alert log [message #445960 is a reply to message #445954] Thu, 04 March 2010 22:30 Go to previous messageGo to next message
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

Re: Oudated alert log [message #445971 is a reply to message #445960] Thu, 04 March 2010 23:46 Go to previous message
reym21
Messages: 241
Registered: February 2010
Location: Philippines
Senior Member

This are all running under Oracle 7.3.4.5.0/ Solaris 8
Previous Topic: Error in creating database
Next Topic: RC-50004 in adcfgclone.pl in db tier
Goto Forum:
  


Current Time: Sat Nov 09 19:45:05 CST 2024