Max Db Error

[Former Member]

Hello,

I am getting this following error from my work directory log file as well trans.log file also.

4 ETW000 [dbsdbsql ,00000] *** ERROR => Connect to database failed, rc = -10709 (Connection failed (RTE:cannot create communication semaphore))

while connecting db through sql manager also the same error. Please help me

Because of this incosistency connection my JAVA is not working..

Os: Sunsolaris 10

Db: MAXDB 7.6.00 build 35.

Earlier it was working fine after i ran SGEN for my FICO related Transactions i am frequently getting error. My data base backup in the server only, No tapes also.

Please help me to sort out the error, if u know provide me the solution

Danke und Gruss

Sankar.G

[former_member229109]

Hello Sankar.G,

Please review the SAP note ::

628131 SAP DB / MaxDB operating system parameters on Unix

& check if the operating system parameters set as recommended in the note.

Thank you and best regards, Natalia Khlopina

[markus_doehr2]

Did you create an /etc/project file (according to note 724713 - parameter settings for Solaris 10)? /etc/system is no more valid on Solaris 10 to configure IPC parameters.

--

Markus

[Former Member]

Hallo Markus,

yes i set that in /etc/system only when the time of installation as well i followed as per the notes 724713

so please tell me what i do now?

Danke und Gruss,

Sankar.G

[markus_doehr2]

As this note states:

[...]

Please do not use any old /etc/system settings from SAP note 395438

with Solaris 10.

[...]

Please post the output of

cat /etc/project
cat /etc/user_attr

--

Markus

[Former Member]

Hello Markus,

Danke for your fast reply,

bash-3.00# cat /etc/project

system:0::::

user.root:1::::process.max-sem-nsems=(priv,2048,deny);project.max-sem-ids=(priv,1024,deny);project.max-shm-ids=(priv,256,deny);project.max-shm-memory=(priv,18446744073709551615,deny)

noproject:2::::

default:3::::

group.staff:10::::

bash-3.00# cat /etc/user_attr

#

1. Copyright (c) 2003 by Sun Microsystems, Inc. All rights reserved.

#

1. /etc/user_attr

#

1. user attributes. see user_attr(4)

#

#pragma ident "@(#)user_attr 1.1 03/07/09 SMI"

#

adm::::profiles=Log Management

lp::::profiles=Printer Management

root::::auths=solaris.*,solaris.grant;profiles=Web Console Management,All;lock_after_retries=no

Danke und Gruss

Sankar.G

[markus_doehr2]

What you did is wrong.

A SAP system is not running under user "root" and thus your settings do not apply to the users <sid>adm, sdb and sqd<SID>.

Additionally the syntax of you project file is not correct and no users are assigned in /etc/user_attr.

Please delete in /etc/project what you have entered after the fouth colon and follow the note to create a project.

--

Markus