search for: tablespaces

.../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 block of file Linux Error: 28: No space left o...

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

...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-t...

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,

...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 added to the `postgresql::database` and `po...

Hi all, I curently have a big problem. One request (listed above) using context take up to 1000 more time than the on RAW or ext2 database. I have ran this request on a single IA32 machine with Redhat and dbf on ext2. The average reponse time is less than a sec. The same request on RAC 4 nodes cluster on RAW take the same average time. On ext2 idem. But on OCFS it took up to 15 sec randomly

Hi all, I curently have a big problem. One request (listed above) using context take up to 1000 more time than the on RAW or ext2 database. I have ran this request on a single IA32 machine with Redhat and dbf on ext2. The average reponse time is less than a sec. The same request on RAC 4 nodes cluster on RAW take the same average time. On ext2 idem. But on OCFS it took up to 15 sec randomly

We are in the process of migrating to new database servers. Our current RAC clusters are running OCFS2 1.2.9 on RHEL 4. Our new servers are running OCFS2 1.6 OEL5. If possible, we would like to minimize the amount of data that 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?

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/ocfsm...

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 th...

Has anyone encountered this error or know 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

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

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

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

Hi, I''m trying to get my head around rails, but the documentation seems sparse at best (and manuals.rubyonrails.com is unreachable from my location for whatever reason). I''m trying to figure out a few things: 1) The documentation for the magicfields mentions using datetimes instead of timestamps, which pgsql doesn''t appear to support. What''s the answer in this