OraFAQ Forum: Forms » TNS NAMES ERROR

Home » Developer & Programmer » Forms » TNS NAMES ERROR (ORACLE 12C)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

TNS NAMES ERROR [message #667616]

Mon, 08 January 2018 13:21

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

Report message to a moderator

Re: TNS NAMES ERROR [message #667618 is a reply to message #667616]

Mon, 08 January 2018 14:42

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/

Report message to a moderator

Re: TNS NAMES ERROR [message #667632 is a reply to message #667618]

Tue, 09 January 2018 03:04

cookiemonster
Messages: 13961
Registered: September 2008
Location: Rainy Manchester

Senior Member

you've got a | rather than a \ in your tns_admin

Report message to a moderator

Re: TNS NAMES ERROR [message #667717 is a reply to message #667632]

Thu, 11 January 2018 09:13

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

Report message to a moderator

Re: TNS NAMES ERROR [message #667719 is a reply to message #667717]

Thu, 11 January 2018 09:48

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>

Report message to a moderator

Re: TNS NAMES ERROR [message #667744 is a reply to message #667719]

Fri, 12 January 2018 10:39

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...

Report message to a moderator

Re: TNS NAMES ERROR [message #667745 is a reply to message #667744]

Fri, 12 January 2018 10:53

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

Report message to a moderator

Re: TNS NAMES ERROR [message #667747 is a reply to message #667745]

Fri, 12 January 2018 12:14

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>

Report message to a moderator

Re: TNS NAMES ERROR [message #667748 is a reply to message #667744]

Fri, 12 January 2018 12:22

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?

Report message to a moderator

Re: TNS NAMES ERROR [message #667749 is a reply to message #667747]

Fri, 12 January 2018 12:27

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.

Report message to a moderator

Re: TNS NAMES ERROR [message #667750 is a reply to message #667749]

Fri, 12 January 2018 14:01

fatfish
Messages: 20
Registered: January 2015

Junior Member

This is the only TNSNAES.ORA file this is on the system.

Report message to a moderator

Re: TNS NAMES ERROR [message #667751 is a reply to message #667750]

Fri, 12 January 2018 14:39

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.

Report message to a moderator

Re: TNS NAMES ERROR [message #667841 is a reply to message #667751]

Fri, 19 January 2018 18:00

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 2295 times)

Report message to a moderator

Re: TNS NAMES ERROR [message #667842 is a reply to message #667841]

Fri, 19 January 2018 18:41

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

Report message to a moderator

Re: TNS NAMES ERROR [message #667844 is a reply to message #667841]

Sat, 20 January 2018 01:08

John Watson
Messages: 8962
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)))"

Report message to a moderator

Re: TNS NAMES ERROR [message #667865 is a reply to message #667844]

Mon, 22 January 2018 15:21

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

John Watson
Messages: 8962
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.

Report message to a moderator

Re: TNS NAMES ERROR [message #667878 is a reply to message #667844]

Tue, 23 January 2018 05:26

John Watson
Messages: 8962
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.

Report message to a moderator

Re: TNS NAMES ERROR [message #667881 is a reply to message #667616]

Tue, 23 January 2018 07:59

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.

Report message to a moderator

Re: TNS NAMES ERROR [message #667884 is a reply to message #667881]

Tue, 23 January 2018 09:32

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.

Report message to a moderator

Re: TNS NAMES ERROR [message #667904 is a reply to message #667884]

Tue, 23 January 2018 14:13

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

Report message to a moderator

Re: TNS NAMES ERROR [message #667908 is a reply to message #667904]

Tue, 23 January 2018 19:20

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

Report message to a moderator

Re: TNS NAMES ERROR [message #667925 is a reply to message #667904]

Wed, 24 January 2018 08:54

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>

Report message to a moderator

Re: TNS NAMES ERROR [message #667927 is a reply to message #667925]

Wed, 24 January 2018 09:07

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.

Report message to a moderator

Re: TNS NAMES ERROR [message #668517 is a reply to message #667927]

Tue, 27 February 2018 17:36

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.

Attachment: ORA_LAYOUT.TXT
(Size: 3.18KB, Downloaded 2119 times)

Report message to a moderator

Re: TNS NAMES ERROR [message #668518 is a reply to message #668517]

Tue, 27 February 2018 18:01

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)

Report message to a moderator

Re: TNS NAMES ERROR [message #668519 is a reply to message #668518]

Tue, 27 February 2018 18:03

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

That's nice.

So what works or don't works NOW?

Report message to a moderator

Re: TNS NAMES ERROR [message #668561 is a reply to message #668519]

Thu, 01 March 2018 07:27

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

John Watson
Messages: 8962
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.

Report message to a moderator

Re: TNS NAMES ERROR [message #668566 is a reply to message #668561]

Thu, 01 March 2018 12:33

Littlefoot
Messages: 21823
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.

Report message to a moderator

Previous Topic:	Oracle forms 12c - OLE function not running
Next Topic:	Excel Upload in Forms 12c

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Jan 02 16:35:03 CST 2025