11g Linux 5.5 - How To Deploy Replication Database
Jul 26, 2011
How I can maintain a replication scheme from a production database and a standby. I was watching the advanced replication methods of Oracle, but what I want is in the evening to run a process and modify the database incrementally and thus leave until the next night.
And the server I want to allocate to the standby database, also implements other processes, so my settings would be:
Production: Oracle Database 11g Linux 5.5
Standby: Windows 2003 Database 11g
Maybe that data is important, let me make clear that what I want is that the database is updated incrementally.
View 1 Replies
ADVERTISEMENT
Jun 22, 2009
I am trying to move my archive from linux to window as the log switch occur.... for this i mount my directory of window in linux .. but it doesn't moving... dest 1 on linux and dest 2 for windows...
In alert log the permission denied appears... the mounted directory in linux of windows is owned by root ... and is not changing to oracle.
View 1 Replies
View Related
Sep 14, 2012
I am soon engaging in a project where we will deploy three triggers to each table in a customers live database. One each for Inserts,Updates and deletes.
These triggers write or update a row in a separate table on a different schema.
We have experienced locking issues on these tables previously with SQL Server. Are there settings we can look at to improve performance?
View 2 Replies
View Related
Sep 4, 2009
i need to set up a central server with all the master tables and two other local database which will hold the updatable materialized view of the master table...the databases must be synchronized with central server..and user will work on the materialized view database...
View 10 Replies
View Related
Oct 8, 2012
We are planning Database Migration From Windows to Linux Using RMAN..We required Oracle database 10.2.0.4 for Linux 64 bit.
View 3 Replies
View Related
Sep 29, 2010
i am new to linux os . the step by step process of oracle database 10gR2 and oracle 10g client installation in linux os
View 6 Replies
View Related
Mar 3, 2012
I need to migrate a 500 GB 10.2 database from windows to linux. Of course I found Alejandro Vargas paper on how to do that ("Database Migration From Windows to Linux Using RMAN"). My problem is that the source database will be up again for 7 days and I need to apply all changes made to the source database to the migrated linux database.
Can I just take all redo log files generated from the source database and apply those to the destination database? I might have a problem with a) file conversion and that the redo log are not in sync with the target database (different check points?).I just found that on an exotic website: "The contents of a redo log file depend on a combination of Oracle version, operating system and server architecture. In general redo logs written on one architecture cannot be read on another. There are a few exceptions to this rule. For example, in Oracle 10.2 a redo log written in Linux can be read by a Windows database."
So if this is true, does it also work the other way AND will the database migration from window to linux create a perfect clone of the database where those redo log files actually can be applied to?
View 1 Replies
View Related
Sep 12, 2011
We are planning to migate Oracle database from Linux 10gR2 (non-ASM) to Solaris (ASM) and then Oracle upgrade that database from 10gR2 to 11gR2 on Solaris.
View 4 Replies
View Related
Jun 5, 2012
URL.....Where can I download Oracle database express edition for x86 Linux? I can only see Windows and x64 Linux in Oracle's download page URL....
View 2 Replies
View Related
Dec 11, 2010
We plan to deploy oracle EBS R12. what are all the components needed to build this infrastructure. ex. Oracle 11g database, oracle 10g application server.
also which solution should be deployed to ensure the Enterprise single-Sign On (ESSO).
View 1 Replies
View Related
May 6, 2013
I need to migrate database from Windows to Linux. The current size is ~50GB.
Current Env:
OS = Windows 2003
DB version = 10.2.0.3
Proposed Env:
OS = Linux
DB version = 11.2.0.2
Would using datapump be a correct choice for this migration? Also do the step below seem correct?
01. Pre-create tablespaces on target 11g database
02. Export full database of source 10g database
03. Copy dumpfile to Destination Server
04. Grant IMPORT_FULL_DATABASE system privilege to user SYSTEM of target 11g database
05. Import full database to target 11g database
View 6 Replies
View Related
Aug 21, 2013
can we query this without login to the oracle database from linux os?database is up and running . /apps/oracle/product/11.2.0/dbhome/bin/sqlplus system/passwd select name from v$database;
View 5 Replies
View Related
Oct 2, 2012
We have 3 databases with version 10.2.0.3.0 running on RHEL AS 4.5 32 bit operating system. We are planning to move these databases to RHEL 64 bit Operating system.
let me know the highest 64 bit RHEL version supported by these databases(10.2.0.3). Will it support with RHEL 5.5 64 bit version?
View 7 Replies
View Related
Apr 13, 2013
can we import oracle 10g database table into oracle 8i database on linux platform?
View 7 Replies
View Related
Nov 12, 2012
We have a scenario where Oracle Database R1 is installed on Windows System and the Client is present on Linux. Both the system is on same network. We can access Windows -2-Windows using TNS entry.
I am unable to connect to this scenario where Database is on Windows and Client is on Linux.
View 8 Replies
View Related
Nov 12, 2012
Issue : NOT able to start the Oracle Data Base 11g on Linux machine
I've successfully installed Oracle-DB-11g on my Linux machine.
Note : I haven't declared or exported any variable(s) , actually I'm not sure how and where to do this.
View 1 Replies
View Related
Jun 20, 2012
I was trying to create a 11g database on linux using dbca.
At very end "create database" I got 'The file pach +DATADG/orcl/system01.dbf in invalid. Check the permissions.'
How to check the permission?
View 6 Replies
View Related
Dec 26, 2012
I need to do the following:
(1) Move my 10gR2 database from 32-bit Linux to 11gR2 64-Bit Linux (using an RMAN backup from 10gR2 restored on the 64-bit machine) then
(2) Bring up the database on 64-bit hardware and then upgrade to 11.2.0.3 (64-Bit) [Without installing the 10.2.0.3 64-Bit software]
Haven't tried restoring to 11.2.0.3 from a RMAN 10.2.0.3 backup. I was trying not to have to install the Oracle 10.2.0.3 software for 64-bit on the 64-bit machine. Was hoping to go directly to 11.2.0.3 (64-bit).
View 2 Replies
View Related
Aug 16, 2013
when migrating from 32 bit Linux to 64 bit Windows version on database standard edition, is there a server media needed?if yes, can you give me more details on what it consists of?
View 2 Replies
View Related
Jan 4, 2013
I have installed Oracle virtual box on windows host and have created Oracle Linux virtual machine as guest. I have installed the database server on my host machine but rest of the things(Peoplesoft peopletools etc....) on Oracle Linux guest.Now, I am trying to installed database client on guest machine which is Linux so that I can connect to DB server running on host, but having difficulties in doing so.
, I am following the installation instruction given in the doc docs.oracle.com/cd/E11882_01/install.112/e24322.pdf, but when I finally run command runInstaller.sh doesn't happen anything.Actually, to install other software's I just double clicked the .sh file and it automatically started the installation process on a terminal window but when I clicked runInstaller.sh to install DB client, it didn't do anything.
Also, when I run the same command runInstaller.sh from command line after navigating to the directory where this file is present, It throws me error saying "no command found".By the way, why the steps given in doc are so complex, I wish If I could just double click runInstaller.sh just like others and it start the installation process.
View 22 Replies
View Related
Mar 19, 2013
I have developed a custom application in APEX. I wants to deploy and make it as a web application so that it can be access through url.
View 1 Replies
View Related
Feb 24, 2012
I have a big probleme with owb 11.2.
1. I have export MDL file from owb 10.2
2. I created owb repoisitory on server where I have installed my database 11gr2.
3. I have installed OWB 11gr2 on another machine.
4. Imported MDL file to new repository.
How I deploy to my new repository?
View 2 Replies
View Related
Aug 4, 2011
I am using expdp/impdp to migrate 4 TB database from solaris to Linux.But the import process is taking forever.
View 13 Replies
View Related
Jun 13, 2013
the database (11gR2) is located on Linux server. A business application is installed on a Windows server with an Oracle client 11g.The application is able to start a datapump export, but as matter of fact the dumpfiles are always written to the Linux-server. The directoryobject is defined as DATA_PUMP_DIR (which is the default directory).
Now we are supposed to change the datapump export in a matterthat the dumpfiles get written to the Windows server. Creating a new directory (e.g. c:datapump) and starting than the datapump from theclient always raises the errors
ORA-39002: ...ORA-39070: ...ORA-29283: ...ORA-06512: in "SYS.UTL_FILE", Zeile 536ORA-29283: ...
Is it possible at all to start a datapump export from a Windows client and writing the dumpfiles to the Windows server itself? Or do the dumpfiles always written to the database-server?
View 9 Replies
View Related
Feb 7, 2011
I'm trying to deploy the schema using DATAPUMP API. The user from which the schema get deployed has the direct privilege of CREATE USER (not through role). But got the insufficient privileges error.
Processing object type SCHEMA_EXPORT/USER
ORA-31685: Object type USER:"SCOTT1" failed due to insufficient privileges. Failing sql is:
CREATE USER "SCOTT1" IDENTIFIED BY VALUES '4EBB0DDE3C79FE47' DEFAULT TABLESPACE "USERS"
TEMPORARY TABLESPACE "TEMP2" PROFILE "APP_PROFILE".
But the user get created successfully when run the CREATE statement manually.I have created the user manually and again run the deployment procedure. Got the below error for ROLE_GRANTS.
Processing object type SCHEMA_EXPORT/ROLE_GRANT
ORA-39083: Object type ROLE_GRANT failed to create with error:
ORA-01932: ADMIN option not granted for role 'EXP_FULL_DATABASE'
Failing sql is:
GRANT "EXP_FULL_DATABASE" TO "SCOTT1"
The user has EXP_FULL_DATABASE with ADMIN Option and IMP_FULL_DATABASE with ADMIN option direct privileges.which privileges the user needs to deploy the schema successfully?
View 1 Replies
View Related
Jul 26, 2012
I want to setup one way replication in oracle 10g Database.
Example: There are 2 database in two locations.DB1 and DB2.
DB1 need to get data from DB2 every one hour and update in DB1 database.
View 4 Replies
View Related
Dec 25, 2007
Is it possible to create replication on same database with different schema ?
View 1 Replies
View Related
Jan 16, 2013
I planing use latest APEX listener and Apache with mod_jk on new server.I wonder what are pros and cons use APEX listener standalone comparing when deployed to J2EE container e.g. Glassfish? URL.....
View 4 Replies
View Related
Jun 5, 2012
We want to deploy an apex environment. I see that there are 3 methods for apex installation:
Scenario 1: Downloading from OTN and Configuring the Oracle Application Express Listener
Scenario 2: Downloading from OTN and Configuring the Embedded PL/SQL Gateway
Scenario 3: Downloading from OTN and Configuring Oracle HTTP Server
I think the applications that we will create in apex will have 50-100 users. We don't use RAC.
View 1 Replies
View Related
Dec 4, 2007
I have a table MYTABLE in database mydb1 duplicated via materialized view and materialized view log and refresh_snapshot commands to a MYTABLE on mydb2 database.
I like to duplicate this table MYTABLE to a third database mydb2, using the same method (materialized view and refresh_snapshot command).
Is it possible ? What's hapend to the materialized view log where I launch a refresh_snapshots on mydb2 ? How is this materialized view log truncated ?
View 5 Replies
View Related
