Skip to Main Content

Oracle Database Express Edition (XE)

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!

2 issues : Invisible user and Invisible table from BI reporting

User_ACOBQJul 10 2020 — edited Jul 12 2020

Hello,

I have created 2 users : "USER1" and "C##USER2".

1- USER1 : I connected Power BI and Qlik sense to the database but the "USER1" is not visible from Power BI and Qlik sense (with SQL plus and SQL developper the user is visible)

2- C##USER2 : I created a new table in this user, the C##USER2 is visible from "Power BI "and "Qlik sense" but not the table

I tryed 2 tools to know if the problem coms from the BI tools or from the database, maybe parameters to add in the database ?

Thanks a lot for your help.

best regards.

This post has been answered by cormaco on Jul 11 2020
Jump to Answer

Comments

cormaco

Please change your display name into something readable:

How can I change my Display Name?

Also post your exact database version, use "select * from v$version" to find out.

The username C##USER2 is typical for a common user in the CDB$ROOT database, you shouldn't create you own users there except for special purposes.

The user USER1 has probably been created in a PDB.

https://oracle-base.com/articles/12c/multitenant-manage-users-and-privileges-for-cdb-and-pdb-12cr1#create-common-users

You can find more information on Oracle's Multitenant Architecture here:

https://oracle-base.com/articles/12c/multitenant-overview-container-database-cdb-12cr1#overview

Can you show us the exact connect strings you use to connect in BI-Publisher, Qlik and SQLPlus, SQL Developer repectively?

User_ACOBQ

Thanks for your answer. I wanted just to know what is the right way to create users, fill them with tables and data, user the right connexions to be able to see the users, tables and data from the reportings BI tools ? Thanks a lot.

1- The databse version :

SQL> select * from v$version;

BANNER

--------------------------------------------------------------------------------

BANNER_FULL

--------------------------------------------------------------------------------

BANNER_LEGACY

--------------------------------------------------------------------------------

CON\_ID

----------

Oracle Database 18c Express Edition Release 18.0.0.0.0 - Production

Oracle Database 18c Express Edition Release 18.0.0.0.0 - Production

Version 18.4.0.0.0

Oracle Database 18c Express Edition Release 18.0.0.0.0 - Production

     0

BANNER

--------------------------------------------------------------------------------

BANNER_FULL

--------------------------------------------------------------------------------

BANNER_LEGACY

--------------------------------------------------------------------------------

CON\_ID

----------

2- you fin the connexions setting in the Screenshots (I used the tnsname automatikly created by oracle)

SQLDEV.PNG

SQLDEV.PNGPower Bi databse connexion.PNGQlik Sense databse connexion.PNG

User_ACOBQ

I Forget other screenshots, sorry : Qlik Sense databse connexion.PNG

cormaco
Answer

Your connection in SQL Developer is to xepdb1.

This is the default PDB in an Oracle 18XE installation, you are supposed to work with that.

The connection in your other screenshots is to XE, this is the CDB$ROOT and as I said you should not create users there.

Unfortunately Oracle does not create an entry for xepdb1 in TNSNAMES.ORA during installation.

Use xepdb1 as in SQL Developer.

Marked as Answer by User_ACOBQ · Sep 27 2020
User_ACOBQ

Hi cormaco,

Thanks a lot for your helpful answer, it working fine now for Power Bi and Qlik sens.

1- Qlik Sens : I you saifd before, I just replaced the service name from XE to XEPDB1

Qlik Sense OK.PNG

2- Power BI : I changed the tnsname from XE to XEPDB1 :

Tnsname.PNG

In the connexion server i fill : XEPDB1 :

Power BI OK - 1.PNG

All is working fine, really thanks a lot for your help, have a nice day.

Best regards

cormaco

2- Power BI : I changed the tnsname from XE to XEPDB1 :

That is not enough, you have to change the servicename to XEPDB1 as well. As it is now you have only gives the connection to XE a new name

User_ACOBQ

Yes you are right, I changed also the servicename from XE to XEPDB1, Thanks a lot

1 - 7

Post Details

Added on Jul 10 2020
7 comments
1,073 views