Kbase 20821: Error 1136 Connecting to the Database
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
10/11/2010 |
|
Status: Verified
SYMPTOM(s):
Error connecting to a database at session startup.
Connection successful if logged in a root.
SYSTEM ERROR: Shared memory access permission denied (1136)
FACT(s) (Environment):
UNIX
CAUSE:
The error indicates the setuid bit is not set on the appropriate _* executables in the $DLC/bin directory. The PROMSGS description of the 1136 error is: "When running shared-memory multi-user PROGRESS, one of the processes was denied access to the shared memory. Make sure the PROGRESS modules were properly installed. _proserve, _progres, etc. must be owned by "root" and have permission bits "rwsrwxr-x".
FIX:
Make sure the correct executables under $DLC/bin have the setuid bit enabled.
Issue the following commands to set permissions:
chmod 755 $DLC/bin/*
chmod 4755 $DLC/bin/_dbutil
chmod 4755 $DLC/bin/_mprosrv
chmod 4755 $DLC/bin/_mprshut
chmod 4755 $DLC/bin/_ora7srv
chmod 4755 $DLC/bin/_proapsv
chmod 4755 $DLC/bin/_probrkr
chmod 4755 $DLC/bin/_probuild
chmod 4755 $DLC/bin/_progres
chmod 4755 $DLC/bin/_prooibk
chmod 4755 $DLC/bin/_prooidv
chmod 4755 $DLC/bin/_proutil
chmod 4755 $DLC/bin/_rfutil
chmod 4755 $DLC/bin/dbagent
chmod 4755 $DLC/bin/ora7rx
chmod 4755 $DLC/bin/prodebug
chmod 4755 $DLC/bin/prolib
chmod 4755 $DLC/bin/sqlcpp
In general, check the file permissions and owners to the Progress executables and to the database files.
Database files permissions should be -rw-rw---- . Restart the databases if permissions need to be changed.