Install_front_casa

Back: Cash scheme and front-office

Victor Starshiy, [26.04.2023 17:24]  
On the cash server:

Unpack the files into  
C:\unisim\casa  

Start SQL*Plus as superuser:

  
  sqlplus / as sysdba  

Execute:

  
  select username from all_users where username in  
('UN4PUBLIC', 'UNIREST_PUBLIC');  

It should return both schemas.  
Execute:

  
  @C:\unisim\casa\casa.user.sql  
  exit  

Import the dump:

  
  imp casa/casa file=C:\unisim\casa\casa0.dmp  
log=C:\unisim\casa\casa_imp.log fromuser=casa  

Start SQL*Plus again as superuser:

  
  sqlplus / as sysdba  
Execute:  
  @C:\unisim\casa\casa.user.AfterImport.sql  
  exit  

Edit `C:\unisim\casa\pos.params.sql` and set the values of parameters  
`ServerID` and `GlobalDep` as required.  

Start SQL*Plus under *casa* user:  

  
  sqlplus casa/casa  

Execute:  

  
  @C:\unisim\casa\pos.params.sql  
  desc dual@RGP.WORLD  
  exit  

Edit `C:\unisim\casa\rogob.casas.sql` and set  
`nrset_23_dig`, `nrbomba`, `server_id`, `cod_univ` to the correct values.  
In the link `POS<nn>R.WORLD` set the proper number (twice),  
and when creating the link, change the IP address to the correct one.  

Start SQL*Plus on the back-end (password required):  

  
  sqlplus market@market  

Execute:  

  
  @C:\unisim\casa\rogob.casas.sql  
  desc dual@POS<nn>R.WORLD  
  exit  

If no errors occurred, the installation was successful.  

Victor Starshiy, [26.04.2023 17:29]  
The archive cannot be placed in OTRS – it is too large. Upload it here?  

Victor Starshiy, [26.04.2023 17:52]  
For the first time, it is better to work according to the instruction under my supervision.  
Afterwards – only for deviations.  

  
Victor Starshiy, [04.05.2023 13:27]  
I simplified the instruction and further automated the scripts.  
Now nothing needs to be changed. The scripts  
"peek" the required data from the old *pos* schema.  
It is assumed that the 3rd component of the store’s IP address represents its number.