I have two databases on a seperate DB server. One of the db I can connect to and the other one I can't either using TOAD or SQLPLUS. For both Apps, I get the ORA-12514: TNS:listener does not currently know of service requested in connect
descriptor error message. I have tried to do several things on the DB server.
- I have managed to login to the database on the DB server using lsnrctl / as sysdba after setting the ORACLE_HOME and ORACLE_SID paremeters. In this way I have checked the instance status which says open.
- I have added the local_listener parameter to the file init.ora (but the file name is specific to the db ,, et initKY734DW2.ora)
- Do note that the port is 1531, in this as well as in the tnsnames.ora, which is the same as the working DB
- While logged into sqlplus on the DB server I have run ALTER SYSTEM REGISTER
- I have also stop and started the DB using the following commands
SHUTDOWN ABORT;
STARTUP NOMOUNT;
ALTER DATABASE MOUNT;
ALTER DATABASE OPEN
- I have then checked that the DB is OPEN
- When I run lsnrctl services, the database Instance shows up as being UNKNOWN
Not that I understand what that means.
- I have stopped and started the listener
- I have restarted the server
With the DB that works, it works without the entry in the init.ora file.
- There is no access issues seeing as I can run the other DB with no issues
- At one stage, I was able to get to this DB, so I am not sure what has changed
Most of these things I have tried, using co-pilot, but it starts to go round and round in circles, so if anyone knows of anything else I can try, it would be most appreciated.
- This is a Windows environment (reiterating that the DB server is a separate server)
- DB is 19C