OraFAQ Forum: Networking and Gateways

Home » RDBMS Server » Networking and Gateways » forms

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

forms [message #220311]

Tue, 20 February 2007 03:42

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

Report message to a moderator

Re: forms [message #220322 is a reply to message #220311]

Tue, 20 February 2007 04:54

Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE

Senior Member

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

regards
Taj

Report message to a moderator

Re: forms [message #220332 is a reply to message #220322]

Tue, 20 February 2007 05:43

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

Report message to a moderator

Re: forms [message #220340 is a reply to message #220332]

Tue, 20 February 2007 05:52

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

Report message to a moderator