Скачать или смотреть Installing and configuring Oracle XE 18c (Express Edition)

Hi, this video is short, and is not intended as a tutorial. I'll share some tips though in the description. This video is only intended to accompany my professional resume. In a follow up video I'll show you how to prepare your new Oracle XE installation for data access from clients like Microsoft Excel (   • ODBC setup for Oracle XEPDB1 database  )

TIPS (this presumes you are working with the Windows version of the Express Edition)

Important Note: Once XE is fully installed, you shouldn't ever have to tweak any of your ORA files by hand.

Starting with SQLPlus (Command Line Interface)
---------------------
If you experience a failed login, the accompanying ORA-????? error message may have you scurrying off on the web to understand what happened and it might falsely lead you into thinking you need to tweak your ORA files. Don't. If you're going to read anything, start with an understanding of Oracle's multitenant database container concept. Your first login will be system and password given at installation time. Once in, you're in the outer layer inside of the multi tenant database. XE comes default with an already built database referred to as a PDB. It's name is XEPDB1, and you will need to connect (login) to it. Initially, also as system.

SQL Developer (DBA tool)
-------------------------
If logging into SQLPlus was a hurdle, you may have a repeat in this tool as well. An indication that your ORA files are preconfigured and functioning, there is a tab that shows what databases SQLDev found. Which is, XE (the outer ring layer of the multi tenant database). (You can ignore the XE Listener) Also logon as system and installation password.

I'll skip going into the SQL Modeler tool because at this point. If you logged in successfully, the XE database will be listed in the explorer on the left hand side of the user interface. You can expand it to reveal the built-in views, etc. But, what you really want in the explorer is the database inside of the main container. It is the actual user consumable database is, and it's name is XEPDB1. Dot Net folks should mind-map the XE (outer ring) database as SQL Server's Master database. You don't do any kind of creation in the Master DB.

That said, if you're following along with the How To for Oracle XE, you'll need to go back to SQLPlus, logon as system, and once logged on, connect to the XEPDB1 database also using the system credentials, create your first user, grant it privileges according to the How-To, and make sure it is not "locked". If you're not familiar with the SQLPlus commands, they are available in the Oracle website.

Then, go back to SQL Developer, create a new connection for the XEPDB1 database through its service connection, not the default method. An easily missed checkbox in the connection dialog box where once it's checked, you can then specify XEPDB1. The login credential you use here is the new user you created and granted privileges.

Once you get all this right, the How-To at Oracle's website for using the SQL Modeler tool to connect to the XEPDB1 database should be a cakewalk.

Look here - http://www.dba-oracle.com/t_connect_s...

Last but not least, the web based Dashboard. the Express edition setup fails to create an icon for it. You will not find it in the Windows Start Menu. Also, when the XE setup completed, it should given you a complete message containing the three URLs it also created. If you didn't take note of it at the time, don't worry, I'll list them verbatim here:

localhost:1521
localhost:1521/XEPDB1
https://localhost:1521/em

What you might discover is, you can only get to the EM website. In fact, it's the only website that the setup dialog indicated using HTTPS. This is the part where Oracle's How To Setup, fails to cover in detail and you will have to dig around to find all the answers you need.

Two things of note.
1) The permissions you granted to your first user will need an additional permission.
2) The three URLs provided for the different dashboards presumes much and therefore, you will need to find the commands to use in SQLPlus that implements a global setting for all three URLs to work with SSL. This means you will also have to change the default port from 1521 to something else. Look here - http://homme.io/44493

:: BACKGROUND MUSIC::
Yung Kartz at Free Music Archive
https://freemusicarchive.org/music/Yu...