Thursday, March 3, 2016

How to select columns with null values

Connect with your  schema and run the sql scripts SET LINESIZE 32000; SET PAGESIZE 40000; SET LONG 50000; SELECT t.table_name, t.column_name FROM user_tab_columns t WHERE t.nullable = 'Y' AND t.num_distinct = 0 AND t.table_name='TABLE_NAME'; For example: SET LINESIZE...

How to connect PENTAHO with Oracle Database (12c/11g)

Step 1: Set JAVA environment for PENTAHO My Computer --> Properties( Click right mouse My Computer) --> Advanced system settings --> Environment Variables --> User Variables --> New PENTAHO_JAVA=C:\Program Files\Java\jdk1.7.0_79\jre\bin\java.exe PENTAHO_JAVA_HOME=C:\Program...

Wednesday, March 2, 2016

How to install php 5.5.1.0 on linux

Step 1: Download the software https://drive.google.com/open?id=0B7a3DEnQ0-uzXzlsU04xcGdJN0E   Step 2: Untar the downloaded file [root@VTGDB.COM ~]# tar -xvf oel-dependency-install.tar.gz oel-dependency-install/ oel-dependency-install/dependency-install.sh oel-dependency-install/._libjpeg-turbo-1.2.1-3.el6_5.x86_64.rpm oel-dependency-install/libjpeg-turbo-1.2.1-3.el6_5.x86_64.rpm oel-dependency-install/._openssl-1.0.1e-16.el6_5.x86_64.rpm oel-dependency-install/openssl-1.0.1e-16.el6_5.x86_64.rpm oel-dependency-install/oracle-instantclient12.1-basic-12.1.0.1.0-1.x86_64.rpm oel-dependency-install/oracle-instantclient12.1-sqlplus-12.1.0.1.0-1.x86_64.rpm oel-dependency-install/php55-5.5.10-1.el6.x86_64.rpm oel-dependency-install/php55-bcmath-5.5.10-1.el6.x86_64.rpm oel-dependency-install/php55-cli-5.5.10-1.el6.x86_64.rpm oel-dependency-install/php55-common-5.5.10-1.el6.x86_64.rpm oel-dependency-install/php55-dba-5.5.10-1.el6.x86_64.rpm oel-dependency-install/php55-fpm-5.5.10-1.el6.x86_64.rpm oel-dependency-install/php55-gd-5.5.10-1.el6.x86_64.rpm oel-dependency-install/php55-intl-5.5.10-1.el6.x86_64.rpm oel-dependency-install/php55-ldap-5.5.10-1.el6.x86_64.rpm oel-dependency-install/php55-mbstring-5.5.10-1.el6.x86_64.rpm oel-dependency-install/php55-mysql-5.5.10-1.el6.x86_64.rpm oel-dependency-install/php55-oci8-12cR1-5.5.10-2.el6.x86_64.rpm oel-dependency-install/php55-opcache-5.5.10-1.el6.x86_64.rpm oel-dependency-install/php55-pdo-5.5.10-1.el6.x86_64.rpm oel-dependency-install/php55-xml-5.5.10-1.el6.x86_64.rpm Step...

Tuesday, March 1, 2016

Setting up an Active Standby Timesten

Active Standby Server: 192.168.2.149(vtgptudserver) Data Store: master1 Installing Directory:/u01/app/TimesTen/tt1121 Port's Daemon: 53396 Port TCP/IP Server TimesTen listen on: 53397 Server: 192.168.2.133 ( PTUDServer3) Data Store:...

Monday, February 29, 2016

Example Creating tablespace in Oracle Database.

Create undo tablespace: create undo tablespace undotbs2 datafile '/u01/app/oracle/oradata/ORCL/datafile/undotbs2.dbf' size 100M autoextend on next 10M; Create tablespace: create tablespace BOC datafile '/u01/app/oracle/oradata/ORCL/datafile/BOC.dbf'...

Wednesday, February 24, 2016

Displaying Backup Information Oracle Database

[oracle@VTGDB-Server app]$ sqlplus / as sysdba SQL*Plus: Release 12.1.0.1.0 Production on Thu Feb 25 13:56:15 2016 Copyright (c) 1982, 2013, Oracle.  All rights reserved. Connected to: Oracle Database 12c Enterprise Edition Release 12.1.0.1.0 - 64bit Production With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options SQL> select session_key,...