Score:0

ORA-210000 Oracle error: ORA-12154: TNS:could not resolve the connect identifier specified

ca flag

I am trying to setup a connection from my rhel 7.9 machine to my oracle host db on windows server 2016 running oracle 19c.

04:25:36 - ORA-210000 Oracle error: ORA-12154: TNS:could not resolve the connect identifier specified

I've downloaded and installed 2 clients, version 19 and 21 hoping that it would resolve the issue but it doesnt. My tnsnames.ora file is being used in another windows installation to connect to the same oracle db host and works fine, but fails on the linux vm.

 /opt/oracle/instantclient_21_5/network/admin/tnsnames.ora
/opt/oracle/instantclient_19_14/network/admin/tnsnames.ora

any ideas what it could be?

error

Also, any idea why the following file is flashing? is there an error, this is all my local environment im learning linux, but not sure why this is flashing.

enter image description here

Also installed sql plus and i got the following error, btw how do I know sqlplus is referencing correctly tnsnames.ora file?

Here is my environment variables

export ORACLE_HOME=/opt/oracle/instantclient_21_25 export TNS_ADMIN=$ORACLE_HOME/network/admin export LD_LIBRARY_PATH=$ORACLE_HOME/lib:$LD_LIBRARY_PATH

enter image description here

cn flag
`sqlplus is referencing correctly tnsnames.ora file` TNSPing usually shows this in the output. https://docs.oracle.com/cd/E11882_01/network.112/e41945/connect.htm#NETAG378
Score:1
cn flag

ORA-12162: TNS:net service name is incorrectly specified

I would suggest that connections through TNS generally look more like this:

username@tns_alias

Given only a single entry, I'm pretty sure that Oracle will assume that you've given it a username and that you want to connect to the database identified by the ORACLE_SID environment variable.

Try something more like ...

sqlplus username@ACCFDA

... and see if you get any further.

(I recommend not using any of the "as sys..." options remotely.
If you want to do anything "serious" with your database, get yourself onto the local host to do it!).

mangohost

Post an answer

Most people don’t grasp that asking a lot of questions unlocks learning and improves interpersonal bonding. In Alison’s studies, for example, though people could accurately recall how many questions had been asked in their conversations, they didn’t intuit the link between questions and liking. Across four studies, in which participants were engaged in conversations themselves or read transcripts of others’ conversations, people tended not to realize that question asking would influence—or had influenced—the level of amity between the conversationalists.