Backup Full Database 12c Script

Task 1: Preparing to Use the Oracle Suggested Backup Strategy To use the Oracle suggested backup strategy, ensure that:   The database is ARCHIVELOG mode The fast recovery area size is configured, or a default device for storing backups is configured. You have added a database host user to the OSBACKUPUPDBA operating system group, for operating system authentication. Task...

How to drop or truncade all partitions Oracle Database

[oracle@PTUD-VM02-2 oradata]$ more drop_partition_table.sql  SET LINESIZE 32000;SET PAGESIZE 40000;SET LONG 50000; select 'ALTER TABLE '||TABLE_OWNER||'.'||table_name||' DROP PARTITION '||partition_name||';' from dba_tab_partitions; [oracle@PTUD-VM02-2 oradata]$ sqlplus / as sysdba @drop_partition_table.sql >> a.sql & [oracle@PTUD-VM02-2 oradata]$ cat a.sql |...

How to allow a OS user running crontab

[root@PTUD-VM03-1 ~]# more /etc/cron.allow root orac...

Running OLAP Builds to Load Data into Analytical Workspace

Read the document firstly https://docs.oracle.com/cd/E64694_01/CDMIG/E64550-04.pdf This load typically completes in 30-35 minutes. [oracle@PTUD-S07 ~]$ sqlplus ocdm_sample/*********@orcl SQL*Plus: Release 12.1.0.1.0 Production on Thu Dec 3 14:56:25 2015 Copyright (c) 1982, 2013, Oracle.  All rights reserved. Last Successful login time: Thu Dec 03 2015 14:03:22 +07:00 Connected...

How to impdp OCDM_SAMPLE for Oracle Communications Data Model

Step 1: Create tablespace for OCDM_SAMPLE: SQL>  create tablespace DW_OCDM_SAMPLE datafile '/u01/app/oracle/admin/orcl/datafile/DW_OCDM_SAMPLE.dbf' size 100M autoextend on next 10M; Tablespace created. SQL>  create temporary tablespace DW_OCDM_SAMPLE_TEMP tempfile '/u01/app/oracle/admin/orcl/datafile/DW_OCDM_SAMPLE_TEMP.dbf' size 100M autoextend on next 10M; Tablespace...

Limiting User Privileges when you install sample reports

[oracle@PTUD-S07 ~]$ more a.sql  SET LINESIZE 32000; SET PAGESIZE 40000; SET LONG 50000; select 'CREATE OR REPLACE EDITIONABLE SYNONYM OCDM_REPORT.'||Table_Name||' for OCDM_SYS.'||Table_Name||';' from All_Tables where owner='OCDM_SYS'; [oracle@PTUD-S07 ~]$ sqlplus / as sysdba @a.sql >> b.sql & [4] 141981 [oracle@PTUD-S07 ~]$ cat b.sql | grep 'CREATE OR...

Scripts start, stop BI Publisher 11G

Prerequisite: [obiee@PTUD-S07 security]$ pwd /u02/obiee/fmw/user_projects/domains/bifoundation_domain/servers/AdminServer/security [obiee@PTUD-S07 security]$ more boot.properties  #Tue Dec 01 18:38:07 ICT 2015 username=weblogic password=******** [obiee@PTUD-S07 security]$ cd ../.. [obiee@PTUD-S07 servers]$ ls AdminServer  AdminServerTag  bi_server1...

Set JAVA_HOME for user!

[obiee@PTUD-VM01-2 ~]$ cat .bash_profile  # .bash_profile # Get the aliases and functions if [ -f ~/.bashrc ]; then . ~/.bashrc fi # User specific environment and startup programs PATH=$PATH:$HOME/bin export PATH #JAVA_HOME export JAVA_HOME=/u01/obiee/setup/jdk export PATH=$JAVA_HOME/bin:$PATH...