Unable To Launch Forms - User Has Denied The Privileges To The Code

security: Trust for: http://install.oracle.com:8008/OA_JAVA/oracle/apps/fnd/jar/fndforms.jar has ended: Wed Dec 31 18:00:00 CST 1969
security: Accessing keys and certificate in Mozilla user profile: null
security: Missing Application-Library-Allowable-Codebase manifest attribute for: http://install.oracle.com:8008/OA_JAVA/oracle/apps/fnd/jar/fndforms.jar
security: Loading Deployment certificates from C:\Users\lq220a\AppData\LocalLow\Sun\Java\Deployment\security\trusted.certs
basic: Dialog type is not candidate for embedding
basic: exception: User has denied the privileges to the code.
com.sun.deploy.security.BlockedException: User has denied the privileges to the code
at sun.plugin2.applet.Plugin2ClassLoader.getTrustedCodeSources(Unknown Source)
at com.sun.deploy.security.CPCallbackHandler$ParentCallback.strategy(Unknown Source)
at com.sun.deploy.security.CPCallbackHandler$ParentCallback.openClassPathElement(Unknown Source)
at com.sun.deploy.security.DeployURLClassPath$JarLoader.getJarFile(Unknown Source)
at com.sun.deploy.security.DeployURLClassPath$JarLoader.access$1000(Unknown Source)
at com.sun.deploy.security.DeployURLClassPath$JarLoader$1.run(Unknown Source)
at java.security.AccessController.doPrivileged(Native Method)
at com.sun.deploy.security.DeployURLClassPath$JarLoader.ensureOpen(Unknown Source)
at com.sun.deploy.security.DeployURLClassPath$JarLoader.(Unknown Source)
at com.sun.deploy.security.DeployURLClassPath$3.run(Unknown Source)
at java.security.AccessController.doPrivileged(Native Method)

Solution ::

1. Backup C:\Program Files (x86)\Java\jrexxx\lib\security\java.policy

2. Add the following in he beginning of java.policy

grant {
permission java.security.AllPermission;
};

3. Close the browser.

4. Retest the issue.

1)Uncheck the any .env entries in .bash_profile for applmgr and oracle user

a)For database user "Oracle"

[oracle@oel-01 ~]$ vi .bash_profile

To save it use command "Esc :wq!"

b)For application user "applmgr"

[root@oel-01 ~]# su - applmgr

[applmgr@oel-01 ~]$

To save it use command "Esc :wq!"

Clone the Db Tier

1)switch to database OS user

[root@oel-01 ~]# su - oracle

Last login: Fri Sep 2 07:53:23 PDT 2016 on pts/3

[oracle@oel-01 ~]$

2)Go to oracle home appsutil/clone/bin directory

[oracle@oel-01 clone]$ cd /u01/db/11.2.0/appsutil/clone/bin

[oracle@oel-01 clone]$ pwd

/u01/db/11.2.0/appsutil/clone/bin

3)Run the adcfgclone.pl script

check the logfile at the end should show below statement

END: ApplyDatabase Completed Successfully

4)Clean the fnd_nodes table

source the database env

[oracle@oel-01 11.2.0]$ cd /u01/db/11.2.0

[oracle@oel-01 11.2.0]$ . DEV_oel-01.env

[oracle@oel-01 11.2.0]$ sqlplus "/as sysdba"

SQL*Plus: Release 11.2.0.4.0 Production on Fri Sep 2 07:58:18 2016

Connected to:

Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production

With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> select open_mode from v$database

2 ;

OPEN_MODE

--------------------

READ WRITE

SQL> conn apps/apps

Connected.

SQL> EXEC FND_CONC_CLONE.SETUP_CLEAN;

PL/SQL procedure successfully completed.

SQL> commit;

Commit complete.

SQL>exit

5)Run autoconfig

[oracle@oel-01 DEV_cscoel-01]$ pwd

/u01/db/11.2.0/appsutil/scripts/DEV_cscoel-01

[oracle@cscoel-01 DEV_cscoel-01]$ sh adautocfg.sh

Enter the APPS user password:

The log file for this session is located at: /u01/db/11.2.0/appsutil/log/DEV_cscoel-01/09020803/adconfig.log

AutoConfig is configuring the Database environment...

AutoConfig will consider the custom templates if present.

Using ORACLE_HOME location : /u01/db/11.2.0

Classpath : :/u01/db/11.2.0/jdbc/lib/ojdbc6.jar:/u01/db/11.2.0/appsutil/java/xmlparserv2.jar:/u01/db/11.2.0/appsutil/java:/u01/db/11.2.0/jlib/netcfg.jar:/u01/db/11.2.0/jlib/ldapjclnt11.jar

Using Context file : /u01/db/11.2.0/appsutil/DEV_oel-01.xml

Context Value Management will now update the Context file

Updating Context file...COMPLETED

Attempting upload of Context file and templates to database...COMPLETED

Updating rdbms version in Context file to db112

Updating rdbms type in Context file to 64 bits

Configuring templates from ORACLE_HOME ...

AutoConfig completed successfully.

[oracle@oel-01 DEV_cscoel-01]$

Its completes the Db clone part

Clone apps Tier

1)Switch to application OS user

[root@oel-01 ~]# su - applmgr

Last login: Fri Sep 2 07:26:11 PDT 2016 on pts/2

[applmgr@oel-01 ~]$

2)Move or delete the previous filesystem files

adcfgclone.pl will recreate this files once again

[applmgr@oel-01 apps]$ mv EBSapps.env EBSapps.env_bkp

[applmgr@oel-01 apps]$ mv fs2 fs2_bkp

[applmgr@oel-01 apps]$ mv fs_ne fs_ne_bkp

move the below files from fs1 directory

[applmgr@oel-01 fs1]$ mv inst inst_bkp

[applmgr@oel-01 fs1]$ mv FMW_Home FMW_Home_bkp

[applmgr@oel-01 fs1]$ mv inst inst_bkp

Only EBSapps directory is enough to perform the clone rest will be created automatically by postclone step

3)Run adcfglone.pl

Go to below directory

Make note of apps and weblogic passwords

[applmgr@oel-01 bin]$ pwd

/u01/apps/fs1/EBSapps/comn/clone/bin

Note:: Port pool of run file system should be same as db port pool which we have given in db clone, port pool of patch files system can be choose anyvalue we like

[applmgr@oel-01 bin]$ perl adcfgclone.pl appsTier dualfs

Redwood Shores, California, USA

Oracle E-Business Suite Rapid Clone

Version 12.2

adcfgclone Version 120.63.12020000.56

Enter the APPS password :

Enter the Weblogic AdminServer password :

Do you want to add a node (yes/no) [no] :

Running: Context clone...

Log file located at /u01/apps/fs1/EBSapps/comn/clone/bin/CloneContext_0902082439.log

Provide the values required for creation of the new APPL_TOP Context file.

Target System Hostname (virtual or normal) [oel-01] : oel-01

Target System Database SID : DEV

Target System Database Server Node [oel-01] : oel-01

Target System Database Domain Name [xxxx.com] : xxxx.com

Target System Base Directory : /u01/apps

Target System Base Directory set to /u01/apps

Target System Current File System Base set to /u01/apps/fs1

Target System Other File System Base set to /u01/apps/fs2

Target System Fusion Middleware Home set to /u01/apps/fs1/FMW_Home

Target System Other File System Fusion Middleware Home set to /u01/apps/fs2/FMW_Home

Target System Web Oracle Home set to /u01/apps/fs1/FMW_Home/webtier

Target System Other File System Web Oracle Home set to /u01/apps/fs2/FMW_Home/webtier

Target System Appl TOP set to /u01/apps/fs1/EBSapps/appl

Target System Other File System Appl TOP set to /u01/apps/fs2/EBSapps/appl

Target System COMMON TOP set to /u01/apps/fs1/EBSapps/comn

Target System Other File System COMMON TOP set to /u01/apps/fs2/EBSapps/comn

Target System Instance Home Directory [/u01/apps] : /u01/apps

Target System Current File System Instance Top set to /u01/apps/fs1/inst/apps/DEV_oel-01

Do you want to preserve the Display [cscoel-01:0.0] (y/n) : n

Target System Display [cscoel-01:0.0] : cscoel-01:1.0

Target System Root Service [enabled] :

Target System Web Entry Point Services [enabled] :

Target System Web Application Services [enabled] :

Target System Batch Processing Services [enabled] :

Target System Other Services [disabled] :

Target System Port Pool [0-99] : 0

Checking the port pool 0

done: Port Pool 0 is free

Report file located at /u01/apps/fs1/inst/apps/DEV_cscoel-01/admin/out/portpool.lst

UTL_FILE_DIR on database tier consists of the following directories.

1. /usr/tmp

2. /usr/tmp

3. /u01/db/11.2.0/appsutil/outbound/DEV_cscoel-01

4. /usr/tmp

Choose a value which will be set as APPLPTMP value on the target node [1] : 1

The new APPL_TOP context file has been created :

/u01/apps/fs1/inst/apps/DEV_oel-01/appl/admin/DEV_oel-01.xml

Check Clone Context logfile /u01/apps/fs1/EBSapps/comn/clone/bin/CloneContext_0902082439.log for details.

Creating Patch file system context file.....

Log file located at /u01/apps/fs1/EBSapps/comn/clone/bin/CloneContextPatch_0902082811.log

Target System Other File System Instance Top set to /u01/apps/fs2/inst/apps/DEV_cscoel-01

Target System Port Pool [0-99] : 1

Checking the port pool 1

done: Port Pool 1 is free

Report file located at /u01/apps/fs2/inst/apps/DEV_cscoel-01/admin/out/portpool.lst

The new APPL_TOP context file has been created :

/u01/apps/fs2/inst/apps/DEV_cscoel-01/appl/admin/DEV_cscoel-01.xml

Check Clone Context logfile /u01/apps/fs1/EBSapps/comn/clone/bin/CloneContextPatch_0902082811.log for details.

FMW Pre-requisite check log file location : /u01/apps/fs1/EBSapps/comn/clone/FMW/logs/prereqcheck.log

Running: FMW pre-req check...

Do you want to start the services (y/n) : N

it should exists with status 0

---Above process completes the Clone of Oracle applications and DB

To Start and stop services

1)How to start the db services

a)Switch to Oracle user

[root@oel-01 ~]# su - oracle

Last login: Tue Sep 6 02:10:31 PDT 2016 on pts/0

[oracle@oel-01 ~]$

SQL>startup

SQL>exit

e)Start the Listener

[oracle@oel-01 11.2.0]$ lsnrctl start DEV

check the status of Listiner until you see below

Service "ebs_patch" has 1 instance(s).

Instance "DEV", status READY, has 1 handler(s) for this service...

The command completed successfully

2)To start the application

a)switch to application user

[root@oel-01 ~]# su - applmgr

Last login: Sat Sep 3 06:17:08 PDT 2016 on pts/1

[applmgr@oel-01 ~]$

b)source the generic env and select run file system

[applmgr@oel-01 apps]$ pwd

/u01/apps

[applmgr@oel-01 apps]$ . EBSapps.env

E-Business Suite Environment Information

----------------------------------------

RUN File System : /u01/apps/fs1/EBSapps/appl

PATCH File System : /u01/apps/fs2/EBSapps/appl

Non-Editioned File System : /u01/apps/fs_ne

DB Host: oel-01.xxxx.com Service/SID: DEV

E-Business Suite Environment Setting

------------------------------------

- Enter [R/r] for sourcing Run File System Environment file, or

- Enter [P/p] for sourcing Patch File System Environment file, or

- Enter anything else to exit

Please choose the environment file you wish to source [R/P]:R

Sourcing the RUN File System ...

[applmgr@oel-01 apps]$

c)Locate the scripts directory

[applmgr@oel-01 apps]$ cd $ADMIN_SCRIPTS_HOME

[applmgr@oel-01 scripts]$ pwd

/u01/apps/fs1/inst/apps/DEV_cscoel-01/admin/scripts

it prompts for apps and weblogic password

it should exists with status 0

check for any process running under applmgr user wait until it stops

[applmgr@oel-01 scripts]$ ps -ef | grep applmgr

b)To stop db services

Note:: please do the same as start process expect the shutdown command as below

SQL>shut immediate

SQL>exit

CMD>lsnrctl stop DEV

Oracle Application DBA

Tuesday, March 7, 2017

Monday, February 13, 2017

How to clone Oracle Apps 12.2.X

1)Uncheck the any .env entries in .bash_profile for applmgr and oracle user

a)For database user "Oracle"

b)For application user "applmgr"

Clone the Db Tier

1)switch to database OS user

2)Go to oracle home appsutil/clone/bin directory

3)Run the adcfgclone.pl script

4)Clean the fnd_nodes table

5)Run autoconfig

Clone apps Tier

1)Switch to application OS user

2)Move or delete the previous filesystem files

3)Run adcfglone.pl

To Start and stop services

1)How to start the db services

a)Switch to Oracle user

b)Go to Oracle home

c)Source the env

d)Start the database

e)Start the Listener

2)To start the application

a)switch to application user

b)source the generic env and select run file system

c)Locate the scripts directory

d)Start the application services

3)To stop the db and apps services

a)To stop apps services

b)To stop db services