search for: tablespac

...v/sdp1 10G 5.3G 4.8G 53% /db/DPS so there are more than 4GB available. $ sqlplus /nolog SQL*Plus: Release 9.2.0.4.0 - Production on Wed Sep 1 12:57:48 2004 Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved. SQL> connect / as sysdba; Connected. SQL> create tablespace data_dp datafile '/db/DPS/tablespaces/dp/data01.dbf' size 999m autoextend on segment space management auto; create tablespace data_dp * ERROR at line 1: ORA-01119: error in creating database file '/db/DPS/tablespaces/dp/data01.dbf' ORA-27044: unable to write the header...

Hi All, I inherited a 4-node ocfs2 cluster and recently 2 ocfs2 filesystems were added to be use as temp tablespace.?One of the four nodes rebooted during the ?creation of the tablespace and hanged at the message below...and it just sits there. If I put the server into rescue mode and comment out all the filesystems it boots up fine and than I can mount the ocfs2 filesystem manuelly but it cannot do it by itsel...

...All, We're hosting DB1 and DB2 with db_block_size set to 8K, 16K respectively File system creation is done with mkfs.ocfs2 -b 4K -C 32K -N 4 -L LABLE /dev/mapper/xxxx Mount is done with: ocfs2 _netdev,datavolume,nointr 0 0 I'd like to know if we can separate most of the tablespaces on different LUNs, even if they're on the same disk group sometimes, is it possible to gain better performance? Is the impact limited to the time of creating the tablespaces only (assuming they're pre-sized properly)? Current OCFS2 version is 1.2.1 Current OCFS2 components: ocfs2...

We used rsync 2.6.3 on a couple of Solaris 8 machines to update an Oracle database from one machine to another. Here is the procedure I used: The source database was up and running so this operation was similar to doing a hot backup. I queried the source database for a list of tablespace names, and for each tablespace, I queried the list of datafiles. I put the tablespace in hot backup mode, which means that no updates are written to the datafiles; they will all go the the redo logs. Then I rsync'ed each datafile in that tablespace then took the tablespace out of hot backu...

...as.conf''` by default so extra parameters not managed by the module can be added by other tooling or by Puppet itself. This provides a useful escape-hatch for managing settings that are not currently managed by the module today. We''ve added a new defined resource for managing your tablespace, so you can now create new tablespaces using the syntax: postgresql::tablespace { ''dbspace'': location => ''/srv/dbspace'', } We''ve added a locale parameter to the `postgresql` class, to provide a default. Also the parameter has been add...

...(RECH_CRITERES) indextype is ctxsys.context PARAMETERS ('MEMORY 50M STORAGE text_storage') / with: ----- BEGIN ctx_ddl.create_preference('SYS.TEXT_STORAGE', 'BASIC_STORAGE'); ctx_ddl.set_attribute('SYS.TEXT_STORAGE', 'I_INDEX_CLAUSE', 'pctfree 0 tablespace TBS_SNAP_INDEX'); ctx_ddl.set_attribute('SYS.TEXT_STORAGE', 'I_ROWID_INDEX_CLAUSE', 'pctfree 0 tablespace TBS_SNAP_INDEX'); ctx_ddl.set_attribute('SYS.TEXT_STORAGE', 'I_TABLE_CLAUSE', 'pctfree 0 tablespace TBS_SNAP_INDEX'); ctx...

...(RECH_CRITERES) indextype is ctxsys.context PARAMETERS ('MEMORY 50M STORAGE text_storage') / with: ----- BEGIN ctx_ddl.create_preference('SYS.TEXT_STORAGE', 'BASIC_STORAGE'); ctx_ddl.set_attribute('SYS.TEXT_STORAGE', 'I_INDEX_CLAUSE', 'pctfree 0 tablespace TBS_SNAP_INDEX'); ctx_ddl.set_attribute('SYS.TEXT_STORAGE', 'I_ROWID_INDEX_CLAUSE', 'pctfree 0 tablespace TBS_SNAP_INDEX'); ctx_ddl.set_attribute('SYS.TEXT_STORAGE', 'I_TABLE_CLAUSE', 'pctfree 0 tablespace TBS_SNAP_INDEX'); ctx...

...needs to move as we migrate to the new servers. We have the following questions: 1. Can we mount an existing OCFS2 1.2 volume on a servers running OCFS2 1.6? 2. Are there any negative implications of being in a mixed mode? 3. If we need to add a OCFS2 1.6 volume to increase a tablespace size, can we have one datafile be OCFS2 1.2 and another be OCFS2 1.6 for the same tablespace? 4. Can we use OCFS2 1.6 features against an OCFS2 1.2 volume mounted on OCFS2 1.6? Thank you, Nancy <http://www.suny.edu/> Nancy Maki Manager of Database Services Office of Info...

hi, i have a problem with ocfs. i did some tests with dbms_stats on a 2-node RAC and got the following error: Thu Feb 17 15:36:31 2005 KCF: write/open error block=0x7800 online=1 file=13 /db/GKEZ/tablespaces/voeb/idx01_kez.dbf error=27072 txt: 'Linux Error: 5: Input/output error Additional information: 30719' Automatic datafile offline due to write error on file 13: /db/GKEZ/tablespaces/voeb/idx01_kez.dbf the kernel log: Feb 17 15:36:31 bn1rac003 kernel: (486) ERROR: ret=-5, Linux/ocf...

I have set up an cluster with ocfs2 on top of drbd in primary/primary mode. As long as the datadir is in /var/lib/mysql, everything works fine. But as soon as I put the datadir on the ocfs2 filesystem /mnt/data/mysql mysql fails with: [Ubuntu] root at fs2:/etc# mysqld --safe-mode 090930 18:08:14 [Warning] Can't create test file /mnt/data/mysql/fs2.lower-test 090930 18:08:14 [Warning]

Hi All, Is there a way to tune the zfs prefetch on a per pool basis? I have a customer that is seeing slow performance on a pool the contains multiple tablespaces from an Oracle database, looking at the LUNs associated to that pool they are constantly at 80% - 100% busy. Looking at the output from arcstat for the miss % on data, prefetch and metadata we are getting around 5 - 10 % on data, 50 - 70 % on prefetch and 0% on metadata. I am thinking that...

...w how to correct it? I couldn''t find any Rails-specific info about this on google. Here are the circumstances: /usr/local/bin/ruby --version ruby 1.8.4 (2005-12-24) [i686-linux] /usr/local/bin/rails --version Rails 1.1.6 ## Create mcd app rails mcd -d oracle cd mcd ## Create oracle tablespace & user sqlplus ''/ as sysdba'' create tablespace mcd datafile ''/oracle/oradata/d102/mcd_0.dbf'' SIZE 500M; create user mcd identified by XXX default tablespace mcd ; grant select_catalog_role, connect, resource, XXX, create session to mcd; ## Start serve...

Just a few quick questions.. Does rsync copy open files? If so, does file integrity remain intact? I’m looking to backup IIS log files and maybe Oracle and SQL Server DB files. If rsync isn’t appropriate, what would you recommend? Thanks for your time, Mark J. de Jong ,.,.,.,...,.,,.,..,.,....,.,..,.,..,.,.,,.,...,..,,... Senior Network Engineer - Secure Dog Hosting, Inc. P.703.256.2869

Hello, Im about to migrate a 6Tb database from Veritas Volume Manager to ZFS, I want to set arc_max parameter so ZFS cant use all my system''s memory, but i dont know how much i should set, do you think 24Gb will be enough for a 6Tb database? obviously the more the better but i cant set too much memory. Have someone implemented succesfully something similar? We ran some test and the

I am starting to see a few issues with OCFS and 9.2.0.3 RAC on redHat Linux AS 2.1. Wondering if there is anyone out there experiencing similar issues... a few pointers to the issues.. 1. OCFS read/write performance is way lower than a read/write to a raw device.. i can give you some comparison numbers.. 2. Writes to shared disk with ocfs would get locked up by one server.. it doesnt have to

I am starting to see a few issues with OCFS and 9.2.0.3 RAC on redHat Linux AS 2.1. Wondering if there is anyone out there experiencing similar issues... a few pointers to the issues.. 1. OCFS read/write performance is way lower than a read/write to a raw device.. i can give you some comparison numbers.. 2. Writes to shared disk with ocfs would get locked up by one server.. it doesnt have to

We are running 2-node RAC on RedHat Linux-86 (32-bit) the following was done on (4/10/2005) 1. upgrade OS to update 4 (kernel-smp-2.4.21-27.0.2.EL) 2. upgrade OCFS 1.0.12 to ocfs-2.4.21-EL-smp-1.0.14-1 3. upgrade from 9.2.0.5 to 9.2.0.6 (IN 2-Node RAC) 4. change defualt temporary tablespace to regular one (Rac bug fix) 5. Enable aysnc mode by applying patch 3208258_9206 ** Patch 4153303 applied on Mon Apr 11 22:16:07 PDT 2005 to fix RAC crach Since then we have been getting the following error on standby system and we are not able to establish standby (physical) ORA-10567: Redo i...

Are there any known issues with using a split mirror of the OCFS partitions for backups? One option we are looking at is as follows: 1. Put tablespace in backup mode. 2. Split the mirror at the SAN level. 3. end tablespace backup mode. 4. mount the OCFS mirror under a different mount point. 5. backup the files on the OCFS mirror using RMAN. The question is how feasibile it is for step #4 to occur. Is there anything within OCFS preventing the O...

Hi All, we´re currently running an Oracle DB un SuSE 7.2 with kernel 2.2.19 and 0.0.7b ext3 Patch. Do you have any recommendations for maximum performance with the Database? Tablespace Sizes are about 15 GB User, 10 GB Temp. Main Operation of DB is reporting (index load, table scan, arithmetic operations). Which mount option should be best (concerning performance)? Hints welcome. -- Christian Weber mailto:Weber@InfoTech.de Tel: 02361/91300 For information on InfoTech visit...

...39;t appear to support. What''s the answer in this case? 2) All the tutorials seem to be geared towards trivial data relationships. What if I have table SHOP and table PERSON, but each record in SHOP has a OWNER, MANAGER, and a collection of EMPLOYEES. How should you structure this in your tablespace to take the best advantage of activerecord? 3) Am I wrong in the assumption that all this needs to be sorted out at the database level before I go and generate models and controllers? Where do you put code that you don''t want to get blatted if and when the schema changes and you need to...