Chapter 4

Creating Your Database

In This Chapter

arrow Familiarizing yourself with the Oracle environment

arrow Configuring an Instance

arrow Using the Database Configuration Assistant to create databases

arrow Post database creation checkup

Creating a database takes a lot of work. Thankfully, a graphical tool called the Database Configuration Assistant (DBCA) helps you point and click your way to victory. However, as its name implies, it only assists. Just like any software wizard-type tool, it can’t cover every option; it can’t explain everything. It does cover up some of the ugly syntax and other required activities (like creating directories and setting permissions) commonly forgotten by someone new to Oracle. It truly is a wonderful tool . . . as long as you know what options to use and what values are appropriate for the questions that it asks you.

With that said, this chapter goes over some of the details necessary to make the right decisions up front when creating a database. Doing so saves you from having to go back and do things twice . . . or even three times. In addition, when you understand ...

Get Oracle® 12c For Dummies® now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.