[resolved] Problem in toracleoutput in talend

One Star

[resolved] Problem in toracleoutput in talend

hi all,
I am using oracle 10g Express edition .
When i tried to load the data from toracleinput DB to ToracleoutputDB ,
i am facing the below error in toracleoutput
Exception in component tOracleOutput_1
java.sql.SQLException: ORA-28009: connection as SYS should be as SYSDBA or SYSOPER
can anyone help on this...

Accepted Solutions
Community Manager

Re: [resolved] Problem in toracleoutput in talend

Hi
As the error message said, connection as SYS user should be as SYSDBA or SYSOPER, user SYS are not allowed to connect to Oracle server in JDBC. To resolve the problem, use another user such as system or a new user.
----------------------------------------------------------
Talend | Data Agility for Modern Business

All Replies
Community Manager

Re: [resolved] Problem in toracleoutput in talend

Hi
As the error message said, connection as SYS user should be as SYSDBA or SYSOPER, user SYS are not allowed to connect to Oracle server in JDBC. To resolve the problem, use another user such as system or a new user.
----------------------------------------------------------
Talend | Data Agility for Modern Business
One Star

Re: [resolved] Problem in toracleoutput in talend

Hi shong,
Thanks , its working.....

Calling Talend Open Studio Users

The first 100 community members completing the Open Studio survey win a $10 gift voucher.

Start the survey

2019 GARNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

What’s New for Talend Summer ’19

Watch the recorded webinar!

Watch Now

Talend Studio Improvements for API Services

Taken a look at the Talend Studio improvements for API Services

Watch Now

Data Integration Success Stories

Take a look at some Data Integration success stories

Read