Install IBM Cognos BI Suite
Began with 'Catering to queries related to IBM Cognos 8 BI Suite installation...' and then expanded beyond !! www.SandeepPamarati.com
Search This Blog
Friday, 1 March 2019
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:
\Product\11.1.0\db_1\dbs
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.
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.
Labels:
Oracle
Location:
Bengaluru, Karnataka 560001, India
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.
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.
Labels:
Book,
Cognos 10,
Cognos 8,
Cognos 8 Planning,
Cognos TM1,
DWH,
Reporting
Monday, 20 May 2013
Install IBM Cognos Insight 10.2.0.1
Today I installed free-to-use-for-personal-non-commercial-use IBM Cognos Insight 10.2.0.1 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.
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.
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 !!!
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 !!!
Location:
Hyderabad, Andhra Pradesh, India
Subscribe to:
Posts (Atom)