I have requirement where replication should be done between two 11gR2 RAC on Standard edition.I have following queries,1. Does Standard edition support DDL capture?
Im asking this because on
[URL]......
it says "SE1/SE: no capture from redo" what that really mean ??2. Can it be possible to configure capture at schema level and skip only some of the tables / triggers ?
I am using Oracle 10.2.0.3.0 standard edition. Now i want to use Oracle XDB in the same.
Can i use this directly or does this require license.
The only supported technique for converting an EE database to SE is export-inport, as documented in note 139642.1. Our client is reluctant to do this because of the downtime involved. It is however possible to open the EE database from an SE home, no problem.
The note says only Quote:When you just install the Standard Edition software, you will end up with Data Dictionary objects which are of no use (or perhaps even invalid) and possibly create problems when maintaining the database.
I want to know, Is NVARCHAR2 available in Oracle standard edition?
View 5 Replies View RelatedWe are upgrading from oracle 9.2.0.8 to 11g r2, and both are Standard Edition database. The database is part of a product that runs on a customer site, and won't get bigger than 50 GB. It runs in archive mode, and our backup script does a hot backup every night, plus copying the archive logs, redos, controlfiles, etc. We save 2 entire backups - from the last night plus the night before last. Then there's a tape backup that saves the backed-up files to an off-server location.
This architecture has allowed us to recover our customer's data from many odd occurrences at customer sites (power loss during a hot backup, corrupt controlfiles/datafiles/archivelogs). My question is, given that we are running the Standard Edition database, which doesn't have most of the useful RMAN features, is it worth it to switch to RMAN?
I took an Oracle Backup and Recovery class and posed this question to the instructor, and the response was, it would be better to use RMAN over a manual user backup script. Our backup script is pretty battle-hardened - is that the best reason?
I read that Oracle RAC which is bundled in Standard Edition can support at max 4 sockets. One of my client has a proposal of using RAC but for 3 nodes each using single 1 quad core Intel processor. As far as i understood, an Intel quad core is a multi chip module and actually is a combination of 2 modules dual core, so each Intel quad core may be counted as 2 sockets. Which yield to the proposal of my client will be failed, as the total number of sockets in it will be: 2*3=6 that exceed the max 4 support.
View 4 Replies View Relatedmy customer wants to create a standby database for his production database (Oracle Standard Edition 11g R2 @ Windows 2008 R2 64 Bit). Now any proof-of-concept which explains shortly the concept and how to achieve it.
View 4 Replies View RelatedIn our current setup we have RAC on standard edition and client is now planning to go for Enterprise Edition but not yet decide because of cost. Is there any difference between Grid Infrastructure 11gR3 Enterprise edition and Standard Edition ?
They told me to first install Enterprise Edition and then will move to Standard Edition if they can't get the EE license so in that case do i have to re-install Grid infrastructure for standard edition?
Recently we have downgraded our database from enterprise to standard edition.....our sga size before downgrade was 11 gb and now it is 11gb and there is no as such problem in database..I have read somewhere that standard edition doesn't support sga size more than 2 gb .
View 1 Replies View RelatedI am checking out licenses. We all know that EE is much more expensive than SE. But many customers do have EE installed - unsure if they need all the features at all. After several years of production, a downgrade is considered 'risky' and we continue to pay the full EE.
How can we check and be sure that a downgrade to SE would not be any problem?
Some checks include:
* partitioning used in user schemas? --> no downgrade to EE
* bitmap indexes in user schemas? --> no downgrade to EE
How can we complete this list, or is there some script to make this easy?
When i am trying to uninstall Oracle 11g Standard Edition on Win 7 after sometimes it stopped.Checking for required files and bootstrapping..
14 File(s) copied
792 File(s) copied
1 file(s) copied.
1 file(s) copied.
Location of logs C:UsersinsajenAppDataLocalTempOraDeinstall2012-06-26_15-2
2-43logs
[code]....
After this message it stopped.
Oracle version :11.2.0.2 standard edition one
I'm trying to enable Email Notification for Chain Jobs, Jobs are running successfully, but i'm not getting email Notification.
i have done necessary SMPT setting in the Enterprise manager and i'm receiving test email from EM.
Below are steps followed:
1) i have created two Program
2)Add this program to a Chain
3)Created a Scheduler Job using this chain
4)Enable Email notification
Code for Email Nitrification:
BEGIN
DBMS_SCHEDULER.ADD_JOB_EMAIL_NOTIFICATION (
job_name => 'ChainJob',
recipients => 's.sankar@test.com',
sender => 'sankars@test.com',
subject => 'Scheduler Job Notification-%job_owner%.%job_name%-%event_type%',
[code]....
In my production ENV there is two node RAC database is running , and on both machine RAM size is (35GB on node1,41GB on Node2) and other configuration is like below.
SGA SGA_TARGET DB_BLOCK_SIZE DB_MULTIBLOCK_READ_COUNT
NODE1 16G 14G 8K 16K
NODE2 16G 14G 8K 16K
Our Database size is 700GB approx.
The above SGA configuration is ok or need to be increase the size of SGA , our HIT RATIO is almost 99%.
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 Relatedcan I install/use Oracle 10g Enterprise Manager Grid Control if my organization has only Oracle 10g Standard Edition Licences.
View 2 Replies View RelatedHow many records could I have in a single table without performance degradation with Standard Edition without partitioning with cutting-edge server (8 or 12 cores, 72 GB RAM, FC 4 Gbit, etc...) and good storage?
300 Millions in only one table with 500K transactions / day is too much?
Simple database with simple schema.
How many records begin to be too many?
A streams apply process which applies to a sql sever database is increasing its pga use continually until i stop the process and restart it. I need to stop it once every week or it will use too much of the pga and the database will hand causin paging etc.
View 1 Replies View RelatedI encountered the following error while trying to setup streams replication at the database level using dbms_streams_adm.maintain_global. Desmond begin*ERROR at line 1:ORA-23616: Failure in executing block 6 for script.
E00C49DDDB27C899E040A8C04C0119DA withORA-06550: line 21, column 3:PL/SQL: ORA-00942: table or view does not existORA-06550: line 21, column 3:PL/SQL: SQL Statement ignoredORA-06550: line 23, column 3:PL/SQL: ORA-00942: table or viewORA-06512: at "SYS.DBMS_RECOVERABLE_SCRIPT", line 659ORA-06512: at "SYS.DBMS_RECOVERABLE_SCRIPT", line 682ORA-06512: at "SYS.DBMS_STREAMS_MT", line 2427ORA-06512: at "SYS.DBMS_STREAMS_ADM", line 3004ORA-06512: at line 2 SQL> select forward_block from dba_recoverable_script_blocks where script_id = '
[code]....
Am trying to implement Oracle Streams Replication (Using Metalink Note 733691.1).I have configured the steps, but in my alert log am getting the below error:
Check that the primary and standby are using a password file and remote_login_passwordfile is set to SHARED or EXCLUSIVE, and that the SYS password is same in the password files. returning error ORA-16191
am successfully able to connect db's both server
From 1st server
sqlplus sys@2nddb as sysdba
From 2nd server
sqlplus sys@1stdb as sysdba
while conning it is asking for password
Both DB's are created with Same Oracle sys user password. after this disabled case sensitivity , still the error persists.
Platform: Windows 2003
Streams Set up: One way Streaming at table level
The error: ORA-26786: A row with key ("REPT_NUM", "STATE_CODE", "SURVEY_ID") = (067305669, 49, J) exists but has conflicting column(s) "DATE_TIME", "PREV_PARENT_ID" in table TOPCATI_JOLTS.UNIT ORA-01403: no data found
We are consistently getting this error every other day and some weeks more often, different records of course. On the capture site the application does a process called split cases. In this process the application will take an old PK case num insert a new PK case number with all of the data of the old case (Parent level). At the unit (Child level) the application will change all of the units to this new FK case number. This means the old case (parent) is left with no child units. This is all one transaction.
Is it possible that streams may be applying the LCR's out of order? especially since that whole process is one transaction.
I am trying to setup a one way queue that will be consumed by an inhouse ESB.We currently are able to create a multi-consumer queue using:
CODEBEGIN
DBMS_STREAMS_ADM.SET_UP_QUEUE(queue_table => 'strmadmin.streams_queue_table',
queue_name => 'strmadmin.streams_queue');
END;
but unfortunatly the ESB that we are using uses a jms component which seems to only be able to take mono-consumer queue.So we have created our queue usuing the following
CODEBEGIN
DBMS_AQADM.CREATE_QUEUE_TABLE( Queue_table => '"STRMADMIN"."STREAMS_QUEUE_TABLE"',
Queue_payload_type => 'SYS.ANYDATA',
storage_clause => 'PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 TABLESPACE
[code]...
This therefore permits us to have a queue/queuetable which pushes data to a single consumer.The probleme comes when we try to add a table rule using the following command:
CODEBEGIN
DBMS_STREAMS_ADM.ADD_TABLE_RULES( table_name => 'source.t1',
streams_type => 'apply',
streams_name => 'streams_apply',
queue_name => 'strmadmin.streams_queue',
[code]...
We then get the following error:
CODEORA-06512: on line 2 24039. 00000 - "Queue %s not created in queue table for multiple consumers"
*Cause: Either an ADD_SUBSCRIBER, ALTER_SUBSCRIBER, or REMOVE_SUBSCRIBER procedure, or an ENQUEUE with a non-empty recipient list, was issued on a queue that was not created for multiple consumers.
*Action: Create the queue in a queue table that was created for multiple consumers and retry the call.
We are able to create the capture rule without any problem but without the apply rule, nothing seems to end up into the queue table.AQ is not a viable solution since it is troublesome when it comes to deletes and mass updates.
We have three unix servers with four databases (10gR2) containing "HP Operation Management Unix" (OMU) server messages for monitoring purpose, and we now want to transfer these data to one new database on a new server for reporting purpose.
The message table in each OMU database keeps the message row until it is "Acknowledged" or for maximum fourteen days, then it is moved to an historic table where it stays for another three days. Keeping data for only seventeen days are a performance issue.The new "Reporting database" is intended to hold messages data for the last 90 days.
I wonder which method to use to move/replicate data against the databases? Materialized view using database link, with view on top of the MVs. How to keep rows longer than the master (source) table, avoiding deletion when master row is deleted
Oracle Streams, with local capture and remote apply. How will this influence on the master database performance. There are about 10000 new messages in each OMU database every day. Is it possible having four streams connections against the reporting database ?
Or should I simply use database triggers which fires after insert and update and applies changes to the reporting database using database links ?
Till now my company used Share Plex for replication 6 DBs from different location to one server (used for BI operations).
1) Replication in in real time
2) All DBs are Oracle but different versions 9 and 10 .
3) We have horizontal and vertical replication. We replicate just some tables, for some tables just some columns and for some tables just records with some conditions
4) We have different charsets.
5) SharePlex have compare/repair tool to check it DBs are in sync mode
I started to look for Oracle Streams to use it instead of SharePlex. Do you know if it is able to handle that type of replications? Do you know about any Oracle Streams limitation which eliminates it?
I need to know that what is best approach for replication. Materialized View or Streaming. We have to replicate a subset of database at different nodes.
View 3 Replies View RelatedWe are using Oracle Streams for replication.
Column datatypes in some of the tables on Source and Destination are different (Number on Source and Varchar2 on destination).
Do we have to create any rule or dml handler to handle this or Streams will automatically take care of it?We are oracle 10g.
Is it possible to read streaming continuous binary data from a web site using PL/SQL?
View 8 Replies View Related10g Oracle Standard Edition RAC feature and how it is charged. I mean: is it free option for Standard Edition or payable?
I read something about Baby Rac on wiki and there was information that only with Engerprise Edition RAC is an extra-charge option for Standard Edition RAC is included.
[URL]......
Quote:Oracle Corporation includes RAC with the Standard Edition of Oracle Database (aka Baby RAC), but makes it an extra-charge option for the Enterprise Edition
We do have corporate licencing model in our firm, so we can evaluate what version of Oracle we need to install (One, Standard or Enterprise) bu there is no matter what version we chosed, because our licensing model give us possibility to install the highest version. So usually we were choosing the Enterprise Editions.
But only limitation for us is an options. We can't have additional option like partitioning, RAC, Oracle Tuning Pack, etc... in order to have additional option we need approval from our financial management.
I have idea to change one of our installation from Enterprise Edition to Standard Edition in order to have RAC option for free. Like i said. If we want to have RAC in our Enterprise Edition we need additional approval of money expense - but this is not easy. But our licensing model give us possibility to install Standard Edition of Oracle instead or Enterprise Edition and have RAC option include without additional expenses.
I tried to uninstall Oracle XE 11g and i got 1402 error from Windows Error: [URL]...
what is happening. I can not uninstall or repair either.
I want to do horizontal fragmentation of a table say employee. But fragmentation is often related to distributed databases. So i want to ask how can i do this on my single home computer? list out the steps that should be performed. I saw the concept of link but really failed to understand that.
View 14 Replies View RelatedI have downloaded oracle 10g express edition. I have tried to connect forms 6i in that in windows xp environment but when i tried to connect it is not connecting and giving "don't send" error.
If there is any patch to connect forms 6i into oracle 10g express edition.
