Home » Developer & Programmer » Forms » TNSNAMES.ORA ERROR (merged 3) (FORMS 12.2.1.3.0)
TNSNAMES.ORA ERROR (merged 3) [message #675105] Sat, 09 March 2019 11:03 Go to next message
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 [message #675116 is a reply to message #675105] Sat, 09 March 2019 12:26 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
Wideminnow6970 wrote on Sat, 09 March 2019 09:33
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.




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: TNSNAMES.ORA ERROR [message #675118 is a reply to message #675105] Sat, 09 March 2019 13:23 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
ORA-12154: TNS:could not resolve the connect identifier specified
 *Cause:  A connection to a database or other service was requested using
 a connect identifier, and the connect identifier specified could not
 be resolved into a connect descriptor using one of the naming methods
 configured. For example, if the type of connect identifier used was a
 net service name then the net service name could not be found in a
 naming method repository, or the repository could not be
 located or reached.
 *Action:
   - If you are using local naming (TNSNAMES.ORA file):
      - Make sure that "TNSNAMES" is listed as one of the values of the
        NAMES.DIRECTORY_PATH parameter in the Oracle Net profile
        (SQLNET.ORA)
      - Verify that a TNSNAMES.ORA file exists and is in the proper
        directory and is accessible.
      - Check that the net service name used as the connect identifier
        exists in the TNSNAMES.ORA file.
      - Make sure there are no syntax errors anywhere in the TNSNAMES.ORA
        file.  Look for unmatched parentheses or stray characters. Errors
        in a TNSNAMES.ORA file may make it unusable.
   - If you are using directory naming:
      - Verify that "LDAP" is listed as one of the values of the
        NAMES.DIRETORY_PATH parameter in the Oracle Net profile
        (SQLNET.ORA).
      - Verify that the LDAP directory server is up and that it is
        accessible.
      - Verify that the net service name or database name used as the
        connect identifier is configured in the directory.
      - Verify that the default context being used is correct by
        specifying a fully qualified net service name or a full LDAP DN
        as the connect identifier
   - If you are using easy connect naming:
      - Verify that "EZCONNECT" is listed as one of the values of the
        NAMES.DIRETORY_PATH parameter in the Oracle Net profile
        (SQLNET.ORA).
      - Make sure the host, port and service name specified
        are correct.
      - Try enclosing the connect identifier in quote marks.

   See the Oracle Net Services Administrators Guide or the Oracle
   operating system specific guide for more information on naming.
Re: TNSNAMES.ORA ERROR (merged 3) [message #675129 is a reply to message #675105] Sun, 10 March 2019 06:18 Go to previous messageGo to next message
John Watson
Messages: 8922
Registered: January 2010
Location: Global Village
Senior Member
You have posted the tnsnames.ora file from the database home. It is the tnsnames.ora file in the Forms home that matters, it will need an entry for the pdborcl service.
Re: TNSNAMES.ORA ERROR (merged 3) [message #675233 is a reply to message #675129] Sat, 16 March 2019 14:34 Go to previous messageGo to next message
Wideminnow6970
Messages: 21
Registered: January 2019
Junior Member
The TNSNAMES.ORA is in the proper directory.
All the syntax looks correct and there is no unmatched parentheses or stray characters.
I am not using LPAD or EZCONNECT.
I added the pdborcl to the TNSNAMES.ORA file.
I put the TNSNAMES.ORA IN THE FORMS HOME and changed the path in the Environmant Variables file under the System variables group
with the same results.


Re: TNSNAMES.ORA ERROR (merged 3) [message #675234 is a reply to message #675233] Sat, 16 March 2019 21:49 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
Wideminnow6970 wrote on Sat, 16 March 2019 12:34
The TNSNAMES.ORA is in the proper directory.
All the syntax looks correct and there is no unmatched parentheses or stray characters.
I am not using LPAD or EZCONNECT.
I added the pdborcl to the TNSNAMES.ORA file.
I put the TNSNAMES.ORA IN THE FORMS HOME and changed the path in the Environmant Variables file under the System variables group
with the same results.


You can be sure & wrong at the same time.

Throughout this whole thread we still have no idea the OS name & version that runs underneath Oracle.

The bottom line is that the TNS alias that is used by your code is NOT found by Oracle to exist within TNSNAMES.ORA file that Oracle looks into.

You don't have to prove anything to us.
This issue is between you & Oracle.

We don't know what you have.
We don't know what you do.

We do know that you have a mystery & give us no clues.
Re: TNSNAMES.ORA ERROR (merged 3) [message #675236 is a reply to message #675234] Sun, 17 March 2019 09:04 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
post COPY & PASTE results of OS command below

tnsping <tns_alias>
Re: TNSNAMES.ORA ERROR (merged 3) [message #675246 is a reply to message #675236] Mon, 18 March 2019 08:08 Go to previous messageGo to next message
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 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
Wideminnow6970 wrote on Mon, 18 March 2019 06:08
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
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 #675248 is a reply to message #675246] Mon, 18 March 2019 12:05 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Quote:
Here is my tnsping alias and the listener status:
Do it from FORMS home not database one.

Re: TNSNAMES.ORA ERROR (merged 3) [message #675249 is a reply to message #675248] Mon, 18 March 2019 14:16 Go to previous messageGo to next message
Wideminnow6970
Messages: 21
Registered: January 2019
Junior Member
C:\WINDOWS\system32>tnsping orcl

TNS Ping Utility for 64-bit Windows: Version 12.1.0.2.0 - Production on 18-MAR-2019 15:15:44

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)))
Re: TNSNAMES.ORA ERROR (merged 3) [message #675250 is a reply to message #675249] Mon, 18 March 2019 14:18 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Still not from FORMS home.

"C:\ORACLE_12C_DATABASE\product\12.1.0\dbhome_1\network\admin" shows you use database home.

Re: TNSNAMES.ORA ERROR (merged 3) [message #675251 is a reply to message #675250] Mon, 18 March 2019 14:23 Go to previous messageGo to next message
Wideminnow6970
Messages: 21
Registered: January 2019
Junior Member

C:\Users\Windows 7>tnsping orcl

TNS Ping Utility for 64-bit Windows: Version 12.1.0.2.0 - Production on 18-MAR-2019 15:21:10

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

Used parameter files:
C:\ORACLE_FORMS_12C_HOME\network\admin\sqlnet.ora


Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = Window10PRO)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = orcl)))
Re: TNSNAMES.ORA ERROR (merged 3) [message #675252 is a reply to message #675251] Mon, 18 March 2019 14:48 Go to previous messageGo to next message
John Watson
Messages: 8922
Registered: January 2010
Location: Global Village
Senior Member
It would seem likely that orcl is your database's root container. That is useless for Forms, you need the pluggable container, pdborcl.
Re: TNSNAMES.ORA ERROR (merged 3) [message #675253 is a reply to message #675252] Mon, 18 March 2019 15:34 Go to previous messageGo to next message
Wideminnow6970
Messages: 21
Registered: January 2019
Junior Member
I added pbdorcl to the tnsnames.ora file in the forms directory:

pdbORCL =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = pdborcl)
))

Re: TNSNAMES.ORA ERROR (merged 3) [message #675257 is a reply to message #675253] Tue, 19 March 2019 04:37 Go to previous messageGo to next message
John Watson
Messages: 8922
Registered: January 2010
Location: Global Village
Senior Member
And???

You make providing assistance really hard, you know.
Re: TNSNAMES.ORA ERROR (merged 3) [message #675258 is a reply to message #675253] Tue, 19 March 2019 09:04 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
Wideminnow6970 wrote on Mon, 18 March 2019 13:34
I added pbdorcl to the tnsnames.ora file in the forms directory:

pdbORCL =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = pdborcl)
))


Your mother should be proud of you.

FWIW when (HOST = localhost), the result is that no remote client can ever connect to this database.
Re: TNSNAMES.ORA ERROR (merged 3) [message #675277 is a reply to message #675258] Wed, 20 March 2019 04:53 Go to previous messageGo to next message
cookiemonster
Messages: 13917
Registered: September 2008
Location: Rainy Manchester
Senior Member
Really?
host points to where the DB host is. If it's on the same machine as the client then what would you put in client tnsnames other than localhost?
Re: TNSNAMES.ORA ERROR (merged 3) [message #675280 is a reply to message #675277] Wed, 20 March 2019 11:37 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
cookiemonster wrote on Wed, 20 March 2019 02:53
Really?
host points to where the DB host is. If it's on the same machine as the client then what would you put in client tnsnames other than localhost?

Yes, really.
HOST=localhost only works when client resides on DB Server.

When listener uses HOST=localhost, then NO remote client can ever connect to this database.
"localhost" is the name for 127.0.0.1; which is a non-routable IP#

https://en.wikipedia.org/wiki/Localhost
Re: TNSNAMES.ORA ERROR (merged 3) [message #675281 is a reply to message #675280] Wed, 20 March 2019 11:50 Go to previous messageGo to next message
cookiemonster
Messages: 13917
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 #675297 is a reply to message #675281] Thu, 21 March 2019 08:47 Go to previous messageGo to next message
Wideminnow6970
Messages: 21
Registered: January 2019
Junior Member
I changed the host name (localhost example taken from internet) to my computer host name master10pro with the same results.
Re: TNSNAMES.ORA ERROR (merged 3) [message #675298 is a reply to message #675297] Thu, 21 March 2019 09:42 Go to previous messageGo to next message
cookiemonster
Messages: 13917
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 #675317 is a reply to message #675298] Thu, 21 March 2019 18:26 Go to previous messageGo to next message
Wideminnow6970
Messages: 21
Registered: January 2019
Junior Member
I had the variable set to C:\ORACLE_12C_DATABASE\PRODUCT\12.1.0\DBHOME_1\NETWORK\ADMIN
Re: TNSNAMES.ORA ERROR (merged 3) [message #675318 is a reply to message #675317] Thu, 21 March 2019 21:11 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
Wideminnow6970 wrote on Thu, 21 March 2019 16:26
I 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.
Re: TNSNAMES.ORA ERROR (merged 3) [message #675323 is a reply to message #675317] Fri, 22 March 2019 02:09 Go to previous messageGo to next message
John Watson
Messages: 8922
Registered: January 2010
Location: Global Village
Senior Member
Wideminnow6970 wrote on Thu, 21 March 2019 23:26
I 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 Go to previous messageGo to next message
cookiemonster
Messages: 13917
Registered: September 2008
Location: Rainy Manchester
Senior Member
BlackSwan wrote on Fri, 22 March 2019 02:11
Wideminnow6970 wrote on Thu, 21 March 2019 16:26
I 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 Go to previous messageGo to next message
cookiemonster
Messages: 13917
Registered: September 2008
Location: Rainy Manchester
Senior Member
Wideminnow6970 wrote on Thu, 21 March 2019 23:26
I 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 #675341 is a reply to message #675331] Fri, 22 March 2019 06:02 Go to previous messageGo to next message
Wideminnow6970
Messages: 21
Registered: January 2019
Junior Member
I set it in the environment variable and with dos under admin
Re: TNSNAMES.ORA ERROR (merged 3) [message #675342 is a reply to message #675341] Fri, 22 March 2019 06:08 Go to previous messageGo to next message
cookiemonster
Messages: 13917
Registered: September 2008
Location: Rainy Manchester
Senior Member
You notice i asked two questions?
You should answer both.
Re: TNSNAMES.ORA ERROR (merged 3) [message #675352 is a reply to message #675342] Fri, 22 March 2019 10:37 Go to previous messageGo to next message
Wideminnow6970
Messages: 21
Registered: January 2019
Junior Member
I did reboot the system
Re: TNSNAMES.ORA ERROR (merged 3) [message #675375 is a reply to message #675323] Mon, 25 March 2019 05:01 Go to previous messageGo to next message
cookiemonster
Messages: 13917
Registered: September 2008
Location: Rainy Manchester
Senior Member
John Watson wrote on Fri, 22 March 2019 07:09
Wideminnow6970 wrote on Thu, 21 March 2019 23:26
I 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 #675952 is a reply to message #675375] Wed, 01 May 2019 14:33 Go to previous messageGo to next message
fatfish6970
Messages: 3
Registered: April 2019
Junior Member


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
Re: TNSNAMES.ORA ERROR (merged 3) [message #675960 is a reply to message #675952] Wed, 01 May 2019 19:16 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.wordpress.com/oracle-tns/ora-12154tns-03505/

Re: TNSNAMES.ORA ERROR (merged 3) [message #675965 is a reply to message #675952] Thu, 02 May 2019 06:56 Go to previous message
cookiemonster
Messages: 13917
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?
Previous Topic: to retrieve BLOB images from database using oracle form 10g
Next Topic: please need hep
Goto Forum:
  


Current Time: Thu Mar 28 10:45:57 CDT 2024