Forum Stats

  • 3,722,808 Users
  • 2,244,417 Discussions
  • 7,850,109 Comments

Discussions

Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

error creating repository in 12c

Tony007
Tony007 Member Posts: 4,046 Bronze Trophy

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

Answers

  • Michael Ferrante-Oracle
    Michael Ferrante-Oracle Member Posts: 6,490 Employee

    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
    Tony007 Member Posts: 4,046 Bronze Trophy

    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
    Michael Ferrante-Oracle Member Posts: 6,490 Employee

    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
    Tony007 Member Posts: 4,046 Bronze Trophy

    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
    Michael Ferrante-Oracle Member Posts: 6,490 Employee

    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
    Tony007 Member Posts: 4,046 Bronze Trophy

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

Sign In or Register to comment.