Connect to the DB from Oracle forms 6i with existing Oracle 22.214.171.124.0 DB.
Joined: May 06, 2003
Hi, I am searching like mad every where on the net to get this thing working,so here I go again. I have the following Oracle DB on my system. Oracle version : 126.96.36.199.0 OS : Win2000 PE, 64MB RAM, PIII processor. I searched in google.com and also in other Oracle forums.I found a few useful hints, which I tried and still the problem exists. When I try to connect to the DB from Oracle forms 6i with just the username and password I get the following error : ORA-12203 : TNS : unable to connect to destination. In one site it had mentioned that I provide the host string name as that mentioned in the TNSNAMES.ORA file. I did that and got the following error : ORA-12154 : TNS : Could not resolve service name. I gave the service name as "home" as mentioned in my Oracle 188.8.131.52.0 ,TNSNAMES.ORA file, in the host string field of the forms 6i connect dialog box. I got the following error : ORA-12514 : Message 12514 not found: product=RDBMS80:facility=ORA In an other site it had mentioned that I do the following: 1) Uninstall all Oracle products. 2) Install Oracle forms 6i first. 3) Then install Oracle 184.108.40.206.0 database. I did the above steps as well, but still I am unable to connect to the DB from forms 6i. I would like to know what the format of "host string" is,in the username/ password dialog box. Can anyone assist me with this issue with a detailed explanation. thanks in advance sharathkv.
Yes, basically the error is that the server name you are giving in Forms is not in your tnsnames.ora file. Just in case, this file is located in your ORACLE_HOME/network/admin directory. There should already be an example entry in this file. Follow that pattern. Or ask your DBA for some help. The error isn't in Forms it is in your tnsnames file. I will post more tomorrow, but I am not at work so I don't have an example ready. Good Luck Mark
Hi Mark, Please allow me .. --------------------------------- Hi Sharath,
These errors are the first few rocks that are but the first steps. a little bit of permutation and combination will help. I am adding my experience to your post may be helpful . First you may want to understand what tnsnames.ora does. I usaually think of it as a entry in telephone directory Lets take an example ----start ---- a.world = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP) (Host = 220.127.116.11) (Port = 1521) ) ) (CONNECT_DATA = (SID = ORCL) ) ) ----end ---- Just by saying firstname.lastname@example.org we get connected to database but internally this a.world is mapped to the whole slew of information. a.world (This "world" usaually comes from sqlnet.ora you can also try without this world and database may still let you connect) Speaking again of the slew of information. . .
(PROTOCOL = TCP) (Host = 18.104.22.168) (Port = 1521) this is what you already know.. the SQL net connection is TCP , and connecting to Host machine with IP as 22.214.171.124 (Best to give IP instead of machine names as it picks more dependencies ) and lastly the port number. This is the port number where Listener is listening for connections. (YOu must have given this port number during the time of installation ) (CONNECT_DATA = (SID = ORCL) Now this is very important part sometimes it is SID and sometimes it is service name (orcl.oracle.ind.com or something long like servicename instead of SID which is short in which case it would be orcl) the difference between the two being service name is longer then SID and also gives the domain name in which the database was installed. (If I remember correctly it was before 8.1.6 that service name was used and after that SID works perfectly fine) Having said all this ..BLAH BLAH... now is time for a quickie.. To solve connection woes (like yours ).. I have always found this DUMMY entry very useful when I make a new entry in tnsnames.ora A few caveats -- Do NOT mess with the braces that contain the entry DO NOT change the indentation (I am not sure Why I am not able to retain the indentation !!! ) Just chage the information to what is now required lastly check what is there in sqlnet.ora (should be there with the tnsnames.ora file ) Now is a time to come back to your error messages.. these also tell a tale.
ORA-12203 : TNS : unable to connect to destination. (Actually you encounter this error when the client from where you are connecting can not find the machine where this database is installed may be a typo in the HOST parameter of tnsnames.ora or may be the network cable at the back of computer is loose --tighten it ) ORA-12154 : TNS : Could not resolve service name. well .. you can consider checking the SID parameter To double check what is your service name you might want to look at init.ora file (8.1.7 should have it Oracle 10g .. has spfile AFAIK)
ORA-12514 : Message 12514 not found: product=RDBMS80:facility=ORA This usaually happens when the Oracle home from where you are trying to connect to the database is goofed up I would suggest trying any other SQL plus shortcuts that might be there on the client machine.. well there should also a perfect explanation for this .. but this POST is already very long... and I am afraid you might be asleeep......zzzzzzz ZZZZ hope it connects Choudhary The tnsnames.ora will be in ORACLE_HOME/net80/admin (Forms default tnsnames.ora path ) against ORACLE_HOME/network/admin (database default tnsname.ora path ) [ December 15, 2003: Message edited by: sunil choudhary ] [ December 15, 2003: Message edited by: sunil choudhary ]
----------------------------------<br />"Learning is weightless, a treasure you can always carry easily."<br />-Chinese Proverb
Joined: Apr 22, 2010
Alternatively, you could copy your tnsnames.ora (from your Oracle Database) into the the Oracle Forms location.
The path for your Oracle Database should look something like this :-
The path for your Oracle Forms should look something like this :-
So if you were to just copy this file containing all your connectors information, when the Oracle Forms Connect Dialog box pops up, you just need to enter
your username, password and the short Connector string (ir. TEST.WORLD) instead of the full connector path.