Forum Stats

  • 3,851,385 Users
  • 2,263,969 Discussions
  • 7,904,691 Comments

Discussions

Behaviour of Public Database Links/Public synonyms in Multi tenant architecture

Sada V
Sada V Member Posts: 11 Bronze Badge
edited May 29, 2019 4:44AM in Multitenant

Hi Gurus,

I need little help in this knowledge area of Multi tenant architecture of Oracle Database R12.2.

In our organization we have not implemented this architecture yet. 

I have few questions lingering in my mind about:

1.What happens to Public Database links. Suppose if I clone a PROD Database to QA/DEV, does the

  Public Database links are also cloned.  When they are cloned, how I can handle them in

  QA/DEV environment. Those links still point my PROD database ?

  or

  Can I clone PROD Database to QA/DEV/someother DB,  everything with the exception of like Public Database Links/

  Public synonyms

2.What happens when using public synonyms in pluggable databases?  Do other databases see those objects?

3.What are advantages/disadvantages using pluggable databases.

Please help me.  Thanks in advance

Answers

  • Markus Flechtner
    Markus Flechtner Member Posts: 503 Bronze Trophy
    edited May 22, 2019 2:35PM

    > 1.What happens to Public Database links. Suppose if I clone a PROD Database to QA/DEV, does the

    >  Public Database links are also cloned.  When they are cloned, how I can handle them in

    >  QA/DEV environment. Those links still point my PROD database ?

    Yes, they will. But you can change/re-create them after cloning with an AFTER-CLONE-Trigger which is fired in the new PDB,

    > Can I clone PROD Database to QA/DEV/someother DB,  everything with the exception of like Public Database Links/

    No, but you can drop the Public DB Links after cloning using an AFTER-CLONE-Trigger.

    > 2.What happens when using public synonyms in pluggable databases?  Do other databases see those objects?

    No.

    > 3.What are advantages/disadvantages using pluggable databases.

    There are multiple articles on blog posts on this topic.

    Try your favourite search engine or start with this one:

    https://oracle-base.com/articles/12c/multitenant-pluggable-databases-what-they-will-break-12cr1

    HTH

    Markus

    HTH

    Markus

    Sada V975799
  • Sada V
    Sada V Member Posts: 11 Bronze Badge
    edited May 23, 2019 10:14AM

    Thanks Markus, appreciates your response.

  • Praveen Ch-Oracle
    Praveen Ch-Oracle Member Posts: 12 Employee
    edited May 29, 2019 4:44AM

    Hi Sada V,

    A database link is created by executing a SQL statement. Therefore, such a statement must produce the same result in a PDB as it does in a non-CDB. By extension, you can create a database link from a PDB to a non-CDB, or from a non-CDB to a PDB — and these can cross a difference in Oracle Database software version in the same way as is supported between two non-CDBs.

    Thanks

    Praveen

    Please mark your question as answered or helpful if you find the above solution useful / correct, so that other community members can find the information easily. See Did Your Question Get Answered in My Oracle Support Community Note 1180503.1 document on how to do this.