BR0310E Connect to database instance SID failed

[Former Member]

Boa tarde caros colegas.

Gostaria de uma ajuda.

Fizemos um clone de máquina(SO, binários do SAP e binários do oracle) e fizemos um HSC do produtivo e ocorreu com sucesso.

Banco e SAP no ar com tudo diferente. Meu problema é na hora de executar o brconnect.

É executado com sucesso no usuário orasid, mas quando tento com o sidadm me dá erro.

Já chequei variáveis de ambiente, .profile, bibliotecas, relink all, permissão dono, grupo. e não consegui resolver o problema.

Erro:

gnqadm> brconnect -u / -jid CHECK20140052215300 -c -f check

BR0801I BRCONNECT 7.00 (40)

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

        0509-150   Dependent module libjox10.a(shr.o) could not be loaded.

        0509-022 Cannot load module libjox10.a(shr.o).

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

BR0805I Start of BRCONNECT processing: cenxiqwq.chk 2014-05-22 15.30.52

BR0484I BRCONNECT log file: /oracle/GNQ/sapcheck/cenxiqwq.chk

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

        0509-150   Dependent module libjox10.a(shr.o) could not be loaded.

        0509-022 Cannot load module libjox10.a(shr.o).

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

BR0280I BRCONNECT time stamp: 2014-05-22 15.30.52

BR0301E SQL error -12547 at location db_connect-2, SQL statement:

'CONNECT /'

ORA-12547: TNS:lost contact

BR0310E Connect to database instance GNQ failed

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

        0509-150   Dependent module libjox10.a(shr.o) could not be loaded.

        0509-022 Cannot load module libjox10.a(shr.o).

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

BR0280I BRCONNECT time stamp: 2014-05-22 15.30.52

BR0301E SQL error -12547 at location db_connect-2, SQL statement:

'CONNECT /'

ORA-12547: TNS:lost contact

BR0310E Connect to database instance GNQ failed

BR0806I End of BRCONNECT processing: cenxiqwq.chk 2014-05-22 15.30.52

BR0280I BRCONNECT time stamp: 2014-05-22 15.30.52

BR0804I BRCONNECT terminated with errors

Obrigado

Marcio Peixoto

.

[Former Member]

check LD_LIBRARY_PATH

[Former Member]

Hi Govind. Thanks by your aswered.

The LD_LIBRARY_PATH is correct

LIBPATH=/usr/lib:/lib:/usr/sap/GNQ/SYS/exe/run:/oracle/client/10x_64/instantclient

I can connect to the oracle and  the oracle is running.

The SAP recomends that I update BRTOOLS to lasted version as per note 12741.

But I cannot apply, because we are in project, We cannot have any problems with backup or brtools.

gnqadm> R3trans -d

This is R3trans version 6.14 (release 701 - 23.07.10 - 09:23:00).

R3trans finished (0000).

gnqadm> R3trans -x

This is R3trans version 6.14 (release 701 - 23.07.10 - 09:23:00).

R3trans finished (0000).

Regards

Marcio Peixoto

[Former Member]

can you include $ORACLE_HOME/lib:$ORACLE_HOME/lib32 in your libpath and check if it work.

[Former Member]

I added the ORACLE_HOME/lib:$ORACLE_HOME/lib32.

Now I get start sqlplus with SIDADM, but the sqlplus cannot find oracle instance.

gnqadm> sqlplus "/as sysdba"

SQL*Plus: Release 10.2.0.4.0 - Production on Tue Jun 24 17:01:49 2014

Copyright (c) 1982, 2007, Oracle.  All Rights Reserved.

Connected to an idle instance.

SQL> exit

Disconnected

I tested with :

gnqadm> sqlplus teste@gnq

SQL*Plus: Release 10.2.0.4.0 - Production on Tue Jun 24 17:02:06 2014

Copyright (c) 1982, 2007, Oracle.  All Rights Reserved.

Enter password:

Connected to:

Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production

With the Partitioning, Data Mining and Real Application Testing options

I will solve the issues on wednesday, because tomorrow in Rio de Janeiro is holiday, because has a game soccer in Maracanã Stadium.

Thank you very much

Marcio Peixoto