Posts

Showing posts from 2021

How To Update SUN STK RAID INT to Adaptec RAID 5805

Image

HOW TO Install Remote Desktop Xrdp on Oracle Linux 7

Image
Based on tutorial in This Video based on tutorial from website : https://www.itzgeek.com/how-tos/linux... This video show how to instal remote desktopXRDP interactive with windows operating system Thankyou

how to install OMSA on oracle linux 7

Image
How To Install OMSA on Oracle Linux 7  Hardware Server : DELL R710 Server  To configure the repository, use the following commands:  1. curl -O https://linux.dell.com/repo/hardware/...  2. bash bootstrap.cgi  3. yum install srvadmin-all   Follow this video carefully Thankyou

Example Case Implementation Interference Rejection Combining (IRC)

Image
Background The purpose of Interference Rejection Combining (IRC) is to improve performance on the uplink in radio environments limited by interference. IRC minimizes the disturbance from an interferer by combining the signal received on diverse antennas and suppressing the interfering signal. IRC can improve the signal more efficiently than the basic RX diversity feature. IRC can be used to increase capacity in a radio network limited in the uplink, improve speech quality, and increase data throughput in the uplink. IRC gives improved speech quality, fewer dropped calls, and increased data throughput due to fewer re-transmissions. IRC activation should improve KPI of Accessibility and retain ability Existing Configuration Case Most of SUPIRC settings in BSC properties have been active Most of cells in all 13 BSCs still with IRC=OFF ...

JAVA Script Parser Ericsson CEDH and STRT Log

 /*  * To change this license header, choose License Headers in Project Properties.  * To change this template file, choose Tools | Templates  * and open the template in the editor.  */ package strt; import java.io.BufferedReader; import java.sql.*; import java.io.File; import java.io.FileReader; import java.io.FileWriter; import java.io.IOException; import java.text.DateFormat; import java.text.SimpleDateFormat; import java.util.Calendar; import java.util.Scanner; import java.util.logging.Level; import java.util.logging.Logger; /**  *  * @author aessa  */ public class STRT {     String dbnn;     String TT;     String locoutfile;     String usreniq;     String pwdeniq;     String ipeniq;     String porteniq;     String dbeniq;     String stsregion;     String maxrowv;     String dtt = null;     private Connection connx;   ...

Example of Query 3G Cell Propagation Data ENIQ with Vector INDEX

Image
The following is an example of an Ericsson ENIQ SQL Query for finding the range of radio signal propagation in average Kilometres by method of Weighted Average. S ELECT Date_ID,RNC,RBS,Sector,Carrier, cast((SUM(A_1)+SUM(A_2)+SUM(A_3)+SUM(A_4)+SUM(A_5)+SUM(A_6)+SUM(A_7)+SUM(A_8)+SUM(A_9)+SUM(A_10)+SUM(A_11)+SUM(A_12)+SUM(A_13)+SUM(A_14)+SUM(A_15)+SUM(A_16)+SUM(A_17)+SUM(A_18)+SUM(A_19)+SUM(A_20)+SUM(A_21)+SUM(A_22)+SUM(A_23)+SUM(A_24)+SUM(A_25)+SUM(A_26)+SUM(A_27)+SUM(A_28)+SUM(A_29)+SUM(A_30)+SUM(A_31)+SUM(A_32)+SUM(A_33)+SUM(A_34)+SUM(A_35)+SUM(A_36)+SUM(A_37)+SUM(A_38)+SUM(A_39)+SUM(A_40)) as float) as TS, cast (((SUM(A_1) * 0.175) + (SUM(A_2) * 0.525) + (SUM(A_3) * 0.875) + (SUM(A_4) * 1.23) + (SUM(A_5) * 1.585) + (SUM(A_6) * 1.935) + (SUM(A_7) * 2.285) + (SUM(A_8) * 2.635) + (SUM(A_9) * 2.985) + (SUM(A_10) * 3.34) + (SUM(A_11) * 3.87) + (SUM(A_12) * 4.57) + (SUM(A_13) * 5.275) + (SUM(A_14) * 5.98) + (SUM(A_15) * 6.68) + (SUM(A_16) * 7.38) + (SUM(A_17...

Example of Query UE Capability Data ENIQ with Vector INDEX

The following is an example of an Ericsson WCDMA Query for transpose the UE Capability from performance parameter pmTotNoRrcConnectUeCapability . Select 'W31' as date_id,RNC,UtranCell,sum(pmTotNoRrcConnectUeCapability_0) as pmTotNoRrcConnectUeCapability_0 ,sum(pmTotNoRrcConnectUeCapability_1) as pmTotNoRrcConnectUeCapability_1 ,sum(pmTotNoRrcConnectUeCapability_2) as pmTotNoRrcConnectUeCapability_2 ,sum(pmTotNoRrcConnectUeCapability_3) as pmTotNoRrcConnectUeCapability_3 ,sum(pmTotNoRrcConnectUeCapability_4) as pmTotNoRrcConnectUeCapability_4 ,sum(pmTotNoRrcConnectUeCapability_5) as pmTotNoRrcConnectUeCapability_5 ,sum(pmTotNoRrcConnectUeCapability_6) as pmTotNoRrcConnectUeCapability_6 ,sum(pmTotNoRrcConnectUeCapability_7) as pmTotNoRrcConnectUeCapability_7 ,sum(pmTotNoRrcConnectUeCapability_8) as pmTotNoRrcConnectUeCapability_8 ,sum(pmTotNoRrcConnectUeCapability_9) as pmTotNoRrcConnectUeCapability_9 ,sum(pmTotNoRrcConnectUeCapability_10) as pmTotNoRrcConnec...

Example of Query CQI (pmRadioUeRepCqiDistr) Data ENIQ with Vector INDEX

 The following is an example of an Ericsson 4G LTE Query for finding the CQI=Carrier Quality Index from performance parameter pmRadioUeRepCqiDistr  by method of Weighted Average. SELECT Date_ID,HOUR_ID,ERBS,EUTRANCELLFDD, cast((SUM(A_0)+SUM(A_1)+SUM(A_2)+SUM(A_3)+SUM(A_4)+SUM(A_5)+SUM(A_6)+SUM(A_7)+SUM(A_8)+SUM(A_9)+SUM(A_10)+SUM(A_11)+SUM(A_12)+SUM(A_13)) as float) as TS,  cast((SUM(A_0) * 0.5) + (SUM(A_1) * 1) + (SUM(A_2) * 2) + (SUM(A_3) * 3) + (SUM(A_4) * 4) + (SUM(A_5) * 5) + (SUM(A_6) * 6) + (SUM(A_7) * 7) + (SUM(A_8) * 8) + (SUM(A_9) * 9+ (SUM(A_10) * 10) + (SUM(A_11) * 11) + (SUM(A_12) * 12) + (SUM(A_13) * 13)) as float) as Wgtd  ,cast((Wgtd/TS) as dec (19,3)) as Reported_CQI, SUM(A_0) as pm_0, SUM(A_1) as pm_1, SUM(A_2) as pm_2, SUM(A_3) as pm_3, SUM(A_4) as pm_4, SUM(A_5) as pm_5, SUM(A_6) as pm_6, SUM(A_7) as pm_7, SUM(A_8) as pm_8, SUM(A_9) as pm_9, SUM(A_10) as pm_10, SUM(A_11) as pm_11, SUM(A_12) as pm...

Example of Query IUB Frame Loss Intensity Data ENIQ with Vector INDEX

The following is an example of an Ericsson ENIQ SQL Query for finding the IUB Frame Loss Intensity by method of Weighted Average. SELECT Date_ID,Hour_ID,MIN_ID,RNC,RBS, SUM(A_0) as A_0,SUM(A_1) as A_1,SUM(A_2) as A_2,SUM(A_3) as A_3,SUM(A_4) as A_4,SUM(A_5) as A_5,SUM(A_6) as A_6,SUM(A_7) as A_7,SUM(A_8) as A_8,SUM(A_9) as A_9,SUM(A_10) as A_10,SUM(A_11) as A_11,SUM(A_12) as A_12,SUM(A_13) as A_13,SUM(A_14) as A_14,SUM(A_15) as A_15,(A_0 * 1) as B_0,(A_1 * 1.5) as B_1,(A_2 * 3.5) as B_2,(A_3 * 6.5) as B_3,(A_4 * 12.5) as B_4,(A_5 * 24.5) as B_5,(A_6 * 48.5) as B_6,(A_7 * 96.5) as B_7,(A_8 * 192.5) as B_8,(A_9 * 384.5) as B_9,(A_10 * 768.5) as B_10,(A_11 * 1536.5) as B_11,(A_12 * 3072.5) as B_12,(A_13 * 6144.5) as B_13,(A_14 * 12288.5) as B_14,(A_15 * 16385) as B_15, cast(100*((B_1+B_2+B_3+B_4+B_5+B_6+B_7+B_8+B_9+B_10+B_11+B_12+B_13+B_14+B_15)/(B_0+B_1+B_2+B_3+B_4+B_5+B_6+B_7+B_8+B_9+B_10+B_11+B_12+B_13+B_14+B_15)) as dec(19,5)) as C_1...

Example of Query Power 3G Data ENIQ with Vector INDEX

The following is an example of an Ericsson ENIQ SQL Query for finding the daily aggregated Power Average in Watts and dBm.   SELECT Date_ID,RNC,RBS,Sector,Carrier, cast((SUM(A_0)+SUM(A_1)+SUM(A_2)+SUM(A_3)+SUM(A_4)+SUM(A_5)+SUM(A_6)+SUM(A_7)+SUM(A_8)+SUM(A_9)+SUM(A_10)+SUM(A_11)+SUM(A_12)+SUM(A_13)+SUM(A_14)+SUM(A_15)+SUM(A_16)+SUM(A_17)+SUM(A_18)+SUM(A_19)+SUM(A_20)+SUM(A_21)+SUM(A_22)+SUM(A_23)+SUM(A_24)+SUM(A_25)+SUM(A_26)+SUM(A_27)+SUM(A_28)+SUM(A_29)+SUM(A_30)+SUM(A_31)+SUM(A_32)+SUM(A_33)+SUM(A_34)+SUM(A_35)+SUM(A_36)+SUM(A_37)+SUM(A_38)+SUM(A_39)+SUM(A_40)+SUM(A_41)+SUM(A_42)+SUM(A_43)+SUM(A_44)+SUM(A_45)+SUM(A_46)+SUM(A_47)+SUM(A_48)+SUM(A_49)+SUM(A_50)+SUM(A_51)) as float) as TS,  cast (((SUM(A_0) * 0) +(SUM(A_1) * 0.5) +(SUM(A_2) * 1.5) +(SUM(A_3) * 2.5) +(SUM(A_4) * 3.5) +(SUM(A_5) * 4.5) +(SUM(A_6) * 5.5) +(SUM(A_7) * 6.5) +(SUM(A_8) * 7.5) +(SUM(A_9) * 8.5) +(SUM(A_10) * 9.5) +(SUM(A_11) * 10.5) +(SUM(A_12) * 11.5) +(SUM(A_13) ...

Decimal Auto Dash Number To HEX

Image
Decimal Number To Hexadecimal Converter Tools This is the code calculator for the dashboard in Kilometres. The resulting code is one of the 5 codes that appear below. Please discuss in the comments column if there are difficulties. Edit EEPROM at spesific memory address acording to type of device, for example shown in picture below honda with EEPROM 93C76 Disclaimer : The use of this software is intended for repair purposes only or experimental, we are not responsible for the misuse of this software resulting in criminal acts according to applicable state laws. Thank you for reading. This tools maybe save your live, so please donate to support me through my paypal https://www.paypal.me/aesixnet Note Please enter a description USD Please enter a price Please enter an Invoice ID

Ericsson Statsfile to Database Parser

Image
  Tool Name : ExpOSS  Compliance : 3GPP 32.435 V10.0 & 32.401 V6.2  Application   : RNC, NodeB, EnodeB Table Of Contents 1. Goals 2. Ericsson 3G & 4G LTE Statsfile 3. Hardware & Operating System Platform 4. Installations, Operations & Maintenance 5. Support 1. Goals - Build alternative performance data collection system, as we know Ericsson has ENIQ. - Make everything simple, Build Light System in Inexpensive Hardware. - Source Codes are open for continuity in order to follow Ericsson system upgraded. - Target System Owner : Ericsson STS Provider. 2. Ericsson 3G & 4G LTE Statsfile - RNC : 3GPP 32.401 OSS RC dir : /var/opt/ericsson/nms_umts_wran_pms OSS ENM dir : /ericsson/pmic1 & /ericsson/pmic2 - RBS : 3GPP 32.435 & 32.401 ...