Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 920
  • Last Modified:

Installing Oracle Developer 6i

hi to all
I'm client of one ERP system built bu oracle developer 6i
all clients be able to connect to this ERP even they don't install any oracle developer or database
only i think oracle client installed there
I'm also used to design some oracle forms , putting it in share folder , where other client be able to run it through oracle forms run time
now i upgraded my ex-windows xp , to win 7 ,
the question is :
could i install oracle developer higher version than oracle developer 6I ?
note : users , or clients , should be able to run both my forms & reports from their machines without any problems
0
NiceMan331
Asked:
NiceMan331
  • 8
  • 7
1 Solution
 
Mark GeerlingsDatabase AdministratorCommented:
I think you know that Developer6i has been de-supported by Oracle for some years.  Later versions of Developer have been released.  These was no version 7 or 8.  The next version after Developer6i, was Developer 9i, then 10g.  Now version 11g is available.  However, none of these later versions can be used in client/server mode .  They all require an application server (that must be purchased and licensed separately from Oracle)  then the clients get to the application via a web browser, with no Oracle software installed on the client machines.

If you want to run Oracle Developer in client/server mode, then Developer6i is the highest version you can use.  Yes, that works in Windows7, if you make a couple of adjustments (there are a couple of older *.DLL files that you will need to find and include) but that combination is not supported by Oracle.  And, Developer6i does work with most Oracle database versions from Oracle8 - Oracle11.2.  It does not work well with the Oracle10,2 database version, but 10.1 is fine and also 11.1 and 11.2 work fine *IF* you use one of the older, non-default charactersets for the Oracle11 database.  Developer6i cannot support the default characterset for Oracle11,  which is AL32UTF16, but AL16UTF16 is fine.
0
 
NiceMan331Author Commented:
ok
i got a solution , thanx
let me please install developer 6i ( which i dislike , but by force i have to )
if i face any problem with the cleints , i will post here
may be 2 -3 days more please
but your answer is advisable
thanx
0
 
NiceMan331Author Commented:
could you please send me the download link of 6i
i fail in my search about it
0
Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

 
Mark GeerlingsDatabase AdministratorCommented:
No, Oracle Developer6i is not available for downloading any more.  Some long-time Oracle customers may have copies of this yet.  If you need (or want) this for a particular organization, hopefully that organization has been an Oracle customer for 15 years and has kept a copy of this software.
0
 
NiceMan331Author Commented:
ok
i got the file
now could i install it without any need of installing any oracle database ? because i'm connecting to the database on server
also , in additional steps for installing developer 6i on win 7 ?
0
 
Alexander Eßer [Alex140181]Software DeveloperCommented:
now could i install it without any need of installing any oracle database ? because i'm connecting to the database on server
Yes. You'll have to setup your TNSNAMES.ORA within the NET80\ADMIN folder to establish a connection to your (remote) DB.

also , in additional steps for installing developer 6i on win 7 ?
Search for these 2 DLLs: NN60.DLL and NNB60.DLL
You'll have to replace them with the proper version in order to have Report Runtime Engine work correctly.

Good luck ;-)
0
 
Mark GeerlingsDatabase AdministratorCommented:
Yes, that is correct.  You just need to edit the tnsnames.ora file to provide the details for your database server.  And, you will need older versions of these two *.DLL files if you want Reports6i to work.  Forms6i will be fine without these.
0
 
NiceMan331Author Commented:
Sorry for delay , I just installed the file , and configured it , but when I tried to run one report it sent me error message that the report was created in newer version of developer and may be lost if continue , I checked the version I installed , it is : 6.0.5.1. While the one was installed befor was : 6.0.8.18. , I searched again I found that I have oracle dev 9 I , is it ok if I de instal the current one and replace it with 9 ?
0
 
Mark GeerlingsDatabase AdministratorCommented:
"is it ok if I deinstall the current one [6.0.5.1] and replace it with 9?"

We can't answer that question for you.

It depends on what you want (or need).  Your question title indicates that you want the result to be Developer 6i not Developer 9i.  If that is actually not important, then yes install a later version, but don't stop with Developer 9i, since that is also de-supported.  Go to Developer 10i or 11g.

If you actually need Developer 6i though for some reason (like if you need to run the application in client/server mode yet) then you have to use Developer 6i.  But, then you should come up with a plan to upgrade to a later version since that may not be a good option in a couple of years.
0
 
NiceMan331Author Commented:
So you mean oracle 9i is not an appropriate version to run all forms created by dev 6 and to be run under client
0
 
Mark GeerlingsDatabase AdministratorCommented:
If your clients are 6i, then no, they certainly cannot run 9i forms.  But 9i forms (and the later 10g and 11g forms) all run in an application server, so clients get to them via a web browser.  They don't need any Oracle software installed on the client at all to run these later version of Oracle Forms.  Your organization though needs to have an application server set up (and licensed) to run these later versions of Oracle Forms if you want to use them.

So, the question is for you (or for your organization): do you want to continue to run Developer6i forms and reports in client/server mode?  If yes, then you certainly cannot use a version of Developer higher than 6i.  If you are ready to upgrade to a later version, then go to 10g or 11g.  Don't stop at 9i, since that is not supported either anymore.  If you aren't ready to go beyond 6i now, you do need to plan for that because sooner or later (with later versions of Windows and/or Oracle databases) Developer6i will no longer work.  For now, with Windows7 and Oracle11g (as long as you don't use the default characterset of AL32UTF8, but instead use something like AL16UTF16) you can get Developer 6i to work.
0
 
NiceMan331Author Commented:
The design is not by I or by my organization , we are inforced to stay using dev 6 because the erp we are using were designed by dev 6 I ,
0
 
Mark GeerlingsDatabase AdministratorCommented:
Then you need to try to find a patch for 6i that will get your version number up to something like 6.0.8.26.  I think that was patch 17.
0
 
NiceMan331Author Commented:
Ok , in here I need more time till I search to find it , what about our question here , shall I accept it now ? But I still require more help till my issue solve
0
 
NiceMan331Author Commented:
the problem solved now without any adjustment
i just noticed that the ERP company  copying a folder contain all developer  objects , such as
 report builder & form builder  ( nothing installed)
i just surprised how it works without installing any database or any developer
or is that folders is a replacement of installing oracle developer ?
0
 
Mark GeerlingsDatabase AdministratorCommented:
You say that the ERP company copies  "a folder contain[ing] all developer objects, such as report builder & form builder" but then "it works without installing any database or any developer".

That is not exactly true.  The "folder contain[ing] all developer objects" *IS* an installation of the Oracle software!  Correct, there is no need to install the database software on every client machine.  You only need the database software in one place (on the database server).
0

Featured Post

Restore individual SQL databases with ease

Veeam Explorer for Microsoft SQL Server delivers an easy-to-use, wizard-driven interface for restoring your databases from a backup. No expert SQL background required. Web interface provides a complete view of all available SQL databases to simplify the recovery of lost database

  • 8
  • 7
Tackle projects and never again get stuck behind a technical roadblock.
Join Now