Skip to Main Content

Data Science & Machine Learning

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!

Error: ORD 3.6.1, OML4R 1.5.1 and Oracle DB 19c

Hasnur RamadhanSep 10 2020

Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production Version 19.8.0.0.0

MS Windows 10 Pro

Connection is to a Pluggable database.

Oracle Distribution of R version 3.6.1 (2018-03-15)

OML4R 1.5.1 packages (R-3.6.1)

I have got error for:

----

ore.doEval(function(){123})

Error in .oci.GetQuery(conn, statement, data = data, prefetch = prefetch,  :

  ORA-06520: PL/SQL: Error loading external library

ORA-06512: at line 11

ORA-06512: at "RQSYS.RQEVALIMPL", line 17

ORA-06512: at "RQSYS.RQEVALIMPL", line 14

ORA-06512: at line 6

------

fit <- ore.neural('default10yr ~ LTI + age', data = trainData, hiddenSizes = c(5L), , activations = c("sigmoid", "linear"))

Error in .oci.GetQuery(conn, statement, data = data, prefetch = prefetch,  :

  ORA-06520: PL/SQL: Error loading external library

ORA-06512: at line 11

ORA-06512: at "RQSYS.RQEVALIMPL", line 17

ORA-06512: at "RQSYS.RQEVALIMPL", line 14

ORA-06512: at line 6

----

oreFit <- ore.lm(Fare ~ ., data = airfare_odf)

Error in .oci.GetQuery(conn, statement, data = data, prefetch = prefetch,  :

  ORA-06520: PL/SQL: Error loading external library

ORA-06512: at line 11

ORA-06512: at "RQSYS.RQEVALIMPL", line 17

ORA-06512: at "RQSYS.RQEVALIMPL", line 14

ORA-06512: at line 6

---

BUT there is no error for some other ORE algorithms:

-----

km.iris<- ore.odmKMeans(~., a,num.centers=3, auto.data.prep=FALSE)

-----

ar.mod <-ore.odmAssocRules(~., ore.assoc_df, case.id.column= "TRANS_ID", item.id.column= "PRODUCT_ID", min.support= 0.5, min.confidence= 0.7, max.rule.length = 3)

-----

Thanks.

Hasnur Ramadhan

Comments

Norman Dunbar
Answer

The reason is simple, the uninstaller only does half a job.

If you run the services.msc utility (Windows +R, type services.msc), scroll down to the Oracle named services and you will see a few that are still there. You need to get rid of those as follows:

start

Search for cmd

Right-click, run as adminsitrator

When it runs:

sc delete service_name

For each and every OracleXE service you see.

Then try the installer again.

HTH

Cheers,

Norm.

Marked as Answer by RabbitWolf · Mar 29 2019
RabbitWolf

Hi Norman,

Thank you for your help.

Tracy

User_W0LKB

Thank you for the answer, it was direct easy and effective.

User_D6N37

16265417480228690500742459505923.jpg

When you look at your services, do you see an XE service?

Jay Ganneru

Thank you so much. This solution worked for me. I was able reinstall XE after deleting below services in my system.
sc delete OracleOraDB18Home1MTSRecoveryService
sc delete OracleOraDB18Home1TNSListener
sc delete OracleOraDB19Home1MTSRecoveryService
sc delete OracleOraDB19Home1TNSListener
sc delete OracleServiceORCL
sc delete OracleServiceXE
sc delete OracleVssWriterORCL
sc delete OracleVssWriterXE

User_0K1SH

Thanks,
it works well

User_OTN9L

I'm getting access denied

Jay Ganneru

try this,
Search for cmd
Right-click, run as adminsitrator

User_OTN9L

okay now i have reinstalled the zip extracted and got it to run but while seting up the database software I'm getting INS-35955 error.
Screenshot 2021-08-28 093943.png

ToolTimeTabor

Typical slipshod Oracle installers and\or instructions.

Xdigit

@norman-dunbar3 Thanks, it worked like a charm

User_LQ951

IMG20230125214021.jpgHow reinstall

asahide

Hi @user-lq951 ,
Is this one helpful?
How to Uninstall Oracle Database 21C | RebellionRider (0 Bytes)Regards,

user-6k6y2

when I try to delete the oracle services it shows ‘The specified service does not exist as an installed service.’. I'm trying to reinstall oracle and it's delivering the same message that it exists on my machine. how do I fix this?

user-q5oby

Hello,

I have several times tried to install Oracle Database 21c but there is an error INS 35955.

How can i fix this problem?

Thank you in advance.

That is not XE (which is what this forum is about). You are trying to install Enterprise Edition. It may be easier to install Express Edition if you do not care.

In any case, it looks like you have already installed once and didn't successfully uninstall.

You can try renaming that dbhome directory to something else and then rerunning setup from there.

user-sgfqu

Thank you.

This worked well!

1 - 18

Post Details

Added on Sep 10 2020
1 comment
436 views