Problem in installing Additional Dialogue Instance in Oracle

[Former Member]

Dear Gurus,

We have our ECC Production server on Windows Server 2008 Server with Oracle 10g on a HA. Now I am trying to install an additional app server for load balancing.

So I choose to install the additional app server on my PI quality server which is having a very less load. Since the PI server is already running on Oracle 10g I started the installation using SAPINST for the additional app server and the installation is over but when the system is trying to start the instance it fails and the dispatcher stops.

I have made the entry for the new SID in listener and tns file . Whether there is any other things that I need to do ? or just guide me how to perform this activity on an existing server in which there is a instance running with the same DB.

Thanks & Regards,

Pradeep

[Former Member · Accepted solution]

Hello pradeep. I not reccomend for you installation additional dialog instance for Production system on server where

quality PI is installed. Do not mix Productive and Test landscapes!

Second you say

Since the PI server is already running on Oracle 10g I started the installation using SAPINST for the additional app server

it does not matter are oracle installed or not, Dialog server can work without oracle installed on same server, only oracle client needed during installation.

How you install this dialoge instance ? Do you have shared profiles directory from ECC server to your PI server ?

the instance it fails and the dispatcher stops

Post dev_dip and dev_w0 traces.

Regards.

[Former Member · Accepted solution]

Hi ,

Thanks for your reply , yes I do know that an oracle client is not required since there is an Oracle exists , I am doing this installation with the same domain administrator used for our production server. I am able to login to my PI server with my ECC production SIDADM user and the r3trans -d throws no error . I have also shared the global host profile to this PI server.

Please find the dev_w0 log

-

---

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

-

---

*

• ACTIVE TRACE LEVEL 1

• ACTIVE TRACE COMPONENTS all, MJ

*

M sysno 02

M sid GEP

M systemid 562 (PC with Windows NT)

M relno 7010

M patchlevel 0

M patchno 125

M intno 20020600

M make: multithreaded, Unicode, 64 bit, optimized

M pid 5888

M

M

M Wed Dec 07 15:51:35 2011

M kernel runs with dp version 244000(ext=110000) (@(#) DPLIB-INT-VERSION-244000-UC)

M length of sys_adm_ext is 576 bytes

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

I MtxInit: 30000 0 0

M DpSysAdmExtCreate: ABAP is active

M DpSysAdmExtCreate: VMC (JAVA VM in WP) is not active

M DpShMCreate: sizeof(wp_adm) 22784 (1752)

M DpShMCreate: sizeof(tm_adm) 5912704 (29416)

M DpShMCreate: sizeof(wp_ca_adm) 24064 (80)

M DpShMCreate: sizeof(appc_ca_adm) 8000 (80)

M DpCommTableSize: max/headSize/ftSize/tableSize=500/16/552064/552080

M DpShMCreate: sizeof(comm_adm) 552080 (1088)

M DpSlockTableSize: max/headSize/ftSize/fiSize/tableSize=0/0/0/0/0

M DpShMCreate: sizeof(slock_adm) 0 (104)

M DpFileTableSize: max/headSize/ftSize/tableSize=0/0/0/0

M DpShMCreate: sizeof(file_adm) 0 (72)

M DpShMCreate: sizeof(vmc_adm) 0 (1864)

M DpShMCreate: sizeof(wall_adm) (41664/36752/64/192)

M DpShMCreate: sizeof(gw_adm) 48

M DpShMCreate: SHM_DP_ADM_KEY (addr: 000000000AA00050, size: 6607136)

M DpShMCreate: allocated sys_adm at 000000000AA00050

M DpShMCreate: allocated wp_adm at 000000000AA02270

M DpShMCreate: allocated tm_adm_list at 000000000AA07B70

M DpShMCreate: allocated tm_adm at 000000000AA07BD0

M DpShMCreate: allocated wp_ca_adm at 000000000AFAB450

M DpShMCreate: allocated appc_ca_adm at 000000000AFB1250

M DpShMCreate: allocated comm_adm at 000000000AFB3190

M DpShMCreate: system runs without slock table

M DpShMCreate: system runs without file table

M DpShMCreate: allocated vmc_adm_list at 000000000B039E20

M DpShMCreate: allocated gw_adm at 000000000B039EA0

M DpShMCreate: system runs without vmc_adm

M DpShMCreate: allocated ca_info at 000000000B039ED0

M DpShMCreate: allocated wall_adm at 000000000B039EE0

M DpRqQInit: Parameter rdisp/queue_lock_level = 2

M rdisp/queue_size_check_value : -> on,50,30,40,500,50,500,80

M ThTaskStatus: rdisp/reset_online_during_debug 0

X EmInit: MmSetImplementation( 2 ).

X MM global diagnostic options set: 0

X <ES> client 0 initializing ....

X Using implementation view

X <EsNT> Using memory model view.

M <EsNT> Memory Reset disabled as NT default

X ES initialized.

X mm.dump: set maximum dump mem to 96 MB

M ThInit: rdisp/cleanup_after_crash = 1

M

M Wed Dec 07 15:51:36 2011

M ThInit: running on host GEEPASPIQUA

M calling db_connect ...

B Loading DB library 'D:\usr\sap\GEP\D02\exe\dboraslib.dll' ...

B Library 'D:\usr\sap\GEP\D02\exe\dboraslib.dll' loaded

B Version of 'D:\usr\sap\GEP\D02\exe\dboraslib.dll' is "700.08", patchlevel (0.42)

C Prepending D:\usr\sap\GEP\D02\exe to Path.

C Oracle Client Version: '10.2.0.4.0'

C application info callback registered

C Client NLS setting (OCINlsGetInfo): connection handle 0 -> 'AMERICAN_AMERICA.UTF8'

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

C Connecting as /@GEP on connection 0 (nls_hdl 0) ... (dbsl 701 220409)

C Nls CharacterSet NationalCharSet EnvHp ErrHp ErrHpBatch

C 0 UTF8 00000000041E0EF0 00000000041E8A40 00000000041EA258

C Attaching to DB Server GEP (con_hdl=0,svchp=00000000041EA118,srvhp=00000000041EB618)

C

C Wed Dec 07 15:51:39 2011

C Starting user session: OCISessionBegin(con_hdl=0, usr='/',svchp=00000000041EA118, srvhp=00000000041EB618, usrhp=00000000041F8530)

C CbApplInfoGet() failed (ignored 1).

C Now '/@GEP' is connected: con_hdl=0, nls_hdl=0, session_id=560.

C *** ERROR => ORA-1403 when accessing table SAPUSER

[dbsloci.c 11627]

C Disconnecting from connection 0 ...

C Closing user session (con_hdl=0,svchp=00000000041EA118,usrhp=00000000041F8530)

C Now I'm disconnected from ORACLE

C Try to connect with default password

C Connecting as SAPGEP/<pwd>@GEP on connection 0 (nls_hdl 0) ... (dbsl 701 220409)

C Nls CharacterSet NationalCharSet EnvHp ErrHp ErrHpBatch

C 0 UTF8 00000000041E0EF0 00000000041E8A40 00000000041EA258

C Starting user session: OCISessionBegin(con_hdl=0, usr=SAPGEP/<pwd>, svchp=00000000041EA118, srvhp=00000000041EB618, usrhp=00000000041F8530)

C OCISessionBegin(OCI_DEFAULT) failed with SQL error 1017:

C ORA-01017: invalid username/password; logon denied

C *** ERROR => CONNECT failed with sql error '1017'

[dbsloci.c 11239]

B RECONNECT: added code: 12500

B RECONNECT: added code: 12571

B ***LOG BY2=> sql error 1017 performing CON [dbsh#2 @ 1208] [dbsh 1208 ]

B ***LOG BY0=> ORA-01017: invalid username/password; logon denied [dbsh#2 @ 1208] [dbsh 1208 ]

B ***LOG BY2=> sql error 1017 performing CON [dblink#4 @ 433] [dblink 0433 ]

B ***LOG BY0=> ORA-01017: invalid username/password; logon denied [dblink#4 @ 433] [dblink 0433 ]

M ***LOG R19=> ThInit, db_connect ( DB-Connect 000256) [thxxhead.c 1505]

M in_ThErrHandle: 1

M *** ERROR => ThInit: db_connect (step 1, th_errno 13, action 3, level 1) [thxxhead.c 10651]

M

M Info for wp 0

M

M pid = 5888

M severity = 0

M status = 0

M stat = WP_RUN

M waiting_for = NO_WAITING

M reqtype = DP_RQ_DIAWP

M act_reqtype = NO_REQTYPE

M rq_info = 0

M tid = -1

M mode = 255

M len = -1

M rq_id = 65535

M rq_source =

M last_tid = 0

M last_mode = 0

M semaphore = 0

M act_cs_count = 0

M csTrack = 0

M csTrackRwExcl = 0

M csTrackRwShrd = 0

M mode_cleaned_counter = 0

M control_flag = 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 attachedVm = no VM

M

M *****************************************************************************

M *

M * LOCATION SAP-Server GEEPASPIQUA_GEP_02 on host GEEPASPIQUA (wp 0)

M * ERROR ThInit: db_connect

M *

M * TIME Wed Dec 07 15:51:39 2011

M * RELEASE 701

M * COMPONENT Taskhandler

M * VERSION 1

M * RC 13

M * MODULE thxxhead.c

M * LINE 10916

M * COUNTER 1

M *

M *****************************************************************************

M

M PfStatDisconnect: disconnect statistics

M Entering TH_CALLHOOKS

M ThCallHooks: call hook >BtcCallLgCl< for event BEFORE_DUMP

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 262]

M Entering ThSetStatError

M ThIErrHandle: do not call ThrCoreInfo (no_core_info=0, in_dynp_env=0)

M Entering ThReadDetachMode

M call ThrShutDown (1)...

M ***LOG Q02=> wp_halt, WPStop (Workproc 0 5888) [dpnttool.c 334]

[former_member189725 · Accepted solution]

Is GEP the production SID ?

Is the CI instance able to login to database ?

Also check if <sid>adm and sapservice<sid> is assigned the group dba and oper . Also login as sapservice<sid> and check the environment dbs_ora_schema and dbs_ora_tnsname are set to sapgep and GEP respectively.

Also make sure the sapservice<sid> user is not locked and the password maintained correctly in the SAP windows service.

Edited by: Ratnajit Dey on Dec 7, 2011 6:43 PM

[Former Member · Accepted solution]

Hello Pradeep,

It is an SAPGEP authentication problem. Please make sure SAPGEP is not locked and password works fine.

• ERROR => ORA-1403 when accessing table SAPUSER [dbsloci.c 11627] C Disconnecting from connection 0 ... C Closing user session (con_hdl=0,svchp=00000000041EA118,usrhp=00000000041F8530) C Now I'm disconnected from ORACLE C Try to connect with default password C Connecting as SAPGEP/@GEP on connection 0

SQL error 1017: C ORA-01017: invalid username/password; logon denied C *** ERROR => CONNECT failed with sql error '1017'

Please take a look at below thread for other possible reason for this failure.

Good Luck.

Thanks,

Siva Kumar

Edited by: Siva Kumar Arivinti on Dec 7, 2011 7:07 PM

[JPReyes · Accepted solution]

The user is not log just yet, but it will be if you don't fix the OPS$ users.

Check SAP Note 400241.

In anycase I can't find a reason for OPS$ users to be altered because of a DI installation...

Did you performed any other activity prior this error?

Is SAPGEP the right schema?

Regards

Juan

Edited by: Juan Reyes on Dec 7, 2011 3:04 PM

[former_member188883 · Accepted solution]

Hi,

Could you update the SAP kernel and then try to start dialog instance.

Many of the time updating the kernel helps in starting the dialog instance.

Hope this helps.

Regards,

Deepak Kori

[Former Member · Accepted solution]

Thanks everybody for the replies , i will try all the workarounds and will update the status.

Regards,

Pradeep