Oracle Database Express Edition (XE) 21c on Windows - Installing and Getting Started

Video Statistics and Information

Video
Captions Word Cloud
Reddit Comments
Captions
hi everyone this video will help you install and get started with oracle database express edition 21c on windows to get started we can go to our web browser and type in oracle.com xc to bring up the oracle database express edition web page from there we can click on the download link to go to the download page and then choose to download oracle database express edition for windows once you've downloaded the xz zip file extract it and go into the directory that contains the installation files now before we run setup exe let's talk about some prerequisites that are required before you install you'll need to make sure of a few things first of all temporarily unset any oracle underscore home and tns underscore admin environment variables you'll need to unset these at the system level next you need to make sure that there's no existing xe service on this machine for example from a prior install finally the user must be a direct member of the administrator's group being a member of one group and then that group being a member of the administrators group is not sufficient and if you're logged into windows as a domain user make sure you're on a network that can reach the domain server for example if you usually use a vpn to reach your domain server make sure you have vpn turned on and alternatively you can create a local user and then add that user to the local administrators group then you can log in and install as that local user now let's go back to the directory that contains our xc installation files and run setup exe the installer will launch click the next button accept the license agreement press next make sure that the installation directory is where you want to install and finally enter a single password that will be used for the sys system and pdb admin accounts on the summary screen make sure that everything's okay and then press install the installation should take about 20 or 30 minutes depending on your system configuration the final screen contains connection strings for connecting to the database from the same system when you're done click the finish button to end the installation now we are going to open sql plus and access the database click on the start menu locate the oracle folder and run sql plus to connect enter forward slash as sysdba and then press return note that whoever installed this database will automatically have sysdba privileges and will not have to connect with the password now we'll get a list of the plugable databases in this system by typing select name from v dollar sign pdbs and you can see that xepdb1 is one of our plugable databases then we'll connect to that pluggable database by saying connect sys slash password at host name colon the port number 1521 slash xcpdb1 assistdba now let's create a new user in this plugable database so we'll type create user demo user identified by the password default tablespace users quota unlimited on users and then let's issue some grants so grant create session create table to demo user and finally let's connect to that user so we'll type connect demo user forward slash password at the host name colon the port number 1521 forward slash xcpdb1 and note that you can use this connection string format to connect to non-local databases you would just need to change the host name to the name of the machine where the remote database is located now we'll create a table so we can test this out so create table test table test column number and then we'll insert a row into it so insert into test table values one one one one we'll commit it and now let's try selecting against it select star from test table and you can see we get a result now i'm going to show how to start up and shut down the database using windows services so go to the search bar and type in services and then click on the services app to launch it in the services app scroll down until you see the oracle service xe service and you can right click on it and you'll see a menu there and in the menu you can choose stop to stop the database and similarly you can choose start to start the database and you can control whether or not the database automatically starts when windows starts up by clicking on properties and then in the startup type choosing manual if you don't want the database to start up when windows starts and automatic if you do and one final tip i'd like to share with you that might help you during troubleshooting is you can open up a command prompt and type lsnrctl status listener control status and this command will give you a lot of useful information including the host name the port number that the service is listening on it'll give you some um information about your listener parameter file in your listener log file and it'll show you the status of your various uh services that are are on your machine to make sure that they're working properly and with that i'd like to thank you for watching my video and i sincerely hope it helped you install and get started using oracle database express edition on windows have fun you
Info
Channel: Oracle .NET and Windows
Views: 201,528
Rating: undefined out of 5
Keywords:
Id: DYleroLay5E
Channel Id: undefined
Length: 8min 13sec (493 seconds)
Published: Fri Oct 08 2021
Related Videos
Note
Please note that this website is currently a work in progress! Lots of interesting data and statistics to come.