TNSNAMES, How and Why
Local Naming = TNSNAMES Whenever we need to connect to the database, we usually provide a connection string by easy connect like this: SQL> conn… Read More »TNSNAMES, How and Why
Network
Where is NETCA Log Location
NETCA Log Location Two locations that you can see the trace log of Net Configuration Assistant (NETCA). NETCA log location The file path and name… Read More »Where is NETCA Log Location
How to Resolve TNS-01201: Listener cannot find executable
TNS-01201 After adding a static service to the local listener, I tried to start the listener, but it failed with TNS-01201. [oracle@test ~]$ vi $ORACLE_HOME/network/admin/listener.ora… Read More »How to Resolve TNS-01201: Listener cannot find executable
How to Resolve ORA-24247: network access denied by access control list (ACL)
ORA-24247 There're two error patterns of ORA-24247 in this post. Resolve or Connect Privilege Debug Mode in SQL Developer Resolve or Connect Privilege For 10g… Read More »How to Resolve ORA-24247: network access denied by access control list (ACL)
How to Resolve ORA-17628: Oracle error 1031 returned by remote Oracle server
ORA-17628 In some situations, you might see errors like the following when cloning a remote pluggable database (PDB): SQL> create pluggable database finance_pdb from finanpdb@link_to_test1… Read More »How to Resolve ORA-17628: Oracle error 1031 returned by remote Oracle server
What GLOBAL_NAMES do to DB Links
GLOBAL_NAMES Normally, we turned off GLOBAL_NAMES to prevent additional check on remote database before connecting to it. This is because we know where we are… Read More »What GLOBAL_NAMES do to DB Links
How to Resolve ORA-12154: TNS:could not resolve the connect identifier specified
ORA-12154 ORA-12154 means that your connection tools (e.g. sqlplus) cannot use TNSNAMES naming method for some reason. This reminds me that there're same error patterns… Read More »How to Resolve ORA-12154: TNS:could not resolve the connect identifier specified
SQLPlus Connect without Tnsnames
SQLPlus without Tnsnames We usually connect a database by sqlplus through tnsnames.ora, but sometimes we are not allowable to change or access tnsnames.ora, even worse,… Read More »SQLPlus Connect without Tnsnames
DB Link, How and Why
What is DB Link? A database link is a kind of schema object in a database that enables users to access and manipulate objects on… Read More »DB Link, How and Why
How to Resolve ORA-12514: TNS:listener does not currently know of service requested in connect
ORA-12514 ORA-12514 means that the listener cannot find any matched service with yours, so it cannot establish the connection with the database for you. As… Read More »How to Resolve ORA-12514: TNS:listener does not currently know of service requested in connect