How to Fix ORA-12505, TNS:listener does not currently know of SID given in connect descriptor

SID is word or DB_UNIQUE_NAME that precedes the DB_DOMAIN. For example, the SID database, as seen in in the full global database name of bookstore.company.com.

SERVICE_NAMES, on the other hand, represent the names by which database instances can be connected to. A SERVICE_NAME will follow the format of the SID followed by the database domain, like so: DB_UNIQUE_NAME.DB_DOMAIN

  iPage site builder banner

TNS Names and Configuration

When connecting to an Oracle database, typically your database server will have tnsnames.ora, which is a configuration file that informs the server about NET_SERVICE_NAMES which are valid database connections. By default, this file is located at ORACLE_HOME/network/admin.

For example, a NET_SERVICE_NAME descriptor in tnsnames.ora may be formatted like this:

clip_image001

And listener.ora file, should be look it this.

clip_image002

Click to rate this post!
[Total: 0 Average: 0]

Share and Enjoy !

Shares
Get Weekly KBV Tips !

Learn and improve day to day Knowledge & lifestyles.