Monday, September 26, 2016

SOA Suite 12.2.1.1 FileNotFound When Executing RCU


I was installing Oracle SOA Suite 12.2.1.1, and when I ran RCU to seed the database, it threw an exception relating to SOA Infrastructure.
Repository Creation Utility: Create - Completion Summary

Database details:
-----------------------------

Host Name                                    : myhost
Port                                         : 1521
Service Name                                 : ORCL
Connected As                                 : sys
Prefix for (prefixable) Schema Owners        : DEV
RCU Logfile                                  : /tmp/RCU2016-09-26_10-37_1761337454/logs/rcu.log
RCU Checkpoint Object                        : /tmp/RCU2016-09-26_10-37_1761337454/logs/RCUCheckpointObj

Component schemas created:

-----------------------------

Component                                    Status         Logfile
Common Infrastructure Services               Success        /tmp/RCU2016-09-26_10-37_1761337454/logs/stb.log
SOA Infrastructure                           Failed         /tmp/RCU2016-09-26_10-37_1761337454/logs/soainfra.log 
User Messaging Service                       Success        /tmp/RCU2016-09-26_10-37_1761337454/logs/ucsums.log
Metadata Services                            Success        /tmp/RCU2016-09-26_10-37_1761337454/logs/mds.log
WebLogic Services                            Success        /tmp/RCU2016-09-26_10-37_1761337454/logs/wls.log
Oracle Platform Security Services            Success        /tmp/RCU2016-09-26_10-37_1761337454/logs/opss.log
Audit Services                               Success        /tmp/RCU2016-09-26_10-37_1761337454/logs/iau.log
Audit Services Append                        Success        /tmp/RCU2016-09-26_10-37_1761337454/logs/iau_append.log
Audit Services Viewer                        Success        /tmp/RCU2016-09-26_10-37_1761337454/logs/iau_viewer.log

Repository Creation Utility - Create : Operation Completed
Repository Creation Utility - Dropping and Cleanup of the failed components
Repository Dropping and Cleanup of the failed components in progress.

Percent Complete: 100

The referenced log file indicated that a file could not be found.

FileNotFound /u01/fmw/soa/common/sql/soainfra/sql/oracle/createschema_soainfra_oracle_small.sql in attempt 0
FileNotFound /u01/fmw/soa/common/sql/soainfra/sql/oracle/createschema_soainfra_oracle_small.sql in attempt 1
FileNotFound /u01/fmw/soa/common/sql/soainfra/sql/oracle/createschema_soainfra_oracle_small.sql in attempt 2
FileNotFound /u01/fmw/soa/common/sql/soainfra/sql/oracle/createschema_soainfra_oracle_small.sql in attempt 3
/u01/fmw/soa/common/sql/soainfra/sql/oracle/createschema_soainfra_oracle_small.sql (No such file or directory)
Mon Sep 26 10:48:49.828 EDT 2016 NOTIFICATION SOAINFRA: oracle.sysman.assistants.rcu.backend.action.JavaAction::perform: Executing Java Action: oracle.ias.version.SchemaVersionUtil:utilDropRegistryEntry
Mon Sep 26 10:48:48.550 EDT 2016 rcu:Executing SQL statement: DROP USER DEV_SOAINFRA CASCADE
Mon Sep 26 10:48:49.869 EDT 2016 rcu:Executing SQL statement: drop tablespace DEV_SOAINFRA including contents and datafiles

So I perused the directory, and the file is there; however, it is contains uppercase SMALL in the name.
-rw-r-----.  1 oracle oinstall 1821419 Jun  8 19:07 createschema_soainfra_oracle_SMALL.sql

I renamed the file with lowercase "small" in the name, as RCU expects, and ran RCU again. This time, the seeding of the database processed successfully. Afterwards, I renamed the file to its original name.

8 comments:

  1. Hmm, it seems like your site ate my first comment (it was extremely long) so I guess I’ll just sum it up what I had written and say, I’m thoroughly enjoying your blog. I as well as an aspiring blog writer, but I’m still new to the whole thing. Do you have any recommendations for newbie blog writers? I’d appreciate it.
    Advanced AWS Training in Bangalore | Best Amazon Web Services Training Institute in Bangalore
    Advanced AWS Training Institute in Pune | Best Amazon Web Services Training Institute in Pune
    Advanced AWS Online Training Institute in india | Best Online AWS Certification Course in india
    AWS training in bangalore | Best aws training in bangalore

    ReplyDelete
  2. Superb. I really enjoyed very much with this article here. Really it is an amazing article I had ever read. I hope it will help a lot for all. Thank you so much for this amazing posts and please keep update like this excellent article. thank you for sharing such a great blog with us.
    microsoft azure training in bangalore
    rpa training in bangalore
    rpa training in pune
    best rpa training in bangalore

    ReplyDelete
  3. This is very good content you share on this blog. it's very informative and provide me future related information.
    Best Devops training in sholinganallur
    Devops training in velachery
    Devops training in annanagar
    Devops training in tambaram

    ReplyDelete
  4. Very nice post here and thanks for it .I always like and such a super contents of these post.Excellent and very cool idea and great content of different kinds of the valuable information's.
    Python Online certification training
    python Training institute in Chennai
    Python training institute in Bangalore

    ReplyDelete
  5. I have to voice my passion for your kindness giving support to those people that should have guidance on this important matter.Informatica Training in Bangalore

    ReplyDelete
  6. Wonderful to visit your websites, This sites are fully filled with full of Information's. I perceived a lots of knowledge from this Articles.

    For more to learn about Python Visit below
    python training in chennai | python training in annanagar | python training in omr | python training in porur | python training in tambaram | python training in velachery

    ReplyDelete
  7. I must appreciate you for providing such a valuable content for us. This is one amazing piece of article. Helped a lot in increasing my knowledge.
    AWS training in chennai | AWS training in annanagar | AWS training in omr | AWS training in porur | AWS training in tambaram | AWS training in velachery

    ReplyDelete