Linux Basic Command for every Day use

#Change Date 

 timedatectl set-time [RRRR-MM-DD]

 timedatectl set-time 2020-11-01

#Change Time

timedatectl set-time [HH:MI:SS]

timedatectl set-time 01:10:10

#Display Time Format like AM/PM

date +%c 

#Change Linux user password (Same)

passwd 

#Linux change password for other user account

passwd oracle

Send Email through Oracle Apex 20.2

CONN HR/HR@LIVE

BEGIN
  DBMS_NETWORK_ACL_ADMIN.drop_acl ( 
    acl         => 'power_users_apex.xml');
COMMIT;
END;
/

begin
DBMS_NETWORK_ACL_ADMIN.create_acl(
  acl => 'power_users_apex.xml',
  description  =>  'Access to Apex Email',
  principal=>'APEX_200200',
  IS_GRANT=>TRUE,
  PRIVILEGE=>'connect',
  START_DATE=>SYSTIMESTAMP,
  END_DATE=>NULL);
  COMMIT;
end;
/

begin
DBMS_NETWORK_ACL_ADMIN.ADD_PRIVILEGE(
  acl => 'power_users_apex.xml',
  principal=>'APEX_200200',
  IS_GRANT=>TRUE,
  PRIVILEGE=>'resolve');
  COMMIT;
end;
/

begin
DBMS_NETWORK_ACL_ADMIN.assign_acl(
  acl => 'power_users_apex.xml',
  host=>'mail.ubs-bd.com',
  lower_port=>26,
  upper_port=>null);
  COMMIT;
end;
/


Now Go to Internal Workspace >>Instance Settings>>Email Tab>>

SMTP Host Address 			: 	mail.ubs-bd.com
SMTP Host Port				:	26
SMTP Authentication Username		:	prince@ubs-bd.com
SMTP Authentication Password		:	xxxyyyxxxxxxx
Default Email From Address		:	prince@ubs-bd.com

https://www.youtube.com/watch?v=Fks0nJJ2Oto

How to Install Oracle Apex 20.2 Old

 ------------Apex 20.2 Installation Guide line----------

Create Tablespace apex
logging
datafile 'D:\Oracle\oradata\LIVE\APEX.DBF' size 1024m
autoextend on
next 64m maxsize 5G
extent management local;

@apexins apex apex temp /i/

@apxchpwd.sql


@apex_rest_config.sql >>all Passworda are >>admin_123

--select username,account_status  from dba_users where username like 'APEX%'

ALTER USER APEX_LISTENER  ACCOUNT UNLOCK identified by admin_123;

ALTER USER APEX_PUBLIC_USER ACCOUNT UNLOCK identified by admin_123;

ALTER USER APEX_REST_PUBLIC_USER ACCOUNT UNLOCK identified by admin_123;

ALTER USER APEX_INSTANCE_ADMIN_USER ACCOUNT UNLOCK identified by admin_123;

ALTER USER APEX_200200 ACCOUNT UNLOCK identified by admin_123;


--select username,account_status  from dba_users where username like 'ORDS%'

ALTER USER ORDS_METADATA ACCOUNT UNLOCK identified by admin_123;

ALTER USER ORDS_PUBLIC_USER ACCOUNT UNLOCK identified by admin_123;

ALTER USER ORDSYS ACCOUNT UNLOCK identified by admin_123;

------------------------------------------------------------------
For Oracle Database version 12c or later run the below script:


BEGIN
DBMS_NETWORK_ACL_ADMIN.APPEND_HOST_ACE(
host => '*',
ace => xs$ace_type(privilege_list => xs$name_list('connect'),
principal_name => 'APEX_200200',
principal_type => xs_acl.ptype_db));
END;
/

BEGIN
DBMS_NETWORK_ACL_ADMIN.APPEND_HOST_ACE(
host => 'localhost',
ace => xs$ace_type(privilege_list => xs$name_list('connect'),
principal_name => 'APEX_200200',
principal_type => xs_acl.ptype_db));
END;
/


EXEC DBMS_XDB.sethttpport(0);

--download jdk
https://www.oracle.com/java/technologies/javase-downloads.html

--Download Ords file as you required or support your apex versions....

https://www.oracle.com/database/technologies/appdev/rest-data-services-v192-downloads.html

#unzip ords file

copy images folder from apex directory and past to ords folder.


go to cmd

and enter ords directory

example

CD D:\Oracle\ords

java -jar ords.war

https://youtu.be/P77Yt8GvLi4

ABRT has detected 1 problem(s). For more info run: abrt-cli list --since 1604139354

 abrt-cli list --since 1429869331

HOW to Install Oracle Database 19c, Weblogic 12c, Oracle Apex 20.1, ORDS in CentOS Linux

Oracle Database 19c

1.     Oracle Database Download (Linux x86-64 ZIP(2.8 GB) )

https://www.oracle.com/database/technologies/oracle-database-software-downloads.html

(https://oracle-base.com/articles/19c/oracle-db-19c-installation-on-oracle-linux-7)

2.     The following packages are listed as required. Many of the packages should be installed already.

Oracle Installation Prerequisites

root@quiumpc

yum install -y bc   

yum install -y binutils

yum install -y compat-libcap1

yum install -y compat-libstdc++-33

#yum install -y dtrace-modules

#yum install -y dtrace-modules-headers

#yum install -y dtrace-modules-provider-headers

yum install -y dtrace-utils

yum install -y elfutils-libelf

yum install -y elfutils-libelf-devel

yum install -y fontconfig-devel

yum install -y glibc

yum install -y glibc-devel

yum install -y ksh

yum install -y libaio

yum install -y libaio-devel

yum install -y libdtrace-ctf-devel

yum install -y libXrender

yum install -y libXrender-devel

yum install -y libX11

yum install -y libXau

yum install -y libXi

yum install -y libXtst

yum install -y libgcc

yum install -y librdmacm-devel

yum install -y libstdc++

yum install -y libstdc++-devel

yum install -y libxcb

yum install -y make

yum install -y net-tools # Clusterware

yum install -y nfs-utils # ACFS

yum install -y python # ACFS

yum install -y python-configshell # ACFS

yum install -y python-rtslib # ACFS

yum install -y python-six # ACFS

yum install -y targetcli # ACFS

yum install -y smartmontools

yum install -y sysstat

 

# Added by me.

yum install -y unixODBC

 

3.    Create the new groups and users.

 

root@quiumpc

 

groupadd -g 54321 oinstall

groupadd -g 54322 dba

groupadd -g 54323 oper

useradd -u 54321 -g oinstall -G dba,oper oracle

 

passwd oracle

 

4.     Manual Setup

If you have not used the "oracle-database-preinstall-19c" package to perform all prerequisites, you will need to manually perform the following setup tasks.

Add the following lines to the "/etc/sysctl.conf" file, or in a file called "/etc/sysctl.d/98-oracle.conf".

-----Go to Computer etc folder

/etc/sysctl.conf

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

 

Run one of the following commands to change the current kernel parameters, depending on which file you edited.

---check sysctl file

 

/sbin/sysctl -p

 

# Or

/sbin/sysctl -p /etc/sysctl.d/98-oracle.conf

 

5.       Add the following lines to a file called "/etc/security/limits.d/oracle-database-preinstall-19c.conf" file.

 

-----Go to Computer etc folder

/etc/security/limits.d/20-nproc.conf

 

# *          soft    nproc     unlimited

root       soft    nproc     unlimited

 

#oracle   soft   nofile    16384

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

 

6.       Set secure Linux to permissive by editing the "/etc/selinux/config" file, making sure the SELINUX flag is set as follows.

 

SELINUX=disabled

setenforce disabled

 

7.       If you have the Linux firewall enabled, you will need to disable or configure it, as shown here. To disable it, do the following.

 

systemctl stop firewalld

systemctl disable firewalld

 

8.       If you are not using Oracle Linux and UEK, you will need to manually disable transparent huge pages.

Create the directories in which the Oracle software will be installed.

 

mkdir -p /u01/app/oracle/product/19.0.0/dbhome_1

chown -R oracle:oinstall /u01

chmod -R 775 /u01

 

9.     Copy and paste to dbhome_1 drive oracle Linux software

cd /u01/app/oracle/product/19.0.0/dbhome_1

 

ls

 

unzip LINUX.X64_193000_db_home.zip

 

chown -R oracle:oinstall /u01

chmod -R 775 /u01

 

cd /u01/app/oracle/product/19.0.0/dbhome_1

 

xhost +

cd /bin

ls

 

-----root

 

chown -R oracle:oinstall /u01

chown -R oracle:oinstall /u01/app/oracle/product/19.0.0/dbhome_1

cd /u01/app/oracle/product/19.0.0/dbhome_1

su oracle

./runInstaller

 

10. Go to Computer->Home-> Oracle ->Show hidden Files for Sqlplus

bash_profiles

 

# Oracle Settings

export TMP=/tmp

export TMPDIR=$TMP

 

export ORACLE_HOSTNAME=localhost.localdomain

export ORACLE_UNQNAME=orcl

export ORACLE_BASE=/u01/app/oracle

export ORACLE_HOME=$ORACLE_BASE/product/19.0.0/dbhome_1

export ORA_INVENTORY=/u01/app/oraInventory

export ORACLE_SID=orcl

 

export PATH=/usr/sbin:/usr/local/bin:\$PATH

export PATH=$ORACLE_HOME/bin:$PATH

 

export LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib

export CLASSPATH=$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib

 

Partition u01 in CentOS Linux

 HDD partition on centos

=========================

# lsblk

# fdisk /dev/vdb

partprobe /dev/sdb

# mkfs.ext4 /dev/vdb1

# mount /dev/vdb1 /u01

# vim /etc/fstab

/dev/vdb1 /u01 ext4 defaults 0 0

# mount -a

sac -vdb

Linux Essentials Training - CSL

Day 00 -First Introduction
Topic
Linux Essentials
Description
REDHAT + UBUNTU + KALI

01. How Operating Systems Works
02. The Linux Operating System
03. Virtual Machine Concepts
04. Download and Install and Create Oracle VM
05. Download RedHat, Ubunutu, CentOS, Kali OS
06. Install Redhat/CentOS OS
07. Install Ubuntu OS
08. Install Kali OS
09. Linux Desktop Environment
10. Linux Command Line Interface 1
11. Linux Command Line Interface 2
12. Linux Text Processing Tools
13. Linux Text Editors
14. Linux User and Group Administration
15. Linux File Permission
16. Password reset Ubuntu & RedHat
17. Linux Networking Redhat/CentOS
18. Linux Networking Kali/Ubuntu
19. Software Install on RedHat/CentOS
20. Software Install on Kali/Ubuntu
21. Working with Linux SSH Service

https://www.facebook.com/notes/linux-essentials-01/le-1-all-lecture-materials-recorded-video-archive-link/2719284008286635

Day 01 Introduction to Linux Operating System

Day 02

Day 03


FU512-2DG1H-M85QZ-U7Z5T-PY8ZD
VMware 15.5

Oracle APEX 20.2 New Features

New Features


Features



Cards Region


The new Cards Region is a lightweight report region, declaratively supporting customizations of layout, appearance, icon, badge, media and actions. Use cards to embed and share media sourced from BLOB column, URL or video in iFrame. Cards are useful for presenting a variety of information in small blocks. As Cards usually provide entry to more detailed information, you can include a number of actions as button or links declaratively.


Automations


Automations are a sequential set of PL/SQL actions, triggered by query results. They are used to monitor data and then perform the appropriate action (examples are auto-approving specific requests and sending email alerts). An automation can be triggered on Schedule or on Demand, by invoking the APEX_AUTOMATION package. Query results can be derived from:
Table or View, SQL Query or a PL/SQL function returning a SQL Query.
Local Database or REST Enabled SQL
REST Data Source (aka Web Source Modules)


Faceted Search Enhancements

Bar or pie charts of facet value counts. Quickly display a chart of facet value counts in a dialog or 'dashboard' area.
Groups of checkbox facets for Boolean columns. Checking the facet will find records that match the 'yes' or 'true' value of the column.
Input Field facet type supports comparing a user-entered value with the facet column. This enables faceted searches such as finding stores within a user entered number of miles or records where a column contains the user entered text.
Performance optimization for distinct value facets.


Report Printing

Built-in PDF printing and Excel download for Interactive Reports, Interactive Grids and Classic Reports. Make sure to enable PDF and Excel as additional download format in your region attributes. Users can change the page orientation and size in the download dialog.
Interactive Report - Send E-Mail: All download formats can now be attached.
Enhanced integration with BI Publisher.
New APEX_REGION.EXPORT_DATA and APEX_DATA_EXPORT APIs to programmatically generate PDF, CSV, Excel, HTML, JSON and XML files.
Built-in PDF now supports Chinese, Japanese and Korean languages.


REST Data Source Synchronization


APEX supports data synchronization from a REST Data Source (formerly known as Web Source Modules) to a local table. Synchronization can run either on Schedule or on Demand, by calling the APEX_REST_SOURCE_SYNC package. Developers don't need to build custom PL/SQL code in order to copy data from REST services to local tables; APEX provides this as a declarative option.
APEX can generate the local target table automatically, based on the attributes of the REST Data Source.
REST Source Data can be appended or merged to the local table. Replacing all local data is also supported.
APEX components using the REST Data Source can be configured to use the local table instead.
Technical details like HTTP request limits, commit intervals or delete methods for the Replace mode are configurable.


REST Data Source Connector Plug-Ins


The APEX Plug-In infrastructure has been extended to support Connector Plug-Ins for external REST APIs. This enables APEX to fully leverage REST API features like result pagination or server-side filtering, also for 3rd Party REST Services which are not ORDS or Oracle Fusion SaaS Services.
The Developer creates a Plug-In of the REST Data Source type.
The Plug-In code handles REST service-specific implementation details like the pagination style or how filters are passed to the REST API.
When APEX invokes a REST Data Source (e.g. to render a report), the engine will invoke the Plug-In code and pass all relevant context information.
The Plug-In code executes one or multiple HTTP requests and passes results back to the APEX engine.
APEX processes the REST response received from the Plug-In.


New Web Credential Types


APEX 20.2 introduces new URL Query String and HTTP Header types for Web Credentials. This allows developers to use the secure and encrypted credential storage also for REST Services which expect e.g. an API key as part of the URL. APEX makes sure that such sensitive parts are not written to debug or execution logs.

A web credential can now be protected by providing a URL pattern. APEX will only use the Web Credential for URLs starting with the given pattern; otherwise an error message will be raised. To change the URL pattern, the secret part of the Web Credential needs to be entered again.


Redwood UI


Universal Theme now supports a new Redwood Light theme style, available via Theme Roller. Refresh your existing apps to uptake the latest version of Universal Theme and this new theme style.


Developer Experience

Page Designer has been enhanced to support multiple tabs in the Property Editor pane, making it more efficient to access the attributes of a region.
A new code editor has been implemented throughout the development environment, resulting in a greatly improved code editing experience. The improved editor includes enhanced code completion, syntax highlighting and vastly improved accessibility.
The Embedded Code utility allows developers to inspect the SQL, PL/SQL and JavaScript contained within an APEX application. Having the ability to view the embedded code makes conducting tasks such as code reviews, security evaluations or application tuning, far more convenient. Code can be saved to the file system from the App Builder, or using the APEXExport utility.
Quick SQL has been enhanced to support the saving of a model, and the automatic population of a Primary Key using column default


New and Improved Items

New Checkbox item type. This single checkbox offers an alternative to the Switch item type for Boolean columns. Works in Interactive Grid as well, even when not in edit mode. The previous Checkbox type has been renamed to Checkbox Group.
File Browse item type has been enhanced to support rendering as a drop zone, supporting the drag & drop of a file to be uploaded.
Rich Text Editor item type has been upgraded to use CKEditor 5 and now supports markdown output.
Text Field item type has a new Text Case setting to optionally transform the user-entered text to upper or lower case.
The Text Field Trim Spaces and Text Case settings and Textarea Trim Spaces settings are now applied on the client as well as the server.


Miscellaneous

Tree region type has been enhanced to support lazy loading and refresh without having to reload the full page
New Interactive Grid Saved Report Static ID Support
Linking to Interactive Grid saved reports should use the saved report static ID instead of the report name.
With APEX 20.2, the APEX_IG API has been updated to require using the saved report static ID rather than the report name, when linking to Interactive Grids.
Web Source Modules are now named REST Data Sources.


JavaScript Library Upgrades

Oracle JET 9.1.0
jQuery 3.5.1
CKEditor 5
Monaco Editor 0.20.0

Conditionally Serial Number, Alternate row Color and font style in Crystal Report (Seagate CR)

1. Adding Serial number in Crystal Report

Add formula like:

WhilePrintingRecords;  

numbervar srno;  

srno := srno + 1; 

2. Adding alternate row color in Crystal Report 

Add formula like:

 

if RecordNumber Mod 2 = 0 Then crSilver else crblue 

3. Adding alternate font style in Crystal Report 

if RecordNumber Mod 3 = 0 Then crbold else crRegular

Crystal Report Product key

Crystal Report 11 

Product Key : D720X-4UBV30S-BYN34C9-BA30040-WE

Crystal Reports Advance 9.0

Product Key : AVS50 - 81SG00S - G61002U

REGISTRATION CODE: 6094107517

How to permission to one user to another user in oracle database

SQL> conn apex_200100/Abcd_1234

ERROR:

ORA-28000: The account is locked.

Warning: You are no longer connected to ORACLE.

SQL>

SQL>

SQL>

SQL> conn sys as sysdba

Enter password:

Connected.

SQL>

SQL>

SQL> alter user apex_200100 identified by Abcd_1234;

User altered.

SQL> alter user apex_200100 identified by Abcd_1234 account unlock;

User altered.

SQL> conn apex_200100/Abcd_1234@orcl19c

Connected.

SQL>

grant select, insert, update, delete on wwv_flow_list_items to ipihr

Backup Oracle Database

 1. EXPDP

CREATE OR REPLACE DIRECTORY 
EXT_TAB_DIR AS 
'E:\oraclehomeuser\ext_tab_dir\'
/
GRANT READ, WRITE ON DIRECTORY EXT_TAB_DIR TO DBA
/
GRANT READ, WRITE ON DIRECTORY EXT_TAB_DIR TO EXP_FULL_DATABASE
/
GRANT READ, WRITE ON DIRECTORY EXT_TAB_DIR TO IMP_FULL_DATABASE
/
GRANT READ, WRITE ON DIRECTORY EXT_TAB_DIR TO PUBLIC
/
GRANT READ, WRITE ON DIRECTORY EXT_TAB_DIR TO SYSTEM WITH GRANT OPTION
/
expdp system/power@orcl schemas=sep directory=ext_tab_dir dumpfile=SAPMS.dmp reuse_dumpfiles=Y

select 'ALTER TABLE'|| table_name ||' ALLOCATE EXTENT;' from user_tables where segment_created='NO'