Skip to content

Instantly share code, notes, and snippets.

@mortenbra
Last active May 9, 2017 08:04
Show Gist options
  • Save mortenbra/d4449debde7151dbcd2a to your computer and use it in GitHub Desktop.
Save mortenbra/d4449debde7151dbcd2a to your computer and use it in GitHub Desktop.
Clean up unused features in Oracle XE after installation
-- do some cleanup after Oracle XE installation
-- run as SYS
-- disable XDB server
-- assumes we will use ORDS or other web listener instead
exec dbms_xdb.sethttpport(0);
exec dbms_xdb.setftpport(0);
-- anonymous user is not needed when we don't use XDB
alter user anonymous account lock;
-- drop demo schemas
drop user hr cascade;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment