Search This Blog

Friday, 1 March, 2019

Moved to Wordpress

Hi All,

Moved this blog to WordPress here.

Saturday, 4 June, 2016

Unsecure Access(Over HTTP) to Oracle 11g Enterprise Manager console

I am posting after a gap of almost 3 years...

Recently I had setup Oracle 11g and tried to access the Enterprise Manager console from my preferred browser Waterfox. To my surprise, Waterfox complained that Oracle EM Console cannot be opened up due to a outdated security certificate issue!!

I did a bit of searching around (googling!!) and found the SSL security certificate that comes with Oracle 11g EM Console is no longed supported by the latest browsers and hence the complaining.

I found a way to 'unsecure' the Console connection so that it works in my browser.

Here is the simple process.

1. Open Start menu and type 'cmd' in the Run command.
2. Change directory to the following folder path:
3. Type the following command and press 'Enter':
emctl unsecure dbconsole

This command is supposed to allow unsecure connection to the Oracle Enterprise Manager console.

You may encounter an error, which states an environment variable is not defined. Not to worry.

We just have to define is as indicated in two sample scenarios given below.
Setting ORACLE_SID environment variable

Setting ORACLE_UNQNAME environment variable

That's it.

Sunday, 9 June, 2013

List of Popular IBM Cognos BI and PM Books/Titles

Hello All

Here is a list of popular books/titles on IBM Cognos 8/10 BI Suite, in no particular sequence. Hope they are helpful to you all, together at a single location.

1. IBM Cognos 8 Business Intelligence: The Official Guide [Paperback]

Author        : Dan Volitich
List Price     : INR 695.00
Discounted Price: INR 556.00
You Save    : INR 139.0

US Link  UK Link

2. IBM Cognos Business Intelligence 10: The Official Guide [Paperback]
Author(s)    :  Dan Volitich & Gerard Ruppert
List Price     : INR 795.00
Discounted Price: INR 636.00
You Save    : INR 159.00

US Link  UK Link

3. IBM Cognos Business Intelligence v10: The Complete Guide [Import] [Paperback]
Author       : Sangeeta Gautam
List Price    : INR 3,768.00
US Link  UK Link

4. IBM Cognos 10 Business Intelligence [Import] [Paperback]
Author       : Dustin Adkison
List Price    : INR 4,317.00
US Link  UK Link

5. IBM Cognos Business Intelligence V10.1 Handbook [Paperback]
Author       :  Dean Browne
List Price    : INR 638.00
US Link  UK Link

6. IBM Cognos 8 Report Studio Cookbook
Author       : Abhishek Sanghani
List Price    : INR 425.00
Discounted Price: INR 350.00
You Save    : INR 75.00

US Link UK Link

7. 10 Core Principles of Report Studio Development
Author       : Ray Hogan
US Link UK Link

8. 10 Hard to Learn Tips for Becoming an Advanced Report Studio Developer
Author       : Ray Hogan
US Link UK Link

9. IBM Cognos Dynamic Cubes
US Link UK Link
Also available as a download on IBM® Redbooks® portal here.

10. Leveraging IBM Cognos 8 Bi for Linux on IBM System Z
US Link, UK Link
Also available as a download on IBM® Redbooks® portal here.

11. Cognos 8 BI for Consumers [Import] [Paperback]
Author       : Juan A Padilla
List Price    : INR 1,562.00
US Link  UK Link  

12. Exploiting IBM PowerVM Virtualization Features With IBM Cognos 8 Business Intelligence
US Link  UK Link

13. IBM Cognos 10 Framework Manager [Import] [Paperback]
Author       : Andy Penver, Terry Curran
List Price    : INR 2,373.00
US Link  UK Link

14. IBM Cognos Business Intelligence 10.1 Dashboarding Cookbook [Import] [Paperback]
Author       : Ankit Garg
List Price    : INR 2,894.00
US Link  UK Link

15. IBM Cognos Insight [Import] [Paperback]
Author       : Sanjeev Datta
List Price    : INR 1,689.00
US Link  UK Link

16. IBM Cognos 10 Report Studio: Practical Examples (Practical Examples Book/CD Rom) [Import] [Paperback]
Author       : Filip Draskovic, Roger Johnson
List Price    : INR 1,689.00
US Link  UK Link

17. IBM Cognos TM1 The Official Guide [Paperback]
Author       : Karsten Oehler, Jochen Gruenes, Christopher Ilacqua
List Price    : INR 636.00

US Link  UK Link

 18. IBM Cognos TM1 Cookbook [Paperback]
Author       : Ankit Garg
List Price    : INR 775.00

US Link  UK Link

19. IBM Cognos TM1 Developer's Certification Guide [Paperback]
Author       : James D. Miller
List Price    : INR 338.00

US Link  UK Link

20. IBM Cognos 8 Planning [Paperback]
Author       : Jason Edwards, Rich Babaran, Ned Riaz
List Price    : INR 650.00
Discounted Price: INR 525.00
You Save    : INR 125.00

US Link  UK Link

21. IBM Business Analytics and Cloud Computing: Best Practices for Deploying Cognos Business Intelligence to the IBM Cloud [Import] [Paperback]
Author       : Anant Jhingran, Stephan Jou, William Lee, Thanh Pham, Biraj Saha
List Price    : INR 1,074.00

US Link  UK Link

I will try and keep adding more useful books as I come across them. Please post info about any good books you are aware of.

Note: While you are on the site, please share your feedback on each of the books.

Monday, 20 May, 2013

Install IBM Cognos Insight

Today I installed free-to-use-for-personal-non-commercial-use IBM Cognos Insight on my personal laptop, to see what all the hype is about, finally.

Go here to download the IBM Cognos Insight software. Check if your environment is supported or not here. You can find the info center for IBM Cognos Insight here.

Installation went through smooth in under 5 minutes. The below are few snapshots from the same.

You will have to allow access to two applications tm1ipmp.exe and cognosinsight.exe through the Windows firewall.

 At first glance, I though I am looking at the UI of a Video editing or Video conversion software !!! Lol But this UI is clean and super smooth. They included some cool themes too.

Saturday, 23 March, 2013

Oracle user account locked??

If you install Oracle 11g on an unsupported Windows version and try to access the default schema/user which is scott/tiger, you could face a error such as below.

This is because the schema is locked (and possibly expired as well).

So we just have to connect to Oracle as DBA and unlock our schema/user

And then as the schema is unlocked now but the password for the schema is only in 'expired' state, if you can go ahead and connect to it. It fails and asks you to set a new password. You set a password and you can happily use the scott schema now with out any issues.

Happy Learning SQL !!!