Schema owner si not changed when the database copied

[Former Member]

hi

for testing purpose we started the system copy . we have installed BW3.1 as per the installation guide and the sap system also started . then i have shutdown th sap and database and done a datbase copy from the online backup of my present prodcution server. as per the note 549828. as per the note have restore the datafiles and recreated the control file.

After this event i have tried to start the ssap it gave me the error. in the translog of R3trans -d

4 ETW000 R3trans version 6.09 (release 620 - 13.08.03 - 15:59:00).

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

4 ETW000

4 ETW000 date&time : 29.10.2007 - 03:13:48

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] Mon Oct 29 03:13:48 2007

243 0.000243

4 ETW000 [dev trc ,00000] db_con_init called

29 0.000272

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

39 0.000311

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

raslib.so' ...

4 ETW000

70 0.000381

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

oraslib.so), hdl 0

4 ETW000

26427 0.026808

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

loaded

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

59 0.091527

4 ETW000 [dev trc ,00000] Starting user session (con_hdl=0,svchp=600000000

0aac798,srvhp=6000000000aaec58,usrhp=6000000000ab86b0)

4 ETW000

39 0.091566

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

rc = 1017

4 ETW000

14958 0.106524

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

'

4 ETW000

26 0.106550

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

16 0.106566

4 ETW000 [dev trc ,00000] Connecting as SAPSEQ/<pwd>@SEQ on connection 0 .

..

4 ETW000

23 0.106589

4 ETW000 [dev trc ,00000] Assigning username to user session 6000000000ab8

6b0

4 ETW000

22 0.106611

4 ETW000 [dev trc ,00000] Assigning password to user session 6000000000ab8

6b0

4 ETW000

26 0.106637

i have checked with the schema owner then only came to know which is the old sid name. say my old sid is TEP and the new which i have configured is TEQ and i tried the database copy from TEP to TEQ. now the schema owner shows me as OPS$TEPADM and SAPTEP. but actually it should be TEQ. what to do now. whether i could change the schema owner of the database.

At present as per the note 534765 when a database copy happened we can only start the database only by the oldsid. so i have configured the dbs_ora_schema as TEP and started the sap. but there is any solution to change the schema owner of the new database.

regards

bala

[Former Member · Accepted solution]

Hello Bala,

no, there is no chance to change the schema owner name after a backup / restore system copy. Renaming a user is no functionality that is provided by Oracle

With Oracle 10g you could at least rename the PSAP<sid>... tablespaces, but the schema remains unchanged.

So you only have the following options:

- Don't get confused about the different schema owner SID.

- Use other copy methods like R3load.

- Use a SID independent schema name (e.g. SAPSR3).

Regards

Martin

[former_member204746 · Accepted solution]

this will be possible in Oracle 11i... not in 10g

[Former Member]

Hi Martin

Since it is SAP Basis 620 version we could not do this. or the latest version is not applicable. then the logic is totally will not be useful when we want to test in any circumstances.

whetether Nw2004s is it can be done ( for Knowledge purpose)

regards

bala

[Former Member]

Hello Bala,

you can find the detailed step by step list in the SAP homogeneous system guide available at the provided link.

At the same location you can find a link to SAP note 543715 that discusses BW system copies.

Regards

Martin

[Former Member]

hi martin

i need step by step with to understand consept of export / import

more over i want to do for SAP BW 3.1 old version i could not get the exact document

regards

bala

[Former Member]

Hello Bala,

the R3load method (based on export / import) is described in the SAP guide for homogeneous system copies that is available at

http://service.sap.com/systemcopy -> Media Library

Regards

Martin

[Former Member]

hi amrtin

thanks regarding your reply. i am convinced.

but if i want to retain the mirror of the same with different schema it can be done by export / import method. how to do it with steps. why itis taking more space for export and import emthod

regards

bala