Home » RDBMS Server » Networking and Gateways » ORA-12224: TNS: no listener
ORA-12224: TNS: no listener [message #654493] Thu, 04 August 2016 01:55 Go to next message
mfahimaamirgmailcom
Messages: 50
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


Re: ORA-12224: TNS: no listener [message #654495 is a reply to message #654493] Thu, 04 August 2016 02:10 Go to previous message
John Watson
Messages: 7183
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:
  


Current Time: Wed Dec 13 21:42:03 CST 2017

Total time taken to generate the page: 0.01499 seconds