Oracle 23C Free下载安装及测试

产品页面：https://www.oracle.com/database/free
下载地址：
Docker：https://container-registry.oracle.com/
VM：https://www.oracle.com/database/technologies/databaseappdev-vm.html
Linux RPM：https://www.oracle.com/database/technologies/free-downloads.html
在线文档：https://docs.oracle.com/en/database/oracle/oracle-database/23/index.html
复制

Oracle Database Free Downloads
Oracle Database 23c Free
(1,758,776,440 bytes - March 31, 2023)
[Sha256sum: 63b6c0ec9464682cfd9814e7e2a5d533139e5c6aeb9d3e7997a5f976d6677ca6]
复制

Installing Oracle Database Free RPM
1.Use sudo to log in as root.
$ sudo -s


2.Run the Oracle Database Preinstallation RPM.
Oracle Linux 8
a.Enable the Oracle Linux 8 Developer channel:
# dnf config-manager --set-enabled ol8_developer
b.Run the Preinstallation RPM:
dnf -y install oracle-database-preinstall-23c


3.Access the Oracle Database Free software download page:
https://www.oracle.com/database/technologies/free-downloads.html
4.Download the oracle-database-free-23c-1.0-1.el8.x86_64.rpm RPM file required for performing an RPM-based installation to a directory of your choice.
5.Install the database software.
# dnf -y localinstall oracle-database-free-23c-1.0-1.el8.x86_64.rpm
复制

Oracle Linux 8.7
Oracle Database 23.2 Free - Developer Release for Linux x86-64
Oracle REST Data Services 23.1
Oracle SQLcl 23.1
Oracle APEX 22.2
复制

6,996,213,760 bytes bytes, md5sum:a802c5870e0c42da25e0d351a822320a , sha1:c6b2925eae4351376c15144ae278162ba533350d
复制

1.在您的主机系统上下载并安装Oracle VM VirtualBox。
Step 1. Download and install Oracle VM VirtualBox on your host system.
2.导入虚拟机
Step 2. Import your VM: File > Import Appliance to launch Appliance Import Wizard. Click Choose... to browse to the directory you re-assembled all the files in and select the Oracle_Database_23c_Free_Developer_Appliance.ova then click Next> to begin importing the virtual machine. It will prompt you to agree to the appropriate Oracle licenses while importing. You will see 'Oracle Database 23c Free - Developer' when it is finished importing.
3.测试虚拟机
Step 3. Test your VM: Once the import has completed, double-click the 23c Free - Developer VM. Click OK to close the Virtualbox Information dialogs. Allow the boot and startup process to complete; it is ready when you see a Firfox browser and/or terminal window. Once you are finished working in the guest VM you can shut it down via System > Shut Down; this will return the guest VM to the Powered Off state.
复制

SELECT SYSDATE FROM DUAL;
SELECT SYSDATE;
复制

alter system set MAX_COLUMNS=EXTENDED;
复制

grant select any table on SCHMEA PROD to HR;
复制

create table t2(name varchar2(100),ac BOOLEAN);
INSERT INTO t2 VALUES('chen',1);
INSERT INTO t2 VALUES('ju',True);
INSERT INTO t2 VALUES('chao',1);
INSERT INTO t2 VALUES('cjc',FALSE);
select name from t2 where ac;
复制

select extract(year FROM hire_date) as hire_year,count(*)
from employees
group by extract(year FROM hire_date)
having extract(year FROM hire_date)>1985;
复制

select extract(year FROM hire_date) as hire_year,count(*)
from employees
group by hire_year
having hire_year>1985;
复制