Search results “Oracle odbc tns no listener” for the 2014
How to resolve the ora 12154 error
In this tutorial you will learn how to resolve the ora 12145 error.
Views: 103785 DBA Pro
Getting rid of  tnsnames.ora to connect to Oracle database.
How to connect to Oracle database without using tnsnames.ora. In this video we will try connecting to Toad for Oracle, SQL Plus for windows and PLSQL Developer without using tnsnames.ora file using connection string instead.
Views: 3591 Subhroneel Ganguly
Best way to connect Oracle with Visual Studio .NET (no BadImageFormatException or mismatch error)
BadImageFormatException Connect oracle database with visual studio .NET project with latest technology. If you are having BadImageException error or Architecture Mismatch error, this will be helpful more!
Views: 61210 Samiul Al Hossaini
How to connect to Oracle Database using Toad for Oracle.
How to connect to Oracle Database using Toad for Oracle. Online Video to learn the simple way to connect to database through Toad for Oracle. Learn Oracle connectivity from configuring tnsnames.ora , net8 client configuration to connecting to toad. A complete oracle tutorial.
Views: 111544 Subhroneel Ganguly
how to solve ORA-12560: TNS:protocol adapter error
protocol error while login. unable to start services.
Views: 174873 Deepak Soni
How to change Port number of Oracle Data Base
by kumar This video is going to tell you how to change your port no of oracle data base ,default port 8080.(oracle)
Views: 17184 brijesh kumar
Using Oracle to read data from SQL Server
Hi everyone, Andy from Easysoft Limited here, what I want to show you today is how to get data from SQL Server into Oracle. Now for this we will be accessing SQL Server 2014 from Oracle 12 and getting data across. This could be quite easily be any SQL Server version from 2008 and any Oracle version from 11.2, the configuration and process is the same. We can obviously get access to data on SQL Server prior to 2008 and Oracle prior to version 11.2 but it will need a different configuration to what I am going to show you today The plan is also to add more data to the SQL Server table and show this new data back in Oracle. To start off you'll need access to ensure that you have access to your SQL Server and Oracle databases. You'll also need the Easysoft SQL Server ODBC Driver available from www.easysoft.com; just download it, install it and request the free 14 day trial licence. Before we start we need to make some changes to the standard Easysoft config files. cat /etc/odbc.ini Here I have changed Mars Connection to Yes. It must be set to "Yes" if you are connecting to SQL Server 2005 or newer. Easysoft supports all SQL data types from the version of SQL Server from version 7. Oracle supports data types that are common to most ODBC Drivers, but not some of the SQL Server ones. If you intend to access VARCHAR(MAX) for example, then there are some additional settings that need to be set up. Now as I would like to show you VARCHAR(MAX) data moving from SQL Server to Oracle, I have made the relevant change. As you can see, VarMaxAsLong says "Yes" We now need to create a link from Oracles Database Gateway (DG4ODBC) to the ODBC datasource that we already have, this is done in an init(sid) oracle file; let's have a look at our file. cat $ORACLE_HOME/hs/admin/initsqlsrv.ora Please note that HS_NLS_NCHAR must be set to UCS2 Oracle assume that most database vendors use UTF-8 for wide characters, however Easysoft, like almost all ODBC Driver vendors (including Oracles own ODBC Driver) uses UCS2 for wide characters. So that's the link between DG4ODBC and the datasource setup correctly. Next we need to set up the Listener entry The Oracle Listener waits for incoming requests from the Oracle database. For the Oracle Listener to listen for requests, information about DG4ODBC must be added to the Oracle Listener configuration file, listener.ora cat $ORACLE_HOME/network/admin/listener.ora The PROGRAM=dg4odbc tells the Listener that we are wanting to use the Oracle database gateway to communicate with ODBC. The ENVS=LD_LIBRARY_PATH tells Oracle what library to load Now that's all set up and OK we need to tell Oracle which server to attach the listener entry to. This is done in tnsnames.ora, and he is the file that we ensured was set up earlier. cat $ORACLE_HOME/network/admin/tnsnames.ora The Oracle Listener now needs to be restarted. lsnrctl stop lsnrctl start OK, that's now started the Listener up again. So we have ensured that all the configuration files are set up correctly. The Listener and tnsnames.ora both set up OK. The final step is to create a link from the Oracle database to the "tnsnames.ora" entry. CREATE PUBLIC DATABASE LINK ODBC CONNECT TO "test" IDENTIFIED BY "test" USING 'sqlsrv_ptr'; Right, that's all done. Let's access the data in SQL Server now. select * from [email protected]; Where 'demo' is the name of the SQL Server table and 'odbc' is the public database link name. OK, there we have the data. So to recap, I'm in Oracle and we have managed to read the data from SQL Server. Let's just add an additional row in that SQL Server table and retrieve the new data in Oracle. quit; /usr/local/easysoft/unixODBC/bin/isql.sh -v sqlsrv insert into demo values (2,'Easysoft') select * from demo select * from [email protected]; And there is the new data. Easysoft Limited can help you with your data access ... for our full range of ODBC and JDBC Drivers, Bridges and Gateways visit easysoft.com Be sure to let us know if you have any comments or questions. Until next time, thanks again and we'll see you again soon.
Views: 14917 Easysoft Limited
ODP.NET Managed Driver - Getting Started
Learn how to start developing with ODP.NET, Managed Driver by building a basic DB app. The demo uses the Easy Connect method to connect. Source Code ------------------- string conString = "User Id=hr;Password=hr;Data Source=[server name or IP]:[port #]/[DB service name];"; OracleConnection con = new OracleConnection(); con.ConnectionString = conString; con.Open(); OracleCommand cmd = con.CreateCommand(); cmd.CommandText = "select first_name from employees where department_id = 90"; OracleDataReader reader = cmd.ExecuteReader(); while (reader.Read()) { Console.WriteLine("Employee Name: " + reader.GetString(0)); } Console.WriteLine(); Console.WriteLine("Press 'Enter' to continue"); Console.ReadLine();
Views: 26555 Oracle .NET
Oracle Database11g tutorials 16: How to uninstall oracle 11g from windows 7 64 bit
How To Properly Uninstall oracle database 11g from windows 7 and 8 manually without formatting your Computer By Manish Sharma Rebellion Rider Blog Link http://bit.ly/uninstall-oracle-11g-from-win-7 Website: www.RebellionRider.com Manual Un-Installation of Oracle Database 11g. This video will show you proper process on uninstalling Oracle database 11g from windows 7 64 bit. How to uninstall oracle 11g on windows 7 / How to uninstall oracle 10g on windows 7 Read How to uninstall oracle 11g on windows http://www.rebellionrider.com/how-to-uninstall-oracle-database-11g-from-windows-7.html YouTube Video on How to create database http://bit.ly/create-database-using-DBCA Tool used in this tutorial is command prompt. This tutorial series is part of SQL expert exam certification training. if you are preparing for SQL certification you can use my tutorials. This SQL Tutorial is a part of free training. Copy Cloud referral link || Use this link to join copy cloud and get 20GB of free storage https://copy.com?r=j7eYO7 Contacts E-Mail [email protected] Twitter https://twitter.com/rebellionrider Instagram http://instagram.com/rebellionrider Facebook. https://www.facebook.com/imthebhardwaj Linkedin. http://in.linkedin.com/in/mannbhardwaj/ Thanks for linking, commenting, sharing and watching more of our videos This is Manish from RebellionRider.com
Views: 234581 Manish Sharma
Connect to Remote Oracle database using Oracle Sql Developer on Windows.
Three methods of connection to oracle database using sql developer in Windows Operating System, is demonstrated in this online video. 1. Connect using general settings with database service name. 2. Connect by importing xml configuration file. 3. Connect using connection string with jdbc thin client. Oracle SQL Developer download link : http://www.oracle.com/technetwork/developer-tools/sql-developer/downloads/index.html
Views: 16770 Subhroneel Ganguly
oracle forms 6i connectivity 11g xpress ed on win 7
orcale forms 6i connectivity with 11g xe on win 7...
Views: 8050 Arsalan Ghaffar
How to connect to Oracle database using Python in Windows.
How to connect to Oracle database using Python in Windows. Program will connect to Oracle 12c database and retrieve data from a table. Link to Oracle 12c client library : https://pypi.python.org/pypi/cx_Oracle/5.1.3 Just chose your version matching your installed python
Views: 34280 Subhroneel Ganguly
Connect to Oracle database without a user - Demo3
How to connect to oracle database without an obvious DB user. This is Demo3 from the presentation http://www.slideshare.net/KirillLoifman/from-my-pc-to-oracle-remote-database http://www.dadbm.com
Views: 360 DaDBm
Installing Oracle Instant Client for Development on Linux
How to install Oracle Instant Client on Linux for development with C based applications - this applies to popular scripting languages such as Ruby, Node.js, Python, PHP, Perl and R. Instant Client allows the Oracle Database drivers and adapters for these languages to connect to a remote or local Oracle database. The first two minutes give an overview of Instant Client. After that, installation is demonstrated. Instant Client is available at http://www.oracle.com/technetwork/database/features/instant-client/index-097480.html To get help, post to an appropriate user forum on Oracle Technology Network: https://community.oracle.com/welcome
How to configure / identify Oracle client on Windows - Demo1
How to configure / identify Oracle client installation on Windows. This is Demo1 from the presentation http://www.slideshare.net/KirillLoifman/from-my-pc-to-oracle-remote-database. http://www.dadbm.com
Views: 2508 DaDBm
Como crear una conexión en Sql Developer para Oracle 11G
Para más vídeos como este visitanos en www.CursosdeComputacion.Net
Connect for ODBC Tracing on Windows
This video demonstrates ODBC Tracing on windows and discusses the Trace options. Learn more about Progress DataDirect: https://www.progress.com/datadirect-connectors
Views: 1478 Progress
Install and configure Sql Developer on Windows | Oracle Tutorial
How to Install SQL Developer on Windows 1) Download for the below link http://www.oracle.com/technetwork/developer-tools/sql-developer/downloads/index.html 2) Make sure you have Java Development Kit installed with latest version. http://www.oracle.com/technetwork/java/javase/downloads/index.html 3) Install SQL developer as rpm -ihv sqldeveloper-xxx.noarch.rpm (replace xxx with exact version of your SQL developer) Run SQL developer on linux command prompt as $ sqldeveloper 4) Create a new connection to connect to user Technology Lair : www.technologylair.org Subscribe : http://www.youtube.com/subscription_center?add_user=technologylair For More Videos : http://www.youtube.com/user/technologylair/videos For Video Tutorials :http://www.youtube.com/playlist?list=PLC71CFFF7A916DCAA For Android : http://www.youtube.com/playlist?list=PLUXK1VpPWQKHI1l-NvM5jvNKKnmNy9eHp For Linux : https://www.youtube.com/playlist?list=PLUXK1VpPWQKHV2xOmjQgUNj3Hrmcslj-H Kalam e Iqbal : http://www.youtube.com/playlist?list=PLF057785BD260F061 Like us on Facebook : https://www.facebook.com/technologylair Tweet us : http://twitter.com/technologylair Follow us : https://plus.google.com/u/0/118196883367288585963/posts Pin us : http://www.pinterest.com/technologylair/
Views: 306755 TechLair
Database Video 3 - How to connect to Oracle 12c in windows 8.1 PC
This part three of the series, How to install Oracle 12c in Windows 8.1 PC. In this video we will explore how to connect to the Oracle 12c database that was installed using the method described in the second video
Views: 32925 Sam Dhanasekaran