Everything was okayed before and now the aforesaid issue occurs.

Login to SQL*Plus as apps user and run the following:
set serveroutput on
declare
db_file NUMBER;
mime_type VARCHAR2(255) := ‘text/plain’;
out_string VARCHAR2(32767) := ‘Just some plain text that is stored.’;
web_server_prefix VARCHAR2(500);
url VARCHAR2(500);
begin
db_file := fnd_gfm.file_create(content_type => mime_type, program_name =>’export’);
fnd_gfm.file_write_line(db_file, out_string);
db_file := fnd_gfm.file_close(db_file);
url := fnd_gfm.construct_download_url(fnd_web_config.gfm_agent, db_file, TRUE);
dbms_output.put_line(url);
end;
/
If it shows, errors like
declare
*
ERROR at line 1:
ORA-29875: failed […]

Popularity: 1% [?]

continue reading.....

For daily checks ( Health Check on Admin/Concurrent Manager Node click on this link eBusiness 11i/R12 - Daily Checks (for Apps. DBA) - Admin Node
.
Related : For health check in 11i Click Here 
Popularity: 8% [?]Share This

Popularity: 8% [?]

continue reading.....

Bug 8520057 - 12.1.1 NLS PATCHING HAS INCREASED IN TIME OVER 12.0.4 
Follow the Note : 839978.1 (12.1.1 NLS Upgrade Patch 6678700 : Performance Installation Issues With XLIFFImporter Java Jobs) 
The issue is caused by the time delay spent in connection time within each Java job. 
Abort the session and apply the patch : 8576725
12.1.1 NLS Upgrade […]

Popularity: 5% [?]

continue reading.....

Assumption

The rpm sharutils-4.2.1-17.i386.rpm is already there.

Verify the same, as followed: rpm –qa sharutil* 
If not, download and install sharutils-4.2.1-17.i386.rpm by the following, as it is mandatory: rpm -ivh sharutils-4.2.1-17.i386.rpm.

DB Check Script is already implemented and scheduled.

As root user, schedule the following script:
#!/bin/bash
FILE=dbchk.doc
FILE2=output.html
RECIPIENT=rawishsiddiqui@yahoo.ca
RECIPIENTCC=oracle@nasaviation.com
RECIPIENTBCC=rsiddiqui@advancedoperations.com
(
echo “Dear Concern! Review the enclosed and take the requisite Action, if needed.”
for i […]

Popularity: 7% [?]

continue reading.....

Follow the Subsequent in order to avoid the aforementioned Error:
1. License Language from OAM
- Login with User, having SYSADMIN Responsibility
- Oracle Application Manager (Under System Administration) 
- License Manager- Under Application Dashboard/Site Map (License Manager) ->
.

.

.
Languages -> Edit- Choose Required Language -> Next -> Next
.

.
When you get the message “Successfully Licensed the Selected Language(s). …”, Now do the following:
. 
 2. Maintain […]

Popularity: 6% [?]

continue reading.....

Turn on Logging

In order to know, which listener commands were executing, one should enable the logging by the following:
LSNRCTL> set log_directory  …/log
LSNRCTL> set log_file Listener_<sid name>.log
LSNRCTL> set log_status on LSNRCTL> save_config

Set the Listener Password

Setting Listener Password is strongly recommended in order to prevent the distinct attacks. There are two ways to do the […]

Popularity: 7% [?]

continue reading.....

NOTE: Always Do Exercise on Test Environment, First. 
Assumptions : 
1. ASM Instance is already Created and Ready to Use.
2. DB Instance was Started using ‘spfile’
3. Disk Group Name : ‘+DGDATA’ 
- Set the Parameter ‘db_create_file_dest’ to ‘+DGDATA’  
alter system set db_create_file_dest=’+DGDATA’ scope=spfile;
- Set the Parameter ‘control_file’ to the destination in ASM
alter system set control_files=” scope=spfile;
 - […]

Popularity: 7% [?]

continue reading.....