Forum Discussion

moritzbartram's avatar
moritzbartram
Frequent Visitor
10 months ago
Solved

Mirrored Oracle Error

Hi everyone,  I'm having trouble to create a mirrored oracle item. I've followed the set-up guide and configured my oracle database accordingly, but get the following error:    The message a...
data engineering
  • moritzbartram's avatar
    moritzbartram
    10 months ago

    Hi v-kpoloju-msft,

     

    thanks again for your reply. I've already been in contact with the fabric support team and they confirmed that the error I'm getting results from the amount of tables ~10000 that are in my database and they cannot be displayed. So this is just a UI error that can be circumvented by creating mirror items via Rest-API. 

    Thanks again for your help! 

    Best regards

moritzbartram's avatar
moritzbartram
Frequent Visitor
10 months ago

Hi v-kpoloju-msft,

 

thanks for your reply! The gateway I'm using work fine for the connection when I try to access the data via a copy activity (within a pipeline), then I can see all my tables and preview my data. 
After inspecting the gateway logs I can see that errors appeared when I tried to set up the mirrored database, but I don't get relevant information out of it. 
The error is: 'Unable to open the Server service performance object. The first four bytes (DWORD) of the Data section contains the status code.'
The gateway version is 3000.282.5. 

I already tried restarting the gateway. Do you have any other idea? 
Thank you!

spaceman127's avatar
spaceman127
Super User
10 months ago

Hi moritzbartram ,

 

I ran some tests yesterday with Oracle Database version 19.3.

I also had a lot of problems at the beginning.

 

Maybe we can solve this.

I have the following questions.

 

1. Which Oracle version are you using?

2. I assume the Data Gateway is up to date?

3. Have you installed the Oracle Client and adjusted the tnsnames.ora accordingly?

4. Does your user have the permissions? Have you tested this with SQL Developer or SQL Plus?

 

If you have any questions, just let me know.

 

Best regards