Monday, March 14, 2016

Install or upgrade Oracle APEX 5.0.3 for ORACLE DATABASE 12C on Linux

Step 1: Create tablespace create tablespace apex  datafile '/u01/app/oracle/oradata/PTUD/datafile/apex.dbf' size 100M autoextend on next 10M; Step 2: Download Oracle Apex 5.0.3.00.03 from Oracle or My Google Drive http://www.oracle.com/technetwork/developer-tools/apex/downloads/index.html or...

Monday, March 7, 2016

How to create schemas for BI Publisher 11G without RCU

Contents  TOC \o "1-3" \h \z \u Prerequisite. PAGEREF _Toc437265289 \h 3 08D0C9EA79F9BACE118C8200AA004BA90B02000000080000000E0000005F0054006F0063003400330037003200360035003200380039000000 List of tablespaces. PAGEREF _Toc437265290 \h 4 08D0C9EA79F9BACE118C8200AA004BA90B02000000080000000E0000005F0054006F0063003400330037003200360035003200390030000000 ...

Friday, March 4, 2016

How to backup & restore timesten

  My environment OLD Timesten Server New Timesten Server Timesten Home /home/orattadmin/app/TimesTen/tt1121 /u01/app/TimesTen/tt1121 Host VTGDB1.COM VTGDB2.COM User OS orattadmin ...

Install Oracle Timesten step by step

Step 1: Create TimesTen user and groups [root@VTGDB.COM ~]# groupadd timesten [root@VTGDB.COM ~]# groupadd orattadmin [root@VTGDB.COM ~]#  useradd -G orattadmin -g timesten orattadmin [root@VTGDB.COM ~]# id orattadmin uid=1104(orattadmin) gid=1104(timesten)...