Oracle Error 03505
Contents |
SQL TuningSecurityOracle UNIXOracle LinuxMonitoringRemote supportRemote plansRemote servicesApplication Server ApplicationsOracle FormsOracle PortalApp UpgradesSQL ServerOracle ConceptsSoftware SupportRemote Support Development Implementation Consulting StaffConsulting PricesHelp Wanted! Oracle PostersOracle Books Oracle Scripts Ion Excel-DB Don Burleson Blog
Tns-03505 Failed To Resolve Name Tnsping
TNS-03505: Failed to resolve name tips Oracle Database Tips by tns-03505 failed to resolve name in oracle 12c Burleson Consulting July 23, 2015 Question: I'm trying to connect to my database and I an getting this TNS-03505 error: tns-03505 failed to resolve name 12c D:\oracle>TNSPING EPT TNS-03505: Failed to resolve name What is the difference between "TNS-03505: Failed to resolve name" and "ORA-12154: TNS:could not resolve the connect identifier specified"? Answer: Obviously, both TNS-03505 and ORA-12154 are TNS errors;
Tns-03505 Failed To Resolve Name In Oracle 10g
however, they can each have a variety of possible causes and resolutions. The TNS-03505 error indicates that the service name is missing : TNS-03505: Failed to resolve name Cause: The service name you provided could not 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
Tns 03505 Failed To Resolve Name Used Parameter Files Sqlnet Ora
network configuration. Appearing on its own, this essentially means the client has not even gotten to the point of attempting to make contact with a server. The TNS-03505 is telling you that it simply cannot find any record of the database you are trying to establish a connection with. Some things to check include the following: Verify that you have spelled the database name correctly, and that the database has an appropriate entry in the tnsnames.ora, including assurance that the path to the database is correct as sometimes the connection will work when run on a single box but not with connection to a client machine. Verify that there are not multiple tsnnames.ora files as it may be attempting a connection to the wrong database. If connecting to a client machine, make sure there are no firewall issues blocking the connection. The ORA-12154 error generally indicates you got a little further in the process such that Oracle itself is telling you that it is looking but cannot find the database indicated. Click here for tips on resolving the ORA-12154. �� Burleson is the Ame
through all the security hassle of Internet Explorer to download the software (I've since put tns-03505 failed to resolve name linux it on it's own volume, and then attach that to my
Tns 03505 Used Parameter Files
instance, so I don't have to do this 300 times)3. Install 11gR2 database, software only.4. DBCA to tns-03505: failed to resolve name ldap build database.5. Net Manager to build the listener.6. Create the weblogic metadata for OBIEE.7. Install OBIEE.8. Scream and yell when the configuration doesn't work.Rinse and repeat 12 http://www.dba-oracle.com/t_tns_03505_failed_to_resolve_name.htm 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 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 http://www.oraclenerd.com/2010/09/tns-03505-failed-to-resolve-name.html 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 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... Hitnspi
SonicWALL User Sorry, we are having issues processing your request. If you own the SonicWALL product requested please confirm that you have https://support.software.dell.com/kb/40788 registered your product at My SonicWALL . If you have already registered your product then please contact Customer Service directly for further assistance at customerservice@software.dell.com. Continue × Support Forms Under Maintenance Submitting forms on the support site are temporary unavailable for schedule maintenance. If you need immediate assistance please contact technical support. We apologize for the inconvenience. Continue failed to Search Sign In Sign In Create Support Account Products ActiveRoles Boomi Change Auditor Foglight Identity Manager KACE Migration Manager Rapid Recovery Recovery Manager SharePlex SonicWALL Spotlight Statistica Toad View all Products Solutions Application & Data Integration Big Data Analytics Business Intelligence Cloud Management Data Protection Overview Backup and Recovery Deduplication and Compression Database Development and Management Database Replication & failed to resolve Backup Endpoint Management Mobile Workforce Management Overview Desktop Virtualization Enterprise Mobility Management Endpoint Security Network Security Secure Remote Access Performance Monitoring Security Overview Email Security Endpoint Security Identity & Access Management Network Security Secure Remote Access Virtualization Management Microsoft Platform Management View all Solutions Solutions by Platform Active Directory Exchange Google GroupWise & NDS Hadoop Hyper-V Lotus Notes Skype for Business/Lync Office 365 Oracle SharePoint SQL Server VMware Trials Buy Support By Product Line Enterprise Reporter Foglight KACE Migration Manager Migrator NetVault One Identity Quick Connect Performance Analysis Recovery Manager Shareplex SonicWALL Spotlight SQL Navigator Toad All Products Contact Support Download Software Knowledge Base My Account My Products My Service Requests My Licenses My Groups My Profile Policies & Procedures Professional Services Technical Documentation Training & Certification User Forums Video Tutorials Support Home Communities Partners × Email Share your favorite Support content with a friend. Email To Email From Subject Information from Dell Software Support Message You might be interested in the following information For more information regarding support on your Dell Software P