ORA 12154 TNS could not resolve service name

[shikha tamta]

Hi!!

I have oracle 8i&oracle 9i installed on my machine.
I have set the tnsnames.ora file for Oracle 8i also.
But whenevr i try to access the oracle 8i it throws the error: ORA 12154 TNS could not resolve service name.

Please advice!!

[Niheel]

Did you go through this already:

Cause:
This error indicates that the service (or TNS alias) specified when trying to connect does not exist.

‘TNS aliases’ or ‘service names’ are defined locally to each workstation. Thus different workstations could have a completely different alias to refer to the same database.

Remedy:
Check what aliases are defined on the workstation, either use one that is defined or add an appropriate one.

• The following methods can be used to view the TNS names:
  • Look in the file ‘ORANT\ Network\ Admin\ Tnsnames.ora’ (for versions of Oracle prior to 8.1) or ‘Oracle\ Ora81\ Network\ Admin\ Tnsnames.ora’ (for versions of Oracle from 8.1 onwards). In this file each defined name will normally have ‘.world’ appended to it.
  • For Oracle 8, run ‘Oracle Net8 Easy Config’. This will list the available service names.
  • For Oracle 7, run ‘SQL Net Easy Configuration’. This provides the option to list the available service names.
  • For Oracle 8.1 onwards: Try specifying the full service name, i.e. as it appears in the tnsnames file.

If a connection alias is not being explicitly provided then try to identify what alias Oracle thinks you are using. This will typically be contained in the ‘sqlnet.log’ file that the Oracle client will produce. Possible places where Oracle could be getting this (default) alias from:

• The environment variable ‘LOCAL’.

[shikha tamta]

Did you go through this already:

Cause:
This error indicates that the service (or TNS alias) specified when trying to connect does not exist.

‘TNS aliases’ or ‘service names’ are defined locally to each workstation. Thus different workstations could have a completely different alias to refer to the same database.

Remedy:
Check what aliases are defined on the workstation, either use one that is defined or add an appropriate one.

• The following methods can be used to view the TNS names:
  • Look in the file ‘ORANT\ Network\ Admin\ Tnsnames.ora’ (for versions of Oracle prior to 8.1) or ‘Oracle\ Ora81\ Network\ Admin\ Tnsnames.ora’ (for versions of Oracle from 8.1 onwards). In this file each defined name will normally have ‘.world’ appended to it.
  • For Oracle 8, run ‘Oracle Net8 Easy Config’. This will list the available service names.
  • For Oracle 7, run ‘SQL Net Easy Configuration’. This provides the option to list the available service names.
  • For Oracle 8.1 onwards: Try specifying the full service name, i.e. as it appears in the tnsnames file.

If a connection alias is not being explicitly provided then try to identify what alias Oracle thinks you are using. This will typically be contained in the ‘sqlnet.log’ file that the Oracle client will produce. Possible places where Oracle could be getting this (default) alias from:

• The environment variable ‘LOCAL’.

Hi!!
The service exists & my other collegues are using the same tnsnames.ora file to refer to the same server.but problem persists only for my machine.
I have also set the oracle home & set TNS_ADMIN=C:\oracle\ora81\network\ADMIN\.
Also checked sqlnet.log file but could not get anything useful.
Please advice !!