The first time with Oracle, this look! Although MySQL is also Oracle's.
To the official website under the Oracle G11 R2 X64, My computer is 64-bit Win7, did not open the firewall.
Follow the numerous tutorials on the Web, finish the installation, but the installation process is not so smooth, the installation of advice:
1. Unplug the network cable
2. Turn off anti-virus (including 360 of various guards)
3. Turn off Windows Protection wall
I installed the process, opened 360, was banned a lot of installation steps, resulting in to reload, let me silly eye is, Oracle's unloading mechanism is really imperfect, first of its own software after unloading, there are services (in the registry), Registry, folder (user; Program Files; Xx/app). Here recommend a unloading paste, I measured well:
Http://www.cnblogs.com/tylerdonet/archive/2009/12/24/1628725.html
Uninstalled, then restarted, after the installation, the first problem is:
The progress bar came to 85% when the helpless only point to confirm.
After the electricity is installed, but since the error, there must be a problem, the Internet to understand the next.
First, press uninstalled to configure the related listener and service:
Http://www.docin.com/p-671726385.html
Configuration complete I have encountered such an error prompt
Then, to continue to find a solution to this problem, it is important to note that the SYS user login method is not normal, and other users such as system is normal.
First found that my service power does not have the following services:
Resolved as follows:
http://www.oschina.net/question/54100_61900
When you get
Connect Username/[email protected]; If connected, this problem basically solves
Test values can also be used sqlplus to test whether the database can be logged in, you can restart the database.
The above setup is completed, you can go to the database configuration Assistant under the EM, specific steps, select the Configuration database options, follow the instructions, you can successfully configure.
After the configuration is complete, the Start menu will have a DATACONTROL-XX Web page, this is the Oracle console, click on the login, but I have a problem, I tried ie,qq browser display the page can not be displayed, the IE security level to the minimum is still not, tinkering for a long time, Thought the installation still has the problem, unexpectedly discovers colleague's computer but can log in the database (LAN), then under a Google Chrome, unexpectedly can log in, As for why, this is I cannot explain.
Down is Oracle and the classic management software PL Connected, here to explain, Oracle I installed x64 version, and PL temporarily does not support X64, so the next x86 Oracle client, after the installation is complete, you need to create the following file structure under the installation directory
. \network\bin
Then go to the copy in your X:\app\SWACK\product\11.2.0\dbhome_1\NETWORK\ADMIN directory:
Listener.ora
Sqlnet.ora
Tnsnames.ora
Three files to the. \network\bin Table of Contents
Then click on PL, will be prompted to connect, cancel out, to set the interface to do the following:
When you're done, try logging in.
Basic I met on these issues, really enough to toss, I hope this blog, let everyone less toss.
Problems encountered in the Oracle installation