Blue Reef Technical Support Blue Reef Virtual Server Reseller ProgramInstallation instructions, manuals, how-tos, and more!About Blue Reef Consulting, Inc.

About Blue Reef Virtual ServersEcommerce Solutions for your Virtual ServerSearch the Blue Reef Virtual Server web site
Return to Blue Reef Virtual Servers Home Page
Order virtual servers, software, computers, and more!
Return to Blue Reef Main Home Page
Site Map
Frequently Asked Questions to help you do business with your Virtual Server.

Blue Reef Virtual Servers
Support Menu
Frequently Asked Questions
FAQ Overview
General FAQs
Solaris Server FAQs
Oracle Server FAQs
Merchant FAQs
Technical FAQs
Domain FAQs
Billing FAQs
Virtual Hosting FAQs
Secure Server FAQs
Ordering FAQs
Pricing FAQs
Request Help from our Support Staff
Order a Blue Reef Virtual Server now!

Oracle Shared Hosting FAQ

  1. Can I purchase an Oracle Shared Hosting service plan without purchasing Web Hosting?

  2. Can I resell Oracle Shared Hosting?
    Yes. You can resell shared portions of your Oracle database by creating multiple logins within a single Oracle account, and then provide the login information to your customers.

  3. What db schema managers do you support?
    We support Toad, Visio, ER Studio, and Rapid SQL. We are in the process of getting DBA Studio to work as well.

  4. What db schema managers do you not support?
    We do not support any schema manager that requires DBA access.
  5. How do I manage my Oracle account?
    Managing and administering your Oracle database is done through the Oracle Control Panel (OCP).
  6. If I resell my Oracle account, how can I make sure my customers can't add new users or access other customer accounts?
    The Oracle Control Panel provides schema management features. If you own the account, you see additional tools for user/tablespace administration on the Oracle Control Panel. Your end users see only the schema management tool.

  7. Will I have access to any portion of my customers' accounts, or is that completely private?
    Your customers can assign passwords to their own tablespace. However, if you require access to their accounts, you can call Customer Service to have their password reset.

  8. Will I be notified of events affecting my billing or system limits?
    Yes. If account limits are reached or any other problems occur, a notification email is automatically sent to the service plan owner with details or instructions on how to resolve the problem.

  9. What if I want to change my payment method?
    Call Customer Service at (305) 274-8393.

  10. What if I want to change my billing address?
    You can call Customer Service at (305) 274-8393.

  11. What is the Cancellation Policy on this service?
    Oracle Shared Hosting is a month-to-month service offering. You may cancel any time, but you will be billed for the remainder of the month in which you cancel.

  12. What kind of Support is offered?
    Blue Reef is selling the hosting of Oracle, and cannot support Oracle functionality. Oracle Shared Hosting support from Blue Reef includes ensuring the database is up and running, the listener is listening, and all servers are functional. If you wish to purchase additional support, we recommend using a remote DBA service or any of a number of professional service providers. A great source for this information is the International Oracle Users Group.

  13. Can I move my Oracle database to my own Oracle server and run it from my own machine if I choose to in the future?
    Yes. You can export your data and transfer it to another Oracle server.

  14. What's the difference between Oracle Enterprise and Oracle Standard?
    Oracle Standard is designed for single machine databases. Oracle Enterprise is designed for databases that span multiple machines, require off-site replication, or require the 10% performance increase that 64-bit software can provide over the 32-bit Standard Edition. For more information on Oracle Standard and Oracle Enterprise, visit the Oracle Corporation Database Web site.

  15. If I have a problem with my database and lose data, how can I restore it?
    Call one of our Customer Service Representatives at (305) 274-8393. Restores are charged on an hourly basis.

  16. How often do you backup my data?
    Your entire database is backed up once a week. Archive logs are backed up every 15 minutes.

  17. How secure is my data? For example, can I confidently store credit card information?
    Oracle Shared Hosting uses standard Oracle database security. You can confidently store credit card or customer information without concern.

  18. I want to resell part of my Oracle tablespace to a customer. How do I create a login and tablespace for the customer?

    1. Log in to your Oracle Control Panel at
    2. Click on the "Add User" button near the bottom of the screen, and fill in the appropriate information about your customer
    3. Click "Submit Changes". The Oracle Control Panel will confirm the user was added correctly. The customer will be able to log in to Oracle with the privileges you assigned to that customer.

  19. Why is there a limit on the number of concurrent connections for Oracle Shared Hosting? Other databases don't have these limits.
    Providing Oracle in a shared hosting environment requires control of concurrent connections in order to optimize server performance. Limiting connections also ensures that no single account ties up all database resources. For more information on concurrent connections, and the reasons for limits in Oracle Shared Hosting, see more information on concurrent connections.

  20. Is there a limit on my connection idle time?
    Yes. Your connection can be idle for 10 minutes before it is disconnected. This is a precaution to avoid performance degradation caused by many idle connections.

  21. Is there a limit on CPU time?
    For performance purposes, we have limited the amount of CPU time per session to 10 minutes. This will prevent any runaway calls that can occupy the CPU and reduce performance.

  22. I just dropped a very important table. Can I get it back?
    Yes. Contact customer support for help.

  23. Can I implement data constraints?
    Yes. See the constraints section of Oracle Shared Hosting Help in the Oracle Control Panel at

  24. Why can't I insert any rows into my table?
    Ensure you're supplying data for all the columns marked NOT NULL.

    Make sure your format is correct, and that you are using single or double quotation marks where required. For example: - The correct date format is: "01/04/00" - The correct text format is: "31 Archer Street" - The correct number format is: 31.9

    Refer to a good Oracle SQL guide. Suggestions include: Oracle8i: The Complete Reference by Kevin Loney, George Koch. Hardcover (May 23, 2000).

  1. What does defragment tablespace do? Specifically, does it defragment all tables associated with a user?
    The "defrag tablespace" function is only available to the Oracle account owner. It removes all empty rows within tables and indexes to free up disk space. This is because defrag tablespace defragments the entire account. With Oracle, when a row within a table is deleted, that space is not recovered. The space can be reused by new rows within that table, but cannot be used by other tables. Therefore, the only way to recover space within Oracle is to defrag the entire tablespace. This recovers space from all tables and indexes of all users within that account.

  2. Are there any schema managers Oracle Shared Hosting does not support?
    Oracle Shared Hosting does not currently support Toad and ER Studio. We are working to resolve this problem.

About Oracle Share Hosting

Concurrent Connections


Oracle 8i: The Complete Reference
Oracle8i: The Complete Reference logo
Search for :
Enter keywords...