Home » RDBMS Server » Server Administration » OracleXe and Visualstudio 2005
OracleXe and Visualstudio 2005 [message #206823] Fri, 01 December 2006 12:12 Go to next message
milleroleg
Messages: 7
Registered: December 2006
Junior Member
hi ...ive got Oracle Xe installed
when i try to access it thru the visual stidio 2005 interface
i get the error TNS : no listener
ive checked both tnsnames.ora :

XE =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = miller-1bcfbce6)(PORT = 1501))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = XE)
)
)

EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC_FOR_XE))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)

ORACLR_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC_FOR_XE))
)
(CONNECT_DATA =
(SID = CLRExtProc)
(PRESENTATION = RO)
)
)

and listener.ora
XE =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = miller-1bcfbce6)(PORT = 1501))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = XE)
)
)

EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC_FOR_XE))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)

ORACLR_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC_FOR_XE))
)
(CONNECT_DATA =
(SID = CLRExtProc)
(PRESENTATION = RO)
)
)

and i still cant figure it out wheres the porblem... id be very gratefull if you could help me ... i did enter my computers name in the server name field ... all correct
so what am i doing wrong ?
Re: OracleXe and Visualstudio 2005 [message #206828 is a reply to message #206823] Fri, 01 December 2006 12:29 Go to previous messageGo to next message
BlackSwan
Messages: 25039
Registered: January 2009
Location: SoCal
Senior Member
Is the Oracle listener actually running?
Re: OracleXe and Visualstudio 2005 [message #206872 is a reply to message #206828] Fri, 01 December 2006 19:44 Go to previous messageGo to next message
milleroleg
Messages: 7
Registered: December 2006
Junior Member
yes ive checked in the task manager and the tnslistener.exe
is running
Re: OracleXe and Visualstudio 2005 [message #206973 is a reply to message #206872] Sat, 02 December 2006 22:20 Go to previous messageGo to next message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

Hi,

check below command.

first go command prompt.

cmd>lsnrctl services

if listener is not running then
cmd>lsnrctl start

then check

if you get any error during startup of listener check registry "tnslsnr.exe" file path is correct set.if not set then set correct and try ur operation again.

reply ...

hope this helps
Taj
nope still the same [message #206981 is a reply to message #206973] Sat, 02 December 2006 23:56 Go to previous messageGo to next message
milleroleg
Messages: 7
Registered: December 2006
Junior Member
the service is running didnt get any error in the CMD
when i tried to connect to the DB thru visual studio i get again the error :
ORA-12541: TNS : no listener
Re: nope still the same [message #206982 is a reply to message #206981] Sun, 03 December 2006 00:07 Go to previous messageGo to next message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

hi

are you check registry for "tnslsnr.exe" is correct set.

cmd>regedit
and check


hope this helps
Taj
Re: nope still the same [message #207003 is a reply to message #206982] Sun, 03 December 2006 11:58 Go to previous messageGo to next message
milleroleg
Messages: 7
Registered: December 2006
Junior Member
cant find the tnslsnr.exe entry in the registry
next step ?
Re: nope still the same [message #207014 is a reply to message #207003] Sun, 03 December 2006 22:08 Go to previous messageGo to next message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

hello

check ::::$oraclehome/bin/tnslsnr.exe
is file is exists or not if exists. then you have to set correct path in tnslsnr.exe.

----------------------------
post output here

cmd>lsnrctl start




hope this helps
Taj.

Re: nope still the same [message #207066 is a reply to message #207014] Mon, 04 December 2006 01:16 Go to previous messageGo to next message
milleroleg
Messages: 7
Registered: December 2006
Junior Member
cmd>lsnrctl start :
service already has been started

and the files is in the right path
so what do i do now ?
Re: OracleXe and Visualstudio 2005 [message #207123 is a reply to message #206823] Mon, 04 December 2006 03:58 Go to previous messageGo to next message
bwetkstr
Messages: 114
Registered: August 2005
Senior Member
Seen that the listener is running ... maybe you should check that the instance is registerd with the listener.

But the error is saying that your listener is not running. He is not saying that he can not find your instance...

Kr
Karel.
Re: OracleXe and Visualstudio 2005 [message #207209 is a reply to message #207123] Mon, 04 December 2006 10:48 Go to previous messageGo to next message
milleroleg
Messages: 7
Registered: December 2006
Junior Member
there is a TNSLISTENER.EXe running ive checked it in the task manager ...what do you mean instance registered with the listener?
Re: OracleXe and Visualstudio 2005 [message #207268 is a reply to message #207209] Mon, 04 December 2006 22:05 Go to previous messageGo to next message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

hi,

for check instance is register...
cmd>lsnrctl services hit <enter>

post here output.


Taj
Re: OracleXe and Visualstudio 2005 [message #207307 is a reply to message #207268] Tue, 05 December 2006 00:33 Go to previous messageGo to next message
milleroleg
Messages: 7
Registered: December 2006
Junior Member
the response is :
TNS-01101 : could not find service name hit
Re: OracleXe and Visualstudio 2005 [message #207317 is a reply to message #207307] Tue, 05 December 2006 00:55 Go to previous messageGo to next message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

hello,

Oracle Error :: TNS-01101
Could not find service name string

Cause
The ervice name could not be resolved by name-lookup.

Action
Verify that the listener name or service name specified to LSNRCTL has the correct name and address defined in LISTENER.ORA or in TNSNAMES.ORA.



can you post ur "tnsnames.ora" or "listener.ora" files.


regards
Taj
Re: OracleXe and Visualstudio 2005 [message #207332 is a reply to message #207209] Tue, 05 December 2006 02:55 Go to previous message
bwetkstr
Messages: 114
Registered: August 2005
Senior Member
milleroleg wrote on Mon, 04 December 2006 17:48
there is a TNSLISTENER.EXe running ive checked it in the task manager ...what do you mean instance registered with the listener?



Your oracle client software can use your tnsnames.ora file to find an oracle instance. In the tnsnames.ora file states the hostname + port of the listener + the instance you want to contact.

So by issuing for example : tnsping db1.company.com
You test your connection to the listener and you check if it can resolve 'db1.company.com'

He will contact a listener. The listener is a process that will connect your client session with the oracle instance. Let's just say it handels the incoming connections, and passes it on the the wanted instance. Of your listener does not know your instance he can not connect you through.

So you need to register your instance with the listener. Do push it
in sqlplus, execute the follwing as a privileged user:

alter system register;

Kr
Karel.
Previous Topic: password required to login as sysdba
Next Topic: Datafiles getting Full
Goto Forum:
  


Current Time: Tue Dec 06 06:10:00 CST 2016

Total time taken to generate the page: 0.12367 seconds