I work an migration jobs Oracle Forms 4.5 INp to 10G.Have any sentence that i havent idea:
DEFINE TRIGGER
NAME = xxxxx
TRIGGER_TYPE = V2
DEFINE STEP
TEXT = <<<
#EXEMACRO NOFAIL NULL;
>>>
REVERSE = ON
ENDDEFINE STEP
special with REVERSE = ON...I need replace this en PL/SQL Oracle Forms 10G
Recently we are planning to migrate oracle 10g to 11g. We are migrating PHASE WISE (Schema wise) as this is a 50TB of Production instance. We are using Oracle Golden gate for this purpose.
Is there is any way that we can migrate oracle jobs from 10g to 11g?
In my project, fmb's were written using oracle 9i and now we planned to move them to oracle 10g. The consequences of using oracle 10g to modify the oracle 9i fmb's.
Also will there be any diff in terms of visual if i use oracle 10g to open oracle 9i fmb's.
Is this possible to convert oracle form which developed in oracle form 10g into Oracle form 6i. We developed one form in oracle form 10g and we trying to open it oracle form 6i. At start it gives warning about compability by ignoring this it open in form 6i, but control mismatch and not showing the trigger code that type of problem we faced. tool of that convert the oracle form 10g into 6i.
View 1 Replies View Relatedi am working on sql server developer in on of the organization. i got requirement from client that migration part from oracle 6i forms to oracle 10g and i got existing forms backup from client that is have .fmb, .mmb, .rdf and some of libraries having .pll files, but am new to oracle which form need to open from form builder first?
i tried to open .fmb file given database connection also but it is showing some libraries are missing. what should be the solution for my problem.
Migration of oracle forms 10g 32 bit windows platform to 11g 64bit Linux platform . I have about 500 fmb on my 10g environment which are currently working fine but when i go to compile it on 11g an error file is generated. All my path is set in proper manner .
I have a object library which has multiple tabs and every tab has its own object. While compiling, the forms are not inheriting the object values only few values from the object are considered.
Assign employees to their jobs in consideration the maximum number of employees to each jobs is 5 employee plus each job has own the maximum number of employees
we need the maximum number of employees for each job 5 to be variable when need to change this maximum for certain job , change this number from database (form the from of job ) not form code )
tables
emp
emp_no
name
manager
hiredate
salary
job
job_no
job
you can add tables or attributes to tables to complete you business.
I have a procedure that needs to be scheduled as a job. This procedure takes an average of 20-25 minutes to complete. The constraint is that these jobs are submitted using dbms_job.submit with an interval of 5 minutes.
For Example:
Job1 Procedure_B 20-Nov-12 21:05:00
Job2 Procedure_B 20-Nov-12 21:10:00
Job3 Procedure_B 20-Nov-12 21:15:00
Job4 Procedure_B 20-Nov-12 21:20:00
So, will Job2 execute only after Job1 completes [even though Job1 takes 25 minutes to complete] or is there any other mechanism for setting incompatibility for a job with itself.
I have a requirement where I need to group sessions which takes time as given below when ran individually .There are a total of 32 sesions.I want to divide them into 7 groups.I want to submit each one of the 7 groups in a job.So there will be seven jobs on the whole.Execution flow will be group 1 completes ,then group 2 starts like that.Actually I don't want to bombard the database at a time with 32 jobs ,hence the idea of grouping 32 jobs among 7 groups.grouping the sessions so that on the whole ,resources are equally allocated among sessions in a group and which in turn makes the process complete faster. I want to achieve parallelism but at the same time database should not be loaded too much.I just want to know is there any good practice from oracle side while doing this type of grouping. I am planning to group the most time taking one with least time taking jobs.
S.NO Session_Name DURATION(HH:MM:SEC)
1 Session_1 00:11:56.202368
1 Session_2 00:00:00.058542
1 Session_3 00:00:00.055205
1 Session_4 00:00:00.043454
1 Session_5 00:00:00.039994
2 Session_6 00:08:05.786031
2 Session_7 00:00:00.579035
2 Session_8 00:00:00.537957
[code]...
My Oracle jobs are not running. I can run them manually but they don't start automatically as per interval. The job_queue_processes=100 and CJQ process is not running. I started CJQ0 process by resetting it to 0 and then to 100. But as soon as I enabled a job this background process stopped.
The job also did not execute in its next execution time. I have created the database manually without using DBCA. Is the problem because of this? I have set crontab immediately to get rid of it.
How to
1) to define a job in oracle9i for solaris
2) to schedule this job
Remember i have prior experience deploying jobs at windows platform but when i try it on (9i for ) solaris, the script does not work as it does not accept a submit job request.
what jobs will be created when we upgrade to oracle 11.1 version ?
View 4 Replies View RelatedI am migrate to forms 5i to 6i. , compile are complete but following error are generate when running the form
[12/23/10 12:29:14 India Standard Time]::Client Status [ConnId=0, PID=2052]
>> ERROR: Abnormal termination, Error C0000005 ACCESS_VIOLATION
Is the oracle migration assistant a utility with the oracle forms 6i distribution? Or do I need to download it from somewhere else? Is there a license required? Is there a disadvantage of using Oracle Application Express for the migration from oracle forms 6i to 11g.
View 1 Replies View RelatedWe have an application running on Forms 5.0.6.8.0 and Reports 3.0.5.8.0 for the past 10 years... I have two main issues from the begining could not sort to-date... Issues are:
1. I use host() to call reports,for ex:
a) I run a report works fine
b) Now I goto any other master screen and just query some data
c) Now I want to run any of the reports, nothing works..
To generate the report I have to open another instance of application then I can run the report... In this instance again same story repeats... I dont know what is the problem...
2. We are financial company, lot of dependancy on excel ... I want export reports to excel but there is no option...
I am converting an application initially written in Forms 4.5 to Forms 10g. Currently I am facing 2 issues regarding the change in functionality from 4.5 to 10g.
There are 5 items in a block and the WHEN-NEW-FORM-INSTANCE trigger sets one of the items (the third item ITEM3) programmatically to display only and assigns a value to it. There is a WHEN-VALIDATE-ITEM in that item (At that point it doesn't fire and this is OK).
When the user navigates from ITEM1 to ITEM2 and then to ITEM4 (because ITEM3 is disabled) the WHEN-VALIDATE-ITEM of ITEM3 does not fire immediately. In forms 4.5/6i the trigger was firing and a lot of functionality was built on that behavior.
In forms 4.5 it was possible to cancel a long running query (during EXECUTE QUERY) using Control-C. The control C doesn't seem to work in form 10g. Is there any way to force a cancel of a long query in 10g?
Our Application is on Oracle 10g and we are going to migrate to Oracle 11g.
1) As of now we are using ojdbc14.jar. So if we migrate can we use the same jar or is it mandatory with 11g to use either ojdbc5.jar or ojdbc6.jar. I guess these jar version depends on the version of jdk we are using. But we are using jdk1.5 and still we use ojdbc14.jar which is working fine. So is it like , Oracle 11g can support only jdk1.5 or jdk1.6 ?
2) Is there any effect on the coding part if we change ojdbc14.jar to ojdbc6.jar ?I have seen there are some extra classes used in ojdbc6.jar.
3) Also we are going to migrate the Oracle database from Solaris to AIX. Our application lies on Solaris.So is there any compatibility problem , if our application lies on Solaris and database on AIX ?
Am going to migrate my databases from 10g to 11g.and am unaware of the performance issues in this and how can i increase the performance at database level and what are the possible bottlenecks.
View 1 Replies View RelatedCurrently our application running with Database - oracle 10.2 and front-end SAP11.5. We are going to upgrade our database (oracle 10.2) to 11g (version not sure) and upgrading application from SAP 11.5 to 12.2. As part of it i want to know what are all things i want to take care while migration (oracle upgradation) as I'm oracle developer.
1) Is it possible to access objects in 8i database from 11g database using DB link?. (as like 10g to 8i).
2) Is it possible to access objects in DB2 database from 11g database using DB link?. (as like 10g to DB2).
We have a product in Oracle forms 10g running in Windows XP OS, we want to migrate this into Linux OS.
View 4 Replies View RelatedDetail step by step description for Migration of ORACLE from 10.2.0.3.0 to 11.2 on AIX 5.2 Server.
View 2 Replies View RelatedI have a database on Mysql which consists on 40 tables interrelated. My issue is to migrate that DB to Oracle 11g by keeping the same structure (I mean the relation between the differents tables).
View 1 Replies View RelatedI want to migrate my database to 10G. Like code change require(e.g. if hints are used previously) table structure changes required.
View 5 Replies View RelatedI created some materialized view in Oracle database from SQL Server using Db Link.
When I selected the materialized view in Oracle database with where clause it is giving me following error.
SELECT * FROM COUNTRY_MV where country_code ='AWB';
ORA-00904: "COUNTRY_CODE": invalid identifier.
But when I write the column name inside quotes it works fine.
SELECT * FROM COUNTRY_MV where "country_code" ='AWB';
I need to migrate Ingres database version 6.0 to oracle 10G.Is there any feasible procedure/tools/process available.
View 2 Replies View RelatedSend me sample data migration scripts to get knowledge on Data migration.
View 10 Replies View RelatedI wanted to migrate my database from one of the Solaris machine to other solaris(High performance) machine.We are using oracle 9i database.
I wanted to take RMAN backup with oracle 9i database.and wanted to restore that database to other machine and perform recovery.This process will be on production database and requirenement is to reduce downtime.
let me know RMAN backup procedure which will have less downtime of the database.
I have a long file in WORD as I try to load it in ORACLE quotes become periods, ex:
insert into mytab values ('myname, 26);
when i copy this and paste it in oRACLE (UNIX environment), it translates as insert into mytab values (.myname.,26)..does not recognize the quotes.
I tried copying from word to notepad to ORACLE same problem..
I am working on database migration project SQL server to oracle, convert this query sql server to oracle basic thing i change but i still getting following error: ORA-01799: A column may not be outer joined to a subquery.
SELECT
h.unique_id,
h.customer_id, h.sequence_id, h.name_first, h.name_last, h.email,
h.tn_work, h.tn_home, h.tn_cell, h.tn_work_do, h.tn_home_do, h.tn_cell_do, h.primary_contact_id,h.ssn, h.created, h.customer_status_id, h.doi, h.dod,
NVL(CASE WHEN h.primary_contact_id = 1 THEN tn_home WHEN h.primary_contact_id = 2 THEN tn_cell
WHEN h.primary_contact_id = 3 THEN tn_work END, '') AS ext_primary_contact, ext_customer_status_desc FROM customer c
INNER JOIN customer_history h
[code]...
Is there any way/ tool to migrate from oracle to sybase with Zero Downtime?
View 2 Replies View Related