No relevant resource is found in the selected language.

This site uses cookies. By continuing to browse the site you are agreeing to our use of cookies. Read our privacy policy>

Reminder

To have a better experience, please upgrade your IE browser.

upgrade

Fail to visit WEB application of DS system after the total DS CAD system reboot

Publication Date:  2018-01-19 Views:  52 Downloads:  0
Issue Description

The DS ECC system was integrated into Huawei Safe City Solution, and the solution has been widely used in many countries around the world. DS’s ECC system consists of ECC database, DS21 communication server, CAD application server, VAD server, Web server and other modules.

In one project, there are frequent blackouts during project deployment period. And there is always a problem that DS web cannot be accessed after the system reboot.

The error prompt is as following picture:


Handling Process

1.    Get the module information list first, and find the IP address of ECC database.

System name

Modules

IP address

DS ECC

ECC database

172.21.100.51

DS21 communication server

172.21.100.52

CAD application server

172.21.100.53

VAD server

172.21.100.54

Web server

172.21.100.55

 

2.    Find a PC with Oracle Client application, then use TNSPing command to test the connection with ECC database server again.

C:\Users\Administrator>tnsping 172.21.100.51

TNS Ping Utility for 32-bit Windows: Version 11.2.0.1.0 - Production on 17-JAN-2

018 11:51:57

Copyright (c) 1997, 2010, Oracle.  All rights reserved.

Used parameter files:

C:\app\Administrator\product\11.2.0\client_1\network\admin\sqlnet.ora

Used EZCONNECT adapter to resolve the alias

Attempting to contact (DESCRIPTION=(CONNECT_DATA=(SERVICE_NAME=))(ADDRESS=(PROTO

COL=TCP)(HOST=172.21.100.51)(PORT=1521)))

TNS-12541: TNS:no listener

3.    According to the error prompt from Web visit response and tnsping result, we need to check the listener status in ECC database server.

1)    Log in to the Oracle server as the oracle user.

2)    Run the lsnrctl status command to check the listener status.


3)    According to the prompt information in Step 2), it’s clear that the listener has not started.

4)    Run the command “lsnrctl start” to start the listener.


And run the command “ lsnrctl status” to check the listener status again


4.    Visit the DS Web again, and it works well now.



Solution

In order to avoid repeated operation after each system reboot, it’s better to set starting automatically for listener in ECC database.

This ECC database runs on OS Suse 11SP2, and we can create file “/etc/rc.d/after.local” to set starting automatically for listener in ECC database

1)    Log in to the Oracle server as the root user.

2)    Run the command “vi /etc/rc.d/after.local”

3)    Add following commands to this file.

su - oracle -c 'dbstart'  

su - oracle -c 'lsnrctl start' 

4)    Press “ESC” and input “:wq” to save the file.

5)    Reboot the database server and check the listener status

Suggestions

NULL

END