| |
2084 Search Results Found |
| 1 |
Forum: Forms «»
Posted on: Wed, 13 July 2022 01:58 «»
By: jury68000
Re: .fmb to .txt
…is a summary:
Topisc with my feedback:
- https://www.orafaq.com/forum/m/677689/#msg_677689
- https://www.orafaq.com/forum/m/680617/#msg_680617
- https://www.orafaq.com/forum/m/684263/#msg_684263
- https://www.orafaq.com/forum/m/684873/#msg_684873…
|
| 2 |
Forum: SQL & PL/SQL «»
Posted on: Mon, 24 October 2022 04:57 «»
By: fixxxer
ORA-29005: The certificate is invalid
… user:
SQL> SELECT utl_http.request('https://HIDDENSERVER.com:8443/healthcheck',NULL,'file:/u01/app/oracle/wallet') from dual;
UTL_HTTP.REQUEST('HTTPS://HIDDENSERVER.COM:8443/HEALTHCHECK',NULL,'FILE…
|
| 3 |
Forum: SQL & PL/SQL «»
Posted on: Thu, 10 March 2022 17:30 «»
By: EdStevens
Re: Oracle calculate hours between timestamps
…
Or maybe these?
https://stackoverflow.com/questions/71420800/find-working-hours-between-two-timestamp-excluding-weekend-and-holiday-in-oracle
https://stackoverflow.com/questions/71406092/create-a-function-to-calculate-working-hours-in-oracle
https://…
|
| 4 |
Forum: Server Administration «»
Posted on: Fri, 14 April 2023 07:18 «»
By: Andrey_R
Re: No SCN in controlfile after BACKUP TO TRACE
…dates back to Oracle 10g days.. )
https://forums.oracle.com/ords/apexds/post/database-recovery-1778
https://docs.oracle.com/en/database/oracle/oracle-database/19/refrn/V-DATABASE.html
https://forums.oracle.com/ords/apexds/post/…
|
| 5 |
Forum: Data Guard «»
Posted on: Sat, 04 February 2023 15:43 «»
By: Andrey_R
RMAN-06820 on rman backup from standby with OS authentication
…in different sources such as:
https://doyensys.com/blogs/rman-06820-warning-failed-to-archive/
https://support.oracle.com/epmos/faces/DocumentDisplay?_afrLoop=573376425708183&parent=EXTERNAL_SEARCH&sourceId=PROBLEM&i d=2723796.1&…
|
| 6 |
Forum: Application Express, ORDS & MOD_PLSQL «»
Posted on: Mon, 24 October 2022 12:01 «»
By: Michel Cadot
Re: ORDS 22.2.1.r2021302 installation on Windows server issues
… Edge, see if the following links help you:
https://answers.microsoft.com/en-us/microsoftedge/forum/all/errinvalidhttpresponse/c91c82f3-387a-47f0-a5cb-abb0b480085f
https://answers.microsoft.com/en-us/windows/forum/all/errinvalidhttpresponse-when-trying…
|
| 7 |
Forum: SQL & PL/SQL «»
Posted on: Thu, 08 September 2022 09:07 «»
By: John Watson
Re: Consuming Rest API from PL/SQL using UTL_HTTP - body not recognized
…rclz>
orclz> select utl_http.request('https://weatherapi-com.p.rapidapi.com/ip.json',wallet_path=>'file:c:\tmp\wallet') from dual;
UTL_HTTP.REQUEST('HTTPS://WEATHERAPI-COM.P.RAPIDAPI.COM/IP.JSON',WALLET_PATH=>'FILE:C:\TMP\WALLET…
|
| 8 |
Forum: Server Administration «»
Posted on: Fri, 24 May 2024 01:57 «»
By: Michel Cadot
Re: How to know if my oracle DB is on premise or cloud
… and got some answers from Connor McDonald:
https://asktom.oracle.com/ords/asktom.search?tag=how-to-know-if-my-oracle-db-is-on-premise-or-cloud
The following page from Sinan Petrus Toma gives a more complete answer:
https://database-heartbeat.com/…
|
| 9 |
Forum: SQL & PL/SQL «»
Posted on: Thu, 16 November 2023 09:03 «»
By: Duane
Re: Help with query returning JSON
…Charts
https://developers.google.com/chart
Google Data Example
https://developers.google.com/chart/interactive/docs/php_example
sampleData.json File
A JSON version of a small DataTable.
{
"cols": [
&…
|
| 10 |
Forum: Suggestions & Feedback «»
Posted on: Wed, 08 November 2023 18:04 «»
By: Barbara Boehmer
Re: Login issue
…being to use private browsing mode.
https://support.mozilla.org/en-US/questions/1154880
How to turn off message that asks to update password
"When logging in asks to update password but don't want to update. This happens every time since the…
|
| 11 |
Forum: RAC & Failsafe «»
Posted on: Fri, 13 October 2023 04:08 «»
By: John Watson
Re: No X11 DISPLAY variable was set
…GI Installation Guide makes this clear:
https://docs.oracle.com/en/database/oracle/oracle-database/19/cwlin/logging-in-to-a-remote-system-using-x-window-system.html
Configuring X is beyond the scope of an Oracle forum. However, I can say that the …
|
| 12 |
Forum: Server Administration «»
Posted on: Mon, 18 September 2023 06:56 «»
By: lodimas
Re: LogMiner - select for update
…of v$logmnr_contents in Oracle 19: https://docs.oracle.com/en/database/oracle/oracle-database/19/refrn/V-LOGMNR_CONTENTS.html#GUID-B9196942-07BF-4935-B603-FA875064F5C3
- This is link for description of v$logmnr_contents in Oracle 21: https://docs.…
|
| 13 |
Forum: Backup & Recovery «»
Posted on: Thu, 06 July 2023 09:41 «»
By: Andrey_R
Re: RMAN restore - only DB backup ( no SF\CF\archivelog backup )
…
Thanks John.
I tried to do something similar, but wasn't sure it made sense, and also was hitting some errors, possibly doing other stuff wrong..
So trying now with some more awareness this time :
C:\Users\Administrator>oradim -new -sid …
|
| 14 |
Forum: Server Utilities «»
Posted on: Sun, 04 June 2023 06:13 «»
By: Solomon Yakobson
Re: sqlldr from Instantclient-21.9 on Win64: missing oranl.dll
… download and install Tools Instant Client - https://download.oracle.com/otn_software/nt/instantclient/2110000/instantclient-tools-windows.x64-21.10.0.0.0dbru.zip
Check https://www.oracle.com/database/technologies/instant-client.html for various instant …
|
| 15 |
Forum: Server Utilities «»
Posted on: Mon, 29 May 2023 11:31 «»
By: NevemTeve
Re: sqlldr from Instantclient-21.9 on Win64: missing oranl.dll
Download the full client and it will work. (The one which is not the InstantClient.)
https://www.oracle.com/database/technologies/oracle21c-windows-downloads.html
(See also this: https://logic.edchen.org/oracle-client-vs-oracle-client-home/ )
|
| 16 |
Forum: Performance Tuning «»
Posted on: Sun, 28 May 2023 05:13 «»
By: Andrey_R
Cannot force indexing on alert log query
…DBAs,
I am trying to query the alert log information from V$DIAG_ALERT_EXT and get bad performance.
I see that it's doing a full scan, in spite of me trying to set up parameters and hints to make it go with Index Scan:
SQL> alter session set …
|
| 17 |
Forum: Server Administration «»
Posted on: Tue, 25 April 2023 04:35 «»
By: John Watson
Database 23c Free now available
…noticed that 23c can now be downloaded,
https://www.oracle.com/database/free/
This "free" seems be an XE release, it has the same limits for CPU, RAM and storage. Anyone tried it yet?
The docs are here,
https://docs.oracle.com/en/database/…
|
| 18 |
Forum: Marketplace «»
Posted on: Thu, 20 April 2023 11:04 «»
By: Alexeyg
Devart Has Released a Major Update of dbForge Tools for MySQL
…
To learn more about the release, visit
https://blog.devart.com/watch-out-for-a-big-new-update-of-dbforge-tools-for-mysql.html
Simultaneously, Devart has released a new multidatabase solution called dbForge Edge, which includes dbForge Studio for…
|
| 19 |
Forum: Weblogic & Application Server «»
Posted on: Sat, 08 April 2023 07:10 «»
By: madurani
Re: Weblogic migration
…trying to invent your own. For example,
https://blogs.oracle.com/scoter/post/virt-v2v-in-action-migrate-virtual-machine-from-oracle-vm-to-oracle-linux-kvm
https://blogs.oracle.com/scoter/post/how-to-migrate-oracle-vm-to-oracle-linux-kvm
This "How …
|
| 20 |
Forum: Weblogic & Application Server «»
Posted on: Sat, 08 April 2023 03:23 «»
By: John Watson
Re: Weblogic migration
…rather than trying to invent your own. For example,
https://blogs.oracle.com/scoter/post/virt-v2v-in-action-migrate-virtual-machine-from-oracle-vm-to-oracle-linux-kvm
https://blogs.oracle.com/scoter/post/how-to-migrate-oracle-vm-to-oracle-linux-kvm…
|
| 21 |
Forum: Marketplace «»
Posted on: Mon, 03 April 2023 00:05 «»
By: Alexeyg
Meet dbForge Edge - Brand New Multidatabase Solution by Devart
…more about the recent release, refer to
https://blog.devart.com/meet-dbforge-edge-your-ultimate-multidatabase-solution.html
About Devart
Devart is one of the leading developers of database management and administration software, ALM …
|
| 22 |
Forum: Marketplace «»
Posted on: Thu, 23 March 2023 04:43 «»
By: Alexeyg
dbForge Tools for Oracle Come With a Great Big Update
…about the recent release, please visit
https://blog.devart.com/here-comes-the-great-big-update-of-dbforge-tools-for-oracle.html
About Devart
Devart is a multi-product company that develops advanced tools for database development and …
|
| 23 |
Forum: Reports & Discoverer «»
Posted on: Fri, 10 March 2023 10:36 «»
By: Barbara Boehmer
Re: subject total in matrix with group report
…at at time.
25 Building a Matrix Report
https://docs.oracle.com/cd/B14099_19/bi.1012/b13895/orbr_matrix.htm
This section should be particularly helpful
25.4 Add summaries to the single-query matrix
https://docs.oracle.com/cd/B14099_19/bi.1012/…
|
| 24 |
Forum: Server Utilities «»
Posted on: Thu, 09 March 2023 09:53 «»
By: NevemTeve
Re: sqlldr from Instantclient-21.9 on Win64: missing oranl.dll
Now, I'll try installing Visual C Redistributable from here:
https://learn.microsoft.com/en-us/cpp/windows/latest-supported-vc-redist?view=msvc-170
https://aka.ms/vs/17/release/vc_redist.x64.exe
Edit: Nope
|
| 25 |
Forum: SQL & PL/SQL «»
Posted on: Mon, 28 November 2022 11:05 «»
By: hissam78
Re: Value multiple
…se, appreciated if you guide to understand,
https://community.oracle.com/tech/apps-infra/discussion/1022313/convert-columns-to-row-equivalent-to-stragg-function-in-oracle-sql
I have tried the following website but showing error
https://www.ndsapps.…
|
| 26 |
Forum: Marketplace «»
Posted on: Tue, 16 August 2022 04:10 «»
By: Alexeyg
Major Update of dbForge Tools for MySQL Is Out
… more about the recent release, please visit https://blog.devart.com/the-enhanced-dbforge-tools-for-mysql-v9-1-are-out.html
About Devart
Devart is a multi-product company that develops advanced tools for database development and administration, ALM …
|
| 27 |
Forum: Marketplace «»
Posted on: Tue, 16 August 2022 04:10 «»
By: Alexeyg
Devart Launched Grand Update - dbForge Studio for MySQL became available on Linux and macOS
… more about the recent release, please visit https://blog.devart.com/meet-dbforge-studio-2022-for-mysql-now-available-on-linux-and-macos.html
About Devart
Devart is a multi-product company that develops advanced tools for database development and …
|
| 28 |
Forum: Server Administration «»
Posted on: Sat, 23 July 2022 15:35 «»
By: Andrey_R
Re: Parse statistic values don't seem to add up
…
Thanks Michel. Will do.
But I would like to just clarify..
Tom Kyte said:
So From what I understand:
Hard Parse - when you have nothin for the executed SQL in the cache library and you invest tons of work to produce an exec plan and …
|
| 29 |
Forum: Performance Tuning «»
Posted on: Thu, 21 July 2022 10:52 «»
By: Andrey_R
Re: Time metrics in V$SQL don't add up
…seem to be asking for the same thing here in 2010 https://community.oracle.com/tech/developers/discussion/1120738/the-meaning-of-elapsed-time-in-sql
Yet I've seen no good answer.
In one of them, some folks point out to this article https&#…
|
| 30 |
Forum: SQL & PL/SQL «»
Posted on: Thu, 30 June 2022 04:36 «»
By: thiyagarajancs
Re: SENDGRID | Curl
…utl_http.resp;
url varchar2(4000) := 'https://api.sendgrid.com/v3/mail/send';
name varchar2(4000);
buffer varchar2(4000);
content varchar2(4000) := '{"personalizations":[{"to":[{"email":"test@mydomain.in…
|
| 31 |
Forum: Reports & Discoverer «»
Posted on: Wed, 30 March 2022 02:21 «»
By: Michel Cadot
Re: download or convert report 6i into excel
https://bfy.tw/SoZ0
https://gprivate.com/5yqcu
|
| 32 |
Forum: Server Utilities «»
Posted on: Mon, 17 June 2024 11:08 «»
By: orHooha
Re: Not able to run expdp
…the export, it wouldn't apply to us.
https://docs.oracle.com/en/database/oracle/oracle-database/19/sutil/oracle-data-pump-export-utility.html#GUID-9BCE2098-A930-4547-8758 -E3A9C2A7A20B
"You can use the SERVICE_NAME parameter with the CLUSTER…
|
| 33 |
Forum: General «»
Posted on: Thu, 13 June 2024 04:51 «»
By: John Watson
MOS
Is MOS working at the moment? When I go to https://support.oracle.com/portal I'm getting this:
400 Bad Request
Request Header Or Cookie Too Large
nginx/1.22.1
Is MOS down for anyone else, or is it just me?
|
| 34 |
Forum: Server Administration «»
Posted on: Fri, 24 May 2024 10:46 «»
By: John Watson
Re: How to know if my oracle DB is on premise or cloud
…it" = TRUE gets around it.
This article,
https://www.dbi-services.com/blog/oracle-disables-your-multitenant-option-when-you-run-on-ec2/
describes using strace to find the function call that does it, apparently it is kgcs_clouddb_provider_detect…
|
| 35 |
Forum: SQL & PL/SQL «»
Posted on: Mon, 29 April 2024 04:11 «»
By: Barbara Boehmer
Re: insert data from csv file
You might also try SQL*Loader Express:
https://docs.oracle.com/en/database/oracle/oracle-database/19/sutil/oracle-sql-loader-express-mode.html
|
| 36 |
Forum: SQL & PL/SQL «»
Posted on: Sat, 20 April 2024 13:44 «»
By: John Watson
Re: Getting ancestors in hierarchies
https://www.orafaq.com/forum/m/686743
|
| 37 |
Forum: Server Administration «»
Posted on: Wed, 17 April 2024 02:49 «»
By: John Watson
Re: ALLOW_LEGACY_RECO_PROTOCOL
… guide chapters on distributed databases,
https://docs.oracle.com/en/database/oracle/oracle-database/23/admin/distributed-database-concepts.html
we have:
All the discussion is about guaranteeing ACID compliance across a distributed database by …
|
| 38 |
Forum: Server Administration «»
Posted on: Wed, 17 April 2024 01:49 «»
By: Alien
Re: ALLOW_LEGACY_RECO_PROTOCOL
Hi John,
I presume this has to do with the new raft replication: https://blogs.oracle.com/database/post/raft-replication-in-distributed-23c
Regards,
Arian
|
| 39 |
Forum: Server Administration «»
Posted on: Tue, 16 April 2024 05:05 «»
By: John Watson
ALLOW_LEGACY_RECO_PROTOCOL
…can find for it is in the DB Reference,
https://docs.oracle.com/en/database/oracle/oracle-database/23/refrn/ALLOW_LEGACY_RECO_PROTOCOL.html
which implies that Uncle Oracle has a new (and presumably better) way for managing distributed transactions, …
|
| 40 |
Forum: Server Utilities «»
Posted on: Fri, 12 April 2024 19:42 «»
By: Barbara Boehmer
Re: impd data only from one table to another table
… expdp and impdp and required privileges:
https://oracle-base.com/articles/10g/oracle-data-pump-10g#NetworkExportsImports
Although it looks like you can import without a dumpfile, you may still need to specify a directory even if you are not using a…
|
Blog
Search
Help
Members
Register
Login
Home