11 Replies Latest reply on Aug 1, 2017 9:49 AM by Delphix It ..

    RW-50004: Error code received when running external process

    Delphix It ..

      Hi Experts,

       

      While trying to install Oracle EBS 12.1.1 on AIX 7.1 - I'm encountering below issue.

       

       

      Error Received

      RW-50004: Error code received when running external process

       

      RapidWiz Log File:

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

      ADX Database Utility

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

      getConnectionUsingAppsJDBCConnector() -->

      APPS_JDBC_URL='null'

      Trying to get connection using SID based connect descriptor

      getConnection() -->

      sDbHost    : aixxpp1

      sDbDomain  : domain.com

      sDbPort    : 1521

      sDbSid     : VIS

      sDbUser    : APPS

      Trying to connect using SID...

      getConnectionUsingSID() -->

      JDBC URL: jdbc:oracle:thin:@aixxpp1.domain.com: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=aixxpp1.domain.com)(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=aixxpp1.domain.com)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=VIS.domain.com)))

      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

       

      Troubleshooting Steps

      Verified if any process running on 1521 port - no process running.

      Tried starting listener and was unable to start on the server and it failed with below error message

      -bash-4.2$ lsnrctl start VIS

       

      LSNRCTL for IBM/AIX RISC System/6000: Version 11.1.0.7.0 - Production on 28-JUL-2017 07:12:42

       

      Copyright (c) 1991, 2008, Oracle.  All rights reserved.

       

      Starting /u01/oracle/VIS/db/tech_st/11.1.0/bin/tnslsnr: please wait...

       

      exec(): 0509-036 Cannot load program /u01/oracle/VIS/db/tech_st/11.1.0/bin/tnslsnr because of the following errors:

      0509-150   Dependent module libttsh11.so could not be loaded.

      0509-022 Cannot load module libttsh11.so.

      0509-026 System error: A file or directory in the path name does not exist.

      TNS-12547: TNS:lost contact

      TNS-12560: TNS:protocol adapter error

      TNS-00517: Lost contact

      IBM/AIX RISC System/6000 Error: 32: Broken pipe

       

       

      As per Doc. ID: 869644.1, the file system where ORACLE_HOME is installed is mounted using CIO option and this is not a supported option for AIX server.

      Reviewed the current setting for the file system where OH will be installed (/u01) - the cio option is not enabled for the FS.

       

      /u01:   dev        = /dev/fslv02   vfs        = jfs2   log        = /dev/loglv03   mount      = true   options    = dio,rw   account    = false

       

      Please suggest what else I need to check, let me know if additional information is required.

       

      Thanks,

      Ankur

        • 1. Re: RW-50004: Error code received when running external process
          Kanda-Oracle

          Hi Ankur,

           

          Can you check whether you are able to execute tnslsnr from command prompt.

           

          $ ../11.1.0/bin/tnslsnr

           

           

          Hope this helps!

           

          N Kandasamy

          • 2. Re: RW-50004: Error code received when running external process
            Delphix It ..

            Thanks for your response Kanda-Oracle

            I'm not able to execute tnslsnr from the command prompt.

             

            -bash-4.2$ tnslsnr

            exec(): 0509-036 Cannot load program tnslsnr because of the following errors:

                    0509-150   Dependent module libttsh11.so could not be loaded.

                    0509-022 Cannot load module libttsh11.so.

                    0509-026 System error: A file or directory in the path name does not exist.

            • 4. Re: RW-50004: Error code received when running external process
              Kanda-Oracle

              Also Please look for file /lib/libttsh11.so and its permission.

              • 5. Re: RW-50004: Error code received when running external process
                Delphix It ..

                Hi Kanda-Oracle

                As mentioned in my initial post, the doc. 869644.1 was reviewed and was not helpful, as CIO option is not enabled on the file system where ORACLE_HOME is installed.

                • 6. Re: RW-50004: Error code received when running external process
                  Delphix It ..

                  unable to locate libttsh11.so

                   

                  root@aixxpp1:/-> which libttsh11.so

                  which: 0652-141 There is no libttsh11.so in /usr/vacpp/bin /usr/local/bin /usr/bin /etc /usr/sbin /usr/ucb /usr/bin/X11 /sbin /usr/java14/jre/bin /usr/java14/bin /usr/vacpp/bin.

                  • 7. Re: RW-50004: Error code received when running external process
                    Violeta F-Oracle

                    Use the RDA diagnostic tool from note RDA - Health Check / Validation Engine Guide (Doc ID 250262.1) for your OS platform, run the command "./rda.sh -T hcve" and use the pre-install Oracle E-Business Suite option appropriate for your OS and EBS version to test the OS configuration.

                    Review the html output, see if you have any missing libraries and solve all the failed checks, then re-try.

                    1 person found this helpful
                    • 8. Re: RW-50004: Error code received when running external process
                      Kanda-Oracle

                      1.You should find it in the ORACLE_HOME.

                       

                      2. You can also try this.

                      ldd /u01/oracle/VIS/db/tech_st/11.1.0/bin/tnslsnr | grep libttsh11

                      • 9. Re: RW-50004: Error code received when running external process
                        Kanda-Oracle

                        (Doc ID 250262.1) helps if you are missing OS kernel level.

                        • 10. Re: RW-50004: Error code received when running external process
                          Delphix It ..

                          -bash-4.2$ ldd /u01/oracle/VIS/db/tech_st/11.1.0/bin/tnslsnr | grep libttsh11

                          Cannot find libttsh11.so

                           

                          Results from RDA are attached at below link.

                          http://www.filedropper.com/appshcveaebs1211aixres_1

                           

                          Looks like few pre-install have failed. Please review the following results for the failed pre-reqs. and let me know what am I missing on the server. Thanks for all the help..!!

                           

                          Got linkxlC? -> Failed

                           

                          root@aixxpp1:/tmp/rda-> which linkxlC

                          /usr/vacpp/bin/linkxlC

                          root@aixxpp1:/tmp/rda-> su - oravis

                          -bash-4.2$ which linkxlC

                          /usr/vacpp/bin/linkxlC

                          -bash-4.2$ logout

                          root@aixxpp1:/tmp/rda-> su - applvis

                          -bash-4.2$ which linkxlC

                          /usr/vacpp/bin/linkxlC

                           

                           

                          ulimits OK? -> Failed

                           

                          Attached results for /etc/security/limits

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

                           

                          *

                          * Sizes are in multiples of 512 byte blocks, CPU time is in seconds

                          *

                          * fsize      - soft file size in blocks

                          * core      - soft core file size in blocks

                          * cpu        - soft per process CPU time limit in seconds

                          * data      - soft data segment size in blocks

                          * stack      - soft stack segment size in blocks

                          * rss        - soft real memory usage in blocks

                          * nofiles    - soft file descriptor limit

                          * fsize_hard - hard file size in blocks

                          * core_hard  - hard core file size in blocks

                          * cpu_hard  - hard per process CPU time limit in seconds

                          * data_hard  - hard data segment size in blocks

                          * stack_hard - hard stack segment size in blocks

                          * rss_hard  - hard real memory usage in blocks

                          * nofiles_hard - hard file descriptor limit

                          *

                          * The following table contains the default hard values if the

                          * hard values are not explicitly defined:

                          *

                          *  Attribute        Value

                          *  ==========    ============

                          *  fsize_hard    set to fsize

                          *  cpu_hard      set to cpu

                          *  core_hard        -1

                          *  data_hard        -1

                          *  stack_hard      8388608

                          *  rss_hard          -1

                          *  nofiles_hard      -1

                          *

                          * NOTE:  A value of -1 implies "unlimited"

                          *

                           

                          default:

                              fsize = -1

                              core = 2097151

                              cpu = -1

                              data = 262144

                                  data_hard = -1

                              rss = 65536

                              stack =    65536

                              nofiles = 2000

                           

                          root:

                              fsize = -1

                              core = -1

                              cpu = -1

                              data = -1

                              data_hard = -1

                              stack = -1

                              nofiles = 65536

                              nproc = -1

                           

                          daemon:

                           

                          bin:

                           

                          sys:

                           

                          adm:

                           

                          uucp:

                           

                          guest:

                           

                          nobody:

                           

                          lpd:

                           

                          esaadmin:

                              stack = 393216

                              stack_hard = 393216

                           

                          ora1120:

                              data = -1

                              data_hard = -1

                           

                          sybase:

                              fsize = -1

                           

                          sybase2:

                              fsize = -1

                           

                          oravis:

                              nofiles = 65536

                              data = -1

                                  core = -1

                                  cpu = -1

                              stack = -1

                              nproc = -1

                                  data_hard = -1

                           

                          applvis:

                              data = -1

                                  core = -1

                                  cpu = -1

                              stack = -1

                              nofiles = 65536

                              nproc = -1

                                  data_hard = -1

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

                           

                           

                           

                          Thanks,

                          Ankur

                          • 11. Re: RW-50004: Error code received when running external process
                            Delphix It ..

                            Installed vacpp.cmp.rte correct version:

                            root@aixxpp1:/-> lslpp -l vacpp.cmp.rte  Fileset                  Level  State  Description  ---------------------------------------------------------------------------- Path: /usr/lib/objrepos  vacpp.cmp.rte        11.1.0.11  COMMITTED  IBM XL C/C++ Compiler                                             Application Runtime

                             

                            RDA shows PASSED for all rule set

                            rda.png

                             

                            But still facing issues while trying to start database listener

                            -bash-4.2$ lsnrctl start VIS

                             

                            LSNRCTL for IBM/AIX RISC System/6000: Version 11.1.0.7.0 - Production on 31-JUL-2017 23:48:34

                             

                            Copyright (c) 1991, 2008, Oracle.  All rights reserved.

                             

                            Starting /u01/oracle/VIS/db/tech_st/11.1.0/bin/tnslsnr: please wait...

                             

                            exec(): 0509-036 Cannot load program /u01/oracle/VIS/db/tech_st/11.1.0/bin/tnslsnr because of the following errors:

                                    0509-150   Dependent module libttsh11.so could not be loaded.

                                    0509-022 Cannot load module libttsh11.so.

                                    0509-026 System error: A file or directory in the path name does not exist.

                            TNS-12547: TNS:lost contact

                            TNS-12560: TNS:protocol adapter error

                              TNS-00517: Lost contact

                               IBM/AIX RISC System/6000 Error: 32: Broken pipe

                             

                            -bash-4.2$ tnslsnr

                            exec(): 0509-036 Cannot load program tnslsnr because of the following errors:

                                    0509-150   Dependent module libttsh11.so could not be loaded.

                                    0509-022 Cannot load module libttsh11.so.

                                    0509-026 System error: A file or directory in the path name does not exist.

                             

                            ebs_install.pngebs_install1.png