Tools Installation in alma linux
Laravel xampp install pre requisite
lavavel 5.6(qrius,boneandall) prerequisite:
PHP >= 7.1.3
OpenSSL PHP Extension
PDO PHP Extension
Mbstring PHP Extension
Tokenizer PHP Extension
XML PHP Extension
Ctype PHP Extension
JSON PHP Extension
BCMath PHP Extension
lavavel 7.0(viokart) prerequisite:
PHP >= 7.2.5
BCMath PHP Extension
Ctype PHP Extension
Fileinfo PHP extension
JSON PHP Extension
Mbstring PHP Extension
OpenSSL PHP Extension
PDO PHP Extension
Tokenizer PHP Extension
XML PHP Extension
Grail,Spring Boot,Tomcat install pre requisite
Grails 2.5 prerequisite:
Java Development Kit (JDK) >= 6
Grails 3.X prerequisite:
Java Development Kit (JDK) >= 8
Grails 6.0 prerequisite:
Java Development Kit (JDK) >= 11
tomcat 8 prerequisite:
Java Development Kit (JDK) >= 7
tomcat 9 prerequisite:
Java Development Kit (JDK) >= 8
Spring 2.7 prerequisite:
Java Development Kit (JDK) >= 8 and <= 20
Spring 3.0 prerequisite:
Java Development Kit (JDK) >= 17
Yum command list
- cmd>yum search wget-- yum serch wget
- cmd>yum list wget -- yum show wet file and folder list
- cmd>yum info wget -- yum show info about wget
How to Install phpMyAdmin on AlmaLinux
Before installing PHPMyAdmin, you need to have the following requisite packages installed.
- Apache Web server(Httpd).
- PHP
- Database Server(MySQL or MariaDB)
About Httpd for Fedora/CentOS/Red Hat Enterprise Linux(Server version: Apache/2.4.37 (AlmaLinux) )
- cmd>httpd -v -- to check httpd server(php) install info
- cmd>yum remove httpd
- cmd>yum install mod_ssl
- cmd>yum install -y epel-release
- cmd>yum install httpd
- cmd>service httpd restart or systemctl httpd restart
- cmd>systemctl enable httpd --ok
- cmd>systemctl status httpd -- ok
- cmd>firewall-cmd --permanent --add-service=http
- cmd>firewall-cmd --permanent --add-service=https
- cmd>firewall-cmd --zone=public --permanent --add-port=80/tcp -- ok
- cmd>firewall-cmd --zone=public --permanent --add-port=443/tcp -- ok
- cmd>firewall-cmd --reload or systemctl restart firewalld
- cmd>systemctl restart httpd
- browse http://149.28.62.75 -- server landing page will show
- cmd>cd /var/www/html/ -- server location and html folder is empty
- cmd>cd /etc/httpd --
- cmd>ls -- conf conf.d conf.modules.d
- cmd>cd
- cmd>cd /var/www/html/
- cmd>touch test.php
- <?php echo phpinfo(); ?>
- browse http://149.28.62.**/test.php -- nothing show , need to install php
- cmd>systemctl stop httpd
Install PHP(7.2)
- cmd>yum -y remove php*
- cmd>yum install -y https://rpms.remirepo.net/enterprise/remi-release-8.rpm
- cmd>yum install epel-release
- cmd>yum module enable php:remi-7.4
- cmd>yum install php -y
- cmd>php -v-- php 7.2.24
Install PHP(7.4.33)-- best
- cmd>yum -y remove php* -- to unisntall all php version
- cmd>rpm -Uvh https://dl.fedoraproject.org/pub/epel/epel-release-latest-8.noarch.rpm
- cmd>yum install -y https://rpms.remirepo.net/enterprise/remi-release-8.rpm
- cmd>yum module list php -- show php version list
- cmd>yum module reset php
- cmd>yum module install php:remi-7.4
- cmd>php -v-- php 7.4.33
- cmd>systemctl restart httpd
- browse http://149.28.62.75/test.php -- php install version will show
Install Mysql Server
How to set mysql server password
- cmd>mysql -- enter mysql from root directory
- cmd>mysql -u root -p
- emter passwor if prolem then
- cmd>use mysql;
- cmd>show databases;
- cmd>use mysql;
- cmd>select user,host,plugin from mysql.user;
- cmd>alter user 'root'@'localhost' identified by 'Rowmi******';
- cmd>grant all privileges on *.* to 'root'@'localhost';
- cmd>update user set plugin='mysql_native_password' where User='root';
- cmd>flush privileges;
- cmd>exit;
- cmd>systemctl restart mysqld
- cmd>mysql
- cmd>mysql -u root -p
- cmd>emter passwor(Rowmi******) --ok
- cmd>systemctl restart mysqld
how to reset mysql password
Laravel Project problem: storage access denied
- cmd>useradd -r www-data -- add user
- cmd>id www-data --ok
- cmd>chown -R www-data:www-data /var/www/html/viokart/app
- cmd>find /var/www/html/viokart/app -type d -exec chmod 755 {} \;
- cmd>find /var/www/html/viokart/app -type f -exec chmod 644 {} \;
- cmd>chmod -R 775 /var/www/html/viokart/storage
- cmd>chmod -R 775 /var/www/html/viokart/bootstrap/cache
- cmd>chcon -R -t httpd_sys_rw_content_t /var/www/html/viokart/storage ---- working
- cmd>chmod -R 777 storage
- cmd>or add permission manually on each folder using winscp
Enable htaccess in httpd server
go to /etc/httpd/conf/httpd.conf => using editor change as follows
# Further relax access to the default document root:
<Directory "/var/www/html">
#
# Possible values for the Options directive are "None", "All",
# or any combination of:
# Indexes Includes FollowSymLinks SymLinksifOwnerMatch ExecCGI MultiViews
#
# Note that "MultiViews" must be named *explicitly* --- "Options All"
# doesn't give it to you.
#
# The Options directive is both complicated and important. Please see
# http://httpd.apache.org/docs/2.4/mod/core.html#options
# for more information.
#
Options Indexes FollowSymLinks
#
# AllowOverride controls what directives may be placed in .htaccess files.
# It can be "All", "None", or any combination of the keywords:
# Options FileInfo AuthConfig Limit
#
#AllowOverride None
AllowOverride All
#
# Controls who can get stuff from this server.
#
Require all granted
</Directory>
How to install apache tomcat
- cmd>java -version --- check java version
- cmd>hostnamectl -- pc info
- cmd>hostname -i -- 127.0.0.1
- cmd>yum update
- cmd>yum -y install https://download.oracle.com/java/17/archive/jdk-17.0.8_linux-x64_bin.rpm
- cmd>java -version --- check java version and show latest version
- cmd>alternatives --config java -- to check all install java version
- download from https://archive.apache.org/dist/tomcat/tomcat-9/v9.0.55/bin/apache-tomcat-9.0.55.tar.gz and upload /opt
- cmd>cp /opt/apache-tomcat-9.0.55.tar.gz /usr/local/apache-tomcat-9.0.55.tar.gz
- cmd>cd /usr/local
- cmd>gunzip apache-tomcat-9.0.55.tar.gz
- cmd>tar xf apache-tomcat-9.0.55.tar
- cmd>ls
- cmd>rm -rf apache-tomcat-9.0.55.tar
- cmd>mv apache-tomcat-9.0.55 tomcat9 -- rename dir
- cmd>ls
- cmd>cd -- root directory
- cmd>echo "export CATALINA_HOME="/usr/local/tomcat9"">/root/.bashrc
- cmd>source /root/.bashrc
- cmd>tail -n 1 /root/.bashrc --- will show export CATALINA_HOME=" /usr/local/tomcat9
- cmd>ps aus | grep "apache" | awk '{print $l}' grep -v root | head -n l --- to check user
- cmd>useradd -r tomcat9user
- cmd>id tomcat9user -- find id of user tomcat9user
- --uid=987(tomcat9user) gid=983(tomcat9user) groups=983(tomcat9user)
- cmd>chown -R tomcat9user:tomcat9user /usr/local/tomcat9/
- cmd>ls -l /usr/local/tomcat9/ --- see the file ownership
- cmd>cd /etc/systemd/system
- cmd>touch tomcat9.service
- cmd>cat tomcat9.service -- to show content
- cmd>vim tomcat9.service
- cmd>i
-
[Unit]
Description=Tomcat 9
After=syslog.target network.target
[Service]
Type=forking
User=tomcat9user
Group=tomcat9user
Environment="CATALINA_BASE=/usr/local/tomcat9"
Environment="CATALINA_HOME=/usr/local/tomcat9"
Environment="CATALINA_PID=/usr/local/tomcat9/temp/tomcat.pid"
ExecStart=/usr/local/tomcat9/bin/startup.sh
ExecStop=/usr/local/tomcat9/bin/shutdown.sh
[Install]
WantedBy=multi-user.target
- cmd>esc:wq!
- cmd>enter
- cmd>systemctl daemon-reload
- cmd>systemctl enable tomcat9.service --now
- cmd>cd
- cmd>systemctl status tomcat9.service
- cmd>netstat -tunlp
- cmd>firewall-cmd --zone=public --permanent --add-port=8080/tcp
- cmd>firewall-cmd --reload
- cmd>firewall-cmd --list-ports
- cmd>echo $PATH
- browse : http://ip:8080
- To access Manage app change the following codes on the location :webapps/manager/META-INF/context.xml
-
<!--CookieProcessor className="org.apache.tomcat.util.http.Rfc6265CookieProcessor"
sameSiteCookies="strict" /-->
<Valve className="org.apache.catalina.valves.RemoteAddrValve"
allow=".*" />
instead of
<CookieProcessor className="org.apache.tomcat.util.http.Rfc6265CookieProcessor"
sameSiteCookies="strict" />
<Valve className="org.apache.catalina.valves.RemoteAddrValve"
allow="^.*$" />
- To add permission go to location :tomcat/conf/tomcat-user.xml
-
<user username="admin" password="rowmi2014" roles="manager-gui, manager-script, manager-jmx, manager-status, admin-gui, admin-script"/>
<user username="robot" password="rowmi2014" roles="manager-script"/>
<role rolename="tomcat"/>
<role rolename="role1"/>
<user username="tomcat" password="rowmi2014" roles="tomcat"/>
<user username="both" password="rowmi2014" roles="tomcat,role1"/>
<user username="role1" password="rowmi2014" roles="role1"/>
- cmd>lsof -i -P -n | grep LISTEN -- to check port
- cmd>systemctl daemon-reload
- cmd>systemctl restart tomcat9.service
Oracle 19c install on alma linux pre requisite
Server Display Cards:At least 1024 x 768 display resolution, which Oracle Universal Installer requires.
Minimum RAM:At least 1 GB RAM for Oracle Database installations. 2 GB RAM recommended.
hard disk space:
How to install oracle 19c database on alma linux using rpm ********************************
Step One:
- cmd>vim /etc/hosts -- add the following code
149.28.62.** ukmodak.com ukmodak
- cmd>id oracle -- no oracle user
- cmd>groupadd -g 54321 oinstall
- cmd>groupadd -g 54322 dba
- cmd>groupadd -g 54323 oper
- cmd>useradd -u 54321 -g oinstall -G dba,oper oracle -- create user oracle with group and permission
- cmd>id oracle -- check user id
- cmd>chown -R oracle:oinstall /opt/oracle
- cmd>chmod -R 775 /opt/oracle
- cmd>cat /etc/sysctl.conf
- cmd>ls /etc/security/limits.d -- no file
- download compat-libcap1-1.10-7.el7.x86_64.rpm and upload to /opt
- download compat-libstdc++-33-3.2.3-72.el7.x86_64.rpm and upload to /opt
- download oracle-database-preinstall-19c-1.0-1.el7.x86_64.rpm and upload to /opt
- cmd>cd /opt/ukupload
- cmd>yum -y install compat-libcap1-1.10-7.el7.x86_64.rpm
- cmd>yum -y install compat-libstdc++-33-3.2.3-72.el7.x86_64.rpm
- cmd>yum -y install oracle-database-preinstall-19c-1.0-1.el7.x86_64.rpm
- cmd>yum install -y libnsl
- cmd>yum install -y libnsl.i686
- cmd>yum install -y libnsl2
- cmd>yum install -y libnsl2.i686
- cmd>cat /etc/sysctl.conf
# sysctl settings are defined through files in
# /usr/lib/sysctl.d/, /run/sysctl.d/, and /etc/sysctl.d/.
#
# Vendors settings live in /usr/lib/sysctl.d/.
# To override a whole file, create a new file with the same in
# /etc/sysctl.d/ and put new settings there. To override
# only specific settings, add a file with a lexically later
# name in /etc/sysctl.d/ and put new settings there.
#
# For more information, see sysctl.conf(5) and sysctl.d(5).
# oracle-database-preinstall-19c setting for fs.file-max is 6815744
fs.file-max = 6815744
# oracle-database-preinstall-19c setting for kernel.sem is '250 32000 100 128'
kernel.sem = 250 32000 100 128
# oracle-database-preinstall-19c setting for kernel.shmmni is 4096
kernel.shmmni = 4096
# oracle-database-preinstall-19c setting for kernel.shmall is 1073741824 on x86_64
kernel.shmall = 1073741824
# oracle-database-preinstall-19c setting for kernel.shmmax is 4398046511104 on x86_64
kernel.shmmax = 4398046511104
# oracle-database-preinstall-19c setting for kernel.panic_on_oops is 1 per Orabug 19212317
kernel.panic_on_oops = 1
# oracle-database-preinstall-19c setting for net.core.rmem_default is 262144
net.core.rmem_default = 262144
# oracle-database-preinstall-19c setting for net.core.rmem_max is 4194304
net.core.rmem_max = 4194304
# oracle-database-preinstall-19c setting for net.core.wmem_default is 262144
net.core.wmem_default = 262144
# oracle-database-preinstall-19c setting for net.core.wmem_max is 1048576
net.core.wmem_max = 1048576
# oracle-database-preinstall-19c setting for net.ipv4.conf.all.rp_filter is 2
net.ipv4.conf.all.rp_filter = 2
# oracle-database-preinstall-19c setting for net.ipv4.conf.default.rp_filter is 2
net.ipv4.conf.default.rp_filter = 2
# oracle-database-preinstall-19c setting for fs.aio-max-nr is 1048576
fs.aio-max-nr = 1048576
# oracle-database-preinstall-19c setting for net.ipv4.ip_local_port_range is 9000 65500
net.ipv4.ip_local_port_range = 9000 65500
- cmd>cat /etc/sysctl.conf | grep -v ^#
fs.file-max = 6815744
kernel.sem = 250 32000 100 128
kernel.shmmni = 4096
kernel.shmall = 1073741824
kernel.shmmax = 4398046511104
kernel.panic_on_oops = 1
net.core.rmem_default = 262144
net.core.rmem_max = 4194304
net.core.wmem_default = 262144
net.core.wmem_max = 1048576
net.ipv4.conf.all.rp_filter = 2
net.ipv4.conf.default.rp_filter = 2
fs.aio-max-nr = 1048576
net.ipv4.ip_local_port_range = 9000 65500
- cmd>cat /etc/security/limits.d -- create this directory
- cmd>cd /etc/security/limits.d
- cmd>ls -- find oracle-database-preinstall-19c.conf
- cmd>cat /etc/security/limits.d/oracle-database-preinstall-19c.conf | grep -v ^#
oracle soft nofile 1024
oracle hard nofile 65536
oracle soft nproc 16384
oracle hard nproc 16384
oracle soft stack 10240
oracle hard stack 32768
oracle hard memlock 134217728
oracle soft memlock 134217728
Step Two:
- cmd>ls -lrt *rpm -- search rpm on this directory
- download oracle-database-ee-19c-1.0-1.x86_64.rpm and upload to /opt
- cmd>cd /opt/ukupload
- cmd>yum -y localinstall oracle-database-ee-19c-1.0-1.x86_64.rpm -- if exist then run "yum remove oracle-database-ee-19c-1.0-1.x86_64"
-
Last metadata expiration check: 0:35:29 ago on Mon 18 Sep 2023 11:29:17 AM UTC.
Dependencies resolved.
============================================================================================================================================================
Package Architecture Version Repository Size
============================================================================================================================================================
Installing:
oracle-database-ee-19c x86_64 1.0-1 @commandline 2.5 G
Transaction Summary
============================================================================================================================================================
Install 1 Package
Total size: 2.5 G
Installed size: 6.9 G
Downloading Packages:
Running transaction check
Transaction check succeeded.
Running transaction test
Transaction test succeeded.
Running transaction
Preparing : 1/1
Running scriptlet: oracle-database-ee-19c-1.0-1.x86_64 1/1
Installing : oracle-database-ee-19c-1.0-1.x86_64 1/1
Running scriptlet: oracle-database-ee-19c-1.0-1.x86_64 1/1
[INFO] Executing post installation scripts...
[INFO] Oracle home installed successfully and ready to be configured.
To configure a sample Oracle Database you can execute the following service configuration script as root: /etc/init.d/oracledb_ORCLCDB-19c configure
Verifying : oracle-database-ee-19c-1.0-1.x86_64 1/1
Installed:
oracle-database-ee-19c-1.0-1.x86_64
Complete!
- cmd>ls /opt -- to check where install oracle
- cmd>ls /opt/oracle
- cmd>cat /etc/oraInst.loc
inventory_loc=/opt/oracle/oraInventory
inst_group=oracle
- cmd>cat /etc/oratab
# This file is used by ORACLE utilities. It is created by root.sh
# and updated by either Database Configuration Assistant while creating
# a database or ASM Configuration Assistant while creating ASM instance.
# A colon, ':', is used as the field terminator. A new line terminates
# the entry. Lines beginning with a pound sign, '#', are comments.
#
# Entries are of the form:
# $ORACLE_SID:$ORACLE_HOME::
#
# The first and second fields are the system identifier and home
# directory of the database respectively. The third field indicates
# to the dbstart utility that the database should , "Y", or should not,
# "N", be brought up at system boot time.
#
# Multiple entries with the same $ORACLE_SID are not allowed.
#
#
- cmd>vi /etc/oratab -- as oracle user
ORCLCDB:/opt/oracle/product/19c/dbhome_1:Y
- cmd>vi /etc/sysconfig/ORCLCDB.oracledb --- as root user
# create new : define environment variables
ORACLE_BASE=/opt/oracle/oradata
ORACLE_HOME=/opt/oracle/product/19c/dbhome_1
ORACLE_SID=ORCLCDB
- cmd>vi /usr/lib/systemd/system/ORCLCDB@oracledb.service -- as root user
# this is an example, modify for free
[Unit]
Description=Oracle Database service
After=network.target
[Service]
Type=forking
EnvironmentFile=/etc/sysconfig/ORCLCDB.oracledb
ExecStart=/opt/oracle/product/19c/dbhome_1/bin/dbstart $ORACLE_HOME
ExecStop=/opt/oracle/product/19c/dbhome_1/bin/dbshut $ORACLE_HOME
User=oracle
[Install]
WantedBy=multi-user.target
- cmd>systemctl daemon-reload -- as root
- cmd>systemctl enable ORCLCDB@oracledb -- as root
Step Three:
- cmd>vi /etc/init.d/oracledb_ORCLCDB-19c.conf -- view configuration file
#!/bin/bash
#
# chkconfig: 2345 80 05
# Description: This script is responsible for taking care of configuring the Oracle Database and its associated services.
#
# processname: oracledb_ORCLCDB-19c
# Red Hat or SuSE config: /etc/sysconfig/oracledb_ORCLCDB-19c
#
# Set path if path not set
case $PATH in
"") PATH=/bin:/usr/bin:/sbin:/etc
export PATH ;;
esac
# Check if the root user is running this script
if [ $(id -u) != "0" ]
then
echo "You must be root user to run the configurations script. Login as root user and try again."
exit 1
fi
# Setting the required environment variables
export ORACLE_HOME=/opt/oracle/product/19c/dbhome_1
export ORACLE_VERSION=19c
export ORACLE_SID=ORCLCDB
export TEMPLATE_NAME=General_Purpose.dbc
export CHARSET=AL32UTF8
export PDB_NAME=ORCLPDB1
export LISTENER_NAME=LISTENER
export NUMBER_OF_PDBS=1
export CREATE_AS_CDB=true
# General exports and vars
export PATH=$ORACLE_HOME/bin:$PATH
- cmd>/etc/init.d/oracledb_ORCLCDB-19c configure -- to configure oracle database
- cmd>su - oracle or root user
- cmd>echo $ORACLE_SID
- cmd>pwd -- /opt/ukupload
- cmd>echo $ORACLE_HOME
- cmd>pwd -- /opt/ukupload
- cmd>vi ~/.bash_profile --- write the following code
# add to the end
umask 022
export ORACLE_SID=ORCLCDB
export ORACLE_BASE=/opt/oracle/oradata
export ORACLE_HOME=/opt/oracle/product/19c/dbhome_1
export PATH=$PATH:$ORACLE_HOME/bin
- cmd>source ~/.bash_profile or source ~/.bashrc
- cmd>time /etc/init.d/oracledb_ORCLCDB-19c configure
Session terminated, killing shell... ...killed.
real 0m9.260s
user 0m0.079s
sys 0m0.105s
- cmd>ps -ef | grep ora -- to check oracle connection
- cmd>su - oracle -- will show /opt/oracle path
- cmd>. oraenv -- to set oracle SID
- cmd>ORCLCDB
- cmd>sqlplus /nolog
- cmd>conn sys/sys as sysdba
- cmd>show pdbs
CON_ID CON_NAME OPEN MODE RESTRICTED
---------- ------------------------------ ---------- ----------
2 PDB$SEED READ ONLY NO
3 ORCLPDB1 READ WRITE NO
- cmd>select instance_name, host_name, version, startup_time from v$instance;
INSTANCE_NAME
----------------
HOST_NAME
----------------------------------------------------------------
VERSION STARTUP_T
----------------- ---------
ORCLCDB
ukmodak.com
19.0.0.0.0 19-SEP-23
- cmd>SELECT owner, directory_name, directory_path FROM dba_directories WHERE directory_name='DATA_PUMP_DIR'; -- /opt/oracle/product/19c/dbhome_1/rdbms/log/
- cmd>SELECT * FROM USER_TABLESPACES;
- cmd>quit
- cmd>install database info:
db_name='ORCL'
memory_target=1G
processes = 150
audit_file_dest='<ORACLE_BASE>/admin/orcl/adump'
audit_trail ='db'
db_block_size=8192
db_domain=''
db_recovery_file_dest='<ORACLE_BASE>/fast_recovery_area'
db_recovery_file_dest_size=2G
diagnostic_dest<ORACLE_BASE>'
dispatchers='(PROTOCOL=TCP) (SERVICE=ORCLXDB)'
open_cursors=300
remote_login_passwordfile='EXCLUSIVE'
undo_tablespace='UNDOTBS1'
# You may want to ensure that control files are created on separate physical
# devices
control_files = (ora_control1, ora_control2)
compatible ='11.2.0'
install oracle using rpm tutorial 1
install oracle using rpm tutorial 2
How to oracle service start and stop:
>logisn as sysdba
sql>startup
Now start listener service:
root>lsnrctl start
listener support no service.
Now we are go to check listener status:
root>tnsping ORCLCDB -- where orcl is the SERVICE_NAME name
root>tnsping ORCL -- where orcl is the SERVICE_NAME name
Now we are going to shutdown oracle service. first login as sysdba
>logisn as sysdba
sql>shutdown immediate
How to create pluggable database
su - oracle -- will show /opt/oracle path
. oraenv -- to set oracle SID
ORCLCDB
sqlplus /nolog
conn sys/sys as sysdba
show pdbs
alter session set container=PDB$SEED;
select FILE_NAME from dba_data_files;
alter pluggable database PDB$SEED open force;
select open_mode from v$pdbs where name = 'PDB$SEED';
#re connect again
CREATE PLUGGABLE DATABASE commom_pdb ADMIN USER commomadmin IDENTIFIED BY commomadmin FILE_NAME_CONVERT=('/opt/oracle/oradata/ORCLCDB/pdbseed','/opt/oracle/oradata/ORCLCDB/common_pdb/commonuser'); -- ok
How to create table space dalerp
CREATE TABLESPACE dalerp DATAFILE '/opt/oracle/oradata/ORCLCDB/common_pdb/dalerp_data.DBF' SIZE 2000M;
echo $ORACLE_HOME
echo $ORACLE_SID
echo $TNS_ADMIN
mkdir -p $ORACLE_BASE/network
How to create schema:
alter session set container=COMMOM_PDB;
create user oms_test identified by oms_test
grant all privileges to oms_test;
conn oms_test/oms_test@commom_pdb; -- ok
CREATE DIRECTORY export_impport as '/opt/oracle/admin/ORCLCDB/dpdump/'; -- ok
GRANT EXP_FULL_DATABASE to oms_test; -- ok
GRANT READ,WRITE ON DIRECTORY export_impport TO EXP_FULL_DATABASE; -- okk
How to import oracle database
impdp schema/password@pluggable_container directory=export_impport dumpfile=LGSPWEB_071216.DMP logfile=LGSPWEB_071216.log; -- ok