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
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.
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
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.
Thank you for useful information. Let’s keep learning and create community to help each other. Thank you again !!!
🙂
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…
Sure. Thanks for your suggestion. We will do. Keep learning.
How to add zip code data into OMS by using a linux box (without SQL developer) ?
Not exactly sure without SQL developer. We will see if some else answers this question. Thanks
You can run sql statements from command prompt by connecting to the database using sqlplus command.