System copy

[Former Member]

Hello Gurus,

our company has split and we need to make a copy of SAP system for backup purposes and occasional viewing. Our SAP runs on Linux Red Hat and Oracle db.

We did the database copy from PRD to QAS to have fresh data there.

Then we thought the simplest solution will be cloning of the whole filesystem from QAS machine to the new backup machine, so we did it.

But now SAP doesn't start on the new backup machine:

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

DB startup failed

But when we check the database with sqlplus, we see it is on and accessible.

Please, do you have any idea?

Thank you,

Ondrej

[sunny_pahuja2 · Accepted solution]

Hi,

This is not a SAP recommended process.

But you can try to change hostname in the profile and also rename profile as per your hostname. You also need to change hostname entries in listener.ora and tnsnames.ora file.

Thanks

Sunny

[Former Member · Accepted solution]

Sunny: Yes, it's not SAP recommended process, but it's just for backup purpose, so we tought this simple clone would be the quickest way... OK, I will try to change the hostname. Thank you!

[nirmal_konchada]

Hi,

First of all you need to check the UID and GID for all sap related users and groups at OS level. It must be same on both servers.

This is done to keep a sync on the file permissions.

Once this is done then you need to change the host name in all SAP profiles.

Regards,

Nirmal.K

[JPReyes]

Can you post the content of dev_w0?

Did you follow the homogeneous system copy guide?, what was exactly the steps taken?

Also, can you check the DB log for errors?

Regards

Juan

[Former Member]

Juan: No, it was only simple filesystem clone.

I will post the dev_w0 :

[Former Member]

---------------------------------------------------
trc file: "dev_w0", trc level: 1, release: "700"
---------------------------------------------------
*
*  ACTIVE TRACE LEVEL           1
*  ACTIVE TRACE COMPONENTS      all, MJ
*
M sysno      00
M sid        E14
M systemid   390 (AMD/Intel x86_64 with Linux)
M relno      7000
M patchlevel 0
M patchno    201
M intno      20050900
M make:      single threaded, ASCII, 64 bit, optimized
M pid        16569
M 
M  
M Wed Jan 19 10:49:46 2011
M  kernel runs with dp version 242(ext=110) (@(#) DPLIB-INT-VERSION-242)
M  length of sys_adm_ext is 364 bytes
M  ***LOG Q01=> ThInit, WPStart (Workproc 0 1 16569) [thxxhead.c   1292]
M  ThInit: running on host sapdevel
M  calling db_connect ...
C  Oracle Client Version: '10.2.0.4.0'
C  application info callback registered
C  
C Wed Jan 19 10:49:47 2011
C  Client NLS setting (OCINlsGetInfo): connection handle 0 -> 'AMERICAN_AMERICA.WE8DEC'
C  Logon as OPS$-user to get SAPSR3's password
C  Connecting as /@E14 on connection 0 (nls_hdl 0) ... (dbsl 700 270309)
C  Nls CharacterSet                 NationalCharSet                   EnvHp      ErrHp ErrHpBatch
C    0 WE8DEC                                                    0x146da6e0 0x146e21c0 0x146e5b28
C  Attaching to DB Server E14 (con_hdl=0,svchp=0x146e5a58,srvhp=0x146e8408)
C  Starting user session: OCISessionBegin(con_hdl=0, usr='/',svchp=0x146e5a58, srvhp=0x146e8408, usrhp=0x14727850)
C  
C Wed Jan 19 10:49:48 2011
C     OCISessionBegin(OCI_DEFAULT) failed with SQL error 1034:
C     ORA-01034: ORACLE not available
C  ORA-27101: shared memory realm does not exist
C  Linux-x86_64 Error: 2: No such file or direc
C     tory                                                                                
C  Detaching from DB Server (con_hdl=0,svchp=0x146e5a58,srvhp=0x146e8408)
C  *** ERROR => CONNECT failed with sql error '1034'
 [dbsloci.c    11161]
C  Try to connect with default password
C  Connecting as SAPSR3/<pwd>@E14 on connection 0 (nls_hdl 0) ... (dbsl 700 270309)
C  Nls CharacterSet                 NationalCharSet                   EnvHp      ErrHp ErrHpBatch
C    0 WE8DEC                                                    0x146da6e0 0x146e21c0 0x146e5b28
C  Attaching to DB Server E14 (con_hdl=0,svchp=0x146e5a58,srvhp=0x146e8408)
C  Starting user session: OCISessionBegin(con_hdl=0, usr=SAPSR3/<pwd>, svchp=0x146e5a58, srvhp=0x146e8408, usrhp=0x14727850)
C     OCISessionBegin(OCI_DEFAULT) failed with SQL error 1034:
C     ORA-01034: ORACLE not available
C  ORA-27101: shared memory realm does not exist
C  Linux-x86_64 Error: 2: No such file or direc
C     tory                                                                                
C  Detaching from DB Server (con_hdl=0,svchp=0x146e5a58,srvhp=0x146e8408)
C  *** ERROR => CONNECT failed with sql error '1034'
 [dbsloci.c    11161]
B  ***LOG BV3=> severe db error 1034      ; work process is stopped [dbsh#3 @ 1203] [dbsh    1203 ]
B  ***LOG BY2=> sql error 1034   performing CON [dblink#7 @ 431] [dblink  0431 ]
B  ***LOG BY0=> ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
Linux-x86_64 Error: 2: No such file or directory [dblink#7 @ 431] [dblink  0431 ]
M  ***LOG R19=> ThInit, db_connect ( DB-Connect 000256) [thxxhead.c   1451]
M  in_ThErrHandle: 1
M  *** ERROR => ThInit: db_connect (step 1, th_errno 13, action 3, level 1) [thxxhead.c   10561]
M  
M  Info for wp 0
M  
M    pid = 16569
M    severity = 0
M    status = 0
M    stat = WP_RUN
M    waiting_for = NO_WAITING
M    reqtype = DP_RQ_DIAWP
M    act_reqtype = NO_REQTYPE
M    rq_info = 0
M    tid = -1
M    mode = 255
M    len = -1
M    rq_id = 65535
M    rq_source = 
M    last_tid = 0
M    last_mode = 0
M    semaphore = 0
M    act_cs_count = 0
M    csTrack = 0
M    csTrackRwExcl = 0
M    csTrackRwShrd = 0
M    mode_cleaned_counter = 0
M    control_flag = 0
M    int_checked_resource(RFC) = 0
M    ext_checked_resource(RFC) = 0
M    int_checked_resource(HTTP) = 0
M    ext_checked_resource(HTTP) = 0
M    report = >                                        <
M    action = 0
M    tab_name = >                              <
M    attachedVm = no VM
M  PfStatDisconnect: disconnect statistics
M  Entering TH_CALLHOOKS
M  ThCallHooks: call hook >ThrSaveSPAFields< for event BEFORE_DUMP
M  *** ERROR => ThrSaveSPAFields: no valid thr_wpadm [thxxrun1.c   723]
M  *** ERROR => ThCallHooks: event handler ThrSaveSPAFields for event BEFORE_DUMP failed [thxxtool3.c  261]
M  ThCallHooks: call hook >BtcCallLgCl< for event BEFORE_DUMP
M  Entering ThSetStatError
M  ThIErrHandle: do not call ThrCoreInfo (no_core_info=0, in_dynp_env=0)
M  Entering ThReadDetachMode
M  call ThrShutDown (1)...
M  ***LOG Q02=> wp_halt, WPStop (Workproc 0 16569) [dpuxtool.c   269]

[Former Member]

The database is not started. login to sqlplus and check the database status.

[hannover_sap-basis]

Hello,

run "R3trans -x" and check trans.log.