Run your own private SWG Server (and help us develop it!)
You might sometimes want to wipe your SWG database and start all over. This guide will help you do that. This guide assumes that you are already up and running on the v1.2.1 SWG Source Server VM.
In your VM, go to
Start -> Logout -> Logout. You will be brought to a login page. Login with Username:
oracle and Password:
Use the button at the top of the desktop to open a terminal. Enter the command
dbca and press enter.
This will open the Oracle Database Configuration Assistant. The first thing we will do it delete the database that already exists. Select “Delete database” and click Next.
You will need to provide the password (
swg) and click Next again.
You will then be given the option to De-Register from EM Cloud Control. Just leave it unchecked and click Next.
You will be given a summary of what is about to happen. Click Finish to run the operation.
Click Yes when prompted.
Click Close when the operation has finished.
Use the Terminal to run the
dbca command again. This time, we want to Create a database, so make sure that’s selected and click next.
You will now need to enter all the information Oracle needs in order to make your new database. Also, be sure to uncheck the “Create as a container database” selection. It’s easiest if you choose
swg for the Global database name and the password. You might be prompted that your password is not good enough, but you can just click Yes to continue.
You will again be presented with a summary of what is about to happen. Click Finish to run the operation. This one may take several minutes.
Click Close when the database creation is complete.
Next, enter the command
sudo nano /etc/oratab and press enter. This will open the oratab configuration file.
Use your arrow keys to navigate to the bottom of this file and change the last character on the last line from
Y as shown. This tells the system to automatically start your new database at the system’s boot time.
When you’re finished, press CTRL+X to exit. Nano will ask you if you want to save. Press Y then Enter to save and close. You should now reboot your VM by going to
Start -> Logout -> Restart.
When your VM has rebooted, use the small button near the start menu to open SQL Developer. Right click on the existing connections to delete them.
Next, use the green plus sign to make a new connection. Enter a name that makes sense, then Username:
system and Password:
swg. Set your SID to
swg. It’s also helpful to check the Save Password checkbox. (Even though I didn’t in the screenshot, I should have, haha.) You can then press the Test button to make sure everything’s working. If so, click Save and close the window.
Double click on your new connection to connect to it. Once you’ve connected, you will need to copy the following commands into the Query Builder worksheet that was opened:
ALTER USER SYSTEM IDENTIFIED by "swg"; ALTER SESSION SET "_ORACLE_SCRIPT"=true; CREATE USER swg IDENTIFIED by "swg"; GRANT ALL PRIVILEGES TO swg; GRANT UNLIMITED TABLESPACE TO swg; alter system set sessions=3000 scope=spfile; alter system set processes=3000 scope=spfile; alter profile default limit password_life_time unlimited;
After pasting these commands, click the “Run Script” button, that is, the play icon with the paper behind it. (NOT “Run Statement”, that is, the regular play icon.)
You will now need to add another connection, so click the green plus sign once more. This time, your Username, Password, and SID should all be
swg. Again, check the Save Password checkbox, even though I forgot to in the screenshot. Click Test, then Save if your test was successful.
You may now close SQL Developer and open Terminator terminal. In the bottom left window, use the command
You can skip most steps by entering
n. The step you’re interested in is importing the database. Select
y for this one. The script will ask you a series of questions to get the information it needs to set up your new database. Use these responses:
Enter the DSN for the database connection: //127.0.0.1/swg Enter the database username: swg Enter the database password: swg Enter value for max_characters_per_account: 10 Enter value for max_characters_per_cluster: 10 Enter value for character_slots: 10 Enter value for cluster_name: swg Enter value for host: 127.0.0.1
That’s it! Start up your server and enjoy your fresh database.