I installed the Oracle 21c database and used Sql Developer to log on as sys and created a users named testuser, password password1. See screenshot below:
Next I attempted to log on as that user with Sql Developer and SqlPlus and could not. See screenshot below:
This is the tnsnames.ora:
# tnsnames.ora Network Configuration File: C:\app\ChartierpwAT2024\homes\OraDB21Home1\NETWORK\ADMIN\tnsnames.ora
# Generated by Oracle configuration tools.
LISTENER_ORCL =
(ADDRESS = (PROTOCOL = TCP)(HOST = 2scheduleathom)(PORT = 1521))
ORACLR_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
)
(CONNECT_DATA =
(SID = CLRExtProc)
(PRESENTATION = RO)
)
)
ORCL =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 2scheduleathom)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl)
)
)
This is the listener.ora:
# listener.ora Network Configuration File: C:\app\ChartierpwAT2024\homes\OraDB21Home1\NETWORK\ADMIN\listener.ora
# Generated by Oracle configuration tools.
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = CLRExtProc)
(ORACLE_HOME = C:\OracleDatabase21C)
(PROGRAM = extproc)
(ENVS = "EXTPROC_DLLS=ONLY:C:\OracleDatabase21C\bin\oraclr.dll")
)
)
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 2scheduleathom)(PORT = 1521))
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
)
)
I had this exact same issue with the 23ai FREE version of the database and could not get the connection to work. So I uninstalled it and installed 21c and I'm having the exact same issue. I have no idea why this is happening, I'm obviously using the correct username and password. Have I installed the database wrong? Is there something I missed?