TNS-03505: Failed to resolve name
First of all you'll have to determine what technologies will be used to lookup the requested service name.
In order to do this, you will have to find the sqlnet.ora file used by the Oracle client. This file is typically in your %oracle_home%\network\admin (or net80\admin for Oracle 8 client)directory.
It might be that you are using Oracle Instant Client, or that the location is changed. This can be done by setting the TNS_ADMIN variable, either via a batch script, stored in the registry or as an environment variable.
See what the value of TNS_ADMIN is and go to that directory in order to find sqlnet.ora
If you found the sqlnet.ora file, open it and search for following line:
NAMES.DIRECTORY_PATH= (TNSNAMES, LDAP, ONAMES, HOSTNAME)
Default installations will use a TNSNAMES.ora file to resolve database/service names.
See if the tnsnames.ora file exists in your directory.
If it doesn't exist and NAMES.DIRECTORY_PATH only contains TNSNAMES (and optionally HOSTNAME), there will be no name resolving.
You will need to create a tnsnames.ora file which will contain all databases you want to connect to.
A typical entry looks like this:
ORA102.WORLD =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = hostname)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SID = databasename)
)
)
You will have to replace hostname and databasename and possible the portnumber to reflect your Oracle databases.
If you think both sqlnet.ora and tnsnames.ora are correct, you might be using multiple Oracle Homes.
Typically this is the case if you install Oracle Developer suite after you install a database on your pc.
With Oracle Locator Express you can easily switch between multiple Oracle Homes.
If you are using other resolving technologies such as Oracle names or Oracle Internet Directory, you can add the service to either ONAMES or OID.
Welcome to our forum for Oracle error: TNS-03505 Add your own message
Could anyone please the exact problem and solution to this thing?
i got pritty similar kind of responses from all searches..............:((
http://www.dbmotive.com/oracle_error_codes.php?errcode=12535&type=ORA
It gives you some hints on how to resolve the error.
Problem History,
on devlopment instance,I have Application server(AS) and Oracle colaboration SUITE (OCS),
AS-infra ip-61
AS-mid -BI installation seperately
OCS-infra ip-61
OCS-miD ip-62
And OCS infra shares same oid of AS infra
NoW comming to OCS
OCS infra has ametadate repository(db)-ocsdbdev
When am able to connect the database in infra tier of OCS i.e from ocsinfra.
But when am trying to connect the database from midtier of OCS i.e from ocsmid
its ginig the following error
SQL*Plus: Release 10.1.0.5.0 - Production on Thu Jul 3 13:36:55 2008
Copyright (c) 1982, 2005, Oracle. All rights reserved.
Enter user-name: sys as sysdba
Enter password:
ERROR:
ORA-12545: Connect failed because target host or object does not exist
When i run this command it gave this error(my sqlnet.ora and tnsnames.ora hav correct entries)
bash-3.00$ trcroute ocsdbdev.kotc.com.kw
Trace Route Utility for Solaris: Version 10.1.0.5.0 - Production on 03-JUL-2008 13:59:23
Copyright (c) 1995, 2003, Oracle. All rights reserved.
TNS-03505: Failed to resolve name
bash-3.00$
Thanks,
S.F.Arshi.
ORA-12154 TNS couldnot resolve service name..i have the correct entry in tnsnames.ora.
plaese help me....
i install oracle 10g database in my system which having OS as windows vista.
First installation itself every thing working fine.
Later on i deinstall the Oracle 10g and try to install again .
The installation are gone fine and oracle is install in my system.
But the Listener cant able to start so i went to service to start that..
it shows the error 1067: the Process terminate exceptedly..
The thing what i did afterinstallation is i went to register file and delete the Oracle from the software link to delete it from the service.
can any help me in this issue since i am struggling to get solution for this for past three days.
I am getting a TNS-03505 error,
this is my info from sqlnet.ora file
NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT)
This is my tnsnames.ora file
ORCL =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = MARJANJANZ)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl)
)
)
EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)
I would really appreciate any help.
Thanks
Marjie
sir i am working on oraclexe.. i face error ora-00600 internal error code.
plz help me...
thanks
girish
An ORA-00600 error is an internal Oracle bug.
When you face this error, a trace file is generated in the user_dump_dest destination.
This trace file is useful to see what's wrong, especially the stack trace
You do not mention if the database is on Windows, Linux, ...
Your problem can be due to a resource shortage, hardware defect, ...
Without a stacktrace it is very difficult to tell what's wrong
SQL> recover database until cancel using backup controlfile;
ORA-00279: change 307624 generated at 12/19/2009 16:33:19 needed for thread 1
ORA-00289: suggestion :
D:\ORACLEXE\APP\ORACLE\FLASH_RECOVERY_AREA\XE\ARCHIVELOG\2009_12_24\O1_MF_1_5_%U
_.ARC
ORA-00280: change 307624 for thread 1 is in sequence #5
Specify log: {<RET>=suggested | filename | AUTO | CANCEL}
cancel
ORA-01547: warning: RECOVER succeeded but OPEN RESETLOGS would get error below
ORA-01194: file 1 needs more recovery to be consistent
ORA-01110: data file 1: 'D:\ORACLEXE\ORADATA\XE\SYSTEM.DBF'
ORA-01112: media recovery not started
in alert log....
Thu Dec 24 10:32:49 2009
ALTER DATABASE RECOVER database until cancel using backup controlfile
Thu Dec 24 10:32:49 2009
Media Recovery Start
WARNING! Recovering data file 1 from a fuzzy file. If not the current file
it might be an online backup taken without entering the begin backup command.
WARNING! Recovering data file 2 from a fuzzy file. If not the current file
it might be an online backup taken without entering the begin backup command.
WARNING! Recovering data file 3 from a fuzzy file. If not the current file
it might be an online backup taken without entering the begin backup command.
WARNING! Recovering data file 4 from a fuzzy file. If not the current file
it might be an online backup taken without entering the begin backup command.
ORA-279 signalled during: ALTER DATABASE RECOVER database until cancel using backup controlfile ...
Thu Dec 24 10:33:35 2009
ALTER DATABASE RECOVER CONTINUE DEFAULT
Thu Dec 24 10:33:36 2009
Media Recovery Log D:\ORACLEXE\APP\ORACLE\FLASH_RECOVERY_AREA\XE\ARCHIVELOG\2009_12_24\O1_MF_1_5_%U_.ARC
Errors with log D:\ORACLEXE\APP\ORACLE\FLASH_RECOVERY_AREA\XE\ARCHIVELOG\2009_12_24\O1_MF_1_5_%U_.ARC
ORA-308 signalled during: ALTER DATABASE RECOVER CONTINUE DEFAULT ...
Thu Dec 24 10:33:36 2009
ALTER DATABASE RECOVER CANCEL
ORA-1547 signalled during: ALTER DATABASE RECOVER CANCEL ...
Thu Dec 24 10:34:04 2009
alter database open resetlogs
Thu Dec 24 10:34:04 2009
ORA-1194 signalled during: alter database open resetlogs...
Thu Dec 24 10:34:42 2009
alter database recover datafile 1
Thu Dec 24 10:34:42 2009
Media Recovery Start
Thu Dec 24 10:34:42 2009
Media Recovery failed with error 1610
ORA-283 signalled during: alter database recover datafile 1...
Thu Dec 24 10:37:25 2009
Is this a hot backup you restored?
If so, the hot backup was not taken correctly:
WARNING! Recovering data file 1 from a fuzzy file. If not the current file
it might be an online backup taken without entering the begin backup command.
1. I have a server in remote location
2. I am connecting through TOAD and getting this error
3. At the server after running the STATUS in LSNRCTL following is comming
ORCL has 2 service handler(s)
in the listner log following details are comming
21-MAR-2010 11:28:43 * (CONNECT_DATA=(SID=IRCL)(CID=(PROGRAM=D:\toad8.6\TOAD.exe)(HOST=XX)(USER=XX))) * (ADDRESS=(PROTOCOL=tcp)(HOST=10.233.65.236)(PORT=3413)) * establish * ORCL * 0
Is your database configured to connect using Multi threaded server connections?
If so, there might be a problem with the configuration, most of the time not using fully qualified domain names in the dispatcher parameter
Add your message
If you need more information about this particular error message, you can leave a forum message.
We are replying to this message whenever we have some spare time, so please do not consider this as a private 'solve my critical issue asap' service.
Should you need professional Oracle Assistance to make your project a success, please have a look at our consultancy services.
In order to prevent automatic generation of messages, we are asking for a validation code. This code is unique and is generated every time a new message is asked.
If you do not enter the validation correctly, your message will not be recorded.