Oracle 19c создание базы
Are you planning to install Oracle 19c on Windows Server or Windows 10? Then this step by step guide is for you.
The installation of Oracle Software is not always an obvious operation, as it is the case for many DBMS (SQL Server, MySQL, etc.). The steps are however simple, but If you read Oracle documentation, more than 190 pages, you can get lost pretty quickly. There is a lot of information.
In this guide, I’ll simplify theses processes for you. I’ll show you the key steps to successfully install Oracle 19c on Windows, from the first attempt. Upon completion of this installation, all of the components required to create and administer a database in Oracle Database 19c will be available.
So I assume that you already have your Windows server set up and running. To avoid issues during the installation process, make sure your environment meets Oracle 19c installation requirements.
Related Articles
6,868 Total Views, 12 Views Today
How useful was this post?
Click on a star to rate it!
Average rating 5 / 5. Vote count: 5
No votes so far! Be the first to rate this post.
As you found this post useful.
Follow us on social media!
We are sorry that this post was not useful for you!
Let us improve this post!
Tell us how we can improve this post?
Hello and welcome to DBsGuru,
DBsGuru is a group of experienced DBA professionals and serves databases and their related community by providing technical blogs, projects, training.
Technical blogs are the source of vast information not about databases but its related product like middleware, PL/SQL, replication methodology, and so on.
Thanks for the visits!
Share Learn Grow!
2. Pfile(init.ora) file
Whenever we start the instance, It will read the pfile(init.ora)/spfile and set the parameter value which is mentioned in the file, and then mount the instance accordingly.
Below are the example of pfile(init.ora) and the same has been created in default location $ORACLE_HOME/dbs
Note: You can modify/add parameters according to your requirements along with required directories.
Oracle Database 19c installation requirements on Windows
Recent Comments
9 thoughts on “Create a Database in Oracle 19c on Windows”
How can I unlock the HR scheme?
with “ALTER USER HR IDENTIFIED BY password ACCOUNT UNLOCK;”
tells me that the account does not exist.
I need to connect to HR, help please
You have to enable Sample Schemas in Step 9 in order to use sample schemas like HR.
I followed the installation steps appropriately, I enabled the example scheme, but when I wanted to unlock the user, “user HR does not exist” appears.
Hi Admin,
I have follow all step above, but cant access to the url, with below error, any advie?
Can’t connect securely to this page
This might be because the site uses outdated or unsafe TLS security settings. If this keeps happening, try contacting the website’s owner.
The TLS certificate used by the server is auto-signed. That’s why you’re getting this message. Try with another web browser and add an exception. That should be fine.
cant connect to DB from Oracle SQL developer
LSNRCTL for 64-bit Windows: Version 19.0.0.0.0 – Production on 10-MAY-2021 17:57:04
Copyright (c) 1991, 2019, Oracle. All rights reserved.
Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
TNS-12541: TNS:no listener
TNS-12560: TNS:protocol adapter error
TNS-00511: No listener
64-bit Windows Error: 61: Unknown error
”
listener.ora and tnsnames.ora these files are empty after installation.
Kindly help resolve.
Hi Anish, it seems there no listener configured for your database instance. Please, follow this guide to configure one and attach it to the database.
Getting an error : ” [DBT-50000] Unable to check for available memory.” in Step 9 – Memory Allocation. Can you guide me what can be the issue?
As indicated, DBCA couldn’t check the amount of RAM available. Try to run it as Administrator and consider using advanced mode to create the database.
After installing Oracle 19c home, now we are going to create to database on-premise. Run the DBCA after setting the Oracle Home.
Select Database type as Oracle Single Instance database.
Provide the database name as SID.
Use the default template.
Check the enable archiving if you want enable archive log mode.
Create a new listener in GUI mode
Check OLS and DB vault if needed.
Setting the memory components.
Check EM cloud if needed.
Provide the password for SYS user.
Setting initialization parameter and storage location if needed.
Check summary page and click on Finish.
Check the progress and review the log if any error occurred.
Finally, Click on close to complete the setup.
Connect with database and check the open mode.
Stay tuned for more articles on Oracle 19c
Thank you for giving your valuable time to read the above information.
If you want to be updated with all our articles send us the Invitation or Follow us:
Anuradha’s LinkedIn: Anuradha’s Profile
[oracle@rac1 grid]$ asmcmd
ASMCMD> lsdg
State Type Rebal Sector Logical_Sector Block AU Total_MB Free_MB Req_mir_free_MB Usable_file_MB Offline_disks Voting_files Name
MOUNTED EXTERN N 512 512 4096 4194304 40956 40824 0 40824 0 N DATA/
MOUNTED EXTERN N 512 512 4096 4194304 12284 11948 0 11948 0 Y OCR_VOTING/
Step:-2 Check Asm diskgroup created and sufficient space Through ASMCA Tool
Step:-3 Select Create database
Step:- 4 Click Advanced configuration
Step:-5 Check Database type and General purpose
Step:-6 Check both nodes are selected
Step:-7 Enter database name
Step:-8 Check database file location
Step:-9 Deselect FRA and archivelog
Step:-10 Leave as it is
Step:- 11 Select ASMM
Step:- 12 Enter Password
Step:-13 select create database
Step:-14 Double check and click finish
Step:-15 Oracle 19c rac database creation is completed
Step:-16 Check database status
[oracle@rac1 ~]$ . .db.env
[oracle@rac1 ~]$ sqlplus / as sysdba
SQL*Plus: Release 19.0.0.0.0 – Production on Wed Dec 25 16:15:18 2019
Version 19.3.0.0.0
Copyright (c) 1982, 2019, Oracle. All rights reserved.
Connected to:
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 – Production
Version 19.3.0.0.0
4. Select database deployment type
This step enables you to select the type of database and template to use to create the database. You can select:
- Oracle Single Instance Database
- RAC database
- RAC node database
for the database type and
for the database template. In this guide, I use “Oracle Single Instance Database” and “General Purpose or Transaction Processing” as a template. However, you can select the type and template suited to the type of workload your database will support. For more information on templates, click on “View details” next to each template.
1. Create require directories
Here we are creating require directories that are required to match exactly as pfile and database creation command.
Step4:- Verify.
After completion of the database creation script in step3, Now we have to verify the database is ready for use.
10. Specify management options
Enterprise Manager provides Web-based management tools for Oracle databases. You can select Configure Enterprise Manager (EM) express and click “Next”.
If Enterprise Manager cloud control is installed on your host computer, then you can choose Register with Enterprise Manager (EM) cloud control and provide the necessary connection details (host, port number, username and password).
4 thoughts on “Step by Step manually creation of an Oracle 19c Database”
Very nice and very easy to understand
Thanks Rajesh!
Great to hear your feedback. Do keep following us for many more articles !
Regards,
Team DBsGuru.
Nice article… Looks like the PDB datafiles are missing
Much thanks Johan and appreciate your valuable time and feedback! This article is for manual standalone DB creation (non-container) so didn’t cover PDB. However, we accept it as a suggestion, and definitely, we will publish a separate article on it which will cover manual DB creation (CDB and PDB).
11. Specify database user credentials
Provide passwords for the administrative accounts SYS and SYSTEM and the Oracle home user account. You can specify a password for each administrative account or use the same password for all accounts. For security reasons, I recommend to set different password for each administrative account.
6. Select database storage option
You can customize the database storage options in different ways. Make sure your select “Use template file for database storage attributes” and click “Next”.
If you want to specify your own location to store database files select “Use following for the database storage attributes” option. With this option, you need to choose how the database files will be managed:
- File System option: your operating system will manage your database files.
- Automatic Storage Management (ASM) option: you place your data files in Oracle Automatic Storage Management (Oracle ASM) disk groups.
- Oracle-Managed Files (OMF) option: Oracle Database will directly manage operating system files comprising an Oracle database.
Step3:- create spfile.
Currently, the database is running from a pfile, Now we are creating spfile from pfile and start a database with spfile.
Now starting database from spfile.
So finally congratulation, 19c database to ready to rock.
This document is only for learning purposes and always validate in the LAB environment first before applying in the LIVE environment.
Hope so you like this article!
Please share your valuable feedback/comments/subscribe and follow us below and don’t forget to click on the bell icon to get the most recent update. Click here to know more about our pursuit.
12. Select database creation option
In this step, you can select any of the following options for creating the database:
- “Create database” to create your database now;
- “Save as a database template” to save the database definition as a template to use at a later time;
- “Generate database creation scripts” to generate a SQL database creation script that you can run at a later time.
Moreover, you can adjust the server initialization parameters, relocate or replicate your database files (control files, redo logs, etc.).
You might also like
Step1:- Post Scripts.
Below post scripts create database data dictionary views which is require 100% database functional.
catalog.sql
catproc.sql
pupbld.sql
13. Oracle database creation summary
This step enables you to review the summary information. To change any of these options, click “Back” and return to the window where you can modify the option.
Click “Finish” to start the creation of the database.
Voilà! You have successfully created your Oracle 19c database with DBCA.
Before closing the window, make sure you copy the “Enterprise Manager Database Express URL”.
Subscribe Our Newsletter
3. Select database configuration mode
DBCA enables you to create a database with typical configuration or with advanced configuration:
- in “Typical configuration” mode, you can set up your database quickly using Oracle prebuilt templates.
- in “Advanced configuration” mode, you can customize storage locations, management options, database options, configuration option, user credentials, etc. It allows you to have full control of your database configuration.
In the following, we use the Advanced configuration mode.
Latest Ratings on Post
Step3:- Create database
After starting the database in nomount mode, Now we run dbcreate.sql to create the database.
14. Test the database
To check if your database is running properly, you can:
start a new SQLPlus session with an administrative account.
or connect to EM Express with SYS administrative account.
You should see the following screen if everything is okay.
That’s it. Still having issues creating a database in Oracle 19c? Let me do it for you.
Step by Step manually creation of an Oracle 19c Database on Linux 7
19c Database creation by DBsGuru
In the previous article, we have demonstrated Step by step silent installation of oracle 19c on Linux 7 , now here we are going to create Oracle 19c standalone database. We can create an Oracle database by using the below methods.
1. DBCA(GUI)
2. Manually
Basically, some organizations, recommend using a manual method for creating a database, or due to less budget or not having GUI option available, we have to perform manual creation.
Here we are going to illustrate, how to create a database manually in oracle 19c on a Linux server.
Below are the pre-requisite to creating a database:
Achievements
Archives
9. Specify configuration options
Memory allocation: The Memory tab enables you to control how the database manages its memory. You can either use:
- Automatic Shared Memory Management if you want to allocate specific amounts of memory to the SGA and aggregate PGA to your database instance;
- Manual Shared Memory Management if you want to allocate specific memory amount for each SGA component and the aggregate PGA;
- Automatic Memory Management if you want Oracle to automatically tune the memory components of the SGA, and allocates memory to individual PGAs as needed.
Block size and processes: this tab allows you to set the database data block size and the maximum number of user processes that can simultaneously connect to the database.
The maximum number of processes depend on many parameters. The value you select should allow for all background processes, user processes, and parallel execution processes. A small value for the maximum number of processes may result to the database not running.
Character sets: Use this tab to to determine how character data is stored in the database. Select Unicode (AL32UTF8) as the database character set.
Connection mode: this tab enables you to select the database connection mode.
In Dedicated server mode, each user process is associated with a dedicated server process. This option is suitable when the number of clients is small.
In Shared serve mode, several client connections share a database-allocated pool of resources. This mode is the best option when client load is expected to cause a strain on memory and other system resources. If you select this mode, then make sure you provide the number of Shared servers.
Sample schemas: this tab allows you to include the sample schemas like HR and OE in your database. Select “Add sample schemas to the database” if you want to use them later.
Follow Us
Recent Posts
5. Specify database identification details
In this step, provide the global database name, something like “database.domaine_name”. You don’t need to fill the SID. It is created automatically from the global database name.
If you want to create a multitenant container database (CDB), then check Create as Container Database and specify the number of pluggable databases the CDB can support. You can also create an empty CDB.
1. Launch DBCA
The Oracle DBCA tool is available after installing the Oracle 19c software. To launch it, you must log into Windows as an administrator and use one of the methods below:
- open it from the Windows Start menu;
- run the dbca command from the Windows command prompt;
- execute the following combination: “Windows + R”, then type dbca.
Create a database in Oracle 19c on Windows step by step
Post Steps
Hits by Community
Categories
Leave a Reply Cancel reply
7. Select Fast recovery option
The fast recovery is an essential component of your database. In fact, it allows you to recover your data if a system failure occurs. It is a location in which Oracle Database can store and manage files related to backup and recovery.
Check “Specify Fast Recovery Area” to specify a backup and recovery area and its directory location, file storage type and size.
You can also to enable the archiving of database online redo log files, which Oracle uses to recover a database with the “Enable archiving” option.
Step2:- Password file (orapwd)
Create a password file under ($ORACLE_HOME/dbs)
8. Specify network configuration details
Configuring a listener is mandatory if you want to access your database remotely. A listener receives incoming client connection requests and manages the traffic of these requests to the database server.
In this step, you can select among the listeners in the current Oracle home or create a new one by providing the listener name and a port number. Then click “Next” to continue.
You can configure Oracle Database Vault and Oracle Label Security in the next window, or you can click Next to continue through DBCA without configuring Oracle Database Vault and Oracle Label Security. I’ll skip this in this guide.
2. Select “Create a database” and click “Next”
Install Oracle Database 19c on Windows step by step
1. Download Oracle Database 19c software for Windows
Our first step is to get the Oracle 19c software for Windows from the official Oracle download page. On this page you will find many packages. In this guide, we will focus on the Oracle Database 19c (19.3) for Microsoft Windows x64 (64-bit) package. If you want to access your future Oracle database remotely, you can also download the Oracle Database 19c Client (19.3) for Microsoft Windows x64 (64-bit) or Oracle Database 19c Client (19.3) for Microsoft Windows (32- bit) according to the architecture of the client computer.
Downloading Oracle 19c software is free, however to use it in the production environment requires a license. Note also that downloading requires an Oracle account.
2. Launch the setup wizard
Once the download is complete
- unzip the package then copy it to the root of your disk;
- rename the folder, choose a shorter name (eg. db_home);
- then launch the setup.
Note: the installation wizard may take several minutes to open. So be patient.
3. Choose database installation options
This step is very important. It allows you to choose the database installation options. You can install Oracle software and create a database at the same time (Create and configure a single instance database).Since we only want to install the Oracle 19c software and its components, we will opt for “Set up Software Only”. This option installs the essential components for creating and administering a database. You can also use it to upgrade an older version of Oracle (example: 12c or 18c) or install RAC.
4. Select database installation type
The first option allows you to install a single instance database on your server. Oracle Database with the Oracle Real Application Clusters (RAC) option allows multiple instances running on different servers to access the same physical database stored on shared storage.As we want to install Oracle 19c on a single server, we select option 1.
You can create a database after installation by using Oracle Database Configuration Assistant (Oracle DBCA).
5. Choose database edition
The version of the database to install depends on your needs. For an application developer or and medium-size companies, the standard version covers practically all needs.To take full advantage of Oracle 19c, you can install the Enterprise version. Obviously, the Enterprise version requires more resources (storage, RAM, CPU).
6. Specify Oracle home user
During Oracle Database installation, you can specify an optional Oracle home user associated with the Oracle home. Oracle home user can be a Windows built-in account (LocalSystem for Server and LocalService for Client), virtual account, or a regular (not an administrator) Windows account. If you specify an existing user as the Oracle home user, then the Windows user account you specify can either be a Windows domain user or a Windows local user.
A Windows user account need not be created by the administrator if a virtual account or a Windows built-in account is used during installation. If you specify a non-existing user as the Oracle home user, then the Windows user account you specify must be a Windows local user. The installer creates this account automatically to run the Windows services for the Oracle home. Do not log in using this account to perform administrative tasks.
7. Specify the location of Oracle software
In a default Windows installation, the Oracle base directory appears as follows: DRIVE_LETTER:\app\username where username is the Oracle installation user if you choose Windows built-in a ccount, else it is the Oracle Home user (standard Windows user account). You can change this directory at your convenience or leave it as default.
8. Minimum requirements checks, summary and end of the installation
After these initial phases of configuration, let’s check the installation prerequisites. If, however, there are errors, try to readjust the minimum installation requirements and start again.
Click install if no error occurs.
That’s it. You can close the installation wizard now.
You can take a look at the different components of your installation from the Windows start menu.
Step by Step manually creation of an Oracle 19c DatabaseCreate a Listener in Oracle Database 19c
Step2:- Start database.
Here we are starting the database in the nomount stage from pfile that we created in pre-requisite above in step2.
3. Create a database creation script.
In the database create a script, we are going to specify the datafile ,redo log files, temp files, and undo tablespace.
Below is the database creation script and made one SQL file dbcreate.sql .
Now, we moving ahead to create a database. Below the steps that we followed to create a manual database in oracle 19c
Configuring a Listener in Oracle Database (12c, 18c and 19c editions)
Contact Us
Copyright © 2020-2022 DBsGuru. All rights reserved.
Privacy Overview
Do you want to create a Database in Oracle 19c on Windows Server or Windows 10 step by step? Then this complete guide is for you.
You can create an Oracle 19c database during the installation of Oracle software or after installation with the Oracle Database Configuration Assistant (DBCA) tool. This guide describes the simple steps to create a database in Oracle 19c with DBCA.
Before you begin, ensure that the minimum requirements are met. If you have not yet installed the Oracle software, I recommend you follow this tutorial on installing Oracle 19c on Windows.
Step1:-specify oracle environment
In this step, we specify ORACLE_SID and ORACLE_HOME
Читайте также: