Check the Oracle database connection from the Inventory Manager and Inventory Beacon servers
You can verify the Oracle database connection from the Inventory Manager server or the Inventory Beacon server by using a Universal Data Link (UDL) file. This is useful after installing and registering the Oracle Provider for OLE DB to confirm that the server can successfully connect to the Oracle database.
- Open a Command Prompt with administrator privileges.
- Create a UDL test file by running the following command:
> COPY NUL %TEMP%\testoledb.udl - C:\Windows\System32\rundll32.exe "C:\Program Files\Common Files\System\Ole DB\oledb32.dll",OpenDSLFile %TEMP%\testoledb.udl
Open the UDL file using the appropriate command for your environment.
For 32-bit Beacon (versions 25.1.0 and below)
On 64-bit Windows Operating System:
C:\Windows\SysWOW64\rundll32.exe "C:\Program Files (x86)\Common Files\System\Ole DB\oledb32.dll",OpenDSLFile %TEMP%\testoledb.udl
On 32-bit Windows Operating System:
C:\Windows\System32\rundll32.exe “C:\Program Files\Common Files\System\Ole DB\oledb32.dll”,OpenDSLFile %TEMP%\testoledb.udl
For 64-bit Beacon versions 25.2.0 and above
On 64-bit Windows Operating System:
C:\Windows\System32\rundll32.exe "C:\Program Files\Common Files\System\Ole DB\oledb32.dll",OpenDSLFile %TEMP%\testoledb.udl
- Click Next.
- Fill in the Data Source, User name, and Password fields.
Use the
tnsnames.ora file to determine the correct value for the Data source field.Example
Entry in the
tnsnames.ora file:ORCL11 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = <host_name>)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl11)
)
)
Corresponding Data source value:
(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=<host_name>)(PORT=1521))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=orcl11)))
- Select Test Connection. If it works, the following dialog box appears.
Was this helpful?
