Skip to Main Content
Forums

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

dblink between 9i and 12.2

User_M8BYZMay 7 2018 — edited May 8 2018

Is it possible to create a DBLink between a database on Oracle9i (9.2.0.6.0) and Oracle Database 12c (12.2.0.1.0) - 64bit?

I'm creating a new database using 12c and I want to be able to get my data from the current 9i database to the 12c database.

They are on 2 different servers.

1. Do I need to create an entry in the tnsnames.ora on either server or both?

2. Using oracle client 11.2.0.4 lets me connect to both databases and I can select from tables in both.  Do I need to install it on either server or both?

Thank you
This post has been answered by Hans Steijntjes on May 8 2018
Jump to Answer

Comments

Srinath Menon-Oracle 
Or do I have to create "Ent_DataArch_1_Role", "Ent_DataArch_2_Role"... in each of the databases they need access to?

It seems this is the only way to achieve this requirement.

AbbY-OC

Thanks Srinath,

Can OUD provide the solution to this then? We create a virtual group of databases and assign the user to that virtual group?

AbbY-OC

Hello OUD user community,
In the same thread - How is every one managing users & databases in their enterprise?
User_A needs access 5-Random databases
UserGroup_A needs access to a different set of databases
And so on...
Any suggestions would be a great help.
aBBy

Sandeep Kumar sk

@abby-oc Here is a reference/blog for implementing RBAC or Role-Based Access Control with CMU. There is a section on implementing RBAC with Active Directory. Hope this helps.

1 - 4
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Jun 5 2018
Added on May 7 2018
#9i, #general-database-discussions
10 comments
2,183 views