sharikaganju
New Member
Hi All,
We are trying to refresh data in our Test database in QAD. And we had written the following script -
#!/bin/sh
DLC=/progress/oe101b;export DLC
PATH=$PATH:$DLC;export PATH
PROMSGS=$DLC/promsgs;export PROMSGS
PROTERMCAP=$DLC/protermcap;export PROTERMCAP
/qad/scripts/stop.test
$DLC/bin/prorest /qad/qaddb/mfgprod.bkp /qad/qaddb/test/mfgtest
$DLC/bin/prorest /qad/qaddb/admprod.bkp /qad/qaddb/test/admtest
$DLC/bin/prorest /qad/qaddb/hlpprod.bkp /qad/qaddb/test/hlptest
/qad/scripts/start.test
When we run this script, we get the following errors -
[root@qad scripts]# ./refresh.test
OpenEdge Release 10.1B03 as of Fri Nov 2 22:11:46 EDT 2007
Connecting to Progress AdminServer using rmi://localhost:20931/Chimera (8280)
Searching for uitest_WS (8288)
Connecting to uitest_WS (8276)
uitest_WS not running (8313)
OpenEdge Release 10.1B03 as of Fri Nov 2 22:11:46 EDT 2007
Connecting to Progress AdminServer using rmi://localhost:20931/Chimera (8280)
Searching for uitest_AS (8288)
Connecting to uitest_AS (8276)
uitest_AS not running (8313)
SYSTEM ERROR: Can't attach shared memory with segment_id: 1343505 for /qad/qaddb/test/mfgtest
There is no server for database /qad/qaddb/test/mfgtest. (1423)
SYSTEM ERROR: Can't attach shared memory with segment_id: 1376276 for /qad/qaddb/test/hlptest
There is no server for database /qad/qaddb/test/hlptest. (1423)
SYSTEM ERROR: Can't attach shared memory with segment_id: 1409045 for /qad/qaddb/test/admtest
There is no server for database /qad/qaddb/test/admtest. (1423)
** Cannot find or open file /qad/qaddb/test/mfgtest, errno = 2. (43)
!!! ERROR - Database restore utility FAILED !!! (8564)
** Cannot find or open file /qad/qaddb/test/admtest, errno = 2. (43)
!!! ERROR - Database restore utility FAILED !!! (8564)
** Cannot find or open file /qad/qaddb/test/hlptest, errno = 2. (43)
!!! ERROR - Database restore utility FAILED !!! (8564)
11:51:15 BROKER 0: Multi-user session begin. (333)
11:51:16 BROKER 0: Begin Physical Redo Phase at 110000 . (5326)
11:51:17 BROKER 0: Physical Redo Phase Completed at blk 111741 off 6416 upd 0. (7161)
11:51:17 BROKER 0: At end of Physical redo, transaction table size is 256. (13547)
11:51:17 BROKER 0: Started for mfgtest-srv using tcp, pid 22651. (5644)
11:51:18 BROKER 0: Multi-user session begin. (333)
11:51:18 BROKER 0: Begin Physical Redo Phase at 0 . (5326)
11:51:18 BROKER 0: Physical Redo Phase Completed at blk 0 off 3407 upd 0. (7161)
11:51:18 BROKER 0: At end of Physical redo, transaction table size is 256. (13547)
11:51:18 BROKER 0: Started for hlptest-srv using tcp, pid 22654. (5644)
11:51:18 BROKER 0: Multi-user session begin. (333)
11:51:18 BROKER 0: Begin Physical Redo Phase at 3584 . (5326)
11:51:18 BROKER 0: Physical Redo Phase Completed at blk 1622 off 5565 upd 0. (7161)
11:51:18 BROKER 0: At end of Physical redo, transaction table size is 256. (13547)
11:51:18 BROKER 0: Started for admtest-srv using tcp, pid 22656. (5644)
OpenEdge Release 10.1B03 as of Fri Nov 2 22:11:46 EDT 2007
Connecting to Progress AdminServer using rmi://localhost:20931/Chimera (8280)
Searching for uitest_WS (8288)
Connecting to uitest_WS (8276)
Starting uitest_WS. Check status. (8296)
OpenEdge Release 10.1B03 as of Fri Nov 2 22:11:46 EDT 2007
Connecting to Progress AdminServer using rmi://localhost:20931/Chimera (8280)
Searching for uitest_AS (8288)
Connecting to uitest_AS (8276)
Starting uitest_AS. Check status. (8296)
[root@qad scripts]#
What could be the reason for the same ?
Thanks in advance.
We are trying to refresh data in our Test database in QAD. And we had written the following script -
#!/bin/sh
DLC=/progress/oe101b;export DLC
PATH=$PATH:$DLC;export PATH
PROMSGS=$DLC/promsgs;export PROMSGS
PROTERMCAP=$DLC/protermcap;export PROTERMCAP
/qad/scripts/stop.test
$DLC/bin/prorest /qad/qaddb/mfgprod.bkp /qad/qaddb/test/mfgtest
$DLC/bin/prorest /qad/qaddb/admprod.bkp /qad/qaddb/test/admtest
$DLC/bin/prorest /qad/qaddb/hlpprod.bkp /qad/qaddb/test/hlptest
/qad/scripts/start.test
When we run this script, we get the following errors -
[root@qad scripts]# ./refresh.test
OpenEdge Release 10.1B03 as of Fri Nov 2 22:11:46 EDT 2007
Connecting to Progress AdminServer using rmi://localhost:20931/Chimera (8280)
Searching for uitest_WS (8288)
Connecting to uitest_WS (8276)
uitest_WS not running (8313)
OpenEdge Release 10.1B03 as of Fri Nov 2 22:11:46 EDT 2007
Connecting to Progress AdminServer using rmi://localhost:20931/Chimera (8280)
Searching for uitest_AS (8288)
Connecting to uitest_AS (8276)
uitest_AS not running (8313)
SYSTEM ERROR: Can't attach shared memory with segment_id: 1343505 for /qad/qaddb/test/mfgtest
There is no server for database /qad/qaddb/test/mfgtest. (1423)
SYSTEM ERROR: Can't attach shared memory with segment_id: 1376276 for /qad/qaddb/test/hlptest
There is no server for database /qad/qaddb/test/hlptest. (1423)
SYSTEM ERROR: Can't attach shared memory with segment_id: 1409045 for /qad/qaddb/test/admtest
There is no server for database /qad/qaddb/test/admtest. (1423)
** Cannot find or open file /qad/qaddb/test/mfgtest, errno = 2. (43)
!!! ERROR - Database restore utility FAILED !!! (8564)
** Cannot find or open file /qad/qaddb/test/admtest, errno = 2. (43)
!!! ERROR - Database restore utility FAILED !!! (8564)
** Cannot find or open file /qad/qaddb/test/hlptest, errno = 2. (43)
!!! ERROR - Database restore utility FAILED !!! (8564)
11:51:15 BROKER 0: Multi-user session begin. (333)
11:51:16 BROKER 0: Begin Physical Redo Phase at 110000 . (5326)
11:51:17 BROKER 0: Physical Redo Phase Completed at blk 111741 off 6416 upd 0. (7161)
11:51:17 BROKER 0: At end of Physical redo, transaction table size is 256. (13547)
11:51:17 BROKER 0: Started for mfgtest-srv using tcp, pid 22651. (5644)
11:51:18 BROKER 0: Multi-user session begin. (333)
11:51:18 BROKER 0: Begin Physical Redo Phase at 0 . (5326)
11:51:18 BROKER 0: Physical Redo Phase Completed at blk 0 off 3407 upd 0. (7161)
11:51:18 BROKER 0: At end of Physical redo, transaction table size is 256. (13547)
11:51:18 BROKER 0: Started for hlptest-srv using tcp, pid 22654. (5644)
11:51:18 BROKER 0: Multi-user session begin. (333)
11:51:18 BROKER 0: Begin Physical Redo Phase at 3584 . (5326)
11:51:18 BROKER 0: Physical Redo Phase Completed at blk 1622 off 5565 upd 0. (7161)
11:51:18 BROKER 0: At end of Physical redo, transaction table size is 256. (13547)
11:51:18 BROKER 0: Started for admtest-srv using tcp, pid 22656. (5644)
OpenEdge Release 10.1B03 as of Fri Nov 2 22:11:46 EDT 2007
Connecting to Progress AdminServer using rmi://localhost:20931/Chimera (8280)
Searching for uitest_WS (8288)
Connecting to uitest_WS (8276)
Starting uitest_WS. Check status. (8296)
OpenEdge Release 10.1B03 as of Fri Nov 2 22:11:46 EDT 2007
Connecting to Progress AdminServer using rmi://localhost:20931/Chimera (8280)
Searching for uitest_AS (8288)
Connecting to uitest_AS (8276)
Starting uitest_AS. Check status. (8296)
[root@qad scripts]#
What could be the reason for the same ?
Thanks in advance.