ORA-12514: TNS: listener does not currently know of service requested in connect descriptor

on

ORA-12514 is occurs when following condition is not meat

1)  Mismatch of TNS in oracle installation Directory (tnsnames.ora file)

“tnsname” =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = “server ip”)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = “dbname”)
)
)

2) Spelling mistake in above configuration

3) Database is not found on  tnsnames.ora file as HOST = “server ip”.

To check which database is available on server as bellow step

  • Open cmd
  • sqlplus user/psw
  • select name from v$database;
  • Check TNS database name in tnsnames.ora  and the output database of above common is not equal then it generate ORA-12514 error.
Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s