error creating repository in 12c

Tony007

hi am running script to create repository in 12c am geting this error

FROM IAU_COMMON, IAU_CUSTOM_01, IAU_USERSESSION, IAU_CUSTOM, IAU_AUDITSERVICE WHERE IAU_COMMON.IAU_ID = IAU_CUSTOM_01.IAU_ID AND IAU_COMMON.IAU_ID = IAU_USERSESSION.IAU_ID AND IAU_COMMON.IAU_ID = IAU_CUSTOM.IAU_ID AND IAU_COMMON.IAU_ID = IAU_AUDITSERVICE.IAU_ID AND IAU_COMMON.IAU_ComponentType = 'JPS'

                               *

ERROR at line 163:

ORA-00980: synonym translation is no longer valid

Michael Ferrante-Oracle

What do you mean by you are "running from a script"?

Also, exactly which FMW version are you using and to which DB version are you connecting?

Tony007

am running this script as sys to create installation repository

script_postDataLoad.sql ,script_systemLoad.sql

my form is Forms [64 Bit] Version 12.2.1.4.0 (Production)

Oracle Toolkit Version 12.2.1.4.0 (Production)

PL/SQL Version 12.1.0.2.0 (Production)

Oracle Procedure Builder V12.2.1.4.0 - Production

PL/SQL Editor (c) WinMain Software (www.winmain.com), v1.0 (Production)

Oracle Query Builder 12.2.1.4.0 - Production

Oracle Virtual Graphics System Version 12.2.1.4.0 (Production)

Oracle Tools GUI Utilities Version 12.2.1.4.0 (Production)

Oracle Multimedia Version 12.2.1.4.0 (Production)

Oracle Tools Integration Version 12.2.1.4.0 (Production)

Oracle Tools Common Area Version 12.2.1.4.0

Oracle CORE 12.1.0.2.0 Production

Java Version: Oracle Corporation, 11.0.6

and datbase is 19c

Michael Ferrante-Oracle

Java Version: Oracle Corporation, 11.0.6

You cannot use Java 11. You must install and run the software with Java 8. This includes the Installer(s), Repository Creation Utility (RCU), and the Configuration Wizard, even if running in silent mode.

Tony007

sorry that was from window builder in server is 8

java -version

java version "1.8.0_211"

Java(TM) SE Runtime Environment (build 1.8.0_211-b12)

Java HotSpot(TM) 64-Bit Server VM (build 25.211-b12, mixed mode)

Michael Ferrante-Oracle

Things to consider:

.1. Did you previously install, but later drop an FMW Repository in this database and possibly use the same schema names as you are trying to use now?

.2. Are you running the scripts as a user with sysdba privileges?

.3. Are you using a local database and not Autonomous DB?

.4. Were these scripts created from the same 12.2.1.4 version and for this instance? Meaning these aren't old scripts created for a previous repo.

.5. If you have sysdba privileges, have you tried use the RCU in graphical mode to create the schemas? If you have not tried this, it might be worth doing it this way.

Please provide the complete error information. It seems that what you shared was just a small snippet of what actually was likely presented.

Tony007

.1. Did you previously install, but later drop an FMW Repository in this database and possibly use the same schema names as you are trying to use now?NO

.2. Are you running the scripts as a user with sysdba privileges?YES SYSDBA

.3. Are you using a local database and not Autonomous DB?LOCAL DATABASE

.4. Were these scripts created from the same 12.2.1.4 version and for this instance? Meaning these aren't old scripts created for a previous repo.=YES SAME VERSION

.5. If you have sysdba privileges, have you tried use the RCU in graphical mode to create the schemas? If you have not tried this, it might be worth doing it this way.I DONT HAVE SYS DBA PROVILEDGE

Grant succeeded.

PL/SQL procedure successfully completed.

Commit complete.

Session altered.

 FROM IAU_COMMON, IAU_CUSTOM_01, IAU_USERSESSION, IAU_CUSTOM, IAU_AUDITSERVICE WHERE IAU_COMMON.IAU_ID = IAU_CUSTOM_01.IAU_ID AND IAU_COMMON.IAU_ID = IAU_USERSESSION.IAU_ID AND IAU_COMMON.IAU_ID = IAU_CUSTOM.IAU_ID AND IAU_COMMON.IAU_ID = IAU_AUDITSERVICE.IAU_ID AND IAU_COMMON.IAU_ComponentType = 'JPS'

                               *

ERROR at line 163:

ORA-00980: synonym translation is no longer valid

PL/SQL procedure successfully completed.