New answers tagged

1

First of all, people often fall for this, but high log file sync waits do not necessarily mean I/O problem. Second, this could be really troublesome, if you have many physical devices in the ASM diskgroup where your redo logs are, because the extents of your files will be evenly distributed on several disks. Anyway, you need to find the ASM diskgroup ...


-2

DBCA will be reside on Oracle home. You can create as many number of databases in system using dbca. It will create default locations based on your unique SID (and dbunique name).


0

I've never used it, but http://blog.gitora.com/ is another option.


1

It only allows access to data dictionary views, so the only security implication is that the users(s) would be able to see which objects existed in the other schemas. They would not, however, be able to actually view the data in the other schemas. I said there was only one security implication, but another is that they would be able to view the source of ...


0

Yes, you need to catalog the backups at their new location. You should run crosscheck also on the backups, so the entries pointing to the old location become EXPIRED.


0

As already said, this is really easy to script e.g using sqlplus + shell scripts. Since you mentioned Enterprise Manager. Yes, it is possible through EM, but you need to set the preferred credentials for the databases and hosts. Once you have done that, you can execute an SQL on databases, or a group of databases. For example, I created a group called ...


0

A simple mistake, I forget to call FoodIngredients_type. Sorry for disturbing all again. insert into Foods values ('F1', 'Food #1', Food_type('FT1', 'Noodle'), FoodIngredients_table(FoodIngredients_type(Ingredients_type('I1','Ingredient #1', 0, 0), 10), FoodIngredients_type(Ingredients_type('I2','Ingredient #2', 0, 0), 20)), ...


0

Sure you can try, here is my quick test (on 11.2.0.4): SQL> select pool, bytes from v$sgastat where name = 'free memory'; POOL BYTES ------------ ---------- shared pool 503941528 large pool 6422528 SQL> drop diskgroup o6cb_fra including contents; Diskgroup dropped. SQL> select pool, bytes from v$sgastat where name = 'free ...


0

15018, 00000, "diskgroup cannot be created" Cause: The specified diskgroup could not be created. Action: Check for additional errors reported. 04031, 00000, "unable to allocate %s bytes of shared memory (\"%s\",\"%s\",\"%s\",\"%s\")" Cause: More shared memory is needed than was allocated in the shared pool or Streams pool. ...


-2

I just pressed left and then enter. It worked for me. This is the fix that helped me but I believe it should be fixed permanently.


2

Listener is a process running in the Oracle Server machine. The responsibility of the listener is to listen for the incoming database connection request and spawning server process to handle the request(in Dedicated Server mode) or handing over to dispatcher process(in Shared-Server mode). In RAC architecture we have SCAN listener to redirect connection ...


0

You need to set your PATH correctly, or run dbca by specifying the absolute path. For example: $ export ORACLE_HOME=/u01/app/oracle/product/11.2.0/dbhome_1 $ export PATH=$ORACLE_HOME/bin:$PATH $ dbca Or run dbca with absolute path: $ /u01/app/oracle/product/11.2.0/dbhome_1/bin/dbca


0

CTAS (Create Table AS) will work as long as you don't need triggers or indexes or constraints. EXPDP/IMPDP with REMAP_SCHEMA will bring along all of these other objects. Use CONTENT=METADATA_ONLY if you don't want to include the data.


1

If you are trying generate SQL to create empty tables for all tables then the SQL you have written might be okay. There is couple of errors which I have corrected as: select 'CREATE TABLE INTDTA.' ||table_name|| ' AS SELECT * FROM ZRTDTA.' || table_name || ' where 1=2;' from all_tables where owner='ZRTDTA'; If you want to use single quotation mark(') ...


4

there's a space missing before to in 'to myuser'. BEGIN FOR X in (select * from all_tables where owner in ('TESTDTA', 'TESTCTL')) LOOP EXECUTE IMMEDIATE 'GRANT SELECT, INSERT, UPDATE, DELETE ON ' ||X.owner||'.'||X.table_name|| ' to TESTUSER'; END LOOP; END; /


0

I'm sure that such approach is feasible. Technically Grid 11.2.0.4 is fully compatible with RDBMS 11.2.0.3. You just need to be accurate in some parameters. I believe that in a new 11.2.0.4 grid you won't use very specific "compatible.rdbms" or "compatible.asm" attributes' value ('11.2.0.4.0', e.g.) which might conflict with 11.2.0.3 database. Ideally you ...



Top 50 recent answers are included