SOLVED

ORA-12154: TNS could not resolve service name specified

Asked by OracleDba17 viewsoracle
1
2
3
4
5
6
7
ORA-12154: TNS could not resolve service name specified

Sometimes you will see the error message related to tns.

Error message will be like this.

ORA-12154: TNS could not resolve service name specified
#oracle#error

Solutions(1)

Accepted Solution
1
2
3
4
5
6
7
8
9
10
11
12
13
s

Check if your listener is up and running

Check if listener is listening to database services.

Look for tnsnames.ora file. database entry needs to be available there

Syntax error in tnsnames.ora

Service name might have an alias, so check for global entries and local entries

Location of tnsnames.ora and listener.ora will be as $ORACLE_HOME/network/admin/
OracleDba

Post Your Solution