romfast/ROMFASTSQL
1
0
Fork 0
Code Issues Pull Requests Actions Packages Projects Releases Wiki Activity
100 Commits 1 Branch 0 Tags
master
Commit Graph

3 Commits

Author SHA1 Message Date
Marius
f50bfcf8d8 Fix DMPDIR handling and datafile auto-detection for ROA Windows setup 
- New-OracleDirectory: Improved verification with direct SQL check, preserves
  existing DMPDIR path instead of blindly recreating
- Get-DatafilePath: Better fallback logic using ORACLE_HOME to derive path,
  no longer hardcodes C:\app\oracle
- grants-public.sql: Fixed DMPDIR creation - now preserves existing path
  instead of overriding with wrong D:\Oracle\admin\ORCL\dpdump
- config.example.ps1: Added DATAFILE_DIR parameter with documentation

These fixes ensure scripts work without manual intervention on fresh Oracle XE
installations where default DMPDIR points to non-existent paths.

Tested on VM 302 - full installation (01-08) now completes successfully.

Co-Authored-By: Claude Opus 4.5 <noreply@anthropic.com>
 2026-01-29 02:38:54 +02:00
Marius
ed3f5f2c43 Simplify config.example.ps1 with default values 
- SYSTEM_PASSWORD: romfastsoft
- CONTAFIN_PASSWORD: ROMFASTSOFT (uppercase)
- COMPANY_PASSWORD: ROMFASTSOFT (uppercase)
- SERVICE_NAME: XEPDB1
- DMPDIR: C:\DMPDIR
- ROAUPDATE_BASE_PATH: D:\ROAUPDATE

Co-Authored-By: Claude Opus 4.5 <noreply@anthropic.com>
 2026-01-29 01:50:23 +02:00
Marius
989477f7a4 Add ROA Oracle Database Windows setup scripts with old client support 
PowerShell scripts for setting up Oracle 21c/XE with ROA application:
- Automated tablespace, user creation and imports
- sqlnet.ora config for Instant Client 11g/ODBC compatibility
- Oracle 21c read-only Home path handling (homes/OraDB21Home1)
- Listener restart + 10G password verifier for legacy auth
- Tested on VM 302 with CONTAFIN_ORACLE schema import

Co-Authored-By: Claude Opus 4.5 <noreply@anthropic.com>
 2026-01-28 17:08:02 +02:00