ORA 12514 and ORA 28547 error solutions

  • 2021-01-03 21:08:12
  • OfStack

The Oracle11g database is installed, before Oracle is installed and modified configuration NET Manager can be connected. But there was a little accident today. Here is the summary.

(1) Problems of installation inspection
When installing Oracle11g Enterprise edition in Win7, one problem occurred during the installation process:
Environment variable: "PATH" - This test checks whether the length of the environment variable "PATH" does not exceed the recommended length. 
 The expected value  
: 1023 
 The actual value  
: 0 
 Error list : 
- PRVF-3916 : Environment variable name "PATH" is not set on node "ywl-PC" - Cause: Environment variable value could 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 1, windows system environment variable Path configuration too much, right click on my computer - > Advanced - > environment variable, find Path, get rid of 1 some unused parts. Retesting is completed by continuing the installation.
(2) Oracle database service was not installed successfully
During the installation process, there was a small problem. The system reported that the corresponding template file was missing, which was very strange. But Oracle, as you know, canceling the installation and starting again is a big problem, and I don't know much about the structure of Oracle itself, so I just ignore the installation problems. However, it was found that Oracle database service was not installed after the installation was completed. The installation was tragic and could not be used.
There is 1 Database Configuration Assistant in Oracle11g.
Start this program and you can reinstall the database service. After the installation is complete, you can see the corresponding service items in service management.
(3) THE Oracle database cannot be connected
After the installation was complete, PL/SQL was installed immediately, and no corresponding DataBase configuration item was found when starting PL/SQL. Then configure the client connection in NET Manager again. Reopen PL/SQL and still have no corresponding configured connection item.
Log in from the SQLPlus command line and log in with the password you set at the time of installation, and the problem is quite bizarre.
Consider that the problem should still be in the client configuration, and there is no problem with the login in SQLPLUS, indicating that there is no problem with the service. During the login process, errors occurred in ORA-12514 and ORA-28547, and the same problem was found when I searched online. The configuration problem of NET Manager was still not logged in, but I modified it, and the restart was also not ok. Then according to the instructions on the Internet to find NET Manager connection listening file. File directory :\Administrator\product\11.2.0\dbhome_1\ ADMIN\ listener.ora. Open this file with UE:
# listener.ora Network Configuration File: D:\Oracle11g\Administrator\product\11.2.0\dbhome_1\network\admin\listener.ora 
# Generated by Oracle configuration tools. 
(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") 
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521)) 
ADR_BASE_LISTENER = D:\Oracle11g\Administrator 

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, but the connection still failed. So I delete PROGRAM=extproc in the appeal file save the file and restart the service and the connection is successful.
Oracle is seldom fixed at ordinary times. Yesterday, I heard a friend said that there was a problem with Oracle, so I wanted to try the installation. As a result, there are so many problems in the installation. Many people choose to step back and not install when there are problems in the installation of software. In fact, the mentality of trying to solve problems is very important, especially for those who have a noble interest in making programs. Think of a solution. The problem will always be solved. (Article does not have what level not to send home page, hope to be helpful to everyone)

Related articles: