Networking And Gateways :: TNS-03505 / Failed To Resolve Name
May 21, 2012
I have 2 virtual machines, in that two vitual machines oracle servers are there.
machine 1 environment file (ofdb.env):
TMP=/tmp; export TMP
TMPDIR=$TMP; export TMPDIR
ORACLE_HOSTNAME=localhost.localdomain; export ORACLE_HOSTNAME
ORACLE_BASE=/u01/app/oracle; export ORACLE_BASE
ORACLE_HOME=$ORACLE_BASE/product/11.1.0/db_1; export ORACLE_HOME
ORACLE_SID=ofdb; export ORACLE_SID
ORACLE_TERM=xterm; export ORACLE_TERM
[code]....
machine 2 environment file (.bash_profile):
TMP=/tmp; export TMP
TMPDIR=$TMP; export TMPDIR
ORACLE_HOSTNAME=localhost.localdomain; export ORACLE_HOSTNAME
ORACLE_BASE=/u01/app/oracle; export ORACLE_BASE
ORACLE_HOME=$ORACLE_BASE/product/11.1.0/db_1; export ORACLE_HOME
ORACLE_SID=DB11G; export ORACLE_SID
[code]....
Now i want to connect from "DB11G (client)" to "ofdb (server)"
ofdb (TNSNAMES.ora) :
TO_OFDB =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost.localdomain)(PORT = 1523))
[code]....
DB11G (listener.ora) :
ofdb =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
[code]....
in both server & client i had set "TNS_ADMIN = $HOME" (see the above environment files) so,
my listener file is in server home directory
my tnsname file is in client home directory
i was started listener in server (ofdb):
$ lsnrctl start ofdb
listner started successfully then came to client side (DB11G) :
$ tnsping TO_OFDB
"TNS Ping Utility for Linux: Version 11.1.0.6.0 - Production on 21-MAY-2012 10:11:27
Copyright (c) 1997, 2007, Oracle. All rights reserved.
Used parameter files:
/u01/app/oracle/product/11.1.0/db_1/network/admin/sqlnet.ora
TNS-03505: Failed to resolve name"
View 9 Replies
ADVERTISEMENT
Oct 14, 2011
CODENAMES.ORA Network Configuration File: /u01/app/oracle/product/8.1.7/network/admin/tnsnames.ora
# Generated by Oracle configuration tools.
college=
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost.localdomain)(PORT = 1521))
[code]...
This is my tnsnames.ora but when i try to tnsping college it gives me following error CODE[oracle@localhost 10.2.0]$ vi tnsnames.ora [oracle@localhost 10.2.0]$ tnsping college
TNS Ping Utility for Linux: Version 10.2.0.1.0 - Production on 14-OCT-2011 14:37:22
Copyright (c) 1997, 2005, Oracle. All rights reserved.
Used parameter files:
TNS-03505: Failed to resolve name
View 1 Replies
View Related
Jun 18, 2013
I'm trying to connect my oracle 10g database to SSIS, and before establishing the connection i tried :tnsping orcl but i got this error
TNS-03505: Failed to resolve name tips
tnsnames.ora
ORCLE =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = myname.lok.DOMAIN)(PORT = 1521))
(CONNECT_DATA =
[code]....
View 3 Replies
View Related
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
Dec 18, 2003
I installed Oracle 9i under W2K with preconfigured DB (SID=ORCL), after that I intalled Oracle developer suite and everything is OK but, When I created second DB (SID=SUMM), I get "ORA-12154: TNS:could not resolve service name" when I tried to connect with :
SQL> connect sys/oracle@summ as sysdba
NB: I have no problem when I use
SQL> connect sys/oracle@orcl as sysdba
Below, are my SQLNET.ORA, TNSNAMES.ORA, LISTENER.ORA files
# SQLNET.ORA Network Configuration File: C:oracleora90networkadminsqlnet.ora
# Generated by Oracle configuration tools.
SQLNET.AUTHENTICATION_SERVICES= (NTS)
NAMES.DIRECTORY_PATH= (TNSNAMES, ONAMES, HOSTNAME)
[code]....
View 39 Replies
View Related
May 15, 2013
What I'm trying to do Establish a remote connection to an Oracle 9i R2 9.2.0.8.0 database using "Oracle Provider for OLEDB 9.2.0.7.0" (I was unable to find an 9.2.0.8.0 equivalent) on a Windows Server 2008 R2 64-bit machine.
My configuration
sqlnet.ora
# SQLNET.ORA Network Configuration File: D:oracleora92
etworkADMINsqlnet.ora
# Generated by Oracle configuration tools.
NAMES.DEFAULT_DOMAIN = B81DCS.COM
SQLNET.AUTHENTICATION_SERVICES= (NTS)
[code]....
View 21 Replies
View Related
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
May 14, 2013
My database is oracle 9i when try to connect oracle database using putty to AIX server like..
$ sqlplus
SQL*Plus: Release 9.2.0.8.0 - Production on Wed May 15 09:50:01 2013
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
Enter user-name: sys@testdb as sysdba
Enter password: (given password)
(then showing the following Error message)
ERROR:
ORA-12154: TNS:could not resolve service name
But I try to connect using SQLPlus window then it is successfully connected also if i try to connect using command line window like..
C:>sqlplus /
Enter user-name: sys@testdb as sysdba
Enter password:
Connected to:
Oracle9i Enterprise Edition Release 9.2.0.8.0 - 64bit Production
JServer Release 9.2.0.8.0 - Production
SQL> select name from v$database;
NAME
---------
TESTDB
then it is also successfully connected to database..what is the problem .
my TNSLISTENER.ora file is
# TNSNAMES.ORA Network Configuration File: /u01/app/oracle/product/9.2.0/network/admin/tnsnames.ora
# Generated by Oracle configuration tools.
SINGERDB =
(DESCRIPTION =
(ADDRESS_LIST =
[code]....
View 7 Replies
View Related
Dec 24, 2010
My server database is not connected today whenever I try to connect it. It was working properly till yesterday but today morning when I came to office and want to connect with server then my database server show the message "ORA-12154 TNS: could not resolve the service name" and not connected.
View 9 Replies
View Related
May 19, 2010
I can able to login to the database through an user A. But when I try login as B,I am getting the follwing error. ORA-12154: TNS:could not resolve service name...I am using the following method.
1. Login to the database server via putty.
2. sqlplus A/****
for the user A,the step2 is working fine. But the same step is failing for the user B.And the user B is trying to connect to the database from the same server as the user A logged in to the database successfully.
db01: sqlplus B/*****
SQL*Plus: Release 9.2.0.4.0 - Production on Wed May 19 13:12:52 2010
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
Enter password:
ERROR:
ORA-12154: TNS:could not resolve service name
Enter user-name: I don't know why this error is coming for a particular user only.
View 21 Replies
View Related
Nov 1, 2010
My database link to the remote database used to work fine until the company VPN was updated for some security reasons. Now When I try to connect using the DBlink now, error comes up:
TNS 12541 no listener.
Checked the actual listener on the remote database(destination) and it is up and running fine. I am able to ping their machine.
ping <remote host> -works fine
tnsping<remte host> -fails
it comes back with error
TNS 12541: no listener
Nothing has been changed on both databases. The destination database can connect to our database without any issues(they can tnsping and use the dblinks to our database).
LISTENER ENTRY:
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
[Code] ......
None of the above should be the cause because there was no change been made on any of these.
View 3 Replies
View Related
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
Apr 22, 2011
I have a database named DBKNIT and my server name is USMSERVER, But i cant login to the PLSQL from my client PC , there is an error :
ORA-12514:TNS:listener could not resolve SERVICE_NAME given in connect descriptor
View 2 Replies
View Related
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
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
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
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
May 13, 2013
I have overwritten tnsnames.ora file with newone. In new tnsnames.ora file I have added new host string, remaining all unchanged.
after that, when trying to connect using sqlplus(from windows machine, sqlplusw.exe), working fine. But when trying to connect through putty getting error.
ORA-12154: TNS:could not resolve service name
for the same reason my scheduled cron tab can not run export backup. cron tab error is
EXP-00056: ORACLE error 12154 encountered
ORA-12154: TNS:could not resolve service name
EXP-00000: Export terminated unsuccessfully
I am suspecting problem may be due to file accessing permission related issue. But cant solve it. Current tnsnames.ora files permission is
# ls -l admin
total 112
-rw-r--r-- 1 oracle oinstall 14661 Apr 26 2002 libnk59.exp
-rw-r--r-- 1 oracle oinstall 643 Apr 26 2002 libnk59.imp
-rw-r--r-- 1 oracle oinstall 5728 Apr 26 2002 libnrad9.exp
[code]....
View 5 Replies
View Related
Feb 15, 2010
I am installing Oracle 10g using windows 7 but i am facing problem Ora-12546.
View 6 Replies
View Related
Sep 23, 2011
after creating database i try to start listener i have copied listener.ora and edit according to db created i have folling issues.
LSNRCTL for IBM/AIX RISC System/6000: Version 9.2.0.8.0 - Production on 23-SEP-2011 15:02:05
Copyright (c) 1991, 2006, Oracle Corporation. All rights reserved.
Starting /u01/app/oracle/product/bin/tnslsnr: please wait...
TNSLSNR for IBM/AIX RISC System/6000: Version 9.2.0.8.0 - Production
System parameter file is /u01/app/oracle/product/network/admin/listener.ora
Log messages written to /u01/app/oracle/product/network/log/listener.log
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=172.1.17.43)(PORT=1521)))
TNS-01155: Incorrectly specified SID_LIST_LISTENER parameter in LISTENER.ORA
NL-00305: the specified path name does not exist
Listener failed to start. See the error message(s) above...
View 16 Replies
View Related
Nov 2, 2011
i could not able to add and open listener to install Oracle database 11g R2 on window 7 ( 64 bit OS).
Steps :
1) i installed Oracle 11g R2 Software Only.
2) Started DBCA to configure Database
3) I got a message that i need to configure Listener first.
4) I opened NETCA and add a listener ( default name LISTENER)
5) Then re-opened DBCA to start Database configuration and found the same message configure listner.
6) I went to control panel-> Services -> i found no listeners there
7) i started NETMGR and add a listner and its location as well I started DBCA and found the same message add listener
9) i opened LSNRCTL and typed the command to START LISTENER and i found no listener error
10) When i am trying to add listener using NETCA ,during it's last step listener adding completion i found the below message :
Oracle Net Services Configuration:
Stopping Oracle Net Listener:
Running Listener Control:
d:apporacleproduct11.2.0dbhome_1inlsnrctl stop LISTENER
Listener Control complete.
Listener stop failed.
[code]....
View 4 Replies
View Related
Jul 10, 2008
when iam running netca on oracle llg iam getting the following error..[wstdba@ora11g ~]$ netca
java.io.FileNotFoundException: /oraeng/app/oracle/product/11.1.0/app/oracle11g/cfgtoollogs/netca/netca_OraDb11g_home1-0802284PM3437.log (No such file or directory)
at java.io.FileOutputStream.open(Native Method)
at java.io.FileOutputStream.<init>(FileOutputStream.java:179)
at java.io.FileOutputStream.<init>(FileOutputStream.java:102)
at oracle.net.ca.NetCA.main(Unknown Source)
Oracle Net Services configuration failed. The exit code is -1...All my services are up and running..
View 2 Replies
View Related
Jul 16, 2012
have some problem between my database and the listener Sometimes I have connection errors: The error occurred intermittently
Oracle 11.2.0.2.0 on RHEL 5
My listener:
XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXx
LISTENER =
[code]...
The listener starts and stops normally
XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXx
>lsnrctl start
LSNRCTL for Linux: Version 11.2.0.2.0 - Production on 16-JUL-2012 17:51:09
Copyright (c) 1991, 2010, Oracle. All rights reserved.
Starting /opt/oracle/product/EE_11.2.0/bin/tnslsnr: .
[code]...
But there is an error when the database register into the listener (in listener.log):
XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXx
Started with pid=4029
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=xxxxxx)(PORT=1521)))
Listener completed notification to CRS on start
[code]....
View 2 Replies
View Related
Feb 21, 2010
I want connect mssql in oracle by orale Gateways 11g
my environment:
windows Wista
oracle 11.1.0.7.0
Oracle Database Gateways 11.1.0.7.0
SQL SEVER2008
these soft in one computer.
my steps :
1. set initdg4mssql.ora
2.set listener.ora
3. set tnsnames.ora
4.start lsnrctl
5.use SYSTEM/ORACLE@DZCDB
logined. create dblink and test.
but it's error. i want to know where is the error.
View 1 Replies
View Related
Jun 26, 2013
I am working on people-soft, currently i am installing it but i found this error
ORA-12154: TNS:could not resolve the connect identifier specified
/*---------------------------------------------*/
this is listener.ora
# listener.ora Network Configuration File: C:oracleproduct10.2.0db
etworkadminlistener.ora
# Generated by Oracle configuration tools.
HRCS9 =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = umhs-86cd1970f)(PORT = 1521))
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
)
)
SID_LIST_HRCS9 =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = C:oracleproduct10.2.0db)
(PROGRAM = extproc)
)
)
/*---------------------------------------------*/
tnsnames.ora
# tnsnames.ora Network Configuration File: C:oracleproduct10.2.0db
etworkadmin nsnames.ora
# Generated by Oracle configuration tools.
HRCS9 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = umhs-86cd1970f)(PORT = 1521))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)
/*----------------------------------------------------*/
sqlnet.ora
# This file is actually generated by netca. But if customers choose to
# install "Software Only", this file wont exist and without the native
# authentication, they will not be able to connect to the database on NT.
SQLNET.AUTHENTICATION_SERVICES = (NTS)
/*--------------------------------------------------------*/
View 1 Replies
View Related
Oct 8, 2012
I have one production server with oracle 11g R2 DB. I have to change Server Hardware and thats why I have to install oracle 11g R2 DB on New hardware and test it. I had installed DB with software only option and copied the cold backup of production server. The hostname and ip address of both the servers are different. I had change the "db_domain" parameter into init.ora with the hostname.Now my question is that can the same db runs on the same network with different hosts. Change of "db_domain" parameter into the init.ora is enough or i have to follow some other procedure.
View 12 Replies
View Related
Jan 24, 2005
I´m working with Oracle 9.2.0 / HP-UX and I need to configure two different listeners for the same server using different IP address.
View 12 Replies
View Related
Jul 5, 2012
I am trying to create a database link from the 11g database to the 10g database using:
create database link ORCL10R2 connect to <username10g> identified by <password10g> using <db10g>;
It Returns
Database link created.
select sysdate from dual@ORCL10R2 returns error:
ERROR at line 1:
ORA-12504: TNS:listener was not given the SERVICE_NAME in CONNECT_DATA
what changes I need to make to tnsnames and listener at both servers.
View 8 Replies
View Related
Dec 12, 2011
How to change listerner.ora name ? I want to have something like that application.ora instead of listener.ora.
View 9 Replies
View Related
Nov 2, 2011
I installed Oracle Express on my Windows 2003 Enterprise server. And right off the bat I cannot connect to it via command line. I have googled and read many sites, but am still getting the same error, no matter what I do. I am newbie again (was a DBA in 1990...when I used to have the same error and fix it in seconds...not sure why this problem still lingers in Oracle) so most likely I am overlooking something. Below are my tnsnames.ora and liserner.ora files
tnsnames.ora
XE =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = myservername.domainname.com)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = XE)
)
)
[code]....
# This file is actually generated by netca. But if customers choose to
# install "Software Only", this file wont exist and without the native
# authentication, they will not be able to connect to the database on NT.
SQLNET.AUTHENTICATION_SERVICES = (NTS)
View 19 Replies
View Related
