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: 713

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: 848

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 Gha...
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: 2274

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: 1233

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: 1705

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: 806

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: 1629

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) ...
by ghanshyamkhetan
Wed Nov 28, 2007 12:42 am
Forum: Application DBA & System Administration
Topic: Error on applying patch
Replies: 1
Views: 1114

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: 3735

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 changed.
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: 1207

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: 1469

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 written in...
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: 2736

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: 1163

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: 2389

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 oracl...
by ghanshyamkhetan
Fri Oct 19, 2007 2:08 am
Forum: Application DBA & System Administration
Topic: Renaming the Host Name
Replies: 5
Views: 2491

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.