Home » RDBMS Server » Networking and Gateways » forms
forms [message #220311] Tue, 20 February 2007 03:42 Go to next message
rdhaprakasam
Messages: 37
Registered: February 2007
Location: Coimbatore
Member

hi to all,
i have installed ORACLE 9i database and ORACLE 9i form builder.i tried to connect the form with my local database. I got this error" ORA-12541: TNS: no listener" . But i can connect with remote server which is in my company. i don`t know how to start
the listener and how to configure.
Can anybody help me?
thanks in advance
gnanaprakash
Re: forms [message #220322 is a reply to message #220311] Tue, 20 February 2007 04:54 Go to previous messageGo to next message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

hi,
Through NETCA
or
On command prompt.
c:\>lsnrctl start


regards
Taj
Re: forms [message #220332 is a reply to message #220322] Tue, 20 February 2007 05:43 Go to previous messageGo to next message
rdhaprakasam
Messages: 37
Registered: February 2007
Location: Coimbatore
Member

thanks for reply,
But i got this error given below. please tell me how can i solve

Starting tnslsnr: please wait...

Service OracleORACLE9iTNSListener already running.
TNS-12536: TNS:operation would block
TNS-12560: TNS:protocol adapter error
TNS-00506: Operation would block
32-bit Windows Error: 997: Unknown error

thanks in advance
gnanapraksam
Re: forms [message #220340 is a reply to message #220332] Tue, 20 February 2007 05:52 Go to previous messageGo to next message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

Hi,

Service OracleORACLE9iTNSListener already running.

Your listener is start. no need to start again.
check YOUR TNS_ADMIN variable is correctly specified.

if not specify like

c:\> set TNS_ADMIN=ORACLE_HOME/network/admin


let us know result
regards
Taj
Re: forms [message #220497 is a reply to message #220340] Tue, 20 February 2007 23:46 Go to previous messageGo to next message
rdhaprakasam
Messages: 37
Registered: February 2007
Location: Coimbatore
Member

thanks man.. i`ll try this method and tell you soon Razz what happen
Re: forms [message #225930 is a reply to message #220497] Thu, 22 March 2007 00:28 Go to previous message
rdhaprakasam
Messages: 37
Registered: February 2007
Location: Coimbatore
Member

is it working friend.. sorry for late reply
Previous Topic: ORA-12508
Next Topic: changing ip address of server which has oracle installed
Goto Forum:
  


Current Time: Wed Dec 07 16:31:18 CST 2016

Total time taken to generate the page: 0.15424 seconds