cancel
Showing results for 
Search instead for 
Did you mean: 

Error: dbmcli -s db_enum --> executable program not accessible

0 Kudos

Hello,

I have 2 SAP DB Instances V 7.6.03.15 in a two node HP Serviceguard Cluster (HP-UX 11.31).

One one Node the dbmcli -s db_enum gives the Output:

$ /sapdb/programs/bin/dbmcli -s db_enum

OK

P02 /sapdb/P02/db 7.6.03.15 fast running

P02 /sapdb/P02/db 7.6.03.15 quick offline

P02 /sapdb/P02/db 7.6.03.15 slow offline

P02 /sapdb/P02/db 7.6.03.15 test offline

Q01 /sapdb/Q01/db 7.6.03.15 fast running

Q01 /sapdb/Q01/db 7.6.03.15 quick offline

Q01 /sapdb/Q01/db 7.6.03.15 slow offline

Q01 /sapdb/Q01/db 7.6.03.15 test offline

this ist OK;

but on the other Node i got the Error:

$ /sapdb/programs/bin/dbmcli -s db_enum

Error! Connection failed to node (local) for database (no dbname):

executable program not accessible

does anyone know what's wrong?

thanks Hans-Peter

Accepted Solutions (0)

Answers (2)

Answers (2)

markus_doehr2
Active Contributor
0 Kudos

Try

dbmcli db_enum

the "-s" means - "connect locally" - if there´s no local database running because it´s running on the other node, it can´t work.

Markus

0 Kudos

Hi Markus,

thats right, but I run the DB "P02" on the "Node 2" before,

an the error also occurs with "dbmcli -s db_enum";

just no there are running "P02" and "Q01" on the "Node 1"

here is the: output from "dbmcli db_enum"

from Node 1:

$ /sapdb/programs/bin/dbmcli db_enum

OK

P02 /sapdb/P02/db 7.6.03.15 fast running

P02 /sapdb/P02/db 7.6.03.15 quick offline

P02 /sapdb/P02/db 7.6.03.15 slow offline

P02 /sapdb/P02/db 7.6.03.15 test offline

Q01 /sapdb/Q01/db 7.6.03.15 fast running

Q01 /sapdb/Q01/db 7.6.03.15 quick offline

Q01 /sapdb/Q01/db 7.6.03.15 slow offline

Q01 /sapdb/Q01/db 7.6.03.15 test offline

from Node 2:

$ /sapdb/programs/bin/dbmcli db_enum

Error! Connection failed to node (local) for database (no dbname):

no installation found

Hans-Peter

markus_doehr2
Active Contributor
0 Kudos

Ok.

Are the files

/etc/opt/sdb

and the directory

/usr/spool/sql

also available on the second node?

See note 803452 - MaxDB directories in UNIX clusters for failover

Markus

0 Kudos

Yes,

the File: /etc/opt/sdb ist the same on both Nodes;

and the Directory:

/usr/spool/sql/ini is located on the NFS Server;

and all the the links shows to the Dirs. located also on the NFS Server;

$ ll /usr/spool/sql/

total 0

lrwxrwxr-x 1 sdb sdba 19 Apr 4 08:42 dbspeed -> /sapdb/data/dbspeed

lrwxrwxr-x 1 sdb sdba 16 Apr 4 08:42 diag -> /sapdb/data/diag

lrwxrwxr-x 1 sdb sdba 16 Apr 4 08:42 fifo -> /sapdb/data/fifo

drwxrwxr-x 3 sdb sdba 96 Apr 8 12:39 ini

lrwxrwxr-x 1 sdb sdba 15 Apr 4 08:42 ipc -> /sapdb/data/ipc

lrwxrwxr-x 1 sdb sdba 15 Apr 4 08:42 pid -> /sapdb/data/pid

lrwxrwxr-x 1 sdb sdba 16 Apr 4 08:42 pipe -> /sapdb/data/pipe

lrwxrwxr-x 1 sdb sdba 16 Apr 4 08:42 ppid -> /sapdb/data/ppid

the NFS Filesystems ist mounted via AUTOFS:

$ cat /etc/auto_direct

/usr/sap/trans snfsp:/export/usr/sap/trans

/sapmnt/D00 sapd00:/export/sapmnt/D00

/sapmnt/P02 sapp02:/export/sapmnt/P02

/sapmnt/Q01 sapq01:/export/sapmnt/Q01

/sapdb/programs sapnfs:/export/sapdb/programs

/sapdb/data sapnfs:/export/sapdb/data

/var/spool/sql/ini sapnfs:/export/var/spool/sql/ini

and there is as link from /usr/spool to /var/spool on both nodes;

Hans-Peter

markus_doehr2
Active Contributor
0 Kudos

Ok.. then the only thing I can imagine is the fact, that the dbmcli call is trying to execute a program (e. g. dbmsrv) which is has no permission to.

If you have tusc installed you could do a

tusc -afpo dbmcli.log dbmcli -s db_enum

and then have a look in dbmcli.log where you get an EACCESS.

Markus

former_member229109
Active Contributor
0 Kudos

Hello Hans-Peter,

You have installed the database software version 7.6.03.15.

Until version 7.4.3, the /usr/spool/sql directory is used. SAP instances that run with a newer database version may also need the clients of the older versions, so that /usr/spool/sql is also used as well.

But as of database version 7.5 the database register files are written to the directory /sapdb/data/config. When the database will be created the /sapdb/data/config/Databases.ini file will be updated & you will see

The created database in the output of the command 'dbmcli -s db_enum'.

Is /sapdb/data/config shared beetween node 1 & node 2?

See SAP note for more details::

803452 - MaxDB directories in UNIX clusters for failover

Thank you and best regards, Natalia Khlopina

0 Kudos

Hi Markus,

I switched the DB "P02" to the Node 2 and as user sdb I run:

$ /usr/local/bin/tusc -afpo dbmcli.log /sapdb/programs/bin/dbmcli -s db_enum

Error! Connection failed to node (local) for database (no dbname):

executable program not accessible

here is the content of the dbmcli.log:

[27357] execve(0x9ffffffffffff93d, 0x9ffffffffffff888, 0x9ffffffffffff8a8) [entry]

argv[0] @ 0x9ffffffffffff93d: "/sapdb/programs/bin/dbmcli"

argv[1] @ 0x9ffffffffffff958: "-s"

argv[2] @ 0x9ffffffffffff95b: "db_enum"

[27357] execve("/sapdb/programs/bin/dbmcli", 0x9ffffffffffff888, 0x9ffffffffffff8a8) = 0 [64-bit]

[27357] mmap(NULL, 8192, PROT_READ|PROT_WRITE|PROT_EXEC, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0) = 0x9fffffffbf7fc000

[27357] open("/usr/lib/hpux64/dld.so", O_RDONLY|0x800, 0) = 4

[27357] read(4, "7fE L F 0202010101\0\0\0\0\0\0\0".., 1024) = 1024

[27357] mmap(NULL, 586672, PROT_READ|PROT_EXEC, MAP_SHARED|MAP_FILE|MAP_SHLIB, 4, 0) = 0xc000000000014000

[27357] sysconf(_SC_PAGE_SIZE) ........................... = 4096

[27357] mmap(NULL, 6272, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS|MAP_SHLIB, -1, 0) = 0x9fffffffbf7fa000

[27357] mmap(0x9fffffffbf7f6000, 14664, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FILE|MAP_SHLIB, 4, 589824) = 0x9fffffffbf7f6000

[27357] close(4) ......................................... = 0

[27357] mmap(NULL, 8192, PROT_READ|PROT_WRITE|PROT_EXEC, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0) = 0x9fffffffbf7f4000

[27357] sysconf(_SC_PAGE_SIZE) ........................... = 4096

[27357] stat("/usr/lib/hpux64/dpd", 0x9ffffffffffff3e0) .. = 0

[27357] open("/usr/lib/hpux64/dpd", O_RDONLY|0x800, 0) ... = 4

[27357] fcntl(4, F_SETFD, 1) ............................. = 0

[27357] mmap(NULL, 16384, PROT_READ|PROT_WRITE|PROT_EXEC, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0) = 0x9fffffffbf7f0000

[27357] getdents(4, 0x9fffffffbf7f0048, 8192) ............ = 88

[27357] getdents(4, 0x9fffffffbf7f0048, 8192) ............ = 0

[27357] close(4) ......................................... = 0

[27357] getuid() ......................................... = 3000 (3000)

[27357] getgid() ......................................... = 200 (200)

[27357] open("/sapdb/programs/bin/dbmcli", O_RDONLY|0x800, 0) = 4

[27357] pread(4, "\0\0\0\0\0\0\002\0\0\0\0\0\0\0X ".., 120, 680) = 120

[27357] close(4) ......................................... = 0

[27357] utssys(0x9fffffffffffefe0, 0, 0) ................. = 0

[27357] procxsec(4, -1, 0x9fffffffffffefb0, 40) .......... = 0

[27357] mmap(NULL, 90112, PROT_READ|PROT_WRITE|PROT_EXEC, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0) = 0x9fffffffbf7d0000

[27357] open("/opt/aCC/lib/hpux64/libsec.so.1", O_RDONLY|0x800, 0) ERR#2 ENOENT

[27357] open("/devtool/_tools//7600/tool/lib/libsec.so.1", O_RDONLY|0x800, 0) ERR#2 ENOENT

[27357] open("/SAP_DB/76_REL/hpia64/genopt/usr/lib/libsec.so.1", O_RDONLY|0x800, 0) ERR#2 ENOENT

[27357] open("/usr/lib/hpux64/libsec.so.1", O_RDONLY|0x800, 0) = 4

[27357] fstat(4, 0x9ffffffffffff2c0) ..................... = 0

[27357] read(4, "7fE L F 0202010101\0\0\0\0\0\0\0".., 64) = 64

[27357] pread(4, "7fE L F 0202010101\0\0\0\0\0\0\0".., 1024, 0) = 1024

[27357] mmap(NULL, 312656, PROT_READ|PROT_EXEC, MAP_SHARED|MAP_SHLIB, 4, 0) = 0xc000000000ccc000

[27357] mmap(NULL, 28856, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS|MAP_SHLIB, -1, 0) = 0x9fffffffbf7e8000

[27357] mmap(0x9fffffffbf7e4000, 14632, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_SHLIB, 4, 327680) = 0x9fffffffbf7cc000

[27357] munmap(0x9fffffffbf7cc000, 14632) ................ = 0

[27357] munmap(0x9fffffffbf7e8000, 28856) ................ = 0

[27357] mmap(NULL, 45240, PROT_READ, MAP_PRIVATE|MAP_ANONYMOUS|MAP_SHLIB, -1, 0) = 0x9fffffffbf7c4000

[27357] munmap(0x9fffffffbf7c4000, 45240) ................ = 0

[27357] mmap(0x9fffffffbf7c8000, 28856, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED|MAP_ANONYMOUS|MAP_SHLIB, -1, 0) = 0x9fffffffbf7c8000

[27357] mmap(0x9fffffffbf7c4000, 14632, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED|MAP_SHLIB, 4, 327680) = 0x9fffffffbf7c4000

[27357] close(4) ......................................... = 0

[27357] open("/opt/aCC/lib/hpux64/libxcurses.so.1", O_RDONLY|0x800, 0) ERR#2 ENOENT

[27357] open("/devtool/_tools//7600/tool/lib/libxcurses.so.1", O_RDONLY|0x800, 0) ERR#2 ENOENT

[27357] open("/SAP_DB/76_REL/hpia64/genopt/usr/lib/libxcurses.so.1", O_RDONLY|0x800, 0) ERR#2 ENOENT

[27357] open("/usr/lib/hpux64/libxcurses.so.1", O_RDONLY|0x800, 0) = 4

[27357] fstat(4, 0x9ffffffffffff2c0) ..................... = 0

[27357] read(4, "7fE L F 0202010101\0\0\0\0\0\0\0".., 64) = 64

[27357] pread(4, "7fE L F 0202010101\0\0\0\0\0\0\0".., 1024, 0) = 1024

[27357] mmap(NULL, 560144, PROT_READ|PROT_EXEC, MAP_SHARED|MAP_SHLIB, 4, 0) = 0xc0000000074e4000

[27357] mmap(NULL, 6792, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS|MAP_SHLIB, -1, 0) = 0x9fffffffbf7ee000

[27357] mmap(0x9fffffffbf7e4000, 37187, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_SHLIB, 4, 589824) = 0x9fffffffbf7b8000

[27357] munmap(0x9fffffffbf7b8000, 37187) ................ = 0

[27357] munmap(0x9fffffffbf7ee000, 6792) ................. = 0

[27357] mmap(NULL, 47752, PROT_READ, MAP_PRIVATE|MAP_ANONYMOUS|MAP_SHLIB, -1, 0) = 0x9fffffffbf7b8000

[27357] munmap(0x9fffffffbf7b8000, 47752) ................ = 0

[27357] mmap(0x9fffffffbf7c2000, 6792, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED|MAP_ANONYMOUS|MAP_SHLIB, -1, 0) = 0x9fffffffbf7c2000

[27357] mmap(0x9fffffffbf7b8000, 37187, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED|MAP_SHLIB, 4, 589824) = 0x9fffffffbf7b8000

[27357] close(4) ......................................... = 0

[27357] open("/opt/aCC/lib/hpux64/libm.so.1", O_RDONLY|0x800, 0) ERR#2 ENOENT

[27357] open("/devtool/_tools//7600/tool/lib/libm.so.1", O_RDONLY|0x800, 0) ERR#2 ENOENT

[27357] open("/SAP_DB/76_REL/hpia64/genopt/usr/lib/libm.so.1", O_RDONLY|0x800, 0) ERR#2 ENOENT

[27357] open("/usr/lib/hpux64/libm.so.1", O_RDONLY|0x800, 0) = 4

[27357] fstat(4, 0x9ffffffffffff2c0) ..................... = 0

[27357] read(4, "7fE L F 0202010101\0\0\0\0\0\0\0".., 64) = 64

[27357] pread(4, "7fE L F 0202010101\0\0\0\0\0\0\0".., 1024, 0) = 1024

[27357] mmap(NULL, 1416416, PROT_READ|PROT_EXEC, MAP_SHARED|MAP_SHLIB, 4, 0) = 0xc000000000708000

[27357] mmap(NULL, 3180, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_SHLIB, 4, 1441792) = 0x9fffffffbf7ef000

[27357] close(4) ......................................... = 0

[27357] mmap(NULL, 16384, PROT_READ|PROT_WRITE|PROT_EXEC, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0) = 0x9fffffffbf7e8000

[27357] open("/opt/aCC/lib/hpux64/libpthread.so.1", O_RDONLY|0x800, 0) ERR#2 ENOENT

[27357] open("/devtool/_tools//7600/tool/lib/libpthread.so.1", O_RDONLY|0x800, 0) ERR#2 ENOENT

[27357] open("/SAP_DB/76_REL/hpia64/genopt/usr/lib/libpthread.so.1", O_RDONLY|0x800, 0) ERR#2 ENOENT

[27357] open("/usr/lib/hpux64/libpthread.so.1", O_RDONLY|0x800, 0) = 4

[27357] fstat(4, 0x9ffffffffffff2c0) ..................... = 0

[27357] read(4, "7fE L F 0202010101\0\0\0\0\0\0\0".., 64) = 64

[27357] pread(4, "7fE L F 0202010101\0\0\0\0\0\0\0".., 1024, 0) = 1024

[27357] mmap(NULL, 1094656, PROT_READ|PROT_EXEC, MAP_SHARED|MAP_SHLIB, 4, 0) = 0xc0000000000a4000

[27357] mmap(NULL, 13936, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_SHLIB, 4, 1114112) = 0x9fffffffbf7b4000

[27357] close(4) ......................................... = 0

[27357] open("/opt/aCC/lib/hpux64/libstd_v2.so.1", O_RDONLY|0x800, 0) ERR#2 ENOENT

[27357] open("/devtool/_tools//7600/tool/lib/libstd_v2.so.1", O_RDONLY|0x800, 0) ERR#2 ENOENT

[27357] open("/SAP_DB/76_REL/hpia64/genopt/usr/lib/libstd_v2.so.1", O_RDONLY|0x800, 0) ERR#2 ENOENT

[27357] open("/usr/lib/hpux64/libstd_v2.so.1", O_RDONLY|0x800, 0) = 4

[27357] fstat(4, 0x9ffffffffffff2c0) ..................... = 0

[27357] read(4, "7fE L F 0202010101\0\0\0\0\0\0\0".., 64) = 64

[27357] pread(4, "7fE L F 0202010101\0\0\0\0\0\0\0".., 1024, 0) = 1024

[27357] mmap(NULL, 1749584, PROT_READ|PROT_EXEC, MAP_SHARED|MAP_SHLIB, 4, 0) = 0xc000000000500000

[27357] mmap(NULL, 13720, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS|MAP_SHLIB, -1, 0) = 0x9fffffffbf7b0000

[27357] mmap(0x9fffffffbf7a4000, 47984, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_SHLIB, 4, 1769472) = 0x9fffffffbf7a4000

[27357] close(4) ......................................... = 0

[27357] mmap(NULL, 24576, PROT_READ|PROT_WRITE|PROT_EXEC, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0) = 0x9fffffffbf79c000

[27357] open("/opt/aCC/lib/hpux64/libCsup.so.1", O_RDONLY|0x800, 0) ERR#2 ENOENT

[27357] open("/devtool/_tools//7600/tool/lib/libCsup.so.1", O_RDONLY|0x800, 0) ERR#2 ENOENT

[27357] open("/SAP_DB/76_REL/hpia64/genopt/usr/lib/libCsup.so.1", O_RDONLY|0x800, 0) ERR#2 ENOENT

[27357] open("/usr/lib/hpux64/libCsup.so.1", O_RDONLY|0x800, 0) = 4

[27357] fstat(4, 0x9ffffffffffff2c0) ..................... = 0

[27357] read(4, "7fE L F 0202010101\0\0\0\0\0\0\0".., 64) = 64

[27357] pread(4, "7fE L F 0202010101\0\0\0\0\0\0\0".., 1024, 0) = 1024

[27357] mmap(NULL, 361632, PROT_READ|PROT_EXEC, MAP_SHARED|MAP_SHLIB, 4, 0) = 0xc0000000006ac000

[27357] mmap(NULL, 25936, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_SHLIB, 4, 393216) = 0x9fffffffbf794000

[27357] close(4) ......................................... = 0

[27357] open("/opt/aCC/lib/hpux64/libunwind.so.1", O_RDONLY|0x800, 0) ERR#2 ENOENT

[27357] open("/devtool/_tools//7600/tool/lib/libunwind.so.1", O_RDONLY|0x800, 0) ERR#2 ENOENT

[27357] open("/SAP_DB/76_REL/hpia64/genopt/usr/lib/libunwind.so.1", O_RDONLY|0x800, 0) ERR#2 ENOENT

[27357] open("/usr/lib/hpux64/libunwind.so.1", O_RDONLY|0x800, 0) = 4

[27357] fstat(4, 0x9ffffffffffff2c0) ..................... = 0

[27357] read(4, "7fE L F 0202010101\0\0\0\0\0\0\0".., 64) = 64

[27357] pread(4, "7fE L F 0202010101\0\0\0\0\0\0\0".., 1024, 0) = 1024

[27357] mmap(NULL, 308080, PROT_READ|PROT_EXEC, MAP_SHARED|MAP_SHLIB, 4, 0) = 0xc000000000864000

[27357] mmap(NULL, 1543, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_SHLIB, 4, 327680) = 0x9fffffffbf7ee000

[27357] close(4) ......................................... = 0

[27357] open("/opt/aCC/lib/hpux64/libc.so.1", O_RDONLY|0x800, 0) ERR#2 ENOENT

[27357] open("/devtool/_tools//7600/tool/lib/libc.so.1", O_RDONLY|0x800, 0) ERR#2 ENOENT

[27357] open("/SAP_DB/76_REL/hpia64/genopt/usr/lib/libc.so.1", O_RDONLY|0x800, 0) ERR#2 ENOENT

[27357] open("/usr/lib/hpux64/libc.so.1", O_RDONLY|0x800, 0) = 4

[27357] fstat(4, 0x9ffffffffffff2c0) ..................... = 0

[27357] read(4, "7fE L F 0202010101\0\0\0\0\0\0\0".., 64) = 64

[27357] pread(4, "7fE L F 0202010101\0\0\0\0\0\0\0".., 1024, 0) = 1024

[27357] mmap(NULL, 2741472, PROT_READ|PROT_EXEC, MAP_SHARED|MAP_SHLIB, 4, 0) = 0xc000000000200000

[27357] madvise(0xc000000000200000, 0x29d4e0, 0x1a) ...... = 0

[27357] mmap(NULL, 47704, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS|MAP_SHLIB, -1, 0) = 0x9fffffffbf788000

[27357] mmap(0x9fffffffbf77f000, 34760, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_SHLIB, 4, 2752512) = 0x9fffffffbf77f000

[27357] close(4) ......................................... = 0

[27357] mmap(NULL, 16384, PROT_READ|PROT_WRITE|PROT_EXEC, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0) = 0x9fffffffbf778000

[27357] open("/opt/aCC/lib/hpux64/libdl.so.1", O_RDONLY|0x800, 0) ERR#2 ENOENT

[27357] open("/devtool/_tools//7600/tool/lib/libdl.so.1", O_RDONLY|0x800, 0) ERR#2 ENOENT

[27357] open("/SAP_DB/76_REL/hpia64/genopt/usr/lib/libdl.so.1", O_RDONLY|0x800, 0) ERR#2 ENOENT

[27357] open("/usr/lib/hpux64/libdl.so.1", O_RDONLY|0x800, 0) = 4

[27357] fstat(4, 0x9ffffffffffff2c0) ..................... = 0

[27357] read(4, "7fE L F 0202010101\0\0\0\0\0\0\0".., 64) = 64

[27357] pread(4, "7fE L F 0202010101\0\0\0\0\0\0\0".., 1024, 0) = 1024

[27357] mmap(NULL, 17616, PROT_READ|PROT_EXEC, MAP_SHARED|MAP_SHLIB, 4, 0) = 0xc0000000001b0000

[27357] mmap(NULL, 232, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_SHLIB, 4, 65536) = 0x9fffffffbf7ed000

[27357] close(4) ......................................... = 0

[27357] mmap(NULL, 8192, PROT_READ|PROT_WRITE|PROT_EXEC, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0) = 0x9fffffffbf7e6000

[27357] open("/usr/lib/hpux64/libm.so.1", O_RDONLY|0x800, 0) = 4

[27357] fstat(4, 0x9ffffffffffff2c0) ..................... = 0

[27357] read(4, "7fE L F 0202010101\0\0\0\0\0\0\0".., 64) = 64

[27357] close(4) ......................................... = 0

[27357] open("/usr/lib/hpux64/libuca.so.1", O_RDONLY|0x800, 0) = 4

[27357] fstat(4, 0x9ffffffffffff2c0) ..................... = 0

[27357] read(4, "7fE L F 0202010101\0\0\0\0\0\0\0".., 64) = 64

[27357] pread(4, "7fE L F 0202010101\0\0\0\0\0\0\0".., 1024, 0) = 1024

[27357] mmap(NULL, 32800, PROT_READ|PROT_EXEC, MAP_SHARED|MAP_SHLIB, 4, 0) = 0xc0000000001ec000

[27357] mmap(NULL, 312, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_SHLIB, 4, 65536) = 0x9fffffffbf7ec000

[27357] close(4) ......................................... = 0

[27357] mmap(NULL, 8192, PROT_READ|PROT_WRITE|PROT_EXEC, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0) = 0x9fffffffbf7a2000

[27357] mmap(NULL, 8192, PROT_READ|PROT_WRITE|PROT_EXEC, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0) = 0x9fffffffbf77c000

[27357] mmap(NULL, 8192, PROT_READ|PROT_WRITE|PROT_EXEC, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0) = 0x9fffffffbf776000

[27357] mmap(NULL, 8192, PROT_READ|PROT_WRITE|PROT_EXEC, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0) = 0x9fffffffbf774000

[27357] sigsetreturn(NULL, 0x6211988, 48640) ............. = 0

[27357] getpid() ......................................... = 27357 (27356)

[27357] sysconf(_SC_THREAD_THREADS_MAX) .................. = 3000

[27357] sysconf(_SC_THREAD_KEYS_MAX) ..................... = 256

[27357] mmap(NULL, 13664, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0) = 0x9fffffffbf770000

[27357] sysconf(_SC_THREAD_STACK_MIN) .................... = 4096

[27357] mpctl(MPC_GETNUMSPUS, 0, 0) ...................... = 2

[27357] mpctl(MPC_GETNUMLDOMS, 0, 0) ..................... = 1

[27357] pstat(PSTAT_DYNAMIC, 0x9fffffffffffe030, 5112, 1, 0) = 1

[27357] sysconf(0x4c2e) .................................. = 1

[27357] pset_ctl(PSET_GETCURRENTPSET, 0, 0) .............. = 0

[27357] mpctl(MPC_GETPROCESS_BINDVALUE, 0, 27357) ........ = 104

[27357] sched_get_priority_max(SCHED_HPUX) ............... = -129

[27357] sched_get_priority_min(SCHED_HPUX) ............... = -256

[27357] pset_ctl(PSET_GETCURRENTPSET, 0, 0) .............. = 0

[27357] sysconf(_SC_GANG_SCHED) .......................... = 1

[27357] lwp_self() ....................................... = 2100644

[27357] lwp_self() ....................................... = 2100644

[27357] sysconf(_SC_PAGE_SIZE) ........................... = 4096

[27357] sysconf(_SC_CCNUMA_PM) ........................... = 1

[27357] mpctl(MPC_GETLWP_BINDVALUE, 0, -4) ............... = 104

[27357] mpctl(MPC_SETLWP, -7, -4) ........................ = -6

[27357] lwp_getscheduler(LWP_SCHED_SPECIFIC, 2100644, 0x9fffffffbf771288, 0x9fffffffbf77128c) = 0

[27357] sigprocmask(SIG_BLOCK, NULL, 0x9fffffffbf771158) . = 0

[27357] sysconf(_SC_CPU_VERSION) ......................... = 768

[27357] brk(0x600000000014cc70) .......................... = 0

[27357] brk(0x6000000000150c40) .......................... = 0

[27357] brk(0x6000000000160000) .......................... = 0

[27357] sched_get_priority_min(SCHED_HPUX) ............... = -256

[27357] sched_get_priority_max(SCHED_RTPRIO) ............. = -1

[27357] sched_get_priority_min(SCHED_RTPRIO) ............. = -128

[27357] sched_get_priority_max(SCHED_HPUX) ............... = -129

[27357] sched_get_priority_min(SCHED_HPUX) ............... = -256

[27357] brk(0x6000000000180000) .......................... = 0

[27357] sched_get_priority_min(SCHED_HPUX) ............... = -256

[27357] sched_get_priority_max(SCHED_HPUX) ............... = -129

[27357] set_userthreadid(1) .............................. = 1

[27357] getpid() ......................................... = 27357 (27356)

[27357] open("/dev/null", O_RDWR|0x800, 0) ............... = 4

[27357] close(4) ......................................... = 0

[27357] getuid() ......................................... = 3000 (3000)

[27357] open("/var/spool/pwgr/status", O_RDONLY|0x800, 0) = 4

[27357] mmap(NULL, 532, PROT_READ, MAP_SHARED|MAP_VARIABLE|MAP_FILE|MAP_ADDR32, 4, 0) = 0xc0001000

[27357] close(4) ......................................... = 0

[27357] socket(AF_UNIX, SOCK_DGRAM, 0) ................... = 4

[27357] getpid() ......................................... = 27357 (27356)

[27357] unlink("/var/spool/sockets/pwgr/client27357") .... ERR#2 ENOENT

[27357] bind(4, 0x9fffffffbf7892f0, 38) .................. = 0

[27357] fcntl(4, F_SETFD, 1) ............................. = 0

[27357] time(NULL) ....................................... = 1212131134

[27357] stat("/etc/default/lugname", 0x9fffffffffffcca0) . ERR#2 ENOENT

[27357] poll(0x9fffffffffffdb58, 1, 0) ................... = 1

[27357] sendto(4, "\0\0\00 \0\0\001\0\0\0\0\0\0\001".., 48, 0, 0x9fffffffbf789350, 0x19) = 48

[27357] poll(0x9fffffffffffdb58, 1, 1000) ................ = 1

[27357] recvfrom(4, "\0\0\0G \0\0\0\0\0\0\0\0\0\0\07 ".., 2064, 0, 0x9fffffffffffdc00, 0x9fffffffffffdb54) = 71

[27357] open("/dev/random", O_RDONLY|0x800|O_NONBLOCK, 0) = 5

[27357] read(5, "\ab087\ g 99c0d6@ 8183L @ \r; b7".., 20) = 20

[27357] getpid() ......................................... = 27357 (27356)

[27357] getuid() ......................................... = 3000 (3000)

[27357] time(NULL) ....................................... = 1212131134

[27357] gettimeofday(0x9ffffffffffff130, 0x9ffffffffffff120) = 0

[27357] pstat(PSTAT_DYNAMIC, 0x9fffffffffffc410, 5096, 0, 0) = 1

[27357] pstat(PSTAT_STATIC, 0x9fffffffffffd500, 736, 0, 0) = 1

[27357] getpid() ......................................... = 27357 (27356)

[27357] utssys(0x9fffffffffffddc0, 0, 0) ................. = 0

[27357] open("/etc/opt/sdb", O_RDONLY|0x800, 01) ......... = 6

[27357] read(6, "[ ", 1) ................................. = 1

[27357] read(6, "G ", 1) ................................. = 1

[27357] read(6, "l ", 1) ................................. = 1

[27357] read(6, "o ", 1) ................................. = 1

[27357] read(6, "b ", 1) ................................. = 1

[27357] read(6, "a ", 1) ................................. = 1

[27357] read(6, "l ", 1) ................................. = 1

[27357] read(6, "s ", 1) ................................. = 1

[27357] read(6, "] ", 1) ................................. = 1

[27357] read(6, "\n", 1) ................................. = 1

[27357] read(6, "I ", 1) ................................. = 1

[27357] read(6, "n ", 1) ................................. = 1

[27357] read(6, "d ", 1) ................................. = 1

[27357] read(6, "e ", 1) ................................. = 1

[27357] read(6, "p ", 1) ................................. = 1

[27357] read(6, "D ", 1) ................................. = 1

[27357] read(6, "a ", 1) ................................. = 1

[27357] read(6, "t ", 1) ................................. = 1

[27357] read(6, "a ", 1) ................................. = 1

[27357] read(6, "= ", 1) ................................. = 1

[27357] read(6, "/ ", 1) ................................. = 1

[27357] read(6, "s ", 1) ................................. = 1

[27357] read(6, "a ", 1) ................................. = 1

[27357] read(6, "p ", 1) ................................. = 1

[27357] read(6, "d ", 1) ................................. = 1

[27357] read(6, "b ", 1) ................................. = 1

[27357] read(6, "/ ", 1) ................................. = 1

[27357] read(6, "d ", 1) ................................. = 1

[27357] read(6, "a ", 1) ................................. = 1

[27357] read(6, "t ", 1) ................................. = 1

[27357] read(6, "a ", 1) ................................. = 1

[27357] read(6, "\n", 1) ................................. = 1

[27357] close(6) ......................................... = 0

[27357] getpid() ......................................... = 27357 (27356)

[27357] utssys(0x9fffffffffffdea0, 0, 0) ................. = 0

[27357] open("/sapdb/data/config/Installations.ini", O_RDONLY|0x800, 01) = 6

[27357] read(6, "[ ", 1) ................................. = 1

[27357] read(6, "I ", 1) ................................. = 1

[27357] read(6, "n ", 1) ................................. = 1

[27357] read(6, "s ", 1) ................................. = 1

[27357] read(6, "t ", 1) ................................. = 1

[27357] read(6, "a ", 1) ................................. = 1

[27357] read(6, "l ", 1) ................................. = 1

[27357] read(6, "l ", 1) ................................. = 1

[27357] read(6, "a ", 1) ................................. = 1

[27357] read(6, "t ", 1) ................................. = 1

[27357] read(6, "i ", 1) ................................. = 1

[27357] read(6, "o ", 1) ................................. = 1

[27357] read(6, "n ", 1) ................................. = 1

[27357] read(6, "s ", 1) ................................. = 1

[27357] read(6, "] ", 1) ................................. = 1

[27357] read(6, "\n", 1) ................................. = 1

[27357] lseek(6, 0, SEEK_CUR) ............................ = 16

[27357] lseek(6, 0, SEEK_END) ............................ = 90

[27357] lseek(6, 16, SEEK_SET) ........................... = 16

[27357] read(6, "/ s a p d b / P 0 2 / d b = 7 . ".., 75) = 74

[27357] read(6, 0x6000000000166dda, 1) ................... = 0

[27357] close(6) ......................................... = 0

[27357] stat("/sapdb/P02/db/pgm/kernel", 0x9fffffffffffe240) = 0

[27357] mmap(0x8000020000000000, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS|0x200000, -1, 0) = 0x8000020000000000

[27357] mmap(0x8000020000001000, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS|0x200000, -1, 0) = 0x8000020000001000

[27357] mmap(0x8000020000002000, 1048576, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS|0x200000, -1, 0) = 0x8000020000002000

[27357] mmap(0x8000020000102000, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS|0x200000, -1, 0) = 0x8000020000102000

[27357] stat("/sapdb/P02/db/pgm/quickknl", 0x9fffffffffffe2e0) ERR#2 ENOENT

[27357] stat("/sapdb/P02/db/pgm/slowknl", 0x9fffffffffffe380) = 0

[27357] stat("/sapdb/P02/db/pgm/omststknl", 0x9fffffffffffe420) ERR#2 ENOENT

[27357] stat("/sapdb/Q01/db/pgm/kernel", 0x9fffffffffffe240) ERR#2 ENOENT

[27357] stat("/sapdb/Q01/db/pgm/quickknl", 0x9fffffffffffe2e0) ERR#2 ENOENT

[27357] stat("/sapdb/Q01/db/pgm/slowknl", 0x9fffffffffffe380) ERR#2 ENOENT

[27357] stat("/sapdb/Q01/db/pgm/omststknl", 0x9fffffffffffe420) ERR#2 ENOENT

[27357] getpid() ......................................... = 27357 (27356)

[27357] utssys(0x9fffffffffffdea0, 0, 0) ................. = 0

[27357] open("/usr/spool/sql/ini/SAP_DBTech.ini", O_RDONLY|0x800, 01) = 6

[27357] read(6, "[ ", 1) ................................. = 1

[27357] read(6, "G ", 1) ................................. = 1

[27357] read(6, "l ", 1) ................................. = 1

[27357] read(6, "o ", 1) ................................. = 1

[27357] read(6, "b ", 1) ................................. = 1

[27357] read(6, "a ", 1) ................................. = 1

[27357] read(6, "l ", 1) ................................. = 1

[27357] read(6, "s ", 1) ................................. = 1

[27357] read(6, "] ", 1) ................................. = 1

[27357] read(6, "\n", 1) ................................. = 1

[27357] read(6, "I ", 1) ................................. = 1

[27357] read(6, "n ", 1) ................................. = 1

[27357] read(6, "d ", 1) ................................. = 1

[27357] read(6, "e ", 1) ................................. = 1

[27357] read(6, "p ", 1) ................................. = 1

[27357] read(6, "D ", 1) ................................. = 1

[27357] read(6, "a ", 1) ................................. = 1

[27357] read(6, "t ", 1) ................................. = 1

[27357] read(6, "a ", 1) ................................. = 1

[27357] read(6, "= ", 1) ................................. = 1

[27357] read(6, "/ ", 1) ................................. = 1

[27357] read(6, "s ", 1) ................................. = 1

[27357] read(6, "a ", 1) ................................. = 1

[27357] read(6, "p ", 1) ................................. = 1

[27357] read(6, "d ", 1) ................................. = 1

[27357] read(6, "b ", 1) ................................. = 1

[27357] read(6, "/ ", 1) ................................. = 1

[27357] read(6, "d ", 1) ................................. = 1

[27357] read(6, "a ", 1) ................................. = 1

[27357] read(6, "t ", 1) ................................. = 1

[27357] read(6, "a ", 1) ................................. = 1

[27357] read(6, "\n", 1) ................................. = 1

[27357] read(6, "I ", 1) ................................. = 1

[27357] read(6, "n ", 1) ................................. = 1

[27357] read(6, "d ", 1) ................................. = 1

[27357] read(6, "e ", 1) ................................. = 1

[27357] read(6, "p ", 1) ................................. = 1

[27357] read(6, "P ", 1) ................................. = 1

[27357] read(6, "r ", 1) ................................. = 1

[27357] read(6, "o ", 1) ................................. = 1

[27357] read(6, "g ", 1) ................................. = 1

[27357] read(6, "r ", 1) ................................. = 1

[27357] read(6, "a ", 1) ................................. = 1

[27357] read(6, "m ", 1) ................................. = 1

[27357] read(6, "s ", 1) ................................. = 1

[27357] read(6, "= ", 1) ................................. = 1

[27357] read(6, "/ ", 1) ................................. = 1

[27357] read(6, "s ", 1) ................................. = 1

[27357] read(6, "a ", 1) ................................. = 1

[27357] read(6, "p ", 1) ................................. = 1

[27357] read(6, "d ", 1) ................................. = 1

[27357] read(6, "b ", 1) ................................. = 1

[27357] read(6, "/ ", 1) ................................. = 1

[27357] read(6, "p ", 1) ................................. = 1

[27357] read(6, "r ", 1) ................................. = 1

[27357] read(6, "o ", 1) ................................. = 1

[27357] read(6, "g ", 1) ................................. = 1

[27357] read(6, "r ", 1) ................................. = 1

[27357] read(6, "a ", 1) ................................. = 1

[27357] read(6, "m ", 1) ................................. = 1

[27357] read(6, "s ", 1) ................................. = 1

[27357] read(6, "\n", 1) ................................. = 1

[27357] read(6, "\n", 1) ................................. = 1

[27357] read(6, "[ ", 1) ................................. = 1

[27357] read(6, "R ", 1) ................................. = 1

[27357] read(6, "u ", 1) ................................. = 1

[27357] read(6, "n ", 1) ................................. = 1

[27357] read(6, "t ", 1) ................................. = 1

[27357] read(6, "i ", 1) ................................. = 1

[27357] read(6, "m ", 1) ................................. = 1

[27357] read(6, "e ", 1) ................................. = 1

[27357] read(6, "] ", 1) ................................. = 1

[27357] read(6, "\n", 1) ................................. = 1

[27357] read(6, "/ ", 1) ................................. = 1

[27357] read(6, "s ", 1) ................................. = 1

[27357] read(6, "a ", 1) ................................. = 1

[27357] read(6, "p ", 1) ................................. = 1

[27357] read(6, "d ", 1) ................................. = 1

[27357] read(6, "b ", 1) ................................. = 1

[27357] read(6, "/ ", 1) ................................. = 1

[27357] read(6, "p ", 1) ................................. = 1

[27357] read(6, "r ", 1) ................................. = 1

[27357] read(6, "o ", 1) ................................. = 1

[27357] read(6, "g ", 1) ................................. = 1

[27357] read(6, "r ", 1) ................................. = 1

[27357] read(6, "a ", 1) ................................. = 1

[27357] read(6, "m ", 1) ................................. = 1

[27357] read(6, "s ", 1) ................................. = 1

[27357] read(6, "/ ", 1) ................................. = 1

[27357] read(6, "r ", 1) ................................. = 1

[27357] read(6, "u ", 1) ................................. = 1

[27357] read(6, "n ", 1) ................................. = 1

[27357] read(6, "t ", 1) ................................. = 1

[27357] read(6, "i ", 1) ................................. = 1

[27357] read(6, "m ", 1) ................................. = 1

[27357] read(6, "e ", 1) ................................. = 1

[27357] read(6, "/ ", 1) ................................. = 1

[27357] read(6, "7 ", 1) ................................. = 1

[27357] read(6, "4 ", 1) ................................. = 1

[27357] read(6, "0 ", 1) ................................. = 1

[27357] read(6, "3 ", 1) ................................. = 1

[27357] read(6, "= ", 1) ................................. = 1

[27357] read(6, "7 ", 1) ................................. = 1

[27357] read(6, ". ", 1) ................................. = 1

[27357] read(6, "4 ", 1) ................................. = 1

[27357] read(6, ". ", 1) ................................. = 1

[27357] read(6, "3 ", 1) ................................. = 1

[27357] read(6, ". ", 1) ................................. = 1

[27357] read(6, "0 ", 1) ................................. = 1

[27357] read(6, ", ", 1) ................................. = 1

[27357] read(6, "\n", 1) ................................. = 1

[27357] read(6, 0x9fffffffffffded1, 1) ................... = 0

[27357] close(6) ......................................... = 0

[27357] time(NULL) ....................................... = 1212131134

[27357] getpid() ......................................... = 27357 (27356)

[27357] utssys(0x9fffffffffffea40, 0, 0) ................. = 0

[27357] brk(0x60000000001a0000) .......................... = 0

[27357] open("/etc/nsswitch.conf", O_RDONLY|0x800, 0666) . = 6

[27357] ioctl(6, TCGETA, 0x9fffffffffffe8c0) ............. ERR#25 ENOTTY

[27357] read(6, "# \n# / e t c / n s s w i t c ".., 8192) = 446

[27357] read(6, 0x60000000001821a8, 8192) ................ = 0

[27357] close(6) ......................................... = 0

[27357] open("/usr/lib/hpux64/libnss_files.so.1", O_RDONLY|0x800, 0) = 6

[27357] fstat(6, 0x9fffffffffffe340) ..................... = 0

[27357] pread(6, "7fE L F 0202010101\0\0\0\0\0\0\0".., 1024, 0) = 1024

[27357] stat("/usr/lib/hpux64/dpd", 0x9fffffffffffd8f0) .. = 0

[27357] open("/usr/lib/hpux64/dpd/libnss_files.so.1.bpd", O_RDONLY|0x800, 0) ERR#2 ENOENT

[27357] getuid() ......................................... = 3000 (3000)

[27357] getgid() ......................................... = 200 (200)

[27357] mmap(NULL, 85872, PROT_READ|PROT_EXEC, MAP_SHARED|MAP_SHLIB, 6, 0) = 0xc0000000008b0000

[27357] mmap(NULL, 3159, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_SHLIB, 6, 131072) = 0x9fffffffbf79b000

[27357] close(6) ......................................... = 0

[27357] getuid() ......................................... = 3000 (3000)

[27357] getgid() ......................................... = 200 (200)

[27357] open("/etc/hosts", O_RDONLY|0x800, 0666) ......... = 6

[27357] ioctl(6, TCGETA, 0x9fffffffffffe850) ............. ERR#25 ENOTTY

[27357] read(6, "# # c o n f i g u r e d u s ".., 8192) = 8192

[27357] read(6, " ".., 8192) = 722

[27357] lseek(6, 18446744073709551119, SEEK_CUR) ......... = 8417

[27357] close(6) ......................................... = 0

[27357] open("/etc/hosts", O_RDONLY|0x800, 0666) ......... = 6

[27357] ioctl(6, TCGETA, 0x9fffffffffffe910) ............. ERR#25 ENOTTY

[27357] read(6, "# # c o n f i g u r e d u s ".., 8192) = 8192

[27357] read(6, " ".., 8192) = 722

[27357] lseek(6, 18446744073709551083, SEEK_CUR) ......... = 8381

[27357] close(6) ......................................... = 0

[27357] sigprocmask(SIG_SETMASK, 0x9fffffffffffec70, 0x9fffffffffffec90) = 0

[27357] sigprocmask(SIG_SETMASK, 0x9fffffffffffec90, 0x9fffffffffffec70) = 0

[27357] sigsetreturn(NULL, 0x6211988, 48640) ............. = 0

[27357] sigprocmask(SIG_SETMASK, 0x9fffffffffffec70, 0x9fffffffffffec90) = 0

[27357] sigprocmask(SIG_SETMASK, 0x9fffffffffffec90, 0x9fffffffffffec70) = 0

[27357] sigaction(SIGPIPE, 0x9fffffffffffecb0, 0x9fffffffffffece0) = 0

[27357] sigaction(SIGINT, 0x9fffffffffffecb0, 0x9fffffffffffece0) = 0

[27357] sigaction(SIGHUP, 0x9fffffffffffecb0, 0x9fffffffffffece0) = 0

[27357] sigaction(SIGTERM, 0x9fffffffffffecb0, 0x9fffffffffffece0) = 0

[27357] sigaction(SIGALRM, 0x9fffffffffffecb0, 0x9fffffffffffece0) = 0

[27357] alarm(120) ....................................... = 0

[27357] stat("/sapdb/Q01/db/pgm/dbmsrv", 0x9fffffffffffe9f0) ERR#2 ENOENT

[27357] alarm(0) ......................................... = 120

[27357] ioctl(1, TCGETA, 0x9fffffffffffec90) ............. = 0

[27357] write(1, "E r r o r ! C o n n e c t i o ".., 106) = 106

[27357] write(1, "\n", 1) ................................ = 1

[27357] close(5) ......................................... = 0

[27357] getpid() ......................................... = 27357 (27356)

[27357] unlink("/var/spool/sockets/pwgr/client27357") .... = 0

[27357] exit(2) .......................................... WIFEXITED(2)

It seems that the problem is, that there is an access to "/sapdb/Q01/db/pgm/dbmsrv"

this File is not available on this node (Node 2) because the DB "Q01" runs on Node 1

at this time;

but the same command on Node 1 gives the Output with no Errors:

$ /usr/local/bin/tusc -afpo dbmcli.log /sapdb/programs/bin/dbmcli -s db_enum

NOTE: /sapdb/Q01/db/pgm/dbmsrv: losing setuid/setgid privileges when tracing

NOTE: /sapdb/Q01/db/pgm/starter/sdbstarter: losing setuid/setgid privileges when tracing

NOTE: /sapdb/Q01/db/pgm/dbmsrv: losing setuid/setgid privileges when tracing

OK

Q01 /sapdb/Q01/db 7.6.03.15 fast running

Q01 /sapdb/Q01/db 7.6.03.15 quick offline

Q01 /sapdb/Q01/db 7.6.03.15 slow offline

Q01 /sapdb/Q01/db 7.6.03.15 test offline

( Terminating process 22357 ("/sapdb/Q01/db/pgm/dbmsrv -sdbstarter 3000 200 A -P 000000050000") )

greetings Hans-Peter

0 Kudos

Hi Natalia,

yes,

/sapdb/data/config

ist served by NFS and both Nodes can access it.

thanks

Hans-Peter

markus_doehr2
Active Contributor
0 Kudos

> but the same command on Node 1 gives the Output with no Errors:

>

> $ /usr/local/bin/tusc -afpo dbmcli.log /sapdb/programs/bin/dbmcli -s db_enum

> NOTE: /sapdb/Q01/db/pgm/dbmsrv: losing setuid/setgid privileges when tracing

> NOTE: /sapdb/Q01/db/pgm/starter/sdbstarter: losing setuid/setgid privileges when tracing

> NOTE: /sapdb/Q01/db/pgm/dbmsrv: losing setuid/setgid privileges when tracing

> OK

> Q01 /sapdb/Q01/db 7.6.03.15 fast running

> Q01 /sapdb/Q01/db 7.6.03.15 quick offline

> Q01 /sapdb/Q01/db 7.6.03.15 slow offline

> Q01 /sapdb/Q01/db 7.6.03.15 test offline

> ( Terminating process 22357 ("/sapdb/Q01/db/pgm/dbmsrv -sdbstarter 3000 200 A -P 000000050000") )

So is it possible that Node 1 sees "both" database and node 2 only P02?

Markus

former_member229109
Active Contributor
0 Kudos

Hello Hans-Peter,

You wrote ::

" DB "P02" on the "Node 2" && "Q01" on the "Node 1"

from Node 1:

$ /sapdb/programs/bin/dbmcli db_enum

OK

P02 /sapdb/P02/db 7.6.03.15 fast running

P02 /sapdb/P02/db 7.6.03.15 quick offline

P02 /sapdb/P02/db 7.6.03.15 slow offline

P02 /sapdb/P02/db 7.6.03.15 test offline

Q01 /sapdb/Q01/db 7.6.03.15 fast running

Q01 /sapdb/Q01/db 7.6.03.15 quick offline

Q01 /sapdb/Q01/db 7.6.03.15 slow offline

Q01 /sapdb/Q01/db 7.6.03.15 test offline

from Node 2:

$ /sapdb/programs/bin/dbmcli db_enum

Error! Connection failed to node (local) for database (no dbname):

no installation found

"

1) Are you SAP customer? Did you already create the SAP ticket where this issue

was reported?

2) Was you able to check the recommended SAP note :: 803452 MaxDB directories in UNIX clusters for failover

3) Please also review the SAP note:: 829408 Upgrading a database in the UNIX cluster

Did you run the installation of the database software on the Node 2?

Please post dbmsrv_<node_2>.prt located in /sapdb/data/wrk.

4) Please run the following commands on the Node 1 & Node 2, logon as user in the sdba group,

& update with outputs:

/sapdb/programs/bin/sdbregview -l

/sapdb/programs/bin/dbmcli inst_enum

/sapdb/programs/bin/dbmcli -s dbm_getpath IndepProgPath

ls -l /sapdb/data/config

more /sapdb/data/config/Installations.ini

ps -efe | grep kernel

on the "Node 2" : /sapdb/programs/bin/xinstinfo P02

on the "Node 1" : /sapdb/programs/bin/xinstinfo Q01

5) Please run as root user on the Node 1 & Node 2 :

cd /sapdb/programs/bin

./sdbverify > check.node_1.txt

< or ./sdbverify > check.node_2.txt >

=> display 'check.node_1.txt' & pay attention that the installed database packages are consistent except may be the Database Kernel 7.6.03.15 ... in /sapdb/P02/db;

display 'check.node_2.txt' & pay attention that the installed database packages are consistent except may be the Database Kernel 7.6.03.15 ... in /sapdb/Q01/db;

Thank you and best regards, Natalia Khlopina

Edited by: Natalia Khlopina on May 31, 2008 12:54 AM

0 Kudos

Hello Natalia,

sorry for my late response,

I will open a SAP Ticket for the problem.

Thanks Hans-Peter

0 Kudos

Hello Markus,

sorry for my late response,

I will open a SAP Ticket for the problem.

Thanks Hans-Peter

markus_doehr2
Active Contributor
0 Kudos

How is you filesystem layout? NFS? Cluster filesystem?

Markus

0 Kudos

the SAPDB Software is located on an NFS Filesystem

Hans-Peter