Comments (9)
vassterg
commented on August 22, 2024
4
Trying with ./sqlcl/bin/sql sys@localhost:1521/xepdb1?oracle.net.disableOob=true as sysdba works as is suggested by you @gvenzl and in oracle/docker-images/issues/1663. This workaround is not tested against other scenarios like connections from ords but...
from oci-oracle-xe.
vassterg
commented on August 22, 2024
1
My main use is with APEX and ORDS. For ORDS config this means that it needs
to use customURL as connect string and this is a change in all
configuration scripts and of course a change in Ansible recipes. So
something reverting the new behavior is welcomed. Thank you.
Στις Παρ, 12 Νοε 2021, 4:45 μ.μ. ο χρήστης Βασίλης Στεργιούλης <
***@***.***> έγραψε:
… That would be great!
Στις Παρ, 12 Νοε 2021, 4:42 μ.μ. ο χρήστης Gerald Venzl <
***@***.***> έγραψε:
> @vassterg <https://github.com/vassterg>, this issue gets reported by
> more and more users taking up 21c, which makes me think that I will
> probably enable this parameter by default in these images so that users
> don't have to go through a lot of pain and troubleshooting just to connect
> to the database.
>
> —
> You are receiving this because you were mentioned.
> Reply to this email directly, view it on GitHub
> <#43 (comment)>,
> or unsubscribe
> <https://github.com/notifications/unsubscribe-auth/ABMI2KOE5I43GDSMNDJF4K3ULURVZANCNFSM5HICKEOQ>
> .
> Triage notifications on the go with GitHub Mobile for iOS
> <https://apps.apple.com/app/apple-store/id1477376905?ct=notification-email&mt=8&pt=524675>
> or Android
> <https://play.google.com/store/apps/details?id=com.github.android&referrer=utm_campaign%3Dnotification-email%26utm_medium%3Demail%26utm_source%3Dgithub>.
>
>
from oci-oracle-xe.
gvenzl
commented on August 22, 2024
Great, happy to hear (sort of) that it's the same issue! Will make sure that the OOB issue gets documented appropriately!
from oci-oracle-xe.
gvenzl
commented on August 22, 2024
This is related to #38.
from oci-oracle-xe.
gvenzl
commented on August 22, 2024
@vassterg, this issue gets reported by more and more users taking up 21c, which makes me think that I will probably enable this parameter by default in these images so that users don't have to go through a lot of pain and troubleshooting just to connect to the database.
from oci-oracle-xe.
vassterg
commented on August 22, 2024
That would be great!
Στις Παρ, 12 Νοε 2021, 4:42 μ.μ. ο χρήστης Gerald Venzl <
***@***.***> έγραψε:
… @vassterg <https://github.com/vassterg>, this issue gets reported by more
and more users taking up 21c, which makes me think that I will probably
enable this parameter by default in these images so that users don't have
to go through a lot of pain and troubleshooting just to connect to the
database.
—
You are receiving this because you were mentioned.
Reply to this email directly, view it on GitHub
<#43 (comment)>,
or unsubscribe
<https://github.com/notifications/unsubscribe-auth/ABMI2KOE5I43GDSMNDJF4K3ULURVZANCNFSM5HICKEOQ>
.
Triage notifications on the go with GitHub Mobile for iOS
<https://apps.apple.com/app/apple-store/id1477376905?ct=notification-email&mt=8&pt=524675>
or Android
<https://play.google.com/store/apps/details?id=com.github.android&referrer=utm_campaign%3Dnotification-email%26utm_medium%3Demail%26utm_source%3Dgithub>.
from oci-oracle-xe.
gvenzl
commented on August 22, 2024
According to https://oracle-l.freelists.narkive.com/6bkLfg9i/anyone-have-disable-oob-on-set-in-sqlnet-ora, setting DISABLE_OOB can have a negative impact on performance (although it's not discussed/shared how much that impact would be). There is an accompanying parameter BREAK_POLL_SKIP that might need to have a higher value set than the default of 4, which is the number of network packets sent before the stack polls for these network break messages.
Oracle's BI server documentation refers to setting this to 10k packages:
Configuring Oracle BI Server When Using a Firewall
The presence of a firewall between the Oracle BI Server and the Oracle Database can result in very long query times.For example, if using a simplenqcmd query takes two to three minutes to return results, or if Answers does not respond after executing or validating a SQL statement initiated in Presentation Services.
To improve query time, go to the sqlnet.ora file in BI_DOMAIN\config\fmwconfig\bienv\core and add the BREAK_POLL_SKIP and DISABLE_OOB parameters as follows:
BREAK_POLL_SKIP=10000
DISABLE_OOB=ON
This configuration only needs to be performed on the Oracle BI Server. This configuration is not needed on the Oracle Database or on user client desktops.
from oci-oracle-xe.
gvenzl
commented on August 22, 2024
Yeah indeed, a lot of people would have to change their configuration to deal with this. Better if the image itself deals with it once, rather than pushing the burden to 1000s of users! :)
from oci-oracle-xe.
gvenzl
commented on August 22, 2024
This is fixed now, DISABLE_OOB is now turned on in all 21c+ images
from oci-oracle-xe.
Related Issues (20)
- The last commit broke the Github Actions HOT 3
- ORA 28040 No matching Authentication Protocol HOT 1
- Unable to start container HOT 1
- ORA-00443: background process "PMON" did not start HOT 1
- Permission denied on Github Workflow HOT 4
- ORA-43853: SECUREFILE LOBs (Large Objects) cannot be used in non-automatic segment space management tablespace "SYSTEM" HOT 3
- Missing double-quotes for APP_USER HOT 3
- Provide `FREE` SID (together with current `XE`) HOT 7
- Multi-schema DB Access HOT 3
- docker image 21-slim-faststart has an outdated healthcheck.sh HOT 5
- Trying to run gvenzl/Oracle-XE image From a Synology 920 DSM Container HOT 3
- error after restarting container
- Apple silicon support HOT 3
- Mac M2 Oracle-XE, both latest and 18.4.0, does not start, ORA-03113: end-of-file on communication channel HOT 4
- Running Oracle as sibling / child container in podman - Oracle database startup failing HOT 3
- Do you have the image 19c-slim HOT 2
- can i change oracle xe 11g NLS_LANG to other HOT 1
- tar with extended attributes issue HOT 7
- Hope add 12c and 19c HOT 1
- Starting docker image with different owner HOT 1
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from oci-oracle-xe.