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?