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 -r1.4 -r1.4.2.1
--- openacs-4/packages/acs-core-docs/www/install-openacs-delete-tablespace.adp 25 Apr 2018 08:38:27 -0000 1.4
+++ openacs-4/packages/acs-core-docs/www/install-openacs-delete-tablespace.adp 2 Mar 2019 19:30:05 -0000 1.4.2.1
@@ -1,5 +1,5 @@
- Should it become necessary to rebuild a tablespace from scratch,
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
+user and every database object the user owns.$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
';
-
and then
SVRMGR>alter system kill session '
+using this user. If it still does not work, do:sid, serial#
';SVRMGR>select username, sid, serial# from v$session where lower(username)='$OPENACS_SERVICE_NAME';
+and then
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
+can also issue the following:$OPENACS_SERVICE_NAME
including contents cascade constraints;SVRMGR>drop tablespace $OPENACS_SERVICE_NAME including contents cascade constraints;
@@ -36,9 +36,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