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:11] – [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 360: Line 350:
      Multitenant container database: vm3.kewl.org      Multitenant container database: vm3.kewl.org
 </code> </code>
 +
 +__Listener__
 +
 +Edit the .ora files in the following directory and change the hostname to 0.0.0.0
  
 <code> <code>
Line 365: Line 359:
 </code> </code>
  
-Edit the .ora files and change the hostname to 0.0.0.0.+
 ===Oracle DB Systemd=== ===Oracle DB Systemd===
  
 ==23c== ==23c==
 +
 +__Stop__
 +<code>
 +/etc/init.d/oracle-free-23c stop
 +</code>
 +
  
 __Start__ __Start__
Line 383: Line 383:
  
 ==23ai== ==23ai==
 +
 +__Stop__
 +<code>
 +/etc/init.d/oracle-free-23ai stop
 +</code>
  
 __Start__ __Start__
Line 564: Line 569:
 SQL> SQL>
 </code> </code>
-===Oracle DB Setup====+===Oracle DB Setup (optional) ====
  
 ==23c or 23ai== ==23c or 23ai==
Line 856: 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 940: Line 947:
 <?php <?php
 /* /*
- * PHP test for Oracle 23c+ * PHP test for Oracle 23ai
  */  */
  
Line 948: Line 955:
  * Connect to PDB  * Connect to PDB
  */  */
-$con = oci_connect('db1user', 'db1passwd', 'vm3.kewl.org/DB1');+$con = oci_connect('dbuser', 'dbpasswd', '192.168.0.113/FREEPDB1');
 if ($con === false) if ($con === false)
     die("Connect error\n");     die("Connect error\n");
Line 1040: 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]]