Skip to content

Instantly share code, notes, and snippets.

@hobu
Created December 15, 2016 05:11
Show Gist options
  • Save hobu/177729da514266fdeb71e59a3a1146d6 to your computer and use it in GitHub Desktop.
Save hobu/177729da514266fdeb71e59a3a1146d6 to your computer and use it in GitHub Desktop.
PDAL oracle test procedure
docker pull sath89/oracle-12c
mkdir oracle
docker run -d \
-p 8080:8080 \
-p 1521:1521 \
-v `pwd`/oracle:/u01/app/oracle \
-e DBCA_TOTAL_MEMORY=1024 \
sath89/oracle-12c
# wait about 10 minutes while oracle init's and wakes up
# sqlplus system/oracle@//localhost:1521/xe.oracle.docker
# SQL > create user lidar identified by lidar;
# SQL > grant all privileges to lidar;
# SQL > grant create session to lidar;
# SQL > EXECUTE MDSYS.enableGeoRaster;
# configure cmake with -DOCI_CONNECTION="lidar/lidar@localhost:1521/xe.oracle.docker"
# rebuild everything
# ./bin/ocitest
# [hobu@pyro pdal (master)]$ ./bin/ocitest
# [==========] Running 5 tests from 1 test case.
# [----------] Global test environment set-up.
# [----------] 5 tests from OCITest
# [ RUN ] OCITest.dim_major_unscaled
# ERROR 1: ORA-00942: table or view does not exist
#
# ERROR 1: ORA-00942: table or view does not exist
#
# [ OK ] OCITest.dim_major_unscaled (3306 ms)
# [ RUN ] OCITest.dim_major_scaled
# [ OK ] OCITest.dim_major_scaled (3650 ms)
# [ RUN ] OCITest.point_major_unscaled
# [ OK ] OCITest.point_major_unscaled (3604 ms)
# [ RUN ] OCITest.point_major_unscaled_compressed
# [ OK ] OCITest.point_major_unscaled_compressed (3683 ms)
# [ RUN ] OCITest.point_major_scaled
# [ OK ] OCITest.point_major_scaled (3855 ms)
# [----------] 5 tests from OCITest (18098 ms total)
#
# [----------] Global test environment tear-down
# [==========] 5 tests from 1 test case ran. (18098 ms total)
# [ PASSED ] 5 tests.
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment