Search found 1999 matches

by admin
Tue Aug 16, 2022 11:38 am
Forum: Oracle APEX
Topic: Find if a Patch is Applied
Replies: 0
Views: 44

Find if a Patch is Applied

select patch_version, installed_on from apex_patches where patch_number = 34020981 order by installed_on;
by admin
Sat Aug 13, 2022 10:37 am
Forum: Oracle APEX
Topic: Error: A JNI error has occurred, please check your installation and try again
Replies: 0
Views: 59

Error: A JNI error has occurred, please check your installation and try again

While installing ORDS 22.1 and Java 1.8 you might get this error as 1.8 not supported minimum 11 or 17 version of java need to be installed, ords configuration Issue in new version 22.1 and Java 1.8 C:\oracle\ords>java -jar ords.war install Error: A JNI error has occurred, please check your installa...
by admin
Wed Aug 10, 2022 6:43 am
Forum: Application DBA & System Administration
Topic: GnuPG GPG Encryption and Decryption 2/2 | Privacy and Security for Integrations with Banks
Replies: 0
Views: 107

GnuPG GPG Encryption and Decryption 2/2 | Privacy and Security for Integrations with Banks

GnuPG GPG Encryption and Decryption Privacy and Security for Integrations with Banks Videos Part 1 Encryption and Decryption Concepts Part 2 Creating Keys Listing Keys (Secret & Public) Encrypting a File Decrypting a File Exporting Keys Importing Keys Changing Passphrase Creating Trust GPG Setup...
by admin
Tue Aug 09, 2022 10:38 am
Forum: Application DBA & System Administration
Topic: Checke Workflow Admin Script
Replies: 0
Views: 51

Checke Workflow Admin Script

Hi,
By default SYSADMIN will be the administrator and to monitor WF you will have to login as SYSADMIN so using this command you can change and '*' means everyone,

SQLPLUS as APPS
update wf_resources set text='*' where name='WF_ADMIN_ROLE';
commit;
by admin
Mon Jun 13, 2022 6:00 am
Forum: Oracle APEX
Topic: SMS service in Oracle Database & APEX
Replies: 0
Views: 294

SMS service in Oracle Database & APEX

In Pakistan, if you want to use SMS service then try to get a package from a company like http://lifetimesms.com or any other company providing such services and integrate as below in the Oracle database. by Muhammad Abrar CREATE OR REPLACE PACKAGE erpstuff_sms_api IS FUNCTION send_sms(api_token IN ...
by admin
Fri May 20, 2022 3:44 am
Forum: Application DBA & System Administration
Topic: GnuPG GPG
Replies: 0
Views: 424

GnuPG GPG

1280px-Gnupg_logo.svg.png Configuration Details Key Type = RSA Keysize = 4096 Validity = 2 years Real name = erpstuff Email address = info@erpstuff.com Comment = training by ERPstuff.com Passphrase = ERPstuff123 Key ID = ? Listing Existing Keys $ gpg2 –list-keys $ gpg2 –list-secret-keys Keys Genera...
by admin
Mon May 16, 2022 5:23 am
Forum: Application DBA & System Administration
Topic: CDB and PDB Queries
Replies: 0
Views: 282

CDB and PDB Queries

Determining Whether a Database is a CDB
SELECT CDB FROM V$DATABASE;

Each Container in a CDB
SELECT NAME, CON_ID, DBID, CON_UID, GUID FROM V$CONTAINERS ORDER BY CON_ID;

Status of Each PDB
SELECT PDB_ID, PDB_NAME, STATUS FROM DBA_PDBS ORDER BY PDB_ID;
by admin
Sun May 15, 2022 5:04 pm
Forum: Application DBA & System Administration
Topic: How to get SID and Service Name?
Replies: 0
Views: 267

How to get SID and Service Name?

Import SQL's SELECT sys_context('userenv','instance_name') FROM dual; select value from v$parameter where name like '%service_name%'; SELECT sys_context('USERENV', 'SID') FROM DUAL; select sys_context('userenv','db_name') from dual; select sys_context('userenv', 'server_host') from dual; select ora_...
by admin
Mon May 09, 2022 3:46 am
Forum: Oracle APEX
Topic: Get Milliseconds in Date & time?
Replies: 0
Views: 322

Get Milliseconds in Date & time?

Hi,
The following query can be used to get milliseconds in the date & time stamp,

SELECT to_char (SYSTIMESTAMP, 'DD-Mon-RR HH24:MI:SS.FF') FROM DUAL;
SELECT to_char (SYSTIMESTAMP, 'DD-Mon-RR HH24:MI:SS.FF3') FROM DUAL;

08-May-22 23:38:13.698

Reference_R21
by admin
Fri Apr 15, 2022 7:53 am
Forum: Oracle APEX
Topic: APEX_AUTOMATION Package
Replies: 0
Views: 469

APEX_AUTOMATION Package

The APEX_AUTOMATION package provides automated functionality to your environment. Automations are a sequential set of actions that are triggered by query results. Use automation to monitor data and then perform the appropriate action, such as auto-approving specific requests and sending email alerts...
by admin
Tue Mar 15, 2022 5:30 am
Forum: Oracle APEX
Topic: Oracle APEX Online Training
Replies: 1
Views: 713

Oracle APEX Online Training

This Oracle APEX training is designed for those who are already working in Oracle EBS and want to use Oracle APEX to create Dashboards, Reports, and other Self Service Applications. Duration: 3 Days Fee: 650 USD Introductory Fee: 325 USD Proposed Dates: 21st Mar to 31st Mar (depending on registered ...
by admin
Fri Mar 04, 2022 4:41 pm
Forum: Application DBA & System Administration
Topic: Assign static IP in Oracle Linux
Replies: 0
Views: 533

Assign static IP in Oracle Linux

ifconfig eth0 192.168.1.10 netmask 255.255.255.0
by admin
Fri Mar 04, 2022 3:26 pm
Forum: Application DBA & System Administration
Topic: Verify Oracle EBS user password
Replies: 0
Views: 439

Verify Oracle EBS user password

select fnd_web_sec.validate_login(‘SYSADMIN’,’sysadmin’) from dual;

It should return Y or N.
by admin
Fri Mar 04, 2022 3:26 pm
Forum: Application DBA & System Administration
Topic: Enable/Disable Oracle Linux GUI
Replies: 0
Views: 431

Enable/Disable Oracle Linux GUI

In Oracle EBS VM's normally GUI is not there so only terminal will be there for the command line. To install/enable GUI following these steps as root user, Enable 1 - $ yum update 2 - $ yum groupinstall "Server with GUI" 3 - Start Oracle Linux GUI on system startup $ ln -sf /lib/systemd/sy...
by admin
Sun Feb 06, 2022 9:41 am
Forum: Application DBA & System Administration
Topic: Downloading Linux Image and Installation
Replies: 0
Views: 608

Downloading Linux Image and Installation

1. Download Linux 8.0 (example). linux1.png 2. There are 3 files in it you need V983280-01 V983278-01 V983279-01 V983280-01 3. Now need to download a Bootable Creator USB/DVD better use USB 8GB or above. https://www.balena.io/etcher/ https://rufus.ie/en 4. I used Etcher as it is open source while Ru...