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

    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
          • 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
              • 5. Re: md5sum check error ONLY for startCD + EBS R12 Installation on Windows 2003
                Oracle-user2
                how do i verfy if database is created please?
                • 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
                  • 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
                          • 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 2 Previous Next