Home » Developer & Programmer » Forms » TNS NAMES ERROR (ORACLE 12C)
TNS NAMES ERROR [message #667616] Mon, 08 January 2018 13:21 Go to next message
fatfish
Messages: 14
Registered: January 2015
Junior Member
I installed Oracle Forms 12C.
When I try to connect to the database, I get the following error:
ORA-12154: TNS could not resolve the connect identifier specified.

In the Environment Variables I put in the following:
oracle_home = C:\ORACLE\MIDDLEWARE\ORACLE_HOME
tns_admin = C:\ORACLE\MIDDLEWARE\NETWORK\ADMIN

In the Registry, I put in the following:
tns_admin = C:\ORACLE|MIDDLEWARE\NETWORK\ADMIN

forms_builder_classpath (Was already installed and on one line) =
C:\ORACLE\Middleware\Oracle_Home\jlib\frmbld.jar;
C:\ORACLE\Middleware\Oracle_Home\forms\doc\JA\fmdevhlp\importer.jar;
C:\ORACLE\Middleware\Oracle_Home\forms\doc\JA\fmdevhlp\debugger.jar;
C:\ORACLE\Middleware\Oracle_Home\jlib\utj.jar;
C:\ORACLE\Middleware\Oracle_Home\jlib\DFC.JAR;
C:\ORACLE\Middleware\Oracle_Home\jlib\ewt3.jar;
C:\ORACLE\Middleware\Oracle_Home\dmu\modules\oracle.bali.share_11.1.1\SHARE.JAR;
C:\ORACLE\Middleware\Oracle_Home\jlib\ohj.jar;
C:\ORACLE\Middleware\Oracle_Home\dmu\modules\oracle.help_5.0\help-share.jar;
C:\ORACLE\Middleware\Oracle_Home\dmu\modules\oracle.help_5.0\ oracle_ice.jar;
C:\ORACLE\Middleware\Oracle_Home\dmu\jlib\jewt4.jar;
C:\ORACLE\Middleware\Oracle_Home\forms\java\frmwebutil.jar;
C:\ORACLE\Middleware\Oracle_Home\forms\java\frmall.jar;
C:\ORACLE\Middleware\Oracle_Home\forms\doc\US\fmdevhlp\debugger.jar
Re: TNS NAMES ERROR [message #667618 is a reply to message #667616] Mon, 08 January 2018 14:42 Go to previous messageGo to next message
BlackSwan
Messages: 25795
Registered: January 2009
Location: SoCal
Senior Member
ora-12154 ALWAYS only occurs on SQL Client & no SQL*Net packets ever leave client system
ora-12154 NEVER involves the listener, the database itself or anything on the DB Server.
ora-12154 occurs when client requests a connection to some DB server system using some connection string.
TNS-03505 is thrown by tnsping & is same error as ora-12154 thrown by sqlplus or others.
The lookup operation fails because the name provided can NOT be resolved to any remote DB.
The analogous operation would be when you wanted to call somebody, but could not find their name in any phonebook.
The most frequent cause for the ora-12154 error is when the connection alias can not be found in tnsnames.ora.
The lookup operation of the alias can be impacted by the contents of the sqlnet.ora file; specifically DOMAIN entry.
TROUBLESHOOTING GUIDE: ora-12154 & TNS-12154 TNS:could not resolve service name [ID 114085.1]
http://edstevensdba.com/oracle-tns/ora-12154tns-03505/
Re: TNS NAMES ERROR [message #667632 is a reply to message #667618] Tue, 09 January 2018 03:04 Go to previous messageGo to next message
cookiemonster
Messages: 12990
Registered: September 2008
Location: Rainy Manchester
Senior Member
you've got a | rather than a \ in your tns_admin
Re: TNS NAMES ERROR [message #667717 is a reply to message #667632] Thu, 11 January 2018 09:13 Go to previous messageGo to next message
fatfish
Messages: 14
Registered: January 2015
Junior Member
I corrected the | with a \.
I user the hyperlink http://edstevensdba.com/oracle-tns/ora-12154tns-03505/ with the examples and received the same error.

Any other ideas?

Thanks

Re: TNS NAMES ERROR [message #667719 is a reply to message #667717] Thu, 11 January 2018 09:48 Go to previous messageGo to next message
BlackSwan
Messages: 25795
Registered: January 2009
Location: SoCal
Senior Member
fatfish wrote on Thu, 11 January 2018 07:13


Any other ideas?

Thanks

There are two parts to your mystery.
1) what is the actual connection string you issue?
2) what is the content of the tnsnames.ora file?

You post NEITHER of these 2 items yet ask us to tell you what you do wrong?
Since we don't know what exactly you have & we don't know what you actually do, we can't say what is wrong.

What results when you issue OS command below?

tnsping <tns_alias_used_to_connect>
Re: TNS NAMES ERROR [message #667744 is a reply to message #667719] Fri, 12 January 2018 10:39 Go to previous messageGo to next message
fatfish
Messages: 14
Registered: January 2015
Junior Member
TNSNAMES.ORA FILE:
#net_service_name =
ORCL =
#EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST =MASTER-PRO-PC)(PORT = 1521))
(CONNECT_DATA =
(SERVICE_NAME = ORCL.HOME)
)
)
****************************************************************************************
SQLNET.ORA FILE:
# Every line that begins with # is a comment line
# You can modify the entry below for your own database.

# sqlnet.ora Network Configuration File

SQLNET.AUTHENTICATION_SERVICES= (NTS)
NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT)
****************************************************************************************
TNSPING RESULTS:
C:\Users\MASTER-PRO>tnsping asset

TNS Ping Utility for 64-bit Windows: Version 12.2.0.1.0 - Production on 12-JAN-2018 11:34:00

Copyright (c) 1997, 2016, Oracle. All rights reserved.

Used parameter files:
C:\ORACLE\MIDDLEWARE\NETWORK\ADMIN\sqlnet.ora

TNS-03505: Failed to resolve name

****************************************************************************************
I hope this is what you requested...

Re: TNS NAMES ERROR [message #667745 is a reply to message #667744] Fri, 12 January 2018 10:53 Go to previous messageGo to next message
BlackSwan
Messages: 25795
Registered: January 2009
Location: SoCal
Senior Member
What is hostname where C:\ORACLE\MIDDLEWARE exists?

post results from OS command below

tnsping orcl
Re: TNS NAMES ERROR [message #667747 is a reply to message #667745] Fri, 12 January 2018 12:14 Go to previous messageGo to next message
fatfish
Messages: 14
Registered: January 2015
Junior Member
C:\Users\MASTER-PRO>tnsping orcl

TNS Ping Utility for 64-bit Windows: Version 12.2.0.1.0 - Production on 12-JAN-2018 13:13:26

Copyright (c) 1997, 2016, Oracle. All rights reserved.

Used parameter files:
C:\ORACLE\MIDDLEWARE\NETWORK\ADMIN\sqlnet.ora


Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST =MASTER-PRO-PC)(PORT = 1521)) (CONNECT_DATA = (SERVICE_NAME = ORCL.HOME)))
TNS-12533: TNS:illegal ADDRESS parameters

C:\Users\MASTER-PRO>
Re: TNS NAMES ERROR [message #667748 is a reply to message #667744] Fri, 12 January 2018 12:22 Go to previous messageGo to next message
joy_division
Messages: 4817
Registered: February 2005
Location: East Coast USA
Senior Member
fatfish wrote on Fri, 12 January 2018 11:39
TNSNAMES.ORA FILE:
#net_service_name =
ORCL =
#EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST =MASTER-PRO-PC)(PORT = 1521))
(CONNECT_DATA =
(SERVICE_NAME = ORCL.HOME)
)
)
****************************************************************************************
SQLNET.ORA FILE:
# Every line that begins with # is a comment line
# You can modify the entry below for your own database.

# sqlnet.ora Network Configuration File

SQLNET.AUTHENTICATION_SERVICES= (NTS)
NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT)
****************************************************************************************
TNSPING RESULTS:
C:\Users\MASTER-PRO>tnsping asset

TNS Ping Utility for 64-bit Windows: Version 12.2.0.1.0 - Production on 12-JAN-2018 11:34:00

Copyright (c) 1997, 2016, Oracle. All rights reserved.

Used parameter files:
C:\ORACLE\MIDDLEWARE\NETWORK\ADMIN\sqlnet.ora

TNS-03505: Failed to resolve name

****************************************************************************************

Why would you tnsping asset when there is no tns entry for it?
Re: TNS NAMES ERROR [message #667749 is a reply to message #667747] Fri, 12 January 2018 12:27 Go to previous messageGo to next message
BlackSwan
Messages: 25795
Registered: January 2009
Location: SoCal
Senior Member
fatfish wrote on Fri, 12 January 2018 10:14
C:\Users\MASTER-PRO>tnsping orcl

TNS Ping Utility for 64-bit Windows: Version 12.2.0.1.0 - Production on 12-JAN-2018 13:13:26

Copyright (c) 1997, 2016, Oracle. All rights reserved.

Used parameter files:
C:\ORACLE\MIDDLEWARE\NETWORK\ADMIN\sqlnet.ora


Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST =MASTER-PRO-PC)(PORT = 1521)) (CONNECT_DATA = (SERVICE_NAME = ORCL.HOME)))
TNS-12533: TNS:illegal ADDRESS parameters

C:\Users\MASTER-PRO>
Obviously content of TNSNAMES.ORA file is not correct.
Do you have a working copy of tnsnames.ora on a different system?
If so, deposit a working copy on this system.

[oracle@vbgeneric bin]$ oerr ora 12533
12533, 00000, "TNS:illegal ADDRESS parameters"
// *Cause: An illegal set of protocol adapter parameters was specified. In
// some cases, this error is returned when a connection cannot be made to the
// protocol transport.
// *Action: Verify that the destination can be reached using the specified
// protocol. Check the parameters within the ADDRESS section of
// TNSNAMES.ORA. Legal ADDRESS parameter formats may be found in the
// Oracle operating system specific documentation for your platform.
// Protocols that resolve names at the transport layer (such as DECnet object
// names) are vulnerable to this error if not properly configured or names are
// misspelled.

Re: TNS NAMES ERROR [message #667750 is a reply to message #667749] Fri, 12 January 2018 14:01 Go to previous messageGo to next message
fatfish
Messages: 14
Registered: January 2015
Junior Member
This is the only TNSNAES.ORA file this is on the system.
Re: TNS NAMES ERROR [message #667751 is a reply to message #667750] Fri, 12 January 2018 14:39 Go to previous message
BlackSwan
Messages: 25795
Registered: January 2009
Location: SoCal
Senior Member
fatfish wrote on Fri, 12 January 2018 12:01
This is the only TNSNAES.ORA file this is on the system.
Are you saying that no other client system now connects to the Oracle database?

post excerpt from listener.log file showing recent connection requests made to the listener.
Previous Topic: Radio button code.
Next Topic: Exiting Forms
Goto Forum:
  


Current Time: Thu Jan 18 11:05:24 CST 2018

Total time taken to generate the page: 0.09120 seconds