Workflow Builder - Cannot Connect To Database, ORA-12154

Workflow Builder - Cannot Connect To Database, ORA-12154 (Doc ID 435755.1)

APPLIES TO: Oracle Workflow - Version 11.5.10.2 to 12.2.3 [Release 11.5.10 to 12.2] Information in this document applies to any platform. Checked for relevance on 23-NOV-2013 SYMPTOMS The Following error occurs whilst trying to start the Workflow Builder 2.6.3.5 Error 1700: Could not connect with username/password'apps/<password>@test.com' (ORA-12154: TNS:could not resolve the connect identifier specified|'). . CAUSE This was reported in internal Bug 4912280 Issue occurs when one attempts to use a local TNSNAMES.ORA file on a Windows platform. SOLUTION To implement the solution, please execute the following steps: 1. Right-click My Computer and choose Properties. 2. On the Advanced tab, choose Environment Variables. 3. Add or edit TNS_ADMIN as a system environment variable so that it points to the directory that contains the TNSNAMES.ORA file used.  -ex: TNS_ADMIN = D:\OraHome1\network\ADMIN     also,  Add or edit ORACLE_HOME as a System environment variable so that it points to the directory where the Software is installed -- ex:  ORACLE_HOME=D:\OraHome1 4. Change the tnsmames.,ora connection string to include the fully qualified hostname.domain From: -------- <SID> =  (DESCRIPTION =    (ADDRESS_LIST =      (ADDRESS = (PROTOCOL = TCP)(HOST = myoracle.com)(PORT = 1521))    )    (CONNECT_DATA =      (SERVICE_NAME = dhd01)    )  ) To: ----- <SID>.myoracle.com =  (DESCRIPTION =    (ADDRESS_LIST =      (ADDRESS = (PROTOCOL = TCP)(HOST = .myoracle.com)(PORT = 1521))    )    (CONNECT_DATA =      (SERVICE_NAME = dhd01)    )  ) NOTE: If the Environment Variable settings interfere with other products that are installed on the PC, then do the following: Suggestions are: ---------------------- Leave the tnsames.ora change in place Unset the ORACLE_HOME & TNS_ADMIN System variable Reboot the Laptop Test the issue. *** One can include other TNSNAMES.ORA files with the INAME command inside the TNSNAMES.ORA file.

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

/u01/test/TEST/db/tech_st/10.2.0/network/admin/TEST_test

[oratest@test TEST_test]$ ls tnsnames.ora

tnsnames.ora

[test@test TEST_test]$ pwd

/u01/test/TEST/db/tech_st/10.2.0/network/admin/TEST_test

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

copt tnsname.ora file from linux server from above directory and paset it into oracle wokflow biulder software installed directory

add two enviroment variables in my computer properties ->advanced tab->enviroment variables

variable                                               value

TNS_ADMIN                                      D:\Home_2\network\ADMIN

ORACLE_HOME                                D:\Home_2

connected to apps@TEST

How To Access Forms Directly In Oracle Applications R12

http://dbissues.blogspot.com/2016/02/how-to-access-forms-directly-in-oracle.html

How To Access Forms Directly In Oracle Applications R12 (Doc ID 552301.1)

Overcoming the Oracle Apps R12 Error APP-FND-01542 on 64 bit Redhat 5.5

Ever try to login to Oracle Apps R12, and get the error APP-FND-01542 on 64 bit Redhat 5.5?

APP-FND-01542: The applications servers is not authorized to access this database.

Here is how to solve it.

Cause:

In the CONTEXT_FILE, the setting, s_appserverid_authentication is set to SECURE.

Modes:
– ON : Partial
– SECURE : activates full server security (SECURE mode)
– OFF : deactivates server security

Solution:

Find the CONTEXT_FILE. In my case:

CONTEXT_FILE=/oapps/applmgr/VIS/inst/apps/VIS_black/appl/admin/VIS_black.xml

Backup The File:

cd /oapps/applmgr/VIS/inst/apps/VIS_black/appl/admin

cp VIS_black.xml VIS_black.xml_2012jan21

Look for the setting: s_appserverid_authentication
Ensure it is there:

cat /oapps/applmgr/VIS/inst/apps/VIS_black/appl/admin/VIS_black.xml | grep -i “appserverid_auth”
SECURE

Edit the file. Change the setting to OFF.

————

Of course, only change the setting to OFF, if your environment security policies would allow it.

————

Run the Script:

adautocfg.sh

You then need to “recompile” all the scripts that Oracle Apps uses.

Use the script: adautocfg.sh
Found in ADMIN_SCRIPTS_HOME

In my case:
ADMIN_SCRIPTS_HOME=/oapps/applmgr/VIS/inst/apps/VIS_black/admin/scripts

Shutdown the APPS middle tier.

As applmgr:

cd /oapps/applmgr/VIS/inst/apps/VIS_black/admin/scripts/
sh adautocfg.sh

Enter the password for APPS

It will then take a number of minutes to reconfigure all the scripts.

Enter the APPS user password:

The log file for this session is located at: /oapps/applmgr/VIS/inst/apps/VIS_black/admin/log/01221331/adconfig.log

AutoConfig is configuring the Applications environment…

AutoConfig will consider the custom templates if present.
Using CONFIG_HOME location : /oapps/applmgr/VIS/inst/apps/VIS_black
A Classpath : /oapps/applmgr/VIS/apps/apps_st/comn/java/lib/appsborg2.zip:/oapps/applmgr/VIS/app
s/apps_st/comn/java/classes

Using Context file : /oapps/applmgr/VIS/inst/apps/VIS_black/appl/admin/VIS_black.xml

Context Value Management will now update the Context file

Updating Context file…COMPLETED

Attempting upload of Context file and templates to database…COMPLETED

Configuring templates from all of the product tops…
Configuring AD_TOP……..COMPLETED
Configuring FND_TOP…….COMPLETED
Configuring ICX_TOP…….COMPLETED
Configuring MSC_TOP…….COMPLETED
Configuring IEO_TOP…….COMPLETED
Configuring BIS_TOP…….COMPLETED
Configuring AMS_TOP…….COMPLETED
Configuring CCT_TOP…….COMPLETED
Configuring WSH_TOP…….COMPLETED
Configuring CLN_TOP…….COMPLETED
Configuring OKE_TOP…….COMPLETED
Configuring OKL_TOP…….COMPLETED
Configuring OKS_TOP…….COMPLETED
Configuring CSF_TOP…….COMPLETED
Configuring IGS_TOP…….COMPLETED
Configuring IBY_TOP…….COMPLETED
Configuring JTF_TOP…….COMPLETED
Configuring MWA_TOP…….COMPLETED
Configuring CN_TOP……..COMPLETED
Configuring CSI_TOP…….COMPLETED
Configuring WIP_TOP…….COMPLETED
Configuring CSE_TOP…….COMPLETED
Configuring EAM_TOP…….COMPLETED
Configuring FTE_TOP…….COMPLETED
Configuring ONT_TOP…….COMPLETED
Configuring AR_TOP……..COMPLETED
Configuring AHL_TOP…….COMPLETED
Configuring OZF_TOP…….COMPLETED
Configuring IES_TOP…….COMPLETED
Configuring CSD_TOP…….COMPLETED
Configuring IGC_TOP…….COMPLETED

AutoConfig completed successfully.

————–

It reconfigures 31 TOPs.

Check the activity in the log file. Almost 4000 lines long.

/oapps/applmgr/VIS/inst/apps/VIS_black/admin/log/01221331/adconfig.log

From the log, it also logs into the database with sqlplus

————–

Restart The Apps Middle Tier and Test:

file:///oapps/applmgr/VIS/apps/tech_st/10.1.2/tools/web/html/runform.htm

Login

The error should be solved now.

——————–

APP-FND-01542 : This Application Server is not authorized to access this system

Posted: October 3, 2012 in Login_issues

0

When i was trying to access direct forms on Oracle Applications 11i, it give me error messages “APP-FND-01542 : This Application Server is not authorized to access this system”. Please contact your system administrator.

Usually this error message will pop-up when value for profile “s_appserverid_authentication” is set to “SECURE” in applications context file. This profile value can be set to three different value “SECURE, PARTIAL, OFF”.

To over come this issue set check profile value “s_appserverid_authentication”, if its set to “SECURE”, then change it this value to “OFF”

1) stop the middle tiers
2) Run autoconfig
3) startup the middle tier services
4) retest direct login to forms

How to Compile a Form in Oracle EBS Enviroment

http://dbissues.blogspot.com/2016/02/how-to-compile-form-in-oracle-ebs.html


Source the APPS Enviroment and run the below command

Echo $FORMS_PATH

If not set then type,

Export FORMS_PATH=$FORMS_PATH:$AU_TOP/FORMS/US

Forms must have Read,wrtie and Execute Rights: 

chmod 777 RECEIPT.fmb "OR"
chmod -Rf 775 RECEIPT.fmb

Command

frmcmp_batch userid=APPS/APPS module=/apps/test/TEST/fs1/EBSapps/appl/au/12.0.0/forms/US/SSUE.fmb output_file=/apps/test/TEST/fs1/EBSapps/appl/ar/12.0.0/forms/US/SSUE.fmx module_type=form

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

Example

Copy Source Forms in the below folder:

/apps/test/TEST/apps/apps_st/appl/au/12.0.0/forms/US

Compiled form should be placed in appropriate folder (i.e. ar)

/apps/test/TEST/apps/apps_st/appl/ar/12.0.0/forms/US

Login to apps os user by using putty

[test@test appl]$ pwd

/apps/test/TEST/apps/apps_st/appl

[test@test appl]$

[test@test appl]$ echo $AU_TOP

[test@test appl]$ ll *.eng

ls: *.eng: No such file or directory

[test@test appl]$

[test@test appl]$

[test@test appl]$ ll *.eng

ls: *.eng: No such file or directory

[test@test appl]$

[test@test appl]$

[test@test appl]$ ll *.env

-rw-r--r-- 1 test dba  1095 Jun  3 06:22 APPSTEST_test.env

-rw-r--r-- 1 test dba  1082 Mar 27 16:08 APPSPROD_db.env

-rwxrwxr-x 1 test dba  1096 Sep 11  2009 APPSTEST_test.env

-rw-r--r-- 1 test dba 16897 Jun  3 06:22 TEST_test.env

-rw-r--r-- 1 test dba 17044 Mar 27 16:08 PROD_db.env

-rwxrwxr-x 1 test dba 17102 Sep 11  2009 TEST_test.env

[test@test appl]$

[test@test appl]$ echo $AU_TOP

[test@test appl]$ . ./APPSTEST_test.env

[test@test appl]$

[test@test appl]$ echo $AU_TOP

/apps/test/TEST/apps/apps_st/appl/au/12.0.0

[test@test appl]$

[test@test appl]$

[test@test appl]$ cd $AU_TOP

[test@test 12.0.0]$ pwd

/apps/test/TEST/apps/apps_st/appl/au/12.0.0

[test@test 12.0.0]$

[test@test 12.0.0]$ cd forms/US/

[test@test US]$

[test@test US]$ ll H*

-rw-r--r-- 1 test dba 217088 Jul  7 18:29 HFSRECEIPT.fmb

[test@test US]$

[test@test US]$ ls –alrt

[test@test US]$ chmod 777 RECEIPT.fmb

[test@test US]$

[test@test US]$ ll H*

-rwxrwxrwx 1 test dba 217088 Jul  7 18:29 RECEIPT.fmb

[test@test appl]$ frmcmp_batch userid=APPS/APPS module=/apps/test/TEST/apps/apps_st/appl/au/12.0.0/forms/US/RECEIPT.fmb output_file=/apps/test/TEST/apps/apps_st/appl/ar/12.0.0/forms/US/RECEIPT.fmx module_type=form

How to Change User Password from Database level

After running apps env then run the following command.

FNDCPASS apps/apps 0 Y system/manager USER Tariq Karachi123   <---new pass

SQLT Usage Instructions

http://dbissues.blogspot.com/2016/02/sqlt-usage-instructions-doc-id-16141071.html

Please follow the below Document attached

All About the SQLT Diagnostic Tool (Doc ID 215187.1)

SQLT Usage Instructions (Doc ID 1614107.1)

How to Compile OJSP Page

http://dbissues.blogspot.com/2016/02/how-to-compile-ojsp-page.html

Command:

[oracle@---- bin]$ perl ojspCompile.pl --compile --flush -p 2

Result:

logfile set: /u01/oracle/PROD/apps/fs1/inst/apps/PROD_---/logs/appl/rgf/ojsp/ojspc_error.log
starting...(compiling all)
using 10i internal ojsp ver: 10.3.6.0
synchronizing dependency file:
  loading deplist...7829
  enumerating jsps...7829
  updating dependency...1150
  parsing jsp...1150 
  writing deplist...7829
initializing compilation:
  eliminating children...5954 (-1875)
translating and compiling:
  translating jsps...5954/5954 in 15m28s                 
  compiling jsps...5954/5954 in 13m50s                 
Finished!___________

How to change the apps user password in oracle apps 12.2.4

http://dbissues.blogspot.com/2016/02/how-to-change-apps-user-password-in.html

Below steps are to change the apps password in R12.2.4

1. Shut down the application tier services using the

$INST_TOP/admin/scripts/adstpall.sh

2. Change the APPLSYS password.

FNDCPASS apps/<existing apps passwd>  0 Y system/<system password> SYSTEM APPLSYS <new apps passwd>

FNDCPASS apps/apps 0 Y system/manager SYSTEM APPLSYS newpasswd

3. Start AdminServer using the $INST_TOP/admin/scripts/adadminsrvctl.sh
Note:Don't start any other application tier services.

4. Change the "apps" password in WLS Datasource as follows:
Log in to WLS Administration Console. (http:/krishna.appsdba.com:7002/console)

Click Lock & Edit in Change Center.
In the Domain Structure tree, expand Services, then select Data Sources.
On the “Summary of JDBC Data Sources” page, select EBSDataSource
On the “Settings for EBSDataSource” page, select the Connection Pool tab.
Enter the new password in the “Password” field.
Enter the new password in the “Confirm Password” field.
Click Save.

Check whether you are able to connect to db using apps
sqlplus apps/<newpassword> from application tier.

Before Starting all the services. Run Autoconfig.
cd $ADMIN_SCRIPTS_HOME
sh adautocfg.sh

Now start the services.
Start all the application tier services using the
$INST_TOP/admin/scripts/adstrtal.sh script.