Bhom Apps DBA || AWS || OCI

Error Occurred :– Trying to connect using SID as ServiceName.DomainName getConnectionUsingServiceName() –> JDBC URL: jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=oratest.tipl.com)(PORT=1532))(CONNECT_DATA=(SERVICE_NAME=TIR12.ticfg.com))) Exception occurred: java.sql.SQLException: The Network Adapter could not establish the connection Connection could not be obtained; returning null RC-00118: Error occurred during creation of database StackTrace: java.lang.Exception: Control file creation failed at oracle.apps.ad.clone.ApplyDatabase.<init>(ApplyDatabase.java:661) at oracle.apps.ad.clone.ApplyDatabase.<init>(ApplyDatabase.java:328) at oracle.apps.ad.clone.ApplyDatabase.<init>(ApplyDatabase.java:304) at oracle.apps.ad.clone.ApplyDBTier.<init>(ApplyDBTier.java:154) at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39) at sun.re...

This issue will solved only if yo will Install same version of openmotif as mentioned in Installation document. If you have higher version of rpm then its simply not going to workout. Required version of openmotif rpm – openmotif21-2.1.30-11.EL5.i386.rpm Actual version exists on system – openmotif22-2.2.3-18.EL5.i386.rpm If you do not want to Install the old version of rpm and want to access the forms using the same rpm “openmotif22-2.2.3-18.EL5.i386.rpm” then this is the post/article which you’re looking for : Form error message: Its looking for the library file “libXm.so.2” in /usr/lib which does not exists on the server. The rpm openmotif22-2.2.3-18.EL5.i386.rpm will deliver the higher version of library file then expected: [root@tir12vis Server]# cd /usr/lib [root@tir12vis lib]# ls -l libXm.so* lrwxrwxrwx 1 root root      14 Oct 19 11:31 libXm.so -> libXm.so.4.0.1 lrwxrwxrwx 1 root root      14 Oct 19 11:24 libXm.so.3 -> libXm....

I have applied Oracle E-Business Suite Applications Technology Release 12.1.3 (R12.ATG_PF.B.delta.3) in  the following steps Instance 12.1.1 Database version 11.2.0.7 OS OEL 5.8 Before Applying Oracle E-Business Suite Applications Technology Release 12.1.3 (R12.ATG_PF.B.delta.3) required to apply R12.AD.B.DELTA.3, Patch 9239089 unzip -o p9239089_R12.AD.B_R12_LINUX.zip As oracle user Copy adgrants.sql from this patch/admin directory to $ORACLE_HOME/appsutil/admin. $ sqlplus /nolog SQL>  @$ORACLE_HOME/appsutil/admin/adgrants.sql APPS Enable the maintenance mode adadmin defaultsfile=$APPL_TOP/admin/$TWO_TASK/adalldefautls.txt logfile=adadmin.log menu_option=ENABLE_MAINT_MODE workers=8 Apply patch 9239089 adpatch workers=8 defaultsfile=$APPL_TOP/admin/$TWO_TASK/adalldefaults.txt logfile=9239089.log patchtop=~/upgrade12.1.3/9239089 driver=u9239089.drv Apply patch 8919491  (Applications Technology Release 12.1.3) adpatch workers=8 defaultsfile=$APPL...

ORA-00449: background process ‘MMON’ unexpectedly terminated with error 448 Now we came to know that there is some problem with Guest user. So validate the Guest user. Connect sqlplus with apps user and run below query. SQL> select FND_WEB_SEC.VALIDATE_LOGIN(‘GUEST’,’ORACLE’) from dual; FND_WEB_SEC.VALIDATE_LOGIN(‘GUEST’,’ORACLE’) ——————————————————————————– N Note:-  The above Query should show Y but it shows N. So we need to check for the reason SQL> select fnd_message.get from dual; GET ——————————————————————————– Oracle error -449: ORA-00449: background process ‘MMON’ unexpectedly terminated with error 448 has been detected in FND_WEB_SEC.VALIDATE_LOGIN(u,p). SQL> Solution:- Restart DB and Listener and apps and check for the Validation of Guest user SQL> select FND_WEB_SEC.VALIDATE_LOGIN(‘GUEST’,’ORACLE’) from dual; FND_WEB_SEC.VALIDATE_LOGIN(‘GUEST’,’ORACLE’) ——————————————————————————– Y

Unable to generate forwarding URL. Exception: java.lang.RuntimeException: Guest user/pwd does not exist or match: GUEST/ORACLE  Now we came to know that there is some problem with Guest user. So validate the Guest user  Work Around Done. SQL> select FND_WEB_SEC.VALIDATE_LOGIN(‘GUEST’,’ORACLE’) from dual; FND_WEB_SEC.VALIDATE_LOGIN(‘GUEST’,’ORACLE’) ——————————————————————————– N The above Query should show Y but it shows N. So we need to check for the reason SQL> select fnd_message.get from dual; GET ——————————————————————————– Oracle error -449: ORA-00449: background process ‘MMON’ unexpectedly terminated with error 448 has been detected in FND_WEB_SEC.VALIDATE_LOGIN(u,p). So the above error states that there was Abnormal termination happened by MMON.  Solution: Restart DB and Listener and apps and check for the Validation of Guest user SQL> select FND_WEB_SEC.VALIDATE_LOGIN(‘GUEST’,’ORACLE’) from dual; FND_WEB_SEC.VALIDATE_LOGIN(‘GUEST’,’ORACLE’) —...

Error :- SQL> drop user TAPROD cascade; drop user TAPROD cascade * ERROR at line 1: ORA-01940: cannot drop a user that is currently connected SQL> Solution :- Make sure the user is logged out, then re-execute the command. If you are permitted to kill the session of that user then find out the connected user sid and serial# by SQL> select s.sid, s.serial#, s.status, p.spid from v$session s, v$process p where s.username = ‘User_Name’ and p.addr (+) = s.paddr SID    SERIAL# STATUS   SPID ———- ———- ——– ———————— 221         45 ACTIVE   25372 235          3 ACTIVE   25374 NOTE:    Before killing session you may wish to lock the account for further connection attempts. This is extremely necessary to drop users who automatically establish session like to drop an application user or to drop a user who performs batch jobs. SQL> Alt...

Scenario: ======== We have Installed the Oracle Application Server Release 2 on new machine and while starting opmn we get the following error: Error : ====== Solution: ======== Switch to root user and run Below command. Now Retest the issue : =====================

How to set 32 bit emulation mode in linux 64bit. During oracle application server IAs 10g (32 bit) installation got below error because we tried in 64 bit OS. Now we need to change the current terminal session environment to 32 bit OS by using ” linux32 bash” command. Error: Solution: [oracle@gbpd2k Disk1]$ linux32 bash [oracle@gbpd2k Disk1]$./runInstaller

If you are not able to remove oracle from the above workaround. Please follow below steps to remove OracleServiceXE. Solution:– Try to delete the service using the command prompt: Click Start, type ‘cmd’ in the search field, and when ‘cmd’ shows up in the list of options, right click it and select ‘Run as Administrator’. At the Command Prompt window, type “sc delete OracleServiceXE” without the quotes and press Enter. Type “Exit” and press Enter. Hope it helps. C:\> sc stop OracleServiceXE                      (to Stop service) C:\> sc delete OracleServiceXE                      (to remove)

Description:- Recently I met the above issue while performing Oracle Applications Cloning for Release 11i environment on Red Hat Enterprise 5.8 64-bit O.S. perl adcfgclone.pl appsTier Enter the APPS password [APPS]: ERROR : Unable to set CLASSPATH /applprod/prodcomn/clone/bin/../jlib/classes111.zip: is  missing First Creating a new context file for the cloned system. The program is going to ask you for information about the new system: Error: can’t find libjava.so. ERROR: context creation not completed successfully. Please check /tmp/adcfgclone_29265.err file for errors Cause:– The first error indicates, that the file ‘Classes111.zip’ is missed. Solution:– To implement the solution, please execute the following steps : 1. Copy from $iAS_TOP/portal30/admin/plsql/lib/classes111.zip to $COMMON_TOP/clone/jlib/classes111.zip : Workaround:– [root@oratestdb bin]# cd /applprod/prodora/iAS/portal30/admin/plsql/lib/ [root@oratestdb lib]# ls classes111.zip cla...

Error:– Checking for make…    found – /usr/bin/make Checking for ld…     found – /usr/bin/ld Checking for cc…     found – /usr/bin/cc Checking for ar…     found – /usr/bin/ar Checking for ksh… Unable to find ‘kshell’ in path Unable to locate all utilities with system path. PATH = /usr/lib64/qt-3.3/bin:/usr/kerberos/bin:/usr/local/bin:/bin:/usr/bin:/home/oracle/bin WARNING: Could not find all the required OS utilities in the $PATH. Please review the checks above Solution: before running/execute adcfgclone.pl script export the following command $ export KSH_VERSION=’@(#)PD KSH v5.2.14 99/07/13.2′ check metalink note: 451994.1 for more details.

Query to check TEMP Table-space Size, Used Space. SELECT d.status “Status”, d.tablespace_name “Name”, d.contents “Type”, d.extent_management”ExtManag”, TO_CHAR(NVL(a.bytes / 1024 / 1024, 0),’99,999,990.900′) “Size (M)”, TO_CHAR(NVL(t.bytes, 0)/1024/1024,’99999,999.999′) ||’/’||TO_CHAR(NVL(a.bytes/1024/1024, 0),’99999,999.999′) “Used (M)”, TO_CHAR(NVL(t.bytes / a.bytes * 100, 0), ‘990.00’) “Used %” FROM sys.dba_tablespaces d, (select tablespace_name, sum(bytes) bytes from dba_temp_files group by tablespace_name) a, (select tablespace_name, sum(bytes_cached) bytes from v$temp_extent_pool group by tablespace_name) t WHERE d.tablespace_name = a.tablespace_name(+) AND d.tablespace_name = t.tablespace_name(+) AND d.extent_management like ‘LOCAL’ AND d.contents like ‘TEMPORARY’; Query to get DATAFILE Location & Details of TEMP Tablespace. select tablespace_name,file_name,bytes/1024/1024 Total_Size,maxbytes/1024/1024 Max_Space,autoextensible from dba_temp_files  order by file_n...

Step to re-create TEMP table-space. 1.Create a new TEMP table-space name TEMP2. SQL> CREATE TEMPORARY TABLESPACE TEMP2 TEMPFILE  ‘/oradata/TAREPOS/TAREPOS/temp2_01.dbf’ SIZE 1024M AUTOEXTEND OFF EXTENT MANAGEMENT LOCAL UNIFORM SIZE 1M; Tablespace created. SQL> 2. Set new table-space TEMP2 as DEFAULT table-space. SQL> ALTER DATABASE DEFAULT TEMPORARY TABLESPACE temp2; Database altered. SQL> 3. Drop table-space TEMP and all its content & data-files. SQL> DROP TABLESPACE temp INCLUDING CONTENTS AND DATAFILES; Tablespace dropped. SQL> 4. Re-create TEMP table-space. SQL> CREATE TEMPORARY TABLESPACE TEMP TEMPFILE ‘/oradata/TAREPOS/TAREPOS/temp01.dbf’ SIZE 4096M AUTOEXTEND OFF EXTENT MANAGEMENT LOCAL UNIFORM SIZE 1M; Tablespace created. SQL> 5. Set new table-space TEMP as DEFAULT table-space. SQL> ALTER DATABASE DEFAULT TEMPORARY TABLESPACE temp; Database altered. SQL> 6. Drop table-space TEMP2 and all its content & data-files....

How to create DB Link. First delete the DB Link if it is already there. sql:>/ drop database link “Database_link_name” To create the Database link. create  database link “DBLINK_NAME” connect to “User_Name” identified by “Passwrod” using ‘(DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (COMMUNITY = tcp.world) (PROTOCOL = TCP) (Host = “Host_name or IP Address”) (Port = “DB_Port”))) (CONNECT_DATA = (SID = “DB_SID”)) )’;

Comparison Between Apps 11i and Release12 In this document we will compare TOPS in apps 11i and release12. Let’s have a look at the technology stack using both release 11i and 12. Oracle ebusiness-suite release 12 technology stack Database : Database Version using in 11i (11.5.9 & 11.5.10) was 9i where in  Release 12 it is 10g R2 (10.2.0.2) and for Release12.1.2 it is using database 11.1.0.7 Application Tier: Tech Stack in Application Tier consist of iAS(1.0.2.2.2) & Developer 6i (Forms & Reports 8.0.6) but in Applications R12 it is built on Fusion Middleware (10g Web Server and 10g Forms & Reports) Sub component in Application Tier: HTTP Server or Web Server in R12 is Version 10.1.3 which is built on Apache version 1.3.34. In apps 11i it is Version 1.0.2.2.2 built on Apache Version 1.3.19 Jserv in apps 11i is replaced by OC4J (mod_jserv is replaced by mod_oc4j) Forms Version 6i in Apps 11i is replaced by Forms 10.1.2.0.2 in R12 Reports Ve...

Usage of FNDCPASS Utility FNDCPASS <APPS username>/<APPS password> 0 Y <SYSTEM username>/<SYSTEM password> <token> <username> <new password> Following are the FNDCPASS Utility options that could be used with different <token>. Change the APPS and APPLSYS schema password The SYSTEM token is used when changing the APPLSYS password. FNDCPASS <logon> 0 Y <system/password> SYSTEM <username> <new password> FNDCPASS apps/apps 0 Y system/manager SYSTEM APPLSYS WELCOME Change an Oracle Applications schema password (other than APPS/APPLSYS) The ORACLE token is used when changing a SINGLE Applications schema password. FNDCPASS <logon> 0 Y <system/password> ORACLE <username> <new password> FNDCPASS apps/apps 0 Y system/manager ORACLE GL GL1 Change all ORACLE schema passwords The ALLORACLE token is used when changing ALL Applications schema passwords. FNDCPASS <logon> 0 Y <sys...

Query to check Table-space Size, Free Space ,Used Space. Select t.tablespace, t.totalspace as ” Totalspace(MB)”, round((t.totalspace-fs.freespace),2) as “Used Space(MB)”, fs.freespace as “Freespace(MB)”, round(((t.totalspace-fs.freespace)/t.totalspace)*100,2) as “% Used”, round((fs.freespace/t.totalspace)*100,2) as “% Free” from (select round(sum(d.bytes)/(1024*1024)) as totalspace, d.tablespace_name tablespace from dba_data_files d group by d.tablespace_name) t, (select round(sum(f.bytes)/(1024*1024)) as freespace, f.tablespace_name tablespace from dba_free_space f group by f.tablespace_name) fs where t.tablespace=fs.tablespace order by t.tablespace;

  DBA / Apps DBA Activities Normally as DBA/Apps DBA, activities to be performed: –  Installing and upgrading the Oracle server and application tools. Managing Multiple Instances like Development, Test, UAT and Production including RAC, Stand by Instances, Application Servers etc. Allocating system storage and planning future storage requirements for the database system. Creating primary database storage structures (table spaces) after application developers have designed an application. Creating primary objects (tables, views, indexes) once application developers have designed an application. Modifying the database structure mainly in customized programs, as necessary from information given by application developers. Enrolling users and maintaining system security. Ensuring compliance with our Oracle license agreement. Controlling and monitoring user access to the database. Monitoring and optimizing the performance of the database. Planning growth and changes (...

Error:- Error: failed /usr/jdk1.7.0_80/jre/lib/i386/server/libjvm.so, because /usr/jdk1.7.0_80/jre/lib/i386/server/libjvm.so: cannot restore segment prot after reloc: Permission denied   Cause:-  SELinux is installed and enabled in the OS.   Solution :- Temporarily disable SELinux by running this command in the terminal: /usr/sbin/setenforce 0 Restart Confluence To re-enable SELinux, run this: /usr/sbin/setenforce 1

Error:- Executing command: /u01/stage/122_stage/startCD/Disk1/rapidwiz/jre/Linux_x64/1.6.0/bin/java -cp /u01/oracle/app/fs2/inst/apps/ORCL_cch1utparexel1/temp/ASInstallHome/fnd/ ../j11067592_fnd.zip:/u01/oracle/app/fs2/inst/apps/ORCL_cch1utparexel1/temp/ ASInstallHome/fnd/java/3rdparty/stdalone/xmlparserv2.zip -Doracle.apps.fnd.txk.env_home=/u01/oracle/app/fs2/EBSapps/appl/admin/ ORCL_cch1utparexel1/-Doracle.apps.fnd.txk.runtime.config= /u01/oracle/app/fs2/inst/apps/ORCL_cch1utparexel1/temp/ xmldocs/instToolPatches.xml oracle.apps.fnd.txk.config.InstallService Fatal Error: TXK Install Service oracle.apps.fnd.txk.config.ProcessStateException: FileSys OS COMMAND Failed : Exit=2 See log for details.  CMD= make -f ins_forms.mk sharedlib install  ## Node=NodeId=1003 Type=24 TypeName=filesys_patch_action Name= RefId=457 State=init ConfigDoc=APPS_C_HOME ParentDoc=null Topology=R12 Action=os_cmd at oracle.apps.fnd.txk.config.FileSysPatchActionNode.doFileSysOSCmd (FileSy...