How to Check Database Character Set (PLSQL Query)

http://dbissues.blogspot.com/2016/11/how-to-check-character-set-query-in.html

select * from v$nls_parameters where parameter like '%CHARACTERSET%';

select * from NLS_DATABASE_PARAMETERS ;

INS-32011: The string that you have specified contains the space character.

http://dbissues.blogspot.com/2016/10/ins-32011-string-that-you-have.html

INS-32011: The string that you have specified contains the space character.

Cause: The string you entered contains the space character.

Action: Please choose a string containing only alphanumeric, and a few additional characters that are allowed for your platform.

Remove Spaces from Path if any.

[INS-13001] Environment does not meet minimum requirements error." appears. How can I prevent it from appearing?

http://dbissues.blogspot.com/2016/10/ins-13001-environment-does-not-meet.html

Question

When installing the Oracle 11g 32-bit client on a Microsoft Windows 2012 Server R2 64-bit server, a dialog box displaying "[INS-13001] Environment does not meet minimum requirements error." appears. How can I prevent it from appearing?

Answer

To prevent this dialog box from appearing, do the following:

1. Right click on the setup.exe for the Oracle 11g 32-bit client, and select Properties.
2. Select the Compatibility tab, and set the Compatibility mode to Windows 7.
3. Click OK to close the Properties tab.
4. Double click setup.exe to install the client.

The following document is for handling printer issue in linux/unix. (How to Cancel Print Requests from Oracle)

http://dbissues.blogspot.com/2016/10/how-to-cancel-all-prints-from-all.html

1:) The following command will delete single request .
cancel queuename

2:) The following command will provide u the list of all and current and old process.
lpstat

3:) The following command will provide You the list of printer with name.
lpstat (printername)

4:) You can cancel only jobs owned by you, or by an specified user (provided that you have the rights to do it).
cancel -u user

5:) The following command will cancel all job related to any printer .
cancel -a

How to Restart Printer Services in Oracle

http://dbissues.blogspot.com/2016/08/how-to-restart-printer-services-in.html

Connect to root from Database

su - root
Pwd:
service cups restart


exit
exit

Excel application doesn't exist under Option tab

http://dbissues.blogspot.com/2016/06/excel-application-doesnt-exist-under.html

Try renaming your localstore.rdf mimetypes.rdf file in your profile folder. Note that this will reset your application preferences.

Go to your troubleshooting page in Firefox: 

1. Enter about:support in the address bar, or go to Help (or > ) > Troubleshooting Information
2. Click the "Show Folder" button
3. See Profiles - Where Firefox stores your bookmarks, passwords and other user data for more information

This should open your profile folder in Windows Explorer. Close Firefox and then rename the localstore.rdf mimetypes.rdf file to something else, such as localstore.old mimetypes.old . Start Firefox again and it will create a new localstore.rdf - try opening an Excel file in Firefox now. If it works properly, you can remove the localstore.old mimetypes.old or whatever you renamed the file as.

How to save file, ask to open or Use default to Open in Mozilla Firefox

http://dbissues.blogspot.com/2016/06/how-to-save-file-ask-to-open-or-use.html

Win Word

Excel

PDF

The Java Runtime Enviroment cannot be loaded from****************************jvm.dll

Running Oracle Forms on WEB

Error: \bin\hotspot\jvm.dll error message during install process

This article applies to:
Platform(s): Windows 10, Windows 7, Windows 8, Windows Vista, Windows XP
Java version(s): 7.0, 8.0SYMPTOMS

During Java installation process, you get this error:

Java Runtime Environment cannot be loaded from /bin/hotspot/jvm.dll

---

CAUSE

The problem could be either caused by corrupted registry keys or incomplete installation.

SOLUTION


Delete the deployment.properties file

The deployment.properties file is usually located in: “C:\Documents and Settings\\Application Data\Sun\Java\Deployment” (where username is your login name) directory. The installation process will create a new deployment.properties file.

To remove the deployment.properties file, follow these steps:
1. Click on Start > My Computer
2. Go to “\Documents and Settings” directory
3. Go to username sub-directory (username is your computer login name )
4. Go to Application Data\Sun\Java\Deployment directory
5. Delete the deployment.properties file
6. Run the installation process again

How to Install JInitiator for Windows and Vista 7

Please follow the below Document 

file:///C:/Users/iacs.consultant/Downloads/Installing%20Oracle%20JInitiator%20for%20Windows%20Vista.pdf

How to directly download Output’s from Google Chrome without opening

http://dbissues.blogspot.com/2016/06/how-to-directly-download-outputs-from.html

Download Extension Force PDF Download from the below URL

https://chrome.google.com/webstore/search/Force%20PDF%20Download?hl=en-US&_category=extensions

https://chrome.google.com/webstore/search/Force%20PDF%20Download?hl=en-US&_category=extensions

How to Open Oracle Application on Google Chrome

Please Download it from the below URL

https://drive.google.com/open?id=0B30-kT1pIOm_Z1R1REFPbjhaUkE

How do I enable Java in my web browser?

This article applies to:

• Platform(s): Macintosh OS X, Windows 10, Windows 7, Windows 8, Windows Vista, Windows XP

---

SYMPTOMS

Even after installing Java, Applets do not run.

---

CAUSE

Java is not enabled in the web browser. If Java is already installed but applets do not work, you need to enable Java through your web browser.

---

SOLUTION

If you recently installed Java, you may need to restart your browser (close all browser windows and re-open), in order for the browser to recognize the installation. In addition, make sure Java content in the browser is enabled through the Java Control Panel.

Follow these instructions to enable Java though your Web browser.

Internet Explorer

1. Click Tools and then Internet Options
2. Select the Security tab, and select the Custom Level button
3. Scroll down to Scripting of Java applets
4. Make sure the Enable radio button is checked
5. Click OK to save your preference

Chrome

Chrome browser versions 42 and above. Starting with Chrome version 42 (released April 2015), Chrome has disabled the standard way in which browsers support plugins. More info

Firefox

1. Open the Firefox browser or restart it, if it is already running
2. From the Firefox menu, select Tools, then click the Add-ons option
3. In the Add-ons Manager window, select Plugins
4. Click Java (TM) Platform plugin (Windows) or Java Applet Plug-in (Mac OS X) to select it
5. Check that the option selected is Ask to Activate or Always Activate or on older Firefox versions, click on the Enable button (if the button says Disable, Java is already enabled)

Safari

1. Click on Safari and select Preferences
2. Choose the Security option
3. Select Allow Plug-ins, then click on Manage Website Settings
4. Click on the Java item, select an option (Ask, Allow or Allow Always) from the pulldown list When visiting other websites
5. Click Done, then close the Safari Preferences window

Safari Help

» Safari 6.1 and later plug-in information (support.apple.com)
» Safari 8 plug-in info (help.apple.com)
» Safari 9 plug-in info (help.apple.com)

Opera 4.x and Up

1. Opera for Windows does not use Java, but an embedded version already inside the Opera Web browser.
2. Opera for other platforms may supports Java . Please consult your Opera platform documentation.
3. For further information, please review the following Opera Support article:
   Support for Java software in Opera

How to run Oracle Application on Mozilla Firefox

http://dbissues.blogspot.com/2016/05/please-download-it-from-below-url.html

Please download it from the below URL

https://drive.google.com/open?id=0B30-kT1pIOm_MGh2NnAxeGhfYm8

FRM-40039:Cannot attach library***********while opening form ***********

http://dbissues.blogspot.com/2016/05/frm-40039cannot-attach-librarywhile.html

Error: Cannot attach library

Solution: Open default.env file and add path

Preference in APPS Start Page. "How to Directly Access any Function after Login"

http://dbissues.blogspot.com/2016/05/preference-in-apps-start-page-how-to.html

"Applications Start Page" feature provides a user an option to set a particular page as his/her preferred start. The user will be taken to this page at login.


A user can choose from the set of functions available under his/her responsibilities. The value is recorded in a profile option named "Applications Start Page (APPLICATIONS_START_PAGE)" as
"functionId$$respId$$appId".


Usage of the Feature

Make sure the profile "Self Service Personal Home Page Mode" is set to "Framework only" at site level or at user level for which user you intend to provide "Applications Start Page" feature

Login to Applications as the End user

Navigate to Preferences link on top of the page.

You can find a section "Start Page" under General Preferences page. Select the Responsibility from which you would like to choose the Function (For e.g. Payables Super User). It then lists the functions available for this user under this responsibility. Choose the Function as Start page (e.g, Invoices). Apply the changes.

Logout and Log back in. Your Start Page is now effective.

After personalizing the 'start page' to directly open a Form, how do I reset the User Preferences and the start page?

Disabling the Feature

When you are on Self-service Framework page, you can Navigate to Preferences Link and de-select the values (choose blank) for Responsibility and Page drop down lists.

When you are in Forms based Applications, navigate to menu Edit => Preferences => Profile

Search for "Applications Start Page", remove the value from User Value field and Save.

Next time when you login to Applications, you get Self-service Framework Homepage.

OR

After logging in, replace the login link with:
http://<initial part of path>/OA_HTML/OA.jsp?OAFunc=OAHOMEPAGE

This should get you to the Personal Home Page.

OR

Either use the Responsibility Hat to change to the System Administrator responsibility or Login as another user and have them use the System Administrator responsibility.

Then do a find for the Start Page profile option: Profile > System for the User Name that is needing to reset their 'Start Page' profile.

Delete the start page for the user, save the changes. This will allow the user to get back to the Personal Home Page, and then they can reset their 'Start Page'.

How to Revert My Start Page?

You have set the start page in Oracle Applications. On each successful login, it will brings you to the page. Now, you change your mind, you want to either disable the start page or change to other page. You could not get back to the HTML Preferences screen, as the start page will bring you directly to the specific Oracle form.

Ans: At any responsibilities, navigate Edit -> Preferences -> Profiles, query Profile Name "Applications Start page", change or remove the "User Value".

How to copy data from Database into .txt file

http://dbissues.blogspot.com/2016/05/how-to-copy-data-from-database-to-txt.html

ls -alrt > filename.txt

cat filename.txt

FRM-30187: Size of CHAR column in record group must be between 1 and 2000. Record Group AR_CUSTOMER1

http://dbissues.blogspot.com/2016/05/frm-30187-size-of-char-column-in-record.html

Error:

FRM-30187: Size of CHAR column in record group must be between 1 and 2000.
Record Group AR_CUSTOMER1

Solution:

Go to the property fo RECORDGROUP named AR_CUSTOMER1 and there is one property called Column Specification there is one columns will be having length greater then 2000 there set it to 2000 which is maximum value. Then it will work.

Copy data from one column to another in oracle table

http://dbissues.blogspot.com/2016/03/copy-data-from-one-column-to-another-in.html

create table abc

(Num VARCHAR2 (10),

Address varchar2 (10));

select * from abc

for update

insert into abc

values (2,null);

update abc set ADDRESS = NUM;

How to Upgrade java plugin in EBS Enviroment

http://dbissues.blogspot.com/2016/03/how-to-upgrade-java-plugin-in-ebs.html

IF you want to upgrade java plugin in ebs environment for running ebs on windows browser.

1:) Downlaod jre plugins  from (Deploying JRE (Native Plug-in) for Windows Clients in Oracle 
      E-Business Suite Release 12 (Doc ID 393931.1)

2:) Download your choice jre plugins from the above document. In my case I have downloaded  
      this jre-->>>  p16534039_160450_WINNT.zip

3:) Run application enviroment and down apps from $ADMIN_SCRIPT_HOME 
      adstpall.sh  <--- run      this script to down apps.

4:) Unzip the jre patch which you have downloded from the above document in step 1. from
      the following command.
      ----   unzip -o p16534039_160450_WINNT.zip  

5:) After unzip you see that it provide both JRE and JDK. But you have to set jre.
      jdk-6u45-windows-i586.exe  
      jre-6u45-windows-i586.exe

6:) Then move the (jre-6u45-windows-i586.exe) from the patch to the following location
      -->>/u01/oracle/PROD/apps/fs1/EBSapps/comn/webapps/oacore/util/javaplugin/??

7:) Then rename jre-6u45-windows-i586.exe like this j2se16045.exe.

8:)  Run apps env  then execute $FND_TOP/bin/txkSetPlugin.sh script against the web node of
       the application tier.
       $ txkSetPlugin.sh jversion [clsid_param] <--- In this classid means 16045 which is the id of  
        jre-6u45-windows-i586.exe.
       LIKE this --->>>>   ./txkSetPlugin.sh 16045


9:) Run application from  $ADMIN_SCRIPT_HOME adstrtall <--

APP-SQLAP-10771: could not reserve record

http://dbissues.blogspot.com/2016/02/app-sqlap-10771-could-not-reserve-record.html

R12: Unable to update an Invoice in Invoice Entry form (APXINWKB): APP-SQLAP-10771: could not reserve record.

ERROR

APP-SQLAP-10771: Could not reserve record

Got this error when trying to pay Full Invoice. This error comes normally due to database lock from another sessions on AP_INVOICES_ALL, AP_INVOICE_LINES_ALL, AP_INVOICE_DISTRIBUTIONS_ALL tables.

SOLUTION 

Step 1. First determine what session has lock this record, please execute the following steps:

a) Run the following to query to determine which tables are locked:

SELECT a.object_id, a.session_id, substr(b.object_name, 1, 40) FROM v$locked_object a, dba_objects b WHERE a.object_id = b.object_id AND b.object_name like ‘AP_%’ ORDER BY b.object_name;

b) Look at the results and run the below given Query by inserting that is returned from above script :

SELECT l.*, o.owner object_owner, o.object_name FROM SYS.all_objects o, v$lock l WHERE l.TYPE = ‘TM’ AND o.object_id = l.id1 AND o.object_name in (‘AP_INVOICES_ALL’, ‘AP_INVOICE_LINES_ALL’, ‘AP_INVOICE_DISTRIBUTIONS_ALL’);

c) Now, run the below given query and enter the SID returned by above query.

SELECT SID, SERIAL# FROM v$session WHERE SID = <SID from Above Query)>;

Step 2. As the locking sessions have been identified, please use the below command to kill sessions.

ALTER SYSTEM KILL SESSION ‘sid,serial#’ IMMEDIATE;

SID and serial# to be taken from the output of 1C.

-----END----

#################################################################################

Objects Locked in Module

SELECT a.object_id, a.session_id, substr(b.object_name, 1, 40)
  FROM v$locked_object a, dba_objects b
 WHERE a.object_id = b.object_id
   AND b.object_name like 'AP_%'
 ORDER BY b.object_name;

Table wise Objects Locked

SELECT l.*, o.owner object_owner, o.object_name
  FROM SYS.all_objects o, v$lock l
 WHERE l.TYPE = 'TM'
   AND o.object_id = l.id1
   AND o.object_name in ('AP_INVOICES_ALL', 'AP_INVOICE_DISTRIBUTIONS_ALL');

SELECT SID, SERIAL# FROM v$session WHERE SID in (306, 312);

ALTER SYSTEM KILL SESSION '312,322' IMMEDIATE;

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

Object Locked in User

 select
 a.object_id, a.session_id, substr(c.object_name, 1, 40), b.CLIENT_IDENTIFIER
from
   v$locked_object a ,
   v$session b,
   dba_objects c
where
   b.sid = a.session_id
and
   a.object_id = c.object_id;

All in One Query

select
 o.owner,l.SID, b.SERIAL#,a.object_id, a.session_id, substr(c.object_name, 1, 40), b.CLIENT_IDENTIFIER, b.LOGON_TIME
from
   v$locked_object a ,
   v$session b,
   dba_objects c,
   SYS.all_objects o,
   v$lock l
where
   b.sid = a.session_id
and
   a.object_id = c.object_id
   AND o.object_id = l.id1
   and o.object_id=a.OBJECT_ID
   and o.object_id=c.object_id
   and l.ID1=a.OBJECT_ID
   and l.ID1=c.object_id
   and l.TYPE = 'TM'
   and b.SID=l.SID
      order by b.LOGON_TIME asc ;

Warning in Excel Output (oracle.apps.fnd.cp.opp.PostProcessorException: oracle.apps.fnd.cp.opp.PostProcessorException: oracle.apps.xdo.XDOException: /apps/prod/PROD/tmp/xdovmRgkvDo0V022716_0035437060.fo (No such file or directory))

http://dbissues.blogspot.com/2016/02/warning-in-excel-output.html

+---------------------------------------------------------------------------+
Payables: Version : 12.2

Copyright (c) 1998, 2013, Oracle and/or its affiliates. All rights reserved.

TAXDETAILXL:  TAX XL NEW
+---------------------------------------------------------------------------+

Current system time is 27-FEB-2016 00:34:24

+---------------------------------------------------------------------------+


+-----------------------------
| Starting concurrent program execution...
+-----------------------------

Arguments
------------
P_DATE1='2015/01/01 00:00:00'
P_DATE2='2015/01/31 00:00:00'
P_ORG_ID='189'
------------

Forcing NLS_NUMERIC_CHARACTERS to: '.,' for XDO processing

 APPLLCSP Environment Variable set to :

 Current NLS_LANG and NLS_NUMERIC_CHARACTERS Environment Variables are :
American_America.UTF8

'.,'

Enter Password:
REP-0004: Warning: Unable to open user preference file.

Report Builder: Release 10.1.2.3.0 - Production on Sat Feb 27 00:34:41 2016

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


+---------------------------------------------------------------------------+
Start of log messages from FND_FILE
+---------------------------------------------------------------------------+
+---------------------------------------------------------------------------+
End of log messages from FND_FILE
+---------------------------------------------------------------------------+


+---------------------------------------------------------------------------+
Executing request completion options...

Output file size:
57447139

+--------- 1) POST-PROCESSING  ---------+
Beginning post-processing of request 1484068 on node CO at 27-FEB-2016 00:35:12.
-- Publishing output


Post-processing of request 1484068 failed at 27-FEB-2016 00:35:43 with the error message:
One or more post-processing actions failed. Consult the OPP service log for details.

CONC-POST-PROCESSING RESULTS

-- PUBLISH:
oracle.apps.fnd.cp.opp.PostProcessorException: oracle.apps.fnd.cp.opp.PostProcessorException: oracle.apps.xdo.XDOException: /apps/prod/PROD/tmp/xdovmRgkvDo0V022716_0035437060.fo (No such file or directory)
+---------------------------------------+


Finished executing request completion options.

+---------------------------------------------------------------------------+
Concurrent request completed
Current system time is 27-FEB-2016 00:35:44

+---------------------------------------------------------------------------+

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

Solution:

Navigate to Xml publisher Administrator and add the path in

Temporary directory: /u01/oracle/PROD/apps/tmp

How to Compile JSP Pages in EBS Enviroment

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

Run apps environment

Navigate to Below Location

cd $FND_TOP/patch/115/bin

Run the Below Command

perl ojspcompile.pl --compile --flush -p

Recommended Browsers & Deploying JRE (Native Plug-in) for Windows Clients

http://dbissues.blogspot.com/2016/02/recommended-browsers-deploying-jre.html

Recommended Browsers for Oracle E-Business Suite Release 12 (Doc ID 389422.1)

Deploying JRE (Native Plug-in) for Windows Clients in Oracle E-Business Suite Release 12 (Doc ID 393931.1)

How to verify Java plugins on Application R12.2

http://dbissues.blogspot.com/2016/02/how-to-verify-java-plugins-of.html

/apps/test/TEST/fs1/EBSapps/comn/webapps/oacore/util/javaplugin

How to check Number of CPU

http://dbissues.blogspot.com/2016/02/how-to-check-number-of-cpu.html

select * from v$OSSTAT

[test@test ~]$ cat /proc/cpuinfo

[test@test ~]$ cat /proc/meminfo

How to run cmclean on apps (cmclean script attached)

http://dbissues.blogspot.com/2016/02/how-to-run-cmclean-on-apps-cmclean.html

Please Download it from the below link

https://drive.google.com/open?id=0B30-kT1pIOm_XzMxU1hSNTNIWFU

Down the Application

Run apps enviorment

Connect to sqlplus

Sql>@cmclean

Type dual to Continue

How to create RTF file through Xml Desktop Publisher

http://dbissues.blogspot.com/2016/02/how-to-create-rtf-file-through-xml.html

Please Download it from the Below Link

https://drive.google.com/open?id=0B30-kT1pIOm_WUw1aWZjSlB4X1E

How to get IP, Domain, Host, Product Version through Query

http://dbissues.blogspot.com/2016/01/how-to-get-ip-domain-host-product.html

TNS NAMES

---------

tt =

  (DESCRIPTION =

    (ADDRESS = (PROTOCOL = TCP)(HOST = ?)(PORT = ?))

    (CONNECT_DATA =

      (SID = ?)

    )

  )

  select utl_inaddr.get_host_address(sys_context('userenv','server_host')) 

  from dual;

how to get server ip address in oracle

================================

1. For Server IP Address

SELECT UTL_INADDR.get_host_address

FROM DUAL

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

2. For Host Name (Server Address)

SELECT UTL_INADDR.get_host_name 

FROM DUAL

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

3. For Domain and host name

SELECT sys_context('USERENV', 'HOST') 

FROM dual; 

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

4. For host name (TO Check, wether Live or Clone)

SELECT sys_context('USERENV', 'SERVER_HOST') 

FROM dual; 

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

For Product Version

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

SELECT PRODUCT, VERSION FROM SYS.PRODUCT_COMPONENT_VERSION;

For Operating System Version

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

select dbms_utility.port_string from dual;

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

select * from V$version;

select * from V$instance;

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

System Network IP Address and Port

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

select sys_context('userenv', 'ip_address') ip_address, port

from gv$session

where gv$session.inst_id = sys_context('userenv', 'instance')

    and gv$session.sid = sys_context('userenv', 'sid');

Profile Option:

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

AMS : Server URL

FRM-18107: Failed to create a DE context for the module

http://dbissues.blogspot.com/2016/02/frm-18107-failed-to-create-de-context.html

Resolved after deleting ORACLE_HOME from Environment Variables.

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

When starting Forms 10g Developer after starting OCJ4 Instance, I got the above error. 

I installed Oracle developer suite 10g after Oracle 10g server. (Windows platform)
Solution is to delete Oracle Home environment Variable. I just delete Oracle Home environment variable which points to, on my system, oracle 10g server which I installed at first. And everything works fine.

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

Installing Oracle Forms (Oracle Suite 10g)

2.1. Go to: www.oracle.com.

After a free registration, download the two Windows version:

http://download-llnw.oracle.com/otn/nt/ids/101202/ds_windows_x86_101202_disk1.zip

(626,122,752 bytes); known as disk1,

and

http://download.oracle.com/otn/nt/ids/101202/ds_windows_x86_101202_disk2.zip

(236,880,881 bytes); known as disk2.

2.2. Unzip the two files within a directory,

2.3. Inside the directory given by the first unpacked file: 

ds_windows_x86_101202_disk1, double click on setup.exe, and follow the 

instruction. 

2.4. We get a 10g Oracle welcome screen, click Next, confirm Exit,

2.5. Choose any destination directory; use Browse,

2.6. Choose the complete installation insted of the one related to J2EE,

2.7. For Provide Outgoing Mail Server Information, leave it blanck, click Next,

2.8. Press Install. The time the second disk is required (70% progression), direct the query 

by browsing to the directory of the second unzipped file: ds_windows_x86_101202_disk2. 

2.9. We get the End of Installation screen

At this step, the installation is successfully completed.

1. Installation directory:

Oracle Forms installed in :

C:\oraclexe\app\oracle\product\10.2.0\server\forms

2. Error:

FRM-18107: Failed to create a DE context for the module. 

Cause: Forms could not create the DE context for the module. 

Action: Check your development

Solution:

My Computer > Properties > Advanced > Environment Variables and 

delete ORACLE_HOME

(It wavs C:\oraclexe\app\oracle\product\10.2.0\server)

3.PATH:

C:\j2sdk1.4.2_04\bin;C:\j2sdkee1.3.1\bin;C:\oraclexe\app\oracle\product\10.2.0\server\bin;

C:\Program Files\Java\jdk1.6.0_03\bin;C:\MATLABR11\bin;C:\Program Files\Ant\bin;

C:\Program Files\Adobe\Flex Builder 3\sdks\3.1.0\bin

Add to it:

;C:\oraclexe\app\oracle\product\10.2.0\server\forms\bin

How to apply Patch in 12.2.4

http://dbissues.blogspot.com/2016/02/how-to-apply-patch-in-1224.html

Copy Patch /u01/oracle/PROD/apps/fs_ne/EBSapps/patch

chown -Rf oracle:dba /file_path
chmod -Rf 775 /file_path

Stop application from by running the APPS.Env
$ADMIN_SCRIPTS_HOME

./adstpall.sh apps/apps

./adadminsrvctl.sh start apps/apps

Navigate to path /u01/oracle/PROD/apps/fs_ne/EBSapps/patch

adop phase=apply patches=patch_num hotpatch=yes

After applying patch stop

./adadminsrvctl.sh stop
./adnodemgrctl.sh stop

Run ./adautocfg.sh after applying patch

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

Error:

Validating credentials...

Initializing...
    Run Edition context  : /u01/oracle/PROD/apps/fs1/inst/apps/PROD_TEST/appl/admin/PROD_TEST.xml
    Patch edition context: /u01/oracle/PROD/apps/fs2/inst/apps/PROD_TEST/appl/admin/PROD_TEST.xml
Reading driver file (up to 50000000 bytes).
*******FATAL ERROR*******
PROGRAM : (/u01/oracle/PROD/apps/fs1/EBSapps/appl/ad/12.0.0/bin/adzdoptl.pl)
TIME    : Sun Feb 21 13:04:32 2016
FUNCTION: ADOP::GlobalVars::_validateApplyRestartArgs [ Level 1 ]
ERRORMSG: Since earlier patching session failed and you are invoking apply again, please specify 'abandon' or 'restart' parameter.


[STATEMENT] Please run adopscanlog utility, using the command

"adopscanlog -latest=yes"

to get the list of the log files along with snippet of the error message corresponding to each log file.


adop exiting with status = 255 (Fail)

Solution:

adop phase=apply patches=patch_num hotpatch=yes abandon=yes (to start patch from failing end)

adop phase=apply patches=patch_num hotpatch=yes restart=yes (to start patch from begning)

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

Error:

Validating system setup...
    Node registry is valid.
    Application services are down.
    [ERROR]     ETCC not run in the database node TEST
                The EBS Technology Codelevel Checker needs to be run on the database node.
                It is available as Patch 17537119.

    Encountered the above errors when performing database validations.
    Resolve the above errors and restart adop.



[STATEMENT] Please run adopscanlog utility, using the command

"adopscanlog -latest=yes"

to get the list of the log files along with snippet of the error message corresponding to each log file.


adop exiting with status = 1 (Fail)

Solution:

select * from fnd_nodes

select * from applsys.txk_tcc_results

Copy DB_MT.tar in /u01/

Run Database Enviroment

connect sqlplus

SQL> create table shafqat_txk as select * from applsys.txk_tcc_results;

SQL> drop table applsys.txk_tcc_results;

[oracle@TEST u01]$ tar -xzvf DB_MT.tar (to untar)

-----[oracle@TEST u01]$ tar -czvf DB_MT.tar DB_MT (to make tar)

check the rights ls-alrt

chmod -Rf 775 DB_MT
chown -Rf oracle:dba DB_MT

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


[oracle@TEST u01]$ cd DB_MT
[oracle@TEST DB_MT]$ ls
backup            checkMTpatch.cmd           README.txt
checkDBpatch.cmd  p17537119_R12_GENERIC.zip
[oracle@TEST DB_MT]$ cd b
-bash: cd: b: No such file or directory
[oracle@TEST DB_MT]$ cd backup/
[oracle@TEST backup]$ ls
checkDBpatch_11738.log  checkDBpatch_4455.log   checkMTpatch_3195.log
checkDBpatch_12360.log  checkDBpatch_5035.log   checkMTpatch_4471.log
checkDBpatch_13066.log  checkDBpatch_5630.log   checkMTpatch_5250.log
checkDBpatch_13548.log  checkDBpatch_7114.log   checkMTpatch_5970.log
checkDBpatch_13970.log  checkDBpatch_963.log    checkMTpatch_7294.log
checkDBpatch_14414.log  checkDBpatch.cmd        checkMTpatch.cmd
checkDBpatch_14526.log  checkDBpatch.sh         checkMTpatch.sh
checkDBpatch_19122.log  checkMTpatch_12641.log  p17537119_R12_GENERIC.zip
checkDBpatch_19742.log  checkMTpatch_13359.log  README.txt
checkDBpatch_20562.log  checkMTpatch_1686.log   txk_R1220_DB_base_bugs.xml
checkDBpatch_21575.log  checkMTpatch_2417.log   txk_R1220_MT_base_bugs.xml
checkDBpatch_3582.log   checkMTpatch_26608.log
[oracle@TEST backup]$ ./checkDBpatch.sh

 +===============================================================+
 |    Copyright (c) 2005, 2015 Oracle and/or its affiliates.     |
 |                     All rights reserved.                      |
 |    Database EBS Technology Codelevel Checker (DB-ETCC)        |
 +===============================================================+

Starting Database EBS Technology Codelevel Checker, Version 120.26
Enter the full path to the DB Context file :/u01/oracle/PROD/db/tech_st/11.2.0/appsutil/PROD_TEST.xml

Using database context file:
/u01/oracle/PROD/db/tech_st/11.2.0/appsutil/PROD_TEST.xml

Bugfix XML file version: 120.0.12020000.24
This file will be used as the reference for identifying missing bugfixes.

[WARNING] DB-ETCC: Bugfix XML file (txk_R1220_DB_base_bugs.xml) in current directory is more than 30 days old.
 Check if a newer version is available in patch 17537119.


Identifying database release ...
Setting database release to 11.2.0.4

=======================================================
[WARNING] DB-ETCC: Could not connect to database, so unable to check:
  - Whether database is in READ-WRITE mode.
  - Existence of table needed to store DB-ETCC results.
Resolve the database connectivity issue, and then rerun DB-ETCC.
=========================================================
Started prerequisite patch testing : Sun Feb 21 14:51:44 PKT 2016

Log file for this session : ./checkDBpatch_12937.log

Obtained list of bugfixes to be applied and the list to be rolled back.
Now checking Database ORACLE_HOME.

The opatch utility is at the required version.

Found patch records in the inventory.

All the required one-off bugfixes are present in Database ORACLE_HOME.

Database not available. DB-ETCC results cannot be stored.

Finished prerequisite patch testing : Sun Feb 21 14:52:11 PKT 2016

=========================================================


[oracle@TEST scripts]$ ./adadminsrvctl.sh stop
[oracle@TEST scripts]$ ./adadminnode.sh stop

You are running adadminsrvctl.sh version 120.10.12020000.9

Enter the WebLogic Admin password:
Enter the APPS Schema password:
Stopping WLS Admin Server...
Refer /u01/oracle/PROD/apps/fs1/inst/apps/PROD_TEST/logs/appl/admin/log/adadminsrvctl.txt for details

adadminsrvctl.sh: exiting with status 0

adadminsrvctl.sh: check the logfile /u01/oracle/PROD/apps/fs1/inst/apps/PROD_TEST/logs/appl/admin/log/adadminsrvctl.txt for more information ...

[oracle@TEST scripts]$

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

Run Database Env
connect to SQLPLUS

SQL> show parameter _system_trig_enabled;

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
_system_trig_enabled                 boolean     TRUE

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

Down the Listener
[oracle@TEST 11.2.0]$ lsnrctl stop PROD

Down Database
SQL> shut immediate


Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> exit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
[oracle@TEST 11.2.0]$ cd appsutil
[oracle@TEST appsutil]$ ls
bin   install  jdk  jre1.5  media  perl            scripts  temp
html  java     jre  log     out    PROD_TEST.xml  sql      template
[oracle@TEST appsutil]$ cd scripts/
[oracle@TEST scripts]$ ls
PROD_TEST
[oracle@TEST scripts]$ cd PROD_TEST/
[oracle@TEST PROD_TEST]$ ls
adautocfg.sh  addbctl.sh   adexecsql.pl  adpreclone.pl  adstrtdb.sql
adchknls.pl   addlnctl.sh  adlsnodes.sh  adstopdb.sql
[oracle@TEST PROD_TEST]$ ./adautocfg.sh
------------------------------------------------------------------------------
AutoConfig completed with errors.
------------------------------------------------------------------------------

Check the logfile for errors >>>> Verifying connection to the Database   : Could not be stablished

lsnrctl start PROD

connect to sqlplus and start database

sql>startup

Run ./adautocfg.sh again

[oracle@TEST PROD_TEST]$ ./adautocfg.sh

--------------------------------------------------------------------------------
AutoConfig completed successfully.
--------------------------------------------------------------------------------

Run apps Enviroment adn run ./adautocfg.sh

[oracle@TEST appl]$ . ./APPSPROD_TEST.env

[oracle@TEST scripts]$ ./adautocfg.sh


------------------------------------------------------------------------------
AutoConfig completed successfully.

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