Skip to Main Content
Forums

Oracle Database Express Edition (XE)

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Why does SQLcl fail to connect thinclient to the XE database?

User_OOTEXApr 14 2021

I installed Database Express Edition (XE) 18c and can connect to the default XE database using SQL*Plus without issue.
I had a previous installation of SQLcl 20.4 that I can still use to connect to *other oracle databases as shown below.
sql\sqlcl\bin> ./sql -verbose -noupdates /nolog
SQLcl: Release 20.4 Production on Wed Apr 14 09:53:06 2021
Copyright (c) 1982, 2021, Oracle. All rights reserved.
2021-04-14 09:53:06.668 INFO oracle.dbtools.raptor.utils.TNSHelper getOracleHome Checking found key for ORACLE_HOME:SOFTWARE\ORACLE\KEY_OraDB18Home1
2021-04-14 09:53:06.700 INFO oracle.dbtools.raptor.utils.TNSHelper getOracleHome Checking found key for ORACLE_HOME:null
2021-04-14 09:53:06.700 INFO oracle.dbtools.raptor.utils.TNSHelper getOracleHome Checking found key for ORACLE_HOME:null
2021-04-14 09:53:06.700 INFO oracle.dbtools.raptor.utils.TNSHelper getOracleHome Checking found key for ORACLE_HOME:null
2021-04-14 09:53:06.700 INFO oracle.dbtools.raptor.utils.TNSHelper getOracleHome Checking found key for ORACLE_HOME:SOFTWARE\ORACLE\KEY_OraDB18Home1
2021-04-14 09:53:06.700 INFO oracle.dbtools.raptor.utils.TNSHelper getOracleHome Checking found key for ORACLE_HOME:null
2021-04-14 09:53:06.700 INFO oracle.dbtools.raptor.utils.TNSHelper getOracleHome Checking found key for ORACLE_HOME:null
2021-04-14 09:53:06.700 INFO oracle.dbtools.raptor.utils.TNSHelper getOracleHome Checking found key for ORACLE_HOME:null
2021-04-14 09:53:06.700 INFO oracle.dbtools.raptor.newscriptrunner.SQLPlusProviderForSQLPATH getOracleEnv Checking found key for ORACLE_HOME:SOFTWARE\ORACLE\KEY_OraDB18Home1
2021-04-14 09:53:06.700 INFO oracle.dbtools.raptor.newscriptrunner.SQLPlusProviderForSQLPATH getOracleEnv Checking found ORACLE_HOME:C:\app\rmj6\oracle_express\18.0.0\dbhomeXE\dbs
2021-04-14 09:53:06.700 INFO oracle.dbtools.raptor.newscriptrunner.SQLPlusProviderForSQLPATH getOracleEnv Checking found key for ORACLE_HOME:null
2021-04-14 09:53:06.700 INFO oracle.dbtools.raptor.newscriptrunner.SQLPlusProviderForSQLPATH getOracleEnv Checking found key for ORACLE_HOME:null
2021-04-14 09:53:06.700 INFO oracle.dbtools.raptor.newscriptrunner.SQLPlusProviderForSQLPATH getOracleEnv Checking found key for ORACLE_HOME:null

SQL> CONNECT rmj6/password@//aup-banrodb11.it.usf.edu:1526/PROD_RO

2021-04-14 10:13:24.604 INFO oracle.dbtools.raptor.utils.TNSHelper checkForTns Checking for tnsnames.* in :C:\Users\rmj6
2021-04-14 10:13:24.605 INFO oracle.dbtools.raptor.utils.TNSHelper getTNSFileContent Checking Registry for ORACLE_HOME
2021-04-14 10:13:24.606 INFO oracle.dbtools.raptor.utils.TNSHelper getTNSFileContent Checking found key for ORACLE_HOME:SOFTWARE\ORACLE\KEY_OraDB18Home1
2021-04-14 10:13:24.607 INFO oracle.dbtools.raptor.utils.TNSHelper getTNSFileContent Checking found key for TNS_ADMIN:null
2021-04-14 10:13:24.607 INFO oracle.dbtools.raptor.utils.TNSHelper getTNSFileContent Checking found ORACLE_HOME:C:\app\rmj6\oracle_express\18.0.0\dbhomeXE
2021-04-14 10:13:24.608 INFO oracle.dbtools.raptor.utils.TNSHelper getTNSEntries Using TNS info from :C:\app\rmj6\oracle_express\18.0.0\dbhomeXE\network\admin
2021-04-14 10:13:24.720 INFO oracle.dbtools.raptor.newscriptrunner.SQLPLUS logConnectionURL Attempting to connect using URL= "jdbc:oracle:oci8:@//aup-banrodb11.it.usf.edu:1526/PROD_RO"
2021-04-14 10:13:24.759 INFO oracle.dbtools.jdbc.util.LogUtil log oracle.dbtools.jdbc.orest.Driver:<clinit>:38:No Message
2021-04-14 10:13:24.759 INFO oracle.dbtools.jdbc.util.LogUtil log oracle.dbtools.jdbc.orest.Driver:<clinit>:45::ORest driver loaded
2021-04-14 10:13:25.252 INFO oracle.dbtools.jdbc.util.LogUtil log oracle.dbtools.jdbc.orest.Driver:acceptsURL:80:No Message
2021-04-14 10:13:25.471 INFO oracle.dbtools.raptor.newscriptrunner.SQLPLUS logConnectionURL Attempting to connect using URL= "jdbc:oracle:thin:@//aup-banrodb11.it.usf.edu:1526/PROD_RO"
2021-04-14 10:13:25.472 INFO oracle.dbtools.jdbc.util.LogUtil log oracle.dbtools.jdbc.orest.Driver:acceptsURL:80:No Message
Connected.
2021-04-14 10:13:27.302 INFO oracle.dbtools.raptor.scriptrunner.commands.NLSLANGListener runOnConnect NLS_LANG is not set

SQL>

HOWEVER I am unable to connect to XE using SQLcl

SQL> connect sys/Joedata@localhost:1521/XE as SYSDBA

2021-04-14 10:50:12.025 INFO oracle.dbtools.raptor.utils.TNSHelper checkForTns Checking for tnsnames.* in :C:\Users\rmj6
2021-04-14 10:50:12.025 INFO oracle.dbtools.raptor.utils.TNSHelper getTNSFileContent Checking Registry for ORACLE_HOME
2021-04-14 10:50:12.025 INFO oracle.dbtools.raptor.utils.TNSHelper getTNSFileContent Checking found key for ORACLE_HOME:SOFTWARE\ORACLE\KEY_OraDB18Home1
2021-04-14 10:50:12.030 INFO oracle.dbtools.raptor.utils.TNSHelper getTNSFileContent Checking found key for TNS_ADMIN:null
2021-04-14 10:50:12.030 INFO oracle.dbtools.raptor.utils.TNSHelper getTNSFileContent Checking found ORACLE_HOME:C:\app\rmj6\oracle_express\18.0.0\dbhomeXE
2021-04-14 10:50:12.030 INFO oracle.dbtools.raptor.utils.TNSHelper getTNSEntries Using TNS info from :C:\app\rmj6\oracle_express\18.0.0\dbhomeXE\network\admin
2021-04-14 10:50:12.061 INFO oracle.dbtools.raptor.newscriptrunner.SQLPLUS logConnectionURL Attempting to connect using URL= "jdbc:oracle:oci8:@localhost:1521/XE"
2021-04-14 10:50:12.061 INFO oracle.dbtools.jdbc.util.LogUtil log oracle.dbtools.jdbc.orest.Driver:<clinit>:38:No Message
2021-04-14 10:50:12.077 INFO oracle.dbtools.jdbc.util.LogUtil log oracle.dbtools.jdbc.orest.Driver:<clinit>:45::ORest driver loaded
2021-04-14 10:50:12.187 INFO oracle.dbtools.jdbc.util.LogUtil log oracle.dbtools.jdbc.orest.Driver:acceptsURL:80:No Message
2021-04-14 10:50:12.279 INFO oracle.dbtools.raptor.newscriptrunner.SQLPLUS logConnectionURL Attempting to connect using URL= "jdbc:oracle:thin:@localhost:1521/XE"
2021-04-14 10:50:12.279 INFO oracle.dbtools.jdbc.util.LogUtil log oracle.dbtools.jdbc.orest.Driver:acceptsURL:80:No Message
USER = sys
URL = jdbc:oracle:oci8:@localhost:1521/XE
Error Message = no ocijdbc21 in java.library.path
USER = sys
URL = jdbc:oracle:thin:@localhost:1521/XE
Error Message = ORA-01017: invalid username/password; logon denied

I do not understand why I get this no ocijdbc21 in java.library.path error when connecting to one database but not another.

Any assistance would be greatly appreciated.
This post has been answered by User_OOTEX on May 5 2021
Jump to Answer

Comments

Post Details

Added on Apr 14 2021
3 comments
355 views