Listener

How to Resolve TNS-12541: TNS:no listener

Posted on
TNS-12541 Let’s see how we reproduce TNS-12541. C:\Users\ed>tnsping compdb TNS Ping Utility for 64-bit Windows: Version 12.1.0.1.0 – Production on 22-JUL-2014 19:20:06 Copyright (c) 1997, 2013, Oracle.  All rights reserved. Used parameter files: C:\oracle\app\client\ed\product\12.1.0\client_1\network\admin\sqlnet.ora Used TNSNAMES adapter to resolve the alias Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = primary01)(PORT = 1521)) […]
SQLNET

How to Resolve TNS-12547: TNS:lost contact

Posted on
TNS-12547 Let’s see how we reproduce TNS-12547. C:\Users\ed>tnsping compdb 100 TNS Ping Utility for 64-bit Windows: Version 12.1.0.1.0 – Production on 22-JUL-2014 19:26:03 Copyright (c) 1997, 2013, Oracle.  All rights reserved. Used parameter files: C:\oracle\app\client\ed\product\12.1.0\client_1\network\admin\sqlnet.ora Used TNSNAMES adapter to resolve the alias Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = primary0 1)(PORT […]
Firewalld

How to Resolve TNS-12535: TNS:operation timed out

Posted on
TNS-12535 Let’s see how we reproduce TNS-12535. C:\Users\ed>tnsping compdb TNS Ping Utility for 64-bit Windows: Version 12.1.0.1.0 – Production on 22-JUL-2014 19:03:21 Copyright (c) 1997, 2013, Oracle.  All rights reserved. Used parameter files: C:\oracle\app\client\ed\product\12.1.0\client_1\network\admin\sqlnet.ora Used TNSNAMES adapter to resolve the alias Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = primary01)(PORT = 1521)) […]
SQLNET

How to Resolve TNS-12545: Connect failed because target host or object does not exist

Posted on
TNS-12545 Let’s see how we reproduce TNS-12545. C:\Users\ed>tnsping compdb TNS Ping Utility for 64-bit Windows: Version 12.1.0.1.0 – Production on 21-JUL-2014 19:10:59 Copyright (c) 1997, 2013, Oracle.  All rights reserved. Used parameter files: C:\oracle\app\client\ed\product\12.1.0\client_1\network\admin\sqlnet.ora Used TNSNAMES adapter to resolve the alias Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = primary01)(PORT = 1521)) […]
SQLNET

How to Resolve TNS-03505: Failed to resolve name

Posted on
TNS-03505 Failing to resolve TNS names could involve any one of the network configuration files, such as tnsnames.ora or sqlnet.ora. There’re several possible causes may throw TNS-03505: Absent Local Naming Connect Identifier Mismatch Search for Wrong Domain 1. Absent Local Naming There’re several naming methods supported by Oracle in sqlnet.ora. Only local naming can be […]
Network

How to Resolve “tnsping command not found” or “tnsping is not recognized as an internal or external command”

Posted on
“tnsping command not found” This type of error message “tnsping command not found” in Linux or “tnsping is not recognized as an internal or external command” in Windows indicates that the command you issued is missing in ordinary execution directories. As a result, the shell does not recognize it. Let’s see some more details. Phenomenon […]
MySQL

How to Connect MySQL from SQL Developer

Posted on
Connect MySQL from SQL Developer By default, SQL developer can be used to connect only Oracle databases. As you can see, there’s only Oracle tab in the connection option. Luckily, SQL developer provides a very special feature that can import the third party JDBC driver into SQL developer. So that we can connect the third […]
PL/SQL

How to Use Bind Variable in Oracle

Posted on
Shareable Cursor Using bind variables can make statements with minor differences become literally the same so as to share the same cursor when executions. That means, SQL engine doesn’t have to parse those similar statements every time they are executed, it reuses the shared cursor to service millions of executions. Unshareable Cursors In contrast, dynamic […]
Administration

How to Move Oracle Database

Posted on
Actually, this topic “How to Move Oracle Database” follows my previous post: How to Move ORACLE HOME. But I think it can be used in any moving operations. Generally speaking, this post will include the following subtle topics: How to move spfile How to move control files How to move database files How to move […]
Oracle Home

How to Move ORACLE HOME

Posted on
Allow me to ask you a question before going further: why would you like to move ORACLE HOME to another place? You may leave your comment below this post, I am curious about it. As for me, it’s because my client like old-fashioned file structure and don’t like Optimal Flexible Architecture (OFA) to be used, […]