Skip to main content

Unable to connect to Oracle DB from a Windows box, getting Oracle driver error while executing a perlscript.


Problem : Unable to connect to Oracle DB from a Windows box, getting Oracle driver error while executing a perlscript.

Resolution:
By default windows OS don’t come with Oracle ODBC drivers hence Windows OS couldn’t get an ODBC connection to the Oracle DB. Hence we need to install Oracle client on the Windows box which puts the Oracle ODBC driver and this helps to get a connection established from the Windows Server to the Oracle DB. Picture below shows the Oracle driver on Windows box after Oracle 11g clinet installed.




• You should ensure that you have the correct entries in tnsnames.ora on the Windows box for the Oracle DB.

Thanks & Regards
Avinash Pillai
http://avinashpillai.blogspot.com/
Labels:

Comments

Post a Comment

Popular posts from this blog

What is Cybersecurity Risk? Definition & Factors to Consider

  Cybersecurity risk has become a leading priority for organizations as they embrace digital transformation and leverage advanced technology solutions to drive business growth and optimize efficiencies. Additionally, many organizations are increasingly reliant on third-party and   fourth-party vendors   or programs.  In this post, we’ll explore what cybersecurity risk is and take a look at some key cybersecurity risk factors that organizations across all industries should keep in mind as they build and refine their   cybersecurity risk management strategy .   What is cybersecurity risk? Cybersecurity risk refers to   potential threats and vulnerabilities   in digital systems. It encompasses the likelihood of a cyberattack compromising data or systems, leading to financial,   reputational , or operational damage. A few examples of cybersecurity risks include   ransomware ,   malware ,   insider threats ,   phishing attacks ...
Post a Comment
Read more

How To Manage Dell Servers using OMSA – OpenManage Server Administrator On Linux

OMSA is a web based application to manage DELL PowerEdge Servers. Using OMSA you can perform proactive system monitoring, system diagnosis, troubleshoot hardware issues and configure RAID etc., You can also view and manage hardware’s embedded system management (ESM) log using OMSA. This is an jumpstart guide that explains how to install Dell OMSA on Linux. I have also provided few screenshots of DELL OMSA web application. 1. Download DELL OMSA Go to DELL support website -> click on “Drivers & Downloads” -> choose your server model (in my case, I selected PowerEdge 2850) -> choose the operating system -> scroll-down and expand ‘Systems Management’ -> Click on ‘OpenManage Server Administrator Managed Node’ -> Click on OM_5.5.0_ManNode_A00.tar.gz to download it. You can directly download it to your Linux server as shown below. # mkdir -p /usr/local/omsa # cd /usr/local/omsa # wget http://ftp.us.dell.com/sysman/OM_5.5.0_ManNode_A00.tar.gz 2....
Post a Comment
Read more

Various Types of Hunt Groups

                                                         Various Types of Hunt Groups         * Sequential Hunt Groups    * Peer Hunt Groups   * Longest-Idle Hunt Groups   * Parallel Hunt Groups (Call Blast) Sequential Hunt Groups In a sequential hunt group, extensions always ring in the order in which they are listed, left to right, when the hunt group is defined. The first number in the list is always the first number to be tried when the pilot number is called. Maximum number of hops is not a configurable parameter for sequential hunt groups. Peer Hunt Groups In a peer hunt group, extensions ring in a round-robin order. The first extension to ring is the number in the list to the right of the last extension to ring when the pilot number was last called. Ringing pro...
Post a Comment
Read more