RMAN checksyntax worth using it

Yesterday I have started RMAN restore and recovery session of my 70 GB Oracle Apps 12.1.3 RAC database in the run block and went to sleep.

When I saw it in the morning, the script got terminated because of some syntax error in the run block. So the whole night has been wasted because of a simple syntax error.

I was checking for any tools in RMAN which can do a syntax check and fortunately I was able to locate the "checksyntax" command which is available from 10g onwards.

One of the powerful commands in RMAN which can be used to check the syntax of big rman scripts which runs for a long time, before start the script we can check the syntax of the script and run it without worrying of the termination of scripts with syntax errors.

Eg:

$ rman checksyntax

Recovery Manager: Release 10.2.0.5.0 - Production on Thu Dec 23 15:21:32 2010

Copyright (c) 1982, 2007, Oracle. All rights reserved.

RMAN>

RMAN> recover data;

RMAN-00571: ===========================================================

RMAN-00569: =======ERROR MESSAGE STACK FOLLOWS ===============

RMAN-00571: ===========================================================

RMAN-00558: error encountered while parsing input commands

RMAN-01009: syntax error: found "identifier": expecting one of: "copy, clone, database, datafile, datafilecopy, device, standby, tablespace"

RMAN-01008: the bad identifier was: data

RMAN-01007: at line 1 column 9 file: standard input

RMAN-00571: ===========================================================

RMAN-00569: ============ ERROR MESSAGE STACK FOLLOWS ===============

RMAN-00571: ===========================================================

RMAN-00558: error encountered while parsing input commands

RMAN-01009: syntax error: found ";": expecting one of: "allocate, alter, backup, beginline, blockrecover, catalog, change, connect, copy, convert, create, cross check, configure, duplicate, debug, delete, drop, exit, endinline, flashback, ho st, {, library, list, mount, open, print, quit, recover, register, release, replace, report, renormalize, reset, restore, resync, rman, run, rpctest, set, setlimit, sql, switch, spool, startup, shutdown, send, show, test, transport, upgrade , unregister, validate"

RMAN-01007: at line 1 column 13 file: standard input

RMAN>

RMAN> recover database

2> ;

The command has no syntax errors

500 Internal Server Error

In R12, when attempting to log in to EBS using HTTP://HOST.DOMAIN:PORT/
,the following error occurs.

ERROR500 Internal Server Errorjava.lang.NoClassDefFoundError atoracle.apps.fnd.sso.AppsLoginRedirect.AppsSetting(AppsLoginRedirect.java:126) atoracle.apps.fnd.sso.AppsLoginRedirect.init(AppsLoginRedirect.java:170) at com.evermind[OracleContainers for J2EE 10g (10.1.3.0.0)

The issue is caused by the following setup: Incorrect set-up of the Distributed Caching, port:12377 is not available.

To implement the solution, please execute the following steps:

Solution 1:
1. You can disable the use of "Distributed JVM cache" by disabling LONG_RUNNING_JVM- set oc4j.properties: ==> LONG_RUNNING_JVM= to "false"

Note: not usually recommended

Solution 2:

1. Assign an available port for "Distributed JVM cache" by using the following steps
a) Set the correct port in your Context File -> parameter "s_java_object_cache_port"
2. Run Autoconfig on all Middle Tiers
3. Make sure your System Profile "JTF_DIST_CACHE_PORT" has the same port specified
4. Retest the issue.

Oracle Universal Installer Fails with "Alert: Unable to create a new Oracle Home with name. An ORCA Oracle Home with this name already exists."

Any destination entered in the Oracle Universal Installer (OUI) returns the
error:

Error : Alert: Unable to create a new Oracle Home with name .
An ORCA Oracle Home with this name already exists.

This is because of bug Bug 2998836.
There is at least one entry in the 'oratab' file that starts with a '*' instead
of a SID. This causes the OUI loading ORCA homes from oratab to fail with a
misleading error.

As a workaround, modify the oratab file by commenting out the entries that begin
with "*" before running the installer, then return the entries to normal when
the installation is complete.
This defect is fixed in OUI 2.3 but it will not be available for Oracle Server
9.2.

When Applying a 11.5.10 Pre-req adpatch Fails With 'Aiprfp: Product 'Bs' Not In Release 'R115'

During the upgrade of Oracle Applications to 11.5.10 or 11.5.10 CU2 this error may occur:

AutoPatch error:
aiprfp: product 'bs' not in release 'R115'
Error running SQL and EXEC commands in parallel

This error is because BS product is no longer included 11.5.10 Apps version anymore, but BS product is still defined in the "topfile.txt" which is read by "adpatch".

To solve this please follow up the steps:
1. Make a backup of the file topfile.txt, under $APPL_TOP/admin
2. Take the line of "BS" out of the topfile.txt
3. Rerun the patch
4. Add the line for "BS" in topfile.txt

COMMON ERRORS ENCOUNTERED WHEN COMPILING FORMS WITH A "NON - ORACLE" user

1. Permission denied when running the forms executables
Cause: Non-oracle user does not have access to the ORACLE_HOME/bin/frm* executables
Solution: Allow access and execution of ORACLE_HOME/bin/frm*chmod +rx $ORACLE_HOMEchmod +rx $ORACLE_HOME/binchmod +rx $ORACLE_HOME/bin/frm*

2. Solaris: ld.so.1: frmcmp_batch: fatal: ORACLE_HOME/lib/libig.so.0: Permission deniedSUSE/Linux: error while loading shared libraries: libig.so.0: cannot open shared object file: No such file or directory
Cause: Non-oracle user does not have access to the libraries required by the compiler.
Solution: Allow read/execute access to ORACLE_HOME/libchmod -R +rx ORACLE_HOME/lib

3. Message file ORACLE_HOME/forms/mesg/fmcus.msb not found.
Cause: Forms is trying to display a message (error) but does not have access to the messages file.
Solution: Allow access to Forms messages files:chmod +rx ORACLE_HOME/formschmod -R +rx ORACLE_HOME/forms/mesg

4. FRM-91500: Unable to start/complete the build.
Cause: This error is generic but it may suggest that non-oracle user does not have access to the needed terminal file (.res) or that the environment is not correctly set.
Solution:a) Allow access to the terminal files:chmod -R +rx ORACLE_HOME/forms/admin
b) Edit frmcmp_batch.sh and addTERM=vt220export TERM
For additional troubleshooting of this specific error please check Note 756384.1 and Note 266731.1

5. FRM-91108: Internal Error: unable to initialize PL/SQL.
Cause: User does not have access to the timezone files
Solution: Allow access to "ORACLE_HOME/oracore/zoneinfo/timezlrg.dat"chmod +rx ORACLE_HOME/oracorechmod -R +rx ORACLE_HOME/oracore/zoneinfo

6. Error while trying to retrieve text for error ORA-12154
Cause: Forms is trying to display a message (non-forms error) but does not have access to the messages file.
Solution: Allow access to the RDBMS messages fileschmod +rx ORACLE_HOME/rdbmschmod -R +rx ORACLE_HOME/rdbms/mesg

7. ORA-12154: TNS:could not resolve the connect identifier specified
Cause: Forms executables cannot read the required ".ora" files required for making a successful DB connection.
Solution: Allow access to the "$ORACLE_HOME/network/admin/" folderchmod +rx ORACLE_HOME/network/chmod -R +rx ORACLE_HOME/network/admin/*

8. FRM-10043: Cannot open file. orFRM-10044: Cannot create file.
Cause: Incorrect access to the FMB specified
Solution: Check if all the folders contained in the "module" parameter are having "rx" right for other users.Also, check if the "non-oracle" user has "rwx" access to the FMB

9. FRM-30087: Unable to create form file $ORACLE_HOME/forms/test.fmx
Cause: Non-oracle user cannot write in the "output" directory or the mentioned fmx exists but user cannot overwrite it.
Solution: By default the FMX is being created in the same directory with the FMB.Give write permission in that folder and check if FMXs with the same name are already there and if the non-oracle user can overwrite them.Also, make use of the "output_file=" parameter within the compile command to specify a location (with correct access) where the FMX should be created.

Access to The Requested Uniform Resource Identifier (URI) Has Been Blocked by The Uniform Resource Locator (URL) Firewall

When attempting to create a bid as a supplier, the following error is encountered:
Access to the requested URI has been blocked by the URL Firewall
ERROR: Access to the requested URI has been blocked by the URL Firewall

This is because of the use of rewrite rules in the fw_url.conf file with the firewall.

to work around the problem, perform the following steps:

- Create a directory under $FND_TOP/admin/template called custom.
- Copy the url_fw.conf from $FND_TOP/admin/template/ to the custom directory
- Add your Custom rules in that file
- Run Autoconfig.
- Retest the issue.
- Migrate the solution as appropriate to other environments.

sqlplus does not connect as a non Oracle user

Users different than the owner of the installation (Oracle user is usually the owner) are not able to run SQL*Plus. The following error is thrown.

"SP2-0642: SQL*Plus internal error state 2165, context 4294967295:0:0Unable to proceed"

the reason is that sqlplus is unable to access required files. The error message is indicating following file is missing from install or inadequate permissions to access to the folder "oracore" under the $ORACLE_HOME.

To implement the work around, follow these steps:

1. Manually change the privileges for the $ORACLE_HOME/oracore directory and files.

cd to $ORACLE_HOME and type :

chmod -R 755 oracore

sqlplus will connect now.

Custom reports exit with APP:FND-362 error

Customized Reports exit with error

====================================
APP-FND-00362: Routine &ROUTINE cannot execute request &REQUEST for program &PROGRAM, because theenvironment variable &BASEPATH is not set for the application to which the concurrent program executable &EXECUTABLE belongs. Shut down the concurrent managers. Set the basepath environment variable for theapplication. Restart the concurrent managers.
====================================

Customized reports registered under the customization Application directory structure were created under APPL_TOP directory and then were copied into it or that the concurrent program definition was incorrect. Rather, the custom top under which this program was registered was not defined correctly. the value of custom application registration within apps (applications -> register) should be the same value as in the shell level.

To implement the solution, execute the following steps:

1. Define customization _TOP directory in your Applications environment file (e.g: CUST_TOP=".../cust/xx.x.x")

2. If step 1 is executed already, login to forms, select system administrator responsibility and navigate to applications -> register. query up the Custom application and change the value of it with the same name as in the shell level.

3. Bounce the concurrent Managers

Adrelink: Error: Product Library For Product "IZU" Not Found

When attempting to relink Applications programs using adadmin utility,the following error occurs.

=================================
adrelink: error: Product library for product "izu" not found."izu" might not be listed correctly in your SID_hostname.env file,you may be missing some files for product "izu",or "izu" could be an invalid product.adrelink will not try to link product "izu".Continuing work on other products...
adrelink is exiting with status 1
=================================

Adadmin during the relinking process of product IZU uses the 2 files: izufile.drv and izuRDA.drv. Theissue is caused by those 2 driver files for IZU products which use improper directory names; forsome files there is used "bin" directory instead of "scripts".adadmin is unable to find the following files in their directories when relinking:

$IZU_TOP/bin/rda.cmd
$IZU_TOP/bin/rda.pl
$IZU_TOP/bin/rda.sh

To implement the solution, please execute the following steps:

Note: The issue is resolved by upgrading to file izufile.drv and version 120.4.12000000.7 or higher and file izuRDA.drv and version 120.6.12000000.7 or higher.
1. Ensure that you have taken a backup of your environment,

2. Download and review the readme and pre-requisites for one of the following Patches
whenavailable for download fomr the MetalinkPatch 7294700 R12.IZU.A.DELTA.6 or Patch 6728000 ORACLE E-BUSINESS SUITE 12.0.6 RELEASE UPDATE PACK (RUP6)

3. Apply the patch in a test environment.

4. Confirm the following file versions:file izufile.drv and version 120.4.12000000.7 file izuRDA.drv and version 120.6.12000000.7
You can use the commands like the following:
strings $IZU_TOP/admin/driver/izufile.drv grep '$Header'
strings $IZU_TOP/admin/driver/izuRDA.drv grep '$Header'

The following workaround should help until the Patches are available for download:

1. backup file $IZU_TOP/admin/driver/izufile.drv and apply the following changes:

From:izu bin FNDFlexfieldDiag115.sh
izu bin sdf_core2.txt
To
izu script FNDFlexfieldDiag115.sh
izu script sdf_core2.txt

2. Please backup file $IZU_TOP/admin/driver/izuRDA.drv and apply the following changes:
a)From:izu bin rda.plTo:izu script rda.pl
b)From:izu bin rda.cmd
izu bin rda.sh

To:
izu script rda.cmd
izu script rda.sh

Save changes.

3. Relink all programs using adadmin after stopping all Applications tier services.

SQL suery to find out all errored requests

Use this SQL script to find out all the requests that ended in ERROR, TERMINATED or WARNING state.

===================================================
-- --------------------------------------------------
-- Author : New Generation Consultants
-- Script to find erroring requests
-- --------------------------------------------------
clear columns
set pages 23
set lines 500
col os form A6
col program head "Program Name" form A45 trunc
col shrtnm head "Shortname" format a13
col time head Elapsed form 9999.99
col request_id head "Req Id" form 9999999
col cprogid head "Prg Id" form 999999
col "Started On" format a10
col "Finished On" format a11
col "Submitted By" format a35 trunc
col argument_text head "Arguments" format a50 trunc
col statustxt head Status format a12 trunc
col phasetxt head Phase format a10 trunc
set recsep wrap
set verify off
select a.request_id
,c.concurrent_program_name shrtnm
,c.concurrent_program_id cprogid
,ctl.user_concurrent_program_name "program"
,l2.meaning phasetxt
,l1.meaning statustxt
--,to_char(a.actual_start_date,'hh:mi:ssAM') "Started On"
--,to_char(a.actual_completion_date,'hh:mi:ssAM') "Finished On"
,(nvl(actual_completion_date,sysdate)-actual_start_date)*1440 "Time"
--,a.argument_text
,u.user_name ' - ' u.description "Submitted By"
from fnd_Concurrent_requests a,fnd_concurrent_programs c,fnd_concurrent_programs_tl ctl
,fnd_user u,
(select l1.lookup_code,l1.meaning from fnd_lookup_values l1
where l1.lookup_type = 'CP_STATUS_CODE'
and l1.language = 'US'
and l1.enabled_flag = 'Y'
and (l1.start_date_active <= sysdate AND l1.start_date_active IS NOT NULL)
and (l1.end_date_active > sysdate or l1.end_date_active is null
and l1.meaning in ('Terminated','Warning','Cancelled','Error'))) l1,
(select l2.lookup_code,l2.meaning from fnd_lookup_values l2
where l2.lookup_type = 'CP_PHASE_CODE'
and l2.language = 'US'
and l2.enabled_flag = 'Y'
and (l2.start_date_active <= sysdate AND l2.start_date_active IS NOT NULL)
and (l2.end_date_active > sysdate or l2.end_date_active is null)
and l2.meaning = 'Completed')l2
where trunc(a.actual_start_date) = trunc(sysdate) and a.program_application_id = c.application_id
and a.concurrent_program_id = c.concurrent_program_id and ctl.application_id = c.application_id
and ctl.concurrent_program_id = c.concurrent_program_id
and l1.lookup_code = a.status_code
and l2.lookup_code = a.phase_code
and u.user_id = a.requested_by
order by actual_start_date
===================================================

Tips On Troubleshooting Java Exception Stack Traces

1) Collect Exception Details

NOTE: For OA Framework-based pages use FND Diagnostics and Apache logs. For others use any product-specific log files and Apache logs
Set Profile ‘FND: Diagnostics’ to ON. Reproduce the issue to get the Unexpected Exception page. Click the link in the text: "Click [here] for exception details." Save the whole page and review the Exception that starts with ‘### Detail 0 ###’ only.
Set FND Diagnostics Debug logging on (either to-page or to-file) and check the ouput. See Note 290614.1 -How To Get Log Files In iProcurement, for steps.
Get the Apache error_log and mod_jserv.log files and check for exceptions.

2) Analyze the Exception Stack Trace.
Use the following example to understand which parts are important and useful to determine areas to investigate, potential causes and solutions.

java.lang.NullPointerException at java.lang.String.(String.java:188) at oracle.apps.icx.por.domain.ReqCustom.validateGLAccount(ReqCustom.java:574) at oracle.apps.icx.por.domain.ReqDistribution.customValidateAccount(ReqDistribution.java:2579) at oracle.apps.icx.por.domain.ReqDistribution.validate(ReqDistribution.java:2653) at oracle.apps.icx.por.domain.ReqLine.validateReqDistribution(ReqLine.java:3948) at oracle.apps.icx.por.domain.Requisition.validateReqDistribution(Requisition.java:571) at oracle.apps.icx.por.apps.CreateReq.validateDistribution(CreateReq.java:144) at oracle.apps.icx.por.apps.CreateReq.requisitionAction(CreateReq.java:130) ...

Within this, the key parts to understand would be:
NullPointerException is the Java Error Type being raised.
java.lang.String. is the core (JDK) Java Method which is raising the above error.
validateGLAccount is the Oracle Method that is using the above core Java Method.
ReqCustom.java:574 is the Oracle Class File Name and Line Number that is making the call to the validateGLAccount method.
ReqDistribution.customValidateAccount is the Parent 'class.method' which is calling the above Method, and so forth down the list (child to parent).

3) Check for Similar Issues on Metalink:

Search on the functionality being used and the Java Error Type.
Search on first and second Oracle Class and Method names. Match any hits to the functionality and the failing Line Numbers.
Compare the file versions of any patches to those in the instance. Apply only those patches with later file versions, and on the same eBusiness Suite (eg. 11.5.10) and Procurement Family Pack (eg. FP.J) version. Always check the patch readme.txt for details.
Use background functionality, exception details and debug logfile hints information, to check instance setups and transaction data, as needed.

4) Understand the Common Java Exceptions

NullPointerException - Means a variable referred to in the code is not available (null). E.g. Profile Option may not be set.
NoClassDefFoundError / NoSuchMethodError / IllegalAccessError - Java code file is missing, or invalid reference is used.
OutOfMemoryException - The JVM cannot allocate more memory for use. Check server resources and AutoConfig and jserv.properties configuration.
ClassCastException / NumberFormatException - Incorrect conversion of a data type (e.g. Character to Number)
[StringArray]IndexOutOfBoundsException - Data being used exceeds the code structure being used for it. This commonly occurs from unexpected database results size.

These points can be used as a general guideline while facing java stack traces

Rapidwiz error while installing Applications Release12

When attempting to install Oracle Applications Release 12, the following error occurs during rapidwiz post-installation checks


ERROR LOGIN PAGE
-------------------------
checking URL = http://.:8000/OA_HTML/AppsLogin
RW-50016: Error: - {0} was not created:

Processing DriverFile = /stage/StageR12/startCD/Disk1/rapidwiz/template/adriapps.drv
Executing service control script:
/oracle/R12/inst/apps/TWO_oraclesvr05/admin/scripts/adoacorectl.sh start
ERROR : Timed out( 100000 ): Interrupted Exception
You are running adoacorectl.sh version 120.11


The issue is caused by a wrong setup in /etc/hosts file. The local host and server are setup in the same line in the hosts file.

To resolve this, backup the hosts file and make the following change.

127.0.0.1 localhost
'IP' 'host.domain' 'host'

Error while running adbldxml.pl after upgrading database to 11.1.0.7 from 10.2.0.2

The following error was encountered while running adbldxml.pl on the database tier to create the context file.


====================================================================
Could not Connect to the Database : ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
Linux Error: 2: No such file or directory

Connecting to the VISN11 database instance...

Connection paramaters values:
Database server hostname ==> NGLINUX05.NEWGEN.COM
Database listener port ==> 1542
Database SID ==> VISN11
Database schema name ==> apps

Could not Connect to the Database : ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
Linux Error: 2: No such file or directory


AC-40000: Error: Exception - java.sql.SQLException: ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
====================================================================


The problem was that the database was not registered with the listener.




SQL> show parameter local_listener;

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
local_listener string




The value for LOCAL_LISTENER is missing, so automatic instance registration is not taking place
We can correct this by setting the LOCAL_LISTENER parameter:


SQL> alter system set local_listener='(ADDRESS =(PROTOCOL=TCP)(HOST=host.domain.com)(PORT=port_number)(SID=sid_name)';

System altered.

SQL> alter system register;

System altered.


SQL> exit

Now adbldxml runs successfully.

Incorrect menu seeded with R12 causes error when iProcurement Catalog Administration is accessed

logging in to Oracle applications Release12 and selecting the iProcurement Catalog Administration responsibility immediately throws the following error

Error Page
You have encountered an unexpected error. Please contact the System Administrator for assistance.
Click here for exception details.

Clicking the link for more details delivers the following:
Exception Details.
oracle.apps.fnd.framework.OAException: oracle.jbo.InvalidDefNameException: JBO-25004: Definition name for type View Definition is invalid
at oracle.apps.fnd.framework.webui.OAPageErrorHandler.prepareException(OAPageErrorHandler.java:1247)
at oracle.apps.fnd.framework.webui.OAPageBean.renderDocument(OAPageBean.java:3111)
at oracle.apps.fnd.framework.webui.OAPageBean.renderDocument(OAPageBean.java:2908)
at _OA._jspService(_OA.java:232)
at com.orionserver.http.OrionHttpJspPage.service(OrionHttpJspPage.java:59)
at oracle.jsp.runtimev2.JspPageTable.service(JspPageTable.java:335)
at oracle.jsp.runtimev2.JspServlet.internalService(JspServlet.java:478)
at oracle.jsp.runtimev2.JspServlet.service(JspServlet.java:401)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:856)
at com.evermind.server.http.ServletRequestDispatcher.invoke(ServletRequestDispatcher.java:719)
at com.evermind.server.http.ServletRequestDispatcher.forwardInternal(ServletRequestDispatcher.java:376)
at com.evermind.server.http.ServletRequestDispatcher.unprivileged_forward(ServletRequestDispatcher.java:270)
at com.evermind.server.http.ServletRequestDispatcher.access$100(ServletRequestDispatcher.java:42)
at com.evermind.server.http.ServletRequestDispatcher$2.oc4jRun(ServletRequestDispatcher.java:204)
at oracle.oc4j.security.OC4JSecurity.doPrivileged(OC4JSecurity.java:283)
at com.evermind.server.http.ServletRequestDispatcher.forward(ServletRequestDispatcher.java:209)
at com.evermind.server.http.EvermindPageContext.forward(EvermindPageContext.java:322)
at _OA._jspService(_OA.java:225)


This happens in a fresh install of R12 because an incorrect menu comes seeded for in seeded for the iProcurement Catalog Administration responsibility. The following work around can be used for getting rid of the error.

- Login to the application as a user which has the System Administrator responsibility.

- Navigate to Security/Responsibility/Define

- Query the responsibility - iProcurement Catalog Administration
* The menu is 'Internet Procurement eContent Manager' - which is incorrect

- Change the menu name to - 'iProcurement Administration: Catalog Administration Home'

- Logout and then again login, the problem will be resolved.


It is better to clear the Web Browser cache to eliminate all errors and correct the problem completely.

OEM grid control 10.2.0.1 installation issue

While performing a full install of Oracle Enterprise manager 10.2.0.1, the 'product specific prerequisite checks' page shows an error for the following pacakes even if they are installed.

compat-libstdc++-296-2.96-132.7.2
libstdc++devel-3.4.3-22.1
openmotif-21-2.1.30-11

One can manually check the prerequisite pacakages for OEM using metalink note 343364.1 and safely ignore the installer warnings and continue for a successful installation.