Oracle Client

Difference between Oracle Client and Oracle Instant Client

Posted on
Here I list their differences including features, pros and cons for you to evaluate which one should be used for your clients: Oracle Client Features Install-based software All-in-one functions General-purpose package Oracle database enterprise edition download page Oracle clients stay with Oracle database software, so there’s no dedicated download page for Oracle clients. Pros One-stop […]
Listener

How to Resolve ORA-12514: TNS:listener does not currently know of service requested in connect descriptor

Posted on
As a DBA, I saw ORA-12514 in different scenarios and solved them respectively by different means. Here I divide scenarios that could throw ORA-12514 into three parts for your error pattern: Common Situations When Restart a Database When Switchover to Standby ORA-12514 in Common Situations Let’s see how we reproduce ORA-12514. First of all, we […]
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 […]
DNS

sqlplus, tnsping or lsnrctl Hangs

Posted on
sqlplus, tnsping or lsnrctl Hangs I can’t cover all the situations in this post, but I have some cases that can share with you. Those hanging all point to one problem: Domain name resolution. Does the database server use DNS to do name resolution? Sometimes, DNS traps the name resolution in an unknown and indefinite […]
Listener

TNSPING – 8 Aspects You Should Know

Posted on
tnsping tnsping is a utility provided by Oracle to test the listener is available or not from clients. If there’s any problem in the path to the destination, it will fail with different aspects. Here I list several possible error types below for your reference. “tnsping is not recognized as an internal or external command” […]
Oracle Home

How to Resolve Message 3511 not found

Posted on
Message 3511 not found Recently, I upgraded my PC from Windows XP to Windows 7 at my working place. For reusing installed Oracle Client 9.2.0, a pretty old Java application, I took several steps to recover it, but I got Message 3511 not found eventually. First, I set an environment variable Path for Oracle Client […]