After installing Dialog issues with BTC on DB server

[Former Member]

Strange thing happened.

I installed an extra application server (we had none) for our system but know the batch processes and update processes on the database server run into hold and error.

According to the log file due to TNS no listener

Database error 12541 at CON

> ORA-12541: TNS:no listener

Initialization DB-Connect Failed, Return Code 000256

But listener is running normally and also DB is up and running and able to access sqlplus

System is

HP-UX, Oracle 11.2.04, ECC EHP6 and kernel 7.21 EXT UC

All other processes are working fine

[Former Member · Accepted solution]

It has been solved.

What has been done is the following

Due to the fact we are using Oracle SSFS in our 11.2.4 I needed to add 2 profile parameters in the DI profile. After this connection worked and the DI could be started.

• Profile parameter : rsdb/ssfs_connect = 1
• Environment variable: rsdb_ssfs_connect 1

[Former Member]

Hi,

First check the DB connectivity on your CI using R3trans -dx, paste the error logs.

Regards,

Nick Loy

[Former Member]

Nick when on my CI and running R3trans -dx

R3trans -dx

This is R3trans version 6.24 (release 721 - 26.09.13 - 20:13:07 ).

unicode enabled version

R3trans finished (0000).

So all fine there. It only happens on my extra added dialog instance

[former_member188883]

Hi Christian,

Can you compare the environment variables for sidadm user on CI as well as Dialog instance.

Also have you installed Oracle client on dialog instance as well ?

Regards,

Deepak Kori

[Sriram2009]

Hi christian

Could you check this SAP Notes

131561 - Work processes sometimes abend during database connect

609332 - Composite note: ORA-12541/ORA-12224

BR

SS

[Reagan]

If the AS is running on a different host then make sure you have Oracle instant client installed.

How is the tnsnames.ora file present under TNS_ADMIN configured ?

Also make sure the Message Server entries are correctly maintained

Regards

RB

[Former Member]

Hi,

Stop SAP on your newly installed DI and restart, check whether it throws an error or not?

If it throws same error, then there must be some inconsistency in environment variables or Oracle client related issues.

Stop SAP on DI and check the database connectivity using R3trans -dx, start SAP and paste error lines from dev_w0 log file.

Regards,

Nick Loy

[Former Member]

Hi Deepak

On application server it doesn't work

But what I have done to resolve the issue with BTC and UPD processes for central instance is setting the tnsnames.ora and sqlnet.ora files like they are in the $ORACLE_HOME/11204/network/admin

After that the central instance is working again.

But now the application server is complaining when starting the

Database <SID> must be started first

Log on to remote server and start database

[former_member188883]

Hi Christian,

For Application server please check and share details on the points mentioned above

Additionally please check whether Oracle client has been installed on Application server .If not please do so and set relevant environment parameters like CI host.

Hope this helps.

Regards,

Deepak Kori

[former_member188883]

Hi Christian,

Please check the following

1) R3trans -d works from the newly installed dialog instance

2) Check the number of processes and sessions configured on oracle database. If it gets exhausted then connections may get lost

3) Check in profile directory of dialog instance whether tnsnames have proper db host maintained.

Hope his helps.

Regards,

Deepak Kori

[Former Member]

Hi Deepak

1) No R3trans -d givese issue on Application Server being:

4 ETW000  [

dev trc,00000]  ocica() -> SQL error code 1017,1017

28

0.269916

4 ETW000  [

dev trc,00000]

DbSlConnect(con=0) -> orc=1017, 99=DBSL_ERR_DB

30

0.269946

4 ETW000  [

dblink  ,00000]  ***LOG BY2=>sql error 1017   performing CON

3101

0.273047

4 ETW000  [

dblink  ,00000]  ***LOG BY0=>ORA-01017: invalid username/password; logon denied

34

0.273081

4 ETW000  [

dev trc,00000]  -->DbSlControl(con=-1,cmd=41=DBSL_CMD_RELINFO_GET)

908

0.273989

2) this is enough

3) was OK

But still when starting issue with the Log on to remote server and start database

[former_member188883]

Hi Christian,

LOG BY0=>ORA-01017: invalid username/password; logon 

1) Does R3trans -d works fine from CI host ?

2) Check and compare the environment parameters on CI and Application server host for sidadm & orasid users.

Hope this helps

Regards,

Deepak Kori