Categories
Blog

UKOUG Business Analytics SIG

I’ll be at the UKOUG Business Analytics SIG on the 12th March Oracle City Office, if you have any questions about accelerating analytics. Get in touch.

Categories
Blog

Database Scripts

I have added some more useful scripts under the database section.

Categories
Blog

Gartner BI Summit 2015

I’m all booked up for the Gartner BI Summit 2015. Looking forward to seeing the winners and losers. Let’s see what they say about Oracle :), come back here on the 9th, where I will share the information.

Categories
Blog

TimesTen import from oracle utility

The other day, someone wanted to place some oracle tables into TimesTen DB for some testing, this is a great quick way:
1)     Make sure you have a connection to your Oracle database in the TimesTen tnsfile, so I have the following in my tnsnames.ora in the following directory (/u01/app/oracle/product/TimesTen/tt1122/network/admin/samples) :
MYDB =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = XXX) (PORT=1521))
(CONNECT_DATA =
(SERVICE_NAME = live)
)
)
2)     Set your environment
TNS_ADMIN=/u01/app/oracle/product/TimesTen/tt1122/network/admin/samples
Export TNS_ADMIN
cd /u01/app/oracle/product/TimesTen/tt1122/ttoracle_home/instantclient_11_2
./sqlplus read/only@mydb
3)     Create a directory to place the files that will be generated for the import, and cd to the directory.
4)     Run the following command:
ttImportFromOracle –oraConn user/oracle@myoracle –tables my_small_tab –typeMap 2,1 –prefix tm1
myoracle = ip:port/service
prefix = prefix for files generated.
5)     Now we shall add the MYDB to the TimesTen settings:
cd /u01/app/oracle/product/TimesTen/tt1122/info
vi sys.odbc.ini
Add the following to your Times Ten Store ours is called TT_AGGR_STORE
[TT_AGGR_STORE]
Driver=/u01/app/oracle/product/fmw/../TimesTen/tt1122/lib/libtten.so
DataStore=/u01/app/oracle/product/fmw/../aggregate_store/tt_aggr_store
LogDir=/u01/app/oracle/product/fmw/../aggregate_store/logs
DatabaseCharacterSet=AL32UTF8
ConnectionCharacterSet=AL32UTF8
LogFileSize=1024
LogBufMB=1024
LogBufParallelism=16
Preallocate=0
PermSize=400000
TempSize=200000
MemoryLock=4
CkptFrequency=30
CkptLogVolume=0
CkptRate=20
PrivateCommands=1
RecoveryThreads=40
oraclenetservicename=MYDB
6)     Restart TimesTen
cd /sbin
./sysctl -p
ttdaemonadmin -stop
ttdaemonadmin -start
7)     In the example below, we are doing the table siebel.wc-KPI_F_041174
[oracle@CIMAlyticsSrv1 TT_INSTALLERS]$  ./ttImportFromOracle -oraConn read/only@8x.2xx.1xx.1x:1521/live -tables siebel.wc_KPI_F_041174 -typeMap 2,1 -prefix ncmp1
Beginning processing
Resolving any tablename wildcards
Eliminating any duplicate tables
Getting metadata from source
Generating database user list
Assigning TimesTen datatypes
Analyzing source tables
Analyzing table ‘SIEBEL.WC_KPI_F_041174’ …
Estimating table sizes
Evaluating parallel data load
Generating output files
Finished processing
 
8)     The following files will be generated:
ncmp1CreateUsers.sql
ncmp1CreateTables.sql
ncmp1LoadData.sql
ncmp1CreateIndexes.sql
ncmp1UpdateStats.sql
9)     Connect to your TimesTen DB and the run the above sql files in the order above:
[oracle@CIMAlyticsSrv1 bin]$ ttisql -connstr “dsn=TT_AGGR_STORE;uid=user;pwd=password;oraclepwd=opassword”
**the opassword is the password to your oracle instance
Command> @/home/oracle/TT_INSTALLERS/ncmp1CreateUsers.sql

..
 
 

Categories
Blog

How to move the OBIEE RCU Database

Recently I had to move the OBIEE RCU Database, click here

Categories
Blog

Oracle BA Summit 2015

At the Oracle Business Analytics summit in London, come to track 1 and hear us talk about how we drive the business using analytics.
Great presentation by Andrew Strauss on how the England cricket team used analytics to analyse the strengths of the team and work on these strengths.

Categories
Blog

Oracle BI Analytics Summit 2015

Make sure you have registered to this year’s event, where I’m sure there will be some in memory analytics discussions: Oracle BI Summit 2015