Rfs: Possible Network Disconnect With Primary Database' In Standby Alert Log (Doc ID 397014.1)

In this Document

APPLIES TO:Oracle Database - Enterprise Edition - Version 9.0.1.0 to 12.1.0.2 [Release 9.0.1 to 12.1]
Information in this document applies to any platform.
***Checked for relevance on 31-AUG-2012***
***Checked for relevance on 8-Jul-2015***


SYMPTOMS

Standby alert log reports fallowing errors:

RFS: Possible network disconnect with primary database
Standby database ID mismatch [0xAAAA:0xBBBBB]

Archive log transfer/apply to this standby database works fine.

CAUSE

The (error) message may be triggered by another database that has log_archive_dest_X pointing to standby instance of (error) message .

The RFS process tries to communicate with the instance.

SOLUTION

Check if you have DB with mismatched database ID and its log_archive_dest_X parameter value.

If found a database, which is not included in the current in primary/standby configuration, disable log_archive_dest_2 to the instance:

ie:

From the error message of "Standby database ID mismatch [0xAAAA:0xBBBBB]"

Convert the hex number of first argument, 0xAAAA to decimal value using calculator

Then search db with the dbid.


SQL> select dbid from v$database;

SQL> alter system set log_archive_dest_state_x=disable;

Offline install of .NET Framework 3.5 in Windows 10 using DISM

Windows 10 comes with .NET framework 4.5 pre-installed, but many apps developed in Vista and Windows 7 era require the .NET framework v3.5 installed along with 4.5. These apps will not run unless you will install the required version. When you try to run any such app, Windows 10 will prompt you to download and install .NET framework 3.5 from the Internet. However, this will take a lot of time. You can save your time and install .NET Framework 3.5 from the Windows 10 installation media. This method is much faster and does not even require an Internet connection. Here is how to install it.

RECOMMENDED: Click here to fix Windows errors and optimize system performance

To install .NET Framework 3.5 in Windows 10, do the following:

1. Insert your Windows 10 DVD, or double click its ISO image, or insert your bootable flash drive with Windows 10, depending on what you have.
2. Open 'This PC' in File Explorer and note the drive letter of the installation media you have inserted. In my case it is disk D:
   
3. Now open an elevated command prompt and type the following command:

   Dism /online /enable-feature /featurename:NetFX3 /All /Source:D:\sources\sxs /LimitAccess

   Replace D: with your drive letter for Windows 10 installation media.
   

You are done! This will install .NET framework 3.5 in Windows 10.

To save your time, I have prepared a simple batch file which will save your time and will find the inserted installation media automatically. It looks like this:

@echo off
Title .NET Framework 3.5 Offline Installer
for %%I in (D E F G H I J K L M N O P Q R S T U V W X Y Z) do if exist "%%I:\\sources\install.wim" set setupdrv=%%I
if defined setupdrv (
echo Found drive %setupdrv%
echo Installing .NET Framework 3.5...
Dism /online /enable-feature /featurename:NetFX3 /All /Source:%setupdrv%:\sources\sxs /LimitAccess
echo.
echo .NET Framework 3.5 should be installed
echo.
) else (
echo No installation media found!
echo Insert DVD or USB flash drive and run this file once again. 
echo.
)
pause

Download the file, extract it from the ZIP archive to the Desktop, right click it and choose Run as administrator. The file will install .NET Framework 3.5 automatically after finding the drive letter of your Windows 10 installation media.

Click here to download the batch file.

How To Run Diagnostic: Apps Check (OMCHECK) From A Financials Responsibility? (Doc ID 460813.1)
R11i/12: GL/AP/FA/AR/PM: 

GOAL

This diagnostic is used to locate the current versions of files you have running on your system.  This document will show you how to setup the Diagnostic: Apps Check (OMCHECK) request to be available in a Financials Responsibility.

SOLUTION

In order to be able to see and use Diagnostic: Apps Check from a Financials Responsibility (like FA, GL, AR, AP, PN, and so on) the following steps need to be performed:

1.  Responsibility:  System Administrator responsibility and go to Request Groups form:

Navigation:  Security > Responsibility > Request

2.  Query for Application: Application Name and Group: All Reports and Programs.

Application Name can be one of the following:  Assets, General Ledger, Receivables, Payables, Property Manager and so on.

3.  Add a new Program under Requests title and enter Diagnostics: Apps Check for the desired Name

4. Save work

ORA-00020: maximum number of processes (500) exceeded

How to increase PROCESSES initialization parameter:

1. Login as sysdba
sqlplus / as sysdba

or

sqlplus /nolog

SQL*Plus: Release 11.2.0.3.0 Production on Wed Oct 4 11:32:29 2017
Copyright (c) 1982, 2011, Oracle. All rights reserved.

SQL> connect sys/oracle as sysdba

Connected.

2. Check Current Setting of Parameters
sql> show parameter sessions
sql> show parameter processes
sql> show parameter transactions

3. If you are planning to increase "PROCESSES" parameter you should also plan to increase "sessions and "transactions" parameters
A basic formula for determining these parameter values is as follows:

processes=x
sessions=x*1.1+5
transactions=sessions*1.1

4. These paramters can't be modified in memory. You have to modify the spfile only (scope=spfile) and bounce the instance.
sql> alter system set processes=500 scope=spfile;
sql> alter system set sessions=555 scope=spfile;
sql> alter system set transactions=610 scope=spfile;
sql> shutdown abort
sql> startup