console error with GUI , return code -17

[Former Member]

Hi All,

I have just finished the Installation of SAP IDES 4.7. Installation was sucessful, after that I Installed GUI 640. But when we are starting the Console it is starting without any error which also shows WP table details in run mode. When we logon to gui, console becomes "Yellow" and dispatch process stop with a return code -17.

Please help.

Thanks

Jagat.

[Former Member]

I checked the user and no users in locked. also we have uninstalled GUI 640 and installed 620. But still the same issue.

[Former Member]

Hi,

there is no problem with GUI.

workout with OSS Note 400241 - Problems with ops$ or sapr3 connect to Oracle

read this note carefully.

Check whether the parameter

os_authent_prefix = ops$

is set correctly in init<sid>.ora. If you have to make a change, restart the database afterwards.

On Windows, make sure that the following parameter is set in sqlnet.ora:

SQLNET.AUTHENTICATION_SERVICES = (NTS)

Determine which operating system user <os_user> wants to create the connection. If this involves a connect initiated out of the R/3 System (for example, work process connect, DB13 actions), user <sid>adm is used under UNIX and user sapservice<sid> under NT. If you manually called the program that executes the connect, the user you are using is decisive here.

Use SVRMGRL to check whether the user OPS$<os_user> (or OPS$<domain>\ <os_user> for NT with Oracle >= 8.1.5) has been created at database level:

SELECT * FROM DBA_USERS WHERE USERNAME = 'OPS$<os_user>';

(for <os_user>, always use upper case)

If the system does not return an entry, create the user:

CREATE USER "OPS$<os_user>" DEFAULT TABLESPACE <user_tsp>

TEMPORARY TABLESPACE PSAPTEMP IDENTIFIED EXTERNALLY;

Note that the name of the OPS$ user must be specified completely in uppercase letters (also the host and domain names in case of NT and W2K), since a logon as OPS$ user will not work if it is not:

wrong: CREATE USER "OPS$c11adm" DEFAULT TABLESPACE ...

CREATE USER "OPS$sapdom\C11ADM" DEFAULT TABLESPACE ...

correct: CREATE USER "OPS$C11ADM" DEFAULT TABLESPACE ...

CREATE USER "OPS$SAPDOM\C11ADM" DEFAULT TABLESPACE ...

Tablespace <user_tsp> is used when newly creating objects, when no explicit tablespace name is specified. In connection with R/3, this is almost never the case. Therefore, you can specify any tablespace. Proposal:

R/3 <= 4.6D: <user_tsp> = PSAPUSER1D

R/3 >= 6.10: <user_tsp> = PSAP<sid>USR

Check whether the OPS$ user has sufficient authorizations. The following statement must at least return CONNECT and RESOURCE:

SELECT GRANTED_ROLE FROM DBA_ROLE_PRIVS

WHERE GRANTEE = 'OPS$<os_user>';

If CONNECT and/or RESOURCE is missing, you can grant these authorizations as follows:

GRANT CONNECT, RESOURCE TO "OPS$<os_user>";

If all the settings described above have been made correctly on NT/ Windows 2000, but the error ORA-01017 is still displayed during the OPS$ Connect, the cause may be a start user set incorrectly for the SAP Service. Change to the services overview of the operating system and check the user who starts the service SAP<sid>_<instance_number>. If the user is not sapservice<sid>, enter sapservice<sid>. Other users (such as the local administrator) do not have an OPS$ user in the database, which leads to error ORA-01017. Check also whether the start user sapservice<sid> is a local user or a domain user. Domain users can be identified by the preceding domain name. Depending on this, the following OPS$ user should exist on database level:

Domain user: <domain>\sapservice<sid>

OPS$ user: OPS$<domain>\sapservice<sid>

Local user: sapservice<sid>

OPS$ user: OPS$<local_host>\sapservice<sid>

Otherwise, change the password in the SAPUSER table:

DELETE FROM "OPS$<sid>ADM".SAPUSER;

INSERT INTO "OPS$<sid>ADM".SAPUSER VALUES ('<sapowner>', '<password>');

regards,

kaushal

[Former Member]

Hi Kaushal,

The user was not there, i created the two users in default tablespace and unlocked the users as well, still its not working.

Pls help its urgent. If possible give me your chat ID, so that we can chat and try to find the sol asap.

Thanks,

[Former Member]

Hi,

try to execute following

connect /@<sid>

provide the result.

regards,

kaushal

[Former Member]

Hi,

I tried it with

connect /@IPE (This is my SID),

The result is,

error:

ora-01017:invalid username/password; logon denied

thanks,

[Former Member]

Hi,

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

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

C Attaching to DB Server TEK (con_hdl=0,svchp=06A497E8,svrhp=06A495F4)

C

C Sat Mar 04 10:19:07 2000

C Starting user session (con_hdl=0,svchp=06A497E8,srvhp=06A495F4,usrhp=06A913AC)

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

http://dboci.c 3718

according to log provide by you your SID should be TEK not IPE!!??

Reset the password of sapowner (i.e SAPR3) according to note 400241

regards,

kaushal

[Former Member]

Hi Kaushal,

Thanks for ur reply. Actually when we started the installation process, and GUI, we have not provide the loopback adapter in the Primary DNS, but Loopback Adapter was properly configured with IP.

Later on we realised and added the 127.0.0.1 in the Primary DNS. But its still not working.

The Log which u have asked for is attached.

-

---

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

-

---

*

• ACTIVE TRACE LEVEL 1

• ACTIVE TRACE COMPONENTS all, M

*

B

B Sat Mar 04 10:18:27 2000

B create_con (con_name=R/3)

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

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

B Version of 'C:\usr\sap\TEK\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 2792

M

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

I MtxInit: -2 0 0

X

X Sat Mar 04 10:18:29 2000

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 calling db_connect ...

C Got ORACLE_HOME=D:\oracle\ora81 from environment

C

C Sat Mar 04 10:18:30 2000

C Client NLS settings: AMERICAN_AMERICA.WE8DEC

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

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

C Attaching to DB Server TEK (con_hdl=0,svchp=06A497E8,svrhp=06A495F4)

C

C Sat Mar 04 10:19:07 2000

C Starting user session (con_hdl=0,svchp=06A497E8,srvhp=06A495F4,usrhp=06A913AC)

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 SAPTEK/<pwd>@TEK on connection 0 ...

C Starting user session (con_hdl=0,svchp=06A497E8,srvhp=06A495F4,usrhp=06A913AC)

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 sapsrv_TEK_00 on host sapsrv (wp 0)

M * ERROR tskh_init: db_connect

M *

M * TIME Sat Mar 04 10:19:07 2000

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 2792) [dpnttool.c 345]

[Former Member]

Hi,

did you logon with administrator user?

try to logon with SIDadm user and start the sap.

did the schema user is locked?

check with

sqlplus "/as sysdba"

select username,account_status from dba_users;

in case user is locked then unlock it using the command:

alter user <user_name> account unlock;

further check note 400241 Problems with ops$ or sapr3 connect to Oracle

regards,

kaushal

[Former Member]

Hi,

did you install on SAP on standalone Host?

if yes check loop back adapter is installed and have valid IP address.

read sap note Note 21971 - Connection between SAP GUI and application server terminated

if problem is still not solved

provide log of dev_w0 from \usr\sap\SID\DVEBMGS<instance Nr>\work

regards,

kaushal