Oracle DBA Forum  

Вернуться   Oracle DBA Forum > Clustering | High Ability > Oracle > Real Application Clusters (RAC)

Ответ
 
Опции темы Опции просмотра
  #11  
Старый 09.03.2011, 15:59
Marley Marley вне форума
Senior Member
 
Регистрация: 19.09.2009
Сообщений: 7,385
По умолчанию

Копируем дистрибутивы clusterware, database, patch на ноду 1 в каталог $HOME


[[email protected] oracle10]# chmod 777 10201_clusterware_linux_x86_64.cpio.gz
[[email protected] oracle10]# chmod 777 10201_database_linux_x86_64.cpio.gz
[[email protected] oracle10]# chmod 777 p8202632_10205_Linux-x86-64.zip


su - oracle10


// извлекаем архивы
[[email protected] ~]$ gunzip 10201_clusterware_linux_x86_64.cpio.gz
[[email protected] ~]$ gunzip 10201_database_linux_x86_64.cpio.gz
[[email protected] ~]$ unzip p8202632_10205_Linux-x86-64.zip

// извлекаем данные из файлов cpio
[[email protected] ~]$ cpio -ivdm < 10201_clusterware_linux_x86_64.cpio
[[email protected] ~]$ cpio -ivdm < 10201_database_linux_x86_64.cpio


// Удаляем файлы архивов
[[email protected] ~]$ rm -f 10201_clusterware_linux_x86_64.cpio
[[email protected] ~]$ rm -f 10201_database_linux_x86_64.cpio
[[email protected] ~]$ rm -f p8202632_10205_Linux-x86-64.zip

-----------------------------------


// Назначаев владельца и прав на каталоги /u01 и /u02 на всех нодах кластера

su -

{
chown -R oracle10:oinstall /u01
chmod -R 775 /u01

chown -R oracle10:oinstall /u02
chmod -R 775 /u02
}


-----------------------------------
// Необходимо перезагрузить все машины перед инсталляцией
# reboot
-----------------------------------


Проверка конфигурации кластера


Скачайте с сайта oracle «Oracle Cluster Verification Utility»
http://www.oracle.com/technetwork/da...ge-099973.html

Проверьте правильность конфигурации подготовленных кластерных нод. Для этого выполните команду:

$ ./runcluvfy.sh stage -pre crsinst -n rac1,rac2 -verbose

Выходное сообщение может подсказать о каких-либо проблемах.
__________________
Чат форума (требуется аккаунт на github или twitter)

Последний раз редактировалось Marley; 19.03.2011 в 13:01.
Ответить с цитированием
  #12  
Старый 09.03.2011, 16:02
Marley Marley вне форума
Senior Member
 
Регистрация: 19.09.2009
Сообщений: 7,385
По умолчанию

Инсталляция clusterware

// Убедитесь, что на нодах кластера отсутствует файл.
// Если файл есть, удалите его

rm /etc/oraInst.loc


unset ORACLE_BASE ORACLE_HOME ORACLE_SID ORA_CRS_HOME ORACLE_UNQNAME ORACLE_OWNER

[[email protected] ~]$ cd $HOME/clusterware

[[email protected] clusterware]$ ./runInstaller

если необходимо преодолеть возникающие ошибки.

[[email protected] clusterware]$ ./runInstaller -ignoresysprereqs


Код:
********************************************************************************

Please run the script rootpre.sh as root on all machines/nodes. The script can be found at the toplevel of the CD or stage-area. Once you have run the script, please type Y to proceed

Answer 'y' if root has run 'rootpre.sh' so you can proceed with Oracle Clusterware installation.
Answer 'n' to abort installation and then ask root to run 'rootpre.sh'.

********************************************************************************

Has 'rootpre.sh' been run by root? [y/n] (n)
y

Starting Oracle Universal Installer...

Checking installer requirements...

Checking operating system version: must be redhat-3, SuSE-9, redhat-4, UnitedLinux-1.0, asianux-1 or asianux-2
                                      Failed <<<<


>>> Ignoring required pre-requisite failures. Continuing...

Preparing to launch Oracle Universal Installer from /tmp/OraInstall2011-03-09_10-55-05PM. Please wait ...[[email protected] clusterware]$ Oracle Universal Installer, Version 10.2.0.1.0 Production
Copyright (C) 1999, 2005, Oracle. All rights reserved.




/u01/app/oracle/oraInventory




crs
/u01/app/oracle/product/10.2.0/crs








Код:
Checking operating system requirements ...
Expected result: One of redhat-3,redhat-4,SuSE-9
Actual Result: redhat-4
Check complete. The overall result of this check is: Passed
=======================================================================

Checking operating system package requirements ...
Checking for make-3.79; found make-1:3.81-3.el5.	Passed
Checking for binutils-2.15; found binutils-2.17.50.0.6-14.el5.	Passed
Checking for gcc-3.2; found gcc-4.1.2-48.el5.	Passed
Check complete. The overall result of this check is: Passed
=======================================================================

Checking physical memory requirements ...
Expected result: 922MB
Actual Result: 2008MB
Check complete. The overall result of this check is: Passed
=======================================================================

Checking for Oracle Home incompatibilities ....
Actual Result: NEW_HOME
Check complete. The overall result of this check is: Passed
=======================================================================

Checking Oracle Home path for spaces...
Check complete. The overall result of this check is: Passed
=======================================================================

Checking local Cluster Synchronization Services (CSS) status ...
Check complete. The overall result of this check is: Passed
=======================================================================

Checking whether Oracle 9.2 RAC is available on all selected nodes
Check complete. The overall result of this check is: Passed
=======================================================================

















/u02/oradata/ocr




/u02/oradata/voting_disk











При инсталляции Clusterware в Linux на архитектуре x86_64 возникают ошибки.


Код:
Oracle CRS stack installed and running under init(1M)
Running vipca(silent) for configuring nodeapps
/u01/app/oracle/product/10.2.0/crs/jdk/jre//bin/java: error while loading shared libraries: libpthread.so.0: cannot open shared object file: No such file or directory

Более подробно ошибка описана на Oracle Metalink (10gR2 RAC Install issues on Oracle EL5 or RHEL5 or SLES10 (VIPCA / SRVCTL / OUI Failures) Doc ID: Note:414163.1)

Для предотвращения ее появления, внесите изменения в скрипты vipca и srvctl на всех нодах кластера.

# cd /u01/app/oracle/product/10.2.0/crs/bin/

// Делаем резервные копии редактируемых файлов
# cp vipca vipca.bkp
# cp srvctl srvctl.bkp


Внесите изменения в скрипт vipca на всех нодах кластера

# vi vipca

1) Укажите значение параметра JREDIR согласно, расположения установленного ранее JDK

Код:
# External Directory Variables set by the Installer
#JREDIR=/u01/app/oracle/product/10.2.0/crs/jdk/jre/
JREDIR=/opt/jdk/jre

2) Замените блок кода начинающийся #Remove this workaround when the bug 3937317 is fixed и заканчивающийся на #End workaround

на

Код:
#Remove this workaround when the bug 3937317 is fixed
arch=`uname -m`
if [ "$arch" = "i686" -o "$arch" = "ia64" -o "$arch" = "x86_64" ]
then
LD_ASSUME_KERNEL=2.4.19
export LD_ASSUME_KERNEL
fi

unset LD_ASSUME_KERNEL

#End workaround
=========================

Замените блок кода начинающийся #Remove this workaround when the bug 3937317 is fixed

# vi srvctl

меняем на

Код:
#Remove this workaround when the bug 3937317 is fixed
LD_ASSUME_KERNEL=2.4.19
export LD_ASSUME_KERNEL
unset LD_ASSUME_KERNEL

=========================



Скрипты должны прогоняться строго по очереди начиная с первого узла. Перед прогоном очередного нужно дождаться завершения предыдущего. Сначала выполняем orainstRoot.sh затем выполняем root.sh. Скрипт root.sh настраивает систему для запуска сервисов Oracle Clusterware (добавляет службы в /etc/inittab) и поднимает эти службы. Первый запуск этого скрипта инициирует файл реестра и кворума (OCR, Voting Disk). После того как, выполним root.sh на второй ноде, необходимо будет запустить программу vipca. О необходимости запуска vipca, будет указано вы выводе скрипта root.sh.


[[email protected] ~]# /u01/app/oracle/oraInventory/orainstRoot.sh

Код:
Changing permissions of /u01/app/oracle/oraInventory to 770.
Changing groupname of /u01/app/oracle/oraInventory to oinstall.
The execution of the script is complete


[[email protected] ~]# /u01/app/oracle/product/10.2.0/crs/root.sh

Код:
WARNING: directory '/u01/app/oracle/product/10.2.0' is not owned by root
WARNING: directory '/u01/app/oracle/product' is not owned by root
WARNING: directory '/u01/app/oracle' is not owned by root
WARNING: directory '/u01/app' is not owned by root
WARNING: directory '/u01' is not owned by root
Checking to see if Oracle CRS stack is already configured
/etc/oracle does not exist. Creating it now.

Setting the permissions on OCR backup directory
Setting up NS directories
Oracle Cluster Registry configuration upgraded successfully
WARNING: directory '/u01/app/oracle/product/10.2.0' is not owned by root
WARNING: directory '/u01/app/oracle/product' is not owned by root
WARNING: directory '/u01/app/oracle' is not owned by root
WARNING: directory '/u01/app' is not owned by root
WARNING: directory '/u01' is not owned by root
Successfully accumulated necessary OCR keys.
Using ports: CSS=49895 CRS=49896 EVMC=49898 and EVMR=49897.
node <nodenumber>: <nodename> <private interconnect name> <hostname>
node 1: rac1 rac1-priv rac1
node 2: rac2 rac2-priv rac2
Creating OCR keys for user 'root', privgrp 'root'..
Operation successful.
Now formatting voting device: /u02/oradata/voting_disk
Format of 1 voting devices complete.
Startup will be queued to init within 90 seconds.
Adding daemons to inittab
Expecting the CRS daemons to be up within 600 seconds.
CSS is active on these nodes.
        rac2
CSS is inactive on these nodes.
        rac1
Local node checking complete.
Run root.sh on remaining nodes to start CRS daemons.
--------

Теперь на другой ноде

[[email protected] ~]# /u01/app/oracle/oraInventory/orainstRoot.sh
[[email protected] ~]# /u01/app/oracle/product/10.2.0/crs/root.sh

Код:
WARNING: directory '/u01/app/oracle/product/10.2.0' is not owned by root
WARNING: directory '/u01/app/oracle/product' is not owned by root
WARNING: directory '/u01/app/oracle' is not owned by root
WARNING: directory '/u01/app' is not owned by root
WARNING: directory '/u01' is not owned by root
Checking to see if Oracle CRS stack is already configured
/etc/oracle does not exist. Creating it now.

Setting the permissions on OCR backup directory
Setting up NS directories
Oracle Cluster Registry configuration upgraded successfully
WARNING: directory '/u01/app/oracle/product/10.2.0' is not owned by root
WARNING: directory '/u01/app/oracle/product' is not owned by root
WARNING: directory '/u01/app/oracle' is not owned by root
WARNING: directory '/u01/app' is not owned by root
WARNING: directory '/u01' is not owned by root
clscfg: EXISTING configuration version 3 detected.
clscfg: version 3 is 10G Release 2.
Successfully accumulated necessary OCR keys.
Using ports: CSS=49895 CRS=49896 EVMC=49898 and EVMR=49897.
node <nodenumber>: <nodename> <private interconnect name> <hostname>
node 1: rac1 rac1-priv rac1
node 2: rac2 rac2-priv rac2
clscfg: Arguments check out successfully.

NO KEYS WERE WRITTEN. Supply -force parameter to override.
-force is destructive and will destroy any previous cluster
configuration.
Oracle Cluster Registry for cluster has already been initialized
Startup will be queued to init within 90 seconds.
Adding daemons to inittab
Expecting the CRS daemons to be up within 600 seconds.
CSS is active on these nodes.
        rac1
        rac2
CSS is active on all nodes.
Waiting for the Oracle CRSD and EVMD to start
Oracle CRS stack installed and running under init(1M)
Running vipca(silent) for configuring nodeapps
The given interface(s), "eth0" is not public. Public interfaces should be used to configure virtual IPs.


==================

Код:
Running vipca(silent) for configuring nodeapps
The given interface(s), "eth0" is not public. Public interfaces should be used to configure virtual IPs.

[[email protected] bin]# cd /u01/app/oracle/product/10.2.0/crs/bin/
[[email protected] bin]# ./oifcfg iflist

Код:
eth0  192.168.1.0
eth1  192.168.2.0
eth2  192.168.3.0
[[email protected] bin]# ./oifcfg setif -global eth0/192.168.10.0ublic
[[email protected] bin]# ./oifcfg setif -global eth1/192.168.11.0:cluster_interconnect
[[email protected] bin]# ./oifcfg getif

Код:
eth0  192.168.10.0  global  public
eth1  192.168.11.0  global  cluster_interconnect

[[email protected]]# cd /u01/app/oracle/product/10.2.0/crs/bin/
[[email protected]]# ./vipca







Нужно указать rac2-vip без localdomain











__________________
Чат форума (требуется аккаунт на github или twitter)

Последний раз редактировалось Marley; 22.03.2011 в 13:19.
Ответить с цитированием
  #13  
Старый 09.03.2011, 16:23
Marley Marley вне форума
Senior Member
 
Регистрация: 19.09.2009
Сообщений: 7,385
По умолчанию

Обновляем clusterware

[[email protected] /]# su - oracle10

unset ORACLE_BASE ORACLE_HOME ORACLE_SID ORA_CRS_HOME ORACLE_UNQNAME ORACLE_OWNER

[[email protected] clusterware]$ cd /home/oracle10/Disk1
[[email protected] Disk1]$ ./runInstaller




crs
/u01/app/oracle/product/10.2.0/crs









Код:
Checking Oracle Clusterware version ...
Check complete. The overall result of this check is: Passed
=======================================================================

Checking operating system requirements ...
Expected result: One of redhat-6,redhat-5,redhat-4,redhat-3,SuSE-11,SuSE-10,SuSE-9,asianux-3,asianux-2,asianux-1
Actual Result: redhat-5
Check complete. The overall result of this check is: Passed
=======================================================================

Checking operating system package requirements ...
Checking for make-3.81; found make-1:3.81-3.el5.	Passed
Checking for binutils-2.17.50.0.6; found binutils-2.17.50.0.6-14.el5.	Passed
Checking for gcc-4.1.1; found gcc-4.1.2-48.el5.	Passed
Checking for libaio-0.3.106; found libaio-0.3.106-5.	Passed
Checking for libstdc++-4.1.1; found libstdc++-4.1.2-48.el5.	Passed
Check complete. The overall result of this check is: Passed
=======================================================================

Checking kernel parameters
Checking for semmsl=250; found semmsl=250.	Passed
Checking for semmns=32000; found semmns=32000.	Passed
Checking for semopm=100; found semopm=100.	Passed
Checking for semmni=128; found semmni=128.	Passed
Checking for shmmax=1073741824; found shmmax=8589934592.	Passed
Checking for shmmni=4096; found shmmni=4096.	Passed
Checking for shmall=2097152; found shmall=4194304.	Passed
Checking for file-max=101365; found file-max=6815744.	Passed
Checking for VERSION=2.6.18; found VERSION=2.6.18-194.el5.	Passed
Checking for ip_local_port_range=9000 - 65500; found ip_local_port_range=20000 - 65500.	Failed <<<<
Checking for rmem_default=1048576; found rmem_default=262144.	Failed <<<<
Checking for rmem_max=1048576; found rmem_max=4194304.	Passed
Checking for wmem_default=262144; found wmem_default=262144.	Passed
Checking for wmem_max=262144; found wmem_max=1048586.	Passed
Check complete. The overall result of this check is: Failed <<<<
Problem: The kernel parameters do not meet the minimum requirements (see above).
Recommendation: Perform operating system specific instructions to update the kernel parameters.
=======================================================================

Checking Recommended glibc version
Expected result: ATLEAST=2.5-12 NOT_EQUALS=2.5-18 
Actual Result: 2.5-49
Check complete. The overall result of this check is: Passed
=======================================================================

Checking physical memory requirements ...
Expected result: 922MB
Actual Result: 2008MB
Check complete. The overall result of this check is: Passed
=======================================================================

Checking available swap space requirements ...
Expected result: 3012MB
Actual Result: 4094MB
Check complete. The overall result of this check is: Passed
=======================================================================

Checking the Components installed in Oracle Home
Check complete. The overall result of this check is: Passed
=======================================================================

Checking for Oracle Home incompatibilities ...
Check complete. The overall result of this check is: Passed
=======================================================================









[[email protected] ~]# /u01/app/oracle/product/10.2.0/crs/bin/crsctl stop crs

Код:
Stopping resources.
Successfully stopped CRS resources
Stopping CSSD.
Shutting down CSS daemon.
Shutdown request successfully issued.

[[email protected] ~]# /u01/app/oracle/product/10.2.0/crs/install/root102.sh

Код:
Creating pre-patch directory for saving pre-patch clusterware files
Completed patching clusterware files to /u01/app/oracle/product/10.2.0/crs
Relinking some shared libraries.
Relinking of patched files is complete.
WARNING: directory '/u01/app/oracle/product/10.2.0' is not owned by root
WARNING: directory '/u01/app/oracle/product' is not owned by root
WARNING: directory '/u01/app/oracle' is not owned by root
WARNING: directory '/u01/app' is not owned by root
WARNING: directory '/u01' is not owned by root
Preparing to recopy patched init and RC scripts.
Recopying init and RC scripts.
Startup will be queued to init within 30 seconds.
Starting up the CRS daemons.
Waiting for the patched CRS daemons to start.
  This may take a while on some systems.
.
10205 patch successfully applied.
clscfg: EXISTING configuration version 3 detected.
clscfg: version 3 is 10G Release 2.
Successfully deleted 1 values from OCR.
Successfully deleted 1 keys from OCR.
Successfully accumulated necessary OCR keys.
Using ports: CSS=49895 CRS=49896 EVMC=49898 and EVMR=49897.
node <nodenumber>: <nodename> <private interconnect name> <hostname>
node 2: rac2 rac2-priv rac2
Creating OCR keys for user 'root', privgrp 'root'..
Operation successful.
clscfg -upgrade completed successfully
Creating '/u01/app/oracle/product/10.2.0/crs/install/paramfile.crs' with data used for CRS configuration
Setting CRS configuration values in /u01/app/oracle/product/10.2.0/crs/install/paramfile.crs

// Теперь выполняем эти операции на второй ноде
[[email protected] bin]# /u01/app/oracle/product/10.2.0/crs/bin/crsctl stop crs
[[email protected] bin]# /u01/app/oracle/product/10.2.0/crs/install/root102.sh

Код:
Creating pre-patch directory for saving pre-patch clusterware files
Completed patching clusterware files to /u01/app/oracle/product/10.2.0/crs
Relinking some shared libraries.
Relinking of patched files is complete.
WARNING: directory '/u01/app/oracle/product/10.2.0' is not owned by root
WARNING: directory '/u01/app/oracle/product' is not owned by root
WARNING: directory '/u01/app/oracle' is not owned by root
WARNING: directory '/u01/app' is not owned by root
WARNING: directory '/u01' is not owned by root
Preparing to recopy patched init and RC scripts.
Recopying init and RC scripts.
Startup will be queued to init within 30 seconds.
Starting up the CRS daemons.
Waiting for the patched CRS daemons to start.
  This may take a while on some systems.
.
10205 patch successfully applied.
clscfg: EXISTING configuration version 3 detected.
clscfg: version 3 is 10G Release 2.
Successfully deleted 1 values from OCR.
Successfully deleted 1 keys from OCR.
Successfully accumulated necessary OCR keys.
Using ports: CSS=49895 CRS=49896 EVMC=49898 and EVMR=49897.
node <nodenumber>: <nodename> <private interconnect name> <hostname>
node 1: rac1 rac1-priv rac1
Creating OCR keys for user 'root', privgrp 'root'..
Operation successful.
clscfg -upgrade completed successfully
Creating '/u01/app/oracle/product/10.2.0/crs/install/paramfile.crs' with data used for CRS configuration
Setting CRS configuration values in /u01/app/oracle/product/10.2.0/crs/install/paramfile.crs
__________________
Чат форума (требуется аккаунт на github или twitter)

Последний раз редактировалось Marley; 19.03.2011 в 12:58.
Ответить с цитированием
  #14  
Старый 09.03.2011, 17:00
Marley Marley вне форума
Senior Member
 
Регистрация: 19.09.2009
Сообщений: 7,385
По умолчанию

Устанавливаем database software

[[email protected] /]# su - oracle10

unset ORACLE_BASE ORACLE_HOME ORACLE_SID ORA_CRS_HOME ORACLE_UNQNAME ORACLE_OWNER

[[email protected] ~]$ cd /home/oracle10/database
[[email protected] database]$ ./runInstaller








db_1
/u01/app/oracle/product/10.2.0/db_1























[[email protected] ~]# /u01/app/oracle/product/10.2.0/db_1/root.sh

Код:
Running Oracle10 root.sh script...

The following environment variables are set as:
    ORACLE_OWNER= oracle10
    ORACLE_HOME=  /u01/app/oracle/product/10.2.0/db_1

Enter the full pathname of the local bin directory: [/usr/local/bin]: [Enter]
   Copying dbhome to /usr/local/bin ...
   Copying oraenv to /usr/local/bin ...
   Copying coraenv to /usr/local/bin ...


Creating /etc/oratab file...
Entries will be added to the /etc/oratab file as needed by
Database Configuration Assistant when a database is created
Finished running generic part of root.sh script.
Now product-specific root actions will be performed.

// Повторить на остальных нодах кластера
[[email protected] ~]# /home/oracle10/oracle/product/10.2.0/db_1/root.sh




__________________
Чат форума (требуется аккаунт на github или twitter)

Последний раз редактировалось Marley; 19.03.2011 в 12:58.
Ответить с цитированием
  #15  
Старый 10.03.2011, 00:19
Marley Marley вне форума
Senior Member
 
Регистрация: 19.09.2009
Сообщений: 7,385
По умолчанию

Обновляем database software

[[email protected] /]# su - oracle10

unset ORACLE_BASE ORACLE_HOME ORACLE_SID ORA_CRS_HOME ORACLE_UNQNAME ORACLE_OWNER

[[email protected] ~]$ cd /home/oracle10/Disk1
[[email protected] Disk1]$ ./runInstaller





db_1
/u01/app/oracle/product/10.2.0/db_1




















[[email protected] ~]# /u01/app/oracle/product/10.2.0/db_1/root.sh

Код:
Running Oracle 10g root.sh script...

The following environment variables are set as:
    ORACLE_OWNER= oracle10
    ORACLE_HOME=  /u01/app/oracle/product/10.2.0/db_1

Enter the full pathname of the local bin directory: [/usr/local/bin]: Enter
The file "dbhome" already exists in /usr/local/bin.  Overwrite it? (y/n)
[n]: y
   Copying dbhome to /usr/local/bin ...
The file "oraenv" already exists in /usr/local/bin.  Overwrite it? (y/n)
[n]: y
   Copying oraenv to /usr/local/bin ...
The file "coraenv" already exists in /usr/local/bin.  Overwrite it? (y/n)
[n]: y
   Copying coraenv to /usr/local/bin ...

Entries will be added to the /etc/oratab file as needed by
Database Configuration Assistant when a database is created
Finished running generic part of root.sh script.
Now product-specific root actions will be performed.

[[email protected] ~]# /u01/app/oracle/product/10.2.0/db_1/root.sh



__________________
Чат форума (требуется аккаунт на github или twitter)

Последний раз редактировалось Marley; 19.03.2011 в 12:58.
Ответить с цитированием
  #16  
Старый 10.03.2011, 01:21
Marley Marley вне форума
Senior Member
 
Регистрация: 19.09.2009
Сообщений: 7,385
По умолчанию

Настраиваем listener

[[email protected] ~]# su - oracle10

[[email protected] db_1]$ netca



















Код:
Oracle Net Services Configuration:
Configuring Listener:LISTENER
Default local naming configuration complete.
rac1...
rac2...
Listener configuration complete.
Oracle Net Services configuration successful. The exit code is 0
__________________
Чат форума (требуется аккаунт на github или twitter)

Последний раз редактировалось Marley; 19.03.2011 в 12:58.
Ответить с цитированием
  #17  
Старый 19.03.2011, 12:56
Marley Marley вне форума
Senior Member
 
Регистрация: 19.09.2009
Сообщений: 7,385
По умолчанию

Развертываем базу данных


unset ORACLE_BASE ORACLE_HOME ORACLE_SID ORA_CRS_HOME ORACLE_UNQNAME ORACLE_OWNER

[[email protected] ~]$ dbca


















/u02/oradata
























Лучше установить везде галочки.









__________________
Чат форума (требуется аккаунт на github или twitter)

Последний раз редактировалось Marley; 22.03.2011 в 13:08.
Ответить с цитированием
  #18  
Старый 19.03.2011, 12:56
Marley Marley вне форума
Senior Member
 
Регистрация: 19.09.2009
Сообщений: 7,385
По умолчанию

SELECT * FROM v$active_instances;

Код:
INST_NUMBER            INST_NAME                                                    
---------------------- ------------------------------------------------------------ 
1                      rac1.localdomain:orcl1                                       
2                      rac2.localdomain:orcl2



__________________
Чат форума (требуется аккаунт на github или twitter)
Ответить с цитированием
  #19  
Старый 19.03.2011, 22:23
cma1kep cma1kep вне форума
Junior Member
 
Регистрация: 19.03.2011
Сообщений: 1
Thumbs up

Marley

Спасибо большое за статью! Очень сильно помогла в начальном познании Оракла.

Было бы замечательно, если дополнить статью описанием добавления третьей ноды в кластер.

Респект и уважение.
Ответить с цитированием
  #20  
Старый 22.03.2011, 13:17
Marley Marley вне форума
Senior Member
 
Регистрация: 19.09.2009
Сообщений: 7,385
По умолчанию

Я думаю, что попозже добавлю добавление/удаление нод кластера.
__________________
Чат форума (требуется аккаунт на github или twitter)
Ответить с цитированием
Ответ

Метки
nfs, oel5.5, oracle database, rac, real application cluster 10g

Опции темы
Опции просмотра

Ваши права в разделе
Вы не можете создавать новые темы
Вы не можете отвечать в темах
Вы не можете прикреплять вложения
Вы не можете редактировать свои сообщения

BB коды Вкл.
Смайлы Вкл.
[IMG] код Вкл.
HTML код Выкл.

Быстрый переход


Текущее время: 17:19. Часовой пояс GMT +3.


Powered by vBulletin®