الرساله ora-12541: TNS:no listener

هل جربت الذهاب الى ال servesic الموجوده في ال control pannel وشغلت ال listener التابع لاوراكل

على كل حال . اذا لقيت نفسك مشغلها رد لي خبر

لقد تم الإجابة عن هذا السّؤال في في احد المشاركات ,

و لكن ساحاول اعادة تفسيره

عند فتح SQl PLUS يعطى الرساله ora-12541: TNS:no listener

if u know when you work with oracle you need the client and the server

at the server you should have the listener started

and at the client you should have the TNSNAMES bien configuré

so :

at the file :

TNSNAMES.ora

oracle_home\NET80\ADMIN

or oracle_home\NET\ADMIN

add at the end for exple :

test =

(DESCRIPTION =

(ADDRESS_LIST =

(ADDRESS = (PROTOCOL = TCP)(Host = xxx.xx.xx.xx)(Port = 1521))

)

(CONNECT_DATA =

(SID = DBname)

)

)

the host is the name or th IP of the server

and sid is the name of the database

and that's all

and when you connect enter the user pwd and the alias should be test

if you need more about sthg you can email me

DBOUBA@postmaster.co.uk