Resolving INS-20802: Oracle Net Configuration Assistant failed error on Windows 10
I was all excited about the migration to Windows 10 until I had to install Oracle client 12.1.0.2 on it. The Oracle client installation used to fail miserably at the last stage with this error named INS-20802.
As with several Oracle error messages, the details were hardly of any use and no clear understanding was possible even after examining the error log. Googling for the error led me to several forum posts but most of them didn’t have the right solution — most answer seekers were meeting with dead ends.
I tried several methods for resolving the issue —
- Disabling Windows UAC
- Disabling firewall
- Disabling antivirus — mine was a fresh VM, so disabled Windows Defender
- Adding localhost IP i.e., 127.0.0.1 to the hosts file etc.
but none of them helped.
Popular posts from this blog
I am someone who is particular about power savings and I don’t leave appliances powered on when not in use. The same applies to computing devices — be it a smartphone or a PC/Laptop. I power off the desktop monitor when I step out for a tea break or hit Fn+F2 on my Lenovo laptop that turns off the display. Recently, I got a Dell Laptop and I was surprised to discover that Dell does not provide any shortcut to turn off the display. This led to some exploration and I found two ways to achieve that which are outlined below —
Is your primary OS at home Linux and do you use Windows only to connect to your work PC over VPN or to attend meetings? Do you often wish to connect to your work VPN from a Linux PC? If your answer is ‘Yes’ to the above questions, I have an answer if your workplace uses Fortinet SSL VPN. Note that it’s possible to connect to Fortinet and other VPNs like Cisco VPN from Linux through the inbuilt network manager by installing additional tools but this post would focus on using the standard Forticlient for accessing the resources on your work network. Obtaining Forticlient The most important thing to note w.r.t. using Forticlient for Ubuntu (or any Linux distro) is to note that the client is not publicly available for download from the official website. You will have to ask your IT department to download the client for you, in case they haven’t provided it.
Databases
-
All things Oracle Database, incuding Autonomous, DB Systems, Exadata, Data Safe, GoldenGate, Multilingual Engine
222.6k Posts
1.1m Comments
-
Develop server-side Java applications that take advantage of the scalability and performance of Oracle Database.
-
All things MySQL and MySQL HeatWave, on Oracle Cloud or anywhere else it runs.
-
Flexible, non-relational database that can accommodate a wide variety of data models
-
Oracle REST Data Services (ORDS) makes it easy to develop modern REST interfaces for relational data in the Oracle Database and now, with ORDS 3.0, the Oracle Database 12c JSON Document Store and Oracle NoSQL Database. ORDS is available both as an Oracle Database Cloud Service and on premise.
3.2k Posts
10.0k Comments
-
The community-supported edition of the Oracle Database family
7.9k Posts
30.8k Comments
-
All about relational database languages, queries, and extensions.
188.0k Posts
1.0m Comments
-
SQL Developer, SQL Developer Data Modeler, SQLcl
26.1k Posts
86.4k Comments
-
A family of embedded key-value database libraries providing scalable high-performance data management services to applications.
6.7k Posts
21.9k Comments
Development
-
APEX is Oracle’s strategic low-code application platform used by customers across every industry and geography.
126.5k Posts
458.7k Comments
-
Wide-ranging discussion on all things about developing software and implementing solutions on Oracle Cloud
-
Using your favorite frameworks and languages to build your apps on and with Oracle Cloud
-
Wiring up your development environment and deployment pipelines to Oracle Cloud, and more.
168.5k Posts
448.3k Comments
-
OCI API, CLI & SDK, plus automations like Ansible and Terraform
-
Create web and mobile apps directly from your browser in a visual environment.
-
Keeping track of your assets. Includes Oracle Content Management, formerly known as Oracle Content and Experience.
-
General discussion of open source software, including Oracle’s open source projects.
Data and Analytics
-
Data Science, Data Labeling, models and model training, data science & machine learning development
-
Big Data Service & Big Data Appliance, Data Catalog, Data Integration, Data Flow
-
OCI AI Language, Speech, Vision, Anomaly Detection Services; Oracle Digital Assistant
-
Media Flow & Media Streams
-
A scalable and secure Oracle Cloud service that provides a full set of capabilities to explore and perform collaborative analytics.
Data Integration
-
4.9k Posts
18.9k Comments
Cloud Infrastructure
-
Whether you’re building something giant, or just aren’t quite sure where to start, come in here for broad discussions about all things Cloud!
-
Bare metal and virtual machines, instance configuration, pools, clusters, and auto-sacling including HPC and GPU.
-
Oracle Linux? Ubuntu? Rocky Linux? Windows? VMWare? Come talk about your cloud operating systems and how to manage them.
-
Block storage, file storage, object & archive storage, along with volume groups and backup policies
-
Virtual Cloud Networks & Load Balancers, Virtual Network Appliances
-
Site-to-Site VPN, FastConnect, Dynamic Routing Gateway, DNS Management, IP Management & Network Command Center
-
Containers, Kubernetes clusters (OKE), registry, artifacts, Serverless Functions, GraalVM, Verrazzano, Cluster API, Service Mesh, API Gateway
-
Users, groups, policies, federation, compartments, authentication.
-
Cloud Guard, Security Advisor, Security Zones, Web Application Firewall, Scanning, Vault, Bastion, Compliance & Audit
-
Application performance monitoring, logging & log analytics, events, monitoring, operational insights, management agent
-
AWS? Azure? GCP? OCI? Running your workloads across multiple vendor’s cloud environments.
-
Cost analysis, cost management, budgets, rewards programs, account & tenancy management, organizations & licenses
-
Running prepared Oracle and third-party applications
Java
-
The standard in community-driven enterprise software developed using the Java Community Process.
165.4k Posts
431.8k Comments
-
Accessing your databases from a Java client application.
37.0k Posts
108.5k Comments
-
Develop highly functional, reliable, and portable applications for today’s most powerful embedded systems
8.1k Posts
24.2k Comments
-
22.1k Posts
74.7k Comments
-
Creating standard technical specifications for Java technology, together.
-
Your favorite Java IDEs and Frameworks to help you create and deploy your Java applications.
138.3k Posts
423.0k Comments
-
Oracle’s implementation of the JVM
13.8k Posts
40.8k Comments
-
Writing applications in the Java programming language
86.4k Posts
467.0k Comments
-
Create and deploy portable code for desktop and server enbironments
94.3k Posts
275.0k Comments
-
Cryptography, public key infrastructure, secure communication, authentication, access control, and more.
13.8k Posts
37.3k Comments
-
Java User Groups (JUGs) are volunteer organizations that strive to distribute Java-related knowledge around the world. They provide a meeting place for Java users to get information, share resources and solutions, increase networking, expand Java Technology expertise, and above all, drink beer, eat pizza and have fun. The JUG Community is the meeting point for JUGs, helping promote the expansion of the worldwide Java Community
-
Just getting started? We’re here to help!
65.1k Posts
401.5k Comments
-
Developing JEE applications has never been so easy. Please use this forum to ask questions, give feedback, share experiences, report problems and request product/documentation enhancements for Oracle JHeadstart.
Learning & Certification
-
Deepen your knowledge of Oracle Cloud with training and certification.
-
Develop in-demand programming skills with comprehensive training on the latest Java technology.
-
Get hands-on with Oracle technologies at your own pace.
Oracle Applications
-
Deliver insurance solutions and digital customer experiences that build your customers’ confidence and loyalty with an insurance management system.
-
Formerly Oracle Policy Automation, decision automation software products for modeling and deploying business rules within the enterprise.
-
An integrated set of business applications for automating customer relationship management (CRM), enterprise resource planning (ERP) and supply chain management (SCM) processes.
14.3k Posts
28.6k Comments
-
A hybrid search-analytical database that organizes complex and varied data from disparate source systems into a flexible data model.
-
A full suite of integrated applications that can address your business needs for Human Capital Management (HCM) and Enterprise Resource Planning (ERP).
10.8k Posts
23.2k Comments
-
Customer relationship management system used to help companies connect and manage sales, marketing, and customer support.
On-Premises Infrastructure
-
133.8k Posts
409.4k Comments
-
Application Development Software
38.6k Posts
110.4k Comments
-
109.6k Posts
375.9k Comments
-
17.6k Posts
49.9k Comments
-
8.8k Posts
18.9k Comments
-
71.3k Posts
179.0k Comments
-
105.4k Posts
245.5k Comments
-
41.6k Posts
115.7k Comments
Communities
-
This is the category for new to luminaries questions, suggestions, and troubleshooting
-
This is a category dedicated the community and collaboration amongst underserved and underrepresented communities
-
This is a category dedicated the community and collaboration amongst students and new developer communities.
General
International Languages
-
Local community discussions in the Chinese language.
2.3k Posts
15.9k Comments
-
Local community discussions in the German language.
-
Local community discussions in the Japanese language.
-
Local community discussions in the Portuguese language.
5
During the installation of SES, you may come across an error “[INS-20802] Oracle Net Configuration Assistant failed.”
This error is due to conflict between a declared environment variable and a configuration value provided during the installation. The variable usually causing this is “ORACLE_HOME”
You can get further details of this issue from the log file located at
C:Program FilesOracleInventorylogsinstallActionsyyyy-mm-dd_hh-mm-ss*.log
Further Details
Go to the bottom of the log file and you will see messages like
WARNING: oracle.net.ca.NetCAFatalException: Environmental error detected: Oracle Home is set to "D:Oracleproduct11.2.0sesdb_1" in the environment is different from Oracle Net Configuration Assistant installed Oracle Home. WARNING: Verify that the ORACLE_HOME environment variable or registry setting is set to correct value and relaunch Oracle Net Configuration Assistant. WARNING: WARNING: at oracle.net.ca.NetCALogger.getOracleHome(NetCALogger.java:236) WARNING: at oracle.net.ca.NetCALogger.initOracleParameters(NetCALogger.java:215) WARNING: at oracle.net.ca.NetCALogger.initLogger(NetCALogger.java:130) WARNING: at oracle.net.ca.NetCA.main(NetCA.java:427) INFO: INFO: Error: Environmental error detected: Oracle Home is set to "D:Oracleproduct11.2.0sesdb_1" in the environment is different from Oracle Net Configuration Assistant installed Oracle Home. INFO: Verify that the ORACLE_HOME environment variable or registry setting is set to correct value and relaunch Oracle Net Configuration Assistant. INFO: INFO: Oracle Net Services configuration failed. The exit code is 1 INFO: WARNING: INFO: Completed Plugin named: Oracle Net Configuration Assistant
Resolution
Delete the Environment Variable “ORACLE_HOME” and you can do a Retry, but most likely the installation wizard will continue to throw the same error. The best option to to deinstall Oracle SES so that everything is clean again. Try to install it again.
I can’t install Oracle Database, because I have error
[INS-20802] Oracle Database Configuration Assistant failed
- My PC: Windows 10 Pro;
- Intel core I3; 100+ gb free space
- My logs: https://1drv.ms/f/s!AsSF97QkK8MmjyxT7WBwRcyscMtE
I already tried:
- disable UAC
- Disable antivirus
- Install Microsft vc 2010 x32
- editing localhsot
- root for perl.exe
Appreciate if someone can help me!
shizhen
12k9 gold badges52 silver badges87 bronze badges
asked Jan 24, 2019 at 11:57
Look into your %Program Files%OracleInventorylogs where you will find the reason for error.
I also encountered similar problem where I installed Oracle 18c XE,
Oracle Database 18c we are introduced to a new concept: Image Based Installation.
In Image Based Installation the Oracle Universal Installer of 18c takes the location of our setup.exe file and assigns it as its db_home location. That’s why before we start extracting the content of this file, we first need to decide where we want to create our db_home directory.
Mistake I made was I had the setup.exe in D://drive and for others location left as default(which is C:/ drive)
Solution:
- Copy and extract the entire folder which contain setup.exe in C://
Drive. - Manually remove all the files in in C:/Program Files/Oracle
(including Oracle folder) - Run the setup.exe as Administrator
- Leave the other configuration paths as default
(Additional : Satisfy following condition when configuring the password
Oracle recommends the following guidelines when prompted for a password.
- Contains at least one lowercase letter.
- Contains at least one uppercase letter.
- Contains at least one digit.
- Is at least 8 characters in length.
- Uses the database character set, which can include the underscore (_), dollar ($), and pound sign (#) characters.
- Should not be an actual word.
)
answered Jul 17, 2019 at 17:19
0
You can find in your logs:
SEVERE: [Jan 18, 2019 4:32:04 PM] [FATAL] [INS-35955] The Database software home
(C:ORACLESOURCE) is already registered in the central inventory. This tool can only be
used in a non-registered Database home.
ACTION: Choose a different location as Oracle home.
Try install Oracle in another directory.
answered Jan 24, 2019 at 12:41
fuNcti0nfuNcti0n
1771 silver badge11 bronze badges
3
Ошибка журнала: ошибка [INS-20802] при установке Oracle.
окружение:
- Windows10 Professional 64-разрядная
- Исходный сжатый пакет 1: win64_11gR2_database_1of2.zip
- Исходный сжатый пакет 2: win64_11gR2_database_1of2.zip
- PLSQL Developer 13 (64 bit)
- Установка относится к этому руководству:https://blog.csdn.net/projectno/article/details/76533921
- Для удаления обратитесь к этому руководству:https://blog.csdn.net/projectno/article/details/76536013
Первая установка: успешно
- Перед установкой были полностью удалены Oracle, PLSQL и Instantclient.
- Установлен Oracle согласно руководству по установке, упомянутому выше.
- Установить Instantclient
- Установить PLSQL
Результат: Oracle успешно установлен, а PLSQL успешно подключен к Oracle.
После установки я обнаружил, что у Oracle есть собственный мгновенный клиент, поэтому у меня было обсессивно-компульсивное расстройство. Я собирался удалить мгновенный клиент, который устанавливался неоднократно. В результате я поступил глупо и даже удалил Oracle в интерфейсе удаления ( Кто бы мог подумать, что эти два парня появились на одном интерфейсе) Итак, согласно руководству по удалению, упомянутому выше, Oracle был полностью удален, независимо от работы по очистке после удаления повторной установки Instantclient, а PLSQL не был удален.
Вторая установка: не удалось
На этот раз я установил Oracle только в соответствии с инструкцией. После сбоя я не проверял файл журнала. Я ошибочно подумал, что во время последнего удаления чего-то не хватало. Поэтому я снова выполнил полное удаление и подготовился к третьей установке. В последний раз я тоже очищал.Удалите остатки Instantclient, не удаляя PLSQL.
Третья установка: не удалось
При установке Oracle он сообщил о той же ошибке, что и при второй установке: [INS-20802]
Я не выходил из установки.После тщательной проверки записей журнала я нашел следующий абзац, но никакого прироста не было.
Информация: Oracle Net listener запускается:
Сообщение: Слушатель работает
Информация: E: Oracle product 11.2.0 dbhome_1 bin lsnrctl start LISTENER
Сообщение: Контроль прослушивателя завершен.
Сообщение: слушатель не может быть запущен.
Информация: Для получения дополнительной информации проверьте файл трассировки: E: Oraclecfgtoollogsnetcatrace_OraDb11g_home1-19010411днем0721.log
Информация: Oracle Ошибка настройки сетевых служб. Код выхода:1
Информация: Завершено Plugin named: Oracle Net Configuration Assistant
Информация: Oracle Сбой помощника по настройке сети
Информация: Oracle Сбой помощника по настройке сети.
Затем проверьте более подробный файл журнала в каталоге установки Oracle и найдите запись об ошибке. Есть два абзаца (на первый взгляд похожие):
[main] [ 2019-01-04 23:07:23.282 CST ] [WindowsSystem.startService:698] WindowsSystem.startService2() returning 0|?????????¨???????
[main] [ 2019-01-04 23:07:23.282 CST ] [WindowsSystem.startRemoteExecServer:1870] _WS_ start Service returned 0|?????????¨???????
[main] [ 2019-01-04 23:07:23.282 CST ] [NativeResult.<init>:91] NativeResult: The String obtained is0|?????????¨???????
[main] [ 2019-01-04 23:07:23.282 CST ] [NativeResult.<init>:99] The status string is: 0
[main] [ 2019-01-04 23:07:23.282 CST ] [NativeResult.<init>:112] The result string is: ?????????¨???????
[main] [ 2019-01-04 23:07:23.282 CST ] [WindowsSystem.startRemoteExecServer:1896] _WS_ Failed.2 to start Service OracleRemExecService on Lenovo-G580
[main] [ 2019-01-04 23:07:23.282 CST ] [CmdToolUtil.doexecute:365] nativeSystem.startRemoteExecServer failed
[main] [ 2019-01-04 23:07:23.282 CST ] [HAUtils.isHASConfigured:364] Ignoring exception in isHASConfigured: PRCT-1013 : Невозможно запустить удаленный сервер выполнения на локальном узле.
PRKN-1017 : Не может быть на узле "Lenovo-G580" Начать обслуживание "OracleRemExecService", Ошибка: "0|?????????¨???????
[main] [ 2019-01-04 23:07:24.110 CST ] [WindowsSystem.startService:698] WindowsSystem.startService2() returning 0|?????????¨???????
[main] [ 2019-01-04 23:07:24.110 CST ] [WindowsSystem.startRemoteExecServer:1870] _WS_ start Service returned 0|?????????¨???????
[main] [ 2019-01-04 23:07:24.125 CST ] [NativeResult.<init>:91] NativeResult: The String obtained is0|?????????¨???????
[main] [ 2019-01-04 23:07:24.125 CST ] [NativeResult.<init>:99] The status string is: 0
[main] [ 2019-01-04 23:07:24.125 CST ] [NativeResult.<init>:112] The result string is: ?????????¨???????
[main] [ 2019-01-04 23:07:24.125 CST ] [WindowsSystem.startRemoteExecServer:1896] _WS_ Failed.2 to start Service OracleRemExecService on Lenovo-G580
[main] [ 2019-01-04 23:07:24.125 CST ] [CmdToolUtil.doexecute:365] nativeSystem.startRemoteExecServer failed
[main] [ 2019-01-04 23:07:24.125 CST ] [HAUtils.isHASConfigured:364] Ignoring exception in isHASConfigured: PRCT-1013 : Невозможно запустить удаленный сервер выполнения на локальном узле.
PRKN-1017 : Не может быть на узле "Lenovo-G580" Начать обслуживание "OracleRemExecService", Ошибка: "0|?????????¨???????
Затем я проверил Baidu и Google и не нашел решения этой проблемы.
Чтобы полностью восстановить состояние компьютера, когда он был впервые установлен, я удалил PLSQL Developer 13, но не ожидал этого! ! ! [INS-20802] Ничего! Прошло! Только на этот раз есть еще одна небольшая проблема, но она не влияет на программу, чтобы запросить успешную установку! После этого установите PLSQL. На всякий случай используйте PLSQL Developer 12, а для конфигурации используйте собственный oci.dll Oracle, вы можете подключиться!
При установке Oracle database 11g, на 11 шаге возникла ошибка:
INS-20802: Oracle Net Configuration Assistant failed
Cause — The plug-in failed in its perform method
Action — Refer to the logs or contact Oracle Support Services. Log File Location
/mnt/u01/app/oraInventory/logs/installActions2021-03-13_05-08-32PM.log
Аналогичная ошибка и была при установке СУБД Oracle на Windows тут. Но судя по ошибке в логе, проблема здесь возникла не из-за переменной среды.
Текст из лога:
INFO: Started Plugin named: Oracle Net Configuration Assistant
INFO: Found associated job
INFO: Starting ‘Oracle Net Configuration Assistant’
INFO: Starting ‘Oracle Net Configuration Assistant’
INFO: Parsing command line arguments:
INFO: Parameter «orahome» = /mnt/u01/app/oracle/product/11.2.0/dbhome_1
INFO: Parameter «orahnam» = OraDb11g_home1
INFO: Parameter «instype» = typical
INFO: Parameter «inscomp» = client,oraclenet,javavm,server,ano
INFO: Parameter «insprtcl» = tcp
INFO: Parameter «cfg» = local
INFO: Parameter «authadp» = NO_VALUE
INFO: Parameter «responsefile» = /mnt/u01/app/oracle/product/11.2.0/dbhome_1/network/install/netca_typ.rsp
INFO: Parameter «silent» = true
INFO: Done parsing command line arguments.
INFO: Oracle Net Services Configuration:
INFO: Profile configuration complete.
INFO: Oracle Net Listener Startup:
INFO: The information provided for this listener is currently in use by other software on this computer.
INFO: Listener start failed.
INFO: Check the trace file for details: /mnt/u01/app/oracle/cfgtoollogs/netca/trace_OraDb11g_home1-2103136PM1352.log
INFO: Oracle Net Services configuration failed. The exit code is 1
INFO:
WARNING:
INFO: Completed Plugin named: Oracle Net Configuration Assistant
[oracle@dbserver38 logs]$ installActions2021-03-13_05-08-32PM.log
-bash: installActions2021-03-13_05-08-32PM.log: command not found
По совету в записи пошел проверять логи трассировки:
[main] [ 2021-03-13 18:13:56.160 IRKT ] [ConfigureListener.typicalConfigure:231] Failed to get free port. Using port 1521.
[main] [ 2021-03-13 18:13:56.243 IRKT ] [ConfigureListener.listenerExists:344] Is listener «LISTENER» already exists: false
[main] [ 2021-03-13 18:13:56.243 IRKT ] [ConfigureListener.setListenerParam:1867] Setting ADR_BASE_LISTENER: /mnt/u01/app/oracle
[main] [ 2021-03-13 18:13:56.245 IRKT ] [ConfigureListener.isPortFree:1080] Checking if port 1521 is free on local machine…
[main] [ 2021-03-13 18:13:56.245 IRKT ] [ConfigureListener.isPortFree:1095] InetAddress.getByName(127.0.0.1): /127.0.0.1
[main] [ 2021-03-13 18:13:56.311 IRKT ] [ConfigureListener.isPortFree:1097] Local host IP address: dbserver38/192.168.146.9
[main] [ 2021-03-13 18:13:56.311 IRKT ] [ConfigureListener.isPortFree:1099] Local host name: dbserver38
[main] [ 2021-03-13 18:13:56.312 IRKT ] [ConfigureListener.isPortFree:1115] IP Address: dbserver38/192.168.146.9, Is IPv6 Address: false
[main] [ 2021-03-13 18:13:56.312 IRKT ] [ConfigureListener.isPortFree:1118] IP Address: dbserver38/192.168.146.9, Is Link-Local Address: false
[main] [ 2021-03-13 18:13:56.312 IRKT ] [ConfigureListener.isPortFree:1143] Creating ServerSocket on Port:1521, IP Address: dbserver38/192.168.146.9
[main] [ 2021-03-13 18:13:56.313 IRKT ] [ConfigureListener.isPortFree:1178] java.net.PlainSocketImpl.socketBind(Native Method)
java.net.PlainSocketImpl.bind(PlainSocketImpl.java:377)
java.net.ServerSocket.bind(ServerSocket.java:319)
java.net.ServerSocket.<init>(ServerSocket.java:185)
oracle.net.ca.ConfigureListener.isPortFree(ConfigureListener.java:1145)
oracle.net.ca.ConfigureListener.startOrStopListener(ConfigureListener.java:1221)
oracle.net.ca.ConfigureListener.typicalConfigure(ConfigureListener.java:270)
oracle.net.ca.SilentConfigure.performSilentConfigure(SilentConfigure.java:185)
oracle.net.ca.InitialSetup.<init>(NetCA.java:4189)
oracle.net.ca.NetCA.main(NetCA.java:428)
[main] [ 2021-03-13 18:13:56.313 IRKT ] [ConfigureListener.isPortFree:1191] Returning is Port 1521 free: false
[oracle@dbserver38 netca]$
При этом, IP машины на котором запущена инсталляция совершенно другая (172.*.*.*).
Решение:
В файле etc/hosts добавить/изменить на корректное название и IP адрес сервера.
В моем случае было так:
127.0.0.1 localhost localhost.localdomain localhost4 localhost4.localdomain4
::1 localhost localhost.localdomain localhost6 localhost6.localdomain6
Поэтому пришлось добавить строку с IP адресом сервера:
172.*.*.* dbserver38
Итог etc/hosts выглядит так:
127.0.0.1 localhost localhost.localdomain localhost4 localhost4.localdomain4
::1 localhost localhost.localdomain localhost6 localhost6.localdomain6
172.*.*.* dbserver38
А установка после нажатия «Retry» выглядит так: