aspose file tools*
The moose likes Oracle/OAS and the fly likes Connect to the DB from Oracle forms 6i with existing Oracle 8.1.7.0.0 DB. Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Products » Oracle/OAS
Bookmark "Connect to the DB from Oracle forms 6i with existing Oracle 8.1.7.0.0 DB. " Watch "Connect to the DB from Oracle forms 6i with existing Oracle 8.1.7.0.0 DB. " New topic
Author

Connect to the DB from Oracle forms 6i with existing Oracle 8.1.7.0.0 DB.

sharath kv
Greenhorn

Joined: May 06, 2003
Posts: 20
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 : 8.1.7.0.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 8.1.7.0.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 8.1.7.0.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.
Mark Spritzler
ranger
Sheriff

Joined: Feb 05, 2001
Posts: 17250
    
    6

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


Perfect World Programming, LLC - Two Laptop Bag - Tube Organizer
How to Ask Questions the Smart Way FAQ
sunil choudhary
Ranch Hand

Joined: Nov 10, 2000
Posts: 141

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 = 145.45.78.56)
(Port = 1521)
)
)
(CONNECT_DATA = (SID = ORCL)
)
)
----end ----
Just by saying username/password@a.world 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 = 145.45.78.56)
(Port = 1521)
this is what you already know.. the SQL net connection is TCP , and connecting to Host machine with IP as 145.45.78.56 (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 ]

"Learning is weightless, a treasure you can always carry easily." -Chinese Proverb
Priya Vairavan
Greenhorn

Joined: Apr 22, 2010
Posts: 1
Hi Guys,
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 :-
C:\oracle\OraClient10gR2\NETWORK\ADMIN\tnsnames.ora

The path for your Oracle Forms should look something like this :-
C:\DevSuiteHome_1\NETWORK\ADMIN\tnsnames.ora

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.

Hope it helps!
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Connect to the DB from Oracle forms 6i with existing Oracle 8.1.7.0.0 DB.