OraFAQ Forum: Networking and Gateways » ORA-12224: TNS: no listener

Home » RDBMS Server » Networking and Gateways » ORA-12224: TNS: no listener

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

ORA-12224: TNS: no listener [message #654493]

Thu, 04 August 2016 01:55

mfahimaamirgmailcom
Messages: 64
Registered: May 2011
Location: pakistan

Member

sir i change tnsname.ora and sqlnet.ora file localhost with my computer name in server mfamda-pc then sqlplus and sql developer run fine but form6i not run and give me error ora-12224
see both changes
orcl = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = MFAMDA-PC)(PORT = 1521))
(CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = orcl) ) )

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

SID_LIST_LISTENER =
(SID_LIST = (SID_DESC = (SID_NAME = CLRExtProc)
(ORACLE_HOME = D:\app\OracleHomeUser1\product\12.1.0\dbhome_1)
(PROGRAM = extproc) (ENVS = "EXTPROC_DLLS=ONLY:D:\app\OracleHomeUser1\product\12.1.0\dbhome_1\bin\oraclr12.dll") ) )

LISTENER = (DESCRIPTION_LIST =
(DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = MFAMDA-PC)(PORT = 1521))
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521)) ) )

is it's means oracle 12c is fine problem in form6i
form 6i not run at server with computer name i change form tnsname.ora localhost with computer name MFAMDA-PC
you see and give me idea what is the problem
form give me error ORA-12224
regard

Report message to a moderator

Re: ORA-12224: TNS: no listener [message #654495 is a reply to message #654493]

Thu, 04 August 2016 02:10

John Watson
Messages: 8979
Registered: January 2010
Location: Global Village

Senior Member

I have split your post off from the previous inappropriate topic, and moved it to the Networking forum.

Readers may want to note that this is a cross posting from here,
https://community.oracle.com/message/13963930?tstart=0#13963930
I notice that you did not acknowledge my assistance on your OTN topic, so I shall not waste your time by assisting you further here.

And, in future, please use [code] tags when you copy/paste. Described here, How to use [code] tags and make your code easier to read You have been asked to do this before.

[Updated on: Thu, 04 August 2016 02:11]

Report message to a moderator

Previous Topic:	SCAN Listener issue while connecting to two node RAC
Next Topic:	Connecting Client Application After DB Password Change Fails

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Jul 11 08:44:38 CDT 2025