1 2 Previous Next 20 Replies Latest reply on Jul 9, 2013 11:22 AM by Rrademak-Oracle Branched to a new discussion.

    md5sum check error ONLY for startCD + EBS R12 Installation on Windows 2003

    Oracle-user2
      @ hussein - forum's father of ebs r12 installations :) (no pun intended)/ also all

      my md5sum check was fine for stage area EXCEPT_ for startCD.

      yes, yes, i ran that particular md5sum command with respective md5sum contents for r12 as suggested by oracle

      checked

      1. c:\cygwin\usr\bin + c:\cygwin\bin in path
      1.1 cygwin 1.5 earlier version - has renamed gcc-3 to gcc and copied to cc.exe

      2. C:\VisualStudio8\VC\bin also in path
      21. visutal studio 2005 professional complete suite

      observations:

      1. no errors while unzipping all the parts of startCD
       Name                                                                                                       Part Number        Size (Bytes)
      Oracle E-Business Suite Release 12.1.1 Rapid Install Start Here (Part 1 of 4)      B53824-01 Part 1 of 4      29M
      Oracle E-Business Suite Release 12.1.1 Rapid Install Start Here (Part 2 of 4)      B53824-01 Part 2 of 4      97M
      Oracle E-Business Suite Release 12.1.1 Rapid Install Start Here (Part 3 of 4)      B53824-01 Part 3 of 4      393M
      Oracle E-Business Suite Release 12.1.1 Rapid Install Start Here (Part 4 of 4)      B53824-01 Part 4 of 4      81M
      *2. downloaded the above files literally 5 times without any interrupts i.e. steady uninterrupted bandwidth @2mbps*

      properties of startCD folder are as follows:
      size: 1.25GB (1,3751,283,829 bytes)
      size on disk: 1.27GB (1,370,624,000 bytes)
      contains: 6,944 files, 1,184 folders
      3. in startCD files, i could verify fully functioning files like pdfs, images, etc. which log of md5sum reports FAILED :(

      autorun.inf: FAILED
      component.label: OK
      Disk1/doc/1211concepts.pdf: FAILED
      Disk1/doc/1211install.pdf: FAILED
      Disk1/doc/1211maintproc.pdf: FAILED
      Disk1/doc/1211maintutil.pdf: FAILED
      Disk1/doc/1211patchproc.pdf: FAILED
      Disk1/doc/1211upg11i.pdf: FAILED
      Disk1/html/runrw.html: FAILED
      Disk1/html/runrw_files/colorschememapping.xml: FAILED
      Disk1/html/runrw_files/filel.xistml: FAILED
      but in reality, i see all_ these files mentioned as FAILED, present* their in respective folders


      4. on cmd prompt i see this
      C:\stage12\startCD>md5sum --check md5sum_startCD_12.1.1.10.txt > md5sum_result.t
      xt
      md5sum: Disk1/rapidwiz/etc/dbvfix.sh: No such file or directory
      md5sum: Disk1/rapidwiz/etc/oraparam.ini.template_10123_hp_pa: No such file or di
      rectory
      md5sum: Disk1/rapidwiz/etc/oraparam.ini_10123_hp_pa: No such file or directory
      md5sum: WARNING: 3 of 5746 listed files could not be read
      md5sum: WARNING: 840 of 5743 computed checksums did NOT match
      & these files, i can't see as i am downloaded the win32 stack

      potential cause:

      1. is it that as these startCD files are frequently updated, the corresponding checksum files haven't been updated accordingly?

      2. or is it that since i changed the gcc-3.exe to gcc.exe and copied to cc.exe that these kinda failed errors displayed.


      appreciate ALL your time and timely thoughts...
        • 1. Re: md5sum check error ONLY for startCD + EBS R12 Installation on Windows 2003
          Hussein Sawwan-Oracle
          Hi,
          1. is it that as these startCD files are frequently updated, the corresponding checksum files haven't been updated accordingly?
          It could be. However, I believe the checksum files are updated regularly, especially when a new version of startCD is released or uploaded to the e-Delivery website.
          2. or is it that since i changed the gcc-3.exe to gcc.exe and copied to cc.exe that these kinda failed errors displayed.
          I do not think it is about the gcc.exe as you were able to run md5sum for other CDs/DVDs with no issues. What I would suggest for now is to download the latest md5 checksum results. In “Section 4” of the md5sum document you should find the list of files you would need to download again.

          If all have been verified, then you may try to run the installer and see if it works, or you may log a SR to confirm that those md5sum result files are up to date.

          Thanks,
          Hussein
          1 person found this helpful
          • 3. Re: md5sum check error ONLY for startCD + EBS R12 Installation on Windows 2003
            Oracle-user2
            hussein, here is my progress.... soliciting you advice please


            ...went ahead w/ install ....


            ...error in step 2 of 5 with below details
            RW-50010: Error: - script has returned an error:   1
            RW-50004: Error code received when running external process.  Check log file for details.
            Running Database Install Driver for VIS instance
            ApplyDatabase_05280536.log details

            getConnectionUsingAppsJDBCConnector() -->
                APPS_JDBC_URL='null'
                Trying to get connection using SID based connect descriptor
            getConnection() -->
                sDbHost    : ebsr1232
                sDbDomain  : ashinc.local
                sDbPort    : 1521
                sDbSid     : VIS
                sDbUser    : APPS
                Trying to connect using SID...
            getConnectionUsingSID() -->
                JDBC URL: jdbc:oracle:thin:@ebsr1232.ashinc.local:1521:VIS
                Exception occurred: java.sql.SQLException: Io exception: The Network Adapter could not establish the connection
                Trying to connect using SID as ServiceName
            getConnectionUsingServiceName() -->
                JDBC URL: jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=ebsr1232.ashinc.local)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=VIS)))
                Exception occurred: java.sql.SQLException: Io exception: The Network Adapter could not establish the connection
                Trying to connect using SID as ServiceName.DomainName
            getConnectionUsingServiceName() -->
                JDBC URL: jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=ebsr1232.ashinc.local)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=VIS.ashinc.local)))
                Exception occurred: java.sql.SQLException: Io exception: The Network Adapter could not establish the connection
                Connection could not be obtained; returning null
            
            -------------------ADX Database Utility Finished---------------
            
            RC-00118: Error occurred during creation of database
            Raised by oracle.apps.ad.clone.ApplyDatabase
            existing etc/hosts file contents
            127.0.0.1       localhost
            127.0.0.1          ebsr1232.ashinc.local
            i guess etc/hosts file should actually be
            127.0.0.1       localhost.localdomain          localhost
            <myIPhere>     ebsr1232.ashinc.local          ebsr1232
            should i now do a clear previous failed install following oracle note, modify etc/hosts file as above and then retry?

            thank you
            • 4. Re: md5sum check error ONLY for startCD + EBS R12 Installation on Windows 2003
              Hussein Sawwan-Oracle
              Hi,
              should i now do a clear previous failed install following oracle note, modify etc/hosts file as above and then retry?
              Was the database created successfully? If yes, correct the entry in the hosts file and click on retry button. If there is no retry button, close Rapid Install window, and start the installation again using "-restart" option.

              Thanks,
              Hussein
              1 person found this helpful
              • 6. Re: md5sum check error ONLY for startCD + EBS R12 Installation on Windows 2003
                Hussein Sawwan-Oracle
                Hi,

                Open a new DOS session, source the database env file "<CONTEXT_NAME>.cmd" under %ORACLE_HOME%, connect to SQL*Plus as sysdba, and issue "SQL> select status from v$instance;".

                Thanks,
                Hussein
                1 person found this helpful
                • 7. Re: md5sum check error ONLY for startCD + EBS R12 Installation on Windows 2003
                  Oracle-user2
                  i found the file you mention to source C:\oracle\VIS\db\tech_st\11.1.0\VIS_ebsr1232.cmd
                  • 8. Re: md5sum check error ONLY for startCD + EBS R12 Installation on Windows 2003
                    Oracle-user2
                    ......this folder data ( C:\oracle\VIS\db\apps_st\data) shows *189 GB*...does that imply db created?

                    ran the command C:\oracle\VIS\db\tech_st\11.1.0\VIS_ebsr1232.cmd

                    when trying to conn via sqlplus it reads ORA-12560: TNS:protocol adapter error

                    Started - OracleServiceVIS
                    Started - OracleVISdb111_RDBMSTNSListenerVIS_

                    content of VIS-ebsr1232.cmd

                    not sure why the following are the way they are:

                    REM Unset all the variables NOT required
                    REM ####################################

                    set TWO_TASK=
                    set ORA_NLS33=
                    set ORACLE_SID=

                    @echo OFF
                    @if not "%ORAWIN_DBG%"=="" echo %ORAWIN_DBG%
                    @REM
                    @REM  $Header: ad8idbnt.env 120.4 2007/07/02 13:19:19 dhakumar ship $
                    @REM
                    @REM  ==========================================================================
                    @REM  NAME
                    @REM     VIS.env
                    @REM 
                    @REM  DESCRIPTION
                    @REM     Setup environment for Oracle 8i RDBMS HOME
                    @REM 
                    @REM  NOTES
                    @REM 
                    @REM  HISTORY
                    @REM     Created by AutoConfig
                    @REM  ==========================================================================
                    @REM
                    REM  ###############################################################
                    REM  
                    REM  This file is automatically generated by AutoConfig.  It will be read and
                    REM  overwritten.  If you were instructed to edit this file, or if you are not
                    REM  able to use the settings created by AutoConfig, refer to Metalink Note
                    REM  387859.1 for assistance.
                    REM  
                    REM  ###############################################################
                    
                    @REM
                    
                    echo
                    
                    REM ####################################
                    REM Unset all the variables NOT required
                    REM ####################################
                    
                    set TWO_TASK=
                    
                    set ORA_NLS33=
                    
                    set ORACLE_SID=
                    
                    REM #######################################
                    REM Run the customization file if it exists
                    REM #######################################
                    
                    IF EXIST C:\oracle\VIS\db\tech_st\11.1.0\customVIS_ebsr1232.cmd (
                    CALL C:\oracle\VIS\db\tech_st\11.1.0\customVIS_ebsr1232.cmd
                    )
                    
                    if "%ORAWIN_DBG%"=="ON" echo You are running VIS_ebsr1232.cmd
                    echo
                    @REM Get Date and Time
                    FOR /F "DELIMS=" %%a IN ('DATE /T') DO (
                      SET dateline=%%a
                    )
                    
                    FOR /F "DELIMS=" %%a IN ('TIME /T') DO (
                      SET timeline=%%a
                    )
                    echo %dateline%%timeline%
                    
                    REM ##########################
                    REM Set the variables required
                    REM ##########################
                    
                    set ORACLE_HOME=C:\oracle\VIS\db\tech_st\11.1.0
                    
                    set LOCAL=VIS
                    
                    set ORA_NLS10=C:\oracle\VIS\db\tech_st\11.1.0\nls\data\9idata
                    
                    set CONTEXT_FILE=C:\oracle\VIS\db\tech_st\11.1.0\appsutil\VIS_ebsr1232.xml
                    
                    set CONTEXT_NAME=VIS_ebsr1232
                    
                    set TNS_ADMIN=C:\oracle\VIS\db\tech_st\11.1.0\network\admin\VIS_ebsr1232
                    
                    REM ############################
                    REM ##### Set Library Path #####
                    REM ############################
                    
                    set LD_LIBRARY_PATH=C:\oracle\VIS\db\tech_st\11.1.0\lib
                    
                    REM #################################################
                    REM ##### Add perl to the PATH and set PERL5LIB #####
                    REM #################################################
                    
                    for %%g in ("C:\oracle\VIS\db\tech_st\11.1.0\Perl\5.8.3\bin\mswin32-x86-multi-thread\perl.exe") do (
                      set PERLBIN=%%~dpg
                    )
                    
                    set PATH=%PERLBIN%;C:\oracle\VIS\db\tech_st\11.1.0\bin;C:\oracle\VIS\db\tech_st\11.1.0\appsutil\jre\bin;C:\oracle\VIS\db\tech_st\11.1.0\appsutil\jre\bin;%PATH%
                    
                    set PERL5LIB=C:\oracle\VIS\db\tech_st\11.1.0\perl\5.8.3\lib\MSWin32-x86-multi-thread;C:\oracle\VIS\db\tech_st\11.1.0\perl\5.8.3\lib;C:\oracle\VIS\db\tech_st\11.1.0\perl\site\5.8.3\lib\MSWin32-x86-multi-thread;C:\oracle\VIS\db\tech_st\11.1.0\perl\site\5.8.3\lib;C:\oracle\VIS\db\tech_st\11.1.0\appsutil\perl
                    
                    set ADPERLPRG=C:\oracle\VIS\db\tech_st\11.1.0\Perl\5.8.3\bin\mswin32-x86-multi-thread\perl.exe
                    
                    REM ###########################################################
                    REM ##### National Language Support environment variables #####
                    REM ###########################################################
                    
                    set NLS_LANG=American_America.AL32UTF8
                    
                    set nls_numeric_characters = .,
                    
                    set nls_date_format = DD-MON-RR
                    
                    set nls_sort = binary
                    
                    set nls_language = american
                    
                    set nls_territory = america
                    
                    REM #######################################
                    REM ##### Set java program used by AD #####
                    REm #######################################
                    
                    set ADJVAPRG=C:\oracle\VIS\db\tech_st\11.1.0\appsutil\jre\bin\java.exe
                    
                    set ADJREOPTS=-Xms128M -Xmx512M
                    
                    REM ###########################
                    REM Timezone specification file
                    REM ###########################
                    
                    set ORA_TZFILE=C:\oracle\VIS\db\tech_st\11.1.0\oracore\zoneinfo\timezlrg.dat
                    
                    echo VIS_ebsr1232.cmd exiting with status %ERRORLEVEL%
                    when trying to conn via sqlplus it reads ORA-12560: TNS:protocol adapter error

                    Started - OracleServiceVIS
                    Started - OracleVISdb111_RDBMSTNSListenerVIS_

                    hosts file
                    # Copyright (c) 1993-1999 Microsoft Corp.
                    #
                    # This is a sample HOSTS file used by Microsoft TCP/IP for Windows.
                    #
                    # This file contains the mappings of IP addresses to host names. Each
                    # entry should be kept on an individual line. The IP address should
                    # be placed in the first column followed by the corresponding host name.
                    # The IP address and the host name should be separated by at least one
                    # space.
                    #
                    # Additionally, comments (such as these) may be inserted on individual
                    # lines or following the machine name denoted by a '#' symbol.
                    #
                    # For example:
                    #
                    #      102.54.94.97     rhino.acme.com          # source server
                    #       38.25.63.10     x.acme.com              # x client host
                    
                    127.0.0.1       localhost.localdomain
                    127.0.0.1     ebsr1232.ashinc.local
                    listener.ora
                    #
                    # $Header: ad8ilsnr.ora 120.3 2007/12/18 10:13:38 sbandla ship $
                    #
                    # ###############################################################
                    # 
                    # This file is automatically generated by AutoConfig.  It will be read and
                    # overwritten.  If you were instructed to edit this file, or if you are not
                    # able to use the settings created by AutoConfig, refer to Metalink Note
                    # 387859.1 for assistance.
                    # 
                    # ###############################################################
                    
                    #
                    
                    #
                    # Net8 definition for Database listener
                    #
                    
                    VIS =
                      (DESCRIPTION_LIST =
                        (DESCRIPTION =
                          (ADDRESS = (PROTOCOL = TCP)(HOST = ebsr1232.ashinc.local)(PORT = 1521))
                        )
                      )
                    
                    SID_LIST_VIS =
                      (SID_LIST =
                        (SID_DESC =
                          (ORACLE_HOME= C:\oracle\VIS\db\tech_st\11.1.0)
                          (SID_NAME = VIS)
                        )
                      )
                    
                    STARTUP_WAIT_TIME_VIS = 0
                    CONNECT_TIMEOUT_VIS = 10
                    TRACE_LEVEL_VIS = OFF
                    
                    LOG_DIRECTORY_VIS = C:\oracle\VIS\db\tech_st\11.1.0/network/admin
                    LOG_FILE_VIS = VIS
                    TRACE_DIRECTORY_VIS = C:\oracle\VIS\db\tech_st\11.1.0/network/admin
                    TRACE_FILE_VIS = VIS
                    ADMIN_RESTRICTIONS_VIS = OFF
                    SUBSCRIBE_FOR_NODE_DOWN_EVENT_VIS = OFF
                    tnsnames.ora
                    #
                    # $Header: ad8itns.ora 120.0 2005/06/20 15:31:47 appldev noship $
                    #
                    # ###############################################################
                    # 
                    # This file is automatically generated by AutoConfig.  It will be read and
                    # overwritten.  If you were instructed to edit this file, or if you are not
                    # able to use the settings created by AutoConfig, refer to Metalink Note
                    # 387859.1 for assistance.
                    # 
                    # ###############################################################
                    
                    #
                    
                    #
                    # Net8 definition for the database
                    #
                    
                    VIS = (DESCRIPTION=
                                    (ADDRESS=(PROTOCOL=tcp)(HOST=ebsr1232)(PORT=1521))
                                    (CONNECT_DATA=(SID=VIS))
                                )
                    
                    VIS_LOCAL =
                                (DESCRIPTION=
                                    (ADDRESS=(PROTOCOL=tcp)(HOST=ebsr1232)(PORT=1521))
                                )
                    
                    VIS_REMOTE =
                                (DESCRIPTION=
                                    (ADDRESS=(PROTOCOL=tcp)(HOST=ebsr1232)(PORT=1521))
                                ) 
                    
                    #
                    # Intermedia
                    #
                    extproc_connection_data =
                              (DESCRIPTION=
                                  (ADDRESS_LIST =
                                      (ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROCVIS))
                                  )
                                  (CONNECT_DATA=
                                      (SID=PLSExtProc)
                                      (PRESENTATION = RO)
                                  ) )
                    
                    IFILE=C:\oracle\VIS\db\tech_st\11.1.0\network\admin\VIS_ebsr1232\VIS_ebsr1232_ifile.ora
                    Edited by: oracleBIuser on May 27, 2010 9:07 PM
                    • 10. Re: md5sum check error ONLY for startCD + EBS R12 Installation on Windows 2003
                      Hussein Sawwan-Oracle
                      Hi,
                      i found the file you mention to source C:\oracle\VIS\db\tech_st\11.1.0\VIS_ebsr1232.cmd
                      This is the script you need to run before connecting to SQL*Plus. From the command prompt, run this file then issue:
                      C:\sqlplus / as sysdba
                      
                      SQL> select status from v$instance;
                      Thanks,
                      Hussein
                      • 11. Re: md5sum check error ONLY for startCD + EBS R12 Installation on Windows 2003
                        Hussein Sawwan-Oracle
                        Hi,
                        ......this folder data ( C:\oracle\VIS\db\apps_st\data) shows *189 GB*...does that imply db created?
                        Not necessarily, run the select statement to verify whether the database is open or not.

                        For the ORA error you are getting, bounce the two services (the dabase and the listener) then try to connect to sqlplus again.
                        127.0.0.1     ebsr1232.ashinc.local
                        Is this the entry you have recently added? You should use a different IP Address by setting up a loopback adapter, so have you done this?

                        Thanks,
                        Hussein
                        1 person found this helpful
                        • 12. Re: md5sum check error ONLY for startCD + EBS R12 Installation on Windows 2003
                          Oracle-user2
                          hussien,
                          SQL> select status from v$instance;
                          
                          STATUS
                          ------------
                          OPEN
                          Is this  - *127.0.0.1     ebsr1232.ashinc.local* - the entry you have recently added? 
                          i did not add recently , it was there right from beginning of installation
                          You should use a different IP Address by setting up a loopback adapter, so have you done this?
                          I wanted to follow only your steps installing on 2003 & i didn't see the configuring loopback adaptor steps in 2003 steps but saw them in xp steps though - sorry if i have missed it

                          can/should I configure loopback adaptor now?

                          can i still succeed continuing w/ installation going forward after adding the below to host file?

                          127.0.0.1 localhost.localdomain          localhost
                          <myIPhere>     ebsr1232.ashinc.local          ebsr1232
                          • 13. Re: md5sum check error ONLY for startCD + EBS R12 Installation on Windows 2003
                            Oracle-user2
                            thanks Hussein,

                            i was able to execute the command w/ ur syntax...that is the output

                            can you comment on above post also plz?
                            • 14. Re: md5sum check error ONLY for startCD + EBS R12 Installation on Windows 2003
                              Hussein Sawwan-Oracle
                              Hi,
                              can i still succeed continuing w/ installation going forward after adding the below to host file?
                              Yes, you can as the IP Address is not hardcoded in any of the files.

                              Thanks,
                              Hussein
                              1 person found this helpful
                              1 2 Previous Next