A full database of oracle11g was installed, and Oracle was previously installed to modify the configuration Net Manager to connect. But there was a little accident today, summed up here.
(i) Problem of installation inspection
Installing the ORACLE11G Enterprise Edition in Win7, a problem occurs during installation:
Copy Code code as follows:
Environment variable: "Path"-this test checks whether the length of the environment variable ' path ' does not exceed the Recommended length.
Expected value
: 1023
Actual value
: 0
Error List:
-prvf-3916:environment variable name ' PATH ' is ' not ' set on node ' ywl-pc '-cause:environment variable value could not B E determined. -Action:ensure that the environment variable are set and access permissions for the Oracle user allow access to read the Environment variables. Restart the installer after correcting the setting for environment variable.
Google a bit, the original Windows System environment variable path configuration too much, right click on My Computer->-"Environment variables, find path, some of the unused parts can be removed." Re-test completed by continuing the installation.
(2) Oracle database service not installed successfully
There are some small problems in the installation process, the system error said that the lack of the corresponding template files, it is strange. But oracle you know, canceling the installation again and again the problem is large, and the structure of the Oracle itself is not very understanding, so the installation problems I directly ignored. However, it was found that the installation did not install Oracle database services, the tragedy of the installation, installation is not used.
There is a database Configuration Assistant in the oracle11g.
Pic
When you start this program, you can reinstall the database service. After the installation is complete, you can see the corresponding service items in service management.
(3) Oracle database cannot connect
After the installation is complete, the Pl/sql is installed immediately, and the corresponding database configuration entry is not found in the boot pl/sql. The client connection is then configured in Net Manager, and the Pl/sql still does not have a corresponding configuration connection entry.
It is strange that you log on at the sqlplus command line and login with the password you set when you install it.
Consider whether the problem should still be in the client configuration, there is no problem with the login in Sqlplus, indicating that there is no problem with the service. In the process of logging in the error ORA-12514 and ORA-28547, search on the internet is still the same problem is to say. NET manager configuration issues, but I have not changed the login, restart also not. Then, according to the instructions on the Web, find the file connected to the monitor in Net Manager. The file directory is as follows: \administrator\product\11.2.0\dbhome_1\network\admin\listener.ora. Open this file with UE:
Copy Code code as follows:
# Listener.ora Network Configuration file:d:\oracle11g\administrator\product\11.2.0\dbhome_1\network\admin\ Listener.ora
# Generated by Oracle configuration tools.
Sid_list_listener =
(Sid_list =
(Sid_desc =
(Sid_name = Clrextproc)
(Oracle_home = D:\Oracle11g\Administrator\product\11.2.0\dbhome_1)
(program = Extproc)
(Envs = "Extproc_dlls=only:d:\oracle11g\administrator\product\11.2.0\dbhome_1\bin\oraclr11.dll")
)
)
LISTENER =
(Description_list =
(DESCRIPTION =
(address = (PROTOCOL = IPC) (KEY = EXTPROC1521))
(address = (PROTOCOL = TCP) (HOST = localhost) (PORT = 1521))
)
)
Adr_base_listener = D:\Oracle11g\Administrator
Found in the file Sid_name=clrextproc my service ID name is not this but oracleroot,sid is actually the global database name. I modified it to oracleroot, restarted the listening service, and the connection still failed. So I delete the Program=extproc in the appeal file. Save File Restart service that connection is successful.
Summary:
Usually very few Oracle, yesterday listen to a friend said an Oracle problem and then install want to try. As a result of installation there are so many problems, many people in the installation of software when the problem has chosen to regress does not install, in fact, efforts to solve the problem of the mentality is very important especially for the people who have a high interest in doing the procedure. If you think about the solution, the problem will always be solved. (The article does not have any standard not to send the homepage, hoped to have the help to everybody)
