Skip to Main Content
Forums

DevOps, CI/CD and Automation

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

TNS Service Name drop list empty in Windows 10 64-Bit

User_AUZE8Jan 6 2021

When I attempt to create an ODBC connection under System DSN, the TNS Service Name drop down list is blank.
image.pngI manually added a database name and credentials (works in SQL Developer) and the following error appears:

image.pngI'm running Windows 10 Enterprise 64-Bit and Oracle12c 32-Bit.
What do I do?

Comments

LeightonLNelson
Hi,
First I recommend to remove your hostname information from the output of your post.
From the output it seems to indicate that your OMS is down. Could you please verify that the OMS in question is up using emctl status oms.
What command did you use to remove the plug-in? Does emcli list_plugins_on_server show the deployed plug-in?

Thanks,
Leighton
EdSpn
Hi Leighton,

Thanks for the feedback. I just checked status oms and it seems fine:
[oracle@dwbi-durl-oel agent_inst]$ $OMS_HOME/bin/emctl status oms
Oracle Enterprise Manager Cloud Control 12c Release 2
Copyright (c) 1996, 2012 Oracle Corporation.  All rights reserved.
WebTier is Up
Oracle Management Server is Up
Yes, my plugin is still listed. I always use the following commands to undeploy:
emcli delete_target -name="$TARGET_NAME"    -type="$TARGET_TYPE_NAME"
emcli undeploy_plugin_from_agent  -plugin="$PLUGINID" -agent_names="$AGENT_NAME"
emcli undeploy_plugin_from_server -plugin="$PLUGINID" -sys_password="$SYSPWD"
I think the issue may be caused by another plugin. Will dig further.

Thanks,
Ed

PS That hostname slipped through into the post. Just removed it :)
EdSpn
To complete the thread:

I have found the offending plugin, and undeployed it (using the OEM UI in browser).
After this, the issue was resolved, and I could successfully undeploy my own plugin.

Regards,
Ed
Which plugin did you undeployed ?
EdSpn
It was not an Oracle provided plugin, but one of our own.
1 - 5

Post Details

Added on Jan 6 2021
#odbc, #windows-and-net
6 comments
12,694 views