Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revision Previous revision
Next revision
Previous revision
howto:ora19oln7 [2019/10/07 22:50]
ibk [Monitor Used Space]
howto:ora19oln7 [2020/06/09 06:32] (current)
ibk [Create Virtual Machine]
Line 30: Line 30:
   * Virtual machine name: vmora19   * Virtual machine name: vmora19
   * Location: E:​\VM\vmora19   * Location: E:​\VM\vmora19
-  * Maximum disk size (GB): 120+  * Maximum disk size (GB): 500
   * Store virtual disk as a single file   * Store virtual disk as a single file
   * Customize Hardware   * Customize Hardware
-    * Memory: ​GB+    * Memory: ​GB
     * Processors: 2     * Processors: 2
     * Network Adapter: Bridged     * Network Adapter: Bridged
Line 513: Line 513:
 ==== Create tablespaces in pdb1 ==== ==== Create tablespaces in pdb1 ====
  
-  ​mkdir /u02/oradata/CDB1/PDB1 +You may think it is a good idea to store the tablespaces under the directories /u01 or /u02, also because the oracle docs about "​optimal flexible architecture"​ seem to suggest it. However if you followed this guide, you will see a problem when checking available disk size: 
-  chmod 750 /u02/oradata/CDB1/PDB1+ 
 +  df -h 
 +   
 +  Filesystem ​                  ​Size ​ Used Avail Use% Mounted on 
 +  devtmpfs ​                    ​1.8G ​    ​0 ​ 1.8G   ​0% /dev 
 +  tmpfs                        1.8G  960M  879M  53% /dev/shm 
 +  tmpfs                        1.8G  9.5M  1.8G   1% /run 
 +  tmpfs                        1.8G     ​0 ​ 1.8G   0% /​sys/​fs/​cgroup 
 +  /​dev/​mapper/​ol_vmora19-root ​  ​50G ​  ​28G ​  ​23G ​ 55% / 
 +  /​dev/​sda1 ​                  ​1014M ​ 331M  684M  33% /boot 
 +  /​dev/​mapper/​ol_vmora19-home ​ 445G   ​36G ​ 409G   9% /home 
 +  tmpfs                        368M     ​0 ​ 368M   0% /​run/​user/​54321 
 +  tmpfs                        368M   ​12K ​ 368M   1% /​run/​user/​42 
 + 
 +As you can see /u01 and /u02 reside under /dev/mapper/ol_vmora19-root which is only 50G. Most of the drive space is available however unter /home which is 445G. Therefore I place my tablespaces under /​home/​oracle 
 + 
 +  mkdir /​home/​oracle/​pdb1 
 +  chmod 750 /home/oracle/pdb1
  
   sqlplus / as sysdba   sqlplus / as sysdba
Line 521: Line 538:
  
   ALTER SESSION SET CONTAINER = pdb1;   ALTER SESSION SET CONTAINER = pdb1;
-  CREATE TABLESPACE lu_agrar_dat ​ DATAFILE '/u02/oradata/CDB1/PDB1/​lu_agrar_dat.dbf'​ SIZE 10M  ​AUTOEXTEND ON NEXT 10M+  CREATE TABLESPACE lu_agrar_dat ​ DATAFILE '/home/oracle/pdb1/​lu_agrar_dat.dbf'​ SIZE 100M  ​AUTOEXTEND ON NEXT 100M
-  CREATE TABLESPACE lu_agrar_inx ​ DATAFILE '/u02/oradata/CDB1/PDB1/​lu_agrar_inx.dbf'​ SIZE 10M  ​AUTOEXTEND ON NEXT 10M;+  CREATE TABLESPACE lu_agrar_inx ​ DATAFILE '/home/oracle/pdb1/​lu_agrar_inx.dbf'​ SIZE 100M  ​AUTOEXTEND ON NEXT 100M;
   SELECT TABLESPACE_NAME,​ STATUS, CONTENTS FROM DBA_TABLESPACES;​   SELECT TABLESPACE_NAME,​ STATUS, CONTENTS FROM DBA_TABLESPACES;​
   ​   ​
Line 605: Line 622:
       )       )
     )     )
 +    ​
 +==== Disable Password Expire ====
 +
 +You may vant to disable password expire at least for system and the BPS superuser.
 +
 +As system, check used profiles:
 +<​code>​
 +select profile from DBA_USERS where username = '​SYSTEM';​
 +select profile from DBA_USERS where username = '​LU_AGRAR';​
 +</​code>​
 +
 +Check settings of the profiles, for example the DEFAULT profile:
 +<​code>​
 +select resource_name,​limit from dba_profiles where profile='​DEFAULT';​
 +</​code>​
 +
 +Set to unlimited:
 +<​code>​
 +alter profile DEFAULT limit password_life_time UNLIMITED;
 +</​code>​
 +
 +Unlock a user:
 +<​code>​
 +alter user system identified by ****** account unlock;
 +</​code>​
 +
  
-~~DISCUSSION|Comments and Discussion~~