OraFAQ Forum: Forms » ora-12224 tns no listene at user computer

Home » Developer & Programmer » Forms » ora-12224 tns no listene at user computer

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

ora-12224 tns no listene at user computer [message #654356]

Mon, 01 August 2016 03:23

mfahimaamirgmailcom
Messages: 64
Registered: May 2011
Location: pakistan

Member

dear sir
i run my 12c fine and 6i form is also run fine both install in same machine
both run by local host
see =======

orcl =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = pdborcl)
)
)

PDBORCL =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = pdborcl)
)
)

Rep60_MFAMDA-PC,Rep60_MFAMDA-PC.world=(ADDRESS=(PROTOCOL=tcp)(HOST=MFAMDA-PC)(PORT=1949))
=====

but dear i connect in user computer and give the computer name MFAMDA in host name but form not run and give me error ora-12224
i change with ip address 192.168.0.60 but it again give me error ora-12224 tns no listnaer
please help me
thank you in advance
regard

Report message to a moderator

Re: ora-12224 tns no listene at user computer [message #654357 is a reply to message #654356]

Mon, 01 August 2016 03:38

Michel Cadot
Messages: 68755
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Please read OraFAQ Forum Guide and How to use [code] tags and make your code easier to read.
Also always post your Oracle version, with 4 decimals, as solution depends on it.

And at least feedback if not thank people who take time to help you.
Review your previous topics and do it now.

Report message to a moderator

Re: ora-12224 tns no listene at user computer [message #654359 is a reply to message #654357]

Mon, 01 August 2016 04:31

mfahimaamirgmailcom
Messages: 64
Registered: May 2011
Location: pakistan

Member

dear see my version
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
my oracle 12c and form 6i run fine in same machine by host = localhost

see C:\orant\net80\admin =-------

orcl =
 (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521)))
    (CONNECT_DATA = (SERVICE_NAME = pdborcl) ))

PDBORCL =
  (DESCRIPTION =   (ADDRESS = (PROTOCOL = TCP)(HOST =  localhost)(PORT = 1521))
    (CONNECT_DATA =      (SERVER = DEDICATED)
      (SERVICE_NAME = pdborcl)    )  )

Rep60_MFAMDA-PC,Rep60_MFAMDA-PC.world=(ADDRESS=(PROTOCOL=tcp)(HOST=MFAMDA-PC)(PORT=1949))

i give in user computer host name my computer name mfamda-pc but is not run and give me error ora-12224
regard

Report message to a moderator

ora-12545 [message #654361 is a reply to message #654357]

Mon, 01 August 2016 05:23

mfahimaamirgmailcom
Messages: 64
Registered: May 2011
Location: pakistan

Member

dear i check in other computer that no have any antivirus or firewall
then system give me new error
ora-12545 cannect failed because target host or object does not exist

Report message to a moderator

Re: ora-12545 [message #654365 is a reply to message #654361]

Mon, 01 August 2016 06:05

Michel Cadot
Messages: 68755
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Michel Cadot wrote on Mon, 01 August 2016 10:38

...
And at least feedback if not thank people who take time to help you.
Review your previous topics and do it now.

Report message to a moderator

Re: ora-12545 [message #654366 is a reply to message #654361]

Mon, 01 August 2016 06:23

mfahimaamirgmailcom
Messages: 64
Registered: May 2011
Location: pakistan

Member

sir i change host name with ip address
i got ip address by oracle command
select SYS_CONTEXT('USERENV', 'IP_ADDRESS', 15) ipaddr from dual;
result
127.0.0.1

i change this ip address with host

orcl =
(DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521)))
(CONNECT_DATA = (SERVICE_NAME = pdborcl) ))

PDBORCL =
(DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521))
(CONNECT_DATA = (SERVER = DEDICATED)
(SERVICE_NAME = pdborcl) ) )

Rep60_MFAMDA-PC,Rep60_MFAMDA-PC.world=(ADDRESS=(PROTOCOL=tcp)(HOST=MFAMDA-PC)(PORT=1949))

then error change
now user computer give me error ora-12224 tns no listener
ora-12224 tns no listener
sir see new error

regard

Report message to a moderator

Re: ora-12545 [message #654370 is a reply to message #654366]

Mon, 01 August 2016 06:43

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

>my oracle 12c and form 6i
above is NOT a certified combination.
Forms 6i is is either V7 or V8 compatible
SQL*Net is only inter-operable across two major Oracle releases; not FOUR or more.

When localhost, 127.0.0.1, is used then no remote client can ever do packet exchange with this server.

Report message to a moderator

Re: ora-12545 [message #654375 is a reply to message #654366]

Mon, 01 August 2016 07:58

Michel Cadot
Messages: 68755
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Michel Cadot wrote on Mon, 01 August 2016 13:05

Michel Cadot wrote on Mon, 01 August 2016 10:38
...
And at least feedback if not thank people who take time to help you.
Review your previous topics and do it now.

Report message to a moderator

Previous Topic:	Template form in oracle Forms 10g
Next Topic:	Event triggered when a form is closed

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Apr 02 12:36:40 CDT 2025