Connect to Oracle DB 12c from Designer 10.1.2.4

User552636-Oracle

Hello,

My Customer has problem with connecting to Oracle Database 12cR1 single database on Exadata from Designer 10.1.2.4 when using Version History Viewer.

Error message:  CDR-03120:  Internal Error - Problem making a repository connection

Support says Designer is not supported any more and is not certified with 11.2 or higher DB versions.

However, Customer must use Designer.

Any ideas are welcomed.

Thanks.

Izabella

InoL

Can you use Oracle 11g database for Designer?

You are very much on your own with Designer on a 12c database, as you already found out. There are some suggestions if you google for CDR-03120.

Mark Striekwold

Besides the error message CDR-03120 do you have some more information about the error message. i.e. is it missing a message file?

You are using  Designer 10.1.2.4 the last patch release is 10.1.2.6 and that is also the one which is certified on 11g. So maybe an upgrade to the latest patch release is an option. When you consider upgrading to 10.1.2.6 you should first try that inside a test environment since the RAU only knows an upgrade and not a downgrade.

user4606378

Hello,

We have the problem we must upgrade to 12c because support of 11g database version will end I think at the end of the year. The problem is that jdbc 1.4 can not connect to the database 12c.

We tried to change the length of the connect string as we read in the Google search results, but it didn't help.

We tried to change the jdbc driver (renamed the ojdbc14.jar and ojdbc14_g.jar file in the $DEVSUITEHOME/jdbc/lib directory and copied there the ojdbc5.jar and ojdbc5_g.jar files) but we didn't succeed.

Can anybody suggest a way to change the JDBC driver under Designer? Or shuold we forget this tool and change it to another? If so are there any tools to manipulate database objects and generate the changing code (for example for tables) and store them in versionable repository?

Thanks,

  Tunde

InoL

> are there any tools to manipulate database objects and generate the changing code (for example for tables) and store them in versionable repository?

If you don't use Designer for generating Forms (and maybe Reports), I would get rid of Designer.  You can use SQL Developer with Data Modeler instead:

http://www.oracle.com/technetwork/developer-tools/datamodeler/overview/index.html

However, there is no alternative for generating Forms.

> because support of 11g database version will end

Support for Designer 10g ended a long time ago, and that was not a problem?

Mark Striekwold

> If so are there any tools to manipulate database objects and generate the changing code (for example for tables) and store them in versionable repository?

Like InoL already wrote you could use SQL Developer Data Model with i.e. subversion then you have a file based versionable repository. But this is only for your entity or data model. SQL Developer Data Modeler can import your entity model and data model from designer.

When you leave designer there is no generatiing Forms,  You have to maintain you PL/Sql packages, Function, Procedure also a version control system.

But why leave your current database environment? You could stay with your repository inside a older database environment and generate your Forms, packages etc for a newer enviroment. We are currently using a 10g repository database and generating for a 11gR2 Forms and 11gR2 database environment.

user4606378

Hello,

thank you for the suggestions. We will consider which solution to choose, Designer with Oracle DB 11gR2 or migrate our developer environment to SQL Developer (we don't use Forms and Reports from Designer).

Thanks,

  Tunde.

mwickham-Oracle

1. change compatible to 11.1.0.7 in your 12 DB.

2. You can download SQL Developer Data Modeler for FREE since you are not using forms and reports.

Michael