Search found 17 matches

by ghanshyamkhetan
Mon Jun 30, 2008 9:46 am
Forum: Application DBA & System Administration
Topic: upgrade oracle database 9i to 10g
Replies: 0
Views: 773

upgrade oracle database 9i to 10g

Hi All,

Here we are using oracle 9.2.0.6 and apps version is 11.5.10.2. I want to upgrade my db 9.2.0.6 to 10.2. Anyone have any experience. Please share with me.

Thanks,
by ghanshyamkhetan
Wed Mar 12, 2008 4:14 am
Forum: Application DBA & System Administration
Topic: Refreshing the database
Replies: 1
Views: 940

Refreshing the database

Hi All,

Is it possible instead of full database cloning only one schema like gl, ap as required by developers will refreshed through export import utility.
Will it work or not.
Because is for only one or two module like FA, GL we have to go for full cloning. If it possible please suggest.

Thanks ...
by ghanshyamkhetan
Fri Feb 29, 2008 7:48 am
Forum: Application DBA & System Administration
Topic: How to find applied family pack in oracle apps
Replies: 2
Views: 2501

How to find applied family pack in oracle apps

Hi All,

Can you please tell me how can i find which family pack is applied in my database. Can u just tell me the table name.
by ghanshyamkhetan
Fri Jan 25, 2008 1:19 am
Forum: Application DBA & System Administration
Topic: Error while logging in into Apps
Replies: 3
Views: 1462

Hi,

For that situation check ur logs that are in
$IAS_ORACLE_HOME/Apache/Apache/logs
check the recent access_log .
by ghanshyamkhetan
Fri Jan 25, 2008 1:13 am
Forum: Application DBA & System Administration
Topic: error in when submit the request
Replies: 4
Views: 2096

Hi,

In that case plse check your FNDLIBR process is running or not. IF not then start your concurrent manager. If possile take a bounce of application and check Is FNDLIBR process is still running. Cancel this FNDLIBR process. and again start ur application server.
by ghanshyamkhetan
Thu Nov 29, 2007 12:56 am
Forum: Application DBA & System Administration
Topic: request problem
Replies: 1
Views: 856

Hi,

Cancel this report.
by ghanshyamkhetan
Wed Nov 28, 2007 4:03 am
Forum: Application DBA & System Administration
Topic: application not working
Replies: 5
Views: 1942

do you have any document for tuning

<i><div align="right">Originally posted by malahmad - Nov 27 2007 : 9:30:05 PM</div id="right"></i>


Hi,
Please follow this steps:
1) select program_application_id, count(1)
from apps.fnd_concurrent_requests
group by program_application_id;

2) select a.user ...
by ghanshyamkhetan
Wed Nov 28, 2007 12:42 am
Forum: Application DBA & System Administration
Topic: Error on applying patch
Replies: 1
Views: 1201

Hi Dear,

Please give me details.
1) Are you applying first time patch in your instance.
2) attach the whole error then I suggest you.
3) what is the patch number.

Please give me all details then i suggest you.

Bye!
by ghanshyamkhetan
Mon Nov 26, 2007 1:38 am
Forum: Application DBA & System Administration
Topic: Inactive - No Manager
Replies: 6
Views: 4525

HI,

Some times ur managers(concurrent manager) will down so ur request status is Inactive nomanager.
Do One thing put this command
login in application
and type this command
startmgr sysmgr=apps_schema_owner/password logfile=std.mgr

After put this command wait 10-20 min ur status request will ...
by ghanshyamkhetan
Thu Nov 22, 2007 8:16 am
Forum: Application DBA & System Administration
Topic: how to add module in oracle apps
Replies: 1
Views: 1348

how to add module in oracle apps

Hi,

I have a small query. can any one tell me how to add module in applications.
In database it is ok but in application i don't know.

Please help me.

Many thanks
Ghanshyam
by ghanshyamkhetan
Tue Nov 20, 2007 2:59 am
Forum: Application DBA & System Administration
Topic: Oracle Applications Patch 2525184
Replies: 2
Views: 1645

Hi you can download patch from metalink.oracle.com

Following way u can apply the patch.
===================================
How can you apply a bug Patch on Oracle Application

Steps: Go through the steps;

1) Shutdown the applications.
2) Down load the patch
3) Read the insructions that is ...
by ghanshyamkhetan
Tue Nov 20, 2007 1:56 am
Forum: Application DBA & System Administration
Topic: How to change user Name from backend
Replies: 3
Views: 3231

Hi ahmad,
After appling this procedure username will change but no responsibility is there. I want my all previous responsibilities.
I can change username also this query:
update fnd_user set username=newuser where username=oldusername;

Please advice.
by ghanshyamkhetan
Tue Nov 20, 2007 1:15 am
Forum: Application DBA & System Administration
Topic: Importance of MO: Security Profile
Replies: 1
Views: 1327

Hi Sajeed,

Through MO we can set joneing means if u have 4 separate zones like south, east,norh,west and u want to create separate responsibity for every zones. All functions will same only changes in system profiles. once u set in system profile in south zone it will show all south zone information.
by ghanshyamkhetan
Fri Oct 19, 2007 2:23 am
Forum: Application DBA & System Administration
Topic: Oracle apps Database Backup & Recovery Scripts?
Replies: 2
Views: 2657

Hello Dear,

Please tell me you are Dba or other guy.

If u r Dba then I tell u one thing nothing is in application Don't confuse.
U can take database backup as per database policy. Like Hotbackup, coldbackup. No extra script for Application.
U can take Application backup as filesystem level.

In ...
by ghanshyamkhetan
Fri Oct 19, 2007 2:08 am
Forum: Application DBA & System Administration
Topic: Renaming the Host Name
Replies: 5
Views: 2924

Hi,

Please login in metalink.
Go to note 341322.1 it will help you. Through this you can easily change the name of host file in application Tier.