Database installation for beginners

Digg This!     StumbleUpon     Del.icio.us

RELATED CONTENT Oracle database design and architecture Can I download DBCA for Oracle Express Edition? How to recreate an Oracle index in a new schema with the CREATE command Using Oracle Universal Installer to install Oracle with Pro*C Defining Oracle database repository vs. information repository Can I create multiple schemas in Oracle for one user? ORA-12514 error when connecting to the Oracle database through Toad Solving the ORA-00904 error: invalid identifier in Oracle How to tune SQL UPDATE statements for an Oracle 10g upgrade Will queries run slower in a smaller Oracle buffer cache? Using a database link to connect two Oracle apps instances Oracle database design and architecture Can I download DBCA for Oracle Express Edition? How to recreate an Oracle index in a new schema with the CREATE command Using Oracle Universal Installer to install Oracle with Pro*C Defining Oracle database repository vs. information repository Can I create multiple schemas in Oracle for one user? ORA-12514 error when connecting to the Oracle database through Toad Solving the ORA-00904 error: invalid identifier in Oracle How to tune SQL UPDATE statements for an Oracle 10g upgrade Will queries run slower in a smaller Oracle buffer cache? Using a database link to connect two Oracle apps instances

RELATED GLOSSARY TERMS Terms from Whatis.com − the technology online dictionary E. F. Codd  (SearchOracle.com) extent  (SearchOracle.com) flexfield  (SearchOracle.com) foreign key  (SearchOracle.com) multidimensional database  (SearchOracle.com) object-oriented database management system  (SearchOracle.com) quad tree  (SearchOracle.com) relational online analytical processing  (SearchOracle.com) row  (SearchOracle.com) splay tree  (SearchOracle.com)

RELATED RESOURCES 2020software.com, trial software downloads for accounting software, ERP software, CRM software and business software systems Search Bitpipe.com for the latest white papers and business webcasts Whatis.com, the online computer dictionary

1)You answer to this question all depends on your platform. The Oracle documentation contains a section on platform specific information. I highly suggest you read this material to answer this question.

2) If you don't want to change anything, you can go with the default SID of "ORCL". The DB_NAME should be the same as the SID.

In the real world, we tend to give the SID a meaningful name. In our installation, we name the SID something meaningful which describes the database function. Then, we append one of the following: "P" for production databases, "D" for development databases, and "T" for test databases.

3) CATALOG and CATPROC are in the $ORACLE_HOME/rdbms/admin directory. You can run them by signing on to the database as SYS and issuing the following commands in SQL*Plus:

@$ORACLE_HOME/rdbms/admin/catalog
@$ORACLE_HOME/rdbms/admin/catproc

4) You must connect as SYS AS SYSDBA to create the database. Or, you can CONNECT / AS SYSDBA. This is the same thing. You cannot connect as SYSTEM and create the database.

5) Backups and recovery is a complex topic that requires lots of study. The simplest thing to do is to bring down the database (SHUTDOWN IMMEDIATE), then backup the file system(s) that contain the database datafiles. You can use whatever backup method you want.

Here are a few books that I would recommend for beginners. Both can be found on Oracle Press:

Oracle Complete Reference by Koch & Loney
Oracle DBA Handbook by Loney

For More Information

• Dozens more answers to tough Oracle questions from Brian Peasland are available.
• The Best Oracle Web Links: tips, tutorials, scripts, and more.
• Have an Oracle or SQL tip to offer your fellow DBAs and developers? The best tips submitted will receive a cool prize. Submit your tip today!
• Ask your technical Oracle and SQL questions -- or help out your peers by answering them -- in our live discussion forums.
• Ask the Experts yourself: Our SQL, database design, Oracle, SQL Server, DB2, metadata, object-oriented and data warehousing gurus are waiting to answer your toughest questions.