SLOB Deployment – A Picture Tutorial.

SLOB can be obtained at this link: Click here.

This post is just a simple set of screenshots I recently took during a fresh SLOB deployment. There have been a tremendous number of SLOB downloads lately so I thought this might be a helpful addition to go along with the documentation. The examples I show herein are based on a Oracle Database but these principles apply equally to and all Oracle Database 11g releases as well.


  1. Create a tablespace for SLOB.
  2. Run
  3. Verify user schemas
  4. Execute An Example Of Wait Kit Failure and Remedy
  5. Execute Successfully
  6. Using SLOB With SQL*Net
    1. Test SQL*Net Configuration
    2. Execute With SQL*Net
  7. More About Testing Non-Linux Platforms


Create a Tablespace for SLOB

If you already have a tablespace to load SLOB schemas into please see the next step in the sequence.



Provided database connectivity works with ‘/ as sysdba’ this step is quite simple. All you have to do is tell which tablespace to use and how many SLOB users (schemas) load. The slob.conf file tells how much data to load. This example is 16 SLOB schemas each with 10,000 8K blocks of data. One thing to be careful of is the slob.conf->LOAD_PARALLEL_DEGREE parameter. The name is not exactly perfect since this actually controls concurrent degree of SLOB schema creation/loading. Underneath the concurrency may be parallelism (Oracle Parallel Query) so consider setting this to a rather low value so as to not flood the system until you’ve practiced with for a while.



Verify Users’ Schemas

After taking a quick look at cr_tab_and_load.out, as per instruction, feel free to count the number of schemas. Remember, there is a “zero” user so with 16 will have 17 SLOB schema users.


Execute An Example Of Wait Kit Failure and Remedy

This is an example of what happens if one misses the detail to create the semaphore wait kit as per the documentation. Not to worry, simply do what the output of directs you to do. Note, while supports just a single argument as shown here, SLOB 2.3 and beyond have additional options to support Multiple Schema Model. Please see the documentation for more information on recently added options to


Execute Successfully

The following is an example of a healthy test.


Using SLOB with SQL Net

Strictly speaking this is all optional if all you intend to do is test SLOB on your current host. However, if SLOB has been configured in a Windows, AIX, or Solaris box this is how one tests SLOB. Testing these non-Linux platforms merely requires a small Linux box (e.g., a laptop or a VM running on the system you intend to test!) and SQL*Net.

Test SQL*Net Configuration

We don’t care where the SLOB database service is. If you can reach it successfully with tnsping you are mostly there.


Execute With SQL*Net

The following is an example of a successful test over SQL*Net.


More About Testing Non-Linux Platforms

Please note, loading SLOB over SQL*Net has the same configuration requirements as what I’ve shown for data loading (i.e., running Consider the following screenshot which shows an example of loading SLOB via SQL*Net.


Finally, please see the next screenshot which shows the slob.conf file the corresponds to the proof of loading SLOB via SQL*Net.




This short post shows the simple steps needed to deploy SLOB in both the simple Linux host-only scenario as well as via SQL*Net. Once a SLOB user gains the skills needed to load and use SLOB via SQL*Net there are no barriers to testing SLOB databases running on any platform to include Windows, AIX and Solaris.






14 Responses to “SLOB Deployment – A Picture Tutorial.”

  1. 1 testconnoisseur July 1, 2015 at 3:57 am

    Hello Kevin, Iam getting ora-65049 when running Is there a way i can make it work? Thanks!

  2. 7 Norm Pang (@normpang) July 10, 2015 at 2:35 am

    hi Kevin,

    After running ./ IOPS 15, I receive the error:

    ERROR at line 1:
    ORA-00904: : invalid identifier

    I can run dbms_random ok:

    select DBMS_RANDOM.VALUE() from dual;


    • 8 kevinclosson July 10, 2015 at 6:04 pm created a log file called cr_tab_and_load.out. Please send that to my contact info (see the top of the blog “contact”). generally doesn’t cause anyone problems. However, I did put a lot of work into failure-hardening for SLOB 2.3 which I will release on 7/12/15. You might just care to wait for SLOB 2.3.

  3. 9 dbam15 November 3, 2015 at 5:30 pm

    Hi can I install the slob server on e.g. a small vm (linux) and then point it at a larger server (linux) to test the I/O or should slob be on the same server.

  4. 11 Ali Naveed March 7, 2019 at 8:55 pm

    I didn’t understand the schema part. Why you have selected 16 schemas?

  5. 13 Drew DeGraff (@drew2fast1st) January 28, 2022 at 9:30 am

    How do you get the to use “/ as sysdba”. I don’t see anything in your code or slob.conf to control this. It only has parameters for setting the user and password thanks.

Leave a Reply to Norm Pang (@normpang) Cancel reply

Please log in using one of these methods to post your comment: Logo

You are commenting using your account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.


I work for Amazon Web Services. The opinions I share in this blog are my own. I'm *not* communicating as a spokesperson for Amazon. In other words, I work at Amazon, but this is my own opinion.

Enter your email address to follow this blog and receive notifications of new posts by email.

Join 744 other subscribers
Oracle ACE Program Status

Click It

website metrics

Fond Memories


All content is © Kevin Closson and "Kevin Closson's Blog: Platforms, Databases, and Storage", 2006-2015. Unauthorized use and/or duplication of this material without express and written permission from this blog’s author and/or owner is strictly prohibited. Excerpts and links may be used, provided that full and clear credit is given to Kevin Closson and Kevin Closson's Blog: Platforms, Databases, and Storage with appropriate and specific direction to the original content.

%d bloggers like this: