UNA Desktop and Oracle Client 12.2

Instructions for any Grok builder, in any tenancy. Leave every existing Windows instance alone. Do not stop, start, terminate, resize, reinstall, or relaunch one. The only disk change is a new additional block volume of 256 GB, brought online as D: or the next free letter. Install UNA Desktop and Oracle Client 12.2 from the UNISIM-SOFT host onto that new volume. Do not record tenancy names, OCIDs, public IPs, passwords, or wallet files.

Each dark block is Markdown. Copy one block into the next Grok session as its task.

Links

What to install

PieceFileBytes
UNA Desktop, current full packageUNA.md-260710-5.77.1.20.zip110097191
Core Files 12.2, includes UNA Oracle client files and tnsnamesInstallCoreFiles_12.exe1146140169
Oracle Client 12.2 fulloracle_client_12.2_full.rar1125054425
7-Zip7z2501-x64.execheck the vendor page

A name such as “UNA Desktop 5.20” on a request means this full desktop package, UNA.md-260710-5.77.1.20, unless a newer zip is listed in the desktop folder. Prefer the newest full desktop zip on that host, and record its exact size before you install.

1. Add a 256 GB block volume. Do not change existing Windows

```markdown
# Task: new 256 GB block volume as D: or the next free letter

Do not do anything to an existing Windows instance except attach this new data volume.
Do not stop, start, terminate, reset, or resize a Windows instance.
Do not resize its boot volume. Do not reinstall Windows. Do not delete another instance or volume to free quota.

Work in the tenancy this session is already authenticated to.

1. Pick the Windows instance the operator already has. Read its availability domain. A block volume must be created in that same availability domain.
2. Create one additional block volume, 256 GB. This is not a boot volume and it does not replace C:.

   oci bv volume create \
     --compartment-id $OCI_TENANCY \
     --availability-domain $AD \
     --display-name una-data-256 \
     --size-in-gbs 256 \
     --vpus-per-gb 10

3. Attach it as a paravirtualized data disk. Do not use --type boot.

   oci compute volume-attachment attach \
     --instance-id $INSTANCE \
     --volume-id $VOLUME \
     --type paravirtualized

4. On that Windows host, as Administrator, bring online only the new raw disk. Assign D: if D: is free. If D: is already used, assign the next free letter and use that letter everywhere below. Do not touch disk 0 or C:.

   $disk = Get-Disk | Where-Object PartitionStyle -eq 'RAW' | Select-Object -First 1
   Initialize-Disk -Number $disk.Number -PartitionStyle GPT
   $used = (Get-Partition | Where-Object DriveLetter).DriveLetter
   $letter = @('D','E','F','G','H') | Where-Object { $_ -notin $used } | Select-Object -First 1
   New-Partition -DiskNumber $disk.Number -UseMaximumSize -DriveLetter $letter
   Format-Volume -DriveLetter $letter -FileSystem NTFS -NewFileSystemLabel DATA -Confirm:$false
   Get-Volume -DriveLetter $letter

5. Done when Get-Volume shows that letter at about 256 GB. If create returns LimitExceeded, stop and report the quota. Do not shrink or delete an existing volume to make the 256 GB fit.
```

2. Download from the same source

```markdown
# Task: download UNA Desktop, Core Files 12.2, and Oracle Client 12.2

Run on the Windows server. Put files on the new 256 GB volume (D:, or the letter chosen in task 1). Do not write these downloads onto C:. Source host is installunamd.unisim-soft.com. Do not use a different mirror.

mkdir D:\UNA\setup
curl.exe -L --retry 5 -o D:\UNA\setup\UNA.md-260710-5.77.1.20.zip http://installunamd.unisim-soft.com/desktop/UNA.md-260710-5.77.1.20.zip
curl.exe -L --retry 5 -o D:\UNA\setup\InstallCoreFiles_12.exe http://installunamd.unisim-soft.com/soft/InstallCoreFiles_12.exe
curl.exe -L --retry 5 -o D:\UNA\setup\oracle_client_12.2_full.rar http://installunamd.unisim-soft.com/soft/oracle_client_12.2_full.rar
curl.exe -L --retry 5 -o D:\UNA\setup\7zsetup.exe https://www.7-zip.org/a/7z2501-x64.exe

Expected sizes:
- UNA.md-260710-5.77.1.20.zip = 110097191
- InstallCoreFiles_12.exe = 1146140169
- oracle_client_12.2_full.rar = 1125054425

If a size does not match, open http://installunamd.unisim-soft.com/desktop/ and http://installunamd.unisim-soft.com/soft/ and take the current full desktop zip plus InstallCoreFiles_12.exe and oracle_client_12.2_full.rar. Do not switch to another vendor.
```

3. Install Oracle Client 12.2 and Core Files 12.2

```markdown
# Task: install Oracle Client 12.2, then Core Files 12.2

Run as a local Administrator. The Cloud Agent account cannot install these.

Use D: below. If task 1 assigned another letter, use that letter instead. Do not install onto C:.

1. Install 7-Zip silently:
   Start-Process D:\UNA\setup\7zsetup.exe -ArgumentList '/S' -Wait
2. Extract the client:
   & "C:\Program Files\7-Zip\7z.exe" x -y "-oD:\UNA\setup\oracle" D:\UNA\setup\oracle_client_12.2_full.rar
3. Write D:\UNA\setup\client12.rsp with these lines:
   oracle.install.responseFileVersion=/oracle/install/rspfmt_clientinstall_response_schema_v12.2.0
   ORACLE_HOSTNAME=localhost
   INVENTORY_LOCATION=D:\Oracle\Inventory
   SELECTED_LANGUAGES=en
   ORACLE_HOME=D:\Oracle\product\12.2.0\client_1
   ORACLE_BASE=D:\Oracle
   oracle.install.client.installType=Administrator
4. Find setup.exe under D:\UNA\setup\oracle and run:
   setup.exe -silent -nowait -ignoreSysPrereqs -responseFile D:\UNA\setup\client12.rsp
5. Install Core Files 12.2. This package also lays down the UNA Oracle client files and tnsnames:
   Start-Process D:\UNA\setup\InstallCoreFiles_12.exe -ArgumentList '/VERYSILENT /NORESTART' -Wait
   If that returns non-zero, try /S and then /silent. If all of those return non-zero, run the exe on the RDP desktop and click through it.
6. Confirm:
   Test-Path D:\Oracle\product\12.2.0\client_1\bin\sqlplus.exe
   Get-ChildItem -Recurse D:\Oracle,D:\UNA -Filter tnsnames.ora -ErrorAction SilentlyContinue | Select-Object -Expand FullName
```

4. Install the UNA Desktop application

```markdown
# Task: install UNA Desktop

Expand-Archive -Force D:\UNA\setup\UNA.md-260710-5.77.1.20.zip D:\UNA\app
The client program is UniacCLNT.exe inside that folder.

Launch UniacCLNT.exe only after Core Files 12.2 has finished. That installer supplies the Oracle client pieces and tnsnames the desktop uses.
```

5. Database check with sqlplus

```markdown
# Task: test sqlplus

Do this only after sqlplus.exe exists.

Ask the operator for three values. Do not invent them:
- TNS alias
- database user
- password

If the alias is an Autonomous Database and it is missing from tnsnames.ora, download that database wallet from the OCI console and set TNS_ADMIN to the unzipped wallet. mTLS databases need the wallet. Do not put the wallet password or the database password in a script, a run command, or a web page.

Test:
sqlplus <user>/<password>@<alias>
select user from dual;
```

6. Storage rules

```markdown
# Task: storage rules

- The data disk is a new 256 GB block volume. It is not the boot volume, not C:, and not an Object Storage bucket.
- Do not grow an existing boot volume. Do not mount a bucket as a drive letter.
- Do not delete an existing Windows instance, its boot volume, or folders already on C: to make room.
- If the 256 GB create is refused with LimitExceeded, stop and report the quota. Always Free block storage is 200 GB per availability domain and 200 GB regional, so 256 GB does not fit on an Always Free account. A paid quota is required. Do not substitute a smaller volume unless the operator asks.
```