![]() ![]() Now the DB_DOMAIN is populated in the data dictionary so that the origin database (where the link is created)Ĭontains a value for both DB_NAME and DB_DOMAIN. It may have been null or not set at all and Or the other case of this error arise after an upgrade from one version of database to another OR the introduction of a PDB in 12c Multitenant.Īt some point since the creation of the database link, the DB_DOMAIN was changed from one value (or possibly null) to a different value.ĭuring the upgrade process the DB_DOMAIN was changed. If you want to be used by everyone, then you need to create public dblink as above. If your dblink is private, then anybody cannot use it. Sometimes this error occurs because of public-private dblink. Or you can use hostname, ip, port and service name as follows. Used TNSNAMES adapter to resolve the aliasĪttempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.63.34)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = MSDB))) To solve this error you need to add the TNS entry to the tnsnames.ora and tnsping TNS_ALIAS command works fine as follows. If it doesn’t exist, then you will give this error. If you use TNS alias in the dblink creation, then check if tns alias exist in the tnsnames.ora. Sometimes this error occurs because of TNS entry used in the database link. If the related view is not present, then create the related view. ora file), you can make a 'Basic' connection.Īnother quirk of the system - we actually read the entries in ANY file named tnsnames* - so if you have older versions of the file saved as something like tnsnames_old.ora or tnsnames.bak - we'll see and use those too, something SQL*Plus used to do and we were asked to follow as well.Sometimes this error occurs because of Database link used in the VIEW is currently not present or dropped in the Database. Assuming you have all the information required (what's normally defined in the. You can however connect to an Oracle Database without a TNSNames.ora file. You do not get a tnsnames.ora file 'for free.' Someone will need to build, maintain, and distribute one for and to you. You can see this for yourself in a SQL Worksheet, by running the command show tns ![]() The location you specified in the preferences.OS Environment Variable value for TNS_ADMIN.$ORACLE_HOME\network\admin - assumes you have a client installed.SQL Developer looks for tnsnames.ora files in the following locations: ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |