please help me

[raviraju]

i had one databse in run state


than i execute this command to find out shared memory




proutil -C Dbipcs


it will show me like that


your data in run state than it shows like that




PROGRESS SHARED MEMORY STATUS
ID ShMemVer Seg# InUse Database
1048576 - - - (not PROGRESS)
1048577 - - - (not PROGRESS)
1048578 - - - (not PROGRESS)
37748739 9136 0 Yes /data3/delphi/hlpprod.db
9437188 9136 0 No /home/guest/prashanth/sha1/prasha
40894471 9136 0 Yes /data2/stat/db/stat_mfg.db
35651592 9136 0 Yes /data1/acer/db/acerdb1.db
35651593 9136 0 Yes /home/guest/manoj/trainee/test.db
30408714 9136 0 Yes /data1/acer/db/mfgaca.db
12582923 9136 0 Yes /data2/fintest/fintest.db
5242892 9136 0 Yes /data3/delphi/mfgprod.db
46137357 9136 0 Yes /data1/acer/db/mfgdist.db
16777230 9136 0 Yes /data6/sapkit/delphidb.db
15 9136 0 Yes /data5/db/apbcl.db
6291472 9136 0 Yes /data3/sp/tyco/tdb/Tycoadm.db
33554449 9136 0 Yes /data3/delphi/delphidb.db
12582930 9136 0 Yes /progress/amco/cust_db.db
19 9136 0 Yes /data3/delphi/NonConfdb.db
17825812 9136 0 Yes /data3/sp/tyco/tdb/Tdelphi.db
11534357 9136 0 Yes /home/guest/durga/pop.db
18874390 9136 0 Yes /home/guest/shailendra/lion.db
18874391 9136 0 Yes /data6/sapkit/hlpprod.db
19922968 9136 0 Yes /data1/acer/db/efcaca.db
2097177 9136 0 Yes /progress/amco/custdb.db
4194330 9136 0 Yes /data3/sp/tyco/tdb/Tycohlp.db
27 9136 0 Yes /data2/fintest/jktdb.db
6291484 9136 0 Yes /home/guest/test/test.db
26214429 9136 0 Yes /data2/finance/finance.db
26214430 9136 0 Yes /data6/sapkit/mfgprod.db
1048608 9136 0 Yes /home/sunil/manoj/test/jkt.db
6291489 9136 0 Yes /home/guest/test/JKT/jkt.db
14680098 9136 0 Yes /data3/sp/tyco/tdb/Tycomfg.db
35 9136 0 Yes /data3/sp/tyco/tdb/Tsports2000.db
14680101 9136 0 Yes /home/sap-db/mfg-app.db
27263014 9136 0 Yes /data3/delphi/admprod.db
1048615 9136 0 Yes /home/guest/shailendra/open/lion.
29360168 9136 0 Yes /progress/amco/qadmfg.db
14680105 9136 0 Yes /home/guest/prashanth/phani/manoj
6291498 9136 0 Yes /home/sunil/vijay/kir.db
9437229 9136 0 Yes /home/guest/manoj/jkt/DBA.db
3145775 9136 0 Yes /data6/sapkit/admprod.db
8388656 9136 0 Yes /home/guest/manoj/kps/pad.db
1048626 9136 0 Yes /home/guest/test/sim/sim.db
$ than i execute commnd ipcrm -m no of id
than now my database is can not be shut down
and now not showing on the shared memory


$ $DLC/bin/proshut heena
SYSTEM ERROR: Can't attach shared memory with segment_id: 8388639 for heena
There is no server for database heena. (1423)


it showing like that now my question is that is it possible to shut down this database

 

[RealHeavyDude]

Did you execute the proshut in the same directory where the .db file resides? If not then you must supply the path to that file omitting the .db.

Heavy Regards, RealHeavyDude.

 

[Rob Fitzpatrick]

$ than i execute commnd ipcrm -m no of id
than now my database is can not be shut down
and now not showing on the shared memory


$ $DLC/bin/proshut heena
SYSTEM ERROR: Can't attach shared memory with segment_id: 8388639 for heena
There is no server for database heena. (1423)


it showing like that now my question is that is it possible to shut down this database

Why the heck are you deleting shared memory segments at the OS level? I think you're asking for trouble.