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
- 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)
)
)
(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.
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