ORA-12154

[kris123]

Hi,

How can I solve this "ORA-12154 could not resolve service name" error? when connecting
sqlplus system/manager@devt1

I already tried to follow the METALINK suggestions but it still persist.

I can ping the server (ping linux_svr).
S.O.S. please.

O.S. Linux 7.0
DB Ora 8.1.7

listener.ora
-------------
DEVT1.WORLD =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = linux_svr)
(PORT = 1521))
)
(CONNECT_DATA = (SID = DEV))
)

sqlnet.ora
------------
NAMES.DEFAULT_DOMAIN = WORLD

[julian]

Show us the TNSNAMES.ORA

[kris123]

Hi,

Sorry, that's the tnsnames.ora (labeled as listener.ora)

[sanjaygk]

If you are accessing from client machine (windows) or linux.
then make a service entry in your tnsnames.ora.
it will be located at C:\orant\network\admin or find for tnsnames.ora if it is in linux usually will be there at
$ORACLE_HOME/network/admin/tnsnames.ora
open the file and make the entry for your service.
if u r on server check the status of listener.
to fin out the host address and port number of ur service
give tnsping < service name>

and in sqlnet.ora please delete or comment all the lines except defaul_domain.



cheers

[Sureshy]

As long as your tnsnames.ora is correct this prolem can occur due to one of 3 reasons :

Have you checked whether the Oracle instance is running.
Log on to sever and ensure database is open.

Ensure that tnsnames and sqlnet are in default directory, otherwise set tns_admin environment variable.

Ensure that the sid is specified in listener.ora and listener is started.



you can also try settting up your connection through net8 assistant and test to ensure that your configuration files are set up correctly.

[noor]

Hello,

You can also use the command :

tnsping service_name

in order to check that the tnsnames.ora are configured and the listener is started.

So if the listener in not started, you will have the following message : TNS-12541 (listener not started).

Be careful, tnsping will not let you if your instance is started or not...

Hope this helps

[kris123]

Hi,

I issued tsnping linux_svr, and this is the result

....attempting to contact (ADDRESS=(PROTOCOL=TCP)(HOST=linux_svr)(PORT=1521)) OK (0 msec)

But I still can not connect....need further assistance pls.

[brhynold]

Do tnsping DEVT1.

[kris123]

Hi,

tnsping devt1

tns-03505: failed to resolve name

....what's next?

[sanjaygk]

go to the server where ur database is residing.

u said that ur database is in linux.

then give this command.

ps -ef | grep smon.
it will show the bg process and easily u can make out how many databases are running.

if u have more than one database then check for listener entry for both.

u can do lsnrctl status.
if u don't have then make the listener entry and start the listener again.
from this u can take the service name, port number and hostname and make the entry n tnsnames.ora

then it will work fine.