TNSNAMES.ORA ERROR (merged 3) [message #675105] |
Sat, 09 March 2019 11:03  |
 |
Wideminnow6970
Messages: 21 Registered: January 2019
|
Junior Member |
|
|
I Installed Oracle 12C forms.
When I try to run FRMBLD,I get the following error:
FRM-18122:Oracle Forms Debugger failed to initialize.
I click on Ok.
Under the Data Block Wizard when trying to connect, I get the following error:
ORA-12154: TNS:could not resolve the connect identifer specified.
I am enclosing a copy of the tnsnames.ora, sqlnet.ora and listiner.ora file with the results of the listener file.
|
|
|
|
|
|
|
|
|
Re: TNSNAMES.ORA ERROR (merged 3) [message #675246 is a reply to message #675236] |
Mon, 18 March 2019 08:08   |
 |
Wideminnow6970
Messages: 21 Registered: January 2019
|
Junior Member |
|
|
Here is my tnsping alias and the listener status:
C:\Users\Windows 7>tnsping orcl
TNS Ping Utility for 64-bit Windows: Version 12.1.0.2.0 - Production on 18-MAR-2019 09:05:56
Copyright (c) 1997, 2014, Oracle. All rights reserved.
Used parameter files:
C:\ORACLE_12C_DATABASE\product\12.1.0\dbhome_1\network\admin\sqlnet.ora
Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = orcl)))
OK (40 msec)
C:\Users\Windows 7>lsnrctl status
LSNRCTL for 64-bit Windows: Version 12.1.0.2.0 - Production on 18-MAR-2019 09:06:30
Copyright (c) 1991, 2014, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=localhost)(PORT=1521)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for 64-bit Windows: Version 12.1.0.2.0 - Production
Start Date 16-MAR-2019 13:24:41
Uptime 1 days 19 hr. 41 min. 49 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File C:\ORACLE_12C_DATABASE\product\12.1.0\dbhome_1\network\admin\listener.ora
Listener Log File C:\ORACLE_12C_DATABASE\diag\tnslsnr\Window10PRO\listener\alert\log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC1521ipc)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcps)(HOST=Window10PRO)(PORT=5500))(Security=(my_wallet_directory=C:\ORACLE_12C_DATABASE\admin\orcl\x db_wallet))(Presentation=HTTP)(Session=RAW))
Services Summary...
Service "CLRExtProc" has 1 instance(s).
Instance "CLRExtProc", status UNKNOWN, has 1 handler(s) for this service...
Service "orcl" has 1 instance(s).
Instance "orcl", status READY, has 1 handler(s) for this service...
Service "orclXDB" has 1 instance(s).
Instance "orcl", status READY, has 1 handler(s) for this service...
Service "pdborcl" has 1 instance(s).
Instance "orcl", status READY, has 1 handler(s) for this service...
The command completed successfully
|
|
|
Re: TNSNAMES.ORA ERROR (merged 3) [message #675247 is a reply to message #675246] |
Mon, 18 March 2019 08:14   |
 |
BlackSwan
Messages: 26766 Registered: January 2009 Location: SoCal
|
Senior Member |
|
|
Wideminnow6970 wrote on Mon, 18 March 2019 06:08Here is my tnsping alias and the listener status:
C:\Users\Windows 7>tnsping orcl
TNS Ping Utility for 64-bit Windows: Version 12.1.0.2.0 - Production on 18-MAR-2019 09:05:56
Copyright (c) 1997, 2014, Oracle. All rights reserved.
Used parameter files:
C:\ORACLE_12C_DATABASE\product\12.1.0\dbhome_1\network\admin\sqlnet.ora
Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = orcl)))
OK (40 msec)
C:\Users\Windows 7>lsnrctl status
LSNRCTL for 64-bit Windows: Version 12.1.0.2.0 - Production on 18-MAR-2019 09:06:30
Copyright (c) 1991, 2014, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=localhost)(PORT=1521)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for 64-bit Windows: Version 12.1.0.2.0 - Production
Start Date 16-MAR-2019 13:24:41
Uptime 1 days 19 hr. 41 min. 49 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File C:\ORACLE_12C_DATABASE\product\12.1.0\dbhome_1\network\admin\listener.ora
Listener Log File C:\ORACLE_12C_DATABASE\diag\tnslsnr\Window10PRO\listener\alert\log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC1521ipc)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcps)(HOST=Window10PRO)(PORT=5500))(Security=(my_wallet_directory=C:\ORACLE_12C_DATABASE\admin\orcl\x db_wallet))(Presentation=HTTP)(Session=RAW))
Services Summary...
Service "CLRExtProc" has 1 instance(s).
Instance "CLRExtProc", status UNKNOWN, has 1 handler(s) for this service...
Service "orcl" has 1 instance(s).
Instance "orcl", status READY, has 1 handler(s) for this service...
Service "orclXDB" has 1 instance(s).
Instance "orcl", status READY, has 1 handler(s) for this service...
Service "pdborcl" has 1 instance(s).
Instance "orcl", status READY, has 1 handler(s) for this service...
The command completed successfully
Above shows that Oracle behaves nicely & as expected when invoked correctly.
The only reasonable conclusion is that FORMS is doing something incorrectly in order to produce ORA-12154 error
|
|
|
|
|
|
|
|
|
|
|
|
|
Re: TNSNAMES.ORA ERROR (merged 3) [message #675281 is a reply to message #675280] |
Wed, 20 March 2019 11:50   |
cookiemonster
Messages: 13965 Registered: September 2008 Location: Rainy Manchester
|
Senior Member |
|
|
Obviously.
But none of that means that this is true:
"when (HOST = localhost), the result is that no remote client can ever connect to this database."
tnsnames controls where the client looks for a DB.
It does not stop remote clients (which would have their own tnsnames.ora) from connecting.
|
|
|
|
Re: TNSNAMES.ORA ERROR (merged 3) [message #675298 is a reply to message #675297] |
Thu, 21 March 2019 09:42   |
cookiemonster
Messages: 13965 Registered: September 2008 Location: Rainy Manchester
|
Senior Member |
|
|
tnsping worked with localhost, that was never the problem.
Problem is still most likely that it isn't using that tnsnames.ora you think it is.
Try setting up a TNS_ADMIN environment variable on your PC that points to the location of the file you want to use.
|
|
|
|
|
Re: TNSNAMES.ORA ERROR (merged 3) [message #675323 is a reply to message #675317] |
Fri, 22 March 2019 02:09   |
John Watson
Messages: 8965 Registered: January 2010 Location: Global Village
|
Senior Member |
|
|
Wideminnow6970 wrote on Thu, 21 March 2019 23:26I had the variable set to C:\ORACLE_12C_DATABASE\PRODUCT\12.1.0\DBHOME_1\NETWORK\ADMIN I'll try again. You have to provide complete information. In this case, where did you set this variable? It would need to be in the registry, so that all shells can pick it up.
You have not shown a tnsping of pdbrcl.
You have not shown how you have configured Forms to use pdborcl.
|
|
|
Re: TNSNAMES.ORA ERROR (merged 3) [message #675330 is a reply to message #675318] |
Fri, 22 March 2019 04:27   |
cookiemonster
Messages: 13965 Registered: September 2008 Location: Rainy Manchester
|
Senior Member |
|
|
BlackSwan wrote on Fri, 22 March 2019 02:11Wideminnow6970 wrote on Thu, 21 March 2019 16:26I had the variable set to C:\ORACLE_12C_DATABASE\PRODUCT\12.1.0\DBHOME_1\NETWORK\ADMIN
That's nice.
Please realize & understand that FORMS has it own ORACLE_HOME tree & uses the tnsnames.ora file from under it.
So I am not surprised that the error for FORMS still occurs when you have NOT corrected the underlying problem.
Oracle error message & code is how it informs you that a problem exists.
You really need to butt out of this BlackSwan cause you have no idea what you are talking about.
Forms will use TNS_ADMIN if it's set, it's one of the main reasons TNS_ADMIN exists.
|
|
|
Re: TNSNAMES.ORA ERROR (merged 3) [message #675331 is a reply to message #675317] |
Fri, 22 March 2019 04:27   |
cookiemonster
Messages: 13965 Registered: September 2008 Location: Rainy Manchester
|
Senior Member |
|
|
Wideminnow6970 wrote on Thu, 21 March 2019 23:26I had the variable set to C:\ORACLE_12C_DATABASE\PRODUCT\12.1.0\DBHOME_1\NETWORK\ADMIN
Where exactly did you set it?
Did you restart your PC after setting it?
|
|
|
|
|
|
Re: TNSNAMES.ORA ERROR (merged 3) [message #675375 is a reply to message #675323] |
Mon, 25 March 2019 05:01   |
cookiemonster
Messages: 13965 Registered: September 2008 Location: Rainy Manchester
|
Senior Member |
|
|
John Watson wrote on Fri, 22 March 2019 07:09Wideminnow6970 wrote on Thu, 21 March 2019 23:26I had the variable set to C:\ORACLE_12C_DATABASE\PRODUCT\12.1.0\DBHOME_1\NETWORK\ADMIN I'll try again. You have to provide complete information. In this case, where did you set this variable? It would need to be in the registry, so that all shells can pick it up.
You have not shown a tnsping of pdbrcl.
You have not shown how you have configured Forms to use pdborcl.
|
|
|
|
|
Re: TNSNAMES.ORA ERROR (merged 3) [message #675965 is a reply to message #675952] |
Thu, 02 May 2019 06:56  |
cookiemonster
Messages: 13965 Registered: September 2008 Location: Rainy Manchester
|
Senior Member |
|
|
fatfish6970 wrote on Wed, 01 May 2019 20:33
The variables were set in the Environment Variable screen:
tns_admin = C:\ORACLE\product\12.1.0\dbhome_1\NETWORK\ADMIN\TNSNAMES.ORA
forms_Path = C:\ORACLE\Middleware\Oracle_Home\forms\java\frmall.jar;C:\ORACLE\Middleware\Oracle_Home\forms\java\FRMWEBUTIL.JAR
forms_builder_classpath = c:\ORACLE\Middleware\Oracle_Home\bin\frmbld.exe;C:\ORACLE\Middleware\Oracle_Home\forms\templates\config\DEFAULT.ENV
Here is the tnsping of pdbrcl:
C:\Users\Windows 7>TNSPING PDBRCL
TNS Ping Utility for 64-bit Windows: Version 12.1.0.2.0 - Production on 01-MAY-2019 15:27:40
Copyright (c) 1997, 2014, Oracle. All rights reserved.
Used parameter files:
C:\ORACLE\product\12.1.0\dbhome_1\network\admin\sqlnet.ora
TNS-03505: Failed to resolve name
Hopefully this is all that you need
You don't appear to be the OP.
Are you actually the OP using a different username?
|
|
|