DB13 job failed

[Former Member]

Hi,

I have ERP 2005 DB server on HP-UX and ERP 2005 CI server on windows 2003. Problem is that db13 does't work. I get error: No application server found on database host - rsh/gateway will be used. rsh works on windows 2003 server, i can test a simple command for example:date on HP-UNIX DB server. I read a lot of topic of this forums and sap Notes, but i can't solve this problem. So, what is wrong in my systems.

[Former Member · Accepted solution]

you have two possibilities (if the standalone DB-Server is running on Unix):

1. use rsh

2. install a standalone SAP Gateway on the DATABASE SERVER! The CI has a gateway included, but this won't help you.

if using rsh keep in mind that the application servers on Windows are running under a user called SAPService<SAPSID>. There is no equivalent Unix user. To create one is also not trivial, because you have to configure the right environment, rights, Oracle operating system associated db user, etc. On some unixes it is also not possible to create him, because some are stil limited to a maximum of 8 character user names.

The best way should be to use the standalone gateway configuration.

regards

Peter

[Former Member · Accepted solution]

i installed SAP Gateway om DB server.

sm59 rfc test works, but then i execute db13 i get error

No application server found on database host - rsh/gateway will be used

Execute logical command BRCONNECT On host fvsdbcl

Parameters: -u / -jid CHECK20070123094049 -c -f check

Can't exec external program (No such file or directory)

External program terminated with exit code 1

BRCONNECT returned error status E

Job finished

[Former Member · Accepted solution]

Can't exec external program (No such file or directory)

External program terminated with exit code 1

....

brconnect.exe is not found / gateway does not have the right user/environment.

peter

[Former Member · Accepted solution]

Hi Peter,

user/environment such

i set

oracle_sid

oracle_home

o copied br* programs to /usr/sap/QGW/SYS/exe/run

and this is log from db13, i saw mistake, but i cant solve it

i created gateway user ops$qgwadm from sqlplus

i changed password for my gateway user, but ;(((((

invalid username/password; logon denied

BR0252E Function fopen() failed for '/oracle/QAS/102_64/sapcheck/cduliyko.chk' at location main-9

BR0253E errno 2: No such file or directory

BR0121E Processing of log file /oracle/QAS/102_64/sapcheck/cduliyko.chk failed

BR0280I BRCONNECT time stamp: 2007-01-23 15.24.50

BR0301E SQL error -1017 at location db_connect-2,SQL statement:

'CONNECT /'

ORA-01017: invalid username/password; logon denied

BR0310E Connect to database instance QAS failed

BR0806I End of BRCONNECT processing: cduliyko.chk2007-01-23 15.24.50

BR0280I BRCONNECT time stamp: 2007-01-23 15.24.50

BR0804I BRCONNECT terminated with errors

External program terminated with exit code 3

BRCONNECT returned error status E

Job finished

[Former Member · Accepted solution]

Hi,

You have to set all parameters as you had them in <sid>adm.

For example, the first error:

BR0252E Function fopen() failed for '/oracle/QAS/102_64/sapcheck/cduliyko.chk' at location main-9

BR0253E errno 2: No such file or directory

As SAPDATA_HOME is not set, BR* uses as default ORACLE_HOME and the directory

sapcheck does not exist there.

The second error indicate that you have not set up properly the OPS$ connection to the database and "CONNECT /" fails

[Former Member · Accepted solution]

Thanks for all

Now DB13 is working. Super !!!!

[Former Member · Accepted solution]

Hi Mindaugas,

What did you to to resolve the issue with CONNECT / ?

I'm having the exact same issue myself.

Thank you for your feedback.

Kind regards,

Tom.

[Former Member · Accepted solution]

Hello,

Please supply the SQL command to create OPS$ connection and please indicate which user was used

[manu_susankar]

Error Details ERROR: SAP gateway connection failed. Is SAP gateway started?

Have you checked the gateway? you can find from SMGW tcode....

Regards...

Manu.

[Former Member]

Gateway service is fine. it works on CI instance.

[Former Member]

Hi Mindaugas

as we discuss regarding gateway just check the oracle agent is install on CI

instance properly or not and cross check the oracle network file i.e. lisner.ora and

tnsname.ora

Cheers

Paresh

[Former Member]

Hi,Paresh,

CI instance is on windows 2003 server

DB instance is HP-UX

On CI instance isn't oracle agent. My question, how to install oracle agent on CI, that this agent could get oracle parameters from DB instance.

Mindaugas

[Former Member]

Hi Mindaugas,

Please go through the link below

[url=[http://help.sap.com/saphelp_erp2004/helpdata/en/29/571a417c4bf423e10000000a155106/frameset.htm[/url]

this will solve u r problem

Cheers

Paresh

[Former Member]

Hi,

First check the internal RFC connection are working or not

and if you send details log then we can check

Cheers

Paresh

[Former Member]

Hi ,Cheers Paresh,

DB host name is fvsdbcl

CI host name is FVSAPP03

sm59 RFC connection test

Logon Connection Error

Error Details Error when opening an RFC connection

Error Details ERROR: SAP gateway connection failed. Is SAP gateway started?

Error Details LOCATION: SAP-Server FVSAPP03_QAS_03 on host FVSAPP03 (wp 0)

Error Details COMPONENT: CPIC

Error Details COUNTER: 23

Error Details MODULE:

Error Details LINE:

Error Details RETURN CODE: 236

Error Details SUBRC: 0

Error Details RELEASE: 700

Error Details TIME: Thu Jan 11 16:45:54 2007

Error Details VERSION:

[Former Member]

Hi Mindaugas,

Please check the RFC connection is created between two system are not

If not created the rfc connection between two system from sm59

and then test it

Paresh

[Former Member]

RFC connection is created with name SAPXPG_DBDEST_FVSDBCL

but this connection is not working, adt log of this connection

Logon Connection Error

Error Details Error when opening an RFC connection

Error Details ERROR: SAP gateway connection failed. Is SAP gateway started?

Error Details LOCATION: SAP-Server FVSAPP03_QAS_03 on host FVSAPP03 (wp 0)

Error Details COMPONENT: CPIC

Error Details COUNTER: 24

Error Details MODULE:

Error Details LINE:

Error Details RETURN CODE: 236

Error Details SUBRC: 0

Error Details RELEASE: 700

Error Details TIME: Thu Jan 11 16:56:32 2007

Error Details VERSION:

[Former Member]

r u created the conection form both the side

[Former Member]

how create connection from DB instance, there no application server. On DB instance is installed only oracle database ?