Lightnews — Scholar-powered news

Piotr Wrzosek @pewu78.bsky.social · 4d

"This section is not visible to customers"
Not really.

Piotr Wrzosek @pewu78.bsky.social · 4d

Looks like it's not available anymore, my SR regarding this was closed with something like "Internal bug was submitted for investigation, but hey, we got that alternate features "Look-up By Error or Error Code's First Argument" or "Search by Stack Trace" added which replace it.
For real?🤦‍♂️

Piotr Wrzosek @pewu78.bsky.social · Jul 1

ORA-600/ORA-7445 Troubleshooting tools on MOS are not working for me - at least since yesterday.

1 2

Piotr Wrzosek @pewu78.bsky.social · 20d

I just hate OEDA. You can't use it offline despite what the readme says (no, it doesn't save js libraries) and it's so damn bugged it's impossible to get what you need.

Piotr Wrzosek @pewu78.bsky.social · Sep 9

AHF 25.7 is marked as obsolete and cannot be downloaded. It's the latest available version. You can download it directly from the AHF Doc ID 2550798.1, but there are no checksums there.
WTH?

Reposted by Piotr Wrzosek

Tanel Poder @tanelpoder.com · Aug 13

Better yet, join next Tuesday's launch webinar!

tanelpoder.com/posts/xtop-t...

xtop - Top for Wall-Clock Time - Tanel Poder Consulting

The two screencasts below are a preview of what’s coming next week, when I formally introduce the latest xtop and xcapture v3 to the world. On next Tuesday, 19th August at 1pm EDT, I’ll up...

tanelpoder.com

2 2

Piotr Wrzosek @pewu78.bsky.social · Aug 13

MOS AI assistant does that too:
bsky.app/profile/pewu...

Piotr Wrzosek @pewu78.bsky.social · Apr 11

Have you seen new AI assisted search on MOS?
I can see the potential here, but...
Why 21c?
Why fixed 280px answer area size? (increased it in console for the screenshot so you can see it all)
And who can first spot where it hmm... let it's imagination run wild and misleads us?

Piotr Wrzosek @pewu78.bsky.social · Aug 13

I got "There has been a critical error on this website." message only for a long time when visiting your blog.

Piotr Wrzosek @pewu78.bsky.social · Jul 30

OK, looks like it's not mentioned directly in changelog.

Piotr Wrzosek @pewu78.bsky.social · Jul 30

What version of AU introduced that (and other home_settings options)?

1 1

Piotr Wrzosek @pewu78.bsky.social · Jul 30

a group of minions are standing next to each other and they are laughing and saying yay

ALT: a group of minions are standing next to each other and they are laughing and saying yay

media.tenor.com

Piotr Wrzosek @pewu78.bsky.social · Jul 23

That's even more complicated, it changed in the past over the versions - it worked, then not without some workarounds, as of now it's fixed after my SR.
Full story here:
bsky.app/profile/pewu...

Piotr Wrzosek @pewu78.bsky.social · Jul 8

Finally, after 8 months of waiting the #SQLcl 25.2 release fixes this issue.
It took me great effort to fill the SR, deal with the clueless person handling it for several months, escalate, etc. to reach this goal. To just get back to where it was working in 24.1.
Should be happy but I'm more tired.

Piotr Wrzosek @pewu78.bsky.social · Nov 26

...and unfortunately that was the case with SQLcl 21.1 up to 24.1, but since 24.2 it is not working anymore and requires additional ?tns_admin= connection parameter ☹️
@thatjeffsmith.com @martindba.bsky.social - can anyone look at this regression?

1

Piotr Wrzosek @pewu78.bsky.social · Jul 22

Cannot open SQLcl from SQLDev due to this error, but I can connect successfully from the edit connection window as the password field is not checked for content there.

1

Piotr Wrzosek @pewu78.bsky.social · Jul 22

For me just released SQLDev 25.2.2 finally started to work, I can now connect without getting some error and what's more even secure external password store (oracle wallet) connection type started to work! The only issue is when trying to connect from connections list, it expects to enter password.

2

Reposted by Piotr Wrzosek

Oracle Exadata Product Management @exadatapm.bsky.social · Jul 15

#Oracle #Exadata System Software #25ai (25.2) is here! 🚀 Enjoy accelerated AI Vector Search, performance boosts, smarter #Exascale management, and enhanced security (SELinux by default). Thanks to our stellar Engineering & PM teams for making it happen! blogs.oracle.com/exadata/post/exadata252

blogs.oracle.com

5 9

Piotr Wrzosek @pewu78.bsky.social · Jul 8

And turns out the connection to source CDB SID is redirected to the hostname of new CDB, but to the management name not VIP so not working properly too. But anyway why CDB when it's PDB that's being relocated?!?
Either way it screws up EM monitoring and backups.
It's all a mess.

Piotr Wrzosek @pewu78.bsky.social · Jul 8

PDB services are running, local listener reports them but scans not, so connections are refused with ORA-12514. LISTENER_NETWORKS is not updated, no chance of connection forwarding. On top of that ORA-00600 [krbbbdr_bad_guid] occurs during backup of tombstone PDB files supposedly due to Bug 36534336

1

Piotr Wrzosek @pewu78.bsky.social · Jul 8

Trying to make PDB relocation in availability max mode working (Doc ID 2771737.1) and it's a mess. PDB relocates successfully, but after opening it source CDB logs following error in alert.log: "ORA-12792: Network transfer operation aborted due to TTC error 3111".

1

Piotr Wrzosek @pewu78.bsky.social · Jul 8

On a downside what hasn't changed is #SQLcl still defaults to thick connection on Windows, even with no client present in path/env, while on Linux it's opposite. Why? 🤷‍♂️
Reported it also in the same SR to no effect...
For reference this thread describes my initial findings: bsky.app/profile/pewu...

Piotr Wrzosek @pewu78.bsky.social · Nov 20

I dedicate my first tech post to my first follower :)
#SQLcl 24.3 brings new interesting feature for CI/CD - the 'project' command - which I'll definitely test, but for now I'm happy to see inclusion of 23 JDBC driver which finally aligns well with e.g. instant client 23.5 (no more version mismatch)

1

Piotr Wrzosek @pewu78.bsky.social · Jul 8

Another thing worth to mention is #SQLcl now seems to be not so much dependant on JDBC driver version when using thick connection and works with any 23 client (tested IC 23.5-23.8) as long as it's in the path. I don't find the selected excerpt from release notes to be true, it doesn't work that way.

1

Piotr Wrzosek @pewu78.bsky.social · Jul 8

Finally, after 8 months of waiting the #SQLcl 25.2 release fixes this issue.
It took me great effort to fill the SR, deal with the clueless person handling it for several months, escalate, etc. to reach this goal. To just get back to where it was working in 24.1.
Should be happy but I'm more tired.

Piotr Wrzosek @pewu78.bsky.social · Nov 26

...and unfortunately that was the case with SQLcl 21.1 up to 24.1, but since 24.2 it is not working anymore and requires additional ?tns_admin= connection parameter ☹️
@thatjeffsmith.com @martindba.bsky.social - can anyone look at this regression?

1

Piotr Wrzosek @pewu78.bsky.social · Jul 2

They removed it along with /opt/oracle/dbserver/dbms/java/lib/jli
due to switching JDK11 to JDK17 for Exadata software, but the default JDK was 1.8 and should not be touched:
ldd /usr/bin/java
[...]
libjli.so => not found

1

Piotr Wrzosek @pewu78.bsky.social · Jul 2

Just spent several hours of diagnosing why java 1.8 won't start when executed from database on #Exadata 25 only to find out Oracle decided to omit /usr/java/default/lib/amd64/jli from /etc/ld.so.conf.d/dbmmgmt.conf 😠
And I think I know why...

1

Piotr Wrzosek @pewu78.bsky.social · Jul 1

ORA-600/ORA-7445 Troubleshooting tools on MOS are not working for me - at least since yesterday.

Piotr Wrzosek @pewu78.bsky.social · Jun 20

Where is the Standalone CVU for Oracle Database 19 on Linux x86-64 ?!?
For HP-UX Itanium CVU version 19.27 April 2025 was already released in Nov-2023 🤣

Reposted by Piotr Wrzosek

Daniel Overby Hansen @dohdatabase.com · Jun 17

You can now use AutoUpgrade as part of your server provisioning to install an Oracle home on a brand-new server.

AutoUpgrade New Features: Install Oracle Home on Brand-New, Empty Server

You can use AutoUpgrade to install an Oracle home on a brand-new, empty server. Previously, AutoUpgrade used an existing Oracle home to determine how to create a new Oracle home. Now, you can use config file parameters to instruct AutoUpgrade on installing the new Oracle home. This allows you to use AutoUpgrade to prepare a new server for use with Oracle Database.

dohdatabase.com

2 7