Zero Downtime Migration From Oracle To Sybase

Aug 3, 2012

Is there any way/ tool to migrate from oracle to sybase with Zero Downtime?

View 2 Replies


ADVERTISEMENT

Server Utilities :: Migration From Sybase To Oracle 1 Table Fails With SQL Error ORA-01841

Jul 17, 2012

im trying to migrate Sybase 12.5 to oracle 11G R2 on linux all tables are fine expect one which fails with error

"SQL Error: ORA-01841: (full) year must be between -4713 and +9999, and not be 0
01841. 00000 - "(full) year must be between -4713 and +9999, and not be 0"
*Cause: Illegal year entered
*Action: Input year in the specified range"

i have change the data type from CHAR to VARCHAR2 etc as for the datatype date shows as date on the tool - I'm using sqldeveloper from oracle.

View 8 Replies View Related

Upgrade :: Migration Without Downtime - Goldengate Approach

Mar 24, 2013

We are facing a project where it is mandatory that the migration (from 9i to 11g) happens without any downtime. We thought about using Goldengate do to this migration. But i would like to listen to somebody who already did such kind of migration (i never used goldengate before). The basic steps to do such migration would be:

1) Install the Goldengate client on both source and target
2) Export only the metadata (structure of the table, for example) from source to target (here is one point of doubt of mine. This export can be only done using exp/imp?)
3) Perform the initial load from source to target (here i have another doubt: It it possible to perform an initial load from a whole database?)
4) Configure manager, export and replicat to perform the migration with the source database open in read-write

With the steps above, would i be able to perform a migration without downtime? What other considerations do you have?

View 1 Replies View Related

SQL & PL/SQL :: Sybase To Oracle Conversion

May 6, 2010

I am converting sybase to oracle database. during the migration, i have small doubt in triggers.

sybase source

create trigger testss_dt
on test
for delete
as
if @@rowcount = 0
return
insert into test
select id from deleted
return

I have converted oracle code here

create or replace trigger testss_dt
before delete on test
for each row
begin
insert into test
values(:old.test);
end;

But i have ignores @@rowcount concepts in oracle. what @@rowcount indicates in trigger?

View 10 Replies View Related

SQL & PL/SQL :: What Would Be The Sybase Str Equivalent In Oracle

Mar 4, 2010

What would be sybase str(approx_numeric [, length [, decimal] ]) equivalent in oracle.

Sybase call :

select str(10000.5555, 6, 3) as Test.

Tset
-------
10001

View 4 Replies View Related

SQL & PL/SQL :: Migrate Sybase To Oracle Conversion

Apr 23, 2010

i want to migrate sybase stored procedure to oracle stored procedure.

sybase stored procedure:

create proc checkcontract @titleid tid
as
delete from titile where titile_id=@titleid
return 0

we need to migrate this procedure to oracle stored procedure. If we are using return 0 in SP in oracle means, it returns the end of the procedure statements(according to oracle statements). but sybase indicates that return 0 does not return 0 value during the run time. The return 0 implies that SP completed successfully. In oracle, i have converted stored procedure into SP and also stored functions.

Oracle Scripts:
Stored Procedure:

create or replace procedure checkcontract(v_titile varchar2)
as
begin
delete from titile where titile_id=v_titleid;
end;
/

Stored Functions:

create or replace functions checkcontract(v_titile varchar2)
as
return number
begin
delete from titile where titile_id=v_titleid;
return 0
end;

Give the comments which one is correct or accurate.

Oracle SQL developer also recommeds STORED FUNCTION. But in my application code, don't assign any output variable to this procedure. If i am using Stored Functions, we need to assign value and assign the output of the SF. we don't want to change the application code.

View 4 Replies View Related

SQL & PL/SQL :: Difference Between Sybase Raise Error And Rasie_application_error In Oracle?

May 6, 2010

I try to convert sybase raiseerror into oracle raise application error.

sybase code :

raiserror 20100 "can't add a contact number that's in the contact"

oracle

raise_application_error (
-20002, ':can''t add a contact number that''s in the contact');

the sybase error number 20100 unable to use in oracle due to the limitation of error number.RAISE_APPLICATION_ERROR should be negative and between -20000 and -20999.

how to use sybase error number in oracle?

View 2 Replies View Related

Replication :: Golden Gate - Replicate Data From Oracle To Sybase

Oct 17, 2007

Implemented the Golden Gate replication tool? In particular, to replicate data from Oracle to Sybase?

No details are needed, just a quick nod indicating "yes, it has been done successfully".

View 1 Replies View Related

Security :: Moving Application Security To Oracle From Sybase

Aug 18, 2010

In Sybase, my application was using system tables to perform application login security. Those tables obviously don't exist in Oracle. I am looking for ways to provide the following functionality in an Oracle world:

1. How to determine 'x' days of inactivity based on "last login date"?

2. How to determine when a new user logs in for the first time and force them to change their password?

3. If we need to reset a users password, how can we require the user to change their password?

4. Is there any other option other than storing a user-id/password in the application code for locking a user's account if their account needs to be locked due to inactivity?

5. In the USER_USERS view there is a status column. What the different status's can be?

View 3 Replies View Related

How To Apply Patchset With No Downtime

Sep 20, 2012

How to apply patchset (10.2.5) with no downtime?

My db version is 10.2.4 and OS is hp-ux

View 10 Replies View Related

Replication :: Applying DB Structure Changes Without Downtime?

Mar 16, 2011

We are trying eliminate/minimize the downtime for our application. As part of new code deployments sometimes we need to modify DB Structure also. As it is taking time to backup current DB and apply new DDL, the application is down.

Is there a way to eliminate the downtime, if I can leverage Data Guard, Golden Gate or RAC concepts?

View 3 Replies View Related

Server Administration :: Bdump Dir Deleted / Cannot Get Cause Of Downtime

Sep 19, 2011

Is there any way I can find out what caused the database to crash; either a history of commands executed within the database, I lost my bdump directory before the scheduled backup ran and the only logs available are after I re-created the directory.

SQL> startup
ORA-00444: background process "PMON" failed while starting
ORA-07446: sdnfy: bad value '' for parameter .
SQL>
[code]....

View 4 Replies View Related

Moving Schema From One Database To Another Of Different Unix Flavour With Minimal Downtime

Aug 14, 2013

Oracle version : 10g, 11g (applicable to both) Consider a schema named 'UNIVERSE' present in the database A running on Linux platform where this schema needs to be moved to another database B running on  windows platform or AIX platform with no downtime provided and data needs to be consistent.  Is this practically possible?

View 13 Replies View Related

Migration From Oracle 10g To 11g?

Apr 26, 2011

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 ?

View 1 Replies View Related

DB Migration From Oracle 10g To 11g?

Sep 1, 2013

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 Related

SQL & PL/SQL :: Migration From Oracle 10.2 To 11

May 7, 2012

Currently 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).

View 7 Replies View Related

Client Tools :: Error When Trying To Connect Sybase Through SQL Developer

Nov 17, 2012

I am getting bellow error message when trying to connect Sybase through Sql developer: status:failure-test failed:IO Error:The network adapter

View 1 Replies View Related

Networking And Gateways :: Can't Connect To Sybase (ASA) Via Database Gateway

Sep 6, 2009

I'm trying to connect from Oracle 11g (11.2.0.1.0) to Sybase Adaptive Server Anywhere (9.0.2.3527). My Oracle environment is running on Linux Centos 5.3, the sybase database runs on a Windows Server.

All my attempts have failed so far - both through Oracle Database Gateway for Sybase and via Oracle Database Gateway for ODBC in combination with freeTDS. Using either way I'm ending up with apparently the same error:

ASA Error -611: Transact-SQL feature not supported

When I use db link created via dg4sybs (Oracle Database Gateway for Sybase) I get this:
SQL> SELECT * FROM aaa@hvx;
SELECT * FROM aaa@hvx
*
ERROR at line 1:
ORA-28500: connection from ORACLE to a non-Oracle system returned this message:

[code]....

When I use db link created via dg4odbc (Oracle Database Gateway for ODBC) and freeTDS driver I get this:

SQL> SELECT * FROM aaa@hvx1;
SELECT * FROM aaa@hvx1
*
ERROR at line 1:
ORA-28511: lost RPC connection to heterogeneous remote agent using
SID=ORA-28511: lost RPC connection to heterogeneous remote agent using

[code]....

It seems both drivers use Transact-SQL instructions which are then denied by ASA. I'm not familiar with Sybase products at all, but as far as what my googling revealed the Transact-SQL is only supported in Adaptive Server Enterprise (enterprise-class version of Sybase's database). I couldn't figure out if there's a way how to disable Transact-SQL in the driver configuration. how to connect from Oracle (10g or 11g) to Sybase Adaptive Server Anywhere?

View 3 Replies View Related

Migration From Oracle 10.2.0.3.0 To 11.2 On AIX 5.2 Server

Jan 26, 2012

Detail 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 Related

Migration Of DB From MySQL5 To Oracle 11g?

Jun 1, 2012

I 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 Related

Oracle Migration From 9i To 10G Tips

Jul 27, 2011

I 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 Related

Forms :: Migration From Oracle 9i To 10g

Jan 4, 2011

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.

View 4 Replies View Related

Migration From SQL Server To Oracle

Oct 10, 2011

I 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';

View 3 Replies View Related

Ingres To Oracle Migration?

Nov 30, 2012

I need to migrate Ingres database version 6.0 to oracle 10G.Is there any feasible procedure/tools/process available.

View 2 Replies View Related

PL/SQL :: Oracle Data Migration

Nov 9, 2013

Send me sample data migration scripts to get knowledge on Data migration. 

View 10 Replies View Related

Database Migration With Oracle 9i?

Mar 18, 2013

I 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.

View 4 Replies View Related

Data Migration From WORD To ORACLE?

Sep 20, 2011

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..

View 5 Replies View Related

Forms :: Migration Of Oracle Form 10g To 6i?

Apr 19, 2011

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 Related

SQL & PL/SQL :: Database Migration Project To Oracle

Nov 8, 2010

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]...

View 4 Replies View Related

Forms :: Migration Jobs Oracle 4.5 INp To 10G

May 6, 2011

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

View 6 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved