Oracle Management Cloud

Introduction to Oracle Management Cloud We have been seeing so many products of Oracle off late. A new suite from Oracle named Oracle Manage...

Thursday, April 4, 2013

Concurrent Program failed with Error ORA-20003: FAILURE: AppServ Notification for Profile

Issue:

In ASCP, Concurrent Program using utl_http package has failed with below error in the log file:


ORA-20003: FAILURE: AppServ Notification for Profile ID=461Failed Return value: <!DOCTYPE HTML PUBLIC "-//IETF//DTD HTML 2.0//EN">
<HTML><HEAD>
<TITLE


Cause:

Pval in sys_params under Demantra Schema (MDSEM in our case) table has wrong value for pname AppServerURL 

Verification:

SQL>  select pname,PVAL
  2  from msdem.sys_params
  3  where PNAME='AppServerURL';

PNAME         PVAL
------------  --------------------------------------------
AppServerURL  http://demuatapp01.xyz.com:7778/demantra_uat


Solution:

SQL> update msdem.sys_params
set pval='http://demuatapp01.xyz.com:7778/demantra_uat11' 
where pname='AppServerURL';

SQL> Commit;

Now restart demantra application services.




at No comments:
Labels: , ,

Collect Shipment and Booking History failed with ORA-24247: network access denied by access control list (ACL) error

Issue:

"Collect Shipment and Booking History" in ASCP completed with below errors in the log file:

ORA-29273: HTTP request failed
ORA-06512: at "SYS.UTL_HTTP", line 1722
ORA-24247: network access denied by access control list (ACL)

 Cause:

 Demantra schema in ASCP does not have "connect" grant on the network ACL.

Verification:
SYS-UAT> select * from dba_network_acls;

 HOST  LOWER_PORT UPPER_PORT ACL                        ACLID
----- ---------- ---------- -------------------------- -------------------------
*                           /sys/acls/OracleEBS.xml    71572A92FE0405D0B59100B2A

SYS-UAT> SELECT DECODE(DBMS_NETWORK_ACL_ADMIN.check_privilege('OracleEBS.xml', 'MSDEM', 'connect'),1, 'GRANTED', 0, 'DENIED', NULL) privilege FROM dual;

PRIVILE
-------

Solution:

Grant connect on ACL to demantra schema (MSDEM in this case)

BEGIN
DBMS_NETWORK_ACL_ADMIN.ADD_PRIVILEGE(acl=>'/sys/acls/OracleEBS.xml',
   principal => 'MSDEM',
   is_grant  => true,
   privilege => 'connect');
COMMIT;
END;
/

Verfication:

SYS-UAT> SELECT DECODE(DBMS_NETWORK_ACL_ADMIN.check_privilege('OracleEBS.xml', 'MSDEM', 'connect'),1, 'GRANTED', 0, 'DENIED', NULL) privilege FROM dual;

PRIVILE
-------
GRANTED

Now, rerun the program and it completes successfully without any issues.


at No comments:
Labels:

Thursday, March 21, 2013

Diagnostics not functioning in Oracle Applications after upgrading to 12.1.3


Issue:

After upgrading to R12, when user is following below navigation for diagnostics:

Help -> Diagnostics -> Examine

getting below error:

"Function Not Available for this responsibility. Change responsibilities or contact your system administrator"

Resolution:

 Beginning with Release 12.1.3, access to the above Diagnostics submenu items can be controlled by the profile Utilities:Diagnostics or by security functions using Role-Based Access Control (RBAC). Whether or not a submenu item is available is checked on an "as-needed" basis by the system when the user selects the submenu item. If the menu item is not available to the user, the message "Function not available to this responsibility. Change responsibilities or contact your System Administrator."

 To fix this error, set the following profile option to Yes at user level for the user to whom this is required.

Utilities:Diagnostics 

 After setting this profile to Yes, clear the cache and bounce Apache to reflect the same.
at No comments:
Labels: ,

Clear Cache in Oracle Apps R12 from backend (server).

Aim: How to clear cache in Oracle Apps R12 without logging into Applications.

Procedure:  Login to Middletier and use below commands.


$ cd $ADMIN_SCRIPTS_HOME
$ adapcctl.sh stop
$ find $LOG_HOME/ora/10.1.3 -name '*' -type f |xargs rm -f
$ adoacorectl.sh stop
$ adoacorectl.sh start
$ adapcctl.sh start



at No comments:
Labels: , ,

How to send mail using utl_mail from PL/SQL?

Aim: To send a mail using utl_mail from SQL.

Procedure:
$ cd $ORACLE_HOME/rdbms/admin
$ sqlplus '/as sysdba'

SQL> @utlmail.sql

 Package created.

 Synonym created.

 SQL> @prvtmail.plb

 Package created.

 Package body created.

 Grant succeeded.

 Package body created.

 No errors.
SQL> GRANT EXECUTE ON UTL_MAIL TO PUBLIC;

 Grant succeeded.

Test:
SQL> BEGIN
  2    EXECUTE IMMEDIATE 'ALTER SESSION SET smtp_out_server = ''mail.testhost.com''';
  3    UTL_MAIL.send(sender => 'vbadam@testhost.com',
  4                  recipients => 'veda.santosh@gmail.com',
  5                     subject => 'Test Mail',
  6                     message => 'Hello World',
  7                   mime_type => 'text; charset=us-ascii');
  8  END;
  9  /

 PL/SQL procedure successfully completed.



And a test mail is received at veda.santosh@gmail.com

at No comments:

Thursday, July 26, 2012

Autoconfig failed during bisdblrp.sql

Autoconfig failed during bisdblrp.sql



Issue: Found Ora-600 error in alert log while dropping a database link.

Error Message :
ORA-00600: internal error code, arguments: [16500], [kqdDBLinkUpdate], [3], [2], [EDW_APPS_TO_WH.WORLD], [], [], [], [], [], [], []

Current SQL from trace file:
drop database link EDW_APPS_TO_WH.WORLD;

Reason:
There are 2 database links in the database with same name.

SQL> select * from dba_db_links where db_link='EDW_APPS_TO_WH.WORLD';

APPS       EDW_APPS_TO_WH.WORLD    APPS    TEST   24-JUL-12
APPS       EDW_APPS_TO_WH.WORLD    APPS    TEST   25-JUL-12


Solution:
Drop the database links from SYS.LINK$ table using below command:

SQL> delete from sys.link$
 2  where NAME='EDW_APPS_TO_WH.WORLD';
at No comments:
Labels: , ,

Wednesday, May 16, 2012

Patch driver logfile has jdbc connection error

Issue:

adwork001.log has following errors:


Calling /d01apps/TS/10.1.3/appsutil/jdk/jre/bin/java ...
Exception in thread "main" java.sql.SQLException: The Network Adapter could not establish the connection
        at oracle.jdbc.driver.SQLStateMapping.newSQLException(SQLStateMapping.java:70)
        at oracle.jdbc.driver.DatabaseError.newSQLException(DatabaseError.java:133)
        at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:199)
        at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:480)
        at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:413)
        at oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:510)
        at oracle.jdbc.driver.T4CConnection.<init>(T4CConnection.java:203)
        at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:33)
        at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:510)
        at java.sql.DriverManager.getConnection(Unknown Source)
        at java.sql.DriverManager.getConnection(Unknown Source)
        at oracle.apps.ad.worker.AdJavaWorker.getAppsConnection(AdJavaWorker.java:1041)
        at oracle.apps.ad.worker.AdJavaWorker.main(AdJavaWorker.java:276)
Caused by: oracle.net.ns.NetException: The Network Adapter could not establish the connection
        at oracle.net.nt.ConnStrategy.execute(ConnStrategy.java:328)
Caused by: oracle.net.ns.NetException: The Network Adapter could not establish the connection
        at oracle.net.nt.ConnStrategy.execute(ConnStrategy.java:328)
        at oracle.net.resolver.AddrResolution.resolveAndExecute(AddrResolution.java:421)
        at oracle.net.ns.NSProtocol.establishConnection(NSProtocol.java:630)
        at oracle.net.ns.NSProtocol.connect(NSProtocol.java:206)
        at oracle.jdbc.driver.T4CConnection.connect(T4CConnection.java:966)
        at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:292)
        ... 8 more
Caused by: java.net.ConnectException: Connection refused
        at java.net.PlainSocketImpl.socketConnect(Native Method)
        at java.net.PlainSocketImpl.doConnect(PlainSocketImpl.java:352)
        at java.net.PlainSocketImpl.connectToAddress(PlainSocketImpl.java:214)
        at java.net.PlainSocketImpl.connect(PlainSocketImpl.java:201)
        at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:377)
        at java.net.Socket.connect(Socket.java:530)
        at oracle.net.nt.TcpNTAdapter.connect(TcpNTAdapter.java:120)
        at oracle.net.nt.ConnOption.connect(ConnOption.java:126)
        at oracle.net.nt.ConnStrategy.execute(ConnStrategy.java:306)
        ... 13 more

Cause:

jdbc connect string has wrong node entry. (Instead of DB hostname, the tnsentry has Apps tier hostname in the jdbc connect string)

Verification:

echo $APPS_JDBC_URL
verify "s_apps_jdbc_connect_descriptor" in $CONTEXT_FILE
Also verify, select node_name from fnd_nodes;

Solution:

If autoconfig is not run on DB Tier, bring down services, Run Autoconfig on DB Tier and then on APP Tier.
If Autoconfig is already ran on DB Tier, change the "s_apps_jdbc_connect_descriptor" parameter with connect DB host entry and run autoconfig in App node. Then resume the patch from where it stopped.

at No comments:
Labels: , ,
Subscribe to: Posts (Atom)

Most Viewed Posts