Oracle 12c R2 for windows_x64 installation 1. Installation Preparation 1.1 Download Oracle for Windows version
- Official: http://www.oracle.com/technetwork/database/enterprise-edition/downloads/index.html
1.2 Unzip the ZIP archive package file
- Unzip the downloaded compressed package file to the same directory, the directory to avoid the occurrence of Chinese characters and spaces, such as a directory in the database folder, the extracted file directory structure is as follows:
2. Installation procedure 2.1 Execute Setup setup.exe
Double-click the Setup.exe executable to install and the following command prompt will appear:
Wait a moment and the following screen appears: Indicates that the software is verifying that the system configuration is in compliance with the requirements.
2.2 Configuring Security Updates
- The installation Configuration screen will then appear, remove the checkmark shown in the diagram, and click Next to continue.
2.3 Select installation Options
- Then, on the installation option prompt that appears, by default click "Next" to continue.
2.4 Select System Class
- Select the default "Desktop class" Here and click "Next" to continue. If the system is a server version, such as Windows Server, select the server version.
2.5 Creating an Oracle Administrative user
- This step is not available in other versions of Oracle for more secure management of Oracle, preventing logged-in win users from mistakenly deleting Oracle files.
Here, select the second option, create a new Windows user, enter a user name and password, create a win user that specifically manages Oracle, and then click Next.
If you select the first option, or select the second option, the following occurs: The installation cannot continue.
2.6 Typical Installation configuration
- The Oracle base directory, software location, and database file location remain the default.
- Database version Select Enterprise Edition, and the character set selects the default "UTF8".
- Password: Requires that passwords contain: Uppercase + lowercase letters + numbers.
- Tick the "Create as container database" option and click "Next".
2.7 Performing prerequisite Checks
- This step is done by itself, checking the previous configuration. Click Next.
2.8 Summary Information Confirmation
- After the previous step of the check is not a problem, the profile of the Oracle installation configuration will be generated, you can also save these configuration information to the local, easy to review later, confirm the error, click "Install"
- Note: It is best to shut down the computer's anti-virus software before installation to ensure the installation process is smooth.
- Note: Do not close the program, power off, or restart the computer during the installation process.
2.9 Installing the Product
Installation process status, the entire installation process for a long time, about half an hour, patience to wait!
Create a DB instance
2.10 Completing the Installation
- Click "Close" to complete the installation.
3. Service Configuration
- After the Oracle installation is complete, the service is registered in the system service.
- Ctrl+shift+esc Open the Task Manager and open the service options as shown in:
- Two of these services must be started, or Oracle will not work properly:
- ORACLESERVICEORCL: The primary service for the database, this service must be turned on, or Oracle cannot be used.
- Oracleoradb12home1tnslistener: The database Listener service, to connect to the server, this service must be turned on.
3.1 Net Manager configuration
- Start –> All Programs –>oracle–> Configure and migrate tools –>net manager–> Right-click –> Administrator.
- First delete the original listener to create a new listener.
- To add a listening location:
- Protocol: TCP/IP
- Host: localhost or 127.0.0.1
- Port number: 1521
- Add Database service
- Global database name: for the previous ORCL
- Oracle Home directory for Oracle product installation directory
- Save the network configuration and close it.
- At this time, my Computer –> right –> management –> service –>oracle ... Tnslistener–> reboot.
3.2 Net Configuration Assistant Configurations
With just the same, open Net Configuration Assistant.
Delete the original listening configuration first: Follow the prompts to proceed to the next step.
Then add the listening service again.
For net service configuration.
Delete the original net service configuration first.
Then execute the Delete ORCL service.
Then add the service.
To test.
Now that the Oracle installation configuration is basically complete, you can then connect to the Oracle database.
4. Access to Oracle OEM4.1 OEM Introduction
- Oracleenterprisemanager (Oracle Enterprise Manager, or OEM) provides management services for managing distributed environments through a set of Oracle programs. The OEM includes a set of DBA tools, a repository, and a graphical display console. The OEM console corresponds to the intelligent agent (intelligentagent) on each server.
- Intelligent agents can monitor specific events of the system and perform tasks (jobs) as if you were local to the system. The results of events and jobs are sent back to the console so that all systems can be managed in one place.
4.2 Login OEM
- Open Browser access: Https://localhost:5500/em
Oracle 11g is access: https://localhost:1158/em/(10g,11g default port: 1158)
Enter your username and password and click "Sign in".
The login interface looks like this:
- You can view the status of the database, the host CPU, the active session, memory, data storage, and so on.
Security-User: Enter user interface
Create user
4.3 OEM tool Group features
- The OEM Database toolset is a set of tools that enable DBAs to manage Oracle databases through the GUI interface
Tools. Includes the following tools:
- DataManager (Data Manager): This tool enables you to perform data as you would load data
Export/import.
- SchemaManager: This tool enables you to manage objects in the database. Can be used to create, repair
Change, and delete tables,indexes,views,snapshots,sequences and so on.
- SecurityManager (Security Manager): This tool enables you to manage users, roles, permissions
and profiles.
- StorageManager (Storage Manager): This tool allows you to create and modify table spaces, data files
and rollback segments.
- Instancemanager (instance Manager): This tool allows you to close, launch instances and store and
Manage database parameters.
- Sql*worksheet: This tool allows you to run or create SQL scripts and store them on your hard disk. You
You can use this tool to reproduce the last executed statement, while checking the execution results displayed to the screen.
- Backupmanager (Backup Manager): This tool allows you to manage backups and restores to Oracle7 and Oracle8 databases. In Oracle7 this tool supports Enterprisebackuputility (EBU),
In Oracle8 this tool supports recovery manager Recoverymanager.
- Softwaremanager (software Manager): This allows you to install remote software to support this feature
The remote server.
5.Oracle database access Tool with SQL Developer5.1 establishing a database connection using the SYS account
After installing Oracle 12c, it comes with a database connectivity tool, SQL Developer, which is also very powerful and has the most versatile tools Plsql Developer and Navicat. We open it:
SQL developer cannot be used to create an Oracle database, it can only be used to connect to a database that has already been created, and we typically use database Configuration Assistant (DBCA) to create databases, which is the tool shown: ( For creating a database using DBCA, this is not covered here)
The Open SQL Developer is this:
To create a database connection, click the green "+" sign at the top left corner of the connection:
- Fill in the connection information and create the connection:
5.2 Creating a new user
- SQL developer can also create new users for the database:
However, the new version of ORACLE12C adds the concept of pluggable databases, the PDB, which allows a database container (CDB) to host multiple pluggable databases (PDB). CDB is all called Containerdatabase, the Chinese translation is a database container, the PDB is all called pluggabledatabase, you can plug and unplug the database.
In CDB, you can only create a C # #或C # #开头的用户, if not c##, you will be prompted with the error "ORA-65096: Public user name or role name is invalid", only in the PDB database to create our habitual named user, Oracle called the local user, The former is called Common User.
Ordinary users of Oracle 12c must be used under the PDB, the PDB can be created by itself, or 12c comes with it.
Oracle 12c Installation and configuration
