Sterling OMS Windows local Oracle Common Issue

By | 08/21/2017

Sterling OMS Windows local Oracle Common Issue

If you are doing development using windows and have local Oracle Installation might seen “The Network Adapter could not establish the connection” issue very frequently after windows machine restart. In this post we are going to see how to address “The Network Adapter could not establish the connection” error.

When Database connection error occurs OMS application server will not start successfully. Meaning even after server coming to RUNNING status will not be able to access the application login screen. Application Console (Weblogic) displays “Failed” status under deployment section.

Sterling OMS Windows local Oracle Common Issue

Sterling OMS Windows local Oracle Common Issue

How to resolve the The Network Adapter could not establish the connection Issue ?

Go to Windows — Open Services

Short the service by name

Start following 3 services and make sure services comes to running mode in status column.

  • OracleServiceXE
  • OracleXEClrAgent
  • OracleXETNListener

Important Note : After services coming to running mode give few minutes before connecting back to database.

The Network Adapter could not establish the connection

Add-on: How to update region schema (US States/City) into OMS ?

  • Go to <install directory>\database\FactorySetup\Optional\oracle\RegionSchema-US
  • Open RegionSchema-US.sql
  • Run the SQL commands using SQL developer
  • Perform commit

Add-on: How to add zip code data into OMS ?

  • Go to <install directory>\database\FactorySetup\Optional\oracle\ZipCodeLocation
  • Open US_ZipcodeLocation.sql
  • Run the SQL commands using SQL developer
  • Perform commit

Please share your feedback on comments section. Any query please write to us support@activekite.com

Register with us to get more Sterling OMS learning update

Sterling OMS : How to add new column ?

Sterling OMS : Interview questions ? If any other question asked please email us we will update here

7 thoughts on “Sterling OMS Windows local Oracle Common Issue

  1. Anonymous

    Another very common issue with oracle is when we abruptly shutdown windows then next time we are not able to connect to local oracle DB. To rectify it follow these steps:-
    1. open command prompt and run – sqlplus connect as sysdaba
    2. give password
    3. sql prompt will come.
    4. run – shutdown immediate;
    5. then run – startup;
    6. if above command are successful then you will able to connect your DB again.

    Reply
    1. admin Post author

      Thank you for useful information. Let’s keep learning and create community to help each other. Thank you again !!!

      Reply
  2. prasannakumar

    HI Team,

    You guys are doing Great. Could you please post more posts on pipe lines, configuring pipelines, transactions, usage of transactions, services, api’s etc…

    Reply
    1. admin Post author

      Sure. Thanks for your suggestion. We will do. Keep learning.

      Reply
  3. Sai

    How to add zip code data into OMS by using a linux box (without SQL developer) ?

    Reply
    1. admin Post author

      Not exactly sure without SQL developer. We will see if some else answers this question. Thanks

      Reply

Leave a Reply

Your email address will not be published. Required fields are marked *