Search found 2009 matches

by admin
Fri Sep 16, 2022 4:29 am
Forum: Application DBA & System Administration
Topic: JDeveloper Installation
Replies: 0
Views: 42

JDeveloper Installation

Unable to launch the Java Virtual Machine Located at path: ..\..\jdk\jre\bin\client\jvm.dll

C:\Oracle\OAF_p28163665_R12\jdevbin\jdev\bin\jdev.conf

SetJavaHome C:\Program Files (x86)\Java\jre1.8.0_201

https://www.oracle.com/java/technologie ... loads.html
by admin
Sat Sep 10, 2022 3:52 am
Forum: Oracle Forms & Reports
Topic: INST-07545: Unexpected Error java.lang.NullPointerException
Replies: 0
Views: 72

INST-07545: Unexpected Error java.lang.NullPointerException

Oracle WebLogic Server - Version 12.2.1.0.0 and later Oracle Fusion Middleware - Version 12.2.1.0.0 and later While installation of Forms and Reports Builder 12c selecting home you might get this error INST-07545. You need to set TEMP folder environment variable in windows OS, Set temp environment v...
by admin
Mon Sep 05, 2022 5:38 am
Forum: Reports (Only Oracle Apps Reports)
Topic: Upgrading form6i and report6i to 11g/12c?
Replies: 0
Views: 121

Upgrading form6i and report6i to 11g/12c?

It is always recommended to upgrade to the latest version of any product while Oracle Developer 6i is already obsolete by Oracle and de-supported. Few companies due to different factors can't upgrade so here we will share to stay with 6i and connect to 12c and higher versions or how to upgrade. Para...
by admin
Tue Aug 30, 2022 7:47 am
Forum: Oracle APEX
Topic: Oracle API Reference Document 21.2
Replies: 0
Views: 197

Oracle API Reference Document 21.2

Oracle apex api reference 21.2.zip
by admin
Sun Aug 28, 2022 8:51 am
Forum: Oracle APEX
Topic: Sum two tables column in single SQL
Replies: 0
Views: 121

Sum two tables column in single SQL

CREATE TABLE ALLOW (ANO NUMBER(3), ANAME VARCHAR2(15), CONSTRAINT ANO_PK PRIMARY KEY (ANO)); CREATE TABLE DED (DEDNO NUMBER(3), DEDNAME VARCHAR2(20), CONSTRAINT DEDNO_PK PRIMARY KEY (DEDNO)); CREATE TABLE EMP(ENO NUMBER(5), ENAME VARCHAR2(20), CONSTRAINT ENO_PK PRIMARY KEY(ENO)); CREATE TABLE EMPA(E...
by admin
Sun Aug 28, 2022 7:01 am
Forum: Oracle APEX
Topic: ORDS Standalone Start and Stop Linux
Replies: 0
Views: 81

ORDS Standalone Start and Stop Linux

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
by admin
Mon Aug 22, 2022 9:45 am
Forum: Oracle APEX
Topic: Jasper: Message Class not found when loading object from file
Replies: 0
Views: 97

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...
by admin
Sat Aug 20, 2022 5:51 am
Forum: Application DBA & System Administration
Topic: How to view Environment variables in Linux & Windows?
Replies: 0
Views: 113

How to view Environment variables in Linux & Windows?

Linux :

$ echo $ORACLE_HOME
$ echo $ORACLE_SID

wINDOWS
C:\> echo %ORACLE_HOME%
C:\> echo %ORACLE_SID%
by admin
Tue Aug 16, 2022 11:38 am
Forum: Oracle APEX
Topic: Find if a Patch is Applied
Replies: 0
Views: 152

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

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

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

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

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 ...