Oracle And MySQL Database - Could Not Resolve Connect Identifier Specified

Jun 2, 2011

i tried for 3 days to setup a connection between my oracle database 11.2 (resides on 2003,64 bit Microsoft windows) and a mysql database (resides on 2003,32 bit Microsoft widows).

i used dg4odbc 64 bit which was installed on oracle server, my steps was as follows :

1- configure ODBC driver (MYSQL 3.51 odbc) on oracle server that connect to mysql database and the connection was tested successfully (the name of odbc dsn is DG4ODBC).

2- configure the listener.ora file (which resides on dg4odbc installation path) that contains the following :

LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = xxxxxxxxxxxx)(PORT = 1511))

[code]....

3- configure the tnsnames.ora file (which resides on oracle database path) that contains the follwoing :

DG4ODBC =
(DESCRIPTION=
(ADDRESS=(PROTOCOL=tcp)(HOST=xxxxxxxxxxxx)(PORT=1521))
(CONNECT_DATA = ( SERVICE_NAME = DG4ODBC ))
(HS=OK)
)

4- configure that initdg4odbc.ora file that resides on the dg4odbc installation.

HS_FDS_CONNECT_INFO = DG4ODBC
HS_FDS_TRACE_LEVEL = off

5- restart the gateway listener.

6- test DG4ODBC service by tnsping which was successful .when i try to get some data from mysql database by SELECT * FROM MDL_COURSE@DG4ODBC query,the query take some time (15 second !!) and return

ORA-12154: TNS:could not resolve the connect identifier specified

View 2 Replies


ADVERTISEMENT

Connect Oracle Database From Delphi - Could Not Resolve Connect Identifier Specified

Oct 6, 2010

I have the following computer/setup:

Acer laptop, Intel Processor w/ Windows 7 Professional (64-bit)
Delphi 2010 Professional
Oracle XE (+ the Oracle XE client that comes with it)

I cannot can't to the Oracle database from Delphi. The error I keep getting is:

Alias is not currently opened. [Oracle][ODBC][Ora]ORA-12154:TNS: could not resolve the connet identifier specified.

Here's what I've done:

1. Create an ODBC connection to my Oracle database

- run C:WindowsSysWOW64odbcad32.exe to open the ODBC administrator.
- Data source name: bt_user
- TNS Server Name: localhost/xe
- user bt_user
- Clicked "test connection" -- Success.

2. Open Delphi and drop a TDatabase component on my main form.

- Set the Alias Name property to "bt_user" (the alias I set up in ODBC)
- Set database name to "bt_user".
- Checked "connected".

Alternatively, I tried using the Delphi ADO components (the dbGo components).

- Drop TADOConnection component on my form.
- Select "connection string" and open the dialog.
- Click "build string".
- Select "Microsoft OLE DB Provider for ODBC Drivers" from the selection.
- In "use data source", select "bt_user" from the drop-down list (my ODBC connection from #1)
- Click "test connection".

Again the same error.

My questions are:

1. Can Delphi work with Oracle XE (Express Edition)?

2. If so, then do I need to install the "Instant Client"?

3. Will the instant client for Oracle 10g work with Oracle 10g XE?

4. Do I need to install any additional ODBC driver(s)?

5. Why was I successful in creating the ODBC connection in Windows, but it failed in Delphi?

6. Will Visual Studio.NET (C#) work with Oracle XE, and what are the steps for setting that up?

View 2 Replies View Related

ORA-12154 / TNS - Could Not Resolve The Connect Identifier Specified

Nov 3, 2010

I have installed Oracle 10g client and am trying to connect to an Oracle 9i database with it. I have already created the required Listner and service names. But when I try to login to SQL * Plus , it gives me the following error: Ora-12154: TNS: Could not resolve the connect identifier specified

Could Oracle 10g client connect to a 9i database? If so how do I fix this problem?

View 4 Replies View Related

ORA-12154 - TNS - Could Not Resolve Connect Identifier Specified

Dec 14, 2012

OS:Solaris
DB:10G

I am trying to create a DR on the same server as that of primary server.

Specifictaions:
Primary server:test
DR: testdr

I have made thetns entries and i am also able to tnsping both test and testdr. But below is the error that is being constantly getting logged in the alert of primary server.

Error 12154 received logging on to the standby
Fri Dec 14 20:09:36 2012
Errors in file /11g/oradata/admin/ettest/bdump/ettest_arc0_7336.trc:
ORA-12154: TNS:could not resolve the connect identifier specified
PING[ARC0]: Heartbeat failed to connect to standby 'ettestdr'. Error is 12154.

View 3 Replies View Related

Networking And Gateways :: TNS Could Not Resolve Connect Identifier Specified

Nov 4, 2010

I have a really strange problem connecting from a new client to an Oracle server, here are the points :

- There is no problem with DB server and its listener and all that as I am able to connect from other clients
- I have installed the oraclient on this machine ( it is a XP machine ) and copy/pasted the TNSNAMES.ORA from one of those correct PCs here and when I do a TNSPING is returns OK
- even when I open oracle net manager I see the TNS entries in there and when I test a connection thru it is says successfull
- BUT WHEN I USE SQL+ or TOAD or ODBC ( any of these) trying to make a connection using the exact same TNS entries it returns :

"ORA-12154: TNS:could not resolve the connect identifier specified"

- I have tried with both IP and Host name but no luck
- TNSNames.Ora and sqlnet.ora both are located here : oracleproduct10.2.0client_1NETWORKADMIN
- there is just one oracle home
- I have already uninstalled/installed oracle client
- These lines are included in Sqlnet.ora :
SQLNET.AUTHENTICATION_SERVICES= (NTS) NAMES.DIRECTORY_PATH= (TNSNAMES)

I marked those entries in Sqlnet.ora and that made no diff in result, another thing : if I use easy connect method : sqlplus scott/tiger@<Servername>:1521/ORCL it does connect but using TNSNames still I can not get connected. so strange!!, seems somehow the TNS file even is not being picked or looked at !

View 2 Replies View Related

Networking And Gateways :: TNS - Could Not Resolve Connect Identifier Specified

Dec 29, 2012

I have both 10g and 11g installed in my machine.There are so many CI builds that runs without problems.For few builds which uses 10g, it throws errors as ,

SQL*Plus: Release 11.2.0.1.0 Production on Thu Dec 27 01:18:52 2012
Copyright (c) 1982, 2010, Oracle. All rights reserved.
ERROR:
ORA-12154: TNS:could not resolve the connect identifier specified
Enter user-name:

Only at a particular step, this is happening. After this,if some-other target is connecting to Oracle,it is able to connect.

View 5 Replies View Related

Networking And Gateways :: ORA-12154 / TNS / Could Not Resolve Connect Identifier Specified

Dec 4, 2012

While connecting to Database through sqlplus as sysdba, error pop-up.

SQL> conn sysdba@disdevt
Enter password: *******
ERROR:
ORA-12154: TNS:could not resolve the connect identifier specified
Warning: You are no longer connected to ORACLE.
SQL>

but i am able to log-in to database through pl/sql developer. Since TNS is same for both.

View 6 Replies View Related

Networking And Gateways :: ORA-12154 - Could Not Resolve Connect Identifier Specified

Dec 26, 2008

I have oracle 10g and Developer suite installed locally in my system and I have edited my TNSNAMES.ora file and added a entry for VISLINUX(for both Developer suite and oracle DB TNSNAMES.ora files).

When I use TNSPING comand I get an error for the schemas APPDEV and VISLINUX.

D:Documents and SettingsBAR>tnsping appdev

TNS Ping Utility for 32-bit Windows: Version 10.1.0.4.2 - Production on 25-DEC-2
008 20:22:57

Copyright (c) 1997, 2003, Oracle. All rights reserved.

Used parameter files:
C:DevSuiteHome_1
etworkadminsqlnet.ora

Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)
(HOST = 70.63.134.203)(PORT = 1521))) (CONNECT_DATA = (SERVICE_NAME = APPDEV)))
VISLINUX = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 75.
182.87.181)(PORT = 1521)) ) (CONNECT_DATA = (SERVICE_NAME = VISLINUX) )
TNS-12533: TNS:illegal ADDRESS parameters

D:Documents and SettingsBAR>tnsping vislinux

TNS Ping Utility for 32-bit Windows: Version 10.1.0.4.2 - Production on 25-DEC-2
008 20:23:21

Copyright (c) 1997, 2003, Oracle. All rights reserved.

Used parameter files:
C:DevSuiteHome_1
etworkadminsqlnet.ora

TNS-03505: Failed to resolve name

and when I use TOAD to connect the schema's I get the following error ORA-12154:TNS:could not resolve the connect identifier specified

Here are the contents of my TNSNAMES.ora file

XE =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = anvesh)(PORT = 1521))
(CONNECT_DATA =

[Code]....

View 4 Replies View Related

Networking And Gateways :: ORA-12154 / Could Not Resolve Connect Identifier Specified

Mar 17, 2011

What works: There is a oracle database on the local network. I'm connecting to it through my web server on my pc (apache/php). I have installed "oracle_instantclient10". It works fine - i can connect to oracle db, queries are executed fine.

What doesnt work: I'm trieing to connect to the same oracle db from a Linux server, but i get the error:

ORA-12154: TNS:could not resolve the connect identifier specified

My linux server can connect to remote oracle db, because "nmap ORACLE_DB_MACHINE_IP -PN", gives me answer "1521/tcp open oracle". I have the same firewall allowance with my winXp pc.

I use the same "TNSNAMES.ORA" and "SQLNET.ORA" files on both: linux server, winXp pc. The only difference between winXp and linux machines is that winXp uses oracle instant client version 10.2, and linux uses version 11.2.

View 16 Replies View Related

Precompilers, OCI & OCCI :: ORA-12154 / TNS / Could Not Resolve Connect Identifier Specified

Jun 25, 2009

I have a 10.2.0.3 server installation on Solaris x86-64.I am trying to compile the sample1 proc demo program with the 32 bit make file :

compilation is successfull, however - I am unable to connect to Oracle ( TNS error ) my TWO_TASK is set correctly.

rstnyc01:>make -f demo_proc32.mk sample1
/usr/ccs/bin/make -f /export/home/oracle/product/10.2_s/precomp/demo/proc/demo_proc32.mk OBJS=sample1.o EXE=sample1 build
/usr/ccs/bin/make -f /export/home/oracle/product/10.2_s/precomp/demo/proc/demo_proc32.mk PROCFLAGS="" PCCSRC=sample1 I_SYM=include= pc1
proc iname=sample1 include=. include=/export/home/oracle/product/10.2_s/precomp/public32 include=/export/home/oracle/product/10.2_s/precomp/public include=/export/home/oracle/product/10.2_s/rdbms/public include=/export/home/oracle/product/10.2_s/rdbms/demo include=/export/home/oracle/product/10.2_s/plsql/public include=/export/home/oracle/product/10.2_s/network/public

[code]....

ORACLE error--

ORA-12154: TNS:could not resolve the connect identifier specified

However - when I am doing the exact same thing with the 64 bit make file, I am able to connect with no issues :

rstnyc01:>make -f demo_proc64.mk sample1
/usr/ccs/bin/make -f /export/home/oracle/product/10.2_s/precomp/demo/proc/demo_proc64.mk OBJS=sample1.o EXE=sample1 build
/usr/ccs/bin/make -f /export/home/oracle/product/10.2_s/precomp/demo/proc/demo_proc64.mk PROCFLAGS="" PCCSRC=sample1 I_SYM=include= pc1
proc iname=sample1 include=. include=/export/home/oracle/product/10.2_s/precomp/public include=/export/home/oracle/product/10.2_s/rdbms/public include=/export/home/oracle/product/10.2_s/rdbms/demo include=/export/home/oracle/product/10.2_s/plsql/public include=/export/home/oracle/product/10.2_s/network/public

[code]....

View 1 Replies View Related

Client Tools :: ORA-12154 / TNS - Could Not Resolve Connect Identifier Specified

Nov 21, 2012

I'm not able to login to PL/SQL Developer 7.0.3.1123.I'm receiving "ORA-12154: TNS: could not resolve the connect identifier specified" error. Although it lists all TNS entries in Database drop down.It was working fine last week but now I'm not able to login.

View 10 Replies View Related

Networking And Gateways :: ORA-12154 TNS - Could Not Resolve Connect Identifier Specified

Mar 7, 2011

While connecting to oracle database, i'm getting

SQL> conn red_user/red@orcl
ERROR:
ORA-12154: TNS:could not resolve the connect identifier specified

Warning: You are no longer connected to ORACLE.

View 6 Replies View Related

Networking And Gateways :: Select Statement - Could Not Resolve Connect Identifier Specified

Jun 7, 2010

we have oracle
Oracle Database 10g Enterprise Edition Release 10.1.0.2.0 - 64bi
PL/SQL Release 10.1.0.2.0 - Production
CORE 10.1.0.2.0 Production
TNS for IBM/AIX RISC System/6000: Version 10.1.0.2.0 - Productio
NLSRTL Version 10.1.0.2.0 - Production

and SQL Server 2005 on MS windows Server 2003

i followed the article and i get succeed on each steps

[URL]

when i execute the select statement under user by name NEW I got below error

ORA-02019: connection description for remote database not found

View 1 Replies View Related

Client Tools :: Sqlplus Error ORA-12154 - TNS - Resolve Connect Identifier Specified?

Feb 24, 2010

it seems to me that the file tnsnames.ora is not read when i execute sqlplus.whit the command: sqlplus username / password @ servicename i receive the error ORA-12154, while if i pass the whole connection string i can connect without problems

sqlplus username/password@(DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = oradev10)(PORT = 10520))(CONNECT_DATA = (SERVICE_NAME = D10)))

i set the ORACLE_HOME environment variable correctly... what more i have to do? following is my tnsnames.ora

TOTEMPROD =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = ttf19.cern.ch)(PORT = 1521))

[code]...

View 6 Replies View Related

SQL & PL/SQL :: Oracle Database To Mysql Conversion

Dec 21, 2012

Is it possible to convert oracle data base to MySql?

View 1 Replies View Related

Migrate MySQL Database Into Oracle Database?

Sep 11, 2003

I'm trying to migrate a mySQL database into an Oracle database.

View 7 Replies View Related

Connect Using Mysql Command Line - Null Password Given

Feb 22, 2010

When I try to connect using the mysql command line, I keep getting an error, I type this exactly:

SQL > Connect
Enter user-name: system
Enter password: (left blank b/c i can't type anything there)
and when I press enter I get the error, null password given, login denied.

View 2 Replies View Related

Migrate Data From MySQL Database To 11g Database

Nov 5, 2008

I need to migrate data from Mysql database to Oracle11g database.

a) is there any method available to import the all the sqls like table script,constraint scripts,data(insert ) script from Mysql.so that we can apply the sql directly to the oracle schema after making necessary changes(like datatype).

b) Is there any free tool available for the migration.

View 2 Replies View Related

Data Migration From MySQL Database

Oct 31, 2008

I need to migrate data from Mysql database to Oracle11g database.

a) is there any method available to import the all the sqls like table script,constraint scripts,data(insert ) script from Mysql.so that we can apply the sql directly to the oracle schema after making necessary changes(like datatype).

b) Is there any free tool available for the migration.

View 1 Replies View Related

Import Dump Differences Into MySQL Database

Jun 18, 2012

We have the following scenario:

1) We get a daily Oracle 11 Dump
2) We only want to import the current changes in a MySQL database .

For this we need:

a) Is there a tool, script or best practices to get only the differences (delta) ?
b) How to import an Oracle dump or only teh differences into a MySQL database ?

View 2 Replies View Related

Way To Resolve Database Locking

Aug 27, 2013

11.2.0.1  I am still resolving the locking issues in our database Often the delete is blocked by some transaction. The operations said that it is intermittent. Last night they were able to delete the 1M transactions without the locking.But the past days lock often occurred, and they have to bounced the database to release the locks.

 I there a way I can compare what happened last night why the batch was able to delete smoothly , and compare it against the other night where the delete was blocked?By using ASH, AWR, ADDM? I also run now this procedure, to identify the blocking sql statement: 

SQL> exec  dbms_workload_repository.add_colored_sql(sql_id => 'fn3qv2dhsu3nb');        

PL/SQL procedure successfully completed.Can I now run AWR,ASH,ADDM, to identify/capture the sql being run?

View 21 Replies View Related

Migrate MySQL 5.0 Objects To Oracle 11g

Jan 23, 2013

I`m migrating a mysql 5.0 database to Oracle 11g. I used Oracle's Sql developer and with a workaround i could convert tables, constraints, indexes, some triggers and created sequences.

My question is, what happen with stored procedures and functions, they didn't pass. I've been searching and i found here hey have to be rewritten. Is there any way to convert those objects ? I can't afford to do it manually because the mysql database has almost 400 of them and they aren't small.

View 2 Replies View Related

ODP.NET :: Connect To Database Oracle With C#

Oct 19, 2012

I am trying to develop a web application with C # VS.net, my application is to connect to an Oracle database on a server (LAN), the problem I want to connect to the database without install oracle or ODP on my client machine.

View 1 Replies View Related

Migrate MySQL And Access Databases Over To Oracle 9i

Oct 2, 2008

I need to migrate MySQL and Access databases over to Oracle 9i. Is there a tool that will do this and also migrate sql scripts?

I heard of Oracle Workbench as one tool I could use?

View 4 Replies View Related

Migrating MySQL Queries To Oracle (sqlplus)

Jun 10, 2010

I am migrating MySQL query's to oracle (sqlplus). Tell me what is the below code doing and equivalent for this code in oracle.

declare @start_date datetime
select @start_date='$first_date'
declare @end_date datetime
select @end_date='$end_date'
This is followed by
select distinct ' ', column from my_table;

I tried a lot of ways (set @start_date etc)but nothing really works.

View 6 Replies View Related

SQL & PL/SQL :: Migrate Data From Oracle Server To MySql?

Feb 1, 2013

I need to migrate data from oracle server to MySql.

View 14 Replies View Related

What Software Is The Best To Backup Oracle / MySQL And MSSQL

Jan 24, 2011

tell me what software is the best to backup Oracle, MySQL and MSSQL?

View 2 Replies View Related

Networking And Gateways :: Mysql Oracle Integration

Sep 25, 2013

I need to created DB link between oracle (10g on linux) and mysql 5.0 to configure a job to fetch data after every hour. I need solution that does not involve:

ODBC Connection
Oracle GateWay
Golden Gate

View 2 Replies View Related

11gR2 On Redhat5 - Import From Oracle To MySQL

Feb 19, 2013

Oracle 11gR2 on Redhat5

I need to export a table from ORACLE to MySQL. My table have more than 1billion rows and more than 140G.

View 4 Replies View Related

Oracle Database - Cannot Connect From PHP Script

Jul 19, 2010

I have created an Oracle database on my Windows XP system but cannot connect from a php script

CODE

<?php
if (!$db = @ocilogon("big", "big", "s7s"))
    {
    $error = ocierror();
    printf("Error was: %s", $error["message"]);
    die();
    }
$stmt = ociparse($db,"SELECT count(*) FROM members");
ociexecute($stmt);
?>

When I created the database the connection I used was s7s but whether or not I include that name or just use the ID/password that script will not connect.

View 2 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved