[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.....