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

With the listening configured, we can create the database with dbca.

First of all, use vnc to link to the oracle user desktop

Set environment variabl

[oracle@oracle-learn ~] $export LANG=en_US

Start the dbca installer

[oracle@oracle-learn ~] $dbca

After startup, as shown in the figure:

Next step

Select create a database

Three different models

The first one is the default

The second one is custom.

The third is the data warehouse.

To learn to use, we choose the first one here.

Set the name of the database and sid, which is the same here, and the same as the previous environment variable setting. The previous setting is orcl.

It defaults to the next step.

Here is the password for setting up the administrator account

For the convenience of learning, we set the unified password oracle here.

The next step will be prompted that the password is simple and direct to yes.

Here is to set the data file location of Oracle. We will not change it. The next step is

Here is to set flashback and archiving, we learn, temporarily do not open.

Select Sample Schemas here there are some examples, we need to install, check it.

Here is to set sga and pga, we can temporarily set 40% in the novice learning stage.

Second tab

Here is the maximum number of processes for setting Oracle. Let's set it a little higher by 4000.

The third tab

Here is to set the character type

Generally speaking, there are two types: gbk and utf-8. We choose gbk characters.

Click next

Here we need to set the maximum number of files in the database.

The default is 100. let's change it to 4000. Next step.

To save the template and configuration file for this database creation, click finish

Save the installation parameters as shown in the figure.

Enter the installation progress interface and wait.

Installation completed

Start sqlplus under the Oracle user

[oracle@oracle-learn] $sqlplus / as sysdbaSQL*Plus: Release 11.2.0.4.0 Production on Tue Oct 30 10:52:32 2018Copyright (c) 1982, 2013, Oracle. All rights reserved.Connected to:Oracle Database 11g Enterprise Edition Release 11.2.0.4.0-64bit ProductionWith the Partitioning, OLAP, Data Mining and Real Application Testing optionsSQL >

Query the instance name of the database

SQL > select INSTANCE_NAME from vastness instance

Query database version

SQL > select * from v$version BANNER----Oracle Database 11g Enterprise Edition Release 11.2.0.4.0-64bit ProductionPL/SQL Release 11.2.0.4.0-ProductionCORE 11.2.0. 4.0 ProductionTNS for Linux: Version 11.2.0.4.0-ProductionNLSRTL Version 11.2.0.4.0-ProductionSQL >

At this point, the Oracle11.2.0.4 under linux has been installed.

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.