brconnect libnnz11.so: cannot open shared object file: No such file or directory

[arya_biswas]

Hi Experts,

I have ran to an issue..

I was upgrading Oracle 11.2.0.3 to 12.1.0.2.

OS - Suse Linux

Upgraded the Brtools to 7.40 (16)

Created Database profile for 12c

Craeted OPS$ORACLE

Then while trying to execute brconnect -u / -f check or brbackup -u / -q i'm getting this error -

brconnect: error while loading shared libraries: libnnz11.so: cannot open shared object file: No such file or directory

brbackup: error while loading shared libraries: libnnz11.so: cannot open shared object file: No such file or directory

All permissions looks ok.

lrwxrwxrwx 1 oracle oinstall       11  libnnz10.so -> libnnz11.so

-rw-r--r-- 1 oracle oinstall 11705222   libnnz11.a

-rw-r--r-- 1 oracle oinstall  7955322   libnnz11.so

-rwsrwsr-- 1 oracle oinstall 10016505  brarchive

-rwsrwsr-- 1 oracle oinstall 10105330  brbackup

-rwsrwsr-- 1 oracle oinstall 12113091  brconnect

-rwsrwsr-- 1 oracle oinstall 10571753  brrecover

-rwsrwsr-- 1 oracle oinstall  6217759  brrestore

-rwsrwsr-- 1 oracle oinstall 12586841  brspace

-rwxr-xr-x 1 sidadm sapsys    6828776  brtools

Tried to run brconnect -u // -f check

Restarted the server even. Still no luck.

Although brtools is opening atleast.

Can anyone could guide.

Thanks

//Arya

[former_member185239 · Accepted solution]

Hi Arya,

Have you check the oracle/client folder and you need to check the softlink properly.

Also check , whether the user oracle is having group oper at OS level.

With Regards

Ashutosh Chaturvedi

[arya_biswas · Accepted solution]

Hi Ashutosh,

Oracle id has oper group and permission in /oracle/client looks good.

instantclient with sidadm/sapsys

and under this all do have orasid and dba.

[arya_biswas]

Hi Experts,

Thank you for all your suggestions.

However my issue is resolved. Thanks Ashutosh for giving the exact hint.

Let me jot down the process carried out in this case -

1. All the initial check suggested that there may not be any issue from /oracle/SID/11203/lib location. Everything looks fine.
2. Checked the environment variable LD_LIBRARY_PATH. it was ok too.
3. Went to kernel location and ran ldd dboraslib.so and there found that libnnz11.so is not picking up proper value.
4. So it is certain that only one other place is left for this library file. That is oracle client, /oracle/client/11x_64/instantclient.
5. There found that it is not properly assigned (linking is not working)
6. Tried to remove and rebuilt the link. It did not worked.
7. So deleted everything from this location(keeping backup)
8. Uncar the client again from software archive.
9. And re-built the links.
10. Checked from kernel location ldd dboraslib.so and everything looks ok.

Must say one of colleague did a great help.

Issue resolved.

Thank you very much. Closing the case.

//Arya

[former_member207186]

Hi,

Have you checked and followed the datbase upgrade guide available on the SAP Service
Marketplace as described in SAP Note 1914631 ?

Since you are using Oracle 12c please also check carefully SAP Note 1598594 - BR*Tools configuration for Oracle installation using user "oracle" .

Regards,

Bíborka

[arya_biswas]

Hi Biborka,

I gone through them... But none of the steps helped me to resolve the issue yet..

Still finding!

//Arya

[former_member182657]

Hi,

Could you check with SAP Note 1449619 - BR*Tools cannot be started on Oracle 11g

Regards,

[arya_biswas]

Hi Gaurav,

Thank you for the reply.

But it didn't worked.

It's getting very strange... Everything seems to be ok.

Can anyone please guide how brconnect/brbackup calls happen, step wise. Want to debug.

//Arya

[Former Member]

Hi Arya,

As far as I know OPS$ mechanism was stopped after 11g and creating link for libnnz11.so is only for Br*Tools up-to version 7.20 or Oracle of 11x version.

The correct permission for BR files should be as follow..

-rwsrwxr--	orasid	sapsys	brarchive
-rwsrwxr--	orasid	sapsys	brbackup
-rwsrwxr--	orasid	sapsys	brconnect
-rwxr-xr-x	sidadm	sapsys	brrecover
-rwxr-xr-x	sidadm	sapsys	brrestore
-rwxr-xr-x	sidadm	sapsys	brspace
-rwxr-xr-x	sidadm	sapsys	brtools

The sticky bit 'S' is very important for the br* files.

For reference:

113747 - Owners and authorizations for BR*Tools

776505 - ORA-01017/ORA-01031 in BR*Tools on Linux and Solaris 11

Also please make sure that below entries are present in /etc/group file

• dba:!:202: sidadm,orasid

• oper:!:203: sidadm,orasid

• sapsys:!:200: orasid,sidadm

Regards,

Prithviraj.