Oracle is the world's leading supplier of software for information management but it is best known for its sophisticated relational database products (SQL database management systems). Blizzard and many other companies who look for excelled performance in the database area look not to MySQL, but to Oracle for larger scale needs. Need proof they use Oracle? Look at this job requirements for a job there: Blizzard Entertainment - Employment Opportunities. Notice the words Oracle and database. I do not know of any servers that currently operate on Oracle, so I decided to write this guide on how to install, configure, and setup your database on a Oracle-oriented system as opposed to MySQL.
-- Step 1: Downloads --
The following programs need to be downloaded prior to beginning this tutorial. Please use standard configuration methods, meaning to just do a typical setup with nothing special.
- Oracle 10g Express Edition Client - Remember to download and install the one labeled "OracleXEUniv.exe"
- Navicat Lite for Oracle - This is the same GUI as it is for MySQL Navicat users
-- Step 2: Setup --
Remember, you do not have to use the 10g Express Edition, but it is the only one that is free. Good luck finding this on a torrent, as I have rarely seen them there. The other servers they offer (non-free) are at least $500 each. This chart depicts the features of each of the different types of Oracle databases: Oracle Database 11g: Product Editions & Features. If you are looking for the difference in MySQL and Oracle, here is an effective link to show you them: http://www-css.fnal.gov/dsg/external/freew...l-vs-pgsql.html. As you can see, Oracle passes with an "A" grade in almost every category.
Anyways, after you have downloaded the Oracle client and Navicat Lite for Oracle programs, install them with the typical install and default file paths. I shouldn't have to install explain this any because it should be self explanatory. Remember to make your passwords complex and not so simple. I recommend that you generate your password with this tool, then check the strength just to be sure with this.
-- Step 3: Database Configuration --
After you have installed the programs I asked you to, please open up Navicat Lite for Oracle. Click the green "Connection" button in the top-left hand corner of the application. For the connection name, put anything you wish; it really doesn't matter. For Host Name/Ip Address, leave it at localhost unless you are connecting to a non-local database. Skip down to User name and password and enter the information I asked you to generate back at step 2 when configuring your Oracle 10g Express Edition client. Test the connection and click ok. If the connection fails, most likely you entered a wrong password or your firewall is blocking this application. Now double click the connection name on the left hand side and some boxes should drop down. Leave them here for the time being.
I don't know of any Ascent, MaNGOS, Spurious, or any emulator that has a database team that develops strictly Oracle databases. MySQL queries will most likely fail if you execute them into an Oracle-oriented database. To fix this issue, developers have created MySQL to Oracle, a program that converts a MySQL formatted file to Oracle formatted: MySQL to Oracle - a program to migrate databases from MySQL server to Oracle. Be sure to download the trial version. My advice is to dump a MySQL query (the whole database) from your Navicat for MySQL (which most already have installed) and then convert that file.
Now return to Navicat Lite for Oracle, and the boxes should be dropped down from your connection name. Right click the first one that is NOT named "Schemas" but most likely your username to your database (Mine is labeled as ROOT). Select "Execute batch file..." and choose your converted SQL file. It should import cleanly.
-- Step 4: Configuration Adjustments --
The default in the configuration files for most emulators is MySQL. Ascent does NOT support Oracle at this moment. We need to change this so that your server is reading the Oracle one, not the MySQL one. I will demonstrate the configuration changes for Spurious Emulator.
Congratulations! You have just setup a server with an Oracle database!Spurious Emulator:
In your Realmserver.ini change the SQLDBType line from MySQL to Oracle.
<SQLDBType>Oracle</SQLDBType>
Repeat these steps for the WorldServer.ini's and the WorldCluster.ini files.
Hope you enjoyed the guide,
SectorSeven
PS - I am SectorSeven, wareagle920, and DudeWheresMYEmu