How to reduce memory consumption? > > > If the above commands show values, and you are using a spfile, you can > > > adjust the parameters like this: [quoted text clipped - 28 lines] > SQL> startup pfile=D:\myoracle11g_home\admin\oracle11g\pfile\init.ora. That's great that you found a work-around for the problem. I should have mentioned this to you - always keep an updated copy of the pfile (init.ora) handy. Name the pfile as initSID.ora (where SID is the database name) and place it in the same folder (directory) as the spfile. So, what can you do if you do not have an up to date pfile? Spfile using Wordpad, but do not make any changes using Wordpad. Create a new file in Notepad listing each parameter that is found in the spfile, on a separate line in the Notepad document, for example: compatible='11.1.0.0.0' control_files=("C:\Oracle\oradata\VMTEST\vmtest\control01.ctl", "D: \Oracle\oradata\VMTEST\vmtest\control02.ctl") db_block_size=8192 db_domain='' There may be a couple stray characters here and there that need to be removed.
Database Online Documentation 10g Release 2 (10.2) Step by step to test stream on 10gr2 « Oracle Force. The Oracle (tm) Users' Co-operative FAQ - Streams 10gR2 simple replication. The Oracle (tm) Users' Co-Operative FAQ Setting up one-way replication at the schema level between two databases using Oracle Streams 10gR2 Back to index of questions Data to be replicated is not obtained by direct access to OLTP database.
Data extraction process interferes with regular database operation. (For an introduction to Streams, basic concepts, list of reference documentation, and an example of a single table one-way replication procedure, please refer to Sanjay Mishra's article , “ Making Data Flow” at ) The single PL/SQL procedure - dbms_streams_adm.maintain_schemas completely sets up basic schema level replication. 1. 2. 3 . 4. 5. (This link is needed because I will use the network Data Pump export/import which is not using an export dump file; standard export/import using dump file is also possible ) 6 . 8 . 9. Steps in detail For steps 1 – 4, please refer to the Mishra's article mentioned above. 5. 6. 7 .
Oracle Streams Replication Example « I’m just a simple DBA on a complex production system. I promised to show off our streams implementation, because I found so few examples out there. Keep in mind that your streams implementation will probably look nothing like mine at all, and even if it will look like mine, you can get the same results in very different way. This example is not an excuse to avoid reading the docs. Our goal: Set up a reporting server, with replication of schemas arriving from many source DBs. We also want to filter out and not replicate some of the less critical tables. Decisions, decisions: When implementing streams there are several things you want to ask yourself: Do you want bi-directional replications? Do you want to capture the changes on the source DB, destination DB or a third server?
We went with one-directional replication, capturing will be done on the destination server, and we’ll use DataPump to initially move the schemas to the destination. CREATE TABLESPACE streams_tbs DATAFILE '/data/oradata/DB05/streams_tbs.dbf' SIZE 25M; Like this: O'Reilly -- Five Timesaving Unix Commands for Oracle DBAs. By Donald K.
Burleson 01/15/2001 My book Unix for Oracle DBAs Pocket Reference is the result of my trying for more than 20 years to memorize all of the different Unix commands that a DBA (database administrator) is required to know. As a consultant, I am asked to tune databases on every dialect of Unix, and it is a constant challenge to remember the commands that I need to perform my work. This article presents a sampling of my favorite scripts from the book. A "Change All" Command for Unix The script shown in this section does a search and replace in all files in a directory, replacing one string with another. . #! The for loop that you see in the script causes the sed command to be executed for each file in the current directory.
To use this script, place the code shown here into a file named chg_all.sh. Root> chg_all.sh *.sql A Script to Check Oracle Values on Hundreds of Databases This script requires the Unix remote shell (rsh) privilege so that it can bounce quickly between servers. Oracle.