Troubleshooting Oracle Installation ORA-12154 and ORA-12169 issues

July 8, 2014, I regained Oracle, the computer was previously installed Oracle10, because to import the 11 version of the DMP table file, it is suggested that the version of the low Oracle can not import, only the version of the Oracle import version of the low-level table file, Helpless can only unload Oracle10 installed oracle11g, someone gave the oracle11xe version, that is the simple version, the first time the installation is smooth, but the use of the installation is tangled, after the installation Start menu Open command Command box, enter
Imp scott/[email protected] file=d:\nbts\zzggg.dmp full=y ignore=y (This is the import of my DMP table file)

Result error Ora-12154:tns: Unable to parse the specified connection identifier, I deliberately went to Baidu search for a long time to solve the way, have not resolved, Some said that Tnsnames.ora and Listener.ora two files configuration error, you can directly go to Oracle's installation directory to retrieve two files for direct modification, this method is not very desirable, after all, this problem and will not solve the majority of the people are like me just contact Oracle not long Novice, manual Modifying the configuration is prone to error, but the more mistakes you make in the end, the more you can only remove the reload. So a simple version like XE is easy to be successful and will be a lasting torment for beginners.

Friends to recommend the full version of the oracle11g, the installation of the time there are 4 versions, Enterprise, standard, Standard and Personal Edition, in fact, I am also very curious why there are two standard version, but I did not care about it, a start I chose a personal version, followed by Baidu search the installation process all the way down, no error, But the final installation is finished. When connecting plsql or importing DMP table files, the Ora-12154:tns: Unable to resolve the specified connection identifier error, no way I went to manually change the appeal. Two files configured, At the same time to check the registry (Start menu Search box input regedit open) and My Computer--Properties--Advanced system settings--environment variables in the path and Oracle_path values, the registry value of the lookup can be mainly in the hkey_local_machine\ Software\oracle\key_oradb11g_home2 can be viewed, and finally let me mess with this error. It's not over. ORA-12169, the net service name specified as the connection identifier is too long, because the Oracle installation does not allow you to configure the Net service name, its net service name may initially default to

Oracl_connection_data, this is the net service name that I saw in the oracle11g after installing the whole version of the net Configuration Assistant, then I did not know, silly to change Global_ NAME, the results found a little effect, but even sys this user can be logged through the Sqlplus command, and later because of the change of service name, completely confused, can only silently unload the reload.

In fact, the service name can be changed by the auxiliary software, here I first mention a wake up, do not complain about their computer configuration is too poor reason, so someone else's computer installed once, we have to debug for so long. Let me silently bask in the garbage configuration, 11 bought Asus, 4000 yuan not to start, i3 processor, 1G graphics card, 2G memory, and later added a 2G memory bar, windows7,32 bit system, alas, but in fact, the installation of Oracle personal feeling and Computer configuration is not very relevant, Look at the luck, the main Oracle installation process is not transparent, compatibility is a bit bad, but slowly debugging just. Specific auxiliary software Personal comparison recommended Netmanager, this is also Oracle full version of the ancillary software.

In this software, we can select the service name and listener, and then click on the left of the "+" sign for service naming and listener reconfiguration.

The following two pictures are my configuration data, you can see (My database Global_name and service names are ORCL, both must be consistent).

Service Naming Configuration Listener configuration

After configuration, remember to choose Save As, replace Oracle's initial installation of Tnsnames.ora and Listener.ora and Sqlnet.ora, path selection: D:\oracle\product\11.2.0\dbhome_1\ Network\admin\sample (This is the path I installed, probably everyone and I do not quite the same, you can open My computer to retrieve the file location). At the end of this may be your Oracle will still report ORA-12154 error, at this time, you can try the cmd command box input tnsping ORCL (your service name), is the situation I encountered, only a portion of the error message omitted below, if you are so, then congratulations, One more step may be successful.

This is the main reason I found myself today, not very clear whether everyone is the same as me, but like me you are lucky, because the above means that the listener's default pointing path in the above path in the admin file directory, But in that directory there is no Tnsnames.ora this file, this may be because the installation of Oracle default Tnsnames.ora and Listener.ora and Sqlnet.ora three files in the initial location in the subdirectory, the location of the wrong cause has been unable to successfully resolve your service name identifier, To copy the Tnsnames.ora to the Admin directory, and I enter tnsping ORCL again, it will be displayed like this

At this point it is your TNS file corresponding to the listener to the service name of the resolution successfully, Oracle should be able to use the normal, that is, I successfully imported the DMP table file.