Index: openacs-4/packages/acs-core-docs/www/install-openacs-delete-tablespace.adp =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/acs-core-docs/www/install-openacs-delete-tablespace.adp,v diff -u -N -r1.2 -r1.3 --- openacs-4/packages/acs-core-docs/www/install-openacs-delete-tablespace.adp 7 Aug 2017 23:47:50 -0000 1.2 +++ openacs-4/packages/acs-core-docs/www/install-openacs-delete-tablespace.adp 8 Nov 2017 09:42:11 -0000 1.3 @@ -17,19 +17,19 @@ you can use the drop user command in SVRMGRL with the cascade option. This command will drop the user and every database object the user owns.

-SVRMGR> drop user $OPENACS_SERVICE_NAME cascade;
+SVRMGR> drop user $OPENACS_SERVICE_NAME cascade;

If this does not work because svrmgrl "cannot drop a user that is currently connected", make sure to kill the AOLserver using this user. If it still does not work, do:

-SVRMGR> select username, sid, serial# from v$session where lower(username)='$OPENACS_SERVICE_NAME';
+SVRMGR> select username, sid, serial# from v$session where lower(username)='$OPENACS_SERVICE_NAME';

and then

-SVRMGR> alter system kill session 'sid, serial#';
+SVRMGR> alter system kill session 'sid, serial#';

where sid and serial# are replaced with the corresponding values for the open session.

Use with caution!

If you feel the need to delete everything related to the service, you can also issue the following:

-SVRMGR> drop tablespace $OPENACS_SERVICE_NAME including contents cascade constraints;
+SVRMGR> drop tablespace $OPENACS_SERVICE_NAME including contents cascade constraints;

@@ -40,9 +40,9 @@ 'down' flag (-d). If you're using inittab, you have to comment out your server in /etc/inittab, reread the inittab with /sbin/init q, and then -restart-aolserver $OPENACS_SERVICE_NAME +restart-aolserver $OPENACS_SERVICE_NAME .

Then, to drop the db, just do:

-[$OPENACS_SERVICE_NAME ~]$ dropdb $OPENACS_SERVICE_NAME
+[$OPENACS_SERVICE_NAME ~]$ dropdb $OPENACS_SERVICE_NAME
 
 DROP DATABASE