Yesterday I changed the win7 system, in the database oracle 10g, it was good to start the installation, but this error always occurred during the creation of the database: ora-12546 tns permission denied. This error occurs when the database configuration assistant is used to configure the database. This problem has always plagued me, but it is the error how many times I install it. I couldn't find the information on the Internet, and finally found a solution. Here I help my colleagues who made the same mistake:
When installing Oracle in Windows 7, pay attention to the following points:
1. You must install it under the administrator user.
2. Because oracle 10g is not compatible with win7 for the moment, we can modify some files in the installation software to achieve the installation goal.
A) Open the "\ Oracle 10G \ stage \ prereq \ db" path, find the refhost. xml file, open it, add the following code to it, and save it.
<OPERATING_SYSTEM>
<VERSION VALUE="6.1"/>
</OPERATING_SYSTEM>
B) Open the "\ Oracle 10G \ install" path, find the oraparam. ini file, open it, add the following code to it and save it.
[Windows-6.1-required]
#Minimum display colours for OUI to run
MIN_DISPLAY_COLORS=256
#Minimum CPU speed required for OUI
#CPU=300
[Windows-6.1-optional]
3.right: Modify the attributes of the step.exe file as follows:
4.double-step. .exe install oracle 10g until the installation process ends.
5. According to the installation steps above, oracle may not be able to work normally. At least after I install it, my sqlplus will not work properly. In this case, permission issues are involved. The following measures can be taken to solve the problem:
A) open the path "\ oracle \ product \ 10.2.0 \ db_1 \ bin.pdf" for the installed oracle program, click the sqlplus.exe application, right-click Properties, and select compatibility, click "run this program in compatible mode", select "window xp (service pack3)", click "run this program as administrator", and click "application.
B) So sqlplus can be used normally.