Use Blizzard's Database of Choice: Oracle menu

User Tag List

Page 1 of 2 12 LastLast
Results 1 to 15 of 19
  1. #1
    Vindicated's Avatar Contributor
    Reputation
    226
    Join Date
    Aug 2008
    Posts
    1,067
    Thanks G/R
    0/0
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Use Blizzard's Database of Choice: Oracle

    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.


    -- 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.

    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.
    Congratulations! You have just setup a server with an Oracle database!

    Hope you enjoyed the guide,
    SectorSeven

    PS - I am SectorSeven, wareagle920, and DudeWheresMYEmu
    Last edited by Vindicated; 08-27-2008 at 12:30 AM.


    Use Blizzard's Database of Choice: Oracle
  2. #2
    BrantX's Avatar Contributor
    Reputation
    205
    Join Date
    Jul 2007
    Posts
    899
    Thanks G/R
    0/0
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Sector,I'm still calling you Sector either way , I love how you are the first one to find this and other EMU Things. Thus why i am giving you +Rep x3 for the great job and outstanding things you do for us at MMOwned. Great Share of Information you give to us.



  3. #3
    Hellgawd's Avatar Account not activated by Email
    Reputation
    710
    Join Date
    Jun 2007
    Posts
    2,480
    Thanks G/R
    0/0
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Old news
    But, good on you for letting everyone else know about it.
    Hopefully more emulators will be supporting Oracle very soon.. in fact, I guarantee it.

  4. #4
    Shao111's Avatar Active Member
    Reputation
    33
    Join Date
    Jul 2007
    Posts
    281
    Thanks G/R
    1/0
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Nice, this is good to know! +Rep!


  5. #5
    Vindicated's Avatar Contributor
    Reputation
    226
    Join Date
    Aug 2008
    Posts
    1,067
    Thanks G/R
    0/0
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Appreciate it guys!


  6. #6
    ninjiaownage's Avatar Member
    Reputation
    2
    Join Date
    Jul 2008
    Posts
    19
    Thanks G/R
    0/0
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Woah! You're Wareagle? You haven't been to AC-Web in ages!

  7. #7
    Vindicated's Avatar Contributor
    Reputation
    226
    Join Date
    Aug 2008
    Posts
    1,067
    Thanks G/R
    0/0
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Its not my favorite site. When I'm in a spamming type of mood I'll go there. All their content is copied from here so why not see the real guides by the real people.

    Anywho, back on topic please.


  8. #8
    Arthas117's Avatar Knight-Champion
    Reputation
    151
    Join Date
    Mar 2007
    Posts
    483
    Thanks G/R
    0/0
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Damn niec ;D Blizzard's database? :O That's kewl ;P
    +rep x2, thro I wont use cuz I'm no longer in to emu bussiness

    World best PvP Paladin=Me? GG ;D


  9. #9
    Cursed's Avatar Contributor
    Reputation
    270
    Join Date
    Jun 2007
    Posts
    1,380
    Thanks G/R
    0/0
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    *wave* hey S7 +Rep 3x for this!

  10. #10
    costel_gabitu's Avatar Member
    Reputation
    44
    Join Date
    Jan 2008
    Posts
    359
    Thanks G/R
    0/0
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    +rep cuz I luv u S7

  11. #11
    Vindicated's Avatar Contributor
    Reputation
    226
    Join Date
    Aug 2008
    Posts
    1,067
    Thanks G/R
    0/0
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Appreciate it guys


  12. #12
    Neth'zul's Avatar Banned
    Reputation
    204
    Join Date
    Nov 2007
    Posts
    887
    Thanks G/R
    0/0
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Yay sector, good guide +2 rep

  13. #13
    volitle's Avatar Contributor
    Reputation
    181
    Join Date
    Nov 2007
    Posts
    1,127
    Thanks G/R
    0/0
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    nice guide +rep wb as well sector


  14. #14
    Dragonshadow's Avatar ★ Elder ★
    Reputation
    1170
    Join Date
    Apr 2007
    Posts
    3,858
    Thanks G/R
    0/0
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Awesome. What benefits does an oracle database have over a mysql database?
    Look at your post, now back to mine; Now back to your post, now back to mine. Sadly, it isn't mine, but if you stopped trolling and started posting legitimate content, it could look like mine. Look down, backup, where are you? You're scrolling through threads, reading the post your post could look like. What did you post? Back at mine; It's a reply saying something you want to hear. Look again and the reply is now diamonds.

    Anything is possible when you think before you post. The moon is shrinking.

  15. #15
    Vindicated's Avatar Contributor
    Reputation
    226
    Join Date
    Aug 2008
    Posts
    1,067
    Thanks G/R
    0/0
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    http://www-css.fnal.gov/dsg/external/freeware/mysql-vs-pgsql.html

    This pretty much sums it up


Page 1 of 2 12 LastLast

Similar Threads

  1. Easiest way to use "Blizzard UI" functions to /interact with a selected target?
    By b0nghitter in forum WoW Bots Questions & Requests
    Replies: 1
    Last Post: 11-05-2012, 11:07 AM
  2. Use Blizzard UI-Protected Functions
    By rljohn in forum World of Warcraft Exploits
    Replies: 283
    Last Post: 08-20-2009, 12:24 AM
  3. [Guide] HowTo: Make custom mounts using an ascent database (works with mangos aswell)
    By TelepathicIndian in forum WoW EMU Guides & Tutorials
    Replies: 13
    Last Post: 03-08-2009, 09:31 AM
  4. How can I create a database that other can use.
    By kate1 in forum World of Warcraft Emulator Servers
    Replies: 3
    Last Post: 12-16-2007, 01:01 PM
  5. To the person using the email: <[email protected]>
    By Dalllas in forum World of Warcraft General
    Replies: 34
    Last Post: 12-11-2007, 02:46 PM
All times are GMT -5. The time now is 09:36 PM. Powered by vBulletin® Version 4.2.3
Copyright © 2024 vBulletin Solutions, Inc. All rights reserved. User Alert System provided by Advanced User Tagging (Pro) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
Digital Point modules: Sphinx-based search