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...

Granting select privilege for owner' all tables to others

[oracle@PTUD-S07 ~]$ cat a.sql select 'GRANT SELECT ON OCDM_SYS.'||Table_Name||' TO OCDM_REPORT;' from All_Tables where owner='OCDM_SYS'; [oracle@PTUD-S07 ~]$ sqlplus / as sysdba @a.sql >> b.sql & [3] 28402 [oracle@PTUD-S07 ~]$ cat b.sql | grep 'GRANT SELECT ON' >> c.sql [oracle@PTUD-S07 ~]$ sqlplus / as sysdba @c.sql ...

Resize your Oracle datafiles down to the minimum without ORA-03297

Read it: http://blog.dbi-services.com/resize-your-oracle-datafiles-down-to-the-minimum-without-ora-03297/ set linesize 1000 pagesize 0 feedback off trimspool on with  hwm as (   -- get highest block id from each datafiles ( from x$ktfbue as we don't need all joins from dba_extents )   select /*+ materialize */ ktfbuesegtsn ts#,ktfbuefno relative_fno,max(ktfbuebno+ktfbueblks-1)...

How to vncviewer with your size

$ vncserver -geometry 1920x108...

Find users belongs to tablespace

select distinct owner from dba_segments where tablespace_name='DATA201502'; OWNER ------------------------------ CC_OWNER CM_POS2 PAYMENT VT_IT_TC_KM PRIVILEGE_OWNER MEDIATION BCCS_GW QLKD_BD 8 rows selected. ...

TABLESPACE USAGE

select a.TABLESPACE_NAME, a.BYTES bytes_used, b.BYTES bytes_free, b.largest, round(((a.BYTES-b.BYTES)/a.BYTES)*100,2) percent_used from ( select TABLESPACE_NAME, sum(BYTES) BYTES from dba_data_files group by TABLESPACE_NAME ) a, ( select TABLESPACE_NAME, sum(BYTES) BYTES , max(BYTES) largest from dba_free_space group by TABLESPACE_NAME ...

How to see files'size and sort them on one folder Linux

[oracle@PTUD-VM02-2 datafile]$ ls --reverse --sort=size  -sh ...

How to backup, restore BI Publisher 11G

Backup Backup Fusion Middleware Directory For Example: [oracle@App1 fmw]$ cd /u01/app [oracle@App1 app]$ ls backup  fmw  obiee_home  oracle  p6 [oracle@App1 app]$ cp -R fmw/ fmw_bak Backup Database: Contact DBA to do that. Backup 2 schemas (For Example: dev_biplatform, dev_mps) which created by RCU. Restore Restore Fusion...

How to switch from ‘Oracle Fusion Middleware’ to ‘Bi Publisher Security’

Prerequisite: Backup Your Fusion Middleware directory home. [rms_bi_vtg@BI-VTG-02 ~]$ cp -R fmw/ fmw_bak Backup Catalog Folder. Step by Step: Step 1: Access Oracle BI Publisher Enterprise via Web Browser http://YOUR_IP_SERVER:9704/xmlpserver ...

Starting, Stopping Services BI Publisher 11g

Starting, Stopping Services Starting Services: Step 1: Starting Admin Server: [oracle@App1 fmw]$ cd user_projects/domains/bifoundation_domain/ [oracle@App1 bifoundation_domain]$ pwd /u01/app/fmw/user_projects/domains/bifoundation_domain [oracle@App1 bifoundation_domain]$ ./startWebLogic.sh … Enter username to boot WebLogic server:weblogic Enter password...

BI Publisher Installation

Read more: https://drive.google.com/open?id=0B7a3DEnQ0-uzblN3Ylo1N3g1...

P6 EPPM R15.1 INSTALLATION AND CONFIGURATION CHECKLIST

Outline: Table of Contents  TOC \o "1-3" \h \z \u Install and configure Single Sign-On Checklist PAGEREF _Toc434224586 \h 3 08D0C9EA79F9BACE118C8200AA004BA90B02000000080000000E0000005F0054006F0063003400330034003200320034003500380036000000 Pre-Installation Checklist:...