How to check Oracle database connection from the Inventory Manager server and the Inventory Beacon server?

Yes

Summary

Synopsis

Oracle Provider for OLE DB is installed and registered. After that how to check Oracle database connection from the Inventory Manager server and the Inventory Beacon server?

Discussion

Run the following command through the Command Prompt window with Administrator privilege.

> COPY NUL %TEMP%\testoledb.udl

On 64bit Windows Operating System:

> C:\Windows\SysWOW64\rundll32.exe "C:\Program Files (x86)\Common Files\System\Ole DB\oledb32.dll",OpenDSLFile %TEMP%\testoledb.udl

On 32bit Windows Operating System:

> C:\Windows\System32\rundll32.exe "C:\Program Files\Common Files\System\Ole DB\oledb32.dll",OpenDSLFile %TEMP%\testoledb.udl

Select the Provider tab on the Data Link Properties, and then select Oracle Provider for OLE DB.

Click Next.
Fill the Data Source, the User name and the Password fields.

Please refer TNSnames.ora file for fill the Data Source field.

Example:

An entry in the TNSnames.ora file:

ORCL11 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.10.11)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl11)
)
)

Data source value should be:

(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.10.11)(PORT=1521))(CONNECT_DATA= (SERVER=DEDICATED)(SERVICE_NAME=orcl11)))

Click Test Connection.

If it works, the following dialog box appears.

How to check Oracle database connection from the Inventory Manager server and the Inventory Beacon server?