ORA-12224: TNS: no listener [message #654493] |
Thu, 04 August 2016 01:55 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
![](http://www.gravatar.com/avatar/cf5d7c9cc796885aaa693d1815aa858c?s=64&d=mm&r=g) |
mfahimaamirgmailcom
Messages: 62 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
|
|
|
|