Oracle-Dispatcher Connectivity Problem

[Former Member]

Hi Everyone...

Well coming straight to the point, i have been facing a problem with my SAP startup.

Whenever i start SAP through the MMC, the dispatcher starts, but as soon as i try to login to SAP easy access, the message server shuts down immediately.

After looking into the system, i have realized that this problem arrises when message server is unable to connect to Oracle DBs. So every time in order to use SAP, first of all i have to start Oracle through CMD, i mean through DOS.

Now that you know the whole situation, my question is how do i sort this problem, so that i dont have to go to CMD to turn on my Oracle Database.

Pleaes help me with the trouble, and if you need any more information, post it here...

Regards

- Sheetal

[JPReyes]

Check that the oracle services are running in automatic so they start on boot... after that check that when you start SAP using MMC you can see strdbs.cmd running that should start and open the DB prior the dispatcher runs... also check sapstartsrv.log

Regards

Juan

[Former Member]

Hi Juan...

Well, most of the Oracle Services that are Automatic by default, starts automatically as soon as my system is up and running.

Regarding else, i couldnt understand what did you mean when you said "when you start SAP using MMC you can see strdbs.cmd running that should start and open the DB prior the dispatcher runs... also check sapstartsrv.log"

But i tried to run the command strdbs in cmd, after which i got this result -

C:\......>strdbs

C:\......>echo WHENEVER SQLERROR exit SQL.SQLCODE 1>v9s

tart.sql

C:\......>echo connect / as sysdba 1>>v9start.sql

C:\......>echo startup 1>>v9start.sql

C:\......>echo exit 1>>v9start.sql

SQL*Plus: Release 8.1.7.0.0 - Production on Mon Nov 30 22:01:50 2009

(c) Copyright 2000 Oracle Corporation. All rights reserved.

Connected to an idle instance.

ORACLE instance started.

Total System Global Area 1109387292 bytes

Fixed Size 75804 bytes

Variable Size 464011264 bytes

Database Buffers 644243456 bytes

Redo Buffers 1056768 bytes

Database mounted.

Database opened.

Disconnected

C:\......>

I will post the sapstartsrv.log, but where do i find it?

Please help...

[Former Member]

Hi,

with your database up can you from the cammand lind run R3trans -x if you get a return code other than 0 can you post the log.

The log will be called trans.log

Also can you post your :

dev_ms

dev_disp

Regards

Mark

[Former Member]

Hi Mark...

Well when i run r3trans -x on my CMD, i get this...

C:\...... >r3trans -x

This is r3trans version 6.07 (release 620 - 05.08.02 - 15:04:42).

2EETW169 no connect possible: "DBMS = ORACLE --- dbs_o

ra_tnsname = 'RDB'"

r3trans finished (0012).

I am sorry, but since i am new to SAP, i dont know where to find this trans.log, is that a file in the folder "usr\sap\trans\log"? If yes, then, i dont see any files in this folder. Else, please tell me where can i find it.

Apart from this, could you please tell me where can i find - dev_ms and dev_disp...

[Former Member]

Hi,

Just list the directory where you ran R3trans -x the trans.log will be there.

Before we check out the dev traces we will get to the bottom of the R3trans log which most likely is your problem.

Can you copy and paste the trans.log here please..

Mark

[Former Member]

Hi again Mark...

Here is the trans.log -

4 ETW000 r3trans version 6.07 (release 620 - 05.08.02 - 15:04:42).

4 ETW000 ===============================================

4 ETW000

4 ETW000 date&time : 30.11.2009 - 20:51:36

4 ETW000 control file: <no ctrlfile>

4 ETW000 R3trans was called as follows: r3trans -x

4 ETW000 trace at level 2 opened for a given file pointer

4 ETW000 [dev trc ,00000] Mon Nov 30 20:51:39 2009 56743 0.056743

4 ETW000 [dev trc ,00000] db_con_init called 199 0.056942

4 ETW000 [dev trc ,00000] create_con (con_name=R/3) 113 0.057055

4 ETW000 [dev trc ,00000] Loading DB library 'dboraslib.dll' ...

4 ETW000 158 0.057213

4 ETW000 [dev trc ,00000] load shared library (dboraslib.dll), hdl 0

4 ETW000 27841 0.085054

4 ETW000 [dev trc ,00000] using "E:\usr\sap\RAM\SYS\exe\run\dboraslib.dll"

4 ETW000 100 0.085154

4 ETW000 [dev trc ,00000] Library 'dboraslib.dll' loaded

4 ETW000 81 0.085235

4 ETW000 [dev trc ,00000] function DbSlExpFuns loaded from library dboraslib.dll

4 ETW000 88 0.085323

4 ETW000 [dev trc ,00000] Version of 'dboraslib.dll' is "620.02", patchlevel (0.112)

4 ETW000 165 0.085488

4 ETW000 [dev trc ,00000] function dsql_db_init loaded from library dboraslib.dll

4 ETW000 86 0.085574

4 ETW000 [dev trc ,00000] function dbdd_exp_funs loaded from library dboraslib.dll

4 ETW000 107 0.085681

4 ETW000 [dev trc ,00000] New connection 0 created 68 0.085749

4 ETW000 [dev trc ,00000] 0: name = R/3, con_id = -000000001 state = DISCONNECTED, perm = YES, reco = NO

4 ETW000 91 0.085840

4 ETW000 [dev trc ,00000] db_con_connect (con_name=R/3)

4 ETW000 108 0.085948

4 ETW000 [dev trc ,00000] find_con found the following connection for reuse:

4 ETW000 81 0.086029

4 ETW000 [dev trc ,00000] 0: name = R/3, con_id = 000000000 state = DISCONNECTED, perm = YES, reco = NO

4 ETW000 85 0.086114

4 ETW000 [dev trc ,00000] Got ORACLE_HOME=E:\oracle\ora81 from environment

4 ETW000 818 0.086932

4 ETW000 [dev trc ,00000] -->oci_initialize 57 0.086989

4 ETW000 [dev trc ,00000] Client NLS settings: AMERICAN_AMERICA.WE8DEC

4 ETW000 40658 0.127647

4 ETW000 [dev trc ,00000] Logon as OPS$-user to get SAPRAM's password

4 ETW000 194 0.127841

4 ETW000 [dev trc ,00000] Connecting as /@RDB on connection 0 ...

4 ETW000 92 0.127933

4 ETW000 [dev trc ,00000] Allocating service context handle

4 ETW000 13189 0.141122

4 ETW000 [dev trc ,00000] Allocating server context handle

4 ETW000 93 0.141215

4 ETW000 [dev trc ,00000] Attaching to DB Server RDB (con_hdl=0,svchp=0173A350,svrhp=0173A15C)

4 ETW000 90 0.141305

4 ETW000 [dev trc ,00000] Assigning server context 0173A15C to service context 0173A350

4 ETW000 89858 0.231163

4 ETW000 [dev trc ,00000] Allocating user session handle

4 ETW000 36 0.231199

4 ETW000 [dev trc ,00000] Starting user session (con_hdl=0,svchp=0173A350,srvhp=0173A15C,usrhp=01780EFC)

4 ETW000 78 0.231277

4 ETW000 [dboci.c ,00000] *** ERROR => OCI-call 'OCISessionBegin' failed: rc = 1017

4 ETW000 2371 0.233648

4 ETW000 [dboci.c ,00000] *** ERROR => CONNECT failed with sql error '1017'

4 ETW000 29 0.233677

4 ETW000 [dev trc ,00000] Try to connect with default password

4 ETW000 30 0.233707

4 ETW000 [dev trc ,00000] Connecting as SAPRAM/<pwd>@RDB on connection 0 ...

4 ETW000 25 0.233732

4 ETW000 [dev trc ,00000] Assigning username to user session 01780EFC

4 ETW000 30 0.233762

4 ETW000 [dev trc ,00000] Assigning password to user session 01780EFC

4 ETW000 26 0.233788

4 ETW000 [dev trc ,00000] Starting user session (con_hdl=0,svchp=0173A350,srvhp=0173A15C,usrhp=01780EFC)

4 ETW000 26 0.233814

4 ETW000 [dboci.c ,00000] *** ERROR => OCI-call 'OCISessionBegin' failed: rc = 1017

4 ETW000 2247 0.236061

4 ETW000 [dboci.c ,00000] *** ERROR => CONNECT failed with sql error '1017'

4 ETW000 27 0.236088

4 ETW000 [dblink ,00419] ***LOG BY2=>sql error 1017 performing CON [dblink#1 @ 419]

4 ETW000 2388 0.238476

4 ETW000 [dblink ,00419] ***LOG BY0=>ORA-01017: invalid username/password; logon denied [dblink#1 @ 419]

4 ETW000 57 0.238533

2EETW169 no connect possible: "DBMS = ORACLE --- dbs_ora_tnsname = 'RDB'"

[Former Member]

Hi,

Have you done anthing with the system recently ?

Refresh

Change passwords

Change user for the oracle service....

Incidently do you know the database is well out of support ?

Mark

[JPReyes]

ORA-01017: invalid username/password

That sounds like a problem with the OPS$ users... check SAP note 400241

Regards

Juan

[Former Member]

@ Mark

Well, the answer to your question is Yes as well as No...

Reason - I have just finished installation of SAP a few hours ago. I installed SAP only after fomatting and doing fresh XP installation. So, i havent done anything with the system.

But yes, before installing SAP, i encountered problems with Oracle installation.

The installation took a little too much time. Also, prior to that, first Oracle Intelligent Agent couldnt be insstalled.

Then i uninstalled Oracle.

Once again, when i tried installing Oracle, it popped a message saying - "The Oracle Service OracleServiceDBS with the system identifier DBS already exists. Rename your Oracle system identifier (SID)"... Since the system was taking too much time, i halted the installation.

After that, somehow i re-installed oracle.

After that, i started installing SAP. Unfortunately, by mistake i gave the same name to Database System Identifier of SAP as the Database System Identifier of Oracle. So, it resulted in error in SAP installation.

After that, instead of installing SAP from the scratch, i deleted the folder that has saparch, sapbackup, sapcheck, saptrace, oraarch etc. sub-folders. Then, I installed SAP kernel, then CI followed by DB Instance.

Thats my story...

[Former Member]

Hi,

thought it might be something like that.

You have a SAPRAM schema with a dbs_ora_tnsname = 'RDB'" as juan mentioned above check out note 400241...

Also I do not think it will Run on XP without trouble.....

As I see it you have two options :

1) Continue fiddling to get it working with note 400241 it's defo somthing to do with OPS$ / SAPUSER table

2) Strip it right down and re-install it again cleanly.

personally I would go for option 2.......

Regards

Mark