Monday 24 March 2014

ORA-00245: control file backup failed; target is likely on a local file system

++++++++++++++++++++++++++++++++++++++++++++++
RMAN FULL BACKUP GOT FAILED WITH BELOW ERROR
+++++++++++++++++++++++++++++++++++++++++++++
channel ch09: backup set complete, elapsed time: 00:01:13
released channel: ch01
released channel: ch02
released channel: ch03
released channel: ch04
released channel: ch05
released channel: ch06
released channel: ch07
released channel: ch08
released channel: ch09
released channel: ch010
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03009: failure of backup command on ch08 channel at 03/14/2014 12:53:46
ORA-00245: control file backup failed; target is likely on a local file system


RMAN>
Recovery Manager complete.

Cause
++++++
Controlfile snapshot is on local file system .


Solution
++++++++
Controlfile snapshot must be on asm shared location.


RMAN> show all;
RMAN configuration parameters for database with db_unique_name ERPOLTP1 are:
CONFIGURE RETENTION POLICY TO REDUNDANCY 1; # default
CONFIGURE BACKUP OPTIMIZATION OFF; # default
CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default
CONFIGURE CONTROLFILE AUTOBACKUP OFF; # default
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%F'; # default
CONFIGURE DEVICE TYPE DISK PARALLELISM 4 BACKUP TYPE TO BACKUPSET;
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE MAXSETSIZE TO UNLIMITED; # default
CONFIGURE ENCRYPTION FOR DATABASE OFF; # default
CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default
CONFIGURE COMPRESSION ALGORITHM 'BASIC' AS OF RELEASE 'DEFAULT' OPTIMIZE FOR LOAD TRUE ; # default
CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default
CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/erpoltp1/oracle/11.2.0/scripts/rman/snapcf_erpoltp11.f';

RMAN> configure snapshot controlfile name to '+ERPOLTP1_DATA/snapcf_erpoltp11.f';
old RMAN configuration parameters:
CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/erpoltp1/oracle/11.2.0/scripts/rman/snapcf_erpoltp11.f';
new RMAN configuration parameters:
CONFIGURE SNAPSHOT CONTROLFILE NAME TO '+ERPOLTP1_DATA/snapcf_erpoltp11.f';
new RMAN configuration parameters are successfully stored

RMAN> show all;
RMAN configuration parameters for database with db_unique_name ERPOLTP1 are:
CONFIGURE RETENTION POLICY TO REDUNDANCY 1; # default
CONFIGURE BACKUP OPTIMIZATION OFF; # default
CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default
CONFIGURE CONTROLFILE AUTOBACKUP OFF; # default
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%F'; # default
CONFIGURE DEVICE TYPE DISK PARALLELISM 4 BACKUP TYPE TO BACKUPSET;
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE MAXSETSIZE TO UNLIMITED; # default
CONFIGURE ENCRYPTION FOR DATABASE OFF; # default
CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default
CONFIGURE COMPRESSION ALGORITHM 'BASIC' AS OF RELEASE 'DEFAULT' OPTIMIZE FOR LOAD TRUE ; # default
CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default
CONFIGURE SNAPSHOT CONTROLFILE NAME TO '+ERPOLTP1_DATA/snapcf_erpoltp11.f';
RMAN>


Fire full backup and test it.


Tuesday 18 March 2014

Default products

Default products
+++++++++++++

AD     ------Application dba
FND   ------Application Object Library
AU     -------Application Utilities
WF    --------Workflow
AK     --------Common Modules
FWK  --------Application FrameWork
XQ0   --------XML Publisher
ALR   --------App Oracle Alert

ERP EXTENSIONS

++++++++++++++
ERP EXTENSIONS
+++++++++++++++

.fmb   ==> Form Binary
.fmx   ==> Form Executable
.pll      ==>pl/sql library
.plx     ==>pl/sql executable
.pkb    ==>package body
.pkh    ==>package header
.pks    ==>package specification
.msb   ==>message binary
.msx   ==>message executable
.rdf    ==>report defination file
.rtf     ==>rich text file
.odf    ==>object description file
.req    ==>concurrent request logfile.
.out    ==>concurrent request out file
.mgr   ==>Manager
.gif     ==>Media file


Can we install 64 bit database on 32 bit operating system?

Answer is No.
We cannot install 64 bit oracle on 32 bit operating system .

+++++++++++++++++
I have tried it practically
++++++++++++++++

[oracle@localhost database]$ ./runInstaller


"You are attempting to install 64-bit Oracle on a 32-bit operating system.  This is not supported and will not work."

Wednesday 5 March 2014

JBOSS 7 Installation on Linux






In this tutorials, we are going to learn on how to install Jboss Application Server 7 on Linux(64-bit) platform.  The first step is to install the JDK. Download the JDK from here

Creating user and groups.
++++++++++++++++



Once you download JDK ,install JDK using below command.
gunzip -c /mnt/hgfs/weblogic software/jdk-7u45-linux-x64.gz | tar -xvf - &



The next step is to download the JBOSS AS 7 package from the following Link

Once downloaded: Extract the package
unzip /u01/jboss-as-7.1.1.Final.zip





Sunday 2 March 2014

*** ERROR : SSO Partner application could not be registered successfully.

+++++++++++++++++++++++++++++++++++++++
While registring sso is getting failed with below error
+++++++++++++++++++++++++++++++++++++++
BEGIN ORACLE HOME INSTANCE REGISTRATION:
Oracle Home Instance preferences stored successfully.
Oracle Home Instance registered successfully.
BEGIN SSO REGISTRATION:
Beginning to register partner application.
*** ERROR : SSO Partner application could not be registered successfully.
End of /ebstest1/erpapp/appl/fnd/12.0.0/patch/115/bin/txkSetSSOReg.pl : No Errors encountered

Cause
------
File contain production entries $IAS_ORACLE_HOME/Apache/Apache/iasobf remove it and try it again.

---------
Solution
---------
[apptest1@ctsst11 bin]$ grep -i ap1 iasobf
ORACLE_HOME=/ebsoltp1/erpapp/10.1.3
[apptest1@ctst11 bin]$

Note
++++
If you still face the same issue  register the sso with different name and might it resolve your issue.

vncserver: couldn't find "Xvnc" on your PATH.

When we run command for activating VNC server Service, we had this error messages,
bash-3.2$ vncserver
vncserver: couldn′t find ″Xvnc″ on your PATH.
Vncserver: couldn′t find ″xauth″on your PATH.
That Error is caused Solaris OS doesn’t put X11 and openwin path. Hence, we must insert path of X11 and openwin into PATH Environtment Variables.

Solution :
========
bash-3.2$ PATH=$PATH:/usr/X11/bin:/usr/openwin/bin
bash-3.2$ export PATH

bash-3.2$ vncserver
You will require a password to access your desktops.
Password:
New ′ctsst11:1 (apptest1)′ desktop is ctsst11:1
Creating default startup script /export/home/apptest1/.vnc/xstartup
Starting applications specified in /export/home/apptest1/.vnc/xstartup
Log file is /export/home/apptest1/.vnc/ctsst11:1.log

Saturday 1 March 2014

Password should contain minimum two embedded numbers


When trying to change the system password as part of the postclone activity getting below error.

SQL> show user
USER is "SYS"
SQL> alter user system identified by sys#2pswd;
alter user system identified by sys#2pswd
*
ERROR at line 1:
ORA-28003: password verification for the specified password failed
ORA-20005: Password should contain minimum two embedded numbers
SQL>


Check user profile
============
SQL> select USERNAME, PROFILE, ACCOUNT_STATUS from dba_users where username = 'SYSTEM';
USERNAME   PROFILE         ACCOUNT_STATUS
------------------    ------------------ --------------------------------
SYSTEM    USER_PROFILE  OPEN

SQL> select * from dba_profiles where profile='USER_PROFILE';

PROFILE RESOURCE_NAME RESOURCE LIMIT
------------------------------ -------------------------------- -------- ----------------------------------------
USER_PROFILE SESSIONS_PER_USER KERNEL DEFAULT
USER_PROFILE CPU_PER_SESSION KERNEL DEFAULT
USER_PROFILE CPU_PER_CALL KERNEL DEFAULT
USER_PROFILE LOGICAL_READS_PER_SESSION KERNEL DEFAULT
USER_PROFILE LOGICAL_READS_PER_CALL KERNEL DEFAULT
USER_PROFILE IDLE_TIME KERNEL DEFAULT
USER_PROFILE CONNECT_TIME KERNEL DEFAULT
USER_PROFILE PRIVATE_SGA KERNEL DEFAULT
USER_PROFILE FAILED_LOGIN_ATTEMPTS PASSWORD DEFAULT
USER_PROFILE PASSWORD_LIFE_TIME PASSWORD DEFAULT

PROFILE RESOURCE_NAME RESOURCE LIMIT
------------------------------ -------------------------------- -------- ----------------------------------------
USER_PROFILE PASSWORD_REUSE_TIME PASSWORD DEFAULT
USER_PROFILE PASSWORD_REUSE_MAX PASSWORD DEFAULT
USER_PROFILE PASSWORD_VERIFY_FUNCTION PASSWORD DEFAULT
USER_PROFILE PASSWORD_LOCK_TIME PASSWORD DEFAULT
USER_PROFILE PASSWORD_GRACE_TIME PASSWORD DEFAULT

Solution :
----------
Make the verification function to NULL and then try it.
SQL> alter profile USER_PROFILE limit password_verify_function NULL;
Profile altered.
SQL> alter user system identified by sys#2pswd;
User altered.

Once the password is changed make it to default...
SQL>alter profile USER_PROFILE limit password_verify_function DEFAULT;

java.sql.SQLException: Io exception: Invalid number format for port number

ISSUE
++++++
Getting below error while generating dbc file in oracle application 11i .


Generating /erpdev/erpapp/appl/fnd/11.5.0/secure/erpdev_erpdev.dbc
java.sql.SQLException: Io exception: The Network Adapter could not establish the connection
Database connection to jdbc:oracle:thin:@erpdev.oraganization.user.com:1603:erpdev failed
erpdev_erpdev.dbc generation failed with exit code 1
Updating Server Security Authentication
java.sql.SQLException: Io exception: Invalid number format for port number
Database connection to jdbc:oracle:thin:@host_name:port_number:database failed
Updating Server Security Authentication failed with exit code 1
adgendbc.sh exiting with status 1
ERRORCODE = 1 ERRORCODE_END



Soltion :
+++++++
Wrong domain name defined in xml file i.e change to user.com from oraganization.user.com.

Caused by: oracle.apps.jtf.base.resources.FrameworkException: ORA-01578: ORACLE data block corrupted

+++++
Issue
++++++
While doing sanity in oracle application gettting below error

Caused by: oracle.apps.jtf.base.resources.FrameworkException: ORA-01578: ORACLE data block corrupted (file # 378, block # 559510)
ORA-01110: data file 378: '+ERPTEST1_DATA/erptest1/datafile/apps_ts_tx_data.602.839483887'
ORA-26040: Data block was loaded using the NOLOGGING option

Solution :
--------
begin
apps.wf_local_synch.BULKSYNCHRONIZATION(P_ORIG_SYSTEM=>'ALL',
P_PARALLEL_PROCESSES=>2, P_LOGGING=>'LOGGING', P_RAISEERRORS=>TRUE,
P_TEMPTABLESPACE=>'APPS_TS_TX_IDX');
END;
/

ERROR - Invalid SQL*plus Version 8.0.6.0.0

When executing this script "PO_APPR_BUG.sql" ,it is failing with below error.

+++++++++++
        Issue
++++++++++++
ERROR - Invalid SQL*plus Version 8.0.6.0.0
ACTION - On databases using the UTF8 NLS characterset this test should not be
run using this
. SQL*plus Version. Please rerun this test using version 8.1.X of
SQL*plus or higher.
. Type Ctrl-C to exit the test.
PO_APPR_BUG.zip

+++++++++
Solution:
++++++++
Login to database as Oracle user and run that script,i think you tried executing it with applmgr user.

WARNING:NFS mount of file +ORA-19600: input file is control file


Issue
+++++
RMAN duplicate is failing with below error.

RMAN ERROR
=============
channel ch00: restoring control file
ORA-19625: error identifying file /erpoltp1/dbdata/backup/stage/_em_backup_/cf_D-ERPOLTP1_id-494164440_95kmfdq3_system01.dbf
ORA-27037: unable to obtain file status
SVR4 Error: 2: No such file or directory
Additional information: 3
ORA-19600: input file is control file (/erpoltp1/dbdata/backup/stage/_em_backup_/cf_D-ERPOLTP1_id-494164440_95kmfdq3_system01.dbf)
ORA-19601: output file is control file (/erptest1/dbdata/data1/cntrl01.dbf
failover to previous backup

Error in alert logfile
+++++++++++++++++++++++
WARNING:NFS mount of file /backup/rman/erpoltp1/cf/bk_utsosavab_s204732_p1_t835026251_bk on filesystem /backup/rman_0008 done with incorrect options
WARNING:Expected NFS mount options: rsize>=32768,wsize>=32768,hard,
WARNING:NFS mount of file /backup/rman/erpoltp1/cf/bk_utsosavab_s204732_p1_t835026251_bk on filesystem /backup/rman_0008 done with incorrect options
WARNING:Expected NFS mount options: rsize>=32768,wsize>=32768,hard,
WARNING:NFS mount of file /backup/rman/erpoltp1/cf/bk_utposauv5_s204729_p1_t835025893_bk on filesystem /backup/rman_0008 done with incorrect options
WARNING:Expected NFS mount options: rsize>=32768,wsize>=32768,hard,
WARNING:NFS mount of file /backup/rman/erpoltp1/cf/bk_utposauv5_s204729_p1_t835025893_bk on filesystem /backup/rman_0008 done with incorrect options
WARNING:Expected NFS mount options: rsize>=32768,wsize>=32768,hard,
WARNING:NFS mount of file /backup/rman/erpoltp1/db/ERPOLTP1_db_urnosaumm_s204663_p1_t835025622_db on filesystem /backup/rman_0008 done with incorrect options
WARNING:Expected NFS mount options: rsize>=32768,wsize>=32768,hard,
WARNING:NFS mount of file /backup/rman/erpoltp1/db/ERPOLTP1_db_unhoph7m2_s200433_p1_t832085698_db on filesystem /backup/rman_0008 done with incorrect options
WARNING:Expected NFS mount options: rsize>=32768,wsize>=32768,hard,

++++++++
SYMTOMS
++++++++
oratest@ctsst11 $ grep -i event initerptest1.ora
*.event='10298 trace name context forever, level 32'

*.event='4030 trace name heapdump level 25'

Solution :
+++++
Keep First event parameter in parameter file and remove the second one.