Starting
!/bin/bash
cd /u01/ords
nohup java -Dorg.eclipse.jetty.server.Request.maxFormContentSize=20971520 -jar ords.war standalone &
Stopping
kill ps -ef | grep ords.war | awk '{print $2}'
or
ps -ef | grep ords.war | awk '{print $2}'
kill 1234 << output of ps if any
Search found 2063 matches
- Sun Aug 28, 2022 7:01 am
- Forum: Oracle APEX
- Topic: ORDS Standalone Start and Stop Linux
- Replies: 0
- Views: 13917
- Mon Aug 22, 2022 9:45 am
- Forum: Oracle APEX
- Topic: Jasper: Message Class not found when loading object from file
- Replies: 0
- Views: 13655
Jasper: Message Class not found when loading object from file
If Jasper Studio version is higher than 6.4 then following error expected in APEX, HTTP Status 500 – Internal Server Error Type Exception Report Message Class not found when loading object from file: /u01/ords/JasperReport/reports/inv.jasper. Description The server encountered an unexpected conditio...
- Sun Aug 21, 2022 7:38 am
- Forum: Oracle APEX
- Topic: Oracle Database JDBC driver link
- Replies: 0
- Views: 13756
- Sat Aug 20, 2022 5:51 am
- Forum: Application DBA & System Administration
- Topic: How to view Environment variables in Linux & Windows?
- Replies: 0
- Views: 13256
How to view Environment variables in Linux & Windows?
Linux :
$ echo $ORACLE_HOME
$ echo $ORACLE_SID
wINDOWS
C:\> echo %ORACLE_HOME%
C:\> echo %ORACLE_SID%
$ echo $ORACLE_HOME
$ echo $ORACLE_SID
wINDOWS
C:\> echo %ORACLE_HOME%
C:\> echo %ORACLE_SID%
- Tue Aug 16, 2022 11:38 am
- Forum: Oracle APEX
- Topic: Find if a Patch is Applied
- Replies: 0
- Views: 13889
Find if a Patch is Applied
select patch_version, installed_on from apex_patches where patch_number = 34020981 order by installed_on;
- 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: 13963
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...
- 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: 13134
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...
- Tue Aug 09, 2022 10:38 am
- Forum: Application DBA & System Administration
- Topic: Checke Workflow Admin Script
- Replies: 0
- Views: 12474
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 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;
- Mon Jun 13, 2022 6:00 am
- Forum: Oracle APEX
- Topic: SMS service in Oracle Database & APEX
- Replies: 0
- Views: 13650
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 ...
- Fri May 20, 2022 3:44 am
- Forum: Application DBA & System Administration
- Topic: GnuPG GPG
- Replies: 0
- Views: 13287
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...
- Mon May 16, 2022 5:23 am
- Forum: Application DBA & System Administration
- Topic: CDB and PDB Queries
- Replies: 0
- Views: 13137
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;
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;
- Sun May 15, 2022 5:04 pm
- Forum: Application DBA & System Administration
- Topic: How to get SID and Service Name?
- Replies: 0
- Views: 13257
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_...
- Mon May 09, 2022 3:46 am
- Forum: Oracle APEX
- Topic: Get Milliseconds in Date & time?
- Replies: 0
- Views: 13871
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
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
- Fri Apr 15, 2022 7:53 am
- Forum: Oracle APEX
- Topic: APEX_AUTOMATION Package
- Replies: 0
- Views: 14480
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...
- Tue Mar 15, 2022 5:30 am
- Forum: Oracle APEX
- Topic: Oracle APEX Online Training
- Replies: 1
- Views: 6411
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 ...