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: 20
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: 26766
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: 13917
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: 20
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: 26766
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: 20
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: 26766
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: 20
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: 4963
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: 26766
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: 20
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 messageGo to next message
BlackSwan
Messages: 26766
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.
Re: TNS NAMES ERROR [message #667841 is a reply to message #667751] Fri, 19 January 2018 18:00 Go to previous messageGo to next message
fatfish
Messages: 20
Registered: January 2015
Junior Member
I only use sql to connect to the Oracle database.

See attached for the Listener.log file



  • Attachment: listener.log
    (Size: 2.36KB, Downloaded 1653 times)
Re: TNS NAMES ERROR [message #667842 is a reply to message #667841] Fri, 19 January 2018 18:41 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
Logfile below shows ZERO connection requests being made by any client to connect to Oracle database

Log messages written to c:\app\MASTER-PRO\virtual\diag\tnslsnr\MASTER-PRO-PC\listener\alert\log.xml
Trace information written to c:\app\MASTER-PRO\virtual\diag\tnslsnr\MASTER-PRO-PC\listener\trace\ora_8928_7392.trc
Trace level is currently 0

Started with pid=8928
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=MASTER-PRO-PC)(PORT=1521)))

TIMESTAMP * CONNECT DATA [* PROTOCOL INFO] * EVENT [* SID] * RETURN CODE
2018-01-19T15:23:59.827413-05:00
19-JAN-2018 15:23:59 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=)(USER=MASTER-PRO))(COMMAND=status)(ARGUMENTS=64)(SERVICE=LISTENER)(VERSION=203424000)) * status * 0
2018-01-19T15:24:04.851075-05:00
19-JAN-2018 15:24:04 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=)(USER=MASTER-PRO))(COMMAND=status)(ARGUMENTS=64)(SERVICE=LISTENER)(VERSION=203424000)) * status * 0
2018-01-19T15:24:34.551624-05:00
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcps)(HOST=MASTER-PRO-PC)(PORT=5500))(Security=(my_wallet_directory=C:\APP\MASTER-PRO\VIRTUAL\admin\o rcl\xdb_wallet))(Presentation=HTTP)(Session=RAW))
Dynamic address is already listened on (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=MASTER-PRO-PC)(PORT=1521)))
19-JAN-2018 15:24:33 * (ADDRESS=(PROTOCOL=tcp)(HOST=fe80::2027:3ee1:c445:cb89%11)(PORT=50967)) * service_register * orcl * 0
2018-01-19T15:27:52.088807-05:00
19-JAN-2018 15:27:52 * service_update * orcl * 0
2018-01-19T15:37:14.503861-05:00
19-JAN-2018 15:37:14 * service_update * orcl * 0
2018-01-19T15:37:53.589099-05:00
19-JAN-2018 15:37:53 * service_update * orcl * 0
2018-01-19T15:47:39.851672-05:00
19-JAN-2018 15:47:39 * service_update * orcl * 0
2018-01-19T15:47:54.892243-05:00
19-JAN-2018 15:47:54 * service_update * orcl * 0
2018-01-19T15:56:44.109529-05:00
19-JAN-2018 15:56:44 * service_update * orcl * 0
2018-01-19T15:58:12.810476-05:00
19-JAN-2018 15:57:56 * service_update * orcl * 0
2018-01-19T16:06:48.557488-05:00
19-JAN-2018 16:06:48 * service_update * orcl * 0
2018-01-19T16:08:37.441518-05:00
19-JAN-2018 16:07:57 * service_update * orcl * 0
2018-01-19T16:09:15.958953-05:00
19-JAN-2018 16:09:15 * service_update * orcl * 0
2018-01-19T16:10:22.166351-05:00
19-JAN-2018 16:10:22 * service_update * orcl * 0
Re: TNS NAMES ERROR [message #667844 is a reply to message #667841] Sat, 20 January 2018 01:08 Go to previous messageGo to next message
John Watson
Messages: 8922
Registered: January 2010
Location: Global Village
Senior Member
I think you have a corrupted tnnames.ora file. Your tnsping of orcl return a TNS-12533, but there is nothing wrong with the entry.

Try this:
tnsping "(DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST =MASTER-PRO-PC)(PORT = 1521)) (CONNECT_DATA = (SERVICE_NAME = ORCL.HOME)))"
Re: TNS NAMES ERROR [message #667865 is a reply to message #667844] Mon, 22 January 2018 15:21 Go to previous messageGo to next message
fatfish
Messages: 20
Registered: January 2015
Junior Member
I tried the tnsping and got the following results:

C:\Users\MASTER-PRO>tnsping "(DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST =MASTER-PRO-PC)(PORT = 1521)) (CONNECT_DATA = (SERVICE_NAME = ORCL.HOME)))"

TNS Ping Utility for 64-bit Windows: Version 12.2.0.1.0 - Production on 22-JAN-2018 16:15:24

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

Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST =MASTER-PRO-PC)(PORT = 1521)) (CONNECT_DATA = (SERVICE_NAME = ORCL.HOME)))
TNS-12541: TNS:no listener

I checked the status of the listener:

C:\Users\MASTER-PRO>lsnrctl   status

LSNRCTL for 64-bit Windows: Version 12.2.0.1.0 - Production on 22-JAN-2018 16:19:50

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

Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
TNS-12541: TNS:no listener
 TNS-12560: TNS:protocol adapter error
  TNS-00511: No listener
   64-bit Windows Error: 61: Unknown error


Here is the listener.ora file layout:

# listener.ora Network Configuration File: C:\ORACLE\MIDDLEWARE\NETWORK\ADMIN\listener.ora
# Generated by Oracle configuration tools.

LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = MASTER-PRO-PC = 1521))
  (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
 
  )
  )

SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
      (SID_NAME = plsextproc)
      (ORACLE_HOME = C:\ORACLE_HOME\product\12.2.0\dbhome_2)
      (PROGRAM = extproc)
        )
  )


[EDITED by LF: deleted duplicates, applied [code] tags to this message]

[Updated on: Tue, 23 January 2018 13:56] by Moderator

Report message to a moderator

Re: TNS NAMES ERROR [message #667877 is a reply to message #667844] Tue, 23 January 2018 05:24 Go to previous messageGo to next message
John Watson
Messages: 8922
Registered: January 2010
Location: Global Village
Senior Member
1. Please do not spam the board with repeated messages.
2. Please use [code] tags when you post stuff, described here How to use [code] tags and make your code easier to read
3. So it is clear that your tnanmaes.ora file is corrupted. Re-create it.
4. Set your TNS_ADMIN variable, and start the listener. Show what happens.
Re: TNS NAMES ERROR [message #667878 is a reply to message #667844] Tue, 23 January 2018 05:26 Go to previous messageGo to next message
John Watson
Messages: 8922
Registered: January 2010
Location: Global Village
Senior Member
Alsdo, your listener.ora file is wrong. This line
(ADDRESS = (PROTOCOL = TCP)(HOST = MASTER-PRO-PC = 1521))
is missing the PORT clause.
Re: TNS NAMES ERROR [message #667881 is a reply to message #667616] Tue, 23 January 2018 07:59 Go to previous messageGo to next message
joy_division
Messages: 4963
Registered: February 2005
Location: East Coast USA
Senior Member
Same spam post as the previous 4 or 5. Why did you insist o doing this? It will just make people pissed off and to stop helping you.
Re: TNS NAMES ERROR [message #667884 is a reply to message #667881] Tue, 23 January 2018 09:32 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
move, remove, or rename listener.ora file, then issue OS command below
> C:\ORACLE\MIDDLEWARE\NETWORK\ADMIN\listener.ora

lsnrctl start

COPY the results from above then PASTE all back here.
Re: TNS NAMES ERROR [message #667904 is a reply to message #667884] Tue, 23 January 2018 14:13 Go to previous messageGo to next message
fatfish
Messages: 20
Registered: January 2015
Junior Member
C:\WINDOWS\system32>lsnrctl start

LSNRCTL for 64-bit Windows: Version 12.2.0.1.0 - Production on 23-JAN-2018 15:11:26

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

Starting tnslsnr: please wait...

TNSLSNR for 64-bit Windows: Version 12.2.0.1.0 - Production
Log messages written to c:\app\MASTER-PRO\virtual\diag\tnslsnr\MASTER-PRO-PC\listener\alert\log.xml
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=MASTER-PRO-PC)(PORT=1521)))

Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for 64-bit Windows: Version 12.2.0.1.0 - Production
Start Date 23-JAN-2018 15:11:30
Uptime 0 days 0 hr. 0 min. 2 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Log File c:\app\MASTER-PRO\virtual\diag\tnslsnr\MASTER-PRO-PC\listener\alert\log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=MASTER-PRO-PC)(PORT=1521)))
The listener supports no services
The command completed successfully
Re: TNS NAMES ERROR [message #667908 is a reply to message #667904] Tue, 23 January 2018 19:20 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
I can see that you correctly did as requested since no listener.ora file is mentioned when starting the listener.
Now that you have a working listener post the results of OS command below

lsnrctl status
Re: TNS NAMES ERROR [message #667925 is a reply to message #667904] Wed, 24 January 2018 08:54 Go to previous messageGo to next message
fatfish
Messages: 20
Registered: January 2015
Junior Member
I added to port name to the listener.
I put the listener back in.
I checked the status of the listener:

C:\Users\MASTER-PRO>lsnrctl status

LSNRCTL for 64-bit Windows: Version 12.2.0.1.0 - Production on 24-JAN-2018 09:50:09

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

Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for 64-bit Windows: Version 12.2.0.1.0 - Production
Start Date 23-JAN-2018 15:11:30
Uptime 0 days 18 hr. 38 min. 41 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Log File c:\app\MASTER-PRO\virtual\diag\tnslsnr\MASTER-PRO-PC\listener\alert\log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=MASTER-PRO-PC)(PORT=1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcps)(HOST=MASTER-PRO-PC)(PORT=5500))(Security=(my_wallet_directory=C:\APP\MASTER-PRO\VIRTUAL\admin\o rcl\xdb_wallet))(Presentation=HTTP)(Session=RAW))
Services Summary...
Service "c94f716b4e514858a57b9f568b1cab6f.home" has 1 instance(s).
Instance "orcl", status READY, has 1 handler(s) for this service...
Service "orcl.home" has 1 instance(s).
Instance "orcl", status READY, has 1 handler(s) for this service...
Service "orclXDB.home" has 1 instance(s).
Instance "orcl", status READY, has 1 handler(s) for this service...
Service "orclpdb.home" has 1 instance(s).
Instance "orcl", status READY, has 1 handler(s) for this service...
The command completed successfully

C:\Users\MASTER-PRO>
Re: TNS NAMES ERROR [message #667927 is a reply to message #667925] Wed, 24 January 2018 09:07 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
OK, you have shown that this listener knows about a few different Service names.
In order for any client to successfully connect to any instance know to this listener, then client must specify a Service name the listener recognizes.
Re: TNS NAMES ERROR [message #668517 is a reply to message #667927] Tue, 27 February 2018 17:36 Go to previous messageGo to next message
fatfish
Messages: 20
Registered: January 2015
Junior Member
I tried different service and instances from the listener status
in the tnsnames.ora file.
I found a tnsnames.ora file that I had on another pc that worked,
but that system crashed and could not be recovered.
I setup the same tnsnames.ora file the same as the other file,
but I changed the host name for the current pc.
I am attaching the tnsname.ora, sqlnet.ora and the listener.ora file
with the listener status.
Re: TNS NAMES ERROR [message #668518 is a reply to message #668517] Tue, 27 February 2018 18:01 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
listener status

C:\Users\MASTER-PRO>lsnrctl status
LSNRCTL for 64-bit Windows: Version 12.2.0.1.0 - Production on 27-FEB-2018 18:19:59
Copyright (c) 1991, 2016, Oracle. All rights reserved.
Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for 64-bit Windows: Version 12.2.0.1.0 - Production
Start Date 23-FEB-2018 19:03:09
Uptime 3 days 23 hr. 16 min. 54 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Log File c:\app\MASTER-PRO\virtual\diag\tnslsnr\MASTER-PRO-PC\listener\alert\log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=MASTER-PRO-PC)(PORT=1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcps)(HOST=MASTER-PRO-PC)(PORT=5500))(Security=(my_wallet_directory=C:\APP\MASTER-PRO\VIRTUAL\admin\o rcl\xdb_wallet))(Presentation=HTTP)(Session=RAW))
Services Summary...
Service "c94f716b4e514858a57b9f568b1cab6f.home" has 1 instance(s).
Instance "orcl", status READY, has 1 handler(s) for this service...
Service "orcl.home" has 1 instance(s).
Instance "orcl", status READY, has 1 handler(s) for this service...
Service "orclXDB.home" has 1 instance(s).
Instance "orcl", status READY, has 1 handler(s) for this service...
Service "orclpdb.home" has 1 instance(s).
Instance "orcl", status READY, has 1 handler(s) for this service...
The command completed successfully

************************************************************************
listener.ora file


# listener.ora Network Configuration File: C:\ORACLE\MIDDLEWARE\NETWORK\ADMIN\listener.ora
# Generated by Oracle configuration tools.

# C:\ORACLE\MIDDLEWARE\NETWORK\ADMIN\LISTENER.ORA

SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = plsextproc)
(ORACLE_HOME = C:\app\MASTER-PRO\virtual\product\12.2.0\dbhome_2)
(PROGRAM = extproc)
)
)

LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
(ADDRESS = (PROTOCOL = TCP)(HOST = MASTER-PRO-PC) (port = 1521))

)
)

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

tnsnames.ora file

# tnsnames.ora Network Configuration File: C:\ORACLE\MIDDLEWARE\NETWORK\ADMIN\tnsnames.ora
# Generated by Oracle configuration tools.

#C:\ORACLE\MIDDLEWARE\NETWORK\ADMIN\tnsnames.ora
#net_service_name =
ORCL =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = MASTER-PRO-PC)(PORT = 1521))
(CONNECT_DATA =
(server = dedicated)
(SERVICE_NAME=ORCL.HOME)
)
))

EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)


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

sqlnet.ora file

# sqlnet.ora Network Configuration File: C:\ORACLE\MIDDLEWARE\NETWORK\ADMIN\sqlnet.ora
# Generated by Oracle configuration tools.

SQLNET.AUTHENTICATION_SERVICES= (NTS)

NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT)
Re: TNS NAMES ERROR [message #668519 is a reply to message #668518] Tue, 27 February 2018 18:03 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
That's nice.

So what works or don't works NOW?
Re: TNS NAMES ERROR [message #668561 is a reply to message #668519] Thu, 01 March 2018 07:27 Go to previous messageGo to next message
fatfish
Messages: 20
Registered: January 2015
Junior Member
The version of Oracle forms that used to work was version 8.
I am still getting the ORA-12154 error.

[Updated on: Thu, 01 March 2018 07:34]

Report message to a moderator

Re: TNS NAMES ERROR [message #668563 is a reply to message #668561] Thu, 01 March 2018 07:38 Go to previous messageGo to next message
John Watson
Messages: 8922
Registered: January 2010
Location: Global Village
Senior Member
I think you are confused about the database environment.

Your lsnrctl status on 24 January shows that you have a multitenant database. Presumably your application is in the pluggable container orclpdb. But your tnsnames entry is pointing to a service orcl.home, which is the root container. You would not want to connect to that with Middleware.

Better ask your DBA to expain how Multitenant works.
Re: TNS NAMES ERROR [message #668566 is a reply to message #668561] Thu, 01 March 2018 12:33 Go to previous message
Littlefoot
Messages: 21806
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
fatfish wrote on Thu, 01 March 2018 14:27

The version of Oracle forms that used to work was version 8.
Forms version 8 never existed.
Previous Topic: Oracle forms 12c - OLE function not running
Next Topic: Excel Upload in Forms 12c
Goto Forum:
  


Current Time: Thu Mar 28 17:36:37 CDT 2024