Provide FREE SID (together with current XE)

[mvorisek]

To allow easier migration to https://github.com/gvenzl/oci-oracle-free/issues, especially to test both in CI, please provide together with the current XE service also FREE, so the image name is enough to parametrize the database version.

[gvenzl]

Hey @mvorisek,

Thanks for this excellent idea, I like it!
This will indeed make the migration to the new Oracle Database Free much easier going forward.

Will work on it.

[gvenzl]

Fixed and will release this weekend.

[mvorisek]

In doctrine/dbal project the following easy connect string (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=localhost)(PORT=1521))(CONNECT_DATA=(SID=FREE))) is still not working with v<23. localhost/free works however. Any idea, is SID emulated well enough?

repro: mvorisek/dbal@2caad21...debug_oci (the repo can be cloned and CI run with a git/Github push)

[mprins]

I'm seeing the same problem

RestartSequenceIntegrationTest.testRestartSequence:50 » SQL ORA-12505: Cannot connect to database. SID FREE is not registered with the listener at host localhost port 15210. (CONNECTION_ID=zS7lxokVStmpWGHYrZ4F7A==)

in B3Partners/jdbc-util#541 using oracle-xe:21.3.0-full (https://github.com/B3Partners/jdbc-util/actions/runs/7424340272/job/20203741000?pr=541)

[mprins]

changing the JDBC url from:
jdbc:oracle:thin:@localhost:15210:FREE
to
jdbc:oracle:thin:@localhost:15210/FREE
fixed things for me as it now connects to the service and not the SID

[mvorisek]

Thank you, you identified the problem - we need to provide FREE SID instead of only FREE service name! Would you be able to send a PR to improve 0cedd27 to provide also FREE SID?

[gvenzl]

Hey @mvorisek,

The ORACLE_SID for Oracle XE cannot be changed, it's fixed to XE (just like for Oracle Free it's fixed to FREE). So you will have to connect via the service name if you want to use FREE.