OracleXe and Visualstudio 2005 [message #206823] |
Fri, 01 December 2006 12:12 |
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 ?
|
|
|
|
|
|
nope still the same [message #206981 is a reply to message #206973] |
Sat, 02 December 2006 23:56 |
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: OracleXe and Visualstudio 2005 [message #207123 is a reply to message #206823] |
Mon, 04 December 2006 03:58 |
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 #207332 is a reply to message #207209] |
Tue, 05 December 2006 02:55 |
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.
|
|
|