Forum Stats

  • 3,855,430 Users
  • 2,264,502 Discussions
  • 7,905,989 Comments

Discussions

Oracle RCU.BAT

SANPAT
SANPAT Member Posts: 1,118 Silver Badge
edited Nov 29, 2021 1:09PM in WebLogic

Dear Friends

I am unable to run the schema - rcu.bat. tried couple of times but it get stuck on this position.

Using Oracle 19c, forms 12 c setup_fmw_12.2.1.4.0_fr_win64, Infrastructure - fmw_12.2.1.4.0_infrastructure.

Kindly suggest what action is needed to install rcu.bat


Sat Nov 27 10:31:39.406 WAT 2021 NOTIFICATION assistants: oracle.sysman.assistants.common.util.LoggingManager::doPostInitialization: HOSTNAME: ppn

Sat Nov 27 10:31:39.422 WAT 2021 NOTIFICATION assistants: oracle.sysman.assistants.common.util.LoggingManager::doPostInitialization: System Property - LOG_LEVEL = INFO

Sat Nov 27 10:31:39.422 WAT 2021 NOTIFICATION assistants: oracle.sysman.assistants.common.util.LoggingManager::doPostInitialization: System Property - RCU_HOME = C:\Oracle\MIDDLE~1\ORACLE~1\oracle_common

Sat Nov 27 10:31:39.422 WAT 2021 NOTIFICATION assistants: oracle.sysman.assistants.common.util.LoggingManager::doPostInitialization: System Property - LOG_LOCATION = c:\tmp\\RCU2021-11-27_10-31_1828361342\logs

Sat Nov 27 10:31:39.422 WAT 2021 NOTIFICATION assistants: oracle.sysman.assistants.common.util.LoggingManager::doPostInitialization: System Property - java.runtime.name = Java(TM) SE Runtime Environment

Sat Nov 27 10:31:39.422 WAT 2021 NOTIFICATION assistants: oracle.sysman.assistants.common.util.LoggingManager::doPostInitialization: System Property - java.vm.version = 25.65-b01

Sat Nov 27 10:31:39.422 WAT 2021 NOTIFICATION assistants: oracle.sysman.assistants.common.util.LoggingManager::doPostInitialization: System Property - java.vm.vendor = Oracle Corporation

Sat Nov 27 10:31:39.422 WAT 2021 NOTIFICATION assistants: oracle.sysman.assistants.common.util.LoggingManager::doPostInitialization: System Property - user.country = US

Sat Nov 27 10:31:39.422 WAT 2021 NOTIFICATION assistants: oracle.sysman.assistants.common.util.LoggingManager::doPostInitialization: System Property - java.runtime.version = 1.8.0_65-b17

Sat Nov 27 10:31:39.422 WAT 2021 NOTIFICATION assistants: oracle.sysman.assistants.common.util.LoggingManager::doPostInitialization: System Property - os.arch = amd64

Sat Nov 27 10:31:39.422 WAT 2021 NOTIFICATION assistants: oracle.sysman.assistants.common.util.LoggingManager::doPostInitialization: System Property - os.name = Windows NT (unknown)

Sat Nov 27 10:31:39.422 WAT 2021 NOTIFICATION assistants: oracle.sysman.assistants.common.util.LoggingManager::doPostInitialization: System Property - os.version = 10.0

Sat Nov 27 10:31:39.422 WAT 2021 NOTIFICATION assistants: oracle.sysman.assistants.common.util.LoggingManager::doPostInitialization: System Property - file.encoding = Cp1252

Sat Nov 27 10:31:39.422 WAT 2021 NOTIFICATION assistants: oracle.sysman.assistants.common.util.LoggingManager::doPostInitialization: System Property - java.specification.version = 1.8

Sat Nov 27 10:31:39.422 WAT 2021 NOTIFICATION assistants: oracle.sysman.assistants.common.util.LoggingManager::doPostInitialization: System Property - user.language = en

Sat Nov 27 10:32:04.078 WAT 2021 NOTIFICATION assistants.rcu.Rcu: oracle.sysman.assistants.rcu.Rcu::initLoggingManager: RCU version:12.2.1.4.0

Sat Nov 27 10:32:04.125 WAT 2021 NOTIFICATION assistants.rcu.Rcu: oracle.sysman.assistants.rcu.Rcu::execute: Launching RCU.

Sat Nov 27 10:32:04.141 WAT 2021 NOTIFICATION assistants.rcu.Rcu: oracle.sysman.assistants.rcu.Rcu::execute: Creating InteractiveRCUModel

Sat Nov 27 10:32:09.219 WAT 2021 NOTIFICATION assistants.rcu.backend.RCUCommandLineParser: oracle.sysman.assistants.rcu.backend.RCUCommandLineParser::process: Processing command line ....

Sat Nov 27 10:32:09.891 WAT 2021 NOTIFICATION assistants.rcu.Rcu: oracle.sysman.assistants.rcu.Rcu::main: Execution Complete.

Sat Nov 27 11:34:01.738 WAT 2021 NOTIFICATION assistants.common.dbutil.jdbc.JDBCEngine: oracle.sysman.assistants.common.dbutil.jdbc.JDBCEngine::connect: Connecting to database: user: sys ,role:SYSDBA , connectString:(description=(address=(host=ppn)(protocol=tcp)(port=1521))(connect_data=(service_name=PPN)(server=dedicated)))


sanjay

Tagged:

Answers

  • Suresh Sangaran-Oracle
    Suresh Sangaran-Oracle Member, Moderator Posts: 334 Employee
    1. Check if your Windows temp is not full.
    2. Test the Database connection(SYS) from local or from the same machine where you are installing FMW.
    3. Test the DB connection on FMW machine using SQL*plus and SQL Developer. If you do not have SQL*plus, install the instant client to test the Database connection https://www.oracle.com/database/technologies/instant-client/downloads.html
    4. Check for the DB alert/listener logs if the connection from RCU is made to the Database.
    5. If nothing works, enable SQL*Net tracing and check what is happening post you give DB credentials in RCU.

    Thanks, Suresh

  • SANPAT
    SANPAT Member Posts: 1,118 Silver Badge

    Dear Suresh,

    Checked all your given 5 points, but didn't find any problem, even able to login.

    LSNRCTL> status

    Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=ppn)(PORT=1521)))

    STATUS of the LISTENER

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

    Alias           LISTENER

    Version          TNSLSNR for 64-bit Windows: Version 19.0.0.0.0 - Production

    Start Date        29-NOV-2021 10:28:50

    Uptime          0 days 0 hr. 35 min. 8 sec

    Trace Level        off

    Security         ON: Local OS Authentication

    SNMP           OFF

    Listener Parameter File  C:\App\Oracle19c\network\admin\listener.ora

    Listener Log File     C:\App\Oracle\diag\tnslsnr\ppn\listener\alert\log.xml

    Listening Endpoints Summary...

     (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=ppn.primepak.com)(PORT=1521)))

     (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC1521ipc)))

     (DESCRIPTION=(ADDRESS=(PROTOCOL=tcps)(HOST=ppn.primepak.com)(PORT=5500))(Security=(my_wallet_directory=C:\APP\ORACLE\admin\ppn\xdb_wallet))(Presentation=HTTP)(Session=RAW))

    Services Summary...

    Service "CLRExtProc" has 1 instance(s).

     Instance "CLRExtProc", status UNKNOWN, has 1 handler(s) for this service...

    Service "ppn" has 1 instance(s).

     Instance "ppn", status READY, has 1 handler(s) for this service...

    Service "ppnXDB" has 1 instance(s).

     Instance "ppn", status READY, has 1 handler(s) for this service...

    The command completed successfully


    SQL> SELECT name,VALUE FROM V$DIAG_INFO where name = 'Diag Alert';

    NAME--------------------------------------------------------------

    VALUE--------------------------------------------------------------------------------

    Diag Alert

    C:\APP\ORACLE\diag\rdbms\ppn\ppn\alert


    sanjay

  • Michael Ferrante-Oracle
    Michael Ferrante-Oracle Senior Principal Product Manager USMember Posts: 7,414 Employee

    Moving this thread to a more appropriate area. Posting in "Forms" was not the right place for this issue.


    Michael Ferrante

    Senior Principal Product Manager

    Oracle

    Twitter: @OracleFormsPM