| Forms2000 and Oracle 9i [message #155097] |
Thu, 12 January 2006 06:21  |
abhijitmane2000
Messages: 20
Registered: June 2005
Location: Pune,Maharastra,India
|
Junior Member |
|
|
Hi everybody,
I am newbie in forms,can anybody tell me how to configure tnslistener.ora file for connecting the forms and oracle database.
Thanks in advance.
with regards
Abhijit.
|
|
|
|
| Re: Forms2000 and Oracle 9i [message #155118 is a reply to message #155097] |
Thu, 12 January 2006 08:27  |
orausern
Messages: 826
Registered: December 2005
|
Senior Member |
|
|
you have to configure tnsnames.ora file to connect to the database.
Ideally , you can check with your dba for this..for detail on what needs to configure see links like:
http://www.databasejournal.com/features/oracle/article.php/3092461
for a problable quick solution: see end part of that link which says:
If you were using one and only one database, no external procedure calls, all you would need in the tnsnames.ora file is this:
DBASPT =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = yourpc)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = dbaspt)
)
)
Scott and other users would only need to use username/password@dbaspt to connect to the database. The "SERVICE_NAME" entry could be changed to "SID" because the use of "SID = your_database_name" is still supported, but the Net8 and beyond Oracle-recommended standard is "SERVICE_NAME = your_database_name."
|
|
|
|
| Re: Forms2000 and Oracle 9i [message #155136 is a reply to message #155097] |
Thu, 12 January 2006 09:26 |
karan.shandilya
Messages: 64
Registered: July 2005
Location: mumbai
|
Member |
|
|
Hi Abhijit,
Just do one thing, copy the tnsnames.ora file of DATABASE
Path is- U:\oracle\home\network\ADMIN\tnsnames.ora
and paste it in the tnsnames.ora file of your tool Form2000
Path is- U:\forms2000\NET80\ADMIN\tnsnames.ora. and save the file.
This will connect your database to your form2000 tool and this is one time job.
This will solve your problem.
Karan.
|
|
|
|
|
|
|
|
|
|
| Re: Forms2000 and Oracle 9i [message #155625 is a reply to message #155097] |
Tue, 17 January 2006 12:54 |
karan.shandilya
Messages: 64
Registered: July 2005
Location: mumbai
|
Member |
|
|
Hi Abhijit,
Do the steps according to David,
you will definitely find the tnsnames.ora files containing directories.
Now write the full paths of your tnsnames.ora files in your reply.
Karan.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
