I can work with cmd normally with sql.
I can authenticate with sqlplus to my database with oracle.
Following command works with cmd sqlplus / as sysdba
but not with wsl 2 v18. with command sql
Password? (**********?) ************
Connection failed
USER = SYS
URL = jdbc:oracle:oci8:@
Error Message = ORA-12547: TNS:lost contact
USER = SYS
URL = jdbc:oracle:thin:@127.0.0.1:1521:XE
Error Message = IO Error: Got minus one from a read call, connect lapse 5 ms., Authentication lapse 0 ms.```
I also tried with same prompt
Prompt: sqlplus / as sysdba
```SQL*Plus: Release 21.0.0.0.0 - Production on Sun Aug 4 16:46:12 2024
Version 21.3.0.0.0
Copyright (c) 1982, 2021, Oracle. All rights reserved.
ERROR:
ORA-12547: TNS:lost contact
Enter user-name:```
My configuration listener.ora is
daewon@sysdaewonpcmain:/mnt/c/project/master/env$ cat
/opt/oracle/product/21c/dbhomeXE/network/admin/listener.ora
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = sysdaewonpcmain)(PORT = 1521))
)
)
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(GLOBAL_DBNAME = XE)
(SID_NAME = XE)
(ORACLE_HOME = /opt/oracle/product/21c/dbhomeXE)
)
)
and my tnsnames.ora is
daewon@sysdaewonpcmain:/mnt/c/project/master/env$ cat /opt/oracle/product/21c/dbhomeXE/network/admin/tnsnames.ora
XE =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = sysdaewonpcmain)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = XE)
)
)
LISTENER_XE =
(ADDRESS = (PROTOCOL = TCP)(HOST = sysdaewonpcmain)(PORT = 1521))`
XESYSDBA =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = sysdaewonpcmain)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = XE)
)
)“`
user26634099 is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.