Dispatcher getting stopped after Homogenous Copy

[former_member603052]

Hi ,

After performing homogenous copy(windows2003,SAP ECC5.O, ORACLE 9i) from PRD to QAS

Executed oradbusr.sql script,created OPS$ user,changed env variable dbs_ora_schema

When tried with R3trans got Return Code <0000> but ....the SAP instance is not starting.

Here is the log og Dev_W0

-

---

trc file: "dev_w0", trc level: 1, release: "640"

-

---

*

• ACTIVE TRACE LEVEL 1

• ACTIVE TRACE COMPONENTS all, M

*

B

B Wed Feb 04 18:06:27 2009

B create_con (con_name=R/3)

B Loading DB library 'D:\usr\sap\BQ1\SYS\exe\run\dboraslib.dll' ...

B Library 'D:\usr\sap\BQ1\SYS\exe\run\dboraslib.dll' loaded

B Version of 'D:\usr\sap\BQ1\SYS\exe\run\dboraslib.dll' is "640.00", patchlevel (0.39)

B New connection 0 created

M systemid 560 (PC with Windows NT)

M relno 6400

M patchlevel 0

M patchno 43

M intno 20020600

M make: multithreaded, ASCII

M pid 3528

M

M ***LOG Q0Q=> tskh_init, WPStart (Workproc 0 3528) [dpxxdisp.c 1160]

I

I Wed Feb 04 18:06:28 2009

I MtxInit: -2 0 0

M DpSysAdmExtCreate: ABAP is active

M DpSysAdmExtCreate: JAVA is not active

M DpShMCreate: sizeof(wp_adm) 9112 (828)

M DpShMCreate: sizeof(tm_adm) 2219848 (11044)

M DpShMCreate: sizeof(wp_ca_adm) 18000 (60)

M DpShMCreate: sizeof(appc_ca_adm) 6000 (60)

M DpShMCreate: sizeof(comm_adm) 192000 (384)

M DpShMCreate: sizeof(vmc_adm) 0 (320)

M DpShMCreate: sizeof(wall_adm) (22440/34344/56/100)

M DpShMCreate: SHM_DP_ADM_KEY (addr: 052B0040, size: 2507904)

M DpShMCreate: allocated sys_adm at 052B0040

M DpShMCreate: allocated wp_adm at 052B17A8

M DpShMCreate: allocated tm_adm_list at 052B3B40

M DpShMCreate: allocated tm_adm at 052B3B68

M DpShMCreate: allocated wp_ca_adm at 054D1AB0

M DpShMCreate: allocated appc_ca_adm at 054D6100

M DpShMCreate: allocated comm_adm_list at 054D7870

M DpShMCreate: allocated comm_adm at 054D7888

M DpShMCreate: allocated vmc_adm_list at 05506688

M DpShMCreate: system runs without vmc_adm

M DpShMCreate: allocated ca_info at 055066B0

M DpShMCreate: allocated wall_adm at 055066B8

X EmInit: MmSetImplementation( 2 ).

X <ES> client 0 initializing ....

X Using implementation flat

M <EsNT> Memory Reset disabled as NT default

X ES initialized.

M

M Wed Feb 04 18:06:29 2009

M calling db_connect ...

C Got ORACLE_HOME=D:\oracle\BQ1\920_64 from environment

C Client NLS settings: AMERICAN_AMERICA.WE8DEC

C Logon as OPS$-user to get SAPBP1's password

C Connecting as /@BQ1 on connection 0 ...

C Attaching to DB Server BQ1 (con_hdl=0,svchp=03913094,svrhp=03913CE4)

C Starting user session (con_hdl=0,svchp=03913094,srvhp=03913CE4,usrhp=0391C4F8)

C *** ERROR => OCI-call 'OCISessionBegin' failed: rc = 1017

[dboci.c 3720]

C *** ERROR => CONNECT failed with sql error '1017'

[dbsloci.c 9750]

C Try to connect with default password

C Connecting as SAPBP1/<pwd>@BQ1 on connection 0 ...

C Starting user session (con_hdl=0,svchp=03913094,srvhp=03913CE4,usrhp=0391C4F8)

C *** ERROR => OCI-call 'OCISessionBegin' failed: rc = 1017

[dboci.c 3720]

C *** ERROR => CONNECT failed with sql error '1017'

[dbsloci.c 9750]

B ***LOG BY2=> sql error 1017 performing CON [dbsh#2 @ 1200] [dbsh 1200 ]

B ***LOG BY0=> ORA-01017: invalid username/password; logon denied [dbsh#2 @ 1200] [dbsh 1200 ]

B ***LOG BY2=> sql error 1017 performing CON [dblink#1 @ 419] [dblink 0419 ]

B ***LOG BY0=> ORA-01017: invalid username/password; logon denied [dblink#1 @ 419] [dblink 0419 ]

M ***LOG R19=> tskh_init, db_connect ( DB-Connect 000256) [thxxhead.c 1269]

M in_ThErrHandle: 1

M *** ERROR => tskh_init: db_connect (step 1, th_errno 13, action 3, level 1) [thxxhead.c 9413]

M

What should i need to do?

Regards,

Kalyan

[former_member603052]

Thank u very much ...Solved the issue..Problem is with SAPService<Sid> User.

[fidel_vales]

Hi,

The error is "clear":

> C *** ERROR => CONNECT failed with sql error '1017'

and it happens twice for two different reasons (but related):

> C Connecting as /@BQ1 on connection 0 ...

OPS$ user is not properly created. You mention that you have done it. If so, you have not done it properly

> C Try to connect with default password

> C Connecting as SAPBP1/<pwd>@BQ1 on connection 0 ...

The user SAPBP1 does not have the default password.

quick solution is to change the password to the default one. But then you have a security risk.

Good solution is to create properly the OPS$ user.

For your comment I think that you are falling in the same mistake as lot of people in Windows.

In Windows you have two different users.

one is <sid>adm. You use this one to administer the installation

the other one is SAPService<sid>, this one is not "interactive" and it is the one that starts and handles SAP.

You have created an OPS$ user for <sid>adm (you mention that R3trans conects to the DB) but the one for SAPService<sid> is not created or not properly done.

Recommendation:

Read carefully the [SAP Note 400241 - Problems with ops$ or sapr3 connect to Oracle|http://service.sap.com/sap/support/notes/400241]

The solution to your problem is there, but you have to read it carefully, if you only have a glance, probably you will miss something

[former_member603052]

Hi,

Thanks for ur reply....I once again check and will let u know the progress.

Regards,

Kalyan