Skip to content
Branch: master
Find file History
Fetching latest commit…
Cannot retrieve the latest commit at this time.
Permalink
Type Name Latest commit message Commit time
..
Failed to load latest commit information.
Dockerfile
README.adoc
init.sql

README.adoc

Oracle XE from the Dockerhub

To run

docker build . -t oraclexe
docker run -d -p 49160:22 -p 1521:1521 -e ORACLE_ALLOW_REMOTE=true oraclexe

To connect remotely by SQL*Plus you need to

  1. Download: http://www.oracle.com/technetwork/topics/linuxx86-64soft-092277.html : instantclient-sqlplus-linux.x64-12.1.0.2.0.zip

  2. Unzip

  3. Configure PATH for LD LIBRARY: https://docs.oracle.com/en/database/oracle/oracle-database/12.2/sqpug/SQL-Plus-instant-client.html#GUID-101860A8-159E-45E5-92AF-DEFECE2089E0 ` export LD_LIBRARY_PATH=${PWD}:${LD_LIBRARY_PATH} `

  4. Run ` ./sqlplus system/oracle@localhost:1521/XE `

Check XA transactions

-- what are currently in-doubt transactions at Oracle side
select * from DBA_2PC_PENDING;

-- connect as system/oracle
rollback force '5.19.150115';
execute dbms_transaction.purge_lost_db_entry('5.19.150115');
You can’t perform that action at this time.