How do you create a new database in Oracle?

To create a new database in Oracle, you can follow these steps:

1. Open Oracle database management tools such as SQL*Plus or SQL Developer.
2. Log in to the database using sysdba privileges. In SQL*Plus, you can log in using the following command:

sqlplus / as sysdba

1. Create a new database instance. You can use the following command in SQL*Plus:

create database database_name;

database_name refers to the name of the database you wish to create.

1. Configure database parameters. You can use the ALTER SYSTEM statement to configure database parameters, for example:

alter system set parameter_name=parameter_value scope=spfile;

parameter_name is the name of the parameter you want to configure, and parameter_value is the value you want to set for that parameter.

1. Start the database instance. In SQL*Plus, you can initiate it using the following command:

startup;

1. Connect to the newly created database. In SQL*Plus, you can use the following command:

connect sys as sysdba

1. To create users and assign permissions, you can utilize the CREATE USER statement, for example:

create user username identified by password;

Next, use the GRANT statement to assign permissions to users, for example:

grant connect, resource to username;

In this case, username is the desired username you want to create and password is the password for that user.

By following the steps above, you can successfully create a new database in Oracle. Please note, make sure to backup the database before performing any database operations to prevent data loss.