- Where can I find the best resources on Oracle9i installation?
- While creating a new database after a new installation, which mode do I select, "dedicated server" or "shared server"? The number of clients will be 10 maximum for my application.
- Is there any option so that Oracle automatically takes backups of the database at certain intervals?
My favorite place for information on Oracle9i installation procedures is the Oracle Technology Network Web site. Specifically, you can find the Oracle9i Release 2 (18.104.22.168) Installation Guide for UNIX Systems located here.
There is also an installation guide for Windows, so choose the appropriate documentation for your operating system.
With respect to your second question about configuring dedicated versus shared connections, if your application will have a maximum of 10 client connections, you can configure dedicated server connections. Although this would also depend on whether those client connections were coming from a single-user source of an application server.
Finally, there is no Oracle option to automatically take database backups, per se. What you can do is configure a job in Enterprise Manager to back up your database using RMAN according to a schedule that you set up. You can also schedule user-managed backups via scripts if you choose not to use RMAN.
Dig Deeper on Oracle database backup and recovery
Related Q&A from Maria Anderson
I have been trying to install Oracle 8.1.7 on SUSE Linux 9.0 and got the error: "Error in invoking target install of makefile /opt/oracle/...../*.mk." Continue Reading
I'm getting errors while installing the Database Configuration Assistant. Continue Reading
Can I use /var/opt/oracle/oratab to specify listener information? Continue Reading