Smudge Oracle Note 1-Create a database and configure listeners

I. Installation of Oracle database software
Oltp:online Transaction Processing
Refers to the database system with short transactions, high concurrency, and frequent read and write. --db_block_size is usually set to a smaller size.
Olap:online Analysis Processing
Refers to a database system that handles long transactions, low concurrency, and read-less writing. ---db_block_size are usually set to a larger size, such as 32K.

Asm:automatic Storage Management
Automatic storage Management system, a storage management system independent of the operating system, can not see the stored data directly through the operating system.

Raw Device: Bare devices
A storage device without a file system. such as the new hard disk, no partition or no partition, no formatting is directly attached to the operating system to use.

Oracle data File Default storage location: $Oracle _base\oradata\sid_name\ Directory

Omf:oracle Manage File
Oracle management files, when creating a database if you choose that file path, you do not need to specify a location and file name when creating a tablespace data file, control file, or log file. Oracle automatically sets the settings based on some initialization parameters
Assignments and commands, usually in conjunction with ASM.

Initialization of memory parameters during Oracle installation:
If there is no special purpose general choice Typical or custom automatic management memory.
SGA corresponding parameter: sga_target PGA corresponding parameter: pga_target
For the relationship between SGA,PGA and system memory, there is a relatively common calculation rule:
For OLTP databases, sga= system memory X70%x80%,pga=sgax (10%~20%)
For OLAP databases, sga= system memory x80%x60%, Pag=sgax (45%~65%)
For the 32bit platform, the SGA has a maximum available memory of 1.7GB by default.
Shared pool: Used to store library caches, compiled Sql,plsql, and more. Typically 300 to 500MB, corresponding initialization parameters: Shared_pool_size
Buffer cache: Data from the database is read from the hard disk here, the higher the value the better, the corresponding parameter: db_cache_size
Java pool: If the database does not have java_procedure or the ORACLE_JVM component is not selected, the value can be set to 0, which generally does not need to be set too large, corresponding parameters Java_pool_size
Large pools: Mainly used for direct path import and export, Rman backup, and so on. The general setting is 100 to 200MB, corresponding parameter: large_pool_size

Specify the database character set:
General selection Select from the list of character sets--->zhs16gbk-gbk15 bit Simplified Chinese. Otherwise, garbled characters may occur.

Dedicated server
Each user process connected to the Oracle database has a dedicated server process that serves it until the user process disconnects. Each process is independent of each other and does not affect each other. This model is more suitable for OLAP systems, where a small number of users
Connected, long-running applications.
Shared server
means that Oracle always maintains a certain number of server processes, and the user process connects to a scheduling process that is first connected to the server, which is assigned a server process by the scheduling process so that only a small number of server processes can provide a large number of user processes
Service. This mode is more suitable for OLTP systems. such as the high concurrency of the site, the need for large traffic, the server can not provide too many processes for the connection. In fact, there are middleware in large applications to provide separate connection pooling services, so most of them choose
Use server mode.

Second, configuration monitoring
1. Create a new listener program
Windows directly opens the Net Configguration Assistant tool in the program to configure
-------Listener Listener is created, a new listening service entry is automatically created in Service Manager and started automatically.
Linux environment with root login GUI, switch to Oracle user, execute NETCA, can bring up net configguration Assistant

2. Configuring the monitoring service with Net Manager
That is, configure which database instances the listener should listen to.
Windows directly opens the Net Manager tool in the program to configure
Linux environment with root login GUI, switch to Oracle user, execute Netmgr, can bring up Net Manager tool

The path of the listening file
$ORACLE _home\network\admin\listener.ora
# Tnsnames.ora Network Configuration File:d:\app\administrator\product\11.2.0\dbhome_1\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.
Rusky =
(DESCRIPTION =
(Address_list =
(ADDRESS = (PROTOCOL = TCP) (HOST = ultrapower) (PORT = 1521))
)
(Connect_data =
(service_name = ORCL)
)
)

3, the start and stop monitoring
Windows can start and stop the corresponding service directly.
Linux environment and Windowscmd interface available for listening command: Lsnrctl stop/start/status

Smudge Oracle Note 1-CREATE DATABASE and configure listeners