Skip to Content
Last modified by Chiorescu Gheorghe on 2025/08/22 12:14
Show last authors
1 [[Back: Cash scheme and front-office>>http://xwiki.una.md/bin/view/Instructiion_Retail_una/Cash_scheme_and_frontoffice||rel="__blank" style="font-family: sans-serif; font-size: 11.6667px; font-style: normal; font-weight: 400; text-align: left;" target="_blank" title="Back: Cash scheme and front-office"]]
2
3 Victor Starshiy, [26.04.2023 17:24]
4 On the cash server:
5
6 Unpack the files into
7 C:\unisim\casa
8
9 Start SQL*Plus as superuser:
10
11 (% style="font-size: 14px; font-family: Consolas; background-color:#fbfdff" %)
12 sqlplus / as sysdba
13
14 Execute:
15
16 (% style="font-size: 14px; font-family: Consolas; background-color:#fbfdff" %)
17 select username from all_users where username in
18 ('UN4PUBLIC', 'UNIREST_PUBLIC');
19
20 It should return both schemas.
21 Execute:
22
23 (% style="font-size: 14px; font-family: Consolas; background-color:#fbfdff" %)
24 @C:\unisim\casa\casa.user.sql
25 exit
26
27 Import the dump:
28
29 (% style="font-size: 14px; font-family: Consolas; background-color:#fbfdff" %)
30 imp casa/casa file=C:\unisim\casa\casa0.dmp
31 log=C:\unisim\casa\casa_imp.log fromuser=casa
32
33 Start SQL*Plus again as superuser:
34
35 (% style="font-size: 14px; font-family: Consolas; background-color:#fbfdff" %)
36 sqlplus / as sysdba
37 Execute:
38 @C:\unisim\casa\casa.user.AfterImport.sql
39 exit
40
41 Edit `C:\unisim\casa\pos.params.sql` and set the values of parameters
42 `ServerID` and `GlobalDep` as required.
43
44 Start SQL*Plus under *casa* user:
45
46 (% style="font-size: 14px; font-family: Consolas; background-color:#fbfdff" %)
47 sqlplus casa/casa
48
49 Execute:
50
51 (% style="font-size: 14px; font-family: Consolas; background-color:#fbfdff" %)
52 @C:\unisim\casa\pos.params.sql
53 desc dual@RGP.WORLD
54 exit
55
56 ===========================================================================================
57
58 Edit `C:\unisim\casa\rogob.casas.sql` and set
59 `nrset_23_dig`, `nrbomba`, `server_id`, `cod_univ` to the correct values.
60 In the link `POS<nn>R.WORLD` set the proper number (twice),
61 and when creating the link, change the IP address to the correct one.
62
63 Start SQL*Plus on the back-end (password required):
64
65 (% style="font-size: 14px; font-family: Consolas; background-color:#fbfdff" %)
66 sqlplus market@market
67
68 Execute:
69
70 (% style="font-size: 14px; font-family: Consolas; background-color:#fbfdff" %)
71 @C:\unisim\casa\rogob.casas.sql
72 desc dual@POS<nn>R.WORLD
73 exit
74
75 If no errors occurred, the installation was successful.
76
77 Victor Starshiy, [26.04.2023 17:29]
78 The archive cannot be placed in OTRS – it is too large. Upload it here?
79
80 Victor Starshiy, [26.04.2023 17:52]
81 For the first time, it is better to work according to the instruction under my supervision.
82 Afterwards – only for deviations.
83
84 -----------------------------------------------------
85 Victor Starshiy, [04.05.2023 13:27]
86 I simplified the instruction and further automated the scripts.
87 Now nothing needs to be changed. [[The scripts>>https://xwiki.una.md/bin/download/UNA/Install_front_casa/RogobCasaBdInstallScripts.zip]]
88 "peek" the required data from the old *pos* schema.
89 It is assumed that the 3rd component of the store’s IP address represents its number.