shell script called from .sql fie in oracle concurrent manager

HiI am running a request set through Oracle concurrent manager.The manager calls a .sql file. The sql file internally calls a unix shell script.v_body VARCHAR2(10000); v_body is set as followed in the sql program.v_body := 'ATTENTION :' || CHR(10) || CHR(10) ||'Your invoice number ' || r_error_rec.i ...

Oracle Database "Runtime" license

Anybody know what an Oracle database "runtime" license actually means? I'm particularly interested in what restrictions exist in terms of re-configuration, e.g. adding redo log groups or increasing the size of the SGA, etc. ...

Oracle Standard edition license

Does oracle standarde Edition license has a limit on the number of users that access the database. ...

Oracle Berkeley DB license is GPL v3 compatible?

some month ago I've read a post of Gregory Burd about it'sn clear what it would be Oracle interpretation of "use over the network". Now that GNU Affero GPL v3 it's been released, how it affects to Oracle Berkeley DB open source license?Is GNU Afero GPL v3 compatible con the above mentionated Oracle ...

Oracle Data Guard license...

I am having one confusion regarding Oracle Data Guard license (9i or 10g). This feature is part of Oracle Enterprise Editions. Does it apply to license as well or I have to buy the license for Data Guard separately.I am aware that 2 Oracle Database licenses are required, each for Primary and standby ...

pl sql - How to set Oracle Concurrent Request Status = Error

I registered a custom pl sql block as an Oracle Concurrent Request. I want to raise an EXCEPTION that will make the job end in an ERROR status if a condition is met. How can I do this? Here's an excerpt of the code I have:EXCEPTION WHEN v_nodata THEN <what command can I put here? I want the concu ...

Using parameter values in SQL Script for Oracle Concurrent Program

I wrote a very simple sql script and I want to register it as an Oracle Concurrent Program. I included a parameter field in the sql script to allow the entry of value to determine the number of days prior for the script. The script runs successfully in SQL*Plus, but when I try to register it as an O ...

Oracle OTN Developer License - can be used for Application development?

Th OTN Developer license states that:----begin---You may not:·use the programs for your own internal data processing or for any commercial or production purposes, or use the programs for any purpose except the development and prototyping of your applications;----end---I would like to know if I can ...

ORACLE 9I EDUCATION LICENSE

Hi I am trying to download Oracle 9i personal edition for Win 2000 for my home pc to allow me to practice/learn the software. I have been told by one of your sales reps that the only way to get the software for educational purposes is to download it from otn.oracle.comas this will provide me with a ...

Oracle Cannot accept license agreement

In trying to download Oracle/lite, I was not able to accept the license agreement. Clicking on the "I Accept" button yielded the following diagnostic:Sorry!In order to download products from Oracle Technology Network, you must agree to the OTN license terms. Go Back and agree to the OTN license term ...

Oracle Concurrent connections

What is the maximum number of concurrent connections allowed in Oracle 8.x ? ...

Oracle database 10g license policy

Oracle database 10g software has not license keys to automatically control entitlements to various enterprise options from inside the server (enabled/disabled). For example, someone can purchase the 10g Standard Edition license, download the software from the Oracle E-Delivery and install it as Ente ...

Oracle older version license

Can any body tell me the Oracle policy for older versions like 9i w.r.t. license ...

Oracle How many License do have to buy???

Oracle Manager and Oracle Architecture,Assume, I am using Oracle data guard.There are 2 DB server, one is active next is passive (clustering).And other passive DB servers are also connection storage (RACK).So, with this situation could you please tell me how many License do I have to buy?Narong ...

Oracle Yes the license is included fro intermedia in 8.1.7

The license is included for oracle 8.1.7.reagrds,khaleel ...

Oracle Concurrent Connections

What is the maximum number of concurrent connections allowed in Oracle 8.x ? ...

Oracle Transparent Gateway License Cost

Does anybody have the ball park figures for Oracle Transparent Gateway for DB2 mainframe license cost? I was given the figure $100,000 (per server?). This can't be true, or is it? ...

Oracle 10g HTMLDB license

HiI am currently running oracle 9i . Recently I request oracle 10g companion cd from oracle (we have a annual silver support with oracle).I have installed the feature 'HTMLDB' into my oracle 9i. Everything seem towork fine .My concern is whether I need to puchase licensefor this new feature since it ...

Oracle Converting Database License

I have been using a downloaded copy of Oracle 10g for development and testing purposes and I now want to use the same database in production environment. Can I use the same software and just upgrade the license to a double processor license? or do I need to get a completely "licensed" version of the ...

Oracle Is a license for Advanced security options required

Is a license for Advanced security options required.One of our clients is using an Oracle 9iR2 Standard Edition server. They are being required to use Oracle Advanced security features to connect to an external database through a database link.1. Does a license for Oracle Advanced Security need to b ...

oracle XML db license

Is Oracle XML db is part of Oracle Database products(ie. 8i,9i,10g)?I mean to say that, if we purchase license for oracle9i database does it cover license for Oracle XML db or we need to purchase seperate license.-Jignesh ...

Oracle Microsoft Windows License Calculation Problem

If I install a Oracle Database (with per CPU license) at a Microsoft Windows Server, which Oracle is as a back-end of public access web site. However, what license I need for the Microsoft Windows Server ?Thanks in advancedKwan6 Sept 2006 ...

Oracle ojdbc14.jar license details

Can I bundle ojdbc14.jar in my commercial application. Please let me know the license details for ojdbc14.jar. In Oracle FAQ, the link given for the license details on jdbc seems to be a broken link.SmithaLink : http://www.oracle.com/java/jdbc/license.html given in the page : http://www.oracle.com/t ...

Oracle database 10g license policy

Oracle database 10g software has not license keys to automatically control entitlements to various enterprise options from inside the server (enabled/disabled). For example, someone can purchase the 10g Standard Edition license, download the software from the Oracle E-Delivery and install it as Ente ...

Oracle Database Vault + license

HiI need to use Oracle Database Vault to protect application data from DBA accessWhat about license need for use Oracle Database Vault with Oracle Database Enterprise Edition 10g R2. I have license to use Oracle Database Enterprise Edition 10g R2, but i don't know if i need extra license !!Best ...

Oracle Concurrent program -> Executable

HiI need help related to oracle 11i apps concurrent program.I have writen a interface using pl/sql now I want this excetable to be register under concurrent program in 11i appsCan you please provide me tutorial that helps me to register the executable in concurrent pogram.it would be great if explai ...

Oracle concurrent connections.

See below my dispatcher settings.I think, this setting means,I want 3 TCP/IP dispatcher to handle a maximum of 2 concurrent connections and a maximum of 3 sessions per dispatcher.Here comes my question,See below, The query to find # of concurrent connection shows all the 9 sessions, I invoked using ...

Oracle User Named License

If you purchase a 5 User Named License, it means that you can only have 5 users connecting to the Database. Thats fine however, the ultimate question is, what if there is 2 Databases on the 1 Oracle Server?How does this affect the 5 user named license for more than 1 Database on the 1 Server?I'm tal ...

Oracle HTML DB License question

I have a question regarding licensing of HTML DB, is HTML DB covered under the Oracle 9i and/or 10g database license or licensed separately? ...

Oracle Express Edition License Question

I am a consultant and I want to develop a translation site like babelfish. I don't have the money to buy an Oracle DB License, but can I use the Oracle 10g Express Edition if I follow these details?Any use of the Oracle Database Express Edition is subject to the following limitations;1. Express Edit ...

Oracle Concurrent API use against the Content DB

I'm having a problem while trying to multi-thread my application. I have an application, while working serially.. it works just fine without errors. However, once I multithreaded it, I am now receiving FdkExceptions. I'm not too surprised by the way..The error codes are ORACLE.FDK.OperationInProgres ...

Oracle Concurrent Connections on XP

In need to have 16 concurrent connections to 10g express via the web interface. Unfortunately, I do not have a server OS available to install on. (Only windows xp or 2000 pro are available) Has anyone tried to connect more than 10 users simultaneously with all of the 10g express components installed ...

Oracle data guard license cost question

I have two Oracle database enterprise processor perpetual license, since my server has 2 CPUI am considering using oracle 11g active data guard soon.I have this question on how to license my second oracle server.Do I need to get exactly the same oracle license as my production server?Which mean two ...

Oracle application express license

We have a license for the Oracle enterprise server edition for the database.But we are not sure that we need to buy the application express license.Is it fine that we have the license for the databases,can we install the application express.In other words,what are the license conditions for apex ...

Oracle OCR'd License Plates

I am on a project in which we are using License Plate Recognition (LPR) technology. Basically it boils down to OCR'ing the license plate and storing it in the database. Of course OCR is not perfect technology and some license plates are not recognized correctly i.e. a plate that is actually '123ABC' ...

Oracle Image Storage License Requirements

Does storing and retrieving images from Oracle require the Spatial License option or can we do this with Locator?To clarify we are looking at loading images into the image themes and displaying these but I am unsure of the license issue. I know that raster themes definately require Spatial which see ...

Oracle Instances by license

somebody could say to me if the cost of a license (by example: Oracle Database 11g Enterprise Edition U$s 47,500.00), allows me to create the amount of instances that I wish? ...

Oracle Concurrent Sessions

We have a Oracle database with a Forms frontend that currently allows our users to log in with their usernames as many times as they like. After a recent audit, it has been suggested that we restrict this.I have used the OEM to create a new profile and set the restiction of Concurrent Sessions to 1. ...

Oracle concurrent sessions are high

Oracle 9.2.0.5 on SolarisWe are observing high number of concurrent sessions daily in a particular time. What are things we can check from database side to find the reason in increase in high number of concurrent sessions. ...

Oracle Concurrent User Connections

Greetings all and please grant a noob a small bit of latitude. I've recently started a BIT program and one question that has repeatedly stumped me as I research databases is the maximum number of concurrent user connectoins for Oracle 11g.As an example, and NOT SPAM, SQL Server 7.0 lists the number ...

Oracle Transparent gateway License information

We are using Oracle 10.2.0.4 in Solaris.We are planing to configure transparent gateway for SQL server.So i need some infromation about the license. We have options for configuring Sybase,teradata,Msql etc..Is the transparent gateway component licensed seperately for each databases or all these are ...

Oracle Named User License

Does internal Oracle processes count if you use "Named User" license? Let's say if you have 50 named user licenses does that mean you can connect 50 users (desktops,clients)? Thing is that once you check running sessions within Oracle there is never less than 20+ Oracle internal sessions so I am not ...

Oracle HTTP Server license?

I was on the phone with Oracle Sales person and I was told that I have to pay for Oracle http server (apache2.2) license. the price will be the same thing as if I bought ORACLE APPLICATION SERVER! is that true? I thought OHS is freeI am planing to use APEX+WINDOWS+BI PUBLISHER+ 10G STANDARD EDITION+ ...

Oracle Data Guard License Inquiry

Good Day! to all. I am not sure if this is already asked before, but I would like to ask your help regarding my inquiry. We have an Oracle 10g Database EE here in our company that is set up in an RAC (2 Nodes and 1 SAN). Of course this are already licensed. We are planning to implement the Oracle Da ...

Oracle concurrent user and hardware

can any one tell me pleas ..how many concurrent user can access on oracle at the same time??what is the minimum computer hardware specifications to install oracle?? ...

how do I submit an Oracle concurrent request from inside a page within Apex

Have an app that basically loads an interface table.I want to call a concurrent job from the page within my apex app that will submit the concurrent job in Oracle when I press the submit button. The only parameter is group id and typically end user enters 101010.I am unsure of the syntax..... the db ...

Oracle What are license restrictions?

I am new with TimeTen (and with Oracle too ), so can anybody clarify to me what are license restrictions within this product?Can I run TimeTen for developing without license (not buying)?What restrictions would I have in this case?Thank you!AlexEdited by: alexondi on 27.04.2010 1:55 ...

Oracle Req. Siebel License Keys Information.

I want small information about Siebel License Keys if i want to active license key for a particular siebel Product (For example call center or sales or Loyalty) which are i select in oracle site they provide no.of products list(like 1. Siebel CRM Base "CRM Base" includes Sales, Service and Marketing ...

Oracle OEPE Weblogic License issue.

I had downloaded Oracle OEPE 11.0 (wls1034_oepe111161_win32.exe) from edelivery site.I installed it, but now it whenever I create a domain and try to log in to the domain, it is displaying "You must have a valid license to use the Weblogic portal network"But I have seen posts, where it is mentioned, ...

oracle Grid control license is free?

We are running multiple databases in enterprise edition and also rac. Now we have plans get the all databases into Grid control. Do i need a addtional license for grid control? grid server and db repository will be install in new server. Some oracle forum says its free if already running with enterp ...