Friday, May 31, 2019

Creating Pluggable database using database configuration assistant

Launch Database Configuration Assistant

Select Manage Pluggable Databases and click on Next

Select Create a Pluggable Database and click on Next

Select database , provide username and password and click on Next

Click on Yes

Click on Next

Provide pluggable database name, location and user details and click on Next

Click on Yes

Click on Finish

Pluggable database created successfully, click on close

Thursday, May 30, 2019

Steps for collecting OBIEE 12c diagnostic bundle

With this we can collect the below security files and logs as a bundle:

Collect a diagnostic bundle by running the following command:
[DOMAINHOME]/bitools/bin/ | .cmd [your path]/<zip file name>.

Click Enter

Archiving Catalog through Catalog Manager

Open Catalog Manager

Go to File and Click on Open Catalog

Provide the details below and click on ok

Type: Online
User: weblogic
Password: ********
Locale: English

Click on Ok

Double click on Catalog Root and select the folder we want to Archive

Provide the path and select time stamps and permissions and click on ok

Click on OK

Archived catalog file

Saturday, May 25, 2019

Code page mismatch Error While creating Informatica Integration Service

When trying to create informatica integration service, getting failed with below error:

Code page mismatch. Service process is running in code page [UTF-8 encoding of Unicode] whereas the service is configured in the Admin Console to run in code page [MS Windows Latin 1 (ANSI), superset of Latin1]

Click on View logs to check the error

Check for the Error message

To resolve this issue under Domain Navigator
Click on Integration Service
And then click on Processes

Select General Properties and click on Edit symbol

Change Code page value to Unicode as below and click on OK

Click on Properties

Restart the service

Click on OK

Issue resolved

Saturday, March 23, 2019

Step by step installing XAMPP

XAMPP is an open source cross platform web server, MySQL database engine, and PHP and Perl package. It is compiled and maintained by apache. The acronym XAMPP stands for;
  • X – [cross platform operating systems] meaning it can run on any OS  Mac OX , Windows , Linux etc.
  • A – Apache - this is the web server software.
  • M – MySQL - Database.
Use of XAMPP:
  • In order to use PHP, you will need to install PHP, Apache and may be even MySQL. It’s not easy to install Apache and configure it. If you install Apache on its own, you will still have to set it up and integrate it with PHP and Perl among other things. XAMPP deals with all the complexity in setting up and integrating with PHP and Perl. Unlike Java that runs with the Java SDK only, PHP requires a web server to work
  • XAMPP provides an easy to use control panel to manage Apache, MySQL and other programs such as Tomcat, filezilla etc. You don’t have to memorize commands for starting apache, MySQL etc.
Step by step installing XAMPP:
Double click on the downloaded software

We will get a warning message as below

As per the warning message disable the UAC or install the software other than program files 

In the welcome screen click on next

Select all the components and click on Next

Provide the installation directory for XAMPP and click on Next

Click on Next

Click on Next

Wait until the installation got finished

Click on Allow access

Check start control panel option and click on Finish

Select the language and click on save

We will get a XAMPP control panel as below

Here we started Apache server and mysql by clicking on start button adjacent to them

By clicking on Admin button belong to Apache we can access the dashboard page as below

Creating MySQL database:

Click on Admin button of MySQL

In the admin console click on New

Provide name for the database and click on create

We can create tables on the newly created database  by using Create table option

Creating a table “nametable” with two columns

Connecting to sql work bench and checking for the table created

  Opatch reports 'Cyclic Dependency Detected' error when patching ODI   Issue: When applying a Patch Set Update (PSU) to WebLogic Se...