Cannot load program sqlplus, error Symbol ___strcmp64 is not exported from dependent module /usr/lib/libc.a[shr_64.o]

[Former Member]

Dear all,

We are expriencing an error after a redirected restore, we are restored a backup of a prod system on a new host.

While running a 'brrestore' command to get the restore, it returns the following error:

BR0401I BRRESTORE 7.40 (8)

BR0169I Value 'util_file_online' of parameter/option 'backup_dev_type/-d' ignored for 'brrestore' - 'util_file' assumed

BR0405I Start of file restore: reojarkx.rsb 2014-07-23 16:48:47

BR0484I BRRESTORE log file: /oracle/SID/sapbackup/reojarkx.rsb

BR0278E Command output of '/oracle/SID/112_64/bin/sqlplus':

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

        0509-130 Symbol resolution failed for sqlplus because:

        0509-136   Symbol ___strcmp64 (number 71) is not exported from

                   dependent module /usr/lib/libc.a[shr_64.o].

        0509-136   Symbol ___strcpy64 (number 76) is not exported from

                   dependent module /usr/lib/libc.a[shr_64.o].

        0509-136   Symbol __setjmp (number 78) is not exported from

                   dependent module /usr/lib/libc.a[shr_64.o].

        0509-192 Examine .loader section symbols with the

                 'dump -Tv' command.

BR0280I BRRESTORE time stamp: 2014-07-23 16:48:47

BR0279E Return code from '/oracle/SID/112_64/bin/sqlplus': 255

BR0302E SQLPLUS call for database instance SID failed

BR0406I End of file restore: reojarkx.rsb 2014-07-23 16:48:47

BR0280I BRRESTORE time stamp: 2014-07-23 16:48:47

BR0404I BRRESTORE terminated with errors

Can someone help to get the reason of this issue.

Thanks, regards

[Former Member · Accepted solution]

More likely you have different version of AIX installed on both hosts. Check this with oslevel -s command and attach output to message from both hosts.

[Former Member · Accepted solution]

Roman,

how can you know that it is about AIX? The OP didn't tell us.
Besides that, I agree that different OS versions may be the root cause.

regards

[Former Member]

Thanks all for your replies.

It is indeed about AIX and the root cause is the difference of OS versions between source system 7100-03-02-1412 and the target system 6100-07-03-1207.

Kind regards

[Former Member]

It seems some modules are missing.
Make sure that the new host does fulfill all the software requirements for your version of Oracle.
Also make sure that Oracle software is installed (or restored) completely.

regards