Skip to Main Content
Forums

SQL Developer

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

"Unable to launch the Java Virtual Machine" ... msvcr100.dll with JDK 1.8u261

Roelof_vSJul 18 2020 — edited Jul 23 2020

Hi all,

Windows 64 bit

SQL*Developer 20.2

JDK 1.8u261

Fresh installation of SQL*Dev and JDK.

With JDK u251, all is good.

With JDK u261, and error window appears:

   Unable to launch the Java Virtual Machine

   Located at path:

   c:\p\jdk8\jre\bin\msvcr100.dll

Downloading and installing Microsoft Redistributable files for Visual stusio 2010 does not help. Neither does the 2012 version, nor the one for 2015-2019.

I know JDK 8u261 is compiled with a newer Visual Studio (2017, per their readme), so likely that is key to the cause of this error. I have reviewed Support note

  => Java SE 8 Update 261+ and Java SE 7 Update 281+ Runtime Windows Visual Studio Library (DLL) Dependency Changes (Doc ID 2684819.1)

but that did not resolve. It only gives me the idea that SQL*Dev on Windows may need to be recompiled?

The worklaround is simple - use JDK 8u251, but I am concerned about other products in the Oracle stack that may also be affected, e.g. OBIEE, Forms, etc. So I wish to understand this problem better, and whether to advise internally to avoid JDK 8u261.
This post has been answered by Sudhakar-Oracle on Jul 21 2020
Jump to Answer

Comments

663750
hello Micros,

If you have small project its beneficial to use Single repository

and the main advantage to have a Single repository is the execution speed ,

If you are using multiple rep its difficult to merge them and the speed is very low
631335
Hello Micros

I have made an installation with one BI Server with multiple repositories, served by multiple presentation services, on Oracle Unbreakable R4. It is a little bit tricky but it works.
663712
Can you share how you did it? What was the tricky part?
631335
Answer
I'm going to write a document about this sometime in the future.
Right now these are some basic steps:

1. Deploy a new version of analytics application on OC4J using the analytics.war on $ORACLEBI/web/
2. Edit file $ORACLEBI/oc4j_bi/j2ee/home/applications/analytics_<new>/WEB-INF/web.xml and change value for "oracle.bi.presentation.sawserver.port"to 9711
3. Add new repository on NQSConfig.Ini and restart BI Server
4. Create a new entry on $ORACLEBI/setup/odbc.sh as a copy of AnalyticsWeb, that should point to the new repository
5. Create a new catalog folder on $ORACLEBIDATA/web/catalog
6. Create a new instanceconfig.xml and add <Listener port=”9711″ />after the <DNS .../> entry.
7. On the new instanceconfig.xml change the Catalogpath to point to the new catalog folder created on step 5, and DNS to the one created on step 4
8. Create new scripts to start the sawserver with parameter the complete path to the new instanceconfig.xml.
9. Restart OC4J and BI Server and start the new Presentation Services with the scripts you made.

This is not a complete guide but the outline of the procedure. I 'm planning to make it complete sometime (if I find some free time)
You can also check the following links
[http://www.be-ice.eu/2007/09/11/managing-multiple-presentation-services-on-the-same-unix-box]
[http://bvellinger.blogspot.com/2008/01/obiee-10132-and-multiple-presentation.html]

Giorgio
Marked as Answer by 663712 · Sep 27 2020
663712
Awesome! Thanks
David_T
Wow. After all that, no points for Giorgio?!
667465
Hi Giorgio
Do you have the document, since i have tried almost everything but i am still not able to do it.
Here is the link where i have written all the steps please correct them if you find any mistake or please add steps if in case you find it missing.
link : 3715965

I badly need to try this, because people dont believe that this can be actually done.

thanks
1 - 7

Post Details

Added on Jul 18 2020
#sql-developer
14 comments
38,646 views