Invalid Runtime Schema

[ravivarma]

i have done a mapping between source(flatfile) and target(oracle) using Oracle warehouse Builder.Mapping was validated,configured and generated successfully.When i am registering the TCL script with OEM by giving all the Runtime Connection Information.It Throws Error 'The Specified connection is not a valid Runtime Schema'
Can you Please give the solution for this!

 

[Subhashab]

The error you have described could be die to various reason.
but to eliminate scenario first check the schema on to which u are loading data has the OWB runtime packages. This is created by executing the OWB Runtime Assistant.

Second did u check the sqlldr script generated check to see it that will work if u had done all this manualy.

 

[suganyaas]

This error occurs when the DB link or the connection details is incorrect.
In OWB though your source & target may be in the same schema , you do need to provide a DB link .