BPA 10.1.3.4 Windows Install with XE

By M&S Consulting (Kevin) on May 21st, 2009
Filed Under Technical Tips // Tags: , , , ,

I have just had a heck of a time with installing BPA (Architect) Evaluation on a Windows Server 2003 machine. There were no inherent issues with the product itself, but some gotchas that I thought I might point out. For the following, I assumed you are installing on a single machine for testing/evaluation purposes like I was.

For one, if you were familiar with BPA 10.1.3.3, there is no longer an auto-installable olite database option. You must use Oracle XE Universal (or better) and you should have it installed locally prior to installing BPA. Note: You should use XE Universal specifically so you get the AL32UTF8 character set that is expected by the BPA install.

After I got the character set squared away, I continued to receive a database connection error during the install. My XE DB was working fine, I could log in, sqlplus, etc., etc. I did some digging and found the following file:

c:\program files\oracle bpa suite10.1.3.4\testsql.txt

In here, the first line started with “C:\XEClient\bin\tnsping”

My XE Client, however, does not have the tnsping utility. So, I copied over the bin directory files from the XE DB bin into the XE Client bin to get the various tools the installation might be leveraging, and sure enough, everything went through smoothly.

So, if you get into trouble during the install while setting up the DB/connection, take a look at that testsql.txt file and you can likely troubleshoot those commands individually to see where your problem lies. Good luck!

Bookmark and Share

Related Information:

  1. Oracle XE 10g Windows Install - Video Walkthrough Tutorial
    This tutorial article is meant to provide a visual guide to the process of installing Oracle express edition (XE) onto...
  2. Install Oracle Apex 3.2 on XE and XP Pro - Video Walkthrough Tutorial
    This tutorial is a supplment to the install video linked to below. It takes you through the process of installing...
  3. Oracle Express Edition (XE) 10g Windows Download
    The following are links to the download page for Oracle Database 10g Release 2 (10.2.0.1) Express Edition (XE) for Microsoft...
  4. OID Install in Oracle Enterprise Linux (OEL) 5 - Shared Libraries Error
    When installing 10g OID on OEL5, if you run into the following error, you can run the below commands to...
  5. Upgrading to APEX 4 on Oracle XE and Windows

    Overview

    This tutorial article and it's associated video will help guide you through the process of upgrading a previously installed...
  6. Oracle Client Download (10g Windows Client)
    Following is the link to the Oracle 10g Release 2 Client for Windows: http://www.oracle.com/technology/software/products/database/oracle10g/htdocs/10201winsoft.html As of this writing (in Januray...
  7. Oracle Client Download (11g Windows Client) - 32 bit and x64
    Following are links to the Oracle 11g Release 1 Client downloads for the various Windows versions: 

    Windows Server 2000, 2003,...

  8. Installing APEX 4 on Windows Server 2003 64 bit edition with Oracle Database 11g

    Overview

    This tutorial article and it's associated video will help guide you through the process of installing APEX version 4.0...

Leave a Reply


Archives

Recent Comments

  • Kavitha Muniraj said: Hi, Could you please send a script which checks the status of forms and reports of oracle...
  • Siddharth said: Hey thanks a lot !! Have been lookin all over for this :) My PC may not be able t handle FlashBuilder...
  • Cyrex said: Hey man why I cant install Apex 4? is there anyone can help me.,?
  • sharanabasava said: ALTER TABLE [my_table_name] RENAME COLUMN [current_column_name] TO [new_column_name]; Sir,I...
  • Huub Vankan said: Thanks for this easy solution. Indeed strange that is does not work in the (x86) folder….

Calendar

July 2010
M T W T F S S
« Jun    
 1234
567891011
12131415161718
19202122232425
262728293031  

Featured Testimonial

"M&S has taken 'partnership' to a new level. They are not only a deeply skilled service provider, the M&S team is actually a mission critical component to our operations, taking on new initiatives as well as maintaining custom, open source, and COTS solutions."

CEO, MedPivot

Free SQL Service