ORA-12514 and ORA-28547 troubleshooting

ORA-12514 and ORA-28547 error fix Oracle11g full database installed, the Oracle is previously installed with the modify configuration NET Manager can be connected. But there was a small accident today. Let's summarize it here. Www.2cto.com (1) install Oracle11g Enterprise Edition in Win7. A problem occurs during installation: 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) some minor problems occurred when the Oracle Database Service was not successfully installed. 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. Start this program and you can reinstall the Database service. After the installation is complete, you can view the corresponding service items in service management. Www.2cto.com (3) After the Oracle DataBase cannot be connected and installed, PL/SQL is installed immediately. No corresponding DataBase configuration items are found when PL/SQL is started. 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: www.2cto.com # 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) (PROG RAM = 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 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: Oracle is rarely integrated at ordinary times. Yesterday I heard a friend say an Oracle problem, so I want to try it out. 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)