erudans.info

When resolwing locking situations using v$session dynamic view, be careful to not to kill wrong session. As appears, v$session “blocking_session” column reports incorrect sid. To obtain correct value, substract 1 from reported sid.

This is bug  5481650 which is resolved in 10.2.0.4

1. Connect to asm instance:

select name, state, total_mb, free_mb from v$asm_diskgroup;

NAME STATE TOTAL_MB FREE_MB
—————————— ———– ———- ———-
ORADATA MOUNTED 65536 53439

2. Using Grid Control

Go to asm host and select asm instance. Go Administration tab and input asm administration password:

3. Using ASMCMD tool

Please make sure to setup ORACLE_SID and ORACLE_HOME environment variables to ASM instance.

-bash-3.2$ asmcmd -p
ASMCMD [+] > du
Used_MB Mirror_used_MB
12011 12011
ASMCMD [+] >

or run

lsdg command

State    Type    Rebal  Unbal  Sector  Block       AU  Total_MB  Free_MB  Req_mir_free_MB  Usable_file_MB  Offline_disks  Name
MOUNTED  EXTERN  N      N        1024   4096  1048576     40960    37628                0           37628              0  ORADATA/
MOUNTED  EXTERN  N      N        1024   4096  1048576     32768    32675                0           32675              0  ORADATA1/

For DBA. understanding business required for long time. Without this understanding hardly possible to tune application and db right. How to understand what exactly to tune – what is important to business? What backup and recovery strategy to develop? MTTR and MTBF? How company is confident in paying $500K only for oracle database enterprise edition? All this related to dba.

On the other hand, there are still loads of pure technical work to do, for example (what first comes to mind):

• Developing and advancing backup and recovery strategy
• Actual backups testing, restoring and testing
• Different crash scenarios modeling and recovery testing
• Recovery documentation and testing
• Proactive monitoring and analysis
• Moving data between test and development, sensual data scrambling
• Maintaining security, patching, auditing, logs analysis
• New features, new releases, new platforms, docs refresh, etc, etc

All this require time and professionals, and if more integration with business is needed, more resources is needed as well (simply add more resources – Grid Era :) This means, that pure technical DBA certainly will be needed. This is probably area for DBA assistants and regular DBAs. Seniors will probably do more business integration, or delegate this role to separate DBA.

Ставил oracle 10g on Linux (oracle linux 5 64bit). При запуске инсталлера такая ошибка:

bash-3.1$ ./runInstaller
Starting Oracle Universal Installer…No pre-requisite checks found in oraparam.ini, no system pre-requisite checks will be executed.
Preparing to launch Oracle Universal Installer from /tmp/OraInstall2008-02-29_10-43-09AM. Please wait …bash-3.1$ Exception in thread “main” java.lang.UnsatisfiedLinkError: /tmp/OraInstall2008-02-29_10-43-09AM/jre/1.4.2/lib/i386/libawt.so: libXp.so.6: cannot open shared object file: No such file or directory
at java.lang.ClassLoader$NativeLibrary.load(Native Method)
at java.lang.ClassLoader.loadLibrary0(Unknown Source)
at java.lang.ClassLoader.loadLibrary(Unknown Source)
at java.lang.Runtime.loadLibrary0(Unknown Source)
at java.lang.System.loadLibrary(Unknown Source)
at sun.security.action.LoadLibraryAction.run(Unknown Source)
at java.security.AccessController.doPrivileged(Native Method)
at sun.awt.NativeLibLoader.loadLibraries(Unknown Source)
at sun.awt.DebugHelper.<clinit>(Unknown Source)
at java.awt.Component.<clinit>(Unknown Source)

Solution: install 32bit package libXP-1.0.0-8.i386.rpm (check note 443617.1)

Эта ошибка вызвана отсутствием пакета который должен ставится по умолчанию. Такое происходит когда при инсталяции linux, выбирается Custom и лишние пакеты не включаются. Кстати oracle рекомендует (может мягко сказано) выбор типа инсталляции Workstation. Смотрите note 401167.1:

“However, de-selecting any “default RPM” groupings or individual RPMs can result in failed RDBMS installation attempts, and as such, is not supported by Oracle Support Services. “

Расскажу забавный случай инсталляции oracle 10g on linux. Админы поготовили Linux сервер и отдали мне на установку базы. Нужно было ставить 10g 64bit. Запускаю installer все нормально, но в конце установки появляются сообщения что невозможно залинковать объекты, netca тоже не запускается.

Запускаю ntetca в ручную, ошибка:

bash-3.1$ netca

UnsatisfiedLinkError exception loading native library: njni10

java.lang.UnsatisfiedLinkError: jniGetOracleHome

at oracle.net.common.NetGetEnv.jniGetOracleHome(Native Method)

at oracle.net.common.NetGetEnv.getOracleHome(Unknown Source)

at oracle.net.ca.NetCA.main(Unknown Source)

Oracle Net Services configuration failed. The exit code is -1

Нахожу ноту Note:308788.1, не помогает. Проверяем еще раз все ли пакеты поставлены, все на месте, переменные окружения. Тут закрадываетя подозрение, а какая битность линукса? Ну конечно 32bit! Это из раздела – сисадмины шутят

Как определить битность системы? Смотрите Note:469497.1 В кратце выполяем uname -a и смотрим первую строку, правая часть, там должно фигурировать 64, для 64 bit linux.

Solution: Problem caused by installing 64bit oracle software on 32bit os linux.