CODEWITHSUNDEEP
oracle-databaseoracle-sqldeveloperoracle-ebsoracle12.2
abdulrahman
abdulrahman

Reputation: 13

How to connect to Oracle EBS R12 vision instance's database using SQL developer

I installed on my PC the oracle EBS R12 vision instance, and I'm able to use the application perfectly (i'm running it on VirtualBox within my Windows PC). But I could not connect to EBS vision instance database using SQL Developer.

What I need is to connect to the database of EBS vision instance using SQL Developer.

Some information you could need to understand the problem:

  1. I'm not sure about the username that i should use.
  2. I'm not sure about the Role u should use for that username.
  3. SQL developer is installed on my PC, while the vision instance is installed and run within a virtual machine using VirtualBox on top of my PC.

error message when i make the try to test the connection

Upvotes: 0

Views: 105

Answers (1)

Egret
Egret

Reputation: 799

Two potential issues here:

  • you need to ensure you can reach the VM internal addresses - need to configured bridged networking for this
  • EBS is configured by default to use the parameter TCP.INVITED_NODES in sqlnet.ora to specify which clients are allowed access to the database. This is functionality in the listener which will only allow clients to connect via TCP that are explicitly "invited" listed. The functionality is controlled via autoconfig (the EBS configuration mechanism). You can edit the sqlnet.ora directly (at risk of it being reverted at the next patch).

Upvotes: 0

Related Questions