Some importants notes from Oracle’s documentation: – “… you cannot rename or drop the SYSTEM tablespace or take it offline.” – “As for the SYSTEM tablespace, management of the SYSAUX tablespace requires a higher level of security and you cannot rename or drop it.” Locally Managed Tablespace : Define through the command EXTENT MANAGEMENT LOCAL where you can: – Choose two types of extent management: AUTOALLOCATE: (default) Database manage extents. CREATE TABLESPACE tech01 DATAFILE ‘/u01/app/oracle/oradata/DB/tech01.dbf’ SIZE 100M EXTENT MANAGEMENT LOCAL AUTOALLOCATE ; UNIFORM: You define the size on command…
Month: July 2015
ORA-0131:Insufficient Priviledges Debugging requires Debug connect session system priviledges
To solve this error , you have just to run a grant to the username that you can debugging and try again. SQL> grant debug connect session to username; brunors
Getting Instantiating disk: failed while an attempt to create a disk on OEL 6.3
While an attempt to create a disk, I got the follow error: ” Instantiating disk: failed”. Then, I did the follow steps: vi /etc/selinux/config and change the value selinux=enforcing to disabled. Restart your Operating System. Type it getenforce on prompt to your terminal. Try create the disk again through the command oracleasm createdisk DISK1 /dev/sdb1 Follow the example after the reboot: brunors
ASM 11g Disk Groups Management
Some Views: V$ASM V$ASM_ATTRIBUTE V$ASM_DISK V$ASM_DISKGROUP V$ASM_DISK_STAT V$ASM_FILE V$ASM_OPERATION V$ASM_USER Redundancy level of the disk group: Normal Redundancy: 2-way mirroring by default for most file types and the maximum oracle asm file sizes for disk group is 5.8 TB High Redundancy:3-way mirroring for all files and the maximum oracle asm file sizes for disk group is 3.9 TB. External Redundancy: If you do not want mirroring by Oracle ASM, but for RAID disk and the maximum oracle asm file sizes for disk group is 16 TB. CREATING…
Drop Oracle Database 11g
Drop database by command line $ sqlplus “/as sysdba” SQL> select instance_name, status from v$instance; SQL> shutdown immediate; SQL> startup mount SQL> alter system enable restricted session; SQL> drop database; Drop database by DBCA $cd $ORACLE_HOME/bin $./dbca DBCA-> Click “Delete a Database” -> Select the database name -> Click “Finish” brunors