Skip to Main Content
  • Questions

  • Not able to insert data in some tables. Unable to connect some times

Breadcrumb

Question and Answer

Chris Saxon

Thanks for the question, Subba Rao.

Asked: June 24, 2020 - 1:13 pm UTC

Last updated: June 25, 2020 - 12:08 pm UTC

Version: 11g_xe

Viewed 1000+ times

You Asked

I have 11G_XE installed in windows 10 64bit Operating system. When I See alert.log of the database, the following messages are repeatedly updating the file. The issues of the database like Procedures are hanging and not being completed, not able to insert data in some tables, not able to connect.

OER 7451 in Load Indicator : Error Code = OSD-04500: illegal option specified
O/S-Error: (OS 1) Incorrect function. !

Fatal NI connect error 12170.

  VERSION INFORMATION:
 TNS for 32-bit Windows: Version 11.2.0.2.0 - Production
 Windows NT TCP/IP NT Protocol Adapter for 32-bit Windows: Version 11.2.0.2.0 - Production
  Time: 05-JUN-2020 12:30:53
  Tracing not turned on.
  Tns error struct:
    ns main err code: 12535
    
TNS-12535: TNS:operation timed out
    ns secondary err code: 12560
    nt main err code: 505
    
TNS-00505: Operation timed out
    nt secondary err code: 60
    nt OS err code: 0
  Client address: <unknown>
OER 7451 in Load Indicator : Error Code = OSD-04500: illegal option specified
O/S-Error: (OS 1) Incorrect function. !


Requesting to go through the issue and advise.

Thanks & Regards
Subbarao Dasari

and Chris said...

I think the issue may be related to:

I have 11G_XE installed in windows 10 64bit Operating system

And:

TNS for 32-bit Windows: Version 11.2.0.2.0 - Production

As MOS note 1060806.1 says:

Note: For the Database software, you can ONLY install the x64 version on MS Windows (x64).
You can NOT install the 32-bit version Database software on MS Windows (x64).

So, ensure you've installed the 64-bit version!

PS - any particular reason to install 11g XE, not 18c XE?

Rating

  (1 rating)

Is this answer out of date? If it is, please let us know via a Comment

Comments

Clarifications

Subbarao Dasari, June 25, 2020 - 11:12 am UTC

Dear sir,

Thank you very much for your reply.


This has been installed 4 years back and not sure on 18C XE.

It is normal in most of the cases and few cases it is misbehaving.

Shall we have 11g XE on 64bit
Chris Saxon
June 25, 2020 - 12:08 pm UTC

If it's a 64bit OS, you need to install the 64bit version of Oracle Database!

If there's a mismatch, you've just been lucky so far
more

Connor and Chris don't just spend all day on AskTOM. You can also catch regular content via Connor's blog and Chris's blog. Or if video is more your thing, check out Connor's latest video and Chris's latest video from their Youtube channels. And of course, keep up to date with AskTOM via the official twitter account.

More to Explore

Administration

Need more information on Administration? Check out the Administrators guide for the Oracle Database