Siebel Installation Guide for Microsoft Windows > Verifying and Troubleshooting Your Installation >

Verifying Installation for Oracle Database XE

Oracle Database XE is installed with Siebel Tools or Siebel Mobile Web Client. You can verify the existence of 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 and Using Oracle Database XE for the Local or Sample Database

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. See also the documentation for Oracle Database Express Edition on Oracle Help Center.

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 Mobile 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 LOCAL_XE or SAMPLE_XE data source.

    NOTE:  For Siebel Mobile Web Client, or for Siebel Tools if you did not already install the local database, then connecting to LOCAL_XE initializes the local database. Users must attempt this only after a local database has been extracted for them by the system administrator.

Verifying the ODBC Data Source for Oracle Database XE

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

• LOCAL_XE (for a Siebel Tools or Siebel Mobile Web Client installation, with the local database using Oracle Database XE)
• SAMPLE_XE (for a Siebel Mobile Web Client installation, with the 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.