Oracle's sqlcl ORA-01005: null password given; logon denied on new RHEL8 install, but not nearly identically configured old RHEL7

dacracot

1/30/23, 4:05 PM

ON RHEL7...

$ sql bagsbx1/password@jdbc:oracle:thin:@mydbdev.dacracot.org:1521/bagdev.dacracot.org

SQLcl: Release 20.3 Production on Thu Sep 30 07:06:15 2021

Copyright (c) 1982, 2021, Oracle.  All rights reserved.

Last Successful login time: Thu Sep 30 2021 07:06:16 -07:00

Connected to:
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.12.0.0.0


SQL> quit
Disconnected from Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.12.0.0.0

On RHEL8...

$ sql bagsbx1/password@jdbc:oracle:thin:@mydbdev.dacracot.org:1521/bagdev.dacracot.org


SQLcl: Release 20.3 Production on Thu Sep 30 07:06:15 2021

Copyright (c) 1982, 2021, Oracle.  All rights reserved.

  USER          = bagsbx1
  URL           = jdbc:oracle:thin:@mydbdev.dacracot.org:1521/bagdev.dacracot.org
  Error Message = ORA-01005: null password given; logon denied
Username? (RETRYING) ('bagsbx1/*********@jdbc:oracle:thin:@mydbdev.dacracot.org:1521/bagdev.dacracot.org'?)

They two systems are as identically configured as they can be.

The Java installed is...

$ java -version
openjdk version "11.0.12" 2021-07-20 LTS
OpenJDK Runtime Environment 18.9 (build 11.0.12+7-LTS)
OpenJDK 64-Bit Server VM 18.9 (build 11.0.12+7-LTS, mixed mode, sharing)

159

0 + 0

oracle

rhel7

rhel8

dacracot

1/30/23, 4:54 PM

Since going to openJDK 11, I've had to remove the java.endorsed.dirs JVM parameter from other runtimes. I'm wondering if sqlcl is still setting it and causing an issue. Wonder how I could remove it?

Elon Musk

I sit in a Tesla and translated this thread with Ai:

EN: Oracle's sqlcl ORA-01005: null password given; logon denied on new RHEL8 install, but not nearly identically configured old RHEL7

TH: Oracle's sqlcl ORA-01005: ให้รหัสผ่าน null; การเข้าสู่ระบบถูกปฏิเสธในการติดตั้ง RHEL8 ใหม่ แต่ไม่ได้กำหนดค่า RHEL7 เก่าเกือบเหมือนกัน

RO: Oracle's sqlcl ORA-01005: parola nulă dată; conectare a fost refuzată la instalarea RHEL8 nouă, dar nu a fost configurat aproape identic vechiul RHEL7

RU: Oracle sqlcl ORA-01005: указан нулевой пароль; вход в систему запрещен при новой установке RHEL8, но почти не идентично настроенному старому RHEL7

VI: sqlcl ORA-01005 của Oracle: mật khẩu null được cung cấp; đăng nhập bị từ chối khi cài đặt RHEL8 mới, nhưng RHEL7 cũ không được cấu hình gần như giống hệt nhau

Post an answer

Most people don’t grasp that asking a lot of questions unlocks learning and improves interpersonal bonding. In Alison’s studies, for example, though people could accurately recall how many questions had been asked in their conversations, they didn’t intuit the link between questions and liking. Across four studies, in which participants were engaged in conversations themselves or read transcripts of others’ conversations, people tended not to realize that question asking would influence—or had influenced—the level of amity between the conversationalists.