on 05-29-2008 8:48 AM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
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
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
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
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
> 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
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
How is you filesystem layout? NFS? Cluster filesystem?
Markus
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
93 | |
10 | |
10 | |
9 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.