Home » RDBMS Server » Networking and Gateways » Error :12154 Could not resolve service name and No listener error
Error :12154 Could not resolve service name and No listener error [message #243819] Sat, 09 June 2007 05:51 Go to next message
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






Re: Error :12154 Could not resolve service name and No listener error [message #243820 is a reply to message #243819] Sat, 09 June 2007 06:14 Go to previous message
Michel Cadot
Messages: 64145
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Do not start a new topic, continue on the previous one http://www.orafaq.com/forum/t/83267/102589/.
This one is closed.
./fa/448/0/
Regards
Michel

[Updated on: Sat, 09 June 2007 07:59]

Report message to a moderator

Previous Topic: Host String,Username and Password Help (merged)
Next Topic: Heterogenous Services
Goto Forum:
  


Current Time: Fri Dec 09 12:01:22 CST 2016

Total time taken to generate the page: 0.13514 seconds