I went in TOAD and put in the TNS name for a db that was supplied to me by the DBA. I also put in the user and password and it connected fine. My confusion is that the tnsnames.ora file does not have any entry corresponding to that db name. So how is TOAD resolving the DB name?
TOAD connects despite the db name not being present in tnsnames.ora
2.1k Views Asked by Victor At
1
There are 1 best solutions below
Related Questions in ORACLE11G
- Building an sql execution plan history
- how to update the date field for this specific condition using oracle query?
- Insert Into SP in Oracle Sql Developer
- Trying to update an ORACLE 11G DB with C# Asp.net using Oracle Managed Driver.
- Require tool to trace the LInq Queries in Oracle
- Oracle 11g : staging table
- Persist the value of one column in two simultaneous update
- Trigger From Oracle to SQL SERVER
- how to check succeeded and failed sending a message in gsmcomm library
- How to install Oracle XE for windows32 properly?
- use select under case statement
- Merge table in Oracle with delete condition refering to source table
- Oracle 11g to PostgreSQL - CREATE TYPE OBJECT
- Import dmp file created in Oracle 11g (WE8ISO8859P1) to Oracle 11g XE database (AL32UTF8)
- Changing start date for system jobs related to automatic statistics collections in 11g
Related Questions in TOAD
- How to get result set from Oracle Stored Procedure?
- Excel Import Data from SQL- Date comes in as text value
- oci_fetch always return false
- SQL Alternative to IN operator with variable and between
- ORA-01830: date format picture ends before converting entire input string in TOAD
- SQL How to find parts of a field then put them in a new column
- Toad: 10.6: Seek clear instructions on automating reoccuring excel reports
- Importing large CSV to Oracle via TOAD
- What to do with Oracle data format error?
- How to run sql queries in SQL Developer or TOAD and extract result using bat file
- Toad SQL optimizer not returning elapsed time
- SQL*Loader Control File Custom Date Format
- SQL Server: Issues with data type
- oracle database to find recently added column in table or database(oracle)
- Reuse subquery results in multiple SELECT in Oracle (Can't create table)
Related Questions in TNSNAMES
- Managed ODP.NET Calls to PUBLIC Database Link tables cause TNS errors
- How to connect SQLPlus with tnsnames.ora
- Connection to Oracle via TNS is not working
- Visual Studio can not resolve tns
- Connecting SQL Developer 1.5.4 to tnsnames.ora
- Oracle client encrypt connection to 11g, ignore 9i database
- sqlplus can not connect to oracle using information in tnsnames.ora
- Oracle JDBC-URL with LDAP to OLE DB connect string - how?
- ADD_MASTER_DATABASE procedure changes tns login username
- ORA-12514 error after restarting the server
- Oracle DB "ERROR: ORA-12154: TNS:could not resolve the connect identifier specified"
- PHP & OCI8. easy connect string not working
- How to set proper path to TNSNAMES file in C# application?
- How to use different Service name in the Oracle JDBC long TNSNAME style URL with multiple servers
- tnsping cannot identify the line feed inside tnsnames.ora
Trending Questions
- UIImageView Frame Doesn't Reflect Constraints
- Is it possible to use adb commands to click on a view by finding its ID?
- How to create a new web character symbol recognizable by html/javascript?
- Why isn't my CSS3 animation smooth in Google Chrome (but very smooth on other browsers)?
- Heap Gives Page Fault
- Connect ffmpeg to Visual Studio 2008
- Both Object- and ValueAnimator jumps when Duration is set above API LvL 24
- How to avoid default initialization of objects in std::vector?
- second argument of the command line arguments in a format other than char** argv or char* argv[]
- How to improve efficiency of algorithm which generates next lexicographic permutation?
- Navigating to the another actvity app getting crash in android
- How to read the particular message format in android and store in sqlite database?
- Resetting inventory status after order is cancelled
- Efficiently compute powers of X in SSE/AVX
- Insert into an external database using ajax and php : POST 500 (Internal Server Error)
Popular Questions
- How do I undo the most recent local commits in Git?
- How can I remove a specific item from an array in JavaScript?
- How do I delete a Git branch locally and remotely?
- Find all files containing a specific text (string) on Linux?
- How do I revert a Git repository to a previous commit?
- How do I create an HTML button that acts like a link?
- How do I check out a remote Git branch?
- How do I force "git pull" to overwrite local files?
- How do I list all files of a directory?
- How to check whether a string contains a substring in JavaScript?
- How do I redirect to another webpage?
- How can I iterate over rows in a Pandas DataFrame?
- How do I convert a String to an int in Java?
- Does Python have a string 'contains' substring method?
- How do I check if a string contains a specific word?
In your Oracle client, the ldap.ora file can list one or more ldap server names, which can be queried to get the Oracle instance info for the given TNS name. This way, TOAD (and other apps) can resolve Oracle database names that are not listed in the tnsnames.ora file.