ords on weblogic in oracle apex

1. Install ords 

2 configure ords on weblogic

How to load images into Apex 18.2

There is a problem with your environment because the Application Express files have not been loaded. Please verify that you have copied the images directory to your application server as instructed in the Installation Guide. In addition, please verify that your image prefix path is correct. Your current path is /i/ (it should contain both starting and ending forward slashes, such as the default /i/). Use the SQL script reset_image_prefix.sql if you need to change it.

Reset Image Prefix in Oracle APEx.

Incase u wanna change the Image Prefix being used in your application express then

Run command >cmd


Change the current directory to apex41\apex\utilities.

C:\apex41\apex\utilities > sqlplus
 username : sys as sydba
Password :*****

sqlplus > @reset_image_prefix.sql
It will prompt for entering the new prefix ..

Enter in the form of [/i/]   , so current should be /j/.

Make sure your Application express instance is down else run it in resticted mdoe.


Now you Images will be refered in workspace using the /j/ instead of /i/ and these changes are updated by Oracle apex automticatically for the exisiting references .

Oracle Report - Oracle Report Trigger (Using in Text)

if :sal>='100'
then
 srw.set_text_color('red');
 srw.set_font_face('Arial');
 srw.set_font_size(10);
 srw.set_font_weight(srw.bold_weight);
 srw.set_font_style(srw.plain_style);
 END if;

https://docs.oracle.com/cd/E28280_01/bi.1111/b32122/orbr_condhigh004.htm#RSBDR1536

How to Migrate Oracle Forms 122C to Apex Apex 192

1.

Microsoft Windows [Version 10.0.18362.476]
(c) 2019 Microsoft Corporation. All rights reserved.

C:\WINDOWS\system32>frmf2xml F:\ALL_PROGRMMING\STR\SCL12C\Test12c\MKTG\Forms\MKT_CUSTOMER.fmb
'frmf2xml' is not recognized as an internal or external command,
operable program or batch file.

Error
Then

C:\WINDOWS\system32>cd.

C:\WINDOWS\system32>
C:\WINDOWS\system32>Cd..

C:\Windows>cd..

C:\>D:

D:\>cd D:\Oracle\Middleware\Oracle_Home\user_projects\domains\base_domain\config\fmwconfig\components\FORMS\instances\forms1\bin\

D:\Oracle\Middleware\Oracle_Home\user_projects\domains\base_domain\config\fmwconfig\components\FORMS\instances\forms1\bin>frmf2xml F:\ALL_PROGRMMING\STR\SCL12C\Test12c\MKTG\Forms\MKT_CUSTOMER.fmb
Oracle Forms 12.2.1 Forms to XML Tool
Copyright(c) 2001, 2017, Oracle and/or its affiliates.  All rights reserved.

Processing module F:\ALL_PROGRMMING\STR\SCL12C\Test12c\MKTG\Forms\MKT_CUSTOMER.fmb
XML Module saved as F:\ALL_PROGRMMING\STR\SCL12C\Test12c\MKTG\Forms\MKT_CUSTOMER_fmb.xml

D:\Oracle\Middleware\Oracle_Home\user_projects\domains\base_domain\config\fmwconfig\components\FORMS\instances\forms1\bin>

2. Login & Migrate in Oracle Apex
3.View effect

Collapsed Navigation Menu Entries in oracle apex

---only parents---

.js-navCollapsed .t-TreeNav .a-TreeView-node--topLevel>.a-TreeView-content.is-hover .a-TreeView-label {
visibility: visible;
left: 48px;
padding: 0 16px;
width: auto;
background-color: #0459a1; /* This would be your primary color */
}

.apex-side-nav.js-navCollapsed .t-Body-nav
, .apex-side-nav.js-navCollapsed .t-Body-nav .t-TreeNav {
    z-index: 999; /* Make it appear on top of the page content */
}

////////


---with child ---

.js-navCollapsed .t-TreeNav .a-TreeView-node--topLevel:hover ul {
display: block !important;
position: fixed;
left: 48px;
width: 220px;
padding: 0 0 0 12px;
}

.js-navCollapsed .t-TreeNav .a-TreeView-node--topLevel:hover > ul > .a-TreeView-node {
padding-left: 0px;
}

.js-navCollapsed .t-TreeNav .a-TreeView-node--topLevel:hover .a-TreeView-content .a-TreeView-label {
visibility: visible;
left: 48px;
padding: 0 8px;
width: 220px;
background-color: #0459a1;
}

.apex-side-nav.js-navCollapsed .t-Body-nav,
.apex-side-nav.js-navCollapsed .t-Body-nav .t-TreeNav {
z-index: 999; /* Make it appear on top of the page content */
}

How to Save NodeManaer PASS in Oracle 12C?

Start the standalone reports server and save the NodeManager Password:

cd /u01/app/oracle/user_projects/domains/forms_domain/bin

./startComponent.sh my_repsrv storeUserConfig

You will be prompted to try the nodemanager user password:

Please enter Node Manager password: xxx

Add Comments in Oracle Sql

Comment on column Test_Table.Column_name is     'Materials code';

Comment on column Test.code is     'Materials code';

Oracle user password expired

Modify the default user profile to set the password policies to 'UNLIMITED':

ALTER PROFILE DEFAULT LIMIT COMPOSITE_LIMIT UNLIMITED

  PASSWORD_LIFE_TIME UNLIMITED

  PASSWORD_REUSE_TIME UNLIMITED

  PASSWORD_REUSE_MAX UNLIMITED

  PASSWORD_VERIFY_FUNCTION NULL

  PASSWORD_LOCK_TIME UNLIMITED

  PASSWORD_GRACE_TIME UNLIMITED

  FAILED_LOGIN_ATTEMPTS UNLIMITED;

Create DBLINK

CREATE DATABASE LINK fremoteorcl
   CONNECT TO jnp_inv_rmpm_b IDENTIFIED BY jnp_inv_rmpm_b
   USING 'orcl122';

drop database link FREMOTE10G

----created 

CREATE PUBLIC DATABASE LINK "FREMOTE10G"
   CONNECT TO "JPLDBA" IDENTIFIED BY VALUES 'j'
   USING 'orcl10g';

   desc jnp_inv_rmpm_b.company@fremoteorcl
 
   desc COMPANY_INFO
   select * from tab;
   select * from jnp_inv_rmpm_b.company@fremoteorcl
 

ORA-01031: insufficient privileges when Toad 11.6 connect to an Oracle 12c database

Solution

Access to SYS.USER$ has been restricted in Oracle 12c (for oracle 12c  security , role, privilege, references doc  https://docs.oracle.com/database/121/DBSEG/E48135-19.pdf)

The issue can be resolved by granting access to the SYS.USER$ table to the related user /schemas:

GRANT SELECT ON SYS.USER$ TO <user>;

For grant the privilege login as sys dba

Sqlplus sys/sys_password@orcl  as sysdba

SQL> GRANT SELECT ON SYS.USER$ TO <user_name>;

Grant succeeded.

Reference Oracle Doc ID 1958777.1)

how to connect cmd to directory in window 10

Microsoft Windows [Version 10.0.18362.418]
(c) 2019 Microsoft Corporation. All rights reserved.

C:\WINDOWS\system32>cd c
The system cannot find the path specified.

C:\WINDOWS\system32>cd C:\

C:\>cd D:\

C:\>cd D:
D:\

C:\>D:\
'D:\' is not recognized as an internal or external command,
operable program or batch file.

C:\>cd D:\

C:\>Cd
C:\

C:\>cd D
The system cannot find the path specified.

C:\>cd D:\

C:\>D:

D:\>Oracle

D:\>
D:\>
D:\>