To create a new user account in Oracle, issue the CREATEUSER command. We are going to create a user in Sqlplus command line, and we will use this user in all of our shell scripts.
To create a user, run the following command:
SQL> create user user1 identified by Test123;
You will get the following output:
User created.