on 05-29-2007 8:17 AM
hi gurus
i have installed 4.7 ides on windows 2003 with oracle 8i as DB
installation went without any problems, but after the installation workprocess
are not started when instance starts. this is developer trace log
-
trc file: "dev_w0", trc level: 1, release: "620"
-
*
ACTIVE TRACE LEVEL 1
ACTIVE TRACE COMPONENTS all, M
*
B
B Fri May 25 11:29:31 2007
B create_con (con_name=R/3)
B Loading DB library 'C:\usr\sap\DEV\SYS\exe\run\dboraslib.dll' ...
B Library 'C:\usr\sap\DEV\SYS\exe\run\dboraslib.dll' loaded
B Version of 'C:\usr\sap\DEV\SYS\exe\run\dboraslib.dll' is "620.02", patchlevel (0.112)
B New connection 0 created
M systemid 560 (PC with Windows NT)
M relno 6200
M patchlevel 0
M patchno 251
M intno 20020600
M pid 3800
M
M ***LOG Q0Q=> tskh_init, WPStart (Workproc 0 3800) [dpxxdisp.c 1016]
I MtxInit: -2 0 0
X EmInit: MmSetImplementation( 2 ).
X <ES> client 0 initializing ....
X Using implementation std
M <EsNT> Memory Reset enabled as NT default
X ES initialized.
M
M Fri May 25 11:29:39 2007
M calling db_connect ...
C Got ORACLE_HOME=C:\oracle\ora81 from environment
C Client NLS settings: AMERICAN_AMERICA.WE8DEC
C Logon as OPS$-user to get SAPDEV's password
C Connecting as /@DEV on connection 0 ...
C Attaching to DB Server DEV (con_hdl=0,svchp=06AB95D8,svrhp=06AB93E4)
C
C Fri May 25 11:30:32 2007
C Starting user session (con_hdl=0,svchp=06AB95D8,srvhp=06AB93E4,usrhp=06AFAFDC)
C
C Fri May 25 11:30:34 2007
C *** ERROR => OCI-call 'OCISessionBegin' failed: rc = 1017
[dboci.c 3718]
C *** ERROR => CONNECT failed with sql error '1017'
[dboci.c 9536]
C Try to connect with default password
C Connecting as SAPDEV/<pwd>@DEV on connection 0 ...
C Starting user session (con_hdl=0,svchp=06AB95D8,srvhp=06AB93E4,usrhp=06AFAFDC)
C *** ERROR => OCI-call 'OCISessionBegin' failed: rc = 1017
[dboci.c 3718]
C *** ERROR => CONNECT failed with sql error '1017'
[dboci.c 9536]
B ***LOG BY2=> sql error 1017 performing CON [dbsh#2 @ 962] [dbsh 0962 ]
B ***LOG BY0=> ORA-01017: invalid username/password; logon denied [dbsh#2 @ 962] [dbsh 0962 ]
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 1098]
M in_ThErrHandle: 1
M *** ERROR => tskh_init: db_connect (step 1, th_errno 13, action 3, level 1) [thxxhead.c 8277]
M
M Info for wp 0
M
M stat = 4
M reqtype = 1
M act_reqtype = -1
M tid = -1
M mode = 255
M len = -1
M rq_id = -1
M rq_source = 255
M last_tid = 0
M last_mode = 0
M rfc_req = 0
M report = > <
M action = 0
M tab_name = > <
M
M *****************************************************************************
M *
M * LOCATION SAP-Server SAPSYS_DEV_00 on host SAPSYS (wp 0)
M * ERROR tskh_init: db_connect
M *
M * TIME Fri May 25 11:30:34 2007
M * RELEASE 620
M * COMPONENT Taskhandler
M * VERSION 1
M * RC 13
M * MODULE thxxhead.c
M * LINE 8408
M * COUNTER 1
M *
M *****************************************************************************
M
M Entering TH_CALLHOOKS
M ThCallHooks: call hook >SAP-Trace buffer write< for event BEFORE_DUMP
M ThCallHooks: call hook >ThrSaveSPAFields< for event BEFORE_DUMP
M *** ERROR => ThrSaveSPAFields: no valid thr_wpadm [thxxrun1.c 672]
M *** ERROR => ThCallHooks: event handler ThrSaveSPAFields for event BEFORE_DUMP failed [thxxtool3.c 235]
M Entering ThSetStatError
M Entering ThReadDetachMode
M call ThrShutDown (1)...
M ***LOG Q02=> wp_halt, WPStop (Workproc 0 3800) [dpnttool.c 345]
i didn't change any default settings but it is showing invalid username/password; logon denied. DB connect failed.
pls guide in the right direction.
regds
sandeep
a) ora 8i is not supported on win2003...
b) "<b>ORA-01017: invalid username/password; logon denied</b>" did you change any passwords lately?
c) try to login via sqlplus/srvmgr and user SYS and/or SYSTEM
GreetZ, AH
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi.......Andreas Herzog
How can you say that Oracle 8i is not supported by Win2003 ?
I am asking , because.....
I have installed successfully 4.7E with Oracle 8i on Win 2003 server recently .
Nagendra.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
lets take a look at the error ( appart of supportability issues 😞
<i>C Logon as OPS$-user to get SAPDEV's password
C <b>Connecting as /@DEV on connection 0</b> ...
C Attaching to DB Server DEV (con_hdl=0,svchp=06AB95D8,svrhp=06AB93E4)
C
C Fri May 25 11:30:32 2007
C Starting user session (con_hdl=0,svchp=06AB95D8,srvhp=06AB93E4,usrhp=06AFAFDC)
C
C Fri May 25 11:30:34 2007
C *** ERROR => <b>OCI-call 'OCISessionBegin' failed: rc = 1017</b>
[dboci.c 3718]
C *** ERROR => CONNECT failed with sql error '1017'
[dboci.c 9536]
C <b>Try to connect with default password</b>
C Connecting as SAPDEV/<pwd>@DEV on connection 0 ...
C Starting user session (con_hdl=0,svchp=06AB95D8,srvhp=06AB93E4,usrhp=06AFAFDC)
C *** ERROR => <b>OCI-call 'OCISessionBegin' failed: rc = 1017</b></i>
SAP tries to connect with the OPS$ user in order to retrieve the SAPDEV password from the sapuser table.
This step fails --> Your OPS$ user is not configured, you have to do it.
As the first step fails, then it tries to connect with the default password.
You have changed the default password --> it fails again.
Quick solution --> Change the SAPDEV password to the default.
Then create the OPS$ user ( there is a note, but not sure what is the number now )
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
hi greetz
are you sure oracle 8i doesnot support win203,
i didn't change any passwords.
redgs
sandeep
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
83 | |
24 | |
12 | |
9 | |
7 | |
6 | |
5 | |
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.