Having problems with your account or logging in?
A lot of changes are happening in the community right now. Some may affect you. READ MORE HERE
Highlighted
philiplo Regular Contributor.
Regular Contributor.
546 views

IPC reset error when configuring Oracle integration

I was trying to configure oracle integration, I get "bad message error. ipc read error. [104] connection reset by peer". When I run "util_oracle8.pl -version" it shows the version, but when I run "util_oracle8.pl" with no argument, normally it show show me the help text but it just came back with no output. Same thing happens when I run util_oracle8.pl with all the parameters, normally there should be a return code but it just came back nothing. I do have other servers with Oracle backup running so I don't think it's an issue with the CM.

Below is the environment details,

DP 9.09 Cell Manager on Windows 2012, client is Oracle Linux 7.5 and DP client 9.09

What can I do to troubleshoot?

0 Likes
13 Replies
Micro Focus Expert
Micro Focus Expert

Re: IPC reset error when configuring Oracle integration

Hello @philiplo

Check connectivity and name resolution between the CM and the client. Add the information of the servers into the hosts file on each server. 

Also, try to reinstall the component via remote installation in the GUI. 

What is the Oracle version? 

Let us know, 

Andres Fallas Salazar
Customer Support Engineer

If you find that this or any other post resolves your issue, please be sure to mark it as an accepted solution.
If you are satisfied with anyone’s response please remember to give them a LIKE by clicking on the bottom at the left of the post and show your appreciation.
0 Likes
philiplo Regular Contributor.
Regular Contributor.

Re: IPC reset error when configuring Oracle integration

Hi @Victor_F_DP

thanks for the quick reply, the oracle version is 12.1.0.2, in fact the filesystem backup is running fine. Will try reinstalling the agent tomorrow.

regards, Philip

0 Likes
Micro Focus Expert
Micro Focus Expert

Re: IPC reset error when configuring Oracle integration

Hi @philiplo

Thanks for the detail. Please let us know after the reinstallation. 

Regards, 

Andres Fallas Salazar
Customer Support Engineer

If you find that this or any other post resolves your issue, please be sure to mark it as an accepted solution.
If you are satisfied with anyone’s response please remember to give them a LIKE by clicking on the bottom at the left of the post and show your appreciation.
0 Likes
philiplo Regular Contributor.
Regular Contributor.

Re: IPC reset error when configuring Oracle integration

HI @Victor_F_DP,

I've reinstalled the agent but it doesn't solve the issue. File backup running fine but not oracle. Any suggestions?

regards, Philip

0 Likes
Knowledge Partner Knowledge Partner
Knowledge Partner

Re: IPC reset error when configuring Oracle integration

Hi @philiplo,

Anything relevant in oracle8.log, debug.log or /var/log/messages on the Oracle client? What is the version of the Oracle database? Is 32bit compatibilty installed on the OL7 client which is required for the Data Protector perl interpreter running the configure script.

Regards,
Sebastian Koehler

---
Please use the Like button below, if you find this post useful.
0 Likes
philiplo Regular Contributor.
Regular Contributor.

Re: IPC reset error when configuring Oracle integration

Hi @Sebastian.Koehler,

The 32bit version of glibc and nss-softokn-freebl are installed. When I run "util_oracle8.pl -version" there's output, but when I just run "util_oracle8.pl", normally it will display the help file but in this case there's no output. Same goes to running the script with the parameters, I'm suspecting the issue with perl that causes all the IPC disconnect and also unable to configure the Oracle extension.

Nothing suspicious in all the logs. When I try to configure Oracle extension via GUI then I see log entries in oracle8.log but nothing if I use util_oracle8.pl. 

regards, Philip

0 Likes
Knowledge Partner Knowledge Partner
Knowledge Partner

Re: IPC reset error when configuring Oracle integration

Hi @philiplo,

Most likely the GUI will also fail because it is using the same commands as you would noramlly do from CLI. Please share the output of the following commands.

ldd /opt/omni/bin/perl
/opt/omni/bin/perl -version
/opt/omni/bin/perl /opt/omni/lbin/util_oracle8.pl -version
/opt/omni/bin/perl /opt/omni/lbin/util_oracle8.pl -help

Regards,
Sebastian Koehler

---
Please use the Like button below, if you find this post useful.
0 Likes
philiplo Regular Contributor.
Regular Contributor.

Re: IPC reset error when configuring Oracle integration

Hi @Sebastian.Koehler,

Below is the output

[root@KTUATJURDB6 lbin]# ldd /opt/omni/bin/perl
        linux-vdso.so.1 =>  (0x00007ffd8e3fe000)
        libpthread.so.0 => /lib64/libpthread.so.0 (0x00007f09579dd000)
        libnsl.so.1 => /lib64/libnsl.so.1 (0x00007f09577c3000)
        libdl.so.2 => /lib64/libdl.so.2 (0x00007f09575be000)
        libm.so.6 => /lib64/libm.so.6 (0x00007f09572bc000)
        libcrypt.so.1 => /lib64/libcrypt.so.1 (0x00007f0957085000)
        libutil.so.1 => /lib64/libutil.so.1 (0x00007f0956e81000)
        libc.so.6 => /lib64/libc.so.6 (0x00007f0956ab4000)
        /lib64/ld-linux-x86-64.so.2 (0x0000564cba1b7000)
        libfreebl3.so => /lib64/libfreebl3.so (0x00007f09568b1000)
[root@KTUATJURDB6 lbin]# /opt/omni/bin/perl -version

This is perl 5, version 24, subversion 0 (v5.24.0) built for x86_64-linux

Copyright 1987-2016, Larry Wall

Perl may be copied only under the terms of either the Artistic License or the
GNU General Public License, which may be found in the Perl 5 source kit.

Complete documentation for Perl, including FAQ lists, should be found on
this system using "man perl" or "perldoc perl".  If you have access to the
Internet, point your browser at http://www.perl.org/, the Perl Home Page.

[root@KTUATJURDB6 lbin]# /opt/omni/bin/perl /opt/omni/lbin/util_oracle8.pl -version
HPE Data Protector A.09.00: UTIL_ORACLE8, internal build 114, built on Fri Mar 31 10:26:43 2017
[root@KTUATJURDB6 lbin]# /opt/omni/bin/perl /opt/omni/lbin/util_oracle8.pl -help

Usage synopsis:

        util_oracle8.pl -help

        util_oracle8.pl -version

        util_oracle8.pl -config -dbname <DB_NAME> -orahome <ORACLE_HOME>
                        <PRIMARY_DB_LOGIN> [<STANDBY_DB_LOGIN>] [<CATALOG_DB_LOGIN>] [<ZDB_OPTIONS>]
                       [-client <CLIENT_NAME>] [<ASM_OPTIONS>]

        PRIMARY_DB_LOGIN:
        -prmuser    <PRIMARY_USERNAME>
        -prmpasswd  <PRIMARY_PASSWORD>
        -prmservice <PRIMARY_NET_SERVICE_NAME_1>[,<PRIMARY_NET_SERVICE_NAME_2>...]

        STANDBY_DB_LOGIN:
        -stbuser    <STANDBY_USERNAME>
        -stbpasswd  <STANDBY_PASSWORD>
        -stbservice <STANDBY_NET_SERVICE_NAME_1>[,<STANDBY_NET_SERVICE_NAME_2>...]

CATALOG_DB_LOGIN:
        -rcuser    <CATALOG_USERNAME>
        -rcpasswd  <CATALOG_PASSWORD>
        -rcservice <CATALOG_NET_SERVICE_NAME_1>

ZDB_OPTIONS:
        -zdb_method      {PROXY | BACKUP_SET }
        [-ctlcp_location  <BACKUP_CONTROL_FILE_COPY_LOCATION>]
        [-pfile           <PARAMETER_FILE>]
        [-bkphost         <BACKUP_SYSTEM>]

ASM_OPTIONS:
        -asmhome          <ASM_HOME>
        -asmuser          <ASM_USERNAME>
        -asmpasswd        <ASM_PASSWORD>
        -asmservice       <ASM_NET_SERVICE_NAME_1>[,<ASM_NET_SERVICE_NAME_2>...]

        util_oracle8.pl -chkconf -dbname <DB_NAME> [-client <CLIENT_NAME>]

        util_oracle8.pl -chkconf_smb -dbname <DB_NAME> [-bkphost <BACKUP_SYSTEM>] [-client <CLIENT_NAME>]

        util_oracle8.pl -chkconf_ir -dbname <DB_NAME> [-client <CLIENT_NAME>]

[root@KTUATJURDB6 lbin]# /opt/omni/bin/perl /opt/omni/lbin/util_oracle8.pl
[root@KTUATJURDB6 lbin]#

The interesting is that when I run /opt/omni/bin/perl /opt/omni/lbin/util_oracle8.pl, there's not output while on another working server it will show *RETVAL*1030, seems like the script is working partially.

regards,

Philip Lo

0 Likes
Knowledge Partner Knowledge Partner
Knowledge Partner

Re: IPC reset error when configuring Oracle integration

Hi @philiplo,

Are there possible problematic environmentals defined. Have seen cases where for example LANG was interrupting with scripts.

Regards,
Sebastian Koehler

---
Please use the Like button below, if you find this post useful.
0 Likes
philiplo Regular Contributor.
Regular Contributor.

Re: IPC reset error when configuring Oracle integration

Hi @Sebastian.Koehler

You're referring to system wide global environment variable right? Any specific variable to looked out for? Thanks.

reagrds, Philip

0 Likes
Knowledge Partner Knowledge Partner
Knowledge Partner

Re: IPC reset error when configuring Oracle integration

Hi @philiplo,

I was thinking of LANG. If it is not using en_US.UTF-8 or C try unset LANG before running the script.

Regards,
Sebastian Koehler

---
Please use the Like button below, if you find this post useful.
0 Likes
philiplo Regular Contributor.
Regular Contributor.

Re: IPC reset error when configuring Oracle integration

Hi @Sebastian.Koehler,

The problematic server is using en_GB.UTF-8 while the other working server is using en_AU.UTF-8, Tried changing to both en_US.UTF-8 & en_AU.UTF-8 and also unset the LANG but the issue remains. Now thinking of what else I can try...

regards, Philip

0 Likes
Knowledge Partner Knowledge Partner
Knowledge Partner

Re: IPC reset error when configuring Oracle integration

Hi @philiplo,

I would try to compare a working with the failing server. Start with the rpm packages (rpm -qa | sort on both systems, diff the results).

Regards,
Sebastian Koehler

---
Please use the Like button below, if you find this post useful.
0 Likes
The opinions expressed above are the personal opinions of the authors, not of Micro Focus. By using this site, you accept the Terms of Use and Rules of Participation. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.) and Hewlett Packard Enterprise Company. As of September 1, 2017, the Material is now offered by Micro Focus, a separately owned and operated company. Any reference to the HP and Hewlett Packard Enterprise/HPE marks is historical in nature, and the HP and Hewlett Packard Enterprise/HPE marks are the property of their respective owners.