Solved: sap OPS$ user error

Former Member · ‎06-19-2013

Dear Experts,

I have restore oracle database on test system. after restoration i have created OPS$ user as per snote400241. still i m not able to start dispatcher. Pls. find dev_w0 log.

---------------------------------------------------

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

---------------------------------------------------

*

* ACTIVE TRACE LEVEL 1

* ACTIVE TRACE COMPONENTS all, M

*

B

B Tue Jun 18 23:52:57 2013

B create_con (con_name=R/3)

B Loading DB library 'K:\usr\sap\PRD\SYS\exe\run\dboraslib.dll' ...

B Library 'K:\usr\sap\PRD\SYS\exe\run\dboraslib.dll' loaded

B Version of 'K:\usr\sap\PRD\SYS\exe\run\dboraslib.dll' is "640.00", patchlevel (0.386)

B New connection 0 created

M sysno 00

M sid PRD

M systemid 560 (PC with Windows NT)

M relno 6400

M patchlevel 0

M patchno 390

M intno 20020600

M make: multithreaded, ASCII

M pid 3952

M

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

I MtxInit: -2 0 0

M DpSysAdmExtCreate: ABAP is active

M DpShMCreate: sizeof(wp_adm) 7712 (964)

M DpShMCreate: sizeof(tm_adm) 2502856 (12452)

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 (364)

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

M DpShMCreate: SHM_DP_ADM_KEY (addr: 04C60040, size: 2789648)

M DpShMCreate: allocated sys_adm at 04C60040

M DpShMCreate: allocated wp_adm at 04C617D8

M DpShMCreate: allocated tm_adm_list at 04C635F8

M DpShMCreate: allocated tm_adm at 04C63620

M DpShMCreate: allocated wp_ca_adm at 04EC66E8

M DpShMCreate: allocated appc_ca_adm at 04ECAD38

M DpShMCreate: allocated comm_adm_list at 04ECC4A8

M DpShMCreate: allocated comm_adm at 04ECC4C0

M DpShMCreate: allocated vmc_adm_list at 04EFB2C0

M DpShMCreate: system runs without vmc_adm

M DpShMCreate: allocated ca_info at 04EFB2E8

M DpShMCreate: allocated wall_adm at 04EFB348

M DpRqQInit: Parameter rdisp/queue_lock_level = 2

M ThTaskStatus: rdisp/reset_online_during_debug 0

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 tskh_init: initializing DIA work process W0

M tskh_init: rdisp/cleanup_after_crash = 1

M

M Tue Jun 18 23:52:58 2013

M calling db_connect ...

C Prepending E:\oracle\ora92 to Path.

C got NLS_LANG='AMERICAN_AMERICA.WE8DEC' from environment

C Client NLS settings: AMERICAN_AMERICA.WE8DEC

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

C Connecting as /@PRD on connection 0 (nls_hdl 0) ... (dbsl 640 310811, non-unicode)

C Nls CharacterSet NationalChar C EnvHp ErrHp ErrBt

C 0 WE8DEC AL16UTF16 1 081A4568 081A95F4 081A9098

C Attaching to DB Server PRD (con_hdl=0,svchp=081A8FEC,srvhp=081A9BC4)

C Starting user session (con_hdl=0,svchp=081A8FEC,srvhp=081A9BC4,usrhp=081B23A4)

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

[dboci.c 4459]

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

[dbsloci.c 11390]

C Info: rc=99, oerr=1017, try to connect with default password.

C Connecting as SAPPRD/<pwd>@PRD on connection 0 (nls_hdl 0) ... (dbsl 640 310811, non-unicode)

C Nls CharacterSet NationalChar C EnvHp ErrHp ErrBt

C 0 WE8DEC AL16UTF16 1 081A4568 081A95F4 081A9098

C Starting user session (con_hdl=0,svchp=081A8FEC,srvhp=081A9BC4,usrhp=081B23A4)

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

[dboci.c 4459]

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

[dbsloci.c 11390]

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

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

B ***LOG BY2=> sql error 1017 performing CON [dblink#6 @ 430] [dblink 0430 ]

B ***LOG BY0=> ORA-01017: invalid username/password; logon denied [dblink#6 @ 430] [dblink 0430 ]

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

M in_ThErrHandle: 1

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

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 drsabc_PRD_00 on host drsabc (wp 0)

M * ERROR tskh_init: db_connect

M *

M * TIME Tue Jun 18 23:52:58 2013

M * RELEASE 640

M * COMPONENT Taskhandler

M * VERSION 1

M * RC 13

M * MODULE thxxhead.c

M * LINE 10004

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 735]

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

M Entering ThSetStatError

M Entering ThReadDetachMode

M call ThrShutDown (1)...

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

former_member206552 · ‎06-19-2013

Hi Sahil

pleae make sure the correct windows users also excist

Note 50088 - Creating OPS$ users on Windows NT/Oracle

SAPSERVICERPRD etc..

Best regards

Marius

Former Member · ‎06-21-2013

Hi,

As this is Windows OS, pay special attention to correct OPS$ user name. If it's domain installation it will be OPS$DOMAINNAME\<SID>ADM

If local then OPS$HOSTNAME\<SID>ADM

Further to recommendations above please also check following:

Test if synonym to sapuser exist:

SELECT OWNER, TABLE_OWNER, TABLE_NAME FROM DBA_SYNONYMS WHERE SYNONYM_NAME = 'SAPUSER';

If yes, then:

If PUBLIC is returned as the first value:

DROP PUBLIC SYNONYM SAPUSER;

If another name <name> is returned as the first value:

DROP SYNONYM "<name>".SAPUSER;

Then re-create synonym:

CREATE SYNONYM "OPS$<HOST\DOMAIN>\SAPSERVICE<SID>".SAPUSER FOR "OPS$<HOST\DOMAIN>\<SID>ADM".SAPUSER;

GRANT SELECT, INSERT, UPDATE ON "OPS$<HOST\DOMAIN>\<SID>ADM".SAPUSER TO "OPS$<HOST\DOMAIN>\<SID>ADM";

GRANT SELECT, UPDATE ON "OPS$<HOST\DOMAIN>\<SID>ADM".SAPUSER TO "OPS$<HOST\DOMAIN>\SAPSERVICE<SID>";

Hope this helps

Former Member · ‎06-20-2013

Well you probably restored a PRD system to the TEST env so this is why you are facing the problem.

Here is what you need to do:

1. Connect to the DB using sqlplus and sysdba and run the following command:

SELECT OWNER FROM DBA_TABLES WHERE TABLE_NAME = 'SAPUSER';

Make sure that the result is the production OPS$ (for example OPS$<DOMAIN>\PRDADM) - if so , this is the cause of your problem.

2. Run the following command:

SELECT OWNER FROM DBA_TABLES WHERE TABLE_NAME = 'T000';

The result is the schema owner of your system. Take note of it.

Let's assume that the schema owner is SAPR3 for this example.

3. Now we need to drop the SAPUSER table using:

DROP TABLE "OPS$<DOMAIN>\SRPADM".SAPUSER;

4. Because you use Oracle 9 use the oradbusr.txt script from note 50088 https://service.sap.com/sap/support/notes/50088

Download the script, change the extension to .sql and run it using the following syntax:

@oradbusr.sql <SCHEMAOWNER> NT <DOMAIN> <SID>

Where <SCHEMAOWNER> is the one you found at step 2 (SAPR3 for example), the <DOMAIN> is the domain of your server. and <SID> is the SID of your TEST system.

When the script is finished - the OPS$ mechanism is fixed and suitable for your TEST env.

Now try to start the SAP system.
If you followed the steps carefully and exactly as i described - there will be no more ORA-1017 errors .

If you encounter:

ERROR => ORA-1403 when accessing table SAPUSER

Then use this note https://service.sap.com/sap/support/notes/400241

Former Member · ‎06-20-2013

Hi Sahil,

Check the values of schema user details in sapuser table.

SQL> select * from "OPS$<SID>ADM".sapuser;

If you don't fount insert using below command:

SQL> INSERT INTO "OPS$<SID>ADM".SAPUSER VALUES ('SAPR3P','password');

if found the entries try to change the password for schema user and then try.

Brtools-->additional functions --> Change password of database user

Regards,

Lakshmi

Former Member · ‎06-19-2013

reset the password of SAPPRD from brtools.

or the command mentioned by Reagan.

brconnect -u / -f chpass -o SAPPRD -p <password>

former_member188883 · ‎06-19-2013

Hi Sahil,

Please check the schema for test system.

Please change the parameter dba_ora_schema=<Source system Schema>

for user <sid>adm on the target system.

Post this check the results for R3trans -d.

Hope this helps.

Regards,

Deepak Kori

Reagan · ‎06-19-2013

Hello

brconnect -u / -f chpass -o SAPPRD -p P@ssW0rD

Run this as sidadm user and then check R3trans -d

Check this thread

http://scn.sap.com/thread/3369353

Regards

RB

sap OPS$ user error

Accepted Solutions (1)

Accepted Solutions (1)

Answers (6)

Answers (6)

How can we use a odata connection of datasphere to...

Re: SQL query is not written completely in framewo...

SQL query is not written completely in framework.t...

Copy from the property of one dimension to the mem...

Set SAC standard Filter (Filter Panel) to display ...