Some users may experience issues accessing the case portal. For more information, please click here.

cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 

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

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

Summary

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

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

  1. 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
  1. Select the Provider tab on the Data Link Properties, and then select Oracle Provider for OLE DB.
User-added image
  1. Click Next.
  2. Fill the Data Source, the User name and the Password fields.
User-added image
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)))
  1. Click Test Connection.
If it works, the following dialog box appears.
User-added image

Related KB Articles

How to check whether OLE DB Provider for Oracle is installed and registered correctly on the Inventory Manager environment and the Inventory Beacon environment
Labels (1)
Was this article helpful? Yes No
No ratings
Version history
Last update:
‎Jun 02, 2018 01:02 PM
Updated by: