OraFAQ Forum: Networking and Gateways » Error :12154 Could not resolve service name and No listener error

Home » RDBMS Server » Networking and Gateways » Error :12154 Could not resolve service name and No listener error

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Error :12154 Could not resolve service name and No listener error [message #243819]

Sat, 09 June 2007 05:51

g.s1223
Messages: 17
Registered: May 2007

Junior Member

Hi,

I'm a beginer and i'm using oracle sql plus 8.0 at my home need to find out what is the username,password and host string for sql plus 8.0 from the tnsnames.ora (plz give me some hint as to what to look in the tnsnames.ora)as scott/tiger and system/manger are not working.If sql plus 8.0 is not supported would it be fine to download 9i or 10g and use that sql plus which comes along with it ?

I'ma little confused because the TNSNAMES.ORA is found in these places in my disk.Pls suggest as to which one should i look?I will then check for the host string as you suggested.

1. win32/SQLNET/8_0_6_0_0-1181195/install/NET80/CLIENT
2. win32/SQLNET/8_0_6_0_0-1181195/install/NET23/CLIENT
3. E:\orant\NET80\ADMIN
4. E:\orant\NET80\TNSAPI
5. E:\orant\NET80\ADMIN\SAMPLE
6. F:\Oracle_Forms\win32\SQLNET\8_0_6_0_0-1181195\install\NET23\CLIENT
7. F:\Oracle_Forms\win32\SQLNET\8_0_6_0_0-1181195\install\NET80\CLIENT

I downloaded 6.0 and extracted it in F:/ and i ran the setup and installed it in E:/orant.
--------------------------------------------------------
the TNSNAMES.ORA has the following :

==========================================================
Beq-local.world =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(COMMUNITY = beq.world)
(PROTOCOL = BEQ)
(PROGRAM = oracle80)
(ARGV0 = oracle80ORCL)
(ARGS = '(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))')
)
)
(CONNECT_DATA = (SID = ORCL)
)
)
Tcp-loopback.world =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(COMMUNITY = tcp.world)
(PROTOCOL = TCP)
(Host = 127.0.0.1)
(Port = 1521)
)
)
(CONNECT_DATA = (SID = ORCL)
)
)
tftp.world =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(COMMUNITY = tcp.world)
(PROTOCOL = TCP)
(Host = hostname)
(Port = 1521)
)
)
(CONNECT_DATA = (SID = tftp)
)
)
sfinger.world =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(COMMUNITY = tcp.world)
(PROTOCOL = TCP)
(Host = hostname)
(Port = 1521)
)
)
(CONNECT_DATA = (SID = sfinger)
)
)

=================================================

As suggested I checked in the command by using tnsping..

C:\tnsping\Beq-local.world (also Beq-local)

I got the following error:
'TNSPING'is not recognised as an internal or external command, operable program or batch file.

=> I also tried to enter the Beq-local.world and
Tcp-loopback.world as host string and tried scott/tiger and system/manager with it. but i'm getting the following error

ORA-12154 :TNS :could not resolve service name.

Some one Plz tell me how to proceed further

-------------------------
I downloaded 10g and istalled forms,reports and sql plus with it.
Still I'm not able to connect in SQL PLUS.tThese two errors occur in it.
1. Unable to relove service service name and
2. No listener
Plz Help

Report message to a moderator