f50bfcf8d8
- 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>
50 lines
2.0 KiB
PowerShell
50 lines
2.0 KiB
PowerShell
# =============================================================================
|
|
# ROA Oracle Database Setup Configuration
|
|
# =============================================================================
|
|
# Usage:
|
|
# 1. Copy to config.ps1: Copy-Item config.example.ps1 config.ps1
|
|
# 2. Edit values as needed
|
|
# 3. Run setup scripts
|
|
# =============================================================================
|
|
|
|
# -----------------------------------------------------------------------------
|
|
# Oracle Installation
|
|
# -----------------------------------------------------------------------------
|
|
|
|
# Oracle Home - auto-detected if $null
|
|
$ORACLE_HOME = $null # e.g., "C:\app\romfast\product\21c\dbhomeXE"
|
|
|
|
# Service Name (XEPDB1 for Oracle XE, ROA for Standard Edition)
|
|
$SERVICE_NAME = "XEPDB1"
|
|
|
|
# -----------------------------------------------------------------------------
|
|
# Passwords
|
|
# -----------------------------------------------------------------------------
|
|
|
|
# SYS/SYSTEM password (set during Oracle installation)
|
|
$SYSTEM_PASSWORD = "romfastsoft"
|
|
|
|
# CONTAFIN_ORACLE schema password (MUST be UPPERCASE!)
|
|
$CONTAFIN_PASSWORD = "ROMFASTSOFT"
|
|
|
|
# Default password for company schemas (MUST be UPPERCASE!)
|
|
$COMPANY_PASSWORD = "ROMFASTSOFT"
|
|
|
|
# -----------------------------------------------------------------------------
|
|
# Paths
|
|
# -----------------------------------------------------------------------------
|
|
|
|
# Directory for DMP files (Data Pump import/export)
|
|
$DMPDIR = "C:\DMPDIR"
|
|
|
|
# Datafile directory for tablespace ROA
|
|
# Auto-detected from database if not set. Set this if auto-detection fails.
|
|
# Common paths:
|
|
# XE 21c: C:\app\<user>\product\21c\oradata\XE\XEPDB1
|
|
# SE 21c: C:\app\<user>\oradata\ROA
|
|
# To find actual path: SELECT file_name FROM dba_data_files WHERE ROWNUM = 1;
|
|
$DATAFILE_DIR = $null # e.g., "C:\app\romfast\product\21c\oradata\XE\XEPDB1"
|
|
|
|
# ROAUPDATE base path (for automatic updates module)
|
|
$ROAUPDATE_BASE_PATH = "D:\ROAUPDATE"
|