Hi Folks,
New installations of Oracle 11C on RHEL 8.4 result in an unusable TNS Listener??
RHEL FW is disabled, SE Linux is disabled, hostname is resolvable and pingable
I start with Software only setup
start the listener with lsnrctl start, this works, then I use dbac to create my DB, this also works, however, if I try to connect to my DB with the following, I get an error:
sqlplus /@db as sysdba
ORA-12154: TNS:could not resolve the connect identifier specified
Exactly the same installation on Windows works fine??
If I try to create a new listener, I get to the point where I have to specify the port and no matter what port number I select, I am told that the port is already in use, when I know there is nothing else on this server?!
What is weird is that if I use an sqlplus command to connect to my server using an IP Address it succeeds??
Example
Windows based Oracle:
C:\Users\Administrator>sqlplus /@db as sysdba
SQL*Plus: Release 19.0.0.0.0 - Production on Fri Aug 19 15:15:29 2022
Version 19.3.0.0.0
Copyright (c) 1982, 2019, Oracle. All rights reserved.
Connected to:
Oracle Database 19c Standard Edition 2 Release 19.0.0.0.0 - Production
Version 19.3.0.0.0
Linux based Oracle
[oracle@ora-19c-02 dbhome_1]$ sqlplus /@db as sysdba
SQL*Plus: Release 19.0.0.0.0 - Production on Fri Aug 19 16:50:24 2022
Version 19.3.0.0.0
Copyright (c) 1982, 2019, Oracle. All rights reserved.
ERROR:
ORA-12154: TNS:could not resolve the connect identifier specified
If I try the network based sqlplus connection I get
[oracle@ora-19c-02 dbhome_1]$ sqlplus "sys@172.16.8.66:1521/db as sysdba"
SQL*Plus: Release 19.0.0.0.0 - Production on Fri Aug 19 16:51:28 2022
Version 19.3.0.0.0
Copyright (c) 1982, 2019, Oracle. All rights reserved.
Enter password:
Connected to:
Oracle Database 19c Standard Edition 2 Release 19.0.0.0.0 - Production
Version 19.3.0.0.0
Any thoughts or comments?