Shulou(Shulou.com)06/01 Report--

This blog is mainly aimed at novice database creation tutorials, so it is more detailed and verbose. In this paper, the creation of the database is divided into three steps: the first step is to install the Oracle database software; the second step is to create a new database listening in netca; the third step is to create a database instance in dbca; the operating system uses windows 2008 R2 64-bit, and the database version uses Oracle 11.2.0.4 64-bit.

Oracle official download 11.2.0.4 database installation package: p13390677_112040_MSWIN-x86-64_1of7.zip, p13390677_112040_MSWIN-x86-64_2of7.zip

When decompressing, pay attention to decompression one by one to avoid decompression errors. Extract the first compressed package first.

When extracting the second unzipped package, be careful to extract it to the first folder.

Set the hosts hostname to correspond to IP (the hostname is used by default when registering snooping later. If it is not specified, there may be problems when accessing across IP address ranges)

Install the Oracle Database program

Select setup.exe in the unzipped folder to run the installer. Formal environments generally cannot connect to the public network, so you can uncheck to accept security updates through My Oracle Support.

It is generally impossible to connect to the Internet in a formal environment, so you can skip software updates directly.

If you select create and configure Database, a database instance orcl is created by default, but the default database instance has many parameters that cannot be configured during installation. So here we choose to install only the data software.

Our test is to install single-node single-instance database, so we choose single-instance database installation here.

Just choose the default product language

Choose the enterprise version with the most complete functions

Here, select the installation path and select the disk with plenty of remaining space. If you need to change the path, only change the drive letter as far as possible. Note: if there is Chinese in the installation path, it is recommended to change it. For example, it will be displayed as C:\ app\ Zhan Kangying in the path and changed to C:\ app\ zky. Or you'll make a mistake.

This is a summary of the above configuration. If you see any errors in the settings, you can go back and reset them. After completing the configuration, you can choose to install.

Here, the database software will be installed.

Configure Listener

Database monitoring is the premise to ensure that the client can establish a connection with the database server, but the client connects to the database instance and registers the database instance to the monitoring. In general, when listening is enabled, the PMON process will dynamically register the database instance information with the monitor when the database instance is started. When the database instance is shut down, the PMON process automatically removes the current instance information from the listener again.

Open windows to run, enter netca, and select listener configuration

Select add

Configure the listener name and keep it by default

Select the protocol and tcp will be fine

Select the listening port number. If there is no special requirement, you can keep 1521 by default.

When the configuration is complete, you do not need to configure the next monitor. Select No by default. Click next.

Then directly select the next step.

Select finish, and the configuration of monitoring will be completed here.

It is normal to use lsnrctl status to check the listening status in cmd, and we can see that the database is listening by default to the hostname.

Create a new Oracle instance

Use windows to run dbca to create a database instance

Choose to create a database

Select a general purpose or transaction template

Configure the database instance name to keep the upper and lower names consistent. Here I use zhanky as the test.

If you don't know how to install oem, it also consumes performance, so you can choose to cancel OEM here. Automatic maintenance tasks can be kept by default

Configure the user name and password, which is the same administrative password for convenience. Set the password to oracle_4U. If the password does not meet the complexity, you can just ignore the confirmation.

This refers to the storage location of the data file, which can be kept by default.

Here, the recovery area is also kept by default, and the archive log is kept by default. (however, it is recommended to enable it, but not for non-Oracle professionals, as it may lead to database downtime due to full archive logs.)

The sample scheme and custom script can be ignored directly here. If you are a friend who built your own local learning database, you can check the example scheme.

Here is the opposite important place, set up memory, 11G here you can directly use automatic memory management. Then the memory is configured as needed. Then configure Resize

What is set here is the maximum number of user processes that connect to the database at the same time. It is recommended to set it according to the user size. If it is too small, the client cannot connect to the database. Next, configure the character set.

The most important guarantee is that the default character set is ZHS16GBK-GBK 16-bit simplified Chinese (you don't need to be exactly like me here, you can configure it according to your actual environment. Misconfiguration here will lead to data garbled)

Here is a summary of the important file storage locations in the above configuration

Make sure to create the database and click finish.

Here are the details of creating the database instance. Once you have selected it, you can start installing the database.

Warm Tip: because there are visitors in the win10 system installed here is not directly completed, but reported an error ora-28000, and then Baidu error is the problem of the password, and then the reconstruction of the password complexity will still report an error. At this time, there may be a permission problem, after installing the database software, the user should be in the ora_dba group, but some systems are not automatically added to the group after installation, so it is easy to have all kinds of problems. Solution: open the computer management → local users and groups → groups → find the ora_dba group and join the current user to the group

The following prompt will be given after you have finished creating the database instance. Just choose to exit.

Verify the created database

After the creation is completed, check the listening again and see that the instance zhanky we created has been registered with the instance.

Then use sqlplus system/oracle_4U@zhanky to log in to our database (using a user name and password to log in to the server remotely). In the figure, you can see that we log in normally, which means that the database and network services are normal.

At this point, you have completed the creation of the database server. If you have any questions, you can leave a message. I will update my blog later.

Link to my blog home page: https://blog.51cto.com/zhanky

My blog article directory: https://blog.51cto.com/zhanky/2354798

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.