Siebel Installation Guide for UNIX > Verifying and Troubleshooting Your Installation >

Verifying Oracle Database XE

Oracle Database XE is installed in some Siebel Patchset installation cases for Siebel Tools or Siebel Web Client. You can verify the existence or the successful installation of Oracle Database XE in multiple ways. This topic includes the following information:

• Verifying Installation of Oracle Database XE
• Verifying the ODBC Data Source for Oracle Database XE
• Verifying the TNSNAMES.ORA Entry for Oracle Database XE

Related Topics

Installing Oracle Database XE for the Local Database for Siebel Tools

Installing the Siebel Sample Database That Uses Oracle Database XE

Verifying Installation for Siebel Tools

Verifying Installation of Oracle Database XE

Use the following methods to verify the installation of Oracle Database XE. Also perform the other verification steps in this topic.

To verify installation of Oracle Database XE

• Do any or all of the following:
  • Open SERVICES.MSC and check for OracleServiceXE.
  • Open Programs and Features and check for Oracle Database XE under installed programs.
  • Check for the presence of the oraclexe directory in the Siebel Tools or Siebel Web Client installation.
  • Open the install.log file, which is available under the %temp% folder. Make sure that [ResultCode] is set to zero.
  • Run the command below to find the entry for Oracle Database XE in the registry:

  reg query HKLM\SOFTWARE\ORACLE\KEY_XE /v ORACLE_BASE

  • Start Siebel Tools and connect to the LOCAL_XE data source or start Siebel Mobile Web Client and connect to the SAMPLE_XE data source.

Verifying the ODBC Data Source for Oracle Database XE

Installing Oracle Database XE with Siebel Tools or Siebel Web Client automatically creates an ODBC system data source name (DSN) that Siebel Tools or Siebel Web Client use to connect to an Oracle Database XE installation. The ODBC data sources are as follows:

• LOCAL_XE (for a Siebel Tools installation, with the local database using Oracle Database XE)
• SAMPLE_XE (for a Siebel Web Client installation, with the Siebel Sample Database using Oracle Database XE)

To verify the ODBC data source for Oracle Database XE

1. Open ODBCAD32.exe, which is available in the C:\Windows\SysWOW64 directory.
2. Check that one of the following ODBC data source has been added under the System DSN tab, corresponding to your installation: either LOCAL_XE or SAMPLE_XE.
3. Make sure that the DSN connects.

Verifying the TNSNAMES.ORA Entry for Oracle Database XE

Use the following procedure to verify the TNSNAMES.ORA entry for Oracle Database XE.

To verify the TNSNAMES.ORA entry for Oracle Database XE

1. Open TNSNAMES.ORA, which is available under Oracle_DB_Client\network\admin.
2. Verify that a new entry of LOCAL_XE or SAMPLE_XE has been added.