About this installation of Oracle

About one weeks before and after, this afternoon (first with the navicat) when I try to put the user name above the complex option from the service name to Sid , unexpectedly connected to the success of the moment, the whole person is a B, so good?

Then I tested it again with plsql, seconds in!

Think about it, feel it is necessary to put this installation process to remember, whether it is the heart or the operation of the process, for a just into the job of small programmers, or is quite necessary!

Attached: My installation Environment Win10, ORACLE12C version 2

Start by installing Oracle First:

In fact, the first time I installed Oracal 12c success, can start from https://localhost:5500/em this page into, and later do not create any reason (now think may be later ORACLESERVICEORCL or Oracledb12home1tnslistener which one did not start) into not go, or ignorance and young, rage the installation files and compression package all deleted (also because of this has a lot of residue and registration files to stay in the computer), and then go online ah, Classmate there Ah made a few plsql, there are a few oracle11g version, installation of a mess, their own circle, and later colleagues help me also make a circle, really embarrassed! Finally after a round of disregard for the consequences of the big Delete, but also once D disk "Oracle Installation" file also deleted = =. After the Oracle related files were deleted and then a oracle12c, and then gradually clear the relationship between them, it will be a step closer to success.

Now I have several files and links to my computer:

D:Allanzhuangbao folder, which is stored directly from the Oracle official website downloaded from the 12c compressed package, and the file after the decompression (where D:\AllAnZhuangBao\Oracle12cYaSuoBao\ Database (just the installation package and decompression package) under the Setup.exe is the place to start installing databases)

After the Setup.exe is started, the "Typical installation" interface will again need to provide three addresses to hold the corresponding files, and here the three addresses are all corresponding to D:\app\ORCL (that is, Oracle's installation directory, Oracle installed in this folder), Note that at that time I only built the app file, inside empty, and the second can automatically bring out also and a system variable, but here I chose the standard version, during which I probably looked at the Enterprise version and the standard version of the difference, PC installed standard version of the line, to protect the computer hard drive can only be installed standard version.

And then the next few messy tools and "clients":

first say the Navicat: directly from the Huaming SSD installed to C:\Program Files (x86) \navicat Premium Desktop has a shortcut;

And the root of the curse. Plsql: Very simple installation package is the "Oracle installation " file of D disk, installed in the D-Disk "Instant Client" file;

First of all the installation package and the installation of the package of the relationship, and then some of the configuration path in the easy to understand the

First look at the plsql--tools--Preferences-(1) Oracle home:d:\instant client\network\admin (2) OCI library:d:\instant client\bin\oci. DLL

And by the way navicat--Tools--Options--(1) D:\Instant Client\bin\oci. DLL (2) D:\Instant Client\network\bin\sqlplus.exe

Look at the environment variable inside the (1) tns_admin value D:\Instant client\bin(2)path inside the installation automatically generated D:\app\orcl\product\12.2.0\ Dbhome_1\bin

Since then, the main configuration is almost, and then say a lot of online said (1) Configure the Tnsnames.ora file (2) and open the Net Configuration Assistant Config Image interface Things, is purely redundant and misleading

My installation process and finally gave me the understanding is: When installing oracle12c, if in the third step "installation Options" when the first "Installation and configuration Database", It will automatically help you with Tnsnames.ora related information, that is, the corresponding configuration of the corresponding graphical interface, without superfluous,

Of course, this may later be reported [INS-20802] Oracle Database Configuration Assistant failure This error, this is a good solution, skip directly, and so on after the installation is completed and then left to open the database Configuration Assistant, in accordance with the requirements of the installation of re-install once, the inside of the path and related information is corresponding to your Tnsnames.ora file and graphical interface;

It is also possible to encounter the error of saying path path exceeds the maximum length , this word first put the environment variable under the path path part of the contents of the copy, and then re-install Oracle once, installed after the environment variable to remember the copy to add path on the good!

There's one more mistake. Failed to set ACL's for specified User. This I was jumping directly, and now there is no big deal, when the doubt will not open with me now Https://localhost:5500/em page will not be about , it should be okay!

And look at the connection information for Navicate.

Connection name seems to be fixed, the rest are based on the Database configuration Assistant inside the relevant! Of course, the following are the most common mistakes encountered

Oracleoradb10g_home1tnslistener:
The service corresponds to%oracle_hoem\bin Tnslsnr. EXE
If the service is not started, or is not configured correctly (not normally installed), it will cause Oracle error-ora-12514:tns: No listening program。
oracleserviceoracle:
If the service is not started, it will cause Oracle error-Ora-12514:tns: The listener currently does not recognize the requested service in the link descriptor.
However, this error can also be caused by starting the service. (also said to change Tnsnames.ora file, but I just like the beginning of said, change from the service name to Sid is OK!) ) Finally, attach someDownload Instructions:1, oracle12c official website download Not much said, just to mention with Google can translate the powerful from the place, a variety of documents such as watching Chinese network!! 2, how to uninstall Oracle after clean-up related registry and residue, see another reprint, other installation files can also refer to, really clean 3, some installation of Oracle common errors, I just said the second time I installed ORACLE12C encountered three, the rest can also be consulted, Also see another article reproduced

About this installation of Oracle