post steps for DB recovery in case of different Installation type and different hostname

[ahmed_ibrahim2]

Hi experts ;

what are the post steps for Oracle DB recovery  in case of  the installation type is different  and different hostname  ??

i am trying to restore SAP ERP production  System (clustered ), on central installation with same SID , the complete restoration has been done and the  DB is running in open state , but there is not connection between SAP application and Oracle DB .

this the Details for Source System

SAP ERP6 clustered  system  (2 physical node)

OS: Linux Redhat 5

DB:  Oracle 11.2 with client 11.2

SID: E1R

virtual host name: r01se1rdb

this the Details for Target System

SAP ERP6 central installation (VM Machine)

OS: Linux Redhat 5

DB:  Oracle 11.2 with client 11.2

SID: E1R

virtual host name: r01se1r

Best Regards,

Ahmed Ibrahim

[ahmed_ibrahim2 · Accepted solution]

Dear All

Kindly check also the startdb.log

r01se1r:e1radm 55> more /home/e1radm/startdb.log

------------------------------ Sun Mar 31 17:15:45 AST 2013

LOGFILE FOR STARTING ORACLE

Trying to start E1R database ...

------------------------------ Sun Mar 31 17:15:45 AST 2013

checking required environment variables

ORACLE_HOME  is >/oracle/E1R/112_64<

ORACLE_SID   is >E1R<

------------------------------ Sun Mar 31 17:15:45 AST 2013

check initora

------------------------------ Sun Mar 31 17:15:45 AST 2013

check initora

------------------------------ Sun Mar 31 17:15:45 AST 2013

checking V2 connect

TNS Ping Utility for Linux: Version 11.2.0.2.0 - Production on 31-MAR-2013 17:15:45

Copyright (c) 1997, 2010, Oracle.  All rights reserved.

Used parameter files:

/usr/sap/E1R/SYS/profile/oracle/sqlnet.ora

Used TNSNAMES adapter to resolve the alias

Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (COMMUNITY = SAP.WORLD) (PROTOCOL = TCP) (HOST = r01se1r) (PORT = 1527))) (CONNECT_DATA = (SID = E1R) (G

LOBAL_NAME = E1R.WORLD)))

OK (0 msec)

tnsping: V2 connect to E1R

------------------------------ Sun Mar 31 17:15:45 AST 2013

Connect to the database to check the database state:

R3trans: connect check finished with return code: 12

Database not available

------------------------------ Sun Mar 31 17:15:45 AST 2013

Shutdown database

First trying to shutdown the database - May be,

the database is in the nomount or mount state

------------------------------ Sun Mar 31 17:15:45 AST 2013

starting database

SQL*Plus: Release 11.2.0.2.0 Production on Sun Mar 31 17:15:45 2013

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

ERROR:

ORA-12547: TNS:lost contact

ORA-12547: TNS:lost contact

------------------------------ Sun Mar 31 17:15:46 AST 2013

Connect to the database to verify, that the database is now open

R3trans check finished with return code: 12

*** ERROR: Startup of database failed

    Notify Database Administrator.

/usr/sap/E1R/SYS/exe/run/startdb: Terminating with error code 12

Best Regards

Ahmed

[former_member188883 · Accepted solution]

Hi Ahmed,

Refer this link http://www.dadbm.com/2012/11/how-to-fix-ora-12547-tns-lost-contact-when-try-to-connect-to-oracle/

Hope this helps.

Regards,

Deepak Kori

[ahmed_ibrahim2 · Accepted solution]

thank you very much Deepak Kori

it was very helpful

you will find same solution in sap notes 583861

Best Regards

Ahmed Ibrahim

[former_member188883 · Accepted solution]

Thanks ahmed for the note number

[Former Member]

i am trying to restore SAP ERP production  System (clustered ), on central installation with same SID , the complete restoration has been done and the  DB is running in open state , but there is not connection between SAP application and Oracle DB .

Why you decided that your DB is running in open mode? Is you performed oracle startup from sqlplus? Can you see oracle processes and shared memory allocated from OS level? Please attach output of sysresv command from ora<sid> user. Also answer on:

1) what do you mean about clustered installation: red hat clustering or Oracle RAC?

2) what steps you performed on target system to restore your production db?

3) what SBPs you have installed on source and target systems?

[ahmed_ibrahim2]

Hi Roman ,

i perform the oracle startup from SQLPLUS and it's Running , by the way the SAP system is running and accessible if i run the command startsap all from <SID>adm user while DB is running  ,but if i run the command startsap while DB is down i will get that error was posted before

--

result of sysresv

------------------------------------------------------------------

r01se1r:orae1r 40> sysresv

IPC Resources for ORACLE_SID "E1R" :

Shared Memory:

ID              KEY

67698703        0x7680396c

Semaphores:

ID              KEY

16252937        0xc2c56850

Oracle Instance alive for sid "E1R"

-------------------------------------------------------------

1- I mean about clustered installation: red hat clustering (which is 2 nodes 4 services ASCS , DB ,ERS , CI )

--------------------------------------------------------------

2 -

the target system is a normal central  installation with same SID "E1R" But Different Host name,  i just restore the control file  after that i restore Data file by using HP Data Protector system (during backup i used Util_file Device ) after that i perform database recovery

recovery database using backup controlfile until cancel ;

alter database open resetlogs;

and i recover TEMP table space

now i am able to start BD from SQLPLUS not from startsap all

------------------------------------------------------------------------

3 -  i install ERP 6 + Oracle in source and target only

Regards ,

Ahmed

[ahmed_ibrahim2]

This message was moderated.

[Former Member]

Hi,

    Can you please execute R3trans -d and share the trans.log?

Please see the below link that contains the steps that needs to be executed after the DB restore.

http://scn.sap.com/message/13834899#13834899

Please check the below note as well it contains the steps that are needed to be executed in case of any error that can be see in trans.log

Note 400241 - Problems with ops$ or sapr3 connect to Oracle

I hope this helps

Thanks and Regards,

Vimal

[ahmed_ibrahim2]

Dear Vimal,

thank you for your replay

kindly check the result of R3trans -d Command

---------

r01se1r:e1radm 52> R3trans -d

This is R3trans version 6.23 (release 720 - 31.10.12 - 20:12:06).

unicode enabled version

2EETW169 no connect possible: "DBMS = ORACLE                           --- dbs_ora_tnsname = 'E1R'"

R3trans finished (0012).

----------------------------------------------------------------------------------------------------------------------------

r01se1r:e1radm 53> more /home/e1radm/trans.log

4 ETW000 R3trans version 6.23 (release 720 - 31.10.12 - 20:12:06).

4 ETW000 unicode enabled version

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

4 ETW000

4 ETW000 date&time   : 31.03.2013 - 13:05:32

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]  Sun Mar 31 13:05:32 2013                                                  74  0.000074

4 ETW000  [     dev trc,00000]  db_con_init called                                                        21  0.000095

4 ETW000  [     dev trc,00000]  set_use_ext_con_info(): rsdb/ssfs_connect not set => ssfs not used        23  0.000118

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

4 ETW000                                                                                                  21  0.000139

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

4 ETW000  [     dev trc,00000]  Loading DB library '/usr/sap/E1R/SYS/exe/run/dboraslib.so' ...            32  0.000180

4 ETW000  [     dev trc,00000]  DlLoadLib() success: dlopen("/usr/sap/E1R/SYS/exe/run/dboraslib.so"), hdl 0

4 ETW000                                                                                                7560  0.007740

4 ETW000  [     dev trc,00000]  Library '/usr/sap/E1R/SYS/exe/run/dboraslib.so' loaded                    23  0.007763

4 ETW000  [     dev trc,00000]  function DbSlExpFuns loaded from library /usr/sap/E1R/SYS/exe/run/dboraslib.so

4 ETW000                                                                                                  23  0.007786

4 ETW000  [     dev trc,00000]  Version of '/usr/sap/E1R/SYS/exe/run/dboraslib.so' is "720.00", patchlevel (0.327)

4 ETW000                                                                                                  95  0.007881

4 ETW000  [     dev trc,00000]  function dsql_db_init loaded from library /usr/sap/E1R/SYS/exe/run/dboraslib.so

4 ETW000                                                                                                  22  0.007903

4 ETW000  [     dev trc,00000]  function dbdd_exp_funs loaded from library /usr/sap/E1R/SYS/exe/run/dboraslib.so

4 ETW000                                                                                                  33  0.007936

4 ETW000  [     dev trc,00000]  function sapic_get_instant_client_version loaded from library /usr/sap/E1R/SYS/exe/run/dboraslib.so

4 ETW000                                                                                                  22  0.007958

4 ETW000  [     dev trc,00000]  function sapic_get_instant_client_flavor loaded from library /usr/sap/E1R/SYS/exe/run/dboraslib.so

4 ETW000                                                                                                  21  0.007979

4 ETW000  [     dev trc,00000]  function sapic_get_patchset_version loaded from library /usr/sap/E1R/SYS/exe/run/dboraslib.so

4 ETW000                                                                                                  19  0.007998

4 ETW000  [     dev trc,00000]  function sapic_get_ls_inventory loaded from library /usr/sap/E1R/SYS/exe/run/dboraslib.so

4 ETW000                                                                                                  20  0.008018

4 ETW000  [     dev trc,00000]  -->DbSlControl(con=-1,cmd=47=DBSL_CMD_IMP_FUNS_SET) -> changed=30, tagset=1

4 ETW000                                                                                                  34  0.008052

4 ETW000  [     dev trc,00000]  -->DbSlControl(con=-1,cmd=39=DBSL_CMD_SET_SINGLETASK)                     14  0.008066

4 ETW000  [     dev trc,00000]  -->DbSlControl(con=-1,cmd=10=DBSL_CMD_DBCA_PTR_GET)                       13  0.008079

4 ETW000  [     dev trc,00000]  New connection 0 created                                                  11  0.008090

4 ETW000  [     dev trc,00000]  0: name = R/3, con_id = -000000001, state = DISCONNECTED, tx = NO , bc = NO , hc = NO , perm = YES, reco = NO , frco = NO , timeout = 00

0, con_max = 255, con_opt = 255, occ = NO , prog =

4 ETW000                                                                                                  38  0.008128

4 ETW000  [     dev trc,00000]  -->DbSlControl(con=-1,cmd=10=DBSL_CMD_DBCA_PTR_GET)                       15  0.008143

4 ETW000  [     dev trc,00000]  db_con_connect (con_name=R/3)                                             13  0.008156

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

4 ETW000                                                                                                  16  0.008172

4 ETW000  [     dev trc,00000]  find_con_by_name found the following connection:                          10  0.008182

4 ETW000  [     dev trc,00000]  0: name = R/3, con_id = 000000000, state = DISCONNECTED, tx = NO , bc = NO , hc = NO , perm = YES, reco = NO , frco = NO , timeout = 000

, con_max = 255, con_opt = 255, occ = NO , prog =

4 ETW000                                                                                                  21  0.008203

4 ETW000  [     dev trc,00000]  -->DbSlConnect(vers=-1, type=0, env='[default env]', usr='[default usr]', kernel dbsl='720')

4 ETW000                                                                                                  62  0.008265

4 ETW000  [     dev trc,00000]  Register application info.                                               163  0.008428

4 ETW000  [     dev trc,00000]  Oracle client version: 11.2.0.2.0, V2, default build, (dbsl 720 291112, UNICODE[2])

4 ETW000                                                                                                 156  0.008584

4 ETW000  [     dev trc,00000]  Installed Oracle client patches:                                          58  0.008642

4 ETW000  [     dev trc,00000]  # Patch  9930315      : Created on 15 Oct 2010, 03:55:06 hrs PST8PDT

4 ETW000                                                                                                  39  0.008681

4 ETW000  [     dev trc,00000]  # Patch  13614088     : Created on  6 Feb 2012, 04:26:32 hrs PST8PDT

4 ETW000                                                                                                  47  0.008728

4 ETW000  [     dev trc,00000]  # Patch  11814893     : Created on 30 Mar 2011, 07:26:47 hrs PST8PDT

4 ETW000                                                                                                  32  0.008760

4 ETW000  [     dev trc,00000]  # Patch  11792348     : Created on  6 Jun 2011, 15:14:52 hrs PST8PDT

4 ETW000                                                                                                  29  0.008789

4 ETW000  [     dev trc,00000]  # Patch  11742262     : Created on  7 Mar 2012, 12:22:36 hrs CET          18  0.008807

4 ETW000  [     dev trc,00000]  # Patch  10144882     : Created on  4 Mar 2011, 10:43:35 hrs PST8PDT

4 ETW000                                                                                                  23  0.008830

4 ETW000  [     dev trc,00000]    Default connection: tnsname ='E1R'                                      15  0.008845

4 ETW000  [     dev trc,00000]  -->oci_initialize(con=0, char='UTF16', nchar='AL16UTF16', nls=-1),uc_ln=2

4 ETW000                                                                                                  30  0.008875

4 ETW000  [     dev trc,00000]  OCIEnvCreate(mode=16384=OCI_UTF16) returned 0 (for default NLS handle)

4 ETW000                                                                                                8319  0.017194

4 ETW000  [     dev trc,00000]     OCIHandleAlloc(OCI_HTYPE_ERROR, con=0, ErrHp=1123d028)                 38  0.017232

4 ETW000  [     dev trc,00000]     OCIHandleAlloc(OCI_HTYPE_ERROR, con=0, ErrBt=1123e978)                 26  0.017258

4 ETW000  [     dev trc,00000]  NLS env. settings: lang=41004D00450052004900430041004E00                 101  0.017359

4 ETW000  [     dev trc,00000]                     terr=41004D0045005200490043004100                      26  0.017385

4 ETW000  [     dev trc,00000]                     char=55005400460031003600                              26  0.017411

4 ETW000  [     dev trc,00000]  Client NLS setting (by OCINlsGetInfo(con=0)): 'AMERICAN_AMERICA.UTF16'

4 ETW000                                                                                                  20  0.017431

4 ETW000  [     dev trc,00000]  charset='UTF16', ncharset='AL16UTF16', UNI_ASC=FALSE                      13  0.017444

4 ETW000  [     dev trc,00000]  Logon as OPS$-user to get SAPSR3's password                               19  0.017463

4 ETW000  [     dev trc,00000]  Connecting as /@E1R on connection 0 (nls 0) ... (dbsl 720 291112, UNICODE[2])

4 ETW000                                                                                                  23  0.017486

4 ETW000  [     dev trc,00000]     OCIHandleAlloc(OCI_HTYPE_SVCCTX, con=0, svchp=1123cf48)                24  0.017510

4 ETW000  [     dev trc,00000]  Allocating server context handle                                          15  0.017525

4 ETW000  [     dev trc,00000]  Attaching to database server E1R (con=0, svchp=1123cf48, srvhp=11242030)

4 ETW000                                                                                                  40  0.017565

4 ETW000  [     dev trc,00000]  Assigning server context 11242030 to service context 1123cf48          20460  0.038025

4 ETW000  [     dev trc,00000]     OCIHandleAlloc(OCI_HTYPE_SESSION, con=0, usrhp=112712f0)               64  0.038089

4 ETW000  [     dev trc,00000]  Starting user session: OCISessionBegin(con=0, usr='/', svc=1123cf48, srv=11242030, usr=112712f0)

4 ETW000                                                                                                  26  0.038115

4 ETW000  [     dev trc,00000]     OCISessionBegin(OCI_DEFAULT) failed with -1=OCI_ERROR                3462  0.041577

4 ETW000  [     dev trc,00000]     OCISessionBegin(OCI_DEFAULT) failed with SQL error 1034:              131  0.041708

4 ETW000  [     dev trc,00000]     ORA-01034: ORACLE not available                                        37  0.041745

4 ETW000                        ORA-27101: shared memory realm does not exist

4 ETW000                        Linux-x86_64 Error: 2: No such file or direc

4 ETW000  [     dev trc,00000]     tory

4 ETW000                                                                                                  33  0.041778

4 ETW000  [     dev trc,00000]  server_detach(con=0,stale=1,srvhp=11242030)                               17  0.041795

4 ETW000  [     dev trc,00000]  Server handle (con=0,svchp=1123cf48,srvhp=11242030) detached             196  0.041991

4 ETW000  [     dev trc,00000]  Free server handle srvhp=11242030 of con=0                                20  0.042011

4 ETW000  [    dbsloci.,00000]  *** ERROR => CONNECT failed with sql error '1034'                         40  0.042051

4 ETW000  [     dev trc,00000]     set_ocica() -> SQL error code 1034                                     15  0.042066

4 ETW000  [     dev trc,00000]  -->oci_get_errmsg (con=0, rc=1034)                                        17  0.042083

4 ETW000  [     dev trc,00000]     OCIErrorGet -> SQL error code: 1034                                    66  0.042149

4 ETW000  [     dev trc,00000]     ORA-01034: ORACLE not available                                        18  0.042167

4 ETW000                        ORA-27101: shared memory realm does not exist

4 ETW000                        Linux-x86_64 Error: 2: No such file or direc

4 ETW000  [     dev trc,00000]     tory

4 ETW000                                                                                                  29  0.042196

4 ETW000  [     dev trc,00000]  SAPUSER error or connect error 99=DBSL_ERR_DB, oerr=1034.                 15  0.042211

4 ETW000  [     dev trc,00000]     DbSlConnect(con=0) -> orc=0, 99=DBSL_ERR_DB                            26  0.042237

4 ETW000  [    dblink  ,00000]  ***LOG BY2=>sql error 1034   performing CON                               43  0.042280

4 ETW000  [    dblink  ,00000]  ***LOG BY0=>ORA-01034: ORACLE not available                               20  0.042300

4 ETW000                        ORA-27101: shared memory realm does not exist

4 ETW000                        Linux-x86_64 Error: 2: No such file or directory

4 ETW000  [     dev trc,00000]  -->DbSlControl(con=-1,cmd=41=DBSL_CMD_RELINFO_GET)                        29  0.042329

4 ETW000  [     dev trc,00000]  -->DbSlControl(con=-1,cmd=14=DBSL_CMD_VERSION_GET)                        15  0.042344

4 ETW000  [     dev trc,00000]  -->DbSlControl(con=-1,cmd=50=DBSL_CMD_GET_PATCH_INFO)                     16  0.042360

4 ETW000  [     dev trc,00000]  -->DbSlControl(con=-1,cmd=13=DBSL_CMD_VENDOR_NAME_GET)                    37  0.042397

4 ETW000  [     dev trc,00000]  -->DbSlControl(con=-1,cmd=52=DBSL_CMD_GET_DBLIB_VERSION)                  20  0.042417

4 ETW000  [     dev trc,00000]                 -> 'OCI_102, 11.2.0.2.0, V2, default build'                16  0.042433

2EETW169 no connect possible: "DBMS = ORACLE 

-----

Best Regards ,

Ahmed

[Former Member]

Hi AHmed,

  Can you please check whether oracle is in open state?

I mean whether oracle is up  and running.

Thanks and Regards,

Vimal

[Reagan]

Hello

4 ETW000  [     dev trc,00000]  SAPUSER error or connect error 99=DBSL_ERR_DB, oerr=1034.                 15  0.042211
4 ETW000  [     dev trc,00000]     DbSlConnect(con=0) -> orc=0, 99=DBSL_ERR_DB                            26  0.042237
4 ETW000  [    dblink  ,00000]  ***LOG BY2=>sql error 1034   performing CON                               43  0.042280
4 ETW000  [    dblink  ,00000]  ***LOG BY0=>ORA-01034: ORACLE not available                               20  0.042300
4 ETW000                        ORA-27101: shared memory realm does not exist
4 ETW000                        Linux-x86_64 Error: 2: No such file or directory

Is the database up and running ?

Cheers

RB

[ahmed_ibrahim2]

HI Vimal

Oracle is not running (this is the issue)

But if i try to run Oracle manually  from SQLPLUS Oracle it will run in Open State

Best Regards

[ahmed_ibrahim2]

HI BR

Oracle is not running (this is the issue)

But if i try to run Oracle manually  from SQLPLUS Oracle it will run in Open State

Best Regards

[ahmed_ibrahim2]

HI Vimal

i check  the link that contains the steps that needs to be executed after the DB restore and i notice that you mention these procedure is valid  for 10g

is it valid for 11g ??

Best Regards

Ahmed

[Former Member]

Yes Ahmed. It is valid for oracle 11.

If you see that link, you can see the oracle 11 has been used.