Oracle Dataguard 9i

[Former Member]

Hi Gurus,

I am configuring Oracle Dataguard for 9i. Currently my database has the same DBSID on both primary and standby.

This effect my listener communication between primary and standby because the listener has the same SID.

How can I differentiate the listener SID's on both system. Is it possible to add SERVICE_NAMES in my init.ora file and then add this parameter to my listener file?

primaryINIT.ora

db_name = 'PRD'

service_names = 'primary'

standbyINIT.ora

db_name = 'PRD'

service_names = 'secondary'

Any body has better suggestion? Appreciate your feedback.

Thanks,

IA

[stefan_koehler]

Hello,

my sugesstion - upgrade your database to Oracle 10g R2 or later.

Oracle 9i R2 is out of support and Data Guard is much better in higher releases.

Regards

Stefan

[Former Member]

Thanks Stefan.

However my client still insists on Oracle 9i.

If you could provide good suggestion with Oracle 9, your most welcome.

[Former Member]

Hi,

I am updating my findings. For oracle 9, we can use services_name replacing db_unique_name (Oracle 10).

From there we just configure our tnsnames.ora for it to communicate both sides.

All the best.

Cheers,

IA