EXPLORER

2009-07-23T21:02:00.000-07:00

Sabse Achha Baccha Kaun?

MOHAMMED JAVEED AHMED

RMAN Backup and Restoration

2009-06-03T22:15:00.002-07:00

Note ID: 360416.1 , 388431.1

Mohammed Riyaz Ahmed Khan
“The PATHAN Boy”

Forms and Reports Compilation at OS level:

2009-06-03T22:15:00.001-07:00

Here is a good document which guides compilation of forms/Reports from command prompt.
Hope it would be helpful.

Subject: How to generate tables, views, forms, libraries, menus, reports, trace files, to find trace files, to format trace files and to get file versions
Doc ID: Note:303107.1 Type: FAQ
Last Revision Date: 29-MAR-2005 Status: PUBLISHED

@
@
ORACLE PAYABLES
------------------------------
FREQUENTLY ASKED QUESTIONS
--------------------------
DD-MON-YYYY
CONTENTS
--------
1. How to generate a table or view?
2. How to generate a form, library or menu?
3. How to generate a report?
4. How to generate a trace file for a form?
5. How to generate a trace file for a report or concurrent program?
6. How to find the trace file?
7. How to format the trace file?
8. How to get the version of forms?
9. How to get the version of reports?
10. How to get the version of libraries?
11. How to get the version of packages (SQL or PL/SQL scripts)?
12. How to find a file?
13. How to view the text of a view?
QUESTIONS & ANSWERS
-------------------
1. How to generate a table or view?
Answer
------
11.0 and 11i: adodfcmp
Table:
adodfcmp \
odffile=.odf userid=ar/ar changedb=yes mode=tables \
touser=apps/apps priv_schema=system/manager
View:
adodfcmp \
odffile=.odf userid=apps/apps changedb=yes mode=views \
touser=apps/apps priv_schema=system/manager
References
----------
Note 137176.1 Ext/Pub The ADODFCMP Utility
Note 69756.1 Int/Pub ADODFCMP and Constraints within Oracle Applications
2. How to generate a form, library or menu?
Answer
------
11.0: f45gen
11i: f60gen
windows NT: ifcmp60nt
Form:
cd $AU_TOP/forms/US
f45gen module=.fmb userid=apps/ module_type=FORM
output_file=.fmx batch=yes compile_all=special
Copy the .fmx to the correct directory.
For example: $AP_TOP/forms/US
Library:
cd $AU_TOP/resource
f45gen module=.pll userid=apps/ module_type=LIBRARY
output_file=.plx batch=yes compile_all=special
Menu:
f45gen module=.mmb userid=apps/ module_type=MENU
output_file=.mmx batch=yes compile_all=special
References
----------
Note 130686.1 Ext/Pub How to Generate Form, Library and Menu for Oracle Applications
3. How to generate a report?
Answer
------
11.0: r25convm
11i: rwcon60
r25convm userid=apps/ source=.rdf dest=.rex
stype=rdffile dtype=rexfile logfile=.log overwrite=yes batch=yes
r25convm userid=apps/ source=.rex dest=.rdf
stype=rexfile dtype=rdffile logfile=.log overwrite=yes batch=yes
References
----------
Note 66703.1 Ext/Pub Batch Generation of Reports
Note 106504.1 Ext/Pub Payables Reports Frequently Asked Questions
4. How to generate a trace file for a form?
Answer
------
11.0:
Open the form and select Help -> Tools -> Trace
11i:
Open the form and select Help -> Diagnostics -> Trace with binds
References
----------
Note 130182.1 Ext/Rev HOW TO TRACE FROM SCREEN, REPORT, PROGRAM AND OTHERS IN ORACLE APPLICATIONS
Note 142898.1 Ext/Pub How To Use Tkprof and Trace With Applications
5. How to generate a trace file for a report or concurrent program?
Answer
------
11.0 and 11i:
Select the Enable Trace flag in the concurrent program definition.
Responsibility: System Administrator
Path: Concurrent -> Program -> Define
References
----------
Note 130182.1 Ext/Rev HOW TO TRACE FROM SCREEN, REPORT, PROGRAM AND OTHERS IN ORACLE APPLICATIONS
Note 142898.1 Ext/Pub How To Use Tkprof and Trace With Applications
6. How to find the trace file?
Answer
------
The directory where the trace files reside is defined by variable USER_DUMP_DEST,
if it is not set, execute the following sql command from sqlplus (apps account):
select value from v$parameter
where name='user_dump_dest';
Trace files are named ora_.trc. To retrieve your trace file you can try
unix command: ls -lt
Verify timestamp and also search a characteristic string with grep command.
References
----------
Note 130182.1 Ext/Rev HOW TO TRACE FROM SCREEN, REPORT, PROGRAM AND OTHERS IN ORACLE APPLICATIONS
Note 142898.1 Ext/Pub How To Use Tkprof and Trace With Applications
7. How to format the trace file?
Answer
------
Use tkprof utility to format the raw trace in more readable file.
tkprof sys=no explain=apps/
References
----------
Note 130182.1 Ext/Rev HOW TO TRACE FROM SCREEN, REPORT, PROGRAM AND OTHERS IN ORACLE APPLICATIONS
Note 142898.1 Ext/Pub How To Use Tkprof and Trace With Applications
8. How to get the version of forms?
Answer
------
11.0:
Open the form and select Help -> Tools -> About Oracle Applications
Verify the form name and version in the Current Form section.
11i:
Open the form and select Help -> Diagnostics -> About Oracle Applications
Verify the form name and version in the Current Form section.
You can verify the version to the Oracle Applications, Oracle Forms and RDBMS using this option.
or go to the directory of the file (for example: cd $AP_TOP/forms/US):
cd $/forms/
On Unix:
strings -a * |grep -i '$Header'
On Windows (DOS box) :
find "Header"
References
----------
Note 121916.1 How To Get Version of Programs, Files, Objects Necessary for Oracle Applications
9. How to get the version of reports?
Answer
------
Go to the directory of the file (for example: cd $AP_TOP/reports/US):
cd $/reports/
On Unix:
strings -a * |grep -i '$Header'
On Windows (DOS box) :
find "Header"
References
----------
Note 121916.1 How To Get Version of Programs, Files, Objects Necessary for Oracle Applications
10. How to get the version of libraries?
Answer
------
cd $AU_TOP/resource
On Unix:
strings -a * |grep -i '$Header'
On Windows (DOS box) :
find "Header"
References
----------
Note 121916.1 How To Get Version of Programs, Files, Objects Necessary for Oracle Applications
11. How to get the version of packages (SQL or PL/SQL scripts)?
Answer
------
Go to $/admin/sql or /patch/110/sql for last version.
You should find the corresponding file with .sql, .pls, .pkh, or .pkb extension.
On Unix:
strings -a * |grep -i '$Header'
On Windows (DOS box) :
find "Header"
or use the following script in the sql&plus:
select text
from dba_source
where name like ''
and line in (1,2,3,4);
References
----------
Note 121916.1 How To Get Version of Programs, Files, Objects Necessary for Oracle Applications
12. How to find a file?
Answer
------
Execute the following commands on unix:
cd $
find . -name '**' -print
find /i "$Header"
grep -i '' *
References
----------
Note 136962.1 Int/Rev How can we find which C source files contain a specific symbol or string
13. How to view the text of a view?
Answer
------
Execute the following script in the sql&plus:
select text
from all_views
where view_name =''
and owner = 'APPS';
References
----------
Note 1018636.102 Ext/Pub HOW TO SEE THE SELECT STATEMENT THAT DEFINES A VIEW.
Note 1075505.6 Ext/Arc HOW DO YOU FIND THE SCRIPT THAT CREATES A PARTICULAR VIEW?
Note 1016346.102 Ext/Pub GENERATE VIEW CREATION SCRIPT
Mohammed Riyaz Ahmed Khan
“The PATHAN Boy”

E-Business Suite URL Redirect To Wrong URL

2009-06-03T22:14:00.004-07:00

Resolution available at Note:387017.1

Mohammed Riyaz Ahmed Khan
“The PATHAN Boy”

Oracle Database 10g Automated SGA Memory Tuning

2009-06-03T22:14:00.003-07:00

Note:257643.1

Mohammed Riyaz Ahmed Khan
“The PATHAN Boy”

Switch log file manually:

2009-06-03T22:14:00.001-07:00

ALTER DATABASE ADD LOGFILE group 1 ('/U02/CAFOS/cafosredo/log01a.dbf') SIZE 512M;
ALTER DATABASE ADD LOGFILE group 2 ('/U02/CAFOS/cafosredo/log02a.dbf') SIZE 512M;
ALTER DATABASE ADD LOGFILE group 3 ('/U02/CAFOS/cafosredo/log03a.dbf') SIZE 512M;
ALTER DATABASE ADD LOGFILE group 4 ('/U02/CAFOS/cafosredo/log04a.dbf') SIZE 512M;
ALTER DATABASE ADD LOGFILE group 5 ('/U02/CAFOS/cafosredo/log05a.dbf') SIZE 512M;
alter system switch logfile;
alter system switch logfile;
alter system switch logfile;
alter system switch logfile;
alter system switch logfile;
## Now wait until logfile groups 6-10 have ALL become INACTIVE, and have been archived off to /hot_bkup/CAFOS/archive !!
ALTER DATABASE DROP LOGFILE GROUP 6;
ALTER DATABASE DROP LOGFILE GROUP 7;
ALTER DATABASE DROP LOGFILE GROUP 8;
ALTER DATABASE DROP LOGFILE GROUP 9;
ALTER DATABASE DROP LOGFILE GROUP 10;
Now: /U04/CAFOS/cafosredo/log01*.dbf can be removed.
Mohammed Riyaz Ahmed Khan
“The PATHAN Boy”

Parellel Concurrent Processor

2009-06-03T22:13:00.004-07:00

Doc ID:185489.1

Mohammed Riyaz Ahmed Khan
“The PATHAN Boy”

Gather Schema Statistics Manual Script:

2009-06-03T22:13:00.003-07:00

Please find the below reference Metalink Note ID: 190177.1 , part of Information is mentioned below :

OVERVIEW:
coe_stats.sql verifies the statistics in the data dictionary for all tables
owned by installed Oracle Apps modules. It generates a dynamic script
coe_fix_stats.sql and a report coe_stats.log.
The generated report coe_stats.log contains the list of tables that need
to be analyzed, including the actual (former) number of rows and the
suggested sample size for the next statistics gathering.
The dynamic script generated coe_fix_stats.sql includes the commands to
execute the FND_STATS packege to gather the statistics based on the number
of days since last analyzed and the size of the table.

INSTRUCTIONS:
Run coe_stats.sql with no parameters and review coe_stats.log file. If
output is approved, remove comment line on '-- @coe_fix_stats' at the end
of this script and run it again, or run coe_fix_stats.sql manually.
This coe_stats.sql script should be run once per week.

Mohammed Riyaz Ahmed Khan
“The PATHAN Boy”

Recompile Invalids:

2009-06-03T22:13:00.001-07:00

exec utl_recomp.recomp_parallel(3); recompile invalid objects;
exec dbms_utility.compile_schema('any schema');
Mohammed Riyaz Ahmed Khan
“The PATHAN Boy”

You MUST shutdown the concurrent manager BEFORE you run cmclean.sql....WHY?

2009-06-03T22:12:00.004-07:00

sqlplus apps/apps @cmclean

You MUST shutdown the concurrent manager BEFORE you run cmclean.sql
If you dont, what will happen is that currently running jobs will be marked as COMPLETED even though they are still running, and any dependent job will startup, possibly corrupting your data. Additionally, the internal manager might get confused as to how many jobs are running and might misallocate jobs to managers, basically a mess for job scheduling.
Once you shutdown the concurrent managers, cmclean.sql will mark all jobs that were in the running state as completed.
It is safe to do, since no jobs are running and they should be marked as completed.

Mohammed Riyaz Ahmed Khan
“The PATHAN Boy”

PHASECODE and STATUS CODE

2009-06-03T22:12:00.003-07:00

Note ID: 304313.1

Mohammed Riyaz Ahmed Khan
“The PATHAN Boy

How to ignore "Out of Office" Reply's for WorkFlow (PO) approvals

2009-06-03T22:12:00.001-07:00

The solution I have uses is in Oracle® Workow Administrator’s Guide Release 2.6.4 Part No. B15852-05 page under Notification Mailer

Configuration Wizard, page 7-24. Specifically: Send Warning for Unsolicited E-mail - Select this parameter to allow the notification

mailer to send back a warning message the first time it receives an unsolicited e-mail message from a particular e-mail address. Deselect this parameter to prevent the notification mailer from sending warning messages. (page 7 - 39)

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

The workflow mailer has a tag file (in Unix it is called wfmail.tag) which is used to deal with replies, it is all documented in note 104198.1

The tag file specifies what to do with messages with particular subjects, a typical example of the contents being:

ERROR "Host unknown"

UNAVAIL "Auto-Reply: "

UNAVAIL "Auto-reply: "

UNAVAIL "Out of Office AutoReply"

The UNAVAIL stops out of office replies from upsetting workflow and doesn't trigger a warning for unsolicited email being sent back in reply.

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

One more comment to close this up. I reviewed our java-based workflow notification mailer set in Oracle Applcations Manager and "Out of Office AutoReply" is set to "Ignore".

Mohammed Riyaz Ahmed Khan

“The PATHAN Boy”

Error while converting to Multi -Org and resolution

2009-06-03T22:11:00.001-07:00

AD Administration error:

The following ORACLE error:

ORA-00001: unique constraint (APPLSYS.AD_DEFERRED_JOBS_U1) violated

occurred while executing the SQL statement:

Insert into AD_DEFERRED_JOBS [6]

AD Administration error:

Failed saving timing information to AD_DEFERRED_JOBS

Resolution:

ORG_ID should be set in the profile MO: Operating Unit at the site level and adadmin should be rerun again.

* recommended to bring down apps services before converting to multi-org.

* Should be run on the admin-tier

* Should be checked in FND_PRODUCTS_GROUPS with the value multiorg_flag.

Mohammed Riyaz Ahmed Khan

“The PATHAN Boy”

Error while running adcfgclone.pl on dbTier.

2009-06-03T22:10:00.000-07:00

We got the below error while running adcfgclone.pl on dbTier.

Starting ORACLE_HOME relinking...
Instantiating adlnkoh.sh

Starting relink of ORACLE_HOME - RDBMS
Adding execute permission to :
/u04/dev/devdb/9.2.0/appsutil/install/adlnkoh.sh
Executing cmd :
/u04/dev/devdb/9.2.0/appsutil/install/adlnkoh.sh

adlnkoh.sh started at Sun Feb 10 14:39:40 GMT 2008
logfile located in /u04/dev/devdb/9.2.0/install/make.log

Error while running adlnkoh.sh. Please check logfile

.end std out.
/u04/dev/devdb/9.2.0/appsutil/install/adlnkoh.sh: line 207: /u04/dev/devdb/9.2.0/bin/sqlplus: No such file or directory

.end err out.

StackTrace:
java.lang.Exception: java.lang.NullPointerException
at oracle.apps.ad.clone.ApplyDBTechStack.runRelinkOH(ApplyDBTechStack.java:847)
at oracle.apps.ad.clone.ApplyDBTechStack.(ApplyDBTechStack.java:421)
at oracle.apps.ad.clone.ApplyDBTier.(ApplyDBTier.java:149)
at java.lang.reflect.Constructor.newInstance(Native Method)
at oracle.apps.ad.clone.util.CloneProcessor.run(CloneProcessor.java:68)
at java.lang.Thread.run(Thread.java:479)

Cause:

=====

gcc is not pointing to correct version.

Solution:

=====

link gcc32 to gcc and run adcfgclone by using below command:.

ln –s gcc32 gcc

Mohammed Riyaz Ahmed Khan

“The PATHAN Boy”

DBMS_FILE_TRANSFER Feature in Oracle 10G

2009-05-12T05:17:00.003-07:00

Note: 283991.1
Mohammed Riyaz Ahmed Khan
Apps DBA “The PATHAN Boy”

Enabling PDF Printer in 5 Easy Steps:

2009-05-12T05:17:00.001-07:00

Enabling the PDF printing is a 5 step process which is as follows …
1. Install pdf2ps (or) pdftops (or) acroread utilities at OS level.
a. Verify the utility by using the command “which” for Ex:“which pdf2ps”
2. Update the pasta_pdf.cfg file in $FND_TOP/resource location with the below entries in the Preprocess for PDF output section …
% Preprocess for PDF output
% This is an example for PDF output to print.
; Xpdf
; preprocess=pdftops {infile} {outfile}
; Ghost Script
preprocess=pdf2ps {infile} {outfile}
; Acrobat
; preprocess=acroread -toPostScript -pairs {infile} {outfile}
a. Only one entry should be enabled. If you install pdf2ps then check it as above.
3. Follow the document to create the custom driver, styles and assign them to printer type and report as well as done in the attached document.
4. Bounce the concurrent services
5. Test the printing.
Mohammed Riyaz Ahmed Khan
Apps DBA “The PATHAN Boy”

Workflow Test Mail Setup from Backend:

2009-05-12T05:16:00.004-07:00

select fscpv.parameter_value ,fscpv.parameter_id from fnd_svc_comp_params_tl fscpt ,fnd_svc_comp_param_vals fscpv
where fscpt.display_name = 'Test Address'
and fscpt.parameter_id = fscpv.parameter_id;

update fnd_svc_comp_param_vals
set parameter_value = 'xxx@xxx.com'
where parameter_value='NONE' and parameter_id=10057;
Mohammed Riyaz Ahmed Khan
Apps DBA “The PATHAN Boy”

Configure Printer at OS Level:

2009-05-12T05:16:00.003-07:00

Configure printer at OS (SOLARIS 5.9) Level....
lpadmin -p -s
Eg: lpadmin -p hpl5000tn -s 192.168.2.95
lpstat -a
Test Print at OS level:
lp -d hpl5000tn test.txt
Application Level Configure....
Install
Printer
Register

Eg: hpl5000tn
Printer type: HPLJ4
:Save:
Run the following request for test print
Work Shift Report
Mohammed Riyaz Ahmed Khan
Apps DBA “The PATHAN Boy”

sga_target - hidden parameter shared pool parameter size

2009-05-12T05:16:00.001-07:00

What is the Reserved Area?
A cache miss on the data dictionary cache or library cache is more expensive than a miss on the buffer cache. For this reason, the Shared Pool should be sized to ensure that frequently used data is cached. If there is not enough free space in the Shared Pool, then Oracle must search for and free enough memory to satisfy this request. This operation could conceivably hold latch resources for detectable periods of time, causing minor disruption to other concurrent attempts at memory allocation.
By default, Oracle configures a small Reserved Pool (or Reserved Area) inside the Shared Pool. This memory can be used for operations such as PL/SQL and trigger compilation or for temporary space while loading Java objects. After the memory allocated from the Reserved Pool is freed, it returns to the Reserved Pool.

5% of the Shared Pool is set aside as the Reserved Pool to handle allocations of memory higher than defined by the hidden parameter _shared_pool_reserved_pct. Issue
select a.ksppinm "Parameter",
b.ksppstvl "Session Value",
c.ksppstvl "Instance Value"
from sys.x$ksppi a, sys.x$ksppcv b, sys.x$ksppsv c
where a.indx = b.indx and a.indx = c.indx
and a.ksppinm = '_shared_pool_reserved_pct';
to see the current setting in your environment. In some application environments, 5% is too small. If an ORA-04031 problem indicates a very large memory request failure, increase the size of the Reserved Area by manually setting SHAREPOOL_RESERVED_SIZE or if using SGA_TARGET>0, change the hidden parameter, _shared_pool_reserved_pct to 10 or 15 (see example below) to ensure that when the Shared Pool grows or shrinks automatically, the Reserved Area will change as well.

Warning:
If you decide to use the SHARED_POOL_RESERVED_SIZE parameter and SGA_TARGET>0, you may experience ORA-4031 situations on large memory requests because the MMAN process may be increasing the size of the Shared Pool over time, while the Reserved Area remains constant. Thus the Reserved Area may start out at 10% of the Shared Pool size, but over time it may end up 2% or 3% (much smaller than expected in relation to the new Shared Pool size).

The Reserved Area handles bigger memory allocations in an attempt to decrease the chances of fragmentation in the Shared Pool over time.
SQL> alter system set "_shared_pool_reserved_pct"=10 scope=spfile
or add this in the pfile
"_shared_pool_reserved_pct"=10
For large allocations, Oracle attempts to allocate space in the Shared Pool in the following order:
1. From the unreserved part of the shared pool.

2. From the reserved pool. If there is not enough space in the unreserved part of the Shared Pool, then Oracle checks whether the reserved pool has enough space.

3. If there is not enough space in the unreserved and reserved parts of the Shared Pool, then Oracle attempts to free enough memory for the allocation. It then retries the unreserved and reserved parts of the Shared Pool. These mini-flushes will clean out RECREATABLE memory chunks from the LRU list that have not been reused for a while
Mohammed Riyaz Ahmed Khan
Apps DBA “The PATHAN Boy”

How to execute forms and libraries and messages

2009-05-12T05:15:00.002-07:00

====> go to adadmin
AD Administration Main Menu
1. Generate Applications Files menu
2. Maintain Applications Files menu
3. Compile/Reload Applications Database Entities menu
4. Maintain Applications Database Entities menu
5. Change Maintenance Mode
6. Exit AD Administration

Enter your choice [6] : 1
Generate Applications Files
----------------------------------------
1. Generate message files
2. Generate form files
3. Generate report files
4. Generate graphics files
5. Generate product JAR files
6. Return to Main Menu
Enter your choice [6] : 2

AD utilities can support a maximum of 999 workers. Your
current database configuration supports a maximum of 20 workers.
Oracle recommends that you use between 64 and 128 workers.

Enter the number of workers [64] :
Please enter a number between 1 and 20.
Enter the number of workers [64] : 1
Your current character set is "UTF8".
Do you want to generate Oracle Forms objects
using this character set [Yes] ?

Do you want to regenerate Oracle Forms PL/SQL library files [Yes] ? y
Do you want to regenerate Oracle Forms menu files [Yes] ? y
Do you want to regenerate Oracle Forms executable files [Yes] y
after completion of this, below menu will come ...
Generate Applications Files
----------------------------------------
1. Generate message files
2. Generate form files
3. Generate report files
4. Generate graphics files
5. Generate product JAR files
6. Return to Main Menu
Enter your choice [6] : 1
select 1 for generate messages.
Please note down all the failed message files or forms if any while generating.
Do let me know for any doubts.
Mohammed Riyaz Ahmed Khan
Apps DBA “The PATHAN Boy”

How to Compile jsp files in 11.5.9

2009-05-12T05:15:00.001-07:00

perl -x /u00/oracle/dhbupgappl/jtf/11.5.0/admin/scripts/ojspCompile.pl --compile --quiet
or
./ojspCompile.pl --compile --flush -p 2

Mohammed Riyaz Ahmed Khan
Apps DBA “The PATHAN Boy”

How to Generate Message Files in Apps:

2009-05-12T05:14:00.004-07:00

• goal: How to generate messages?
• fact: FNDMDMSG - Define Messages
• fact: FNDMDGEN - Generate Messages

fix:

Responsibility: System Administrator
Submit the concurrent process : Generate Messages

Afterwards restart Oracle Application.

OR

Run from command line.
Syntax is :
$ FNDMDGEN APPS/APPS 0 Y DB_TO_RUNTIME <
application shortname> .msb
Mohammed Riyaz Ahmed Khan
Apps DBA “The PATHAN Boy”

Shared memory controls in Solaris 10

2009-05-12T05:14:00.003-07:00

The controls for IPC settings such as shared memory and semaphores have changes somewhat in Solaris 10. This seems to be a cause of regular confusion, and recently a friend asked me to clarify how they ought to be configured. The new facilities in Solaris 10 makes such settings dynamic, but the controls to prevent overallocation are still there, albeit in a slightly modified form.
There are two approaches these days..
1. /etc/system (yawn, requires a reboot - why would you?)
2. Projects
The IPC settings are entirely controlled by projects these days.. the ability to set values in /etc/system is there solely for backwards compatibility, and simply sets the default values for the projects, and therefore should be considered deprecated.
Probably the best way to explain the use of projects to set default values is to run through a quick worked example of setting the shared memory max allocation (shmmax), with comments inline:
$ uname -a
SunOS deepthought 5.11 snv_69 i86pc i386 i86pc
It's reporting 5.11 as it's an OpenSolaris build, but same priciples apply to 5.10
$ id –a
uid=500(mike) gid=100(users) groups=100(users)
The user we're running as has no specific privs, such as would be the case with an Oracle application account (for example). There is no settings in /etc/system, so we're running with default values.
As an aside, this is running under VMware server on a Linux host with 256MB memory allocated to the VM. The default value of shmmax is calculated as physmem/4, so we ought to see maximum allocation around about 64MB
We can check what the max shm is going to be using Solaris 10 prctl command:
$ prctl -n project.max-shm-memory $$
process: 6905: ksh -o vi
NAME PRIVILEGE VALUE FLAG ACTION RECIPIENT
project.max-shm-memory
privileged 61.9MB - deny -
system 16.0EB max deny -
$
That's reporting 61.9MB, which is pretty close to the expected 64MB. I wonder where the other 3.1MB went?
And to prove the point, I've just written a wee program that tests this, by creating (and destroying) increasingly large segments of shared memory (incrememnting by 1MB at each iteration). It stops when it fails and reports the last created seg.
$ ./findmax
Shared seg created with 61.0 MB
shmget failed!
$
So, here's how we increase it.. We need root privs, or a friendly sysadmin for this, as we're adding a new project for this user only:
$ su
Password:
# projadd -U mike -K "project.max-shm-memory=(priv,80MB,deny)" user.mike
#
Back on as me now.. (notice I'm logging on again by su'ing back to myself, rather than just exiting the "su" shell - this is deliberate)
# su – mike
Sun Microsystems Inc. SunOS 5.11 snv_69 October 2007
$ prctl -n project.max-shm-memory $$
process: 7044: ksh
NAME PRIVILEGE VALUE FLAG ACTION RECIPIENT
project.max-shm-memory
privileged 80.0MB - deny -
system 16.0EB max deny -
$
$ ./findmax
Shared seg created with 80.0 MB
shmget failed!
$

Mohammed Riyaz Ahmed Khan
Apps DBA “The PATHAN Boy”

Effective Unix Find Command:

2009-05-12T05:14:00.001-07:00

Find by Date
Find . –name “**” –mtime + -exec {} \;
Eg:
Find –name “*.log” –mtime +45 –exec ls –ltr {} \;
Version Check
Adident Header
Eg:
Adident Header asdf.sql

Mohammed Riyaz Ahmed Khan
Apps DBA “The PATHAN Boy”

Cumulative Backups:

2009-05-12T05:12:00.000-07:00

Start RMAN with a level 0 cold backup and then last night should have been a level 1 cumulative hot backup
however I feel that as this backups was taken without the level 0 cold backup The level1 hot cumulative was actually the equivalent to a full hot backup hence the size.
See example below for proposed solution
Level 0 is Full Cold backup (application down)
Level 1 is Hot Cumulative backup (application up)
Restores have not been tested until we create an RMAN duplicate on the test environment to verify the backups are complete by using the LIVE backups to create a clone of the system in the test arena.

APPS DBA

2009-05-04T06:52:00.000-07:00

Hi There,

I work as an Oracle Applications DBA... from now onwards you can find most frequent issues and their resolutions on my BLOG.... ryzpathan.blogspot.com

Yo
Mohammed Riyaz Ahmed Khan
"The PATHAN Boy"

APEDUCATION

2008-04-19T07:09:00.000-07:00

TRAVEL

2008-04-18T07:35:00.000-07:00

It was one of my adventurous tours......

This country has built the first ever biggest ship in the world.

Yes....! TITANIC. it was built in IRELAND a country known for his rebel fighters.

Its a lovely green country, just cl0se your eyes and imagine how does green landscapes looks like......... go to IRELAND your imagination will come true.

This picture has been taken at Charles Fort, one of the historic places in IRELAND.

Find Who am I in this Picture?