cancel
Showing results for 
Search instead for 
Did you mean: 

Additional dialog Instance for 6.40 not started

victor_bakhmin2
Discoverer
0 Kudos

I've installed additional dialog instance RWA for already existed central instance RWT (DB Oracle 9.2.0.8). When disp+work.exe is started and tried to get password for OPS$-user from remote DB - the process is toped with follow error message (dev_w0 log):

M Sat May 12 12:56:46 2007

M calling db_connect ...

C Got ORACLE_HOME=D:\oracle\RWA\920 from environment

C Client NLS settings: AMERICAN_AMERICA.WE8DEC

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

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

C Attaching to DB Server RWT (con_hdl=0,svchp=03913004,svrhp=03913C54)

C Starting user session (con_hdl=0,svchp=03913004,srvhp=03913C54,usrhp=0391C864)

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 SAPRWT/<pwd>@RWT on connection 0 ...

C Starting user session (con_hdl=0,svchp=03913004,srvhp=03913C54,usrhp=0391C864)

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

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 rusaprwa_RWA_10 on host rusaprwa (wp 0)

M * ERROR tskh_init: db_connect

M *

M * TIME Sat May 12 12:56:46 2007

M * RELEASE 640

M * COMPONENT Taskhandler

M * VERSION 1

M * RC 13

M * MODULE thxxhead.c

M * LINE 9589

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 1896) [dpnttool.c 357]

So the process died.

When I try to connect in RWT instance - there is no problem:

SQL*Plus: Release 9.2.0.8.0 - Production on Sat May 12 17:19:35 2007

Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.

SQL> connect /@RWT

Connected.

If I do the same in RWA instance - the ORA-01017

SQL*Plus: Release 9.2.0.8.0 - Production on Sat May 12 17:20:09 2007

Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.

SQL> connect /@RWT

ERROR:

ORA-01017: invalid username/password; logon denied

Could anybody help me with the problem ? Thank you in advance.

Victor.

Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Kudos

Hello Victor,

I understand that RWA and RWT are SIDs (system ids or in simpler terms syste names)

How come your dialog instance has different SID from your Central Instance?

It is not possible. RWA is another central instance in that case !!.

Regards.

Ruchit

victor_bakhmin2
Discoverer
0 Kudos

Hi Ruchit,

Thank you for reply. You are right. Our central instance SID is RWT and sa I see the additional dialog instance should has the same SID. Is it correct ?

Kind Regards,

Victor.

Former Member
0 Kudos

Hello Victor,

Yes of course. Additional dialog instance(s) should have the same SID.

Please award points if the answer was useful.

Regards.

Ruchit.