R3trans -d unable successful after the systemcopy (rman/backup restore)

[Former Member]

Hello All,

I make a copy of system A to the system B using a backup of RMAN, DB is mounted and open.

But when am trying the StartSAP  Ups!!!! SAP dont start.

Please suggest me to resolve the issue

The log of the R3Trans say:

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

R3trans finished (0012).

R3trans -d

This is R3trans version 6.24 (release 720 - 16.05.14 - 20:14:06).

unicode enabled version

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

R3trans finished (0012).

bash-3.2$

trans.log

4 ETW000                                                                                                  36  0.540846

4 ETW000  [     dev trc,00000]  charset='', chset='UTF8', UNI_ASC=FALSE/FALSE                             27  0.540873

4 ETW000  [     dev trc,00000]  Logon as OPS$-user to get SAPPRD's password                               18  0.540891

4 ETW000  [     dev trc,00000]  Connecting as /@PRD on connection 0 (nls_hdl 0) ... (dbsl 720 280110)

4 ETW000                                                                                                  25  0.540916

4 ETW000  [     dev trc,00000]  Nls CharacterSet                 NationalCharSet              Env        Err        ErrBt

4 ETW000                                                                                                  27  0.540943

4 ETW000  [     dev trc,00000]    0 UTF8                                                      11110fbc0 11113f578 111140838

4 ETW000                                                                                                  27  0.540970

4 ETW000  [     dev trc,00000]     OCIHandleAlloc(OCI_HTYPE_SVCCTX, con=0, svchp=111142890)               40  0.541010

4 ETW000  [     dev trc,00000]  Allocating server context handle                                          16  0.541026

4 ETW000  [     dev trc,00000]  Attaching to database server PRD (con=0, svchp=111142890, srvhp=111143de0)

4 ETW000                                                                                                  67  0.541093

4 ETW000  [     dev trc,00000]  Assigning server context 111143de0 to service context 111142890       150018  0.691111

4 ETW000  [     dev trc,00000]     OCIHandleAlloc(OCI_HTYPE_SESSION, con=0, usrhp=1111ab020)            2020  0.693131

4 ETW000  [     dev trc,00000]  Starting user session: OCISessionBegin(con=0, usr='/',svc=111142890, srv=111143de0, usr=1111ab020)

4 ETW000                                                                                                  38  0.693169

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

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

4 ETW000  [     dev trc,00000]     ORA-01034: ORACLE not available                                        22  0.725658

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

4 ETW000                        IBM AIX RISC System/6000 Error: 2: No such f

4 ETW000  [     dev trc,00000]     ile or directory

4 ETW000                                                                                                  35  0.725693

4 ETW000  [     dev trc,00000]  server_detach(con=0,stale=1,srvhp=111143de0)                              17  0.725710

4 ETW000  [     dev trc,00000]  Detaching from DB Server (con=0,svchp=111142890,srvhp=111143de0)          18  0.725728

4 ETW000  [     dev trc,00000]  Deallocating server context handle 111143de0 from con=0                 5889  0.731617

4 ETW000  [dbsloci.c   ,00000]  *** ERROR => CONNECT failed with sql error '1034'                         58  0.731675

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

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

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

4 ETW000  [     dev trc,00000]     ORA-01034: ORACLE not available                                        21  0.731794

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

4 ETW000                        IBM AIX RISC System/6000 Error: 2: No such f

4 ETW000  [     dev trc,00000]     ile or directory

4 ETW000                                                                                                  35  0.731829

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

4 ETW000  [     dev trc,00000]     DbSlConnect(con=-1) -> orc=0, 99=DBSL_ERR_DB                           18  0.731865

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

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

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

4 ETW000                        IBM AIX RISC System/6000 Error: 2: No such file or directory

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

trans.log: END

Thanks,

Santu

[JamesZ]

Hi Santu,

Please check the listener.ora file used, if the ORACLE_HOME entry is correct. I met the same problem before and the problem is due to wrong ORACLE_HOME set in listener.ora file.

Best regards,

James

[Former Member]

hi Santosh,

Agree with James, Do check your ORALE_HOME path in your .dbenv.sh/.csh files and in tnsnames.ora and if you have 11.2.0.4 above Oracle binaries do verify your SERVICE Name too.

This will eliminate the possible issue due to worng oracle_home.

also you can try both below oracle_home paths with and without softlink.

example:-

setenv ORACLE_HOME /oracle/PRD/112_64

or

setenv ORACLE_HOME /oracle/PRD/11204

This you can try setting in temporary. And if R3trans works then you can hardcode same in enviroment files.

Regards,

Ram

[Former Member]

Hi Santosh,

Check if your oracle listener parameter file is adapted according to your new system and if the service for listener is running and connected to the database as well.

Regards,

Kaleem

[former_member283936]

Hi Santosh,

some days ago I run into the same problem. Checking the passwords auf SAP<SID> was fine, eintries in OPS$.<SID>adm was set correctly also.

We solved the issue by creating a new password entry with brconnect.

SAP changed the way how the OPS$ password is placed into the table sapuser in past. From a certain version on the password have to saved in a encrypted version in table sapuser. R3trans isn't be able to read the encrypted password if it's version is to old.

Kind regards,

Sascha

Please

[Former Member]

Hi Sascha,

When am trying to change the password of OPS$<SID>ADM its asking to change SAPSR3 password too when am trying to set both its showing the error

BR0280I BRCONNECT time stamp: 2015-10-13 21.38.50

BR0301E SQL error -1031 at location password_change-8, SQL statement:

'/* BRCONNECT */ ALTER USER "SAPSR3" IDENTIFIED BY "********"'

ORA-01031: insufficient privileges

BR0832E Changing password for user SAPSR3 failed

BR0280I BRCONNECT time stamp: 2015-10-13 21.38.50

BR0804I BRCONNECT terminated with errors

###############################################################################

BR0292I Execution of BRCONNECT finished with return code 5

But i changed the password with command passw <username> in SQL

I studied the note 400241.  Problem with OPS$

As per the note

i have few doubts.As per the note:

a) Logon using the OPS$ user ("connect /@<sid>") to determine the

sapr3 password that is stored in the database table SAPUSER.

Now i have no idea,that how to check the password,as i logged in using "connect /",it just got connected.

But how will i know that what password has been set.

As i have to refresh quality from production,i will have to make changes.

If possible,kindly guide me with step by step procedure.

[former_member283936]

Hi Santosh,

if you are on Linux <SID>adm should be used to execute brtools.

The commandline how to change the password of SAPSR3 looks like this:

     brconnect -u system/<password of system> -f chpass -u SAPSR3 -p <new of SAPSR3 password>

<password of system> is the password of the SYSTEM database user. You can use another user with DBA privileges.This commandline changes the SAPSR3 users password and updates the password entry in table sapuser.

The select statement

     select * from OPS$<sidadm>.sapuser;

returns the value of the user SAP connects to the database and the password of this user. If the password is stored encrypted, r3trans should be one of the latest versions. Older versions aren't able to decrypt this hash value, newer versions of r3trans expect a encrypted password and don't use a non encrypted password. So the best way how to chaneg the password of SAPSR3 is the use of brtools.

Hope I hit the mark.

Kind regards,

Sascha

[former_member182657]

Hi Santosh,

Suggest you to follow SAP Note  491174 - Composite SAP note for ORA-01034

Hope this will help you.

Regards,

[Reagan]

Assuming that you refreshed the QA system with the PRD copy.

Did you recreate the OPS$ users after the DB restore and recovery?

[Former Member]

No I did not create anything,

As you know the SID are same for both,, password of QA and PRD are same..

Please let me know the steps I need to follow here .

[Former Member]

Hi

In our current scenario,

We have restored the oracle DB  backup of source to target system through RMAN.

Here System SID are same for source and target but host name is different.

We have started Oracle DB , its running  fine.  Listener is also running.

Only problem is with starting of SAP , giving R3 trans -d  12.

Also checked the password of SAPPRD . As you observed above logs of R3trans -d .12.

startup;

ORA-32004: obsolete or deprecated parameter(s) specified for RDBMS instance

ORACLE instance started.

Total System Global Area 4743598080 bytes

Fixed Size                  2229384 bytes

Variable Size               2399144824 bytes

Database Buffers         2332033024 bytes

Redo Buffers               10190848 bytes

Database mounted.

Database opened.

Regards,

Santu

[fidel_vales]

which OS user have you used to check that the DB is up?

ora<sid> or <sid>adm?

how have you installed the oracle software?

one possible reason could be wrong authorizations of the binary, wrong environment variables ...

[Former Member]

Please  check $oracle_home and dbenv*** files.

[Former Member]

Hi Santu;

This error is because the database is not active.

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

4 ETW000  [     dev trc,00000]     ORA-01034: ORACLE not available                                        21  0.731794

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

Regards

Henry Orellana