|
|
|
|
|
|
|
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 #675965 is a reply to message #675952] |
Thu, 02 May 2019 06:56  |
cookiemonster
Messages: 13966 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?
|
|
|