Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

Oracle Failsafe Logging - fslservername log

Posted on 2004-09-06
3
Medium Priority
?
2,048 Views
Last Modified: 2012-05-05
Hello

I would appreciate if anyone can advise on the following scenario on a subject that at present our organisation does not have a great deal of knowledge.  In our environment we are running a COTS document management system using Oracle 9i as the backend database.  In our core offices this system has been configured in in a MSCS environment with Oracle Failsafe.  This cluster environment is configured in an active/passive mode.

In the oracle application folders on both server nodes oracle fail safe generates a log file in the ora92\network\log folder .  This file is called fslservername.log.  On investigation we have discovered that this log is only updated on the server that is active.  Whilst logging entries are made approximatley 4 times a minute.  A sample of the entries are as follows:

"06-SEP-2004 13:25:32 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=)(USER=erdm_cluster))(COMMAND=status)(ARGUMENTS=64)(SERVICE=Fslmc35glera)(VERSION=153092352)) * status * 0
06-SEP-2004 13:25:45 * (CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=MC34.MC34GLERC.scotland.gov.uk)(CID=(PROGRAM=E:\Objective\Objective 6i SP3 Server\bin\objindex.exe)(HOST=MC35GLERA)(USER=objective))) * (ADDRESS=(PROTOCOL=tcp)(HOST=10.12.128.97)(PORT=3186)) * establish * MC34.MC34GLERC.scotland.gov.uk * 0
06-SEP-2004 13:26:15 * (CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=MC34.MC34GLERC.scotland.gov.uk)(CID=(PROGRAM=E:\Objective\Objective 6i SP3 Server\bin\objindex."

Regarding this log file I would appreciate if anyone can help on the following points:

What is failsafe generating when writing to this log and should it be checked frequently.  

Is it safe to archive these logs on routinely basis. If so what frequency would be recommended, daily, weekly, monthly etc.


Assistance in this request would be greatly appreciated.

0
Comment
Question by:GraemeTL
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
3 Comments
 
LVL 7

Accepted Solution

by:
BobMc earned 500 total points
ID: 11990720
This is a listener log file, and will contain an entry for each 'action' requested on the listener - user connections, change of listener config, listener start/stop etc. This explains why you dont get anything reported on your passive node!

The information is purely informational, and is not required by any part of the system - consider it an audit trail.

You can safely ignore it or turn off the logging in your ora92\network\admin\listener.ora file.

On most systems I support, I change the logfile name once a month, and delete / archive off the old one. How often you would want to do this will depend on the size of the files, which in turn usually depends on the number and frequency of user connections.

HTH
Bob
0
 

Author Comment

by:GraemeTL
ID: 11990850
Thanks very much. This makes perfect sense.  This will now help us correctly archive as per usage as the system grows.

Thanks again.
0
 
LVL 7

Expert Comment

by:BobMc
ID: 11990890
No probs - good luck!
0

Featured Post

Get free NFR key for Veeam Availability Suite 9.5

Veeam is happy to provide a free NFR license (1 year, 2 sockets) to all certified IT Pros. The license allows for the non-production use of Veeam Availability Suite v9.5 in your home lab, without any feature limitations. It works for both VMware and Hyper-V environments

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Note: this article covers simple compression. Oracle introduced in version 11g release 2 a new feature called Advanced Compression which is not covered here. General principle of Oracle compression Oracle compression is a way of reducing the d…
From implementing a password expiration date, to datatype conversions and file export options, these are some useful settings I've found in Jasper Server.
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function
Via a live example, show how to restore a database from backup after a simulated disk failure using RMAN.

721 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question