Search found 1994 matches

by admin
Fri May 20, 2022 3:44 am
Forum: Application DBA & System Administration
Topic: GNUPG GPG
Replies: 0
Views: 7

GNUPG GPG

$ gpg2 –list-keys
$ gpg2 –list-secret-keys
by admin
Mon May 16, 2022 5:23 am
Forum: Application DBA & System Administration
Topic: CDB and PDB Queries
Replies: 0
Views: 36

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: 28

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: 50

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: 186

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: 445

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: 294

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: 217

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: 209

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: 382

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...
by admin
Wed Feb 02, 2022 5:03 pm
Forum: Oracle APEX
Topic: Oracle default EMP and DEPT table script with data
Replies: 0
Views: 410

Oracle default EMP and DEPT table script with data

CREATE TABLE "DEPT" ( "DEPTNO" NUMBER(2,0), "DNAME" VARCHAR2(14 BYTE), "LOC" VARCHAR2(13 BYTE) ) ; ALTER TABLE "DEPT" ADD PRIMARY KEY ("DEPTNO"); CREATE TABLE "EMP" ( "EMPNO" NUMBER(4,0) NOT NULL, "ENAME" VARC...
by admin
Wed Feb 02, 2022 2:36 am
Forum: Application DBA & System Administration
Topic: Oracle VM Virtual Appliances for Oracle E-Business Suite 12.2.10
Replies: 0
Views: 369

Oracle VM Virtual Appliances for Oracle E-Business Suite 12.2.10

Oracle VM Virtual Appliances for Oracle E-Business Suite 12.2.10 Here steps to install and configure Oracle EBS 12.2.10 in VirtualBox are explained so anyone can configure on a laptop/desktop to use and practice. space.png 1. Download Oracle VM VirtualBox vm.png https://www.oracle.com/virtualizatio...
by admin
Thu Jan 27, 2022 4:44 pm
Forum: Oracle APEX
Topic: Built-in substitution names
Replies: 0
Views: 358

Built-in substitution names

The built-in substitution names are:

&APP_USER.
&APP_ID.
&APP_PAGE_ID.
&APP_SESSION.
&APP_FILES.
&WORKSPACE_FILES.
&REQUEST.
&DEBUG.
&APEX_FILES.
&IMAGE_PREFIX. (legacy- use &APEX_FILES. instead)
&APEX_VERSION.
by admin
Wed Jan 26, 2022 1:28 pm
Forum: Oracle APEX
Topic: Upload Multiple files into table code
Replies: 0
Views: 371

Upload Multiple files into table code

create table erpstuff_files (name VARCHAR2(400), filename VARCHAR2(400), mime_type VARCHAR2(255), created_on date, blob_content blob); declare l_file_names apex_t_varchar2; l_file apex_application_temp_files%rowtype; begin l_file_names := apex_string.split ( p_str => :P2_DOC, p_sep => ':' ); for i i...
by admin
Sat Jan 22, 2022 6:37 am
Forum: Oracle APEX
Topic: ORDS Scripts
Replies: 0
Views: 468

ORDS Scripts

GET declare l_clob clob; json_content APEX_JSON.t_values; v_lines number; begin l_clob:= apex_web_service.make_rest_request( p_url => 'https://apex.oracle.com/pls/apex/erpstuffords/hr/dept', p_http_method => 'GET', p_parm_name => apex_util.string_to_table('deptno'), p_parm_value => apex_util.string_...