Shared Hosting FAQ
- Can I purchase an Oracle Shared Hosting service plan without purchasing
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.
- 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.
- What db schema managers do you not support?
We do not support any schema manager that requires DBA access.
- How do I manage my Oracle account?
Managing and administering your Oracle database is done through the
Oracle Control Panel (OCP).
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
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.
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.
What if I want to change my payment method?
Call Customer Service at (305) 274-8393.
What if I want to change my billing address?
You can call Customer Service at (305) 274-8393.
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.
- 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.
- 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.
- 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.
- If I have a problem with my database and lose data, how can I restore
Call one of our Customer Service Representatives at (305) 274-8393.
Restores are charged on an hourly basis.
- How often do you backup my data?
Your entire database is backed up once a week. Archive logs are backed
up every 15 minutes.
- How secure is my data? For example, can I confidently store credit
Oracle Shared Hosting uses standard Oracle database security. You can
confidently store credit card or customer information without concern.
- I want to resell part of my Oracle tablespace to a customer. How
do I create a login and tablespace for the customer?
- Log in to your Oracle Control Panel at http://youraccountname.myhosteddb.net/
- Click on the "Add User" button near the bottom of the screen,
and fill in the appropriate information about your customer
- 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.
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.
- 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
- 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.
- I just dropped a very important table. Can I get it back?
Yes. Contact customer support for help.
- Can I implement data constraints?
Yes. See the constraints section of Oracle Shared Hosting Help in the
Oracle Control Panel at http://youraccountname.myhosteddb.net/
- 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
- 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.
- 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.