ERROR: ORA-12547: TNS:lost contact

[Former Member]

Hi Experts,

I am installing DB instance with homogeneous restore method with oracle 12.1 offline backup and getting sqlplus script error at Oracle backup/Restore database -control.sql phase.

Restoration was done successfully and started with continued with above Phase but i am getting the below error. So manually executed the CONTROL.SQL file and database is in open stage.

Retried with the error phase. It is trying execute the control file with sapinst tool and end up with the same error.

Below is the ora_sql_results.log  log file.

SQL*Plus: Release 12.1.0.2.0 Production on Wed Feb 24 12:26:38 2016

Copyright (c) 1982, 2014, Oracle.  All rights reserved.

Connected to an idle instance.

ERROR:

ORA-01034: ORACLE not available

ORA-27101: shared memory realm does not exist

SVR4 Error: 2: No such file or directory

Additional information: 2581

Additional information: 528625991

Process ID: 0

Session ID: 0 Serial number: 0

Disconnected

SAPINST: End of output of SQL executing program /oracle/GFP/121/bin/sqlplus.

2016-02-24, 12:26:40 SAPINST ORACLE stop logging

================================================================================

2016-02-24, 12:26:41 SAPINST ORACLE start logging for

CREATE SPFILE FROM PFILE;

exit;

Output of SQL executing program:

SQL*Plus: Release 12.1.0.2.0 Production on Wed Feb 24 12:26:41 2016

Copyright (c) 1982, 2014, Oracle.  All rights reserved.

Connected to an idle instance.

File created.

Disconnected

SAPINST: End of output of SQL executing program /oracle/GFP/121/bin/sqlplus.

2016-02-24, 12:26:43 SAPINST ORACLE stop logging

================================================================================

2016-02-24, 12:26:47 SAPINST ORACLE start logging for

CONNECT / AS SYSDBA

SHUTDOWN ABORT

@CONTROL.SQL

SHUTDOWN IMMEDIATE

STARTUP MOUNT

ALTER DATABASE ARCHIVELOG;

ALTER DATABASE OPEN;

SHUTDOWN IMMEDIATE

EXIT

exit;

Output of SQL executing program:

SQL*Plus: Release 12.1.0.2.0 Production on Wed Feb 24 12:26:48 2016

Copyright (c) 1982, 2014, Oracle.  All rights reserved.

ERROR:

ORA-12547: TNS:lost contact

SP2-0751: Unable to connect to Oracle.  Exiting SQL*Plus

SAPINST: End of output of SQL executing program /oracle/GFP/121/bin/sqlplus.

SAPINST found errors.

SAPINST The current process environment may be found in sapinst_ora_environment.log.

2016-02-24, 12:26:49 SAPINST ORACLE stop logging

gfp-db:oragfp 33% more ora_sql_results.log

================================================================================

2016-02-24, 12:24:57 SAPINST ORACLE start logging for

shutdown immediate;

exit;

Output of SQL executing program:

SQL*Plus: Release 12.1.0.2.0 Production on Wed Feb 24 12:24:57 2016

Copyright (c) 1982, 2014, Oracle.  All rights reserved.

Connected to an idle instance.

ERROR:

ORA-01034: ORACLE not available

ORA-27101: shared memory realm does not exist

SVR4 Error: 2: No such file or directory

Additional information: 2581

Additional information: 528625991

Process ID: 0

Session ID: 0 Serial number: 0

Disconnected

SAPINST: End of output of SQL executing program /oracle/GFP/121/bin/sqlplus.

SAPINST found errors.

SAPINST The current process environment may be found in sapinst_ora_environment.log.

2016-02-24, 12:25:06 SAPINST ORACLE stop logging

================================================================================

2016-02-24, 12:26:37 SAPINST ORACLE start logging for

SHUTDOWN IMMEDIATE;

exit;

Output of SQL executing program:

SQL*Plus: Release 12.1.0.2.0 Production on Wed Feb 24 12:26:38 2016

Copyright (c) 1982, 2014, Oracle.  All rights reserved.

Connected to an idle instance.

ERROR:

ORA-01034: ORACLE not available

ORA-27101: shared memory realm does not exist

SVR4 Error: 2: No such file or directory

Additional information: 2581

Additional information: 528625991

Process ID: 0

Session ID: 0 Serial number: 0

Disconnected

SAPINST: End of output of SQL executing program /oracle/GFP/121/bin/sqlplus.

2016-02-24, 12:26:40 SAPINST ORACLE stop logging

================================================================================

2016-02-24, 12:26:41 SAPINST ORACLE start logging for

CREATE SPFILE FROM PFILE;

exit;

Output of SQL executing program:

SQL*Plus: Release 12.1.0.2.0 Production on Wed Feb 24 12:26:41 2016

Copyright (c) 1982, 2014, Oracle.  All rights reserved.

Connected to an idle instance.

File created.

Disconnected

SAPINST: End of output of SQL executing program /oracle/GFP/121/bin/sqlplus.

2016-02-24, 12:26:43 SAPINST ORACLE stop logging

================================================================================

2016-02-24, 12:26:47 SAPINST ORACLE start logging for

CONNECT / AS SYSDBA

SHUTDOWN ABORT

@CONTROL.SQL

SHUTDOWN IMMEDIATE

STARTUP MOUNT

ALTER DATABASE ARCHIVELOG;

ALTER DATABASE OPEN;

SHUTDOWN IMMEDIATE

EXIT

exit;

Output of SQL executing program:

SQL*Plus: Release 12.1.0.2.0 Production on Wed Feb 24 12:26:48 2016

Copyright (c) 1982, 2014, Oracle.  All rights reserved.

ERROR:

ORA-12547: TNS:lost contact

SP2-0751: Unable to connect to Oracle.  Exiting SQL*Plus

SAPINST: End of output of SQL executing program /oracle/GFP/121/bin/sqlplus.

SAPINST found errors.

SAPINST The current process environment may be found in sapinst_ora_environment.log.

2016-02-24, 12:26:49 SAPINST ORACLE stop logging

Please let me know if you need more details

Regards,

Govardhan.

[Former Member]

I understand the issue it is related to connectivity issue from SAP instance to DB instance. When i run R3trans -d with <sid>adm from SAP instance, I am getting the below error.

gfp:gfpadm 57% R3trans -d

This is R3trans version 6.24 (release 742 - 18.11.14 - 20:14:09).

unicode enabled version

2EETW169 no connect possible: "maybe someone set invalid values for DIR_LIBRARY ('/usr/sap/GFP/SYS/exe/run') or dbms_type ('ORA')"

R3trans finished (0012).

But above environment variables are maintained properly. Please let me know if you can find anything.

Regards,

Govardhan.

[Former Member]

Below are the trans.log file details.

4 ETW000 R3trans version 6.24 (release 742 - 18.11.14 - 20:14:09).

4 ETW000 unicode enabled version

4 ETW000 ===============================================

4 ETW000

4 ETW000 date&time   : 25.02.2016 - 11:57:37

4 ETW000 control file: <no ctrlfile>

4 ETW000 R3trans was called as follows: R3trans -d

4 ETW000  trace at level 2 opened for a given file pointer

4 ETW000  [     dev trc,00000]  Thu Feb 25 11:57:37 2016                                                 119  0.000119

4 ETW000  [     dev trc,00000]  db_con_init called                                                        20  0.000139

4 ETW000  [     dev trc,00000]  set_use_ext_con_info(): ssfs will be used to get connect information

4 ETW000                                                                                                  47  0.000186

4 ETW000  [     dev trc,00000]  determine_block_commit: no con_hdl found as blocked for con_name = R/3

4 ETW000                                                                                                  32  0.000218

4 ETW000  [     dev trc,00000]  create_con (con_name=R/3)                                                 19  0.000237

4 ETW000  [     dev trc,00000]  Loading DB library '/usr/sap/GFP/SYS/exe/run/dboraslib.so' ...            88  0.000325

4 ETW000  [dlux.c      ,00000]  *** ERROR => DlLoadLib()==DLENOACCESS - dlopen("/usr/sap/GFP/SYS/exe/run/dboraslib.so") FAILED

4 ETW000                          "ld.so.1: R3trans: fatal: libc.so.1: open failed: No such file or directory"

4 ETW000                                                                                              451425  0.451750

4 ETW000  [dbcon.c     ,00000]  *** ERROR => Couldn't load library '/usr/sap/GFP/SYS/exe/run/dboraslib.so'

4 ETW000                                                                                                 187  0.451937

2EETW169 no connect possible: "maybe someone set invalid values for DIR_LIBRARY ('/usr/sap/GFP/SYS/exe/run') or dbms_type ('ORA')"

[Former Member]

Under which user id are the Oracle processes running (should be "oracle") and which user are you using to run the restore (should be ora<sid>)?

Also refer to note 1915317 in regards to ownership of the br-tools.

[Former Member]

Hi Thomas,

Yes thats right i am using ora<sid>. But even in source system also i used ora<sid> then built the system(including oracle software) and same thing i am using in target server(ora<tar_sid>.

Source system is running fine and enhancement is going perfectly alright.

Please correct me if my understanding wrong.

Note:I am doing homogeneous system copy(backup & restore) and SAP distributed installation as note is talking about SAP standard installation.

Regards,

Govardhan.

[Former Member]

Thanks for your response Govardhan.

I have the following reason to ask about users "oracle" and "ora<sid>" is:

your copied system will be SAP standard installation where the software owner will be "oracle" and all administration tasks are done via "ora<sid>" whereas in your source ystem it's "ora<sid>" only.

Have you just tried to connect to the database outside of the installation process? For example, start sqlplus as ora<sid> and then run a select on v$instance to see of the connection works or not.

Are the Oracle processes running?

Regards, Thomas.

[Former Member]

HI Thomas,

As i mentioned in the issue log database status is in open stage. I have as sqlplus and v$instance status only.

Regards,

Govardhan.