How To Install D2k In Windows Xp

» » » Here Oracle Forms and Reports 11gR2 Installation on Windows (32-bit) This article describes the default installation of Oracle Forms and Reports on Windows (32-bit). The article assumes there is already an installation present on the machine. • • • Related Articles.

• • Software Download the Forms and Reports 11gR2 software from Oracle Technology Network. • (ofm_frmrpts_win_11.1.2.0.0_32_disk1_1of1.zip) Installation Unzipping the 'ofm_frmrpts_win_11.1.2.0.0_32_disk1_1of1.zip' file will result in 3 directories (Disk1, Disk2 and Disk3). Run the 'setup.exe' executable in the 'Disk1' directory.

Click the 'Next' button on the Welcome screen. Select the 'Skip Software Updates' radio group, then click the 'Next' button. Accept the 'Install and Configure' option by clicking the 'Next' button.

Jul 7, 2008 - 4 min - Uploaded by i am professional programmersetup oracle forms 6i by mohamed fayed mohamed لا تنسو الاشتراك فى القناة كى يصلك كل ما هو جديد فقط اضغط على زر. Feb 12, 2009. Installing Oracle 9i on Windows NT/2000 The following outline describes the steps required to install Oracle9i (version 9.0.1.1 or 9.0.2.1) on the Microsoft Windows NT/2000 operating system. It is assumed that this is a fresh install and that no other Oracle products are installed at this time. If this is not the.

If the prerequisites were successful, click the 'Next' button. Select a previously installed 10.3.5 middlware home, then click the 'Next' button. Select the 'Configure for Development' option, then click the 'Next' button. Enter the username, password and domain name, then click the 'Next' button. Uncheck the security updates checkbox, then click the 'Next' button. Select the products you want to configure, then click the 'Next' button.

Accept the 'Auto Port Configuration' option by clicking the 'Next' button. If you need them, enter the relevant proxy settings, then click the 'Next' button. If you are happy with the installation summary, click the 'Install' button. Wait while the installation takes place.

If the installation is successful, the configuration progress screen will start automatically. When the configuration reaches 100%, click the 'Next' button. On the final screen, click the 'Finish' button. Your installation is now complete.

Post-Installation Once the server is started you can access the administrator console using the 'URL. Log in using the username and password set during the installation. The following scripts are useful. Rem # Start WebLogic user_projects domains startWebLogic.cmd Rem # or user_projects domains bin startWebLogic.cmd Rem # Stop WebLogic user_projects domains bin stopWebLogic.cmd Rem # Start the configuration wizard wlserver_12.1 common bin config.cmd Most of this is available directly from the Windows menu.

For more information see: • • • Hope this helps.

I went through the URL and related chapters/pages butstill getting the error scott@817>select authid from authors@sqlsvr; select authid from authors@sqlsvr * ERROR at line 1: ORA-28509: unable to establish a connection to non-Oracle system ORA-02063: preceding line from SQLSVR Looking the error up in the error manual i have checked the following 1. The USING clause in the DB link and TNSNAMES is the same as in the TNSNAMES file CREATE DATABASE LINK SQLSVR USING 'HSORA' HSORA = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = BP)(PORT = 1433)) ) (CONNECT_DATA = (SID = HSORA) ) (HS = OK) ) 2. Protocol-specific information in the service name definition is the same as in the SID_LIST_LISTENER = (SID_LIST = (SID_DESC = (GLOBAL_DBNAME = tsora) (ORACLE_HOME = C: Oracle Ora81) (SID_NAME = tsora) ) (SID_DESC = (PROGRAM = extproc) (SID_NAME = PLSExtProc) (ORACLE_HOME = C: Oracle Ora81) ) (SID_DESC = (PROGRAM = hsodbc) (SID_NAME = hsora) (ORACLE_HOME = C: Oracle Ora81) ) ) LSNRCTL>start Starting tnslsnr: please wait. TNSLSNR for 32-bit Windows: Version 8.1.7.0.0 - Production System parameter file is C: Oracle Ora81 network admin listener.ora Log messages written to C: Oracle Ora81 network log listener.log Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=.

Pipe EXTPROC0ipc ))) Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=258_stock)(PORT=1521))) Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=258_stock)(PORT=2481))(P ROTOCOL_STACK=(PRESENTATION=GIOP)(SESSION=RAW))) Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC0))) STATUS of the LISTENER ------------------------ Alias LISTENER Version TNSLSNR for 32-bit Windows: Version 8.1.7.0.0 - Produc tion Start Date 23-JUL-2002 12:57:47 Uptime 0 days 0 hr. 2 sec Trace Level off Security OFF SNMP OFF Listener Parameter File C: Oracle Ora81 network admin listener.ora Listener Log File C: Oracle Ora81 network log listener.log Services Summary. PLSExtProc has 1 service handler(s) hsora has 1 service handler(s) tsora has 1 service handler(s) The command completed successfully 3.SID=name in the service name definition (in the TNSNAMES.ORA file) must match the value in the LISTENER.ORA file for the responding listener. Was this the Service (hsora)? The system DSN is called HSORA. Microsoft SQL Server ODBC Driver (Version ) Running connectivity tests.

Attempting connection Connection established Verifying option settings Disconnecting from server TESTS COMPLETED SUCCESSFULLY! I have run the HS script C: Oracle Ora81 RDBMS ADMIN caths.sql The init file for HS has been modified and named appropriately INITHSORA # # HS init parameters # HS_FDS_CONNECT_INFO = hsora HS_FDS_TRACE_LEVEL = OFF The SQL Server is on another machine.

I am running this test from the Oracle Server (8.1.7) and has the SQL server 2000 Client installed on it. I am still trying ot find where i went wrong. In case you can help pl let me know. Followup July 23, 2002 - 10:44 am UTC No -- I cannot give you an example. The reason is just really simple. Connecting to a non-oracle data source is NO DIFFERENT THEN CONNECTING TO ANOTHER ORACLE DATA SOURCE.

You follow the setup, make sure the stuff is working and use dblinks. It is NOT any different then a normal DBLINK.

There is no 'example' to be given. Oh wait -- here is one: create database link foo connect to user identified by pw using 'sqlserver'; select * from t@foo; It is Just a database link. You have to configure the configuration files and that is something you need to discover how to do in your environment, given your odbc drivers, etc etc etc (and something that the documentation actually does walk you through step by step) Configuration and setup -- support is excellent at helping you there. I personally (believe it or not) do not have sqlserver installed on my machines. In fact, I don't have any machines that are physically capable of running sqlserver since they only run on one OS. Two things which i was doing wrong 1. In SQLNET instead of SQLNET.AUTHENTICATION_SERVICES= (NTS) use SQLNET.AUTHENTICATION_SERVICES=(NONE) look out for changes in connecting from localhost 2.

In the hsodbc definition in tnsnames.ora the host needs to be the Oracle host where I am trying to link from, not the SQL Server host that I am trying to connect to I also noticed one thing. After i execute the script for HS my DBMS_HS_PASSTHROUGH package is no longer to be found!!.but now i can select data from SQL Server. It is important that you do read thru the URL so that you can diy here are the steps i followed 1. Initodbc.ora - modify it to incule the DSN you have created HS_FDS_CONNECT_INFO=FILEDSN=file_dsn When connecting using a System DSN, specify the value using: HS_FDS_CONNECT_INFO=system_dsn HS_FDS_TRACE_LEVEL = value of on or off 2.

Set up the LISTENER and TNSNAMES as i said in my earlier post the tnsnames host is the localhost. The listener setup sample is provided in the oracle_home hs admin directory.

So is the tnsnames sample 3.CREATE DATABASE LINK link_name CONNECT TO user IDENTIFIED BY password USING 'non_oracle_system'; again ref to my post above for the precautions you have to take 4. Run hte caths.sql as sys or internal thats it.!!!

I have been trying to get this working on my oracle 9i rel 2.0 datawarehouse database. Its a shame oracle does'nt have a simple method to get this done ( I was heckled by MS Access users with the ease with which they can set it up:( ) I have a access database and another UNIDATA database for which I 'm trying to access using Heterogenious services.

My initavantiaccess.ora file in HSadmin folder and Tnsnames.ora in network/admin folder are in place. Hi Tom, Unfortunately our application has to support Oracle and SQL Server at the same time. One trouble we had in SQL Server is that it doesn't support Oracle hierarchy query like 'CONNECT BY'.

I came up with a function which returns the list of child IDs for given root ID, which works in both databases. For example, get_children(20) may returns a string of '21,23,30,220,22'. Obviously this has some limitation such as the list cannot be too long. However it's not the concern right now. So at least now we can use the same code (writen in C#) for both databases, which works like this: 1.

Get the list of child IDs for the given root ID. Compose the whole SQL statement such as 'SELECT * FROM orgs WHERE orgid IN (' + + ')' As compared to the original query in Oracle, which may look like 'SELECT * FROM orgs WHERE orgid IN ( SELECT orgid FROM orgassociations START WITH parentorgid = 20 CONNECT BY PRIOR orgid = parentorgid)'. What I want to ask you: 1. Does this solution look workable to you? Will Oracle 'CONNECT BY' become ANSI standards sometime?

Is there a document that I can refer to for the 'minimal intersect of SQL syntax supported by all major RDBMS vendors'? Followup December 31, 2003 - 9:23 am UTC sorry -- i don't do 'database independence' all you get from that is an application that runs pretty bad on one database and horrible on all of the rest. Whichever you develop on -- you run pretty bad on and everyone else is hack. You've basically totally crippled both products -- totally. My solution would be to hide all of this stuff in stored procedures, have 0 lines of code in the proprietary language C# that start with SELECT, INSERT, UPDATE, DELETE -- only call stored procedures that return result sets and maximize the $$$'s you and your customers spend on the underly databases to get the best possible performance from them. This works -- it works well. Doen't matter if connect by is ansi or not.

Ansi is soooo huge these days that no vendor will ever be 100% compliant. Just speaking from the voice of 'been there done that'. Before Oracle I did just database things using sqlserver, informix, db2, ingress, oracle and others. Database independence -- nope -- doesn't happen unless you write your own database like SAP or Peoplesoft do with their middle tier caches -- and even then they can only support a small handful of databases using simple keyed reads.

I experienced lots of pain getting HS working, so I've put together a worked example, in the hope it will spare you some of that pain. I'm using Excel - if it works for Excel then it should just be a matter of chaging the DSN (and database link username/password) to connect to another database. Westone Thunder Serial Numbers.

OK, I'll assume you already have a spread sheet handy. We'll start by setting up an ODBC Data Source Name. Open the ODBC Data Source Administrator [ Start ->Programs ->Administrative Tools ->Data Sources (ODBC) ] Click on the tab page labeled 'System DSN' Click on the button labeled 'Add' Select the Excel driver, and press the button marked 'Finish' In the box labeled 'Data Source Name', enter the word 'SPONGE'. Click on the button labeled 'Select Workbook' Select the excel workbook you saved earlier. Click OK, and exit the ODBC Administrator This has created a Data Source Name (called 'SPONGE') that points to your excel workbook. Now we'll move onto the Oracle side of things.

First, we need to tell Hetrogeneous Services about SPONGE. The HS initialisation files are stored in ORACLE_HOME hs admin. In there, you will find a file named 'inithsodbc.ora'. Make a copy of it called 'initFRUIT.ora', and edit the file. HS_FDS_CONNECT_INFO = SPONGE HS_FDS_TRACE_LEVEL = 0 Save the file.

This has created a link between the SID 'FRUIT' to the DSN 'SPONGE'. Now edit your LISTENER.ORA file. In the SID_LIST, add the following entry:- (SID_DESC= (SID_NAME=FRUIT) (ORACLE_HOME=C: Oracle Ora9i) # change this to YOUR oracle home (PROGRAM=hsodbc) ) This instructs the listener that to service this sid, use 'hsodbc'. You'll need to stop and start the listener to get it to pick up the changes, or perhaps you just need to use the 'reload' option - old habits die hard. Next we need to define a service, so that NET8 knows how to connect to that sid. Add the following entry to your TNSNAMES.ORA on your database server. JELLY = # you may need to add a domain name suffix - ask your DBA (DESCRIPTION= (ADDRESS_LIST= (ADDRESS= (PROTOCOL=TCP) # edit to point to your LISTENER (HOST=localhost) # edit to point to your LISTENER (PORT=1521) # edit to point to your LISTENER ) ) (CONNECT_DATA=(SID=FRUIT)) (HS=OK) ) Finally, we can log in to oracle.

Create a database link to refer to the JELLY service. For excel, we seem to need to specify the Windows 2000 account name ('tangt' on machine 'home' becomes 'HOME tangt') and password:- CREATE DATABASE LINK custard CONNECT TO 'home tangt' IDENTIFIED BY taktangspassword USING 'jelly'; Now try this:- SELECT table_name FROM all_tables@custard; TABLE_NAME ------------------------------ Sheet1$ Sheet2$ Sheet3$ CDS TRACKS (Got an error instead? Skip to the error section below) You can see that each worksheet is available as a table (with a '$' appended for good measure), as well as any NAMED RANGES you might have set up. Now try doing some queries against it. Q: What is a 'named range'? A: It's an Excel thing, and beyond the scope of this article. Have a look in the excel help pages.

Q: Does it support 'unnamed ranges'? What about the [] and `` notations?

A: As far as I can tell, they are not supported. Q: Should I use the worksheet names, or use named ranges?

A: Thats up to you. It depends on how you use Excel, whether you have multiple sets of data on a single worksheet, whether you have lots of extraneous text which will need stripping out etc. Q: How does it know what the columns are called? A: The column names are in the first row. Q: How does it determine the datatype? A: I would imagine it uses the formatting information to make a guess. Perhaps theres an answer on MSDN.

Q: Why did I pick such odd names for the link, service, sid and dsn? A: Well, it's not because I'm a trifle mad (BOOM! BOOM!, ahem, I'm sorry, so very sorry) - its so that you can see how the database link name ('CUSTARD') relates to the tns service name ('JELLY') in the tnsnames.ora, and how that relates to a 'SID' ('FRUIT') in both the listener.ora and in the hetrogeneous services parameter file ('initFRUIT.ora'), and how that links to the DSN ('SPONGE'), which gets you to the Excel file. Oh, by the way, the instructions above are for a Windows 2000 system. Things might be different on your system, especially if you are trying to do this on an *nix system. You might also consider downloading the latest version of Microsofts Data Access Components pack - which includes more recent ODBC drivers. I'm running 2.7, but I think the latest is 2.8.

Have a look on MSDN. Takmeister ------------------------- ORA-28500: connection from ORACLE to a non-Oracle system returned this message: [Generic Connectivity Using ODBC][Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified (SQL State: 00000; SQL Code: 0) ORA-02063: preceding 2 lines from CUSTARD The DSN name specified by 'HS_FDS_CONNECT_INFO = SPONGE' in your%ORACLE_HOME% hs admin initSID.ora could not be found. Check your iniSID.ora file and the ODBC manager. ------------------------- ORA-02085 You have GLOBAL_NAMES set to TRUE.

I have not managed to get HS working with global names, so turn it off with this command:- alter session set global_names = false; ------------------------- ORA-28545: error diagnosed by Net8 when connecting to an agent NCRO: Failed to make RSLV connection ORA-02063: preceding 2 lines from JELLY Could be that listener is not running, or has not been restarted. Could be that the PROGRAM in listener.ora is not 'hsodbc' Could be that the SID in tnsnames.ora is incorrect ------------------------- ORA-28500: connection from ORACLE to a non-Oracle system returned this message: [Generic Connectivity Using ODBC][H006] The init parameter is not set. Please set it in init.ora file. ORA-02063: preceding 2 lines from JELLY Could be that the initSID.ora file is not named correctly. Match the SID to that in the listener.ora and tnsnames.ora files. ------------------------- ORA-12154: TNS:could not resolve service name The TNS Service name in your tnsnames.ora file does not match that specified in the 'using' clause of your database link.

Tom, Of course you can reprint it! Distribute it as widely as possible. Adapt it as part of the oracle manual if you like.

I'm flattered that you think so highly of it. HS is such a great technology.

You can get it up and running in under 5 minutes, without writing a *single* line of code. And the ODBC/OLE side is completely free. I produced the errors by starting with a working setup, and gradually misspelling things to see what error message came out.

Oh, and I notice that I've missed out the 't' in 'initSID.ora' under the first error. Followup July 04, 2004 - 11:34 am UTC time to goto askbill.microsoft.com sorry -- we can load the xls spreadsheet into the database, we can even turn it into a open systems format (html) using TEXT -- but beyond that, I just don't work with that stuff -- I turn xls into csv and load it into something useful (a table) and skip the xls after that. Working with MS specific file formats on non-windows OS's is 'not easy'. A quick search on google for java api excel found as the first hit: which looks promising, you could easily load that jar up and create a java stored procedure. To Reader (July 2nd 2004) 'Sharity' looks like something that lets a unix/linux machine mount a windows share. If you have a windows machine as a server, install an oracle listener on it (second option - 'management/integration'; select CUSTOM and deselect everything except for net services/listner; if the install does not create the hs subdirectory, you can extract it manually from disk 2). Modify the listener.ora, and hs admin files as described in my worked example.

On the unix machine hosting oracle server, modify the tnsnames.ora as described, but change the 'ADDRESS=' portion to point to the listener on your windows machine. This uses SQL*Net as the communication protocol, and launches ODBC on the windows machine natively. Do not be tempted to use some kind of odbc-odbc bridge - this is exactly what Generic Connectivity does.

-- To Reader (July 4th 2004) My example above used Excel because it is ubiquitous. In my (limited) experience, the performance of the Excel ODBC driver is terrible and would only use it to simplify one-off data loads. There also seem to be some concurrency issues which I did not manage to resolve. If you only want to extract data, try one of the various ODBC extraction tools, such as 'Database Fishing Tool' from sourceforge; or my own quick-and-dirty contibution 'dumpodbc.js' (which does not require ODBC DSN for Excel/Access) (posted there because its more than 1000 'words'). If read/writeing Excel files (in spite of the performance and concurrency issues) is mission critical, you have two options:- 1) Deploy a windows server to host the excel files, and install a listener on it. This lets you use Microsoft's ODBC drivers.

(Variation: use some kind of PC/Windows emulation on Unix/Linux) 2) Put together a buisiness case to your boss for licensing third party ODBC drivers, but make sure you evaluate their trial version first. If your budget is tight, you'll have to write your own, but consider the cost of your time to write it vs the cost of buying one in. I might have a go at it myself if I can find time. 'the performance of the Excel ODBC driver is terrible.' 'Deploy a windows server to host the excel files, and install a listener on it.

This lets you use Microsoft's ODBC drivers' Let me understand what you are saying. You are saying that the performance of Microsoft's ODBC drivers is terrible? But surely I can use other Windows-land freely available ODBC drivers for Excel? Or are you saying all of them perform horribly? I mean, Excel can handle only about 64000 rows only anyway, right? Even the worst ODBC driver should be able to load this in a minute, right?! 'If you only want to extract data, try one of the various ODBC extraction tools' Thanks, but I was thinking more about ongoing real-time interface between Oracle and Excel.

For one-time loads, I can just save the Excel as a CSV (or better a separated file, because, is very common in user data) and load using SQL Loader/external tables. To Reader, Sorry - that was a vague and completely unsubstantiated opinion - I probably shouldn't have mentioned it. Tom would never be so careless. It might just be something wierd about my setup. Try it out and see if it performs well enough for you - its cheap and easy to try.

The concurrency problem I had was that the Excel file gets locked as soon as you access it, even if you set it to 'read only', until you terminate the session (perhaps by connecting as another user?) so you can not access it from two different sessions, nor from Excel and Oracle at the same time. I notice the Hetrogeneous Services manual mentions setting up Multi Threaded Agents. That might be worth looking into. I also got HS working with Ole DB, if you're interested. Tom and Tak, Thanks for your ideas and comments. I dislike Excel i.e. Proprietary file formats as much as you do.

But the thing about Excel files is that they are like weeds, no one likes them but you have to deal with them anyway. IMHO more companies have lot of critical information locked up inside.xls files than they would admit.

Buku Ekonomi Internasional Pdf Merge. I even have users referring to.xls files as 'databases'! After all they have rows and columns and guess what tables have! Over the years, they accumulate tabs/workbooks with elaborate cross-checking, lookups, etc, all the things that you typically associate with database-based applications.

Given all this, having the ability to access (even just for reading).xls files as effortlessly as flat files (the external tables feature in 9i) is immensely useful. Well, HTMLDB is much more than just cut-n-paste xls into a table! Dont downplay htmldb. For one-time load of XLS into the database, there are many options, the simplest (other than HTMLDB) being just save as CSV and load using SQLLDR/external tables. The problem, as always, is the culture around use of technology. In other words, the users! Even after loading the xls into the database and providing a way to maintain it right in the database, users have a tendency to keep using their darn spreadsheets and then coming back after 3 months complaining that the database is 'out of sync'!:-( God, how I hate Excel spreadsheets, Access 'databases' and the like!

First, Tak Tang's article was great! I was able to get my link between 9i and SQL Server working. However, referencing the SQL Server table data on a column level has eluded me. SQL>select count(*) 2 from SQL_SERVER_TABLE@custard; COUNT(*) ---------- 1836925 works fine. SQL>select * 2 from SQL_SERVER_TABLE@custard; will list all of the rows as normal.

SQL>desc SQL_SERVER_TABLE@custard Name Null? Type ----------------------------------------- -------- ---------------------------- Account_no NOT NULL VARCHAR2(20) Individual_ID NOT NULL NUMBER(10) Date_added NOT NULL DATE Presence_of_Email CHAR(1) Last_Update NOT NULL DATE works as expected However: 1 select * 2 from SQL_SERVER_TABLE@custard 3* where Presence_of_Email = '1' where Presence_of_Email = '1' * ERROR at line 3: ORA-00904: 'PRESENCE_OF_EMAIL': invalid identifier Is there some special snytax needed when refering to a linked table? Followup January 28, 2005 - 7:18 pm UTC the tnsnames on the machine that needs the tnsnames (the database machine) is not correct. The tnsnames.ora on your client - not meaningful, the DATABASE is trying to resolve the tns entry. [tkyte@localhost tkyte]$ oerr ora 4, 00000, 'TNS:could not resolve service name' // *Cause: The service name specified is not defined correctly in the // TNSNAMES.ORA file. // *Action: Make the following checks and correct the error: // - Verify that a TNSNAMES.ORA file exists and is in the proper // place and accessible. See the operating system specific manual // for details on the required name and location.

// - Check to see that the service name exists in one of the // TNSNAMES.ORA files and add it if necessary. // - Make sure there are no syntax errors anywhere in the file. // Particularly look for unmatched parentheses or stray characters. // Any error in a TNSNAMES.ORA file makes it unusable. See // Chapter 4 in the SQL*Net V2 Administrator's Guide. If // possible, regenerate the configuration files using the Oracle // Network Manager.