Connecting Forms to Oracle

[gisapac]

Someone can help me ..... I'm a beginner and I'm desperate to get the forms in Oracle ...... I already installed the designer on a machine and oracle in another, but even so it continues the error ....
Someone could provide me a step by step than I have to do.
Thanks

[Trevisolli]

Hello how are you?

I will be redirecting this post to the DBA's team here from the forum, so they can help you.

beforehand, I already ask for some data, which will probably ask you to give a help, such as:

bank version:
Operating system:
Forms version:
Error presented:

[gisapac]

Hello friend .... Thanks for the attention: Cry:


Bank version: 8i
Operating system: 2003 Server
Forms version : 6i
Error presented: ORA-12514: Message 12514 Not Found; Product = RDBMS80; Facility = Pray


Thank you

[Trevisolli]

So

Did you ever check, if your TNSNAMES file is configured properly?

If the IP of the machine where it is tending to connect is correct
(in your tnsnames.ora) ...

If your SQLNET.ORA, is there any domain, which is not specified on your tnsnames?

[gisapac]

Friend I'm sorry for my ignorance ... but would you have any templates for setting this file?

I found 7 files with the name you said (tnsnames.ora), in which of these I should change? in all?

Thanks again

[gokden]

It depends on which is configured in your regedit

I opened the Start> Run> "Regedit"

will open a window ..
Go to HKEY_LOCAL_MACHINE> Software> Oracle
Ai on the right side, look for a key with the name of tns_admin

then he will show you a path the tnnames.ora

At least my Oracle was set up here in the businessman

and an example of tnsname.ora here ..

Select all

 
sfcnbr = 
  (description = 
    (address_list = 
      (address = (community = tcp.world)(protocol = tcp)(host = 192.1.1.1)(port = 1521)) 
      (address = (community = tcp.world)(protocol = tcp)(host = 192.1.1.2)(port = 1526)) 
    ) 
    (connect_data = 
      (sid = sfcnbr) 
    ) 
  ) 

99]
This is the maximum qui I can explain about it = D
if the problem is TNSNAME this will help ...

[Trevisolli]

Good morning,

Follow my tnsnames, so that they use example, if necessary?

Select all

 
ORCL.world = 
  (DESCRIPTION = 
    (ADDRESS_LIST = 
      (ADDRESS = (PROTOCOL = TCP)(HOST = NBPT)(PORT = 1521)) 
    ) 
    (CONNECT_DATA = 
      (SERVICE_NAME = ORCL) 
    ) 
  ) 

Where:
Orcl = name of my bank / instance.
. World = name of my domain, which is in SQLNET.ora (if you do not have domain in SQLNET, do not inform you in tnsnames, only leave orcl =. (This TNS is from my local bank) - Full computer name, in: My Computer / Properties.
port = port = port (local).
Service_Name = The same as my bank / instance.

If someone has some more useful information, just post.

[gisapac]

Hello friend ....

Thanks for the force so far .....
I did exactly everything you said, but continues giving error .....
The error has changed to:
OR-12154: TNS: It was not possible to determine the name of the service

Initially I created two different VMs, one emulated Oracle and the other The developer.
I also tried to install Oracle and Developer on the same machine and nothing.

I'm already losing the hopes of getting ...... I already read all Oracle's documentation and nothing .....

Another tip?

Thanks

[Trevisolli]

Send your tns to take a look.

[gokden]

Dude, google search on this error, which has enough thing talking about it ....

I axei quite interesting thing, like this tutorial withdrawn from another site ...

OR-12154: TNS: Could Not Resolves The Connect Identifier Specified
Date: Monday, October 30 @ 11:54:46 BRT
Topic: Articles
This is a mistake that often appears in our forum, even if there are many topics about this problem, there seems to be little understanding about error and their solution.
Let's try to set up a tutorial, with the main reasons and the main solutions adopted in this type of problem.


Basically this is a connection problem between the client and the database.
So let's put in priority the actions, even if basic and even ridiculous, but it has to be looked at and discarded before looking for more complex solutions.

On the server:
1. Verify that the server is on the network, using the ping command both the client for the server and the server to the client, it is necessary to verify that the traffic is available in both hands.
2. Check that the bank is in the air, that is, if the boot process occurred without fail.
2.1. See the Alert that is in the BDump directory configured during the creation of your bank if the bank has been successfully initiated.
2.1.1. Sometimes the process is apparently in the air, but for lack of memory or by a boot failure the bank stayed in stand by.
3. Verify that the listener is working properly.
3.1. Check in the $ Oracle_Home / Network / Log directory. Listener.log
4. Verify that the Listener configuration.ora, sqlnet.ora and tnsnames.ora, which are in the $ Oracle_Home / Network / Admin directory, are correct.
4.1. In the tnsnames.ora file you have to exist and to be in the listed directory, you must also contain the names.directory_path values ??of the sqlnet.ora
5. Check the number of concurrent connections in the Bank Boot file.
6. The directories where both binary (programs) files and datafiles (database) should be owned by the user who will start the bank, this user should never be root or administrator.
7. Try to connect to the bank using SQLPlus, if it fails and no use trying to go to the client, check the error, and if everything is OK, contact the forum personnel, identifying the error and what has already been verified.

In the client:
1. Check the TNSNAMES and SQLNET configuration, which are in the $ Oracle_Home / Network / Admin directory, check out the data to see if all are correct, mainly host name, port, and bank name (SID)
. Run tnSping with the name of the alias that is in TNSNAMES, the same must successfully return the test.
3. Try the connection using SQLPlus, if this fails to check the possible causes of the error.
4. Test the connection using the application.

Any error not covered in this article should be notified to the group so that we can jointly assist in solving its problem in addition to improving this tutorial.

Note: On the site http://www.ora-code.com you will certainly find some more tips, not only for this error as for many others, only in English

withdrawal [url=http://www.profissionaloracle.com.br/mo ... int&sid=56]daqui

[gilbertoca]

Dude, google search on this error, which has enough thing talking about it ....

I Axei a lot of interesting thing, like this tutorial withdrawn from another site ...

OR-12154: TNS: Could Not Resolve The Connect Identifier Specified
Date: Monday, October 30 @ 11:54:46 BRT
Topic: Articles
This is a mistake that often appears in our forum, even if there are many topics about this problem, there seems to be little understanding about error and its solution.
Let's try to set up a tutorial, with the main reasons and the main solutions adopted in this type of problem.


Basically this is a connection problem between the client and the database.
So let's put in priority the actions, even if basic and even ridiculous, but it has to be looked at and discarded before looking for more complex solutions.

On the server:
1. Verify that the server is on the network, using the ping command both the client for the server and the server to the client, it is necessary to verify that the traffic is available in both hands.
2. Check that the bank is in the air, that is, if the boot process occurred without fail.
2.1. See the Alert that is in the BDump directory configured during the creation of your bank if the bank has been successfully initiated.
2.1.1. Sometimes the process is apparently in the air, but for lack of memory or by a boot failure the bank stayed in stand by.
3. Verify that the listener is working properly.
3.1. Check in the $ Oracle_Home / Network / Log directory. Listener.log
4. Verify that the Listener configuration.ora, sqlnet.ora and tnsnames.ora, which are in the $ Oracle_Home / Network / Admin directory, are correct.
4.1. In the tnsnames.ora file you have to exist and to be in the listed directory, you must also contain the names.directory_path values ??of the sqlnet.ora
5. Check the number of concurrent connections in the Bank Boot file.
6. The directories where both binary (programs) files and datafiles (database) should be owned by the user who will start the bank, this user should never be root or administrator.
7. Try to connect to the bank using SQLPlus, if it fails and no use trying to go to the client, check the error, and if everything is OK, contact the forum personnel, identifying the error and what has already been verified.

In the client:
1. Check the TNSNAMES and SQLNET configuration, which are in the $ Oracle_Home / Network / Admin directory, check out the data to see if all are correct, mainly host name, port, and bank name (SID)
. Run tnSping with the name of the alias that is in TNSNAMES, the same must successfully return the test.
3. Try the connection using SQLPlus, if this fails to check the possible causes of the error.
4. Test the connection using the application.

Any error not covered in this article should be notified to the group so that we can jointly assist in solving its problem in addition to improving this tutorial.

Note: On the site http://www.ora-code.com you will certainly find some more tips, not only for this error as for many others, only in English

withdrawal [http://www.profissionaloracle.com.br/mo ... int&sid=56]daqui

Excellent tip!

Route that must be followed by all before to post a message about not being able to connect to the bank.

Thomas, one cares to fix this tip on all forums (DBA, SQL, etc.)? Type a post that will always be the first in the list, as read before posting.

Gilberto

[fabyfmo]

I need to set up too to run the local appliance on the machine, but I did not even start. What did you install beyond Forms 6i? How do you configure the connection to the bank in this business? If possible send me a step by step than you had to change.
Thank you in advance.

[renan.sulaiman]

Good evening!

Personal I have the following problem, I have a bank installed (SID = ASP) on a server and it is working properly, both locally, and accessing a station. I created a new bank (SID = OTLP), set up tnsnames.ora, sqlnet.ora and listener.ora. The Bank works normal locally, but accessing from a station does not connect from the error below:

ORA-12514: Message 12514 Not Found; Product = RDBMS80; Facility = Ora

Here is my configuration files.

TNSNAMES.ORA (Server)

Select all

# tnsnames.ora Network Configuration File: /u01/app/oracle/product/10.2.0/db_1/network/admin/tnsnames.ora 
# Generated by Oracle configuration tools. 
 
ASP = 
  (DESCRIPTION = 
    (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.200)(PORT = 1521)) 
    (CONNECT_DATA = 
      (SERVER = DEDICATED) 
      (SERVICE_NAME = asp) 
    ) 
  ) 
 
OTLP = 
  (DESCRIPTION = 
    (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.200)(PORT = 1521)) 
    (CONNECT_DATA = 
      (SERVER = DEDICATED) 
      (SERVICE_NAME = otlp) 
    ) 
  ) 
 
EXTPROC_CONNECTION_DATA = 
  (DESCRIPTION = 
    (ADDRESS_LIST = 
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1)) 
    ) 
    (CONNECT_DATA = 
      (SID = PLSExtProc) 
      (PRESENTATION = RO) 
    ) 
  ) 
 
LISTENER.ORA (SERVIDOR) 
 
# listener.ora Network Configuration File: /u01/app/oracle/product/10.2.0/db_1/network/admin/listener.ora 
# Generated by Oracle configuration tools. 
 
SID_LIST_LISTENER = 
  (SID_LIST = 
    (SID_DESC = 
      (SID_NAME = PLSExtProc) 
      (ORACLE_HOME = /u01/app/oracle/product/10.2.0/db_1) 
      (PROGRAM = extproc) 
    ) 
  ) 
 
LISTENER = 
  (DESCRIPTION_LIST = 
    (DESCRIPTION = 
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1)) 
      (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.200)(PORT = 1521)) 
    ) 
  )

SQLNET.ORA (server)

Select all

# sqlnet.ora Network Configuration File: /u01/app/oracle/product/10.2.0/db_1/network/admin/sqlnet.ora 
# Generated by Oracle configuration tools. 
 
NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT)

]

tnsnames.ora (station)

Select all

# tnsnames.ora Network Configuration File: E:\oracle\ora102\network\admin\tnsnames.ora 
# Generated by Oracle configuration tools. 
 
OTLP = 
  (DESCRIPTION = 
    (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.200)(PORT = 1521)) 
    (CONNECT_DATA = 
      (SERVER = DEDICATED) 
      (SERVICE_NAME = otlp) 
    ) 
  ) 
 
ASP = 
  (DESCRIPTION = 
    (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.200)(PORT = 1521)) 
    (CONNECT_DATA = 
      (SERVER = DEDICATED) 
      (SERVICE_NAME = asp) 
    ) 
  )

sqlnet.ora (station)

Select all

# This file is actually generated by netca. But if customers choose to  
# install "Software Only", this file wont exist and without the native  
# authentication, they will not be able to connect to the database on NT. 
 
#SQLNET.AUTHENTICATION_SERVICES = (NTS)

Listener status

Select all

[oracle@asp]~/product/10.2.0/db_1/network/admin> lsnrctl start 
 
LSNRCTL for Linux: Version 10.2.0.1.0 - Production on 13-MAY-2009 16:02:03 
 
Copyright (c) 1991, 2005, Oracle.  All rights reserved. 
 
Starting /u01/app/oracle/product/10.2.0/db_1/bin/tnslsnr: please wait... 
 
TNSLSNR for Linux: Version 10.2.0.1.0 - Production 
System parameter file is /u01/app/oracle/product/10.2.0/db_1/network/admin/listener.ora 
Log messages written to /u01/app/oracle/product/10.2.0/db_1/network/log/listener.log 
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1))) 
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.1.200)(PORT=1521))) 
 
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1))) 
STATUS of the LISTENER 
------------------------ 
Alias                     LISTENER 
Version                   TNSLSNR for Linux: Version 10.2.0.1.0 - Production 
Start Date                13-MAY-2009 16:02:03 
Uptime                    0 days 0 hr. 0 min. 0 sec 
Trace Level               off 
Security                  ON: Local OS Authentication 
SNMP                      OFF 
Listener Parameter File   /u01/app/oracle/product/10.2.0/db_1/network/admin/listener.ora 
Listener Log File         /u01/app/oracle/product/10.2.0/db_1/network/log/listener.log 
Listening Endpoints Summary... 
  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1))) 
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.1.200)(PORT=1521))) 
Services Summary... 
Service "PLSExtProc" has 1 instance(s). 
  Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service... 
The command completed successfully

I followed all steps from the tutorial, but without success. Remembering that one of the banks (SID = ASP) that is on the same server is working properly.

If someone can help me it would be grateful.

Renan

[pedroedu]

Renames your tnsnames.ora and creates this:

Select all

LISTENER = 
  (DESCRIPTION_LIST = 
    (DESCRIPTION = 
      (ADDRESS_LIST = 
        (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.200)(PORT = 1521)) 
      ) 
    ) 
  ) 
 
 
SID_LIST_LISTENER = 
  (SID_LIST = 
 
    (SID_DESC = 
      (GLOBAL_DBNAME = otlp) 
      (ORACLE_HOME = /u01/app/oracle/product/10.2.0/db_1) 
      (SID_NAME = otlp) 
    ) 
    (SID_DESC = 
      (GLOBAL_DBNAME = asp) 
      (ORACLE_HOME = /u01/app/oracle/product/10.2.0/db_1) 
      (SID_NAME = asp) 
    ) 
 
 )

Perform commands as Oracle User:
LSNRCTL STOP
LSNRCTL START

I hope I have helped. : Wink:

[AlexTR]

Dude, I'm not even a DBA or anything I only have some basic experiences with settings.
So let's go, I do not know right but it seems to me that this mistake is that the bank is off, already tried Starta he?
Once I went to try to enter the forms and it appeared a message like this (it may be different I do not remember well), try to start the seat and try to connect again.

[samparker1122]

Topic under translation. Come back later. (This is an automatic message)