Администрирование
HyperSQL, IBM DB2, IBM DB2, Interbase, Firebird, Yaffil , MSSQL, MySQL, ORACLE, PostgreSQL, SYBASE, Другие, Курсы, ... |
Безопасность
HyperSQL, MSSQL, Oracle, Phpmyadmin, Инъекция SQL, Книги, Патчи, Программы, Скрипты, СУБД, ... |
Проектирование БД
Business intelligence, Data Warehouse, Designer 2000 (Oracle), ErWin, ETL, OLAP, Sybase PowerDesigner , Другие CASE средства, Статьи, Теория БД, ... |
Производительность
DB2, HyperSQL, IBM DB2, Interbase, Firebird, Yaffil, MSSQL, MySQL, ORACLE, PostgreSQL, SQL, SYBASE, Другие, ... |
Установка
HyperSQL, IBM DB2, Interbase, Firebird, Yaffil , MSSQL, MySQL, ORACLE, PostgreSQL, SYBASE, Другие, ... |
|
|
Главная
SYSDBA - Системный администратор баз данных
|
Install -
ORACLE
|
|
Этап 1
Качаем дистрибутив Ubuntu 10 64-bit , можно по этой ссылке , установка и настройка Ubuntu можно почитать в этой статье. После того как установили делаем обновление пакетов #apt-get update
Для дальнейшей установки нам необходимы буду следующие пакеты
build-essential, libaio1, gawk, ksh, libmotif3, alien, libtool, sb-rpm, gcc-multilib, sux, ia32-libs, lib32gcc1, lib32stdc++6 |
|
Подробнее...
|
|
|
Performance -
ORACLE
|
 Starting with Oracle 9i, DBAs can now create locally managed tablespaces.
A Locally Managed TBS manages its own list of free extents in a bitmap block placed inside the header of the first data file of the tablespace. Inside the bitmap block, each bit maps to a free block in the tablespace.
When creating a locally managed tablespace, you can specify the extent allocation method to be used. |
|
Подробнее...
|
|
|
Administration -
ORACLE
|
Steps when the database state is down:
1. Login to sqlplus
-sqlplus /nolog
-connect / as sysdba
2. The db must be mounted EXCLUSIVE and not open for operation
-startup mount;
3. Check the log mode status of the database
-select log_mode from v$database;
4. Setting it to noarchivelog mode
-alter database noarchivelog;
5. Setting db open for user operation
-alter database open;
6. Reverting back to archivelog mode
-alter database archivelog; |
|
Подробнее...
|
|
|
Administration -
ORACLE
|
|
Use this DDL to generate a script to recreate all your permanent tablespaces. Limitations: - Permanent tablespaces only
- Datafiles, not tempfiles, only
- Dictionary managed tablespaces only
This script is also useful when you want to copy a database from one server to another one. A full export/import will reorganize all the tablespaces, so moving, copying, or recreating a database is a great opportunity in terms of space management. There's a problem, though: if the disks on the new server are set up differently from the source server, the full import will fail to create the necessary tablespaces.
|
|
Подробнее...
|
|
|
Administration -
ORACLE
|
Applies to: Oracle Server – Enterprise Edition – Version: 10.2.0.1 to 10.2.0.3 – Release: 10.2 to 10.2
Information in this document applies to any platform. Symptoms The following errors are occurring when starting the instance: ORA-00600: internal error code, arguments: [6006], [1], [], [], [], [], [], [] ORA-00600: internal error code, arguments: [6856], [0], [60], [], [], [] SMON will eventually terminate the instance. |
|
Подробнее...
|
|
| | << [Первая] < [Предыдущая] 1 2 3 4 5 6 7 8 9 10 [Следующая] > [Последняя] >>
| | Результаты 1 - 9 из 143 |
|
Последние добавленные статьи |
|
|
|
|
