Skip to Content
0
Former Member
Jul 14, 2015 at 03:54 PM

SAP Instance not start after database restore

174 Views

Hi all.

I have problem to start the SAP application.

We had a disk problem and we need to restore the SAP database. But after restore the SAP application is not starting.

Can someone help me?

Follow the logs analised by me:

ENVIRONMENT VARIABLES

SAPSYSTEMNAME=ED0

DIR_LIBRARY=/usr/sap/ED0/SYS/exe/run

LD_LIBRARY_PATH=/usr/sap/ED0/SYS/exe/run:/oracle/client/10x_64/instantclient

JAVA_HOME=/opt/IBMJava2-ppc64-142

THREAD=NOPS

dbms_type=ORA

dbs_ora_tnsname=ED0

dbs_ora_schema=SAPSR3

ORACLE_SID=ED0

DB_SID=ED0

ORACLE_BASE=/oracle

TNS_ADMIN=/usr/sap/ED0/SYS/profile/oracle

ORACLE_HOME=/oracle/ED0/102_64

NLS_LANG=AMERICAN_AMERICA.UTF8

SAPDATA_HOME=/oracle/ED0

START DATABASE

SQL> startup

ORACLE instance started.

Total System Global Area 2365587456 bytes

Fixed Size 2147184 bytes

Variable Size 1191197840 bytes

Database Buffers 1157627904 bytes

Redo Buffers 14614528 bytes

Database mounted.

Database opened.

SQL>

CHECK DATABASE STATUS

SQL> select open_mode from v$database;

OPEN_MODE

----------

READ WRITE

SQL>

CHECK OPS$ USERS ON DATABASE

SQL> select username, account_status from dba_users;

USERNAME ACCOUNT_STATUS

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

SAPSR3 OPEN

DBSNMP EXPIRED

OUTLN OPEN

OPS$ORAED0 OPEN

OPS$ED0ADM OPEN

OPS$SAPSERVICEED0 OPEN

SYS OPEN

SYSTEM OPEN

TSMSYS EXPIRED & LOCKED

DIP EXPIRED & LOCKED

ORACLE_OCM EXPIRED & LOCKED

11 rows selected.

LISTENER STATUS

hades:oraed0 52> lsnrctl status

LSNRCTL for Linux: Version 10.2.0.4.0 - Production on 14-JUL-2015 12:19:00

Copyright (c) 1991, 2007, Oracle. All rights reserved.

Connecting to (ADDRESS=(PROTOCOL=IPC)(KEY=ED0.WORLD))

STATUS of the LISTENER

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

Alias LISTENER

Version TNSLSNR for Linux: Version 10.2.0.4.0 - Production

Start Date 14-JUL-2015 09:56:21

Uptime 0 days 2 hr. 22 min. 38 sec

Trace Level off

Security ON: Local OS Authentication

SNMP OFF

Listener Parameter File /oracle/ED0/102_64/network/admin/listener.ora

Listener Log File /oracle/ED0/102_64/network/log/listener.log

Listening Endpoints Summary...

(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=ED0.WORLD)))

(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=ED0)))

(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=hades.drogaraia.com.br)(PORT=1527)))

Services Summary...

Service "ED0" has 1 instance(s).

Instance "ED0", status UNKNOWN, has 1 handler(s) for this service...

The command completed successfully

R3trans -x

hades:ed0adm 40> R3trans -x

This is R3trans version 6.14 (release 701 - 26.01.09 - 12:46:00).

unicode enabled version

R3trans finished (0000).

hades:ed0adm 41>

R3trans -d

hades:ed0adm 41> R3trans -d

This is R3trans version 6.14 (release 701 - 26.01.09 - 12:46:00).

unicode enabled version

2EETW000 sap_dext called with msgnr "2":

2EETW000 ---- db call info ----

2EETW000 function: db_ntab

2EETW000 fcode: NT_RDTDESCR

2EETW000 tabname: TADIR

2EETW000 len (char): 5

2EETW000 key: TADIR

2EETW000 retcode: 2

R3trans finished (0012).

hades:ed0adm 42>

trans.log

hades:ed0adm 42> tail trans.log

2EETW000 sap_dext called with msgnr "2":

2EETW000 ---- db call info ----

2EETW000 function: db_ntab

2EETW000 fcode: NT_RDTDESCR

2EETW000 tabname: TADIR

2EETW000 len (char): 5

2EETW000 key: TADIR

2EETW000 retcode: 2

4 ETW000 [dev trc ,00000] db_con_rollback (con_da={R/3,0,0},th_rollback=1,tx=0)

4 ETW000 125 0.164155

hades:ed0adm 43>

Regards,

Fábio Belli