You are here: start » tools » oracle

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revisionPrevious revision
Next revision		Previous revision
tools:oracle [2024/10/13 04:22] – [Oracle DB Demo Database] darrontools:oracle [2024/10/13 22:26] (current) – [Resources] darron
Line 1: Line 1:
 ====Oracle==== ====Oracle====
  
-This is a demo install of Oracle Database Server 21c and 23c on Oracle Linux 8.+This is a demo install of Oracle Database Server 21c, 23c and 23ai on Oracle Linux.
  
 ===Environment=== ===Environment===
Line 9: Line 9:
 ===Operating system=== ===Operating system===
  
-Oracle Linux 8 is preferred since version 9 is not supported +Use Oracle Linux 8.10 for Oracle Database 21c or 23c and Oracle Linux 9.4 for Oracle Database 23ai.
-by Oracle database server RPMs at this time (Feb 2024).+
  
 [[https://yum.oracle.com/oracle-linux-isos.html|Oracle Linux ISO Downloads]] [[https://yum.oracle.com/oracle-linux-isos.html|Oracle Linux ISO Downloads]]
  
-==Oracle Linux 8.5== +==Oracle Linux 8.10==
- +
-OracleLinux-R8-U5-x86_64-dvd.iso +
- +
-==Oracle Linux 8.9== +
- +
-OracleLinux-R8-U9-x86_64-dvd.iso +
- +
-==Oracle Linux 9.3== +
- +
-OracleLinux-R9-U3-x86_64-dvd.iso+
  
 +[[https://yum.oracle.com/ISOS/OracleLinux/OL8/u10/x86_64/OracleLinux-R8-U10-x86_64-dvd.iso|OracleLinux-R8-U10-x86_64-dvd.iso]]
 ==Oracle Linux 9.4== ==Oracle Linux 9.4==
  
Line 75: Line 65:
 ===Firewall=== ===Firewall===
  
-Disable the firewall is network connections to the database are required.+Disable the firewall since a network connection to the database is required.
  
 <code> <code>
Line 361: Line 351:
 </code> </code>
  
-==Listener==+__Listener__
  
 Edit the .ora files in the following directory and change the hostname to 0.0.0.0 Edit the .ora files in the following directory and change the hostname to 0.0.0.0
Line 373: Line 363:
  
 ==23c== ==23c==
 +
 +__Stop__
 +<code>
 +/etc/init.d/oracle-free-23c stop
 +</code>
 +
  
 __Start__ __Start__
Line 387: Line 383:
  
 ==23ai== ==23ai==
 +
 +__Stop__
 +<code>
 +/etc/init.d/oracle-free-23ai stop
 +</code>
  
 __Start__ __Start__
Line 568: Line 569:
 SQL> SQL>
 </code> </code>
-===Oracle DB Setup====+===Oracle DB Setup (optional) ====
  
 ==23c or 23ai== ==23c or 23ai==
Line 860: Line 861:
 GRANT CREATE SESSION TO dbuser CONTAINER=CURRENT; GRANT CREATE SESSION TO dbuser CONTAINER=CURRENT;
 GRANT CREATE TABLE TO dbuser CONTAINER=CURRENT; GRANT CREATE TABLE TO dbuser CONTAINER=CURRENT;
 +GRANT CREATE TYPE TO dbuser  CONTAINER=CURRENT;
 +GRANT CREATE PROCEDURE TO dbuser CONTAINER=CURRENT;
 ALTER USER dbuser QUOTA UNLIMITED ON USERS CONTAINER=CURRENT; ALTER USER dbuser QUOTA UNLIMITED ON USERS CONTAINER=CURRENT;
 </code> </code>
Line 1044: Line 1047:
 [[https://www.php.net/manual/en/ref.oci8.php|PHP OCI8 Reference Guide]] [[https://www.php.net/manual/en/ref.oci8.php|PHP OCI8 Reference Guide]]
  
 +[[https://docs.oracle.com/en/database/oracle/oracle-database/19/lnpcc/c-c-programmers-guide.pdf|C Programmers Guide]]
 +
 +[[https://docs.oracle.com/en/database/oracle/oracle-database/18/lnoci/oci-demo-programs.html|C Demo Code overview]]
 +
 +[[https://github.com/oleksiivorobiov/oracle_oci_examples/|Demo Code including C]]
 +
 +[[https://www.oracle.com/database/technologies/instant-client/linux-x86-64-downloads.html|Instant client for Linux]]
 +
 +[[https://www.oracle.com/database/technologies/instant-client/precompiler-downloads.html|Pro C pre-compiler]]