Download Oracle 12c For Windows 10 64 Bit UPDATED
Download Oracle 12c For Windows 10 64 Bit
1- Introduction
This document is based on:
- Oracle 12c R1 (Release 1) (64 fleck)
- Window Server 2012 (64 bit)
2- Download Oracle 12c
Oracleallows y'all to freely download. Y'all can access the dwelling house page of Oracle to download this software.
Delight check whether your operating system is 32 bit or 64 bit to download exactly.
After finishing downloading, y'all have 2 zip files. Decompress them in the same folder.
iii- The difference in structure of Oracle 11g and Oracle 12c:
The structure of Oracle includes:
- Oracle software
- And Databases
Oracle 11g and Oracle 12c have some differences in structure. Nosotros need to clarify these differences before starting to install.
ORACLE 11G
After installingOracle Database 11g software, yous tin can create ane or more Database (Typically, y'all need to create only 1 Database). In each Database, you lot can create one or many SCHEMAs. Each SCHEMA is a system of tabular array and objects like functions, procedure, package, and so on. The structure ofOracle 11g is like to the following illustrative image:
ORACLE 12C
Oracle 12c has existent changes in structure compared toOracle 11g.Oracle 12c is actually a deject database.
The definition of database in 11g is like to that ofContainer Database (CDB) in 12c. Especially, after installingOracle 12c you tin create one or moreContainer Database (CDB). (In fact, 1 is plenty).
InOracle 12c, there is a new concept which isCDB$ROOT (or CDB Root).CDB$Root is a specialPlugin Database and is a object ofCDB. SCHEMAs tin be attached withCDB$ROOT or other typicalPlugin Databases (PDB) are attached withCDB$ROOT. EachPlugin Database contain 0 or many SCHEMAs.
During the process of installingOracle 12C, the installing set up will ask whether you create a Plugin or not. In that location will be two situations as follow:
- If yous select not to create plugin, the installing set will create aContainer Database with Root and SCHEMAs attached with Root.
- If yous select to create plugin, you lot demand to enter name of plugin. The installing set will create aContainer Database with Root, a Plugin attached with Root, and SCHEMAs attached with this Plugin.
iv- Installing Oracle 12c on Windows
We volition install Oracle software and immediately create a Database named as db12c (or SID = db12c).
Install a database:
Oracle will be install in a user of window, but this user has no right of an Ambassador for the reason of security. If your calculator has no such a window user, you can create a new window user.
In this stride, if the installer asks whether yous create Plugin or not, select:
- Create equally Container Database.
Enter name of Plugin Database:
- pdbdb12c
If you select"Create as Container Database" your database model is like to the following illustrative epitome:
Notation: Organisation, SYS Schema is always available when you create Container Database or Plugin Database.
Note: Arrangement, SYS Schema is always bachelor when you createContainer Database or Plugin Database.
To store many kinds of linguistic communication (including Vietnamese), you lot should select:
- Character Set: Unicode (AL32UTF8)
Oracle has some users administrating the organisation (sys, organization,...). You need to prepare passwords for them. You can ready the same password for all of these users.
And look until the installation is complete.
In the next step, the installer will create Database named as db12c similar the previous step where we named.
At present the installment of Oracle is successful. Parameters relating to database will be synthesized, and you should think this information.
five- Check the installation and install the expansion
Later the successful installation, services of Oracle are automatically started. We tin can access to Service of Windows to bank check.
There are 6 services of Oracle, merely usually three services are plenty for the performance:
- OracleOraDB12Home1TNSListener
- OracleServiceDB12C
- OracleVssWriterDB12C
5.1- SQL Plus
SQL Plus is a elementary Console tool that allows you to execute SQL command. Usually, we work with a more visual tool (It is unavailable when y'all install Oracle) that you lot need to install additionally. It tin can be software provided by a third party.
Чтобы войти в SQL Plus, вы можете войти в систему через CMD:
Login to organization schema:
Recheck the Database model yous have installed:
SYSTEM, SYS is a schema of the system. Information technology is automatically created when you lot createContainer Database. Enterarrangement/<password> and you can log in schema system of Container. system, sys schema are also available when you create aPlugin Database.
Check which container you lot are standing:
Standing at Container Database, you can query so as to know the current number of Plugin Database.
SELECT proper noun, pdb FROM v$services Lodge BY name; 
You are standing at the CDB$ROOT, you want to create a SCHEMA:
Note: When you create a user in Oracle, a Scheme with the respective proper name would be created.
Create a User database:
-- Create a user database named mytest, and password mytest001 create user mytest identified by mytest001; -- Grant Database Admin to mytest. grant dba to mytest; Annotation that with Oracle 12c or subsequently, the default name of 'user database' must begin past C## , C or ## , the opposite will be the error message ORA-65096.
ORA-65096: invalid mutual user or role name Cause: An attempt was fabricated to create a mutual user or office with a proper noun that was not valid for common users or roles. In add-on to the usual rules for user and role names, mutual user and function names must start with C## or c## and consist only of ASCII characters. Activity: Specify a valid common user or function proper name.
When you create a user database, you need to fix value for subconscious parameter "_oracle_script"=truthful
-- Login with system user. connect system/Abc#123 alter session gear up "_ORACLE_SCRIPT"=true; -- Create user database named mytest, and password mytest001 create user mytest identified by mytest001; -- Grant Database Admin to mytest. grant dba to mytest; -- Connect to mytest connect mytest/mytest001 
You can find more instructions relating to creating a user database, connecting to the plugin database ... and the cloud features inOracle Database 12c at:
6- Visual tools to piece of work with Oracle
See more:
DOWNLOAD HERE
Posted by: yarbroughthationeath.blogspot.com
