03505 Error
Contents |
CommunityOracle User Group CommunityTopliners CommunityOTN Speaker BureauJava CommunityError: You don't have JavaScript enabled. This tool uses JavaScript and much of it will not work correctly without it enabled. Please turn JavaScript back on and reload this page. Please enter a title. You can not tns-03505 failed to resolve name 12c post a blank message. Please type your message and try again. More discussions tns 03505 failed to resolve name used parameter files sqlnet ora in Instant Client All PlacesOracle CommunityArchived ForumsOracle Database Archived ForumsInstant Client This discussion is archived 4 Replies Latest reply on tns-03505 failed to resolve name linux Jan 1, 2012 8:16 AM by 907806 TNS-03505:Failed to resolve name in oracle 11g. 907806 Dec 28, 2011 9:26 AM i install oracle 11g client in my pc.i want to connect to the tns-03505 failed to resolve name in oracle 10g server i also used and install Toad Tools. i have server ip address.192.168.1.162 and userid and password and port number-1521 when i connect to the toad and its make error like that ORA-12541TNS- no listener. and this is my tnsnames.ora file , # tnsnames.ora Network Configuration File: E:\app\IT\product\11.2.0\dbhome_1\network\admin\tnsnames.ora # Generated by Oracle configuration tools. ERP = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = IT-PC)(PORT =
Tns-03505 Failed To Resolve Name In Oracle 12c
1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = erp) ) ) ORACLR_CONNECTION_DATA = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521)) ) (CONNECT_DATA = (SID = CLRExtProc) (PRESENTATION = RO) ) ) ORCL = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST =IT-PC)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = orcl) ) ) mlmdb = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.8.162)(PORT = 1521)) ) (CONNECT_DATA = (SERVICE_NAME = mlmdb) ) ) and i want to connect mlmdb from server. and this is my listner.ora file # listener.ora Network Configuration File: E:\app\IT\product\11.2.0\dbhome_1\network\admin\listener.ora # Generated by Oracle configuration tools. SID_LIST_LISTENER = (SID_LIST = (SID_DESC = (SID_NAME = CLRExtProc) (ORACLE_HOME = E:\app\IT\product\11.2.0\dbhome_1) (PROGRAM = extproc) (ENVS = "EXTPROC_DLLS=ONLY:E:\app\IT\product\11.2.0\dbhome_1\bin\oraclr11.dll") ) ) LISTENER = (DESCRIPTION_LIST = (DESCRIPTION = (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521)) (ADDRESS = (PROTOCOL = TCP)(HOST =IT-PC)(PORT = 1521)) ) ) ADR_BASE_LISTENER = E:\app\IT and this is my sqlnet.ora file # sqlnet.ora Network Configuration File: E:\app\IT\product\11.2.0\dbhome_1\network\admin\sqlnet.ora # Generated by Oracle configuration tools. # This file is actually generated by netca. But if customers choose to # install "Software Only", this file wont exist and without the native # authenticatio
through all the security hassle of Internet Explorer to download the software (I've since put it on it's own volume, and then attach that to my instance, so
Tns 03505 Used Parameter Files
I don't have to do this 300 times)3. Install 11gR2 database, software only.4. tns 03505 failed to resolve name ldap DBCA to build database.5. Net Manager to build the listener.6. Create the weblogic metadata for OBIEE.7. Install OBIEE.8. Scream and tns-03505 failed to resolve name 10g yell when the configuration doesn't work.Rinse and repeat 12 times.I've gotten quite good at it.Then I ran into this lovely error...TNS-03505: Failed to resolve name Cause: The service name you provided could not https://community.oracle.com/thread/2328609 be found in TNSNAMES.ORA, an Oracle Names server, or a native naming service. Action: Verify that you entered the service name correctly. You may need to ensure that the name was entered correctly into the network configuration.I went through Net Manager and Net Configuration Manager about 1000 times. You know, instead of actually reading the error.I thought I needed a Loopback Adapter. I didn't.I started to go http://www.oraclenerd.com/2010/09/tns-03505-failed-to-resolve-name.html through the files by hand, sqlnet.ora, listener.ora, tnsnames.ora (which I'm much more confident with surprisingly)...it had to be something small.# tnsnames.ora Network Configuration File:c:\oracle\product\11.2.0\dbhome_1\network\admin\tnsnames.ora# Generated by Oracle configuration tools.ORACLR_CONNECTION_DATA = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521)) ) (CONNECT_DATA = (SERVICE_NAME = TESTING) (SID = TESTING) ) )LISTENER=(Address=(PROTOCOL=TCP)(HOST=127.0.0.1)(PORT=1521))I name all my sandbox databases "testing." Always have, probably always will. From the command line I issue:SQLPLUS SYS/TESTING@TESTING AS SYSDBA(Yes, I know I don't need to specify the user/password@service_name).Spot it yet?Could it be that my alias says: ORACLR_CONNECTION_DATA?Yup, foiled again. ID10T in the house. Posted by chet justice at 9/02/2010 11:06:00 PM Email ThisBlogThis!Share to TwitterShare to FacebookShare to Pinterest Labels: database, obiee, oradb, TNS-03505 4 comments: Gergo Bacskai said... Hitnsping -?it shows the sqlnet.ora filesqlnet.ora should be :#--------------------------SQLNET.AUTHENTICATION_SERVICES= (NTS)NAMES.DIRECTORY_PATH= (TNSNAMES)#---------------------------...after test your tns:tnsping ORACLR_CONNECTION_DATA... have a look on TNS_ADMIN variableIf TNS_ADMIN set that this would be the tnsnames.ora location.RegardsGergo September 2, 2010 at 11:47 PM oraclenerd said... Gergo,I tried that one (a bunch) too. Problem was, I was using tnsping testing not tnsping ORACLR_CONNECTION_DATAAmusingly, "testing" worked, I'm sure there's a good reason for that (I think I had a "testing" service name defined).chet
TNS-03505: Failed to resolve name tips - tnsping orcl [message #587758] Tue, 18 June 2013 07:37 Devo Messages: 23Registered: November 2012 Location: France Junior Member Hi everybody, I'm trying to connect my oracle http://www.orafaq.com/forum/t/188159/ 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 = http://www.club-oracle.com/threads/tns-03505-failed-to-resolve-name.4302/ TCP)(HOST = myname.lok.DOMAIN)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = orcle) ) ) listener.ora SID_LIST_LISTENER = (SID_LIST = (SID_DESC = (SID_NAME = PLSExtProc) (ORACLE_HOME = F:\oracle\product\10.2.0\db_1) (PROGRAM = extproc) ) ) LISTENER failed to = (DESCRIPTION_LIST = (DESCRIPTION = (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1)) (ADDRESS = (PROTOCOL = TCP)(HOST = myname.lok.DOMAIN)(PORT = 1521)) ) ) sqlnet.ora SQLNET.AUTHENTICATION_SERVICES= (NONE) NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT) Can anyone help me to resolve this problem ? thanks [Updated on: Tue, 18 June 2013 07:37]Report message to a moderator Re: TNS-03505: Failed to resolve name tips - tnsping orcl [message #587759 is a reply to failed to resolve message #587758] Tue, 18 June 2013 07:39 gazzag Messages: 812Registered: November 2010 Location: Bristol, UK Senior Member Try: tnsping ORCLE Report message to a moderator Re: TNS-03505: Failed to resolve name tips - tnsping orcl [message #587760 is a reply to message #587758] Tue, 18 June 2013 07:39 Littlefoot Messages: 20827Registered: June 2005 Location: Croatia, Europe Senior MemberAccount Moderator tnsping orclvs.(tnsnames.ora)ORCLE = Report message to a moderator Re: TNS-03505: Failed to resolve name tips - tnsping orcl [message #587761 is a reply to message #587760] Tue, 18 June 2013 07:40 Devo Messages: 23Registered: November 2012 Location: France Junior Member OMG thanks @Littlefoot it was my error, i should rite tnsping orcle thanks a lot. Report message to a moderator Previous Topic: PL/SQL Developer Debug Date/Time Variable Next Topic: ora-01017 Import/Export SQL SERVER 2008r Wizard From Oracle 10g Goto Forum: - SQL & PL/SQLSQL & PL/SQLClient Tools- RDBMS ServerServer AdministrationBackup & RecoveryPerformance TuningSecurityNetworking and GatewaysEnterprise ManagerServer Utilities- Server OptionsRAC & FailsafeData GuardReplicationStreams & AQSpatialText & interMedia- Developer & ProgrammerApplication Express, ORDS & MOD_PLSQLFormsReports & DiscovererDesignerJDeveloper, Java & XMLWarehouse BuilderPrecompilers, OCI & OCCI- Fusion Middleware & Colab SuiteWeblogic & Application ServerBusiness IntelligenceWebCenter Suite & PortalCollab
Failed to resolve Name Discussion in 'General' started by SudeepShakya, Aug 13, 2011. SudeepShakya Active Member Messages: 33 Likes Received: 1 Trophy Points: 90 Location: Kathmandu,Nepal when i used tnsping last time i worked fine but now it doesn't and displays following error: TNS-03505: Failed to resolve name but the connection works fine while connecting from SQL Developer,jDeveloper and others i have attached image what i did Attached Files: Capture.JPG File size: 42.4 KB Views: 30 SudeepShakya, Aug 13, 2011 #1 apps_expert Forum Expert Messages: 325 Likes Received: 28 Trophy Points: 330 Location: Chennai, India Is your listener service up and running? If yes, do you have multiple oracle homes? If yes, did you set TNS_ADMIN? If you do have multiple oracle homes, try this. From Command prompt, Defin TNS_ADMIN for the current Command Prompt session. For example: C:\> set tns_admin=c:\oracle\network\admin (set this to your own "admin" folder) After you do that try tnsping again and see what happens. If it works, you should set TNS_ADMIN variable in the OS environment variables. apps_expert, Aug 14, 2011 #2 SudeepShakya likes this. SudeepShakya Active Member Messages: 33 Likes Received: 1 Trophy Points: 90 Location: Kathmandu,Nepal it didn't work so i think i have to reinstall Oracle bcoz i don't have much time if any other solutions ??? please reply fast thank u for ur help SudeepShakya, Aug 14, 2011 #3 SudeepShakya Active Member Messages: 33 Likes Received: 1 Trophy Points: 90 Location: Kathmandu,Nepal i viewed the Net Manager and i noticed that last time i saw orcl somewhere but this time the orcl is nowhere i think something is missing there the tnslsnr.exe is also running and i can connect the databases also the only problem is i cannot tnsping As i remember that, i think this problem started when i created a new admin user account on windows and now i have deleted the user account which i was previously using(ie when i installed Oracle for first time) does this user account has some relation with this problem??? SudeepShakya, Aug 14, 2011 #4 apps_expert Forum Expert Messages: 325 Likes Received: 28 Trophy Points: 330 Location: Chennai, India I doubt it. Creating Admin account in windows shouldn't alter tnsping behaviour. Basically what "TNS-03505: Failed to resolve Name" means is that the specified database name (in your case "orcl") was not found in the tnsnames.ora, onames or ldap. This means that the client hasn't even got as far as trying to make contact with a server - it simply can't find any record of the database that you are trying to connect to. apps_expert