Oracle

ORA-12899: importing a .dmp file + character set conversion

Posted on

https://www.queryxchange.com/q/7_17504/ora-12899-importing-a-dmp-file-character-set-conversion/ You can edit the dump file and change the included NLS_LENGTH_SEMANTICS from BYTE to CHAR. Near the beginning of the file you find a line ending like this : ^@02:00:^@^@^D^@BYTE^F^@UNUSED^A^@2^K^INTERPRETED^K^@DISABLE:ALL^@^@ Change BYTE to CHAR using your favorite text editor and save the file. When you will imp that new dump file, all columns will be create […]

General programming

Source code control for database schema

Posted on

http://www.liquibase.org The easiest way to run Liquibase is to set it to run automatically on startup. Once set up, your database state always matches what your code expects and you have no manual steps to forget. This method works best in environments where you have less control over the deployment process or if you want […]

Oracle DB administering

Patching DST for Solaris and Oracle

Posted on

Patching DST for Solaris and Oracle 1. Solaris: 1.1. copy last tzdata from http://www.iana.org/time-zones 1.2. unpack the archive into temporary directory 1.3. as root: #zic europe this command compiles and installs updated timezone database 1.4. check that tz update applied #! /usr/bin/perl use POSIX qw(mktime),qw(strftime); # Oct 26 02:00:00 MSD 2041 $t = mktime(0,10,1,26,9,2014-1900,-1,-1,1); print […]

Oracle DB administering

Solaris and RDBMS direct IO

Posted on

DB Options disk_asynch_io is a kind of master switch, which turns on or off Async I/O to database files on any type of storage, whether it’s raw device or filesystem. The filesystemio_options parameter gives finer control over I/O to database files on filesystems. It allows you to turn off async I/O to filesystem files but […]

Oracle DB administering

Installing Oracle RDBMS on Solaris 11

Posted on

Prepare OS environment #projadd group.dba #projmod -s -K “project.max-shm-memory=(priv,4gb,deny)” group.dba #projmod -s -K “project.max-sem-ids=(priv,256,deny)” group.dba #projmod -s -K “process.max-file-descriptor=(priv,65536,deny)” group.dba   #groupadd dba #groupadd oinstall #useradd -g oinstall -G dba -d /export/home/oracle -s /bin/bash -K project=group.dba -m oracle !important! on Solaris 11 you can not explicitly create directoris in /home because of the automount feature. […]

Oracle DB administering

Oracle RDBMS installation

Posted on

Oracle Database 11g Release 2 (11.2.0.2) Installation On Solaris 10 (x86-64) In this article I’ll describe the installation of Oracle Database 11g Release 2 (11.2.0.2) on Solaris 10 (x86-64). The article is based on a default server installation as shown here. Alternative installations may require a different setup procedure. Download Software Unpack Files Hosts File […]

Oracle DB administering

RMAN – разное

Posted on

Если в fast_recovery_area не осталось свободного места и не хочется добавлять дополнительное, можно почистить архивлоги: 1. удаляем файлы архивлогов 2. чистим видимое место crosscheck archivelog all; delete noprompt expired archivelog all; можно не удалять вручную файлы архивлогов, вместо этого команда: DELETE NOPROMPT ARCHIVELOG ALL; Incrementally Updated Backups The following example shows how an incrementally updated […]

Oracle DB administering

Parallel operations in Oracle

Posted on

http://www.akadia.com/services/ora_parallel_processing.html Parallel Features The full list of Oracle parallel execution features currently includes the following Parallel Query Parallel DML Parallel DDL Parallel Data Loading Parallel Recovery Parallel Replication How Parallel Execution Works Operations That Can Be Parallelized Oracle can parallelize operations that involve processing an entire table or an entire partition. These operations include: SQL […]

Oracle DB administering

Партиционирование таблиц

Posted on

Для таблиц с партиционированием по интервалу при попытке удалить первую партицию возникает ошибка: ORA-14758: Last partition in the range section cannot be dropped Чтобы ее обойти можно поступить так: alter table my_table set interval (); alter table my_table drop partition P1 alter table my_table set interval (numtoyminterval(1,’year’));

Oracle DB administering

Установка Enterprise Manager 12c

Posted on

Для активации агента на Solaris SPARC потребовалось установить патч: перед установкой патча необходимо поставить правильный ORACLE_HOME export ORACLE_HOME=/u01/oracle/Middleware/oms и проверить версию opatch /u01/oracle/Middleware/oms/OPatch/opatch lsinventory Добавляем standby database instance как target: http://hongwang.wordpress.com/2012/01/30/grid-control-adding-target-a-standby-database/