Problem installing dialog instance for BI -

[Former Member]

The installation is going smoothly untill it fails on the last step which is startup of the applicaton server.

When I try to startup manually I get:

ddrsap06:dbpadm 42> startsap

Checking DBP Database

-

---

ABAP Database is not available via R3trans

Starting SAP-Collector Daemon

-

---

10:20:16 14.02.2007 LOG: Effective User Id is root

***********************************************************************

• This is Saposcol Version COLL 20.89 700 - AIX v6.55 5L-64 bit 060323

• Usage: saposcol -l: Start OS Collector

• saposcol -k: Stop OS Collector

• saposcol -d: OS Collector Dialog Mode

• saposcol -s: OS Collector Status

• The OS Collector (PID 315438) is already running .....

************************************************************************

saposcol already running

ABAP Database DBP must be started on remote server

I am checking it against other application server that works (for other ECC system) and I do not see any difference in terms of configuration.

When I run R3trans -d I get the log in which I can find the section with error:

ORA-1403 when accessing table SAPUSER

Can you Oracle guys help me with finding out what have I done wrong.

4 ETW000 [dev trc ,00000] Allocating service context handle for con_hdl=0 66 0.014355

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

4 ETW000 [dev trc ,00000] Attaching to DB Server DBP (con_hdl=0,svchp=0x110f92978,svrhp=0x110fa4738)

4 ETW000 58 0.014437

4 ETW000 [dev trc ,00000] Assigning server context 0x110fa4738 to service context 0x110f92978

4 ETW000 37160 0.051597

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

4 ETW000 [dev trc ,00000] Starting user session (con_hdl=0,svchp=0x110f92978,srvhp=0x110fa4738,usrhp=0x110f91d80)

4 ETW000 36 0.051668

4 ETW000 [dev trc ,00000] Assigning user session 0x110f91d80 to service context 0x110f92978

4 ETW000 9998 0.061666

4 ETW000 [dev trc ,00000] Now '/@DBP' is connected (con_hdl 0, nls_hdl 0).

4 ETW000 838 0.062504

<b>4 ETW000 [dbsloci. ,00000] *** ERROR => ORA-1403 when accessing table SAPUSER</b>4 ETW000 903 0.063407

4 ETW000 [dev trc ,00000] Disconnecting from connection 0 ... 86 0.063493

4 ETW000 [dev trc ,00000] Rolling back transaction ... 23 0.063516

4 ETW000 [dev trc ,00000] Closing user session (con_hdl=0,svchp=0x110f92978,usrhp=0x110f91d80)

4 ETW000 251 0.063767

4 ETW000 [dev trc ,00000] Now I'm disconnected from ORACLE 492 0.064259

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

4 ETW000 [dev trc ,00000] Connecting as SAPDBP/<pwd>@DBP on connection 0 (nls_hdl 0) ... (dbsl 700 240106)

4

[Former Member]

Hi

Try to run R3trans -d and see the out put , also check whether the enviornment variables are set correctly

thanks

prince Jose