ORA-12514 and ORA-28547 error Solutions

The entire Oracle database is installed with Oracle11g. In the past, the NET Manager can be connected after being installed and configured in Oracle. But there was a small accident today. Let's summarize it here.

(1) Installation check Problems
To install Oracle11g Enterprise Edition in Win7, a problem occurs during installation:Copy codeThe Code is 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 cocould not be determined. -Action: Ensure that the environment variable is 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, the environment variable Path in windows is too configured, right-click my computer-> advanced-> environment variable, find Path, remove unnecessary parts. Check again and continue the installation.
(2) The Oracle Database Service is not successfully installed.
Some minor problems occurred during the installation process. The system reports an error saying that the corresponding template file is missing, which is strange. However, you know about Oracle. It is a big problem to cancel the installation and re-installation, and it is not very familiar with the Oracle structure. Therefore, I will ignore the installation problems. However, it is found that the Oracle database service is not installed after the installation is complete. Unfortunately, the installation cannot be used.
There is a Database Configuration Assistant in Oracle11g.
Pic
Start this program to reinstall the database service. After the installation is complete, you can view the corresponding service items in service management.
(3) Oracle database cannot be connected
After the installation is complete, PL/SQL is immediately installed, and no corresponding DataBase configuration items are found in start PL/SQL. As a result, the client connection is configured in the NET Manager, and PL/SQL is re-opened, there is no corresponding configuration connection item.
Log on to the SQLPlus command line and use the password set during installation to log on. The problem is very strange.
The problem should still be considered in the client configuration. There is no problem with SQLPLUS logon, indicating that the service is normal. In the process of login error ORA-12514 and ORA-28547, online search is still the same problem are said. NET Manager configuration problems, but I have modified it and still cannot log on, nor can I restart it. Find the file to connect to the listener in the NET Manager according to the instructions on the Internet. The file directory is as follows: \ Administrator \ product \ 11.2.0 \ dbhome_1 \ NETWORK \ ADMIN \ listener. ora. Open this file with UE:Copy codeThe Code is 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 \ lrlr11.dll ")
)
)
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC) (KEY = EXTPROC1521 ))
(ADDRESS = (PROTOCOL = TCP) (HOST = localhost) (PORT = 1521 ))
)
)
ADR_BASE_LISTENER = D: \ Oracle11g \ Administrator

In the file, we found that SID_NAME = CLREXTPROC. My service ID is not this but leroot, and SID is actually the global database name. I changed it to OracleRoot and restarted the listening service. The connection still failed. So I deleted the PROGRAM = extproc in the appeal file and saved the file. Restart the service and the connection is successful.
Summary:
At ordinary times, Oracle is rarely integrated. Yesterday I heard a friend say an Oracle problem, so I want to try the installation. As a result, there were so many problems during the installation. Many people chose to step down and choose not to install the software when installing the software, in fact, the mentality of trying to solve the problem is very important, especially those who are highly interested in programming. Think about the solution, and the problem will always be solved. (The homepage will not be posted if the document is not accurate. I hope it will help you)