Domain change -- OPS$ user change

[Former Member]

Hi Guys,

We have migrated our domain to new domain and I have moved all the sidadm and sapservicesid users to new domain and assigned SAP services to the new users.

Then unable to restart the SAP. As its failing due to OPS$ logon failure I beleive

I have attached the work process error file for the reference. Oracle services using local system account.

I have created OPS$ user in the database for the new domain but its still giving me the same error. Just wondering whether I need to add any authorisation at DB level to OPS$ user?

Please help

Thanks

Santosh

-

---

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

-

---

*

• ACTIVE TRACE LEVEL 1

• ACTIVE TRACE COMPONENTS all, M

*

B

B Fri Jun 27 15:54:17 2008

B create_con (con_name=R/3)

B Loading DB library 'C:\usr\sap\ABD\SYS\exe\run\dboraslib.dll' ...

B Library 'C:\usr\sap\ABD\SYS\exe\run\dboraslib.dll' loaded

B Version of 'C:\usr\sap\ABD\SYS\exe\run\dboraslib.dll' is "640.00", patchlevel (0.55)

B New connection 0 created

M sysno 00

M sid ABD

M systemid 560 (PC with Windows NT)

M relno 6400

M patchlevel 0

M patchno 71

M intno 20020600

M make: multithreaded, ASCII

M pid 5816

M

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

I MtxInit: -2 0 0

M DpSysAdmExtCreate: ABAP is active

M DpShMCreate: sizeof(wp_adm) 11592 (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) 768000 (384)

M DpShMCreate: sizeof(vmc_adm) 0 (320)

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

M DpShMCreate: SHM_DP_ADM_KEY (addr: 056A0040, size: 3086384)

M DpShMCreate: allocated sys_adm at 056A0040

M DpShMCreate: allocated wp_adm at 056A17A8

M DpShMCreate: allocated tm_adm_list at 056A44F0

M DpShMCreate: allocated tm_adm at 056A4518

M DpShMCreate: allocated wp_ca_adm at 058C2460

M DpShMCreate: allocated appc_ca_adm at 058C6AB0

M DpShMCreate: allocated comm_adm_list at 058C8220

M DpShMCreate: allocated comm_adm at 058C8238

M DpShMCreate: allocated vmc_adm_list at 05983A38

M DpShMCreate: system runs without vmc_adm

M DpShMCreate: allocated ca_info at 05983A60

M DpShMCreate: allocated wall_adm at 05983A68

X EmInit: MmSetImplementation( 2 ).

X <ES> client 0 initializing ....

X

X Fri Jun 27 15:54:18 2008

X Using implementation flat

M <EsNT> Memory Reset disabled as NT default

X ES initialized.

M calling db_connect ...

C dbs/ora/array_buf_size = 650000

C Got ORACLE_HOME=c:\oracle\ABD\920 from environment

C

C Fri Jun 27 15:54:23 2008

C Client NLS settings: AMERICAN_AMERICA.WE8DEC

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

C Connecting as /@ABD on connection 0 (nls_hdl 0) ...

C Nls Characterset Natcharacterset C EnvHp ErrHp ErrHpBatch

C 0 1 054CF758 054D47F8 054D4260

C Attaching to DB Server ABD (con_hdl=0,svchp=054D41B4,svrhp=054D4E04)

C

C Fri Jun 27 15:54:24 2008

C Starting user session (con_hdl=0,svchp=054D41B4,srvhp=054D4E04,usrhp=054DD618)

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

[dboci.c 4176]

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

[dbsloci.c 9891]

C Try to connect with default password

C Connecting as SAPABD/<pwd>@ABD on connection 0 (nls_hdl 0) ...

C Nls Characterset Natcharacterset C EnvHp ErrHp ErrHpBatch

C 0 1 054CF758 054D47F8 054D4260

C Starting user session (con_hdl=0,svchp=054D41B4,srvhp=054D4E04,usrhp=054DD618)

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

[dboci.c 4176]

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

[dbsloci.c 9891]

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#2 @ 419] [dblink 0419 ]

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

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

M in_ThErrHandle: 1

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

M

M Info for wp 0

M

M stat = 4

M reqtype = 1

M act_reqtype = -1

M rq_info = 0

M tid = -1

M mode = 255

M len = -1

M rq_id = 65535

M rq_source = 255

M last_tid = 0

M last_mode = 0

M int_checked_resource(RFC) = 0

M ext_checked_resource(RFC) = 0

M int_checked_resource(HTTP) = 0

M ext_checked_resource(HTTP) = 0

M report = > <

M action = 0

M tab_name = > <

M

M *****************************************************************************

M *

M * LOCATION SAP-Server edcaunt07_ABD_00 on host edcaunt07 (wp 0)

M * ERROR tskh_init: db_connect

M *

M * TIME Fri Jun 27 15:54:24 2008

M * RELEASE 640

M * COMPONENT Taskhandler

M * VERSION 1

M * RC 13

M * MODULE thxxhead.c

M * LINE 9637

M * COUNTER 1

M *

M *****************************************************************************

M

M PfStatDisconnect: disconnect statistics

M Entering TH_CALLHOOKS

M ThCallHooks: call hook >ThrSaveSPAFields< for event BEFORE_DUMP

M *** ERROR => ThrSaveSPAFields: no valid thr_wpadm [thxxrun1.c 730]

M *** ERROR => ThCallHooks: event handler ThrSaveSPAFields for event BEFORE_DUMP failed [thxxtool3.c 252]

M Entering ThSetStatError

M Entering ThReadDetachMode

M call ThrShutDown (1)...

M ***LOG Q02=> wp_halt, WPStop (Workproc 0 5816) [dpnttool.c 357]

[former_member227600]

Hi,

First of all check owner using the following command

select owner from dba_tables where table_name='sapuser';

if you get the owner name ops$<oldsid>adm than

Drop your ops$<oldsid>adm.sapuser table using drop command

drop table "ops$<oldsid>adm".sapuser;

And create new user.

Using

create user ops$<sid>adm identified externally

And run also

grant dba,resource,sapdba,connect to ops$<sid>adm;

I performed this all of i described on AIX operating system.May you get some help from this.

Karan

Edited by: karan Singh on Jun 27, 2008 2:11 PM

[Former Member]

Hello. Try to change password for SAPABD user http://help.sap.com/saphelp_nw04/helpdata/en/4f/c3883989676778e10000000a11402f/frameset.htm

Regards.

[Former Member]

Hi,

check

also check Note 400241 - Problems with ops$ or sapr3 connect to Oracle

regards,

kaushal