Home » Developer & Programmer » Forms » ora-12224 tns no listene at user computer
ora-12224 tns no listene at user computer [message #654356] Mon, 01 August 2016 03:23 Go to next message
mfahimaamirgmailcom
Messages: 62
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
Re: ora-12224 tns no listene at user computer [message #654357 is a reply to message #654356] Mon, 01 August 2016 03:38 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
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.

Re: ora-12224 tns no listene at user computer [message #654359 is a reply to message #654357] Mon, 01 August 2016 04:31 Go to previous messageGo to next message
mfahimaamirgmailcom
Messages: 62
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
ora-12545 [message #654361 is a reply to message #654357] Mon, 01 August 2016 05:23 Go to previous messageGo to next message
mfahimaamirgmailcom
Messages: 62
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
Re: ora-12545 [message #654365 is a reply to message #654361] Mon, 01 August 2016 06:05 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
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.
Re: ora-12545 [message #654366 is a reply to message #654361] Mon, 01 August 2016 06:23 Go to previous messageGo to next message
mfahimaamirgmailcom
Messages: 62
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
Re: ora-12545 [message #654370 is a reply to message #654366] Mon, 01 August 2016 06:43 Go to previous messageGo to next message
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.
Re: ora-12545 [message #654375 is a reply to message #654366] Mon, 01 August 2016 07:58 Go to previous message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
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.
Previous Topic: Template form in oracle Forms 10g
Next Topic: Event triggered when a form is closed
Goto Forum:
  


Current Time: Fri Mar 29 03:38:41 CDT 2024