RDB Manager and Historical service stopped working

[Natty]

Greetings,

I developed a WinCC OA application for the Montparnasse Paris train station. Attached files are the WinCC OA servers logs.

I have noticed that Oracle database could not be read with a request sent from the WinCC OA server UI. So historical datas cannot be displayed on the UI anymore.

After rebooting both WinCC OA server and Oracle server, I have been able to visualize the historcal datas on the UI. But it only worked once. If I send a second request from the UI after rebooting, datas won't be displayed and the error "Database is offline" occurs (on the UI). I pasted an extract of server log below :

WCCILdata (0), 2018.08.02 16:00:11.155, PARAM,INFO, 1, Manager Start, HistOrgMain, connection from archive received - initializing, archive number is: 97
WCCOArdb (97), 2018.08.02 16:00:11.155, SYS, INFO, 0, , Internal Dp Value changed! It will take a few seconds that the Manager uses the Value changes.
WCCOArdb (97), 2018.08.02 16:00:11.155, SYS, INFO, 0, , Internal Dp Value changed! It will take a few seconds that the Manager uses the Value changes.
WCCOArdb (97), 2018.08.02 16:00:11.155, SYS, INFO, 0, , Internal DP stopWriteToDB is false
WCCOArdb (97), 2018.08.02 16:00:11.171, SYS, INFO, 0, , RDB uses Oracle Client Version 12
WCCOArdb (97), 2018.08.02 16:00:52.869, SYS, SEVERE, 0, , ORA-12154: TNS : l'identificateur de connexion indiqué n'a pas pu être résolu

WCCOArdb (97), 2018.08.02 16:00:52.869, SYS, SEVERE, 0, , Failed to make a valid connection to the data base [Write Connection OCCI] (BDDGTC)
WCCOArdb (97), 2018.08.02 16:01:34.553, SYS, SEVERE, 0, , ORA-12154: TNS : l'identificateur de connexion indiqué n'a pas pu être résolu

WCCOArdb (97), 2018.08.02 16:01:34.553, SYS, SEVERE, 0, , Failed to make a valid connection to the data base [Read Connection] (BDDGTC)
WCCOArdb (97), 2018.08.02 16:01:34.553, SYS, SEVERE, 0, , Do only initialize connection params for [Request Connection] (BDDGTC)
WCCOArdb (97), 2018.08.02 16:01:34.553, SYS, SEVERE, 0, , Do only initialize connection params for [Request Connection] (BDDGTC)
WCCOArdb (97), 2018.08.02 16:01:34.553, SYS, SEVERE, 0, , Do only initialize connection params for [Request Connection] (BDDGTC)
WCCOArdb (97), 2018.08.02 16:01:34.553, SYS, SEVERE, 0, , Do only initialize connection params for [Request Connection] (BDDGTC)
WCCOArdb (97), 2018.08.02 16:01:34.553, SYS, INFO, 0, , Manager made 0 valid Connection(s) to the Data Base [Request Connection]! (BDDGTC)
WCCOArdb (97), 2018.08.02 16:01:34.553, SYS, SEVERE, 0, , Do only initialize connection params for [DP INFO Connection] (BDDGTC)
WCCOArdb (97), 2018.08.02 16:01:34.553, SYS, SEVERE, 0, , Do only initialize connection params for [DP Delete Connection] (BDDGTC)

Error "Ora-12154" occurs several time. I tried to modify the "tnsnames.ora" file but I could not solve it. Also, wirting to the Oracle database is still working. There is only a problem with reading the database.

Do you know how to solve this problem ? Is there a way to check wether the Oracle database is full ?

Thanks in advance.
Mathieu Baviera https://www.winccoa.com/fileadmin/image ... 180802.zip

[paramesh1985]

Hello,

Meaning of the error is related to TNS connector identifier issue. Could you please share the tnsname.ora file from both Oracle server and WinCC OA server.

First check listener status and share your tnsname.ora file.

It seems to be connector identifier issue.

Try the below command directly from your WinCC OA server using sql command and check which error message you are getting;

sqlplus "SchemaUsername"/"SchemaUserPassword"@"DatabaseName"


Regards,

R.Parameshwaran

[Natty]

Hello,

I attached the tnsnames.ora from the Oracle server. Unfortunately I do not have such a file on the WinCC OA server. The existing path on the Oracle server simply does not exist on the WinCC OA server.

I also attached a screenshot of the sqlplus command you asked. Errors ORA-12154 and ORA-12560 occur. I'm not sure I used it the right way. If not, could you give me more details please ?

Thanks in advance for your reply.

Mathieu BAVIERA

[Natty]

I have a doubt whether the file attachment worked.

[paramesh1985]

Hi,

I am not able to find any tnsname.ora file attachment.

Could you please tell me you have installed Oracle Client software in the WinCC OA server or not.


Regards,

R.Parameshwaran

[Natty]

Hello,

I have indeed installed Oracle client on the WinCC OA server but as I said, I can't find any tnsname using Window research tool in this directory (i linked a screenshot).

[paramesh1985]

Hello,

Have you installed the Oracle CLient software in the Administrator mode or something else.

It should be install under Administrator mode.

Regards,

R.Parameshwaran

[Natty]

I can't remember as I did 2 years ago. Though it used to work for several months so I would say that I did install it with Administrator mode.


[img/]

Regards.
Mathieu BAVIERA

[paramesh1985]

Hello,

During the installation of oracle client software in the scada server,client ; it will prompt to select the type of installion. In that you have select "Administrator" mode.

Could you please tell me which mode you have selected during installation.





Regards,

R.Parameshwaran

[Natty]

Hello,

I selected "Administrator" mode. I can't figure out how to link a file.

Regards.