SAP not starting after brrestore(QAS refresh)

[Former Member]

Hi Gurus ,

We have done a QA refresh through brbackup and brrestore .

I had followed the following steps

1.) OFF-LINE backup od the PRD(production)

2.) RUN BRRESTORE in the QAS(Quality)

3.) Modify the control file generated from the PRD (to change the SID to QAS) and open the database .

4.)shutdown and restart the database.Also start the listener

5.)Start the application.

I was able to successfully complete upto STEP 4.

Now , while starting the application , i get the following error

<b>" ABAP Database is not available via R3trans"</b>

The output of R3trans -d is as

***************************************************************************************

This is R3trans version 6.13 (release 640 - 21.06.06 - 08:38:00).

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

R3trans finished (0012).

*****************************************************************************************

Also the trans.log

*************************************************************************************

4 ETW000 R3trans version 6.13 (release 640 - 21.06.06 - 08:38:00).

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

4 ETW000

4 ETW000 date&time : 01.08.2007 - 12:19:43

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] Wed Aug 1 12:19:43 2007 238 0.000238

4 ETW000 [dev trc ,00000] db_con_init called 52 0.000290

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

4 ETW000 [dev trc ,00000] Loading DB library '/usr/sap/<SIDQAS>/SYS/exe/run/dboraslib.so' ...

4 ETW000 188 0.000634

4 ETW000 [dev trc ,00000] load shared library (/usr/sap/<SIDQAS>/SYS/exe/run/dboraslib.so), hdl 0

4 ETW000 64337 0.064971

4 ETW000 [dev trc ,00000] Library '/usr/sap/<SIDQAS>/SYS/exe/run/dboraslib.so' loaded

4 ETW000 137 0.065108

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

4 ETW000 120 0.065228

4 ETW000 [dev trc ,00000] Version of '/usr/sap/<SIDQAS>/SYS/exe/run/dboraslib.so' is "640.00", patchlevel (0.125)

4 ETW000 800 0.066028

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

4 ETW000 97 0.066125

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

4 ETW000 103 0.066228

4 ETW000 [dev trc ,00000] New connection 0 created 59 0.066287

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

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

4 ETW000 121 0.066408

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

4 ETW000 [dev trc ,00000] find_con_by_name found the following connection for reuse:

4 ETW000 82 0.066544

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

con_max = 255, con_opt = 255, occ = NO

4 ETW000 88 0.066632

4 ETW000 [dev trc ,00000] Got ORACLE_HOME=/oracle/<SIDQAS>/920_64 from environment

4 ETW000 408 0.067040

4 ETW000 [dev trc ,00000] -->oci_initialize (con_hdl=0) 190 0.067230

4 ETW000 [dev trc ,00000] got NLS_LANG='AMERICAN_AMERICA.WE8DEC' from environment

4 ETW000 90 0.067320

4 ETW000 [dev trc ,00000] Client NLS settings: AMERICAN_AMERICA.WE8DEC 7448 0.074768

4 ETW000 [dev trc ,00000] Logon as OPS$-user to get SAP<SIDQAS>'s password 66 0.074834

4 ETW000 [dev trc ,00000] Connecting as /@<SIDQAS> on connection 0 (nls_hdl 0) ... (dbsl 640 310306)

4 ETW000 86 0.074920

4 ETW000 [dev trc ,00000] Nls CharacterSet NationalCharSet C EnvHp ErrHp ErrHpBat

ch

4 ETW000 90 0.075010

4 ETW000 [dev trc ,00000] 0 WE8DEC 1 10124ce20 1012560b0 101255a

48

4 ETW000 106 0.075116

4 ETW000 [dev trc ,00000] Allocating service context handle for con_hdl=0 52 0.075168

4 ETW000 [dev trc ,00000] Allocating server context handle 58 0.075226

4 ETW000 [dev trc ,00000] Attaching to DB Server <SIDQAS> (con_hdl=0,svchp=101255978,svrhp=101257e18)

4 ETW000 156 0.075382

4 ETW000 [dev trc ,00000] Assigning server context 101257e18 to service context 101255978

4 ETW000 64563 0.139945

4 ETW000 [dev trc ,00000] Allocating user session handle 75 0.140020

4 ETW000 [dev trc ,00000] Starting user session (con_hdl=0,svchp=101255978,srvhp=101257e18,usrhp=101261870)

4 ETW000 105 0.140125

4 ETW000 [dev trc ,00000] Assigning user session 101261870 to service context 101255978

4 ETW000 12611 0.152736

4 ETW000 [dev trc ,00000] BEGIN DBMS_APPLICATION_INFO.SET_MODULE (:A0, :A1); END;

4 ETW000 184 0.152920

4 ETW000 [dev trc ,00000] BEGIN DBMS_APPLICATION_INFO.SET_CLIENT_INFO (:A0); END;

4 ETW000 288 0.153208

4 ETW000 [dev trc ,00000] Now '/@<SIDQAS>' is connected (con_hdl 0, nls_hdl 0).

4 ETW000 1489 0.154697

4 ETW000 [dev trc ,00000] ALTER SESSION SET NLS_SORT = BINARY

4 ETW000 134 0.154831

4 ETW000 [dev trc ,00000] SELECT USERID,PASSWD FROM SAPUSER WHERE USERID IN (:A0, :A1)

4 ETW000 847 0.155678

4 ETW000 [dbsloci. ,00000] *** ERROR => ORA-1403 when accessing table SAPUSER

4 ETW000 1307 0.156985

4 ETW000 [dev trc ,00000] Disconnecting from connection 0 ... 98 0.157083

4 ETW000 [dev trc ,00000] Rolling back transaction ... 89 0.157172

4 ETW000 [dev trc ,00000] Closing user session (con_hdl=0,svchp=101255978,usrhp=101261870)

4 ETW000 395 0.157567

4 ETW000 [dev trc ,00000] Now I'm disconnected from ORACLE 777 0.158344

4 ETW000 [dev trc ,00000] Try to connect with default password 58 0.158402

4 ETW000 [dev trc ,00000] Connecting as SAP<SIDQAS>/<pwd>@<SIDQAS> on connection 0 (nls_hdl 0) ... (dbsl 640 310306)

4 ETW000 88 0.158490

4 ETW000 [dev trc ,00000] Nls CharacterSet NationalCharSet C EnvHp ErrHp ErrHpBat

ch

4 ETW000 87 0.158577

4 ETW000 [dev trc ,00000] 0 WE8DEC 1 10124ce20 1012560b0 101255a

48

4 ETW000 84 0.158661

4 ETW000 [dev trc ,00000] Assigning username to user session 101261870 53 0.158714

4 ETW000 [dev trc ,00000] Assigning password to user session 101261870 55 0.158769

4 ETW000 [dev trc ,00000] Starting user session (con_hdl=0,svchp=101255978,srvhp=101257e18,usrhp=101261870)

4 ETW000 250 0.159019

4 ETW000 [dboci.c ,00000] *** ERROR => OCI-call 'OCISessionBegin' failed: rc = 1017

4 ETW000 1573 0.160592

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

4 ETW000 82 0.160674

4 ETW000 [dblink ,00419] ***LOG BY2=>sql error 1017 performing CON [dblink#2 @ 419]

4 ETW000 121 0.160795

4 ETW000 [dblink ,00419] ***LOG BY0=>ORA-01017: invalid username/password; logon denied [dblink#2 @ 419]

4 ETW000 79 0.160874

2EETW169 no connect possible: "DBMS = ORACLE --- dbs_ora_tnsname = '<SIDQAS>'"

***************************************************************************************

Following are the log of brrestore ,

***************************************************

<SIDQA>scm:ora<SIDQA> 1% brrestore

BR0401I BRRESTORE 6.40 (40)

BR0405I Start of file restore: rdvuqfnl.rsb 2007-07-29 09.14.49

BR0454W Values of oracle_sid are different: current '<SIDQA>', backup bdvupcyo.aft '<SIDPRD>'

BR0455W Value '<SIDQA>' of oracle_sid will be used for restore

BR0454W Values of oracle_home are different: current '/oracle/<SIDQA>/920_64', backup bdvupcyo.aft '/oracle/<SIDPRD>/920_64'

BR0455W Value '/oracle/<SIDQA>/920_64' of oracle_home will be used for restore

BR0454W Values of sapdata_home are different: current '/oracle/<SIDQA>', backup bdvupcyo.aft '/oracle/<SIDPRD>'

BR0455W Value '/oracle/<SIDQA>' of sapdata_home will be used for restore

BR0280I BRRESTORE time stamp: 2007-07-29 09.14.50

BR0256I Enter 'c[ont]' to continue, 's[top]' to cancel BRRESTORE:

c

BR0280I BRRESTORE time stamp: 2007-07-29 09.14.55

BR0257I Your reply: 'c'

BR0259I Program execution will be continued...

BR0427I Files from the old sapdata_home /oracle/<SIDPRD> will be restored into the new sapdata_home /oracle/<SIDQA>

BR0280I BRRESTORE time stamp: 2007-07-29 09.14.56

BR0407I Restore of database: <SIDQA>

BR0408I BRRESTORE action ID: rdvuqfnl

BR0409I BRRESTORE function ID: rsb

BR0449I Restore mode: ALL

BR0419I Files will be restored from backup: bdvupcyo.aft 2007-07-29 03.52.54

BR0416I 57 files found to restore, total size 180490.445 MB

BR0425I Files will be decompressed by hardware

BR0421I Restore device type: tape

BR0102I Following backup device will be used: /dev/rmt/1mn

BR0103I Following backup volume will be used: <SIDPRD>B16 (2007-07-29 03.52.54)

BR0280I BRRESTORE time stamp: 2007-07-29 09.14.56

BR0256I Enter 'c[ont]' to continue, 's[top]' to cancel BRRESTORE:

c

BR0280I BRRESTORE time stamp: 2007-07-29 09.14.58

BR0257I Your reply: 'c'

BR0259I Program execution will be continued...

BR0208I Volume with name <SIDPRD>B16 (2007-07-29 03.52.54) required in device /dev/rmt/1mn

BR0210I Please mount BRBACKUP volume, if you have not already done so

BR0280I BRRESTORE time stamp: 2007-07-29 09.14.58

BR0256I Enter 'c[ont]' to continue, 's[top]' to cancel BRRESTORE:

c

BR0280I BRRESTORE time stamp: 2007-07-29 09.15.05

BR0257I Your reply: 'c'

BR0259I Program execution will be continued...

BR0280I BRRESTORE time stamp: 2007-07-29 09.15.05

BR0226I Rewinding tape volume in device /dev/rmt/1m ...

BR0351I Restoring /oracle/<SIDQA>/sapbackup/.tape.hdr0

BR0355I from /dev/rmt/1mn ...

BR0241I Checking label on volume in device /dev/rmt/1mn

BR0209I Volume in device /dev/rmt/1mn has name <SIDPRD>B16 (2007-07-29 03.52.54)

BR0280I BRRESTORE time stamp: 2007-07-29 09.15.05

BR0199I Volume label checked successfully

BR0351I Restoring /oracle/<SIDQA>/sapdata1/<SIDPRD>_13/<SIDPRD>.data13

BR0355I from /dev/rmt/1mn ...

#FILE..... /oracle/<SIDQA>/sapdata1/<SIDPRD>_13/<SIDPRD>.data13

#RESTORED. <SIDPRD>.data13 <SIDPRD>B16/4

.... and so on...............................

*************************************************************

Please help .,

Regards

Anthony

[fidel_vales · Accepted solution]

Hello,

The tabe SAPUSER does not exist for your OPS$ user:

<i>4 ETW000 [dev trc ,00000] Connecting as /@<SIDQAS> on connection 0 (nls_hdl 0) ... (dbsl 640 310306)

<b>*** ERROR => ORA-1403 when accessing table SAPUSER</b></i>

Then SAP is not able to retrieve the password for SAP<SIDQAS>

As this is the case, SAP tries with the default password and it fails, because you have changed the password for this user.

Please, check note 361641 on how to recreate the OPS$ user

[Former Member · Accepted solution]

Hi Fidel Vales ,

I had already applied the note 361641.

Please find attached the Logs

********************************************************

<SIDQAS>scm:ora<SIDQAS> 1% sqlplus /nolog @/oracle/<SIDQAS>/sapdata4/ORADBUSR.SQL SAP<SIDPRD> UNIX <SIDQAS> X

SQL*Plus: Release 9.2.0.7.0 - Production on Wed Aug 1 13:55:07 2007

Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.

Connected.

old 6: if length('&&1') = 5 then

new 6: if length('SAP<SIDPRD>') = 5 then

old 7: if substr(upper('&&1'),1,5) = 'SAPR3' then

new 7: if substr(upper('SAP<SIDPRD>'),1,5) = 'SAPR3' then

old 11: if upper('&&2') = 'NT' then

new 11: if upper('UNIX') = 'NT' then

old 18: :sDomain := upper('&&3');

new 18: :sDomain := upper('<SIDQAS>');

old 19: :sSapSid := upper('&&4');

new 19: :sSapSid := upper('X');

old 21: :sSapSid := upper('&&3');

new 21: :sSapSid := upper('<SIDQAS>');

old 37: :sSchema := upper('&&1');

new 37: :sSchema := upper('SAP<SIDPRD>');

old 39: if upper('&&2') = 'NT' then

new 39: if upper('UNIX') = 'NT' then

old 46: :sDomain := upper('&&3');

new 46: :sDomain := upper('<SIDQAS>');

old 47: :sSapSid := upper('&&4');

new 47: :sSapSid := upper('X');

old 49: :sSapSid := upper('&&3');

new 49: :sSapSid := upper('<SIDQAS>');

using following Parameters:

.

. Oracle Version: 9.2.0.7.0

. Parametervalue os_authent_prefix: OPS$

. Schema Id: <SIDPRD>

. Database User (Schema): SAP<SIDPRD>

. SAP R/3 Administrator: OPS$<SIDQAS>ADM

. SAP R/3 Serviceuser: OPS$SAPSERVICE<SIDQAS>

.

User OPS$ORA<SIDQAS>does already exist.

Connected.

Connected.

Disconnected from Oracle9i Enterprise Edition Release 9.2.0.7.0 - 64bit Production

With the Partitioning option

JServer Release 9.2.0.7.0 - Production

********************************************************************************

Also to reset the password of SAP<SID> . I am not much aware of oracle database , hence i was not knowing the password of system user , I had given the password as system only..

*********************************************************************

<SIDQAS>scm:ora<SIDQAS> 2% brconnect -u system/system -f chpass -o SAP<SIDPRD> -p SAP<SIDPRD>

BR0801I BRCONNECT 6.40 (40)

BR0280I BRCONNECT time stamp: 2007-08-01 13.57.11

BR0828I Changing password for database user SAP<SIDPRD>

BR0280I BRCONNECT time stamp: 2007-08-01 13.57.11

BR0256I Enter 'c[ont]' to continue, 's[top]' to cancel BRCONNECT:

c

BR0280I BRCONNECT time stamp: 2007-08-01 13.57.16

BR0257I Your reply: 'c'

BR0259I Program execution will be continued...

BR0280I BRCONNECT time stamp: 2007-08-01 13.57.16

BR0829I Password changed successfully in database for user SAP<SIDPRD>

BR0830I Password changed successfully in table OPS$<SIDPRD>ADM.SAPUSER for user SAP<SIDPRD>

BR0830I Password inserted successfully into table OPS$<SIDQAS>ADM.SAPUSER for user SAP<SIDPRD>

BR0280I BRCONNECT time stamp: 2007-08-01 13.57.16

BR0802I BRCONNECT completed successfully

<SIDQAS>scm:ora<SIDQAS> 3%

*****************************************************************************

Regards

Anthony

[fidel_vales · Accepted solution]

Hi,

Have you replace the "placeholders"

<SIDQAS>

<SIDPRD>

with the real values?

Is it working now?

[Former Member · Accepted solution]

Hi Fidel Vales ,

Yes , I have replace the sid with its real values , but still while startting SAP application its states the same messages that database is not available ..

Regards

Anthony

[Former Member · Accepted solution]

>>4 ETW000 [dev trc ,00000] Now '/@<SIDQAS>' is connected (con_hdl 0, nls_hdl 0).

>>4 ETW000 1489 0.154697

>>4 ETW000 [dev trc ,00000] ALTER SESSION SET NLS_SORT = BINARY

>>

>>4 ETW000 134 0.154831

>>4 ETW000 [dev trc ,00000] SELECT USERID,PASSWD FROM SAPUSER WHERE USERID IN (:A0, :A1)

>>

>>4 ETW000 847 0.155678

>>4 ETW000 [dbsloci. ,00000] *** ERROR => ORA-1403 when accessing table SAPUSER

the ops$ user was already there (logon using / was successfull).

ORA-1403 indicates that SAPUSER was also there.

The simple thing missing is the entry for SAPUSER.

refer to

<b>brconnect -f chpass -o <dbuser> -p <newpassword></b>

to create the sapuser entries automatically.

peter

[Former Member · Accepted solution]

Hi Peter ,

I am not much aware of Oracle ,

Can you please guide me as to what will be the <dbuser>

is it ops$<SID>adm or ora<SID> .

Please help..

Anthony

[Former Member · Accepted solution]

Anthony,

first you have to answer Fidels question:

it looks very much like you did not replace the placesholders <SAPQAS> <SIDPRD> in the command line.

sqlplus /nolog @/oracle/<SIDQAS>/sapdata4/ORADBUSR.SQL SAP<SIDPRD> UNIX <SIDQAS> X

is wrong, assuming that your QAS System has the ORACLE_SID QAS and the schema owner of this database is SAPPRD the right syntax is:

sqlplus /nolog @/oracle/QAS/sapdata4/ORADBUSR.SQL SAPPRD UNIX QAS X

after that you have to run:

brconnect -u SYSTEM -f chpass -o SAPPRD -p <newpassword>

to fill sapuser with the logon information.

peter

[Former Member · Accepted solution]

Hi Peter , Fidels,

Thanks a lot , i was able to start the application .

What i did was , in the enviorment variable of the QAS . I have changed the variable "dbs_ora_schema to SAP<SIDPRD> (sid of the PRD).

Regards

Anthony