Oracle RAC

6 thoughts on “Oracle RAC”

• OLIVIER COMBE says:

  06/10/2020 at 13:27

  Tablespace (with a disk group named “data”):

  -- Create tablespace
  CREATE TABLESPACE test_tablespace DATAFILE '+data';
  
  -- Alter tablespace
  ALTER TABLESPACE test_tablespace
      ADD DATAFILE '+data'  SIZE 200M
        AUTOEXTEND ON
        NEXT 50M
        MAXSIZE UNLIMITED;
  

  Check : https://docs.oracle.com/database/121/OSTMG/GUID-47E5C33B-17E0-4CDC-82AE-D0107269A1BA.htm#OSTMG13950

  Reply
• OLIVIER COMBE says:

  06/10/2020 at 13:30

  SQLPlus to RAC :

  sqlplus "sys/password@(DESCRIPTION = (LOAD_BALANCE=on) (ADDRESS = (PROTOCOL = TCP)(HOST = _HOSTNAME)(PORT = _PORT)) (CONNECT_DATA = (SERVER = DEDICATED)(SERVICE_NAME = _SERVICE_NAME))) as sysdba"
  

  Reply
• OLIVIER COMBE says:

  06/10/2020 at 13:30

  JDBC URL :

  jdbc:oracle:thin@(DESCRIPTION=
     (LOAD_BALANCE=on)
     (ADDRESS=(PROTOCOL=TCP)(HOST=racnode1) (PORT=1521))
     (ADDRESS=(PROTOCOL=TCP)(HOST=racnode2) (PORT=1521))
     (CONNECT_DATA=(SERVICE_NAME=service_name)))
  

  Reply
• OLIVIER COMBE says:

  09/10/2020 at 10:28

  Restart the DB :

  /u01/app/grid/19c/grid/bin/srvctl stop database -d DB_NAME
  /u01/app/grid/19c/grid/bin/srvctl start database -d DB_NAME
  

  Reply
• OLIVIER COMBE says:

  26/10/2020 at 16:48

  Apply a patch on RAC instance :

  https://support.oracle.com/epmos/faces/DocumentDisplay?_afrLoop=122367841169814&id=244241.1&_afrWindowMode=0&_adf.ctrl-state=75ut40kg9_4

  Reply
• OLIVIER COMBE says:

  28/04/2023 at 14:53

  https://alllinuxdba.wordpress.com/2014/08/01/how-to-stop-one-node-in-a-two-node-oracle-rac-cluster/

  Reply