on 05-12-2007 2:23 PM
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.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
93 | |
10 | |
10 | |
9 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.