How to Create a database at oracle11g

Recently, I tried to write a project on the oracle11g database creation method, but I couldn't help it. Because I have never used Oracle data development before, And I used everything in the cloud, seeing that the theoretical knowledge is useless, we can only use hands-on practices to create the value of ourselves. We will continue to explore and study it with the help of the Internet. There are two methods to create a database in Oracle. The first is to use the Oracle database creation tool DBCA, which is a graphical interface tool that is easy to use and easy to understand, because of its friendly interface, beautiful appearance, and complete prompts. In Windows, this tool can be opened in the Oracle program group ("START"-"program"-"Oracle-OraDb10g_home1"-"Configuration and Migration Tools"-"Database Configuration Assistant "), you can also directly enter dbca in the command line ("START"-"run"-"cmd") tool. Another method is to create a database manually. I will illustrate it one by one. Manual creation of manual databases is indeed troublesome, but it is necessary for developers or professional DBAs. Only in this way can you better master Oracle knowledge. Next, let's take a step-by-step exploration. Several steps are required to manually create a database. Each step is critical. It includes: 1. create necessary directories; 2. Create initialization parameter files; 3. Set the environment variable Oracle_sid; 4. Create an instance; 5. Create a password file; 6. Start the database to nomount (instance) status 7. Execute the database creation script 8. Execute the catalog script to create a data dictionary 9. Execute catproc to create a package 10. Execute pupbld 11. Create a spfile file from the initialization parameter file 12. Execute the scott script to create scott mode I work on the platform Experimental System Platform: windows 7 Database System Version: Oracle Database 11G Oracle installation path: the name of the Database created by disk D: book 1. create related directories. create folders under the installation directory: D: \ product \ 11.1.0 \ db_1 \ admin \ book at D: \ product \ 11.1.0 \ db_1 \ admin \ book, create five folders: arch, bdump, and cdump, Create, udump. at the same time, you can create the Directory D: \ product \ 11.1.0 \ db_1 \ oradata \ book in the Windows GUI, the sub-directories in the book directory are mainly used to store tracking information during database operation. The two most important subdirectories are the bdump and udump directories. The bdump directory stores the tracking information of various background processes in the database running process. The alert file is a warning file, and its name is alert_book.log, when a problem occurs in the database, you can first view the file to find out the cause. You can also find the cause of various problems during manual creation. The udump directory stores trace information related to a specific session. 2. When creating the initialization parameter file database system, you must use the initialization parameter file settings to allocate memory and start necessary background processes. Therefore, whether the initialization parameter file is created correctly or whether the parameter settings are correct is related to the "fate" of the entire database ". You can create an initialization parameter file by copying an existing initialization parameter file and modifying it as appropriate, so you do not have to write it out in one sentence manually, because the structure of the initialization parameter file is basically the same. When we install Oracle, the system has installed a database named orcl for us, so we can get an initialization parameter file from it.