Home » Developer & Programmer » Forms » Forms and Report 6i and Oracle DB different PC [merged by jd] (Form and Report 6i and Oracle DB 10, Windows XP client, windows 2008 server)
Forms and Report 6i and Oracle DB different PC [merged by jd] [message #662152] Wed, 19 April 2017 01:40 Go to next message
hissam78
Messages: 193
Registered: August 2011
Location: PAKISTAN
Senior Member
we want to install Oracle Database 10G on "One computer",
and Forms and Reports 6i on "another Computer"
and from this computer we want to configure 6i with Oracle Database 10G.
somebody can help us?
after long time again i am going to work on Forms and reports, i need help for this,
thanks

Report message to a moderator

Forms and Report 6i and Oracle DB different PC [message #662155 is a reply to message #662152] Wed, 19 April 2017 03:03 Go to previous messageGo to next message
hissam78
Messages: 193
Registered: August 2011
Location: PAKISTAN
Senior Member
we want to install Oracle Database 10G on "One computer" having windows 2008,
and Forms and Reports 6i on "another Computer" having windows XP
and from this computer we want to configure 6i with Oracle Database 10G.
somebody can help us?
after long time again i am going to work on Forms and reports, i need help for this,
thanks

[Updated on: Wed, 19 April 2017 03:15]

Report message to a moderator

Re: Forms and Report 6i and Oracle DB different PC [message #662158 is a reply to message #662155] Wed, 19 April 2017 06:42 Go to previous messageGo to next message
EdStevens
Messages: 1376
Registered: September 2013
Senior Member
hissam78 wrote on Wed, 19 April 2017 03:03
we want to install Oracle Database 10G
which is long out of support . . .



Quote:
on "One computer" having windows 2008,
and Forms and Reports 6i
another obsolete version . . .


Quote:
on "another Computer" having windows XP
and from this computer we want to configure 6i with Oracle Database 10G.
somebody can help us?
after long time again i am going to work on Forms and reports, i need help for this,
thanks
What specific problems are you having? Have you checked the appropriate installation guides?
Why such old software? The current database version is 12.1 and the current Forms and Reports is 12.2

Report message to a moderator

Re: Running 6i and Oracle DB on Different Computer [message #662159 is a reply to message #662152] Wed, 19 April 2017 06:44 Go to previous messageGo to next message
EdStevens
Messages: 1376
Registered: September 2013
Senior Member
Crossposted

And, is this just a continuation of this?

[Updated on: Wed, 19 April 2017 06:47]

Report message to a moderator

Re: Forms and Report 6i and Oracle DB different PC [message #662160 is a reply to message #662158] Wed, 19 April 2017 06:45 Go to previous messageGo to next message
EdStevens
Messages: 1376
Registered: September 2013
Senior Member
Crossposted

And apparently just a continuation of this.

[Updated on: Wed, 19 April 2017 06:47]

Report message to a moderator

Re: Forms and Report 6i and Oracle DB different PC [message #662172 is a reply to message #662160] Thu, 20 April 2017 00:22 Go to previous messageGo to next message
hissam78
Messages: 193
Registered: August 2011
Location: PAKISTAN
Senior Member
Thanks for reply dear Experts,
Dear EdStevens
Yes it is Continuation that you highlighted, i have followed the Little foot kind advise and installing 6i on XP and DB 10g on Windows 2008,
what i am requesting is, how to configure both the PCs so that Client can access the Server?
i agree it is obsolete but our client want to use the same,

Report message to a moderator

Re: Forms and Report 6i and Oracle DB different PC [message #662174 is a reply to message #662172] Thu, 20 April 2017 00:56 Go to previous messageGo to next message
John Watson
Messages: 8929
Registered: January 2010
Location: Global Village
Senior Member
If you have installed the software and created a database, then it would seem that all you need do is configure SQL*Net. Or Oracle Net, as we are meant to call it now. You need to start a database listener on the database server machine and create a tnsnames.ora file on the Developer machine. Are you familiar with doing that?

Report message to a moderator

Re: Forms and Report 6i and Oracle DB different PC [message #662179 is a reply to message #662174] Thu, 20 April 2017 01:34 Go to previous messageGo to next message
hissam78
Messages: 193
Registered: August 2011
Location: PAKISTAN
Senior Member
Thanks for Reply John Watson,
I am not familiar with this, therefore i request for help Please,

Report message to a moderator

Re: Forms and Report 6i and Oracle DB different PC [message #662180 is a reply to message #662179] Thu, 20 April 2017 01:37 Go to previous messageGo to next message
John Watson
Messages: 8929
Registered: January 2010
Location: Global Village
Senior Member
I would suggest that you should start with the docs,
http://docs.oracle.com/cd/B19306_01/network.102/b14212/toc.htm
and come back with questions if there is anything you do not understand. Be sure to give detail of whatever needs clarification.

Report message to a moderator

Re: Forms and Report 6i and Oracle DB different PC [message #662184 is a reply to message #662180] Thu, 20 April 2017 02:10 Go to previous messageGo to next message
hissam78
Messages: 193
Registered: August 2011
Location: PAKISTAN
Senior Member
Dear John Watson,
Very much thankful to you for your kind act,
grateful,
will study the document and comeback to you, if any issue

Report message to a moderator

Re: Forms and Report 6i and Oracle DB different PC [message #662222 is a reply to message #662180] Fri, 21 April 2017 00:49 Go to previous messageGo to next message
hissam78
Messages: 193
Registered: August 2011
Location: PAKISTAN
Senior Member
i have do the following
Copy the TNSNames.Ora from Server where Oracle Database is installed
and copied in the CLient PC location where 6i is installed on the following path

Copy From Server
C:\ora90\network\ADMIN\tnsnames.ora (server)

Copy To on client
C:\\DEV6I\NET80\ADMIN\TNSNAMES.ORA(client)

but it is showing the following Error

ORA-12203: TNS UNABLE TO CONNECT TO DESTINATION

Any Kind advise please!!!

Report message to a moderator

Re: Forms and Report 6i and Oracle DB different PC [message #662225 is a reply to message #662222] Fri, 21 April 2017 01:01 Go to previous messageGo to next message
Littlefoot
Messages: 21807
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
  • Is the database up and running?
  • Does it listen?
  • Can you ping database server from your computer? Can you do it using its alias or its IP address?
  • How is database's alias entry in TNSNAMES.ORA created - try to use IP address.

Report message to a moderator

Re: Forms and Report 6i and Oracle DB different PC [message #662229 is a reply to message #662225] Fri, 21 April 2017 01:41 Go to previous messageGo to next message
hissam78
Messages: 193
Registered: August 2011
Location: PAKISTAN
Senior Member
Yes database is running
yes it is listening
yes Ping 192.168.10.42 is working

following lines i have added in Client machine TNSNames.Ora

ORCL =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(COMMUNITY = tcp.world)
(PROTOCOL = TCP)
(Host = 192.168.10.42)
(Port = 1521)
)
)
(CONNECT_DATA = (SID = ORCL)
)
)

Report message to a moderator

Re: Forms and Report 6i and Oracle DB different PC [message #662230 is a reply to message #662229] Fri, 21 April 2017 01:46 Go to previous messageGo to next message
John Watson
Messages: 8929
Registered: January 2010
Location: Global Village
Senior Member
First, you said thatQuote:
i have do the following
Copy the TNSNames.Ora from Server where Oracle Database is installed
but now you sayQuote:
following lines i have added in Client machine TNSNames.Ora
So which did you do? Copy the file, or edit it? What is the content of that file now?

Second, you sayQuote:
Yes database is running
yes it is listening
how do you know that the database and the listener are running? What is the result of running
lsnrctl status

Report message to a moderator

Re: Forms and Report 6i and Oracle DB different PC [message #662231 is a reply to message #662230] Fri, 21 April 2017 01:51 Go to previous messageGo to next message
hissam78
Messages: 193
Registered: August 2011
Location: PAKISTAN
Senior Member
Yes i have copied the TNSNames.ora from server to Client, it was not working so,
after that i have just change the Same TNSNames.ora with the Above defined Changes in 6i, but same error is showing,
i have installed the 6i on Server as well,
so from server 6i can connect to server,
means server is working fine, therefore i told it is listening and running,
but when i try to connect from client it is working

thanks

Report message to a moderator

Re: Forms and Report 6i and Oracle DB different PC [message #662355 is a reply to message #662231] Wed, 26 April 2017 03:44 Go to previous message
hissam78
Messages: 193
Registered: August 2011
Location: PAKISTAN
Senior Member
Dear Respectful Experts,
Thank you so very much for your kind support, highly appreciable,
there was a problem with our Server's NIC Card due to this hardware issue , we were unable to connect with server, replaced NIC now its working fine,


again bundle of thanks,

[Updated on: Wed, 26 April 2017 03:48]

Report message to a moderator

Previous Topic: client_ole2 for outlook on windows 10 Problem
Next Topic: what is the Forms 10.1.2.3 download site?
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Apr 19 02:41:58 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.