ORACLE-create user

 [oracle@epsdc1 ~]$ sqlplus /nolog

SQL*Plus: Release 11.2.0.1.0 Production on Thu Sep 10 08:54:32 2020

Copyright (c) 1982, 2009, Oracle.  All rights reserved.

SQL> connect /as sysdba;

Connected.

SQL> 

SQL> create user picktolight identified by pick_to_light;

User created.

SQL> grant dba,resource,connect to picktolight;

Grant succeeded.

SQL>

SQL> grant unlimited tablespace to picktolight;

Grant succeeded.

SQL> grant resource to picktolight;

Grant succeeded.

SQL> CREATE TABLESPACE TBPOSDATA DATAFILE '/u01/app/oracle/oradata/POSDATA/tbposdata01.dbf' SIZE 5024M;

Tablespace created.

SQL> exit

[root@epsdc53 ~]# systemctl status firewalld

[root@epsdc53 ~]# service firewalld stop