Connection to Oracle Database

Have you tried the Knowledge-base: https://warewolf.io/knowledge-base/new-database-source/

Yes, I have read. I'm successfully connect to MSSQL database, but get an error in Oracle Database.

Put the port in the server address: 192.168.50.30:1521.

Still not connected.

I'm also try 10.222.50.181:1521/orcl also not connected.

FYI, the database connected with the info above when using Oracle Sql Developer.

Hi,

Please use the server as "10.222.50.181:1521/orcl"

Where orcl is the SID.

Thanks

Hi Genie, Thank you for reply. Still not connect into oracle database. I have try using Oracle SQL Developer, the connection status is Success.

Hi,

If you navigate in your windows explorer to %PROGRAMDATA%\Warewolf\Server Log\

there is a wareWolf-Server.log file in that folder. Can you please send us that file?

Thanks

Could you please give me your email address? Or should I paste the server-log content here?

Hi,

You can attach the file in your comment.

Thanks

wareWolf-Server.log

Thanks

Hi,

Thanks for the log file. The error is : ORA-00942: table or view does not exist

based on some googling this error occurs if the user does not have any tables associated with it or does not have access to get a list of tables. Please see and ensure that the user you are connecting with is correctly set up (http://dba.stackexchange.com/questions/47074/getting-ora-00942-table-or-view-does-not-exist-while-table-does-exist)

I will log an item into our backlog to have the Error message to show the underlying message. That would have made this issue far easier to resolve.

Thanks for your patience and help in resolving this issue.

Hi,

The user information I enter in Warewolf is correct and I have try connect the database using Oracle Sql Developer and it's successfully connected.

Thanks

Hi,

What tables are shown in Sql Developer after you connect?

Thanks

I have created new table as below. But still not connect.

It's connected now. I have create new user and give all privilege and successfully connected. Thank you so much and it's appreciated.

Hi,

Please ensure that privileges to that table and user is setup correctly. Please try the following article to diagnose the problem: http://stackoverflow.com/questions/16129912/sql-error-ora-00942-table-or-view-does-not-exist

As shown in above connecting does not necessarily mean that you can query for tables or databases.

Please execute the following command in Sql Developer when connected as the SPBO user:

SELECT DISTINCT(OWNER) AS DATABASE_NAME FROM DBA_SEGMENTS WHERE OWNER IN (SELECT USERNAME FROM DBA_USERS WHERE DEFAULT_TABLESPACE NOT IN ('SYSTEM','SYSAUX'));

Thanks

Hi. Why are the database choices are limited to:

Should it be include 'SPBO2' as if in normal oracle query it will be SELECT * FROM SPBO2.TABLENAME

Thank you

Support for Oracle can be found on the Oracle website. If this issue relates to Warewolf, please create a new ticket with steps to reproduce.