Install Oracle Database Express Edition (XE) 21c on Windows 10/11 | How to install Oracle 21c

Video Statistics and Information

Video
Captions Word Cloud
Reddit Comments
Captions
hello and welcome Oracle database Express Edition is a free smaller footprint edition of Oracle database it includes all advanced database features like multi-tenant in memory partitioning Advanced analytics Advanced security Etc you can experience the same Oracle database capabilities enjoyed by large Enterprises whether you are a developer a DBA a data scientist an educator or just curious about databases Oracle database Express Edition is the ideal way to get started Oracle database Express Edition supports up to CPUs 2 gigabytes of RAM and 12 gigabytes of database storage on disk if the user data grows beyond this limit then an aura 12592 error will appear if you outgrow Oracle database Express Edition you can easily move to another edition of Oracle database Oracle provides numerous data movement tools to make migrating Oracle database Express Edition easy in this video I will demonstrate how to install and configure Oracle database Express Edition on Microsoft Windows 11. first and foremost pause this tutorial and read a note first at this webpage before installing the software ensure that your computer fulfills the Basic Hardware and software requirements for Oracle database Express Edition installation for Microsoft Windows open a web browser and navigate to The Oracle database XC website now click here to download the Microsoft Windows version of Oracle database XC then choose the location where you want to download the compressed zip file before you start the installation first open the environment variables dialog box by right clicking this PC icon on the desktop and from the menu select properties now click Advanced system settings next click the environment variables button if the Oracle underscore home or TNS underscore admin environment variables have been set then temporarily delete them next see the currently logged in username from the start menu now open the computer Management console click local users and groups double-click users and open the properties dialog box for the currently logged in User make sure this user must be a member of the administrators group on Windows to install Oracle database XE after downloading the file go to the directory that contains the downloaded zip file extract the downloaded zip file to the folder of your choice and click extract the software files are extracted next expand the database setup folder locate setup and double-click it to start the installation click next in the license agreement window select I accept the terms in the license agreement and then click next here either accept the default location or Click Change to select a different installation directory remember do not select a directory that has spaces in its name make sure that the installation directory is where you want to install then click next in this window enter and confirm the single database password to use for the sys system and pdb admin database accounts the same password will be used for these accounts Oracle recommends that the password entered should be at least 12 characters in length contain at least one uppercase character one lowercase character and one digit click next the summary window shows important locations such as Oracle base and Oracle home also database files and log files are stored in these directories finally review the installation settings and if you are satisfied click install ing Oracle database XC doesn't take much time a well-equipped machine with an efficient processor will install Oracle database XC within 5 to 10 minutes on installation complete make a note of the connection strings provided for multi-tenant container database and the plugable database as well as the Enterprise Manager Express URL finally click finish to close the installer now from the start menu open SQL Plus to connect type forward slash as sysdba and press enter this connects you to the root container of the multi-tenant database as database user sys without the password actually when you install Oracle database XC your windows user is automatically added to the or underscore DBA operating system Group which grants you the sysdbe Privileges hence you will not have to connect with the password if you don't have the sysdba administrative privilege or Operating System Authentication you can still connect to the root container as database user says like this forward slash your password at Double forward slashes localhost colon 1521 forward slash XC as sysdba the word localhost in the connect string can be replaced with your PC name or IP address the next type show pdb is to get a list of the pluggable databases in this system let's now connect to this default pluggable database xcpdb1 type connect and press enter key end you can connect to the default pluggable database xcpdb1 as user sys by typing sys forward slash your password then at Double forward slashes localhost colon 1521 forward slash xcpdb 1 as sysdbe note the default Services created by Oracle database Express Edition rxc and xcpdd1 the XC service connects you to the root container of the database and the xcpdb1 service connects you to the default pluggable database xcpdb1 created at the installation time remember connection strings for local connections were provided on the final screen of the installation DNS no listener might occur when The Listener is not running or the listening address supplied in the listener.ora file is invalid to resolve the problem open up a command prompt and type lsnrctl status and hit enter to check the status of the listener the output from the lsnrctl command shows values of a number of important parameters including the host and the port The Listener status output shows that the listener listens on this IP address instead of the hostname let's replace the word localhost with the IP address of this database PC in the connection string next let's add a new test user to the pluggable database foreign necessary privileges to the new user so he can create session and accomplish tasks now let's connect to the test user next copy and paste this code snippet to SQL plus to create a table also insert a sample record into the table finally type the select statement to view the table data all commands from adding a user to viewing table data are executed successfully this shows that our database is working fine Oracle database Express Edition starts up automatically when the system starts we need Oracle to start automatically on servers however on a standalone development system we may prefer to start Oracle only when it is required because Oracle when running takes a considerable amount of system resources you can manually start or stop the database using Windows services let's do this from the start menu open Windows services in the services application window select any service and press the o key to bring up the list of services that starts with the letter O right click the Oracle service XE and from the menu select stop to stop this service also stop the TNS listener service similarly you can right click the service name and select start to start a service you can also control whether or not the database automatically starts when Windows starts up to do so right click DNS listener service and then click the properties now change the startup type from automatic to manual also change the Oracle service XC startup type to manual I hope you enjoyed watching the video goodbye
Info
Channel: The Oracle Professor
Views: 11,274
Rating: undefined out of 5
Keywords:
Id: iv7qlWMsHFc
Channel Id: undefined
Length: 13min 59sec (839 seconds)
Published: Wed Aug 23 2023
Related Videos
Note
Please note that this website is currently a work in progress! Lots of interesting data and statistics to come.