cancel
Showing results for 
Search instead for 
Did you mean: 

RMAN Clone system

Former Member
0 Kudos

Good Day:

I make a copy of system A to the system B using a backup of RMAN, i use the next scrip for it:

Step 1:

Backup include control file and archive log

Step 2:

Drop old database QAS on the SAP instance QAS

Step 3:

I restore the control file from the backup files

Step 4:

I catalog a pieces of backup

Step 5:

I set all the new names for the data files from /oracle/PRD/sapdata1/... to /oracle/QAS/sapdata1/...

I restore my backup DB PRD and rest logs

Step 6:

All is OK!

DB is mounted and open

Step 7:

StartSAP

Ups!!!! SAP dont start.

The log of the R3Trans say:

4 ETW000 R3trans version 6.14 (release 700 - 16.10.08 - 16:26:00).

4 ETW000 unicode enabled version

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

4 ETW000

4 ETW000 date&time : 26.11.2009 - 11:13:52

4 ETW000 control file: <no ctrlfile>

4 ETW000 R3trans was called as follows: R3trans -x

4 ETW000 trace at level 2 opened for a given file pointer

4 ETW000 [dev trc ,00000] Thu Nov 26 11:13:52 2009

931 0.000931

4 ETW000 [dev trc ,00000] db_con_init called

155 0.001086

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

233 0.001319

4 ETW000 [dev trc ,00000] Loading DB library '/usr/sap/QAS/SYS/exe/run/dbo

raslib.so' ...

4 ETW000

286 0.001605

4 ETW000 [dev trc ,00000] load shared library (/usr/sap/QAS/SYS/exe/run/db

oraslib.so), hdl 0

4 ETW000

76790 0.078395

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

4 ETW000 429 0.078824

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

4 ETW000 275 0.079099

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

4 ETW000 1221 0.080320

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

4 ETW000 266 0.080586

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

4 ETW000 423 0.081009

4 ETW000 [dev trc ,00000] New connection 0 created 234 0.081243

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 300 0.081543

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

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

4 ETW000 246 0.081959

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 286 0.082245

4 ETW000 [dev trc ,00000] Oracle Client Version: '10.2.0.2.0' 1458 0.083703

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

4 ETW000 [dev trc ,00000] Client NLS settings: AMERICAN_AMERICA.UTF8 42124 0.126044

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

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

4 ETW000 299 0.126587

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

4 ETW000 303 0.126890

4 ETW000 [dev trc ,00000] 0 UTF8 1 0x10194f4c0 0x101956f10 0x101967648

4 ETW000 278 0.127168

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

4 ETW000 [dev trc ,00000] Allocating server context handle 204 0.127682

4 ETW000 [dev trc ,00000] Attaching to DB Server PRD (con_hdl=0,svchp=0x101967578,srvhp=0x101969868)

4 ETW000 481 0.128163

4 ETW000 [dboci.c ,00000] *** ERROR => OCI-call 'OCIServerAttach' failed with rc=12505

4 ETW000 18429 0.146592

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

4 ETW000 263 0.146855

4 ETW000 [dev trc ,00000] set_ocica() -> OCI or SQL return code 12505 166 0.147021

4 ETW000 [dev trc ,00000] Try to connect with default password 563 0.147584

4 ETW000 [dev trc ,00000] Connecting as SAPSR3/<pwd>@PRD on connection 0 (nls_hdl 0) ... (dbsl 700 030508)

4 ETW000 294 0.147878

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

4 ETW000 272 0.148150

4 ETW000 [dev trc ,00000] 0 UTF8 1 0x10194f4c0 0x101956f10 0x101967648

4 ETW000 273 0.148423

4 ETW000 [dev trc ,00000] server_detach(con_hdl=0,stale=0,svrhp=0x101969868)

4 ETW000 317 0.148740

4 ETW000 [dev trc ,00000] Detaching from DB Server (con_hdl=0,svchp=0x101967578,srvhp=0x101969868)

4 ETW000 262 0.149002

4 ETW000 [dev trc ,00000] Deallocating server context handle 0x101969868 230 0.149232

4 ETW000 [dev trc ,00000] Allocating server context handle 264 0.149496

4 ETW000 [dev trc ,00000] Attaching to DB Server PRD (con_hdl=0,svchp=0x101967578,srvhp=0x101969868)

4 ETW000 289 0.149785

4 ETW000 [dboci.c ,00000] *** ERROR => OCI-call 'OCIServerAttach' failed with rc=12505

4 ETW000 12261 0.162046

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

4 ETW000 258 0.162304

4 ETW000 [dev trc ,00000] set_ocica() -> OCI or SQL return code 12505 163 0.162467

4 ETW000 [dblink ,00431] ***LOG BY2=>sql error 12505 performing CON [dblink#5 @ 431]

4 ETW000 790 0.163257

4 ETW000 [dblink ,00431] ***LOG BY0=>ORA-12505: TNS:listener does not currently know of SID given in connect descriptor [dblink#5 @ 431

]

4 ETW000 283 0.163540

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

HOW I CAN SOLVE IT!???

Accepted Solutions (1)

Accepted Solutions (1)

lbreddemann
Active Contributor
0 Kudos

> I make a copy of system A to the system B using a backup of RMAN, i use the next scrip for it:

Any reason why you don't just use the BRTOOLS instead?

> Step 1:

> Backup include control file and archive log

> Step 2:

> Drop old database QAS on the SAP instance QAS

> Step 3:

> I restore the control file from the backup files

> Step 4:

> I catalog a pieces of backup

> Step 5:

> I set all the new names for the data files from /oracle/PRD/sapdata1/... to /oracle/QAS/sapdata1/...

> I restore my backup DB PRD and rest logs

> Step 6:

> All is OK!

> DB is mounted and open

> Step 7:

> StartSAP

> Ups!!!! SAP dont start.

> The log of the R3Trans say:

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

Have you read this? It tries to connect to PRD - not to QAS!

You've to check your environment variables!

> 4 ETW000 [dblink ,00431] ***LOG BY0=>ORA-12505: TNS:listener does not currently know of SID given in connect descriptor [dblink#5 @ 431

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

This fits - your listener does not know a DB/Service named PRD.

It should know QAS.

> HOW I CAN SOLVE IT!???

By setting the environment variables correctly. Easy peasy

Former Member
0 Kudos

thaks, but!

Any reason why you don't just use the BRTOOLS instead?

Yep! the owner does not support systems with brtools use RMAN and all I give is a backup in RMAN.

Have you read this? It tries to connect to PRD - not to QAS!

You've to check your environment variables!

The instance of SAP is QAS, but the DB is left with the product name PRD

In step 5 I just redirect the data, not to replace the structure of QAS, but the DB is called PRD

My file system, origin are:

/ oracle/PRD/sapdata1 ...

/ oracle/PRD/sapdata2 ...

/ oracle / PRD / sapdata ....

The stations are:

/ oracle/QAS/sapdata1

/ oracle/QAS/sapdata2

/ oracle/QAS/sapdata3

/ oracle / QAS / sapdata ...

lbreddemann
Active Contributor
0 Kudos

> Have you read this? It tries to connect to PRD - not to QAS!

> You've to check your environment variables!

>

> The instance of SAP is QAS, but the DB is left with the product name PRD

But obviously the instance isn't maintained as such in the listener.

What's the DB_NAME of the database?

How does your listener.ora file look like?

If you want to reach the database via "PRD" then you've to make sure that "PRD" is a known SID to the listener.

Former Member
0 Kudos

I have a new Log from my R3trans.

tr-icqa:qasadm> R3trans -x

This is R3trans version 6.14 (release 700 - 16.10.08 - 16:26:00).

unicode enabled version

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

R3trans finished (0012).

tr-icqa:qasadm> clear

tr-icqa:qasadm> more trans.log

4 ETW000 R3trans version 6.14 (release 700 - 16.10.08 - 16:26:00).

4 ETW000 unicode enabled version

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

4 ETW000

4 ETW000 date&time : 27.11.2009 - 13:06:57

4 ETW000 control file: <no ctrlfile>

4 ETW000 R3trans was called as follows: R3trans -x

4 ETW000 trace at level 2 opened for a given file pointer

4 ETW000 [dev trc ,00000] Fri Nov 27 13:06:57 2009 908 0.000908

4 ETW000 [dev trc ,00000] db_con_init called 155 0.001063

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

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

4 ETW000 286 0.001576

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

4 ETW000 76836 0.078412

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

4 ETW000 9028 0.087440

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

4 ETW000 274 0.087714

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

4 ETW000 1226 0.088940

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

4 ETW000 270 0.089210

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

4 ETW000 419 0.089629

4 ETW000 [dev trc ,00000] New connection 0 created 241 0.089870

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 300 0.090170

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

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

4 ETW000 245 0.090584

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 285 0.090869

4 ETW000 [dev trc ,00000] Oracle Client Version: '10.2.0.2.0' 1441 0.092310

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

4 ETW000 [dev trc ,00000] Client NLS settings: AMERICAN_AMERICA.UTF8 40567 0.133095

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

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

4 ETW000 300 0.133642

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

4 ETW000 303 0.133945

4 ETW000 [dev trc ,00000] 0 UTF8 1 0x10194f4c0 0x101956f10 0x101967648

4 ETW000 278 0.134223

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

4 ETW000 [dev trc ,00000] Allocating server context handle 204 0.134736

4 ETW000 [dev trc ,00000] Attaching to DB Server PRD (con_hdl=0,svchp=0x101967578,srvhp=0x101969868)

4 ETW000 479 0.135215

4 ETW000 [dev trc ,00000] Fri Nov 27 13:06:58 2009 116864 0.252079

4 ETW000 [dev trc ,00000] Assigning server context 0x101969868 to service context 0x101967578

4 ETW000 266 0.252345

4 ETW000 [dev trc ,00000] Allocating user session handle 216 0.252561

4 ETW000 [dev trc ,00000] Starting user session (con_hdl=0,svchp=0x101967578,srvhp=0x101969868,usrhp=0x101957728)

4 ETW000 290 0.252851

4 ETW000 [dev trc ,00000] Assigning user session 0x101957728 to service context 0x101967578

4 ETW000 34170 0.287021

4 ETW000 [dev trc ,00000] -->oci_prepare_stmt(con_hdl=0, len=55, stmth_p=0x101972278)

4 ETW000 433 0.287454

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

4 ETW000 271 0.287725

4 ETW000 [dev trc ,00000] -->oci_prepare_stmt(con_hdl=0, len=55, stmth_p=0x1019732d0)

4 ETW000 757 0.288482

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

4 ETW000 269 0.288751

4 ETW000 [dev trc ,00000] -->oci_prepare_stmt(con_hdl=0, len=0, stmth_p=0x1019732d0)

4 ETW000 3364 0.292115

4 ETW000 [dev trc ,00000] SELECT SID FROM V$MYSTAT WHERE ROWNUM<2

4 ETW000 270 0.292385

4 ETW000 [dev trc ,00000] Connected to session 150. 1948 0.294333

4 ETW000 [dev trc ,00000] Now '/@PRD' is connected: con_hdl=0, nls_hdl=0, session_id=150.

4 ETW000 262 0.294595

4 ETW000 [dev trc ,00000] -->oci_prepare_stmt(con_hdl=0, len=0, stmth_p=0x1019732d0)

4 ETW000 280 0.294875

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

4 ETW000 284 0.295159

4 ETW000 [dev trc ,00000] -->oci_prepare_stmt(con_hdl=0, len=0, stmth_p=0x1019732d0)

4 ETW000 1767 0.296926

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

4 ETW000 271 0.297197

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

4 ETW000 1783 0.298980

4 ETW000 [dev trc ,00000] set_ocica() -> OCI or SQL return code 1403 169 0.299149

4 ETW000 [dev trc ,00000] Disconnecting from connection 0 ... 651 0.299800

4 ETW000 [dev trc ,00000] Rolling back transaction ... 406 0.300206

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

4 ETW000 865 0.301071

4 ETW000 [dev trc ,00000] Now I'm disconnected from ORACLE 2231 0.303302

4 ETW000 [dev trc ,00000] Try to connect with default password 167 0.303469

4 ETW000 [dev trc ,00000] Connecting as SAPSR3/<pwd>@PRD on connection 0 (nls_hdl 0) ... (dbsl 700 030508)

4 ETW000 261 0.303730

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

4 ETW000 271 0.304001

4 ETW000 [dev trc ,00000] 0 UTF8 1 0x10194f4c0 0x101956f10 0x101967648

4 ETW000 307 0.304308

4 ETW000 [dev trc ,00000] Assigning username to user session 0x101957728 167 0.304475

4 ETW000 [dev trc ,00000] Assigning password to user session 0x101957728 183 0.304658

4 ETW000 [dev trc ,00000] Starting user session (con_hdl=0,svchp=0x101967578,srvhp=0x101969868,usrhp=0x101957728)

4 ETW000 277 0.304935

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

4 ETW000 9478 0.314413

4 ETW000 [dev trc ,00000] server_detach(con_hdl=0,stale=1,svrhp=0x101969868)

4 ETW000 248 0.314661

4 ETW000 [dev trc ,00000] Detaching from DB Server (con_hdl=0,svchp=0x101967578,srvhp=0x101969868)

4 ETW000 270 0.314931

4 ETW000 [dev trc ,00000] Deallocating server context handle 0x101969868 1141 0.316072

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

4 ETW000 272 0.316344

4 ETW000 [dev trc ,00000] set_ocica() -> OCI or SQL return code 28000 164 0.316508

4 ETW000 [dblink ,00431] ***LOG BY2=>sql error 28000 performing CON [dblink#5 @ 431]

4 ETW000 810 0.317318

4 ETW000 [dblink ,00431] ***LOG BY0=>ORA-28000: the account is locked [dblink#5 @ 431]

4 ETW000 253 0.317571

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

My dbname is PRD.

My SAP instance is QAS

Any help???

Former Member
0 Kudos

I have a new Log from my R3trans.

tr-icqa:qasadm> R3trans -x

This is R3trans version 6.14 (release 700 - 16.10.08 - 16:26:00).

unicode enabled version

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

R3trans finished (0012).

tr-icqa:qasadm> clear

tr-icqa:qasadm> more trans.log

4 ETW000 R3trans version 6.14 (release 700 - 16.10.08 - 16:26:00).

4 ETW000 unicode enabled version

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

4 ETW000

4 ETW000 date&time : 27.11.2009 - 13:06:57

4 ETW000 control file: <no ctrlfile>

4 ETW000 R3trans was called as follows: R3trans -x

4 ETW000 trace at level 2 opened for a given file pointer

4 ETW000 [dev trc ,00000] Fri Nov 27 13:06:57 2009 908 0.000908

4 ETW000 [dev trc ,00000] db_con_init called 155 0.001063

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

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

4 ETW000 286 0.001576

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

4 ETW000 76836 0.078412

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

4 ETW000 9028 0.087440

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

4 ETW000 274 0.087714

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

4 ETW000 1226 0.088940

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

4 ETW000 270 0.089210

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

4 ETW000 419 0.089629

4 ETW000 [dev trc ,00000] New connection 0 created 241 0.089870

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 300 0.090170

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

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

4 ETW000 245 0.090584

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 285 0.090869

4 ETW000 [dev trc ,00000] Oracle Client Version: '10.2.0.2.0' 1441 0.092310

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

4 ETW000 [dev trc ,00000] Client NLS settings: AMERICAN_AMERICA.UTF8 40567 0.133095

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

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

4 ETW000 300 0.133642

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

4 ETW000 303 0.133945

4 ETW000 [dev trc ,00000] 0 UTF8 1 0x10194f4c0 0x101956f10 0x101967648

4 ETW000 278 0.134223

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

4 ETW000 [dev trc ,00000] Allocating server context handle 204 0.134736

4 ETW000 [dev trc ,00000] Attaching to DB Server PRD (con_hdl=0,svchp=0x101967578,srvhp=0x101969868)

4 ETW000 479 0.135215

4 ETW000 [dev trc ,00000] Fri Nov 27 13:06:58 2009 116864 0.252079

4 ETW000 [dev trc ,00000] Assigning server context 0x101969868 to service context 0x101967578

4 ETW000 266 0.252345

4 ETW000 [dev trc ,00000] Allocating user session handle 216 0.252561

4 ETW000 [dev trc ,00000] Starting user session (con_hdl=0,svchp=0x101967578,srvhp=0x101969868,usrhp=0x101957728)

4 ETW000 290 0.252851

4 ETW000 [dev trc ,00000] Assigning user session 0x101957728 to service context 0x101967578

4 ETW000 34170 0.287021

4 ETW000 [dev trc ,00000] -->oci_prepare_stmt(con_hdl=0, len=55, stmth_p=0x101972278)

4 ETW000 433 0.287454

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

4 ETW000 271 0.287725

4 ETW000 [dev trc ,00000] -->oci_prepare_stmt(con_hdl=0, len=55, stmth_p=0x1019732d0)

4 ETW000 757 0.288482

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

4 ETW000 269 0.288751

4 ETW000 [dev trc ,00000] -->oci_prepare_stmt(con_hdl=0, len=0, stmth_p=0x1019732d0)

4 ETW000 3364 0.292115

4 ETW000 [dev trc ,00000] SELECT SID FROM V$MYSTAT WHERE ROWNUM<2

4 ETW000 270 0.292385

4 ETW000 [dev trc ,00000] Connected to session 150. 1948 0.294333

4 ETW000 [dev trc ,00000] Now '/@PRD' is connected: con_hdl=0, nls_hdl=0, session_id=150.

4 ETW000 262 0.294595

4 ETW000 [dev trc ,00000] -->oci_prepare_stmt(con_hdl=0, len=0, stmth_p=0x1019732d0)

4 ETW000 280 0.294875

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

4 ETW000 284 0.295159

4 ETW000 [dev trc ,00000] -->oci_prepare_stmt(con_hdl=0, len=0, stmth_p=0x1019732d0)

4 ETW000 1767 0.296926

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

4 ETW000 271 0.297197

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

4 ETW000 1783 0.298980

4 ETW000 [dev trc ,00000] set_ocica() -> OCI or SQL return code 1403 169 0.299149

4 ETW000 [dev trc ,00000] Disconnecting from connection 0 ... 651 0.299800

4 ETW000 [dev trc ,00000] Rolling back transaction ... 406 0.300206

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

4 ETW000 865 0.301071

4 ETW000 [dev trc ,00000] Now I'm disconnected from ORACLE 2231 0.303302

4 ETW000 [dev trc ,00000] Try to connect with default password 167 0.303469

4 ETW000 [dev trc ,00000] Connecting as SAPSR3/<pwd>@PRD on connection 0 (nls_hdl 0) ... (dbsl 700 030508)

4 ETW000 261 0.303730

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

4 ETW000 271 0.304001

4 ETW000 [dev trc ,00000] 0 UTF8 1 0x10194f4c0 0x101956f10 0x101967648

4 ETW000 307 0.304308

4 ETW000 [dev trc ,00000] Assigning username to user session 0x101957728 167 0.304475

4 ETW000 [dev trc ,00000] Assigning password to user session 0x101957728 183 0.304658

4 ETW000 [dev trc ,00000] Starting user session (con_hdl=0,svchp=0x101967578,srvhp=0x101969868,usrhp=0x101957728)

4 ETW000 277 0.304935

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

4 ETW000 9478 0.314413

4 ETW000 [dev trc ,00000] server_detach(con_hdl=0,stale=1,svrhp=0x101969868)

4 ETW000 248 0.314661

4 ETW000 [dev trc ,00000] Detaching from DB Server (con_hdl=0,svchp=0x101967578,srvhp=0x101969868)

4 ETW000 270 0.314931

4 ETW000 [dev trc ,00000] Deallocating server context handle 0x101969868 1141 0.316072

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

4 ETW000 272 0.316344

4 ETW000 [dev trc ,00000] set_ocica() -> OCI or SQL return code 28000 164 0.316508

4 ETW000 [dblink ,00431] ***LOG BY2=>sql error 28000 performing CON [dblink#5 @ 431]

4 ETW000 810 0.317318

4 ETW000 [dblink ,00431] ***LOG BY0=>ORA-28000: the account is locked [dblink#5 @ 431]

4 ETW000 253 0.317571

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

My dbname is PRD.

My SAP instance is QAS

Any help???

lbreddemann
Active Contributor
0 Kudos

Antonio,

you've got the log file and you've got the error messages.

There's a fancy search tool available in the upper right corner of the SDN site... how about using it?

The problems you currently face are really trivial and the solution is described in several sap notes.

So please - use the search tool yourself.

Or, if you think others should do that for you - open a support message.

regards,

Lars

Former Member
0 Kudos

Thank you!

My copy of system has been completed successfully.

Best regards!

Answers (1)

Answers (1)

Former Member
0 Kudos

Thank you!

My copy of system has been completed successfully.

Best regards!

Former Member
0 Kudos

Iu2019m doing system copy using RMAN online backup. Can u please send the following steps in detailed?

Step 1:

> Backup include control file and archive log

> Step 2:

> Drop old database QAS on the SAP instance QAS

> Step 3:

> I restore the control file from the backup files

> Step 4:

> I catalog a pieces of backup

> Step 5:

> I set all the new names for the data files from /oracle/PRD/sapdata1/... to /oracle/QAS/sapdata1/...

> I restore my backup DB PRD and rest logs

> Step 6:

> All is OK!

> DB is mounted and open

> Step 7:

> StartSAP