User Grid .bash_profile

.bash_profile du User Grid (pour installation ASM).

Connaitre le maximum de sessions autorisés (Oracle)

Lancer cette requete permet de connaitre le nombre maximum de users (1.1 * PROCESSES) + 5) autorisés à se connecter, et de connaitre également le maximum de processes user qui en découlent.

Try this to show info about both:

    select resource_name, current_utilization, max_utilization, limit_value 
    from v$resource_limit 
    where resource_name in ('sessions', 'processes');
exemple :

RESOURCE_NAME CURRENT_UTILIZATION MAX_UTILIZATION LIMIT_VALUE
------------- ------------------- --------------- -----------
processes                      96             309         500
sessions                      104             323         792

Ces deux derniers paramètres ne sont pas modifiables à chaud.

Serveur Dédié ou Serveur Partagé? (Oracle)

Il suffit de regarder du côté du tnsname.ora pour savoir si l'on est en serveur dédié ou partagé :

 

Configurer Oracle en serveur partagé

Passer de Serveur Dédié à Serveur partagé (Oracle)

ORACLE SWITCHING FROM DEDICATED SERVER TO SHARED SERVER (MTS)
By Edward Stoever

oracleasm createdisk failed

http://www.toadworld.com/platforms/oracle/b/weblog/archive/2015/03/15/oracleasm-instantiating-disk-failed

 

Solution:   The ASM error "disk does not exist or is not instantiated" error can be caused by many issues:
    
     - Not disabling SELINUX:

        vi /etc/sysconfig/selinux SELINUX=disabled

        Then reboot your system and run getenforce to confirm that
        SELINUX is disabled:

        root> /usr/sbin/getenforce Disabled

Oracle 11G - Install oracle grid infrastucture 11GR2

http://www.oracle.com/webfolder/technetwork/tutorials/obe/db/11g/r2/prod/install/gridinstss/gridinstss.htm

Oracle 11G - réduire la taille du tablespacec temporaire

SQL> alter tablespace TEMP shrink space keep 1G;

Source.

Réinitialiser le tablespace temporaire

Réinitialiser le TBS TEMP Oracle

Configuration E/S - Oracle

Oracle® Database Performance Tuning Guide
11g Release 2 (11.2)
Part Number E16638-03

Raw device pour Oracle

Using Raw Devices for Oracle Databases

Configure a raw device

1. Configure the desired device in the /etc/sysconfig/rawdevices file:

   /dev/raw/raw1 	/dev/sdb1

2. Start and enable the device by running:

   # service rawdevices start
   # chkconfig rawdevices on

At this point, you could set ownership and permissions with chmod and chown. However, because these devices will be created dynamically at boot time, permissions set in this manner will not persist after a reboot.

 

Creating Oracle database that uses Raw Device option for Storing database files (For RHEL 4 / 3 / 2.1/ CentOS 4 / 3 / 2)

Binding Logical Volumes to the raw devices:

 

I have added the below lines into the /etc/sysconfig/rawdevices and restarted the rawdevices service to bind logical volumes

created in the above steps.

 

/usr/bin/raw /dev/raw/raw11 oracle_vg/lvol0    # test db -- SYSAUX Tablespace
/usr/bin/raw /dev/raw/raw12 oracle_vg/lvol1    # test db -- UNDOTBS1
/usr/bin/raw /dev/raw/raw13 oracle_vg/lvol2    # test db -- TEMP tablespace
/usr/bin/raw /dev/raw/raw14 oracle_vg/lvol3    # test db -- EXAMPLE tablespace
/usr/bin/raw /dev/raw/raw15 oracle_vg/lvol4    # test db -- USERS tablespace
/usr/bin/raw /dev/raw/raw16 oracle_vg/lvol5    # test db -- redo1_1.log
/usr/bin/raw /dev/raw/raw17 oracle_vg/lvol6    # test db -- redo1_2.log
/usr/bin/raw /dev/raw/raw18 oracle_vg/lvol7    # test db -- redo1_3.log
/usr/bin/raw /dev/raw/raw19 oracle_vg/lvol8    # test db -- control1
/usr/bin/raw /dev/raw/raw20 oracle_vg/lvol9    # test db -- control2
/usr/bin/raw /dev/raw/raw21 oracle_vg/lvol10    # test db -- control2	
/usr/bin/raw /dev/raw/raw22 oracle_vg/lvol11    # test db -- spfile
/usr/bin/raw /dev/raw/raw23 oracle_vg/lvol12    # test db -- pwfile
/usr/bin/raw /dev/raw/raw24 oracle_vg/lvol13    # test db -- SYSTEM Tablespace

Also, you need to change the ownership of these devices to oracle user. Raw devices are refreshed with the default
permissions and ownership every time you reboot your system. For this reason, I add these lines to the /etc/rc.local so
that every time machine reboots, this devices are assigned correct ownership/permissionsPlease add the below lines
to the /etc/rc.local

for i in `seq 1 25`
do
chown oracle:dba /dev/raw/raw$i
chmod 600 /dev/raw/raw$i
done