Hi All,
Oracle has recently launched the Oracle database 23c Free Developer Release , in this post i am sharing how launch this on Oracle VM VitualBox 7.0.
Access the below URL and download the
https://www.oracle.com/database/technologies/databaseappdev-vm.html
Setup
Step 1. Download and install Oracle VM VirtualBox on your host system.
Download .... > Oracle DB Developer VM .
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.
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.
Follow the below instruction's to access the Oracle 23C database on VM.
Oracle Database 23c Free – Developer Release is the first release of the next-generation Oracle Database, allowing developers a head-start on building applications with innovative 23c features that simplify development of modern data-driven apps. The entire feature set of Oracle Database 23c is planned to be generally available within the next 12 months.
Please note that this appliance is for testing purposes only as such it is unsupported and should not be used as a production environment.
Database Information
Oracle SID : free
Pluggable DB : freepdb1
ALL PASSWORDS ARE : oracle
Sample schemas have been preloaded (HR, OE, PM, IX, BI, AV, SH) for your convenience.
Oracle REST Data Service (ORDS) and APEX are both installed, configured, and available at startup. Port Forwards are defined for HTTP and SQL*Net, these are configurable in the Virtual Machine settings.
8080:8080
1521:1521
From your host, simply launch:
http://localhost:8080/ords to launch APEX
http://localhost:8080/ords/sql-developer to start SQL Developer Web
sql hr/oracle@localhost:1521/freepdb1 tp get a SQLcl session for the Pluggable Database (PDB)
sql system/oracle@localhost:1521/free to get a SQLcl session for the Container Database (CDB)
The HR schema is REST enabled, you can login to SQL Developer Web using: HR/oracle
I have accessed the database and see few of the imported parameters on this new database.
sql system/oracle@localhost:1521/free
[oracle@localhost dbhomeFree]$ sql system/oracle@localhost:1521/free
SQLcl: Release 23.1 Production on Thu Apr 13 19:40:03 2023
Copyright (c) 1982, 2023, Oracle. All rights reserved.
Last Successful login time: Thu Apr 13 2023 19:40:05 +00:00
Connected to:
Oracle Database 23c Free, Release 23.0.0.0.0 - Developer-Release
Version 23.2.0.0.0
SQL> sho pdbs
CON_ID CON_NAME OPEN MODE RESTRICTED
_________ ___________ _____________ _____________
2 PDB$SEED READ ONLY NO
3 FREEPDB1 READ WRITE NO
SQL> select name,open_mode from v$database;
NAME OPEN_MODE
_______ _____________
FREE READ WRITE
SQL> select banner from v$version;
BANNER
___________________________________________________________________
Oracle Database 23c Free, Release 23.0.0.0.0 - Developer-Release
SQL> select * from dba_data_files;
FILE_NAME FILE_ID TABLESPACE_NAME BYTES BLOCKS STATUS RELATIVE_FNO AUTOEXTENSIBLE MAXBYTES MAXBLOCKS INCREMENT_BY USER_BYTES USER_BLOCKS ONLINE_STATUS LOST_WRITE_PROTECT
________________________________________ __________ __________________ _____________ _________ ____________ _______________ _________________ ______________ ____________ _______________ _____________ ______________ ________________ _____________________
/opt/oracle/oradata/FREE/system01.dbf 1 SYSTEM 1216348160 148480 AVAILABLE 1 YES 34359721984 4194302 1280 1215299584 148352 SYSTEM OFF
/opt/oracle/oradata/FREE/sysaux01.dbf 3 SYSAUX 576716800 70400 AVAILABLE 3 YES 34359721984 4194302 1280 575668224 70272 ONLINE OFF
/opt/oracle/oradata/FREE/users01.dbf 7 USERS 5242880 640 AVAILABLE 7 YES 34359721984 4194302 160 4194304 512 ONLINE OFF
/opt/oracle/oradata/FREE/undotbs2.dbf 16 UNDOTBS2 52428800 6400 AVAILABLE 16 YES 34359721984 4194302 6400 51380224 6272 ONLINE OFF
SQL> alter session set container=freepdb1;
Session altered.
SQL> sho pdbs
CON_ID CON_NAME OPEN MODE RESTRICTED
_________ ___________ _____________ _____________
3 FREEPDB1 READ WRITE NO
SQL> exit
Disconnected from Oracle Database 23c Free, Release 23.0.0.0.0 - Developer-Release
Version 23.2.0.0.0
[oracle@localhost dbhomeFree]$ cd $ORACLE_HOME
[oracle@localhost dbhomeFree]$ cd network/admin/
[oracle@localhost admin]$ ls -ltr
total 16
-rw-r--r--. 1 oracle oinstall 1866 May 19 2021 shrept.lst
drwxr-xr-x. 2 oracle oinstall 64 Apr 3 16:43 samples
-rw-r-----. 1 oracle oracle 190 Apr 3 16:43 sqlnet.ora
-rw-r-----. 1 oracle oracle 365 Apr 3 16:43 listener.ora
-rw-r--r--. 1 oracle oracle 584 Apr 3 16:50 tnsnames.ora
[oracle@localhost admin]$ cat listener.ora
# listener.ora Network Configuration File: /opt/oracle/product/23c/dbhomeFree/network/admin/listener.ora
# Generated by Oracle configuration tools.
DEFAULT_SERVICE_LISTENER = FREE
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
)
)
[oracle@localhost admin]$ cat tnsnames.ora
# tnsnames.ora Network Configuration File: /opt/oracle/product/23c/dbhomeFree/network/admin/tnsnames.ora
# Generated by Oracle configuration tools.
FREE =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = FREE)
)
)
LISTENER_FREE =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
FREEPDB1 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = FREEPDB1)
)
)
[oracle@localhost admin]$ ps -ef |grep tns
root 6 2 0 19:32 ? 00:00:00 [netns]
oracle 1853 1 0 19:32 ? 00:00:00 /opt/oracle/product/23c/dbhomeFree/bin/tnslsnr LISTENER -inherit
oracle 5328 3588 0 19:42 pts/0 00:00:00 grep --color=auto tns
[oracle@localhost admin]$ cd ../../dbs/
[oracle@localhost dbs]$ ls -ltr
total 20
-rw-r-----. 1 oracle oinstall 3079 May 14 2015 init.ora
-rw-r-----. 1 oracle oinstall 24 Apr 3 16:44 lkFREE
-rw-r-----. 1 oracle oracle 2048 Apr 3 16:46 orapwFREE
-rw-rw----. 1 oracle oinstall 1544 Apr 13 19:32 hc_FREE.dat
-rw-r-----. 1 oracle oinstall 3584 Apr 13 19:32 spfileFREE.ora
[oracle@localhost dbs]$ cat init.ora
#
# $Header: rdbms/admin/init.ora /main/25 2015/05/14 15:02:30 kasingha Exp $
#
# Copyright (c) 1991, 2015, Oracle and/or its affiliates. All rights reserved.
# NAME
# init.ora
# FUNCTION
# NOTES
# MODIFIED
# kasingha 05/12/15 - 21041456 - fix copyright header
# ysarig 02/01/12 - Renaming flash_recovery_area to
# fast_recovery_area
# ysarig 05/14/09 - Updating compatible to 11.2
# ysarig 08/13/07 - Fixing the sample for 11g
# atsukerm 08/06/98 - fix for 8.1.
# hpiao 06/05/97 - fix for 803
# glavash 05/12/97 - add oracle_trace_enable comment
# hpiao 04/22/97 - remove ifile=, events=, etc.
# alingelb 09/19/94 - remove vms-specific stuff
# dpawson 07/07/93 - add more comments regarded archive start
# maporter 10/29/92 - Add vms_sga_use_gblpagfile=TRUE
# jloaiza 03/07/92 - change ALPHA to BETA
# danderso 02/26/92 - change db_block_cache_protect to _db_block_cache_p
# ghallmar 02/03/92 - db_directory -> db_domain
# maporter 01/12/92 - merge changes from branch 1.8.308.1
# maporter 12/21/91 - bug 76493: Add control_files parameter
# wbridge 12/03/91 - use of %c in archive format is discouraged
# ghallmar 12/02/91 - add global_names=true, db_directory=us.acme.com
# thayes 11/27/91 - Change default for cache_clone
# jloaiza 08/13/91 - merge changes from branch 1.7.100.1
# jloaiza 07/31/91 - add debug stuff
# rlim 04/29/91 - removal of char_is_varchar2
# Bridge 03/12/91 - log_allocation no longer exists
# Wijaya 02/05/91 - remove obsolete parameters
#
##############################################################################
# Example INIT.ORA file
# This file is provided by Oracle Corporation as a starting point for
# customizing the Oracle Database installation for your site.
# NOTE: The values that are used in this file are example values only.
# You may want to adjust those values for your specific requirements.
# You might also consider using the Database Configuration Assistant
# tool (DBCA) to create a server-side initialization parameter file
# and to size your initial set of tablespaces. See the
# Oracle Database 2 Day DBA guide for more information.
###############################################################################
# Change '<ORACLE_BASE>' to point to the oracle base (the one you specify at
# install time)
db_name='ORCL'
memory_target=1G
processes = 150
audit_file_dest='<ORACLE_BASE>/admin/orcl/adump'
audit_trail ='db'
db_block_size=8192
db_domain=''
db_recovery_file_dest='<ORACLE_BASE>/fast_recovery_area'
db_recovery_file_dest_size=2G
diagnostic_dest='<ORACLE_BASE>'
dispatchers='(PROTOCOL=TCP) (SERVICE=ORCLXDB)'
open_cursors=300
remote_login_passwordfile='EXCLUSIVE'
undo_tablespace='UNDOTBS1'
# You may want to ensure that control files are created on separate physical
# devices
control_files = (ora_control1, ora_control2)
compatible ='11.2.0'
[oracle@localhost dbs]$
Thanks,
Srini
No comments:
Post a Comment
No one has ever become poor by giving