How to install Oracle Database Examples 21c on an existing Oracle 21c installation

Paul_6690295

Hi,

Today I tried to install the Oracle Database Examples 21c.

I downloaded Oracle Database 21c Examples (21.3) for Microsoft Windows x64 (64-bit) from https://www.oracle.com/database/technologies/oracle21c-windows-downloads.html and unzipped it. When I run setup.exe (as administrator on a windows 11 x64 machine) You need to fill in the Oracle Base. That's a point to begin with.. I guess it was C:\Oracle21c. And the place you want your software to go.I opted for c:\Oracle21c\demo.

All good and well, but when I press the Next button I get the error: [INS-52001] Oracle Database Examples can only be installed into an existing Oracle Database Home of version 21.0.0.0.0.

Now that is weird. I have 21C = 21.3.0.0.0.

The download was for 21c, so why can't I install it ?

here's my folder structure:

Any help would be greatly appreciated.

Thanks,

Paul

Solomon Yakobson

INS-32016 and INS-52001 during Oracle Database Examples installation(Doc ID 2597729.1)

SY.

Paul_6690295

https://community.oracle.com/tech/developers/discussion/comment/16830524#Comment_16830524

That link points to a location I can't get to because I don't have a support subscription 😧

However, I managed to get the stuff installed:

In the adventures that followed I was met with plenty of other irritating issues. Like setup-scripts that don't do the job as advertised.

For instance this script: C:\Oracle21c\db_home\md\demo\examples\spatial_examples.sql

When I ran that in sql*plus it failed when the script was connecting to the scott/tiger account. The account I had already created earlier, but the script failed to connect to it, throwing an Invalid username/password error and left me with no database connection at all. Took me a while to figure out that the connect string must include "@orcl" behind it. (i.e. connect scott/[email protected]). Also the user scott had not enough privileges to do all the stuff needed, so I just granted all privileges to scott (not advisable, I know).

I also didn't know that the pdb container is automatically switched to when you connect to scott/[email protected] from CDB$ROOT, if scott is an schema in the pdb.

Then there were some errors in the insert statements: ORA-29861: domain index is marked LOADING/FAILED/UNUSABLE. I had to rebuild the indexes (using sqldeveloper)

Then I tried to install Oracle Spatial Studio. Another drama, with errors from the get-go: "java.lang.NoClassDefFoundError: Could not initialize class org.codehaus.groovy.vmplugin.v7.Java7"

I gave up on fixing that. Had my belly full of Oracle for a while 😅

Thanks,

Paul

User_QO9VV

Hi, Paul!

How did you do that? I have the same problem with Oracle 19c (19.3)

I try to install examples but get error INS-52001

Paul_6690295

https://community.oracle.com/tech/developers/discussion/comment/16830731#Comment_16830731

In my case it was a question of picking the correct locations for oracle base and the software installation.

(i.e. c:\oracle21c\ and c:\oracle21c\db_home See the locations in the opening post)

Good luck,

Paul

User_QO9VV

Hi, Paul!

Thank you!

in my c ase solution was

Bug 22579138

When installing the Oracle Database Examples software on an Oracle Database Client home (32-bit), you encounter the following error:

SEVERE: [FATAL] [INS-52001] Oracle Database Examples can only be installed into an existing Oracle Database Home of version 12.2.0.1.0.

Workaround:

Restart the Oracle Database Examples installer with the -skipOHCOmpatibilityCheck switch and proceed with the installation.