fal server fal client

Robeen

Oracle DB 12.1.0.2 on source and destination

Hi,

I would like to have same SID on both primary and standby.

The TNS entries are shown below:

--standbyentry

DWDR =

  (DESCRIPTION =

    (ADDRESS = (PROTOCOL = TCP)(HOST = dwaredr)(PORT = 1521))

    (CONNECT_DATA =

      (SERVER = DEDICATED)

      (SERVICE_NAME = dware1)

    )

  )

--primary entry

DWARE =

  (DESCRIPTION =

    (ADDRESS = (PROTOCOL = TCP)(HOST = dware-scan)(PORT = 1521))

    (CONNECT_DATA =

      (SERVER = DEDICATED)

      (SERVICE_NAME = dware1)

    )

  )

Can I set the FAL_server and FAL_CLIENT to dware1?

Regards,

Joe

Sunny kichloo

Why are you trying have same sid?

Robeen

I have same issue as

Data guard configuration with same SID

for reporting purposes. The SID is hardcoded in reports.

Shaik Ahmed Ali Bajubair

for the fal_server and fal_client you need to use the value in the oracle net service name not the SID. for example in your case

Fal_server = DWARE 

Fal_client = DWDR

Note : from 11g Fal_client is no longer required