ORA-12638: credential retrieval failed

Got this error while connecting to Oracle Database

This looks like entered wrong password, but actually its not.

Problem will be the Oracle server is not configured to support Windows authentication
or The credentials used to login are not sufficient to allow to login to the server.

Workaround
Goto %Oracle Home%\NETWORK\ADMIN in my case it is 
C:\app\prathap\product\11.2.0\dbhome_1\NETWORK\ADMIN

Open sqlnet.ora file and modify 
SQLNET.AUTHENTICATION_SERVICES= (NTS) to
SQLNET.AUTHENTICATION_SERVICES= (NONE)


It worked for me.

Configuring MapViewer in OBIEE 11g

Download Navteq spatial SampleApp data from the below link

http://download.oracle.com/technology/products/bi/files/SampleApp_Navteq_dmp.zip

Login to SQL Plus and Create obiee_navteq user to create schema in Oracle Database

Grant permission to obiee_navteq user

Unzip SampleApp and Import into Oracle database(i have unzipped file to C:\)

Open command prompt and execute below command

imp obiee_navteq/obiee_navteq file=C:\obiee_navteq.dmp FULL=Y

Login to SQL Plus and Execute the following insert statements to insert data

Logon to Oracle MapViewer using http://localhost:9704/mapviewer/mvlogon.jsp

Click on “Configuration” to edit mapViewerConfig.xml file

Find “Security Configuration” section and add the below code

<disable_direct_info_request> true </disable_direct_info_request>
<disable_info_request> true </disable_info_request>
<disable_csf>true</disable_csf>
<enforce_security_role> true </enforce_security_role>

In “Security Configuration” section enter the server name

Go to the bottom of mapViewerConfig.xml file and check for “Predefined Data Sources“ section. Add the below code to this section

Keep the exclamation mark (!) before the password. It will encrypt the password next time the MapViewer instance is restarted.

<map_data_source name="obiee_navteq"

                      jdbc_host="localhost"

                      jdbc_sid="orcl"

                      jdbc_port="1521"

                      jdbc_user="obiee_navteq"

                      jdbc_password="!obiee_navteq"

                      jdbc_mode="thin"

                     number_of_mappers="3"

                     allow_jdbc_theme_based_foi="false"

                     editable="false" />

Click on “Save” button to save the changes. Do not click on “Save & Restart”

Restarting the services for these changes to take effect:

Stop Order:
a) BI Components using Oracle Enterprise Manager FMC console
b) The BI Managed Server using the WebLogic console.

Start Order:
a) The BI Managed Server using the WebLogic console.
b) BI Components using Oracle Enterprise Manager FMC console

Start & Stop BI Components Using Oracle Enterprise Manager FMC console

http://localhost:7001/em/

Start & Stop The BI Managed Server Using Oracle WebLogic Admin console

http://localhost:7001/console/

Logon to http://localhost:9704/mapviewer/mvlogon.jsp

Click on data sources, here it will show the data source name which we have created.

Login to obiee console using http://localhost:9704/analytics/

Go to Administration -> Manage Map Data

Here select the Layers and background maps

Successfully Configured MapViewer with OBIEE. Now we can use Maps in Analysis in OBIEE

Step by step Installation of OBIEE 11.1.1.7.0

Prerequisites to install OBIEE
1. Database (Oracle Database Installation)
2. Repository Creation Utility(RCU Installation)

Once we are done with prerequisites installation then start OBIEE installation.

Download all the necessary files and extract to one folder.

Right click on “setup.exe” and click on “Run as administrator” to start installation

Click on “Run” to continue

Here it will check for prerequisites… if it is passed it will go to next screen

This is the installer welcome screen. Click “Next” to continue installation

For product updates it is good to provide Oracle support user name and password if you have, Otherwise select “Skip software updates” and continue

In this screen select the type of Installation
I am going with “Enterprise Install” option

Here it will do the prerequisite checks. Once it is successful click “Next” to continue

Select “Create New BI System” option as we are creating for the first time and enter password for the “weblogic” user and clink “Next” to continue

Select “Oracle Middleware Home Location” to install OBIEE. Once it is selected remaining will be filled automatically.
We can change “Oracle Instance Name” if required.

In this screen select the Components to install. I have unchecked “Essbase Suite” option since we have separate “Essbase Environment”

If you need to install “Essbase Suite” also then check that option and continue with installation

In this screen select the Components to install. I have unchecked “Essbase Suite” option since we have separate “Essbase Environment”

If you need to install “Essbase Suite” also then check that option and continue with installation

Here we have to enter MDS Schema Username and password

Select “Auto Port Configuration” then Installer will do the port configuration automatically.

If you want to select different ports then go with option “Specify ports using Configuration file”.

I am going with Auto Port Configuration 

It is good to enter Oracle support user name and password to inform critical security issues. If you don’t want to receive any security updates leave it blank and continue

This screen shows the summary of installation that is going to happen. Save the file as a reference for installation summary and Click on “Install” to start installation of OBIEE. 

This screen will shows the Installation progress

After installing OBIEE here it will start the Configuration of each task. Once it is successful (100%) click “Next” to continue.

We have successfully installed and configured OBIEE 11.1.1.7.0 on Windows.

Click “Finish” to close the Installer screen.

Installing Repository Creation Utility(RCU)

Download Repository Creation Utility install file(s) from Oracle edelivery website.

Extract file(s) into one folder

To install RCU we need a database as prerequisite. I have installed Oracle database

Oracle Database Installation

Right click on “rcu.bat” and Click on “Run as administrator” to start installation

 

Click on “Run” to continue installation

Repository Creation Utility installer Welcome Window

Default option will be “Create”, continue with this option if it is a fresh copy of installation.

If you have already created Schemas and wants to drop those from database use “Drop” option.

Specify the Database server details which you have Installed and configured already.

Checking the details of Database server, once validated successfully click on “OK” to continue

Here I am installing RCU as prerequisite to install OBIEE, so no need to select all components.

Select components related to OBIEE only.

Expand “Oracle Business Intelligence” option and select “Business Intelligence Platform” then it will automatically selects “Metadata Services” also. Click “Next” to Continue

Here it will check for Component Prerequisites, once it is successful Click on “OK” to continue installation

In this screen we have to provide passwords for Schemas

If you want to use one password for all Schemas go with default option “Use same passwords for all Schemas”

Select “Use main schema passwords for auxiliary schemas” option if you want to specify different passwords for the main schemas, but still have the same password used for their respective auxiliary schemas. (This option is not required in this scenario since there is no Auxiliary schemas)

If you want to use different passwords for each Schema then go with “Specify different passwords for all schemas”

Here it will select the default tablespaces for the selected components. We can create new tablespaces or modify existing tablespaces by clicking on “Manage Tablespaces”

I am going with default tablespaces

This screen will ask you to confirm the creation of tablespaces for the new schemas.

Click “OK” to confirm and continue

In this screen it will validate and create tablespaces for the selected components.

Click “OK” to continue

In this screen it will show the summary of Repository to create.

Click on “Create” to start creating Repository.

We have successfully created Repository.