Archive for the ‘Oracle TNS’ Category

21 Dec

Common Oracle TNS Errors

Posted by mohibalvi in Oracle TNS. Tagged: , , , .

In this post , I am trying to cover common TNS errors and possible corrective measures. ORA-12154: TNS:could not resolve service name SQL> connect SYSTEM/manager@DEV ERROR: ORA-12154: TNS:could not resolve service name The most common TNS error mostly due to multiple ORACLE HOME, tnsnames.ora and sqlnet.ora conflicts. Check that the instance or database name is [...]

Continue reading »

23 Feb

Oracle Network Issues Link

Posted by mohibalvi in Listener, oracle, Oracle Issues, Oracle Network, Oracle TNS. Tagged: , , , , .

Network DBA This link contains common network issues for Oracle Connectivity along with brief description of network files. NETWORK DBA  1. LISTENER.ORA file It is a server side file and contains information regarding network configuration parameters. It can be found in the ORACLE_HOME/network/admin directory on the server. Sample File SID_LIST_LISTENER =   (SID_LIST =     [...]

Continue reading »

Follow

Get every new post delivered to your Inbox.