http://onlineAppsDBA.com

Hi
my name is jeremiah Ochieng. am the pricipal DBA in Safaricom Kenya. my urgent concern is security for the E-biz. there is always a trade off between the security and the performance. can you highlight for us how we can do this so that we have the best security and performance as well

 

Hi jeremiah,
Thanks for pointing this out. Do you access applications from internet as well or its just from intranet ?

Atul

 

Atul,
Nice post.
By the way, it should be AD_TOP/bin instead of FND_TOP/bin.

-Arunkumar

 

Arun,
Thanks for pointing this , corrected now .

Atul

 

Atul- you said, "Don't forget to take backup before executing autoconfig"

Q is that, what us to take backup & location, can you pl help us

Thanks
Suresh

 

Suresh,
you Just take backup of xml file . (If you are new to autoconfig & not very good in apps you might want to backup middle tier & database ) but if you know how to troubleshoot in case of any issues then no need to backup middle tier & database .

 

Waiting for the xml file's post-mortem..........:)

 

Sandeep,
I am happy to hear that you would like to hear more on XML file .

Few more things you can find here

http://becomeappsdba.blogspot.com/2006/10/unwrapping-xml-context-file-or.html

More I'll write in a week or two as I have few more things which are already in pipeline.

Atul

 

Hi,
We are planning to change the apps password in our production. Usuallly i use to change the apps password using FNDCPASS and run autoconfig to probagate the password change. But now my client dont want to run the autoconfig after password change. I know we can do this by changing some config files. Can you please give info about what configuration files we should change the passwords in 11.5.10.2

by
lac

 

Iac,
You don't have to run Autoconfig after changing apps password , you just need to update wdbsvr.app ($IAS_ORACLE_HOME/Apache/modplsql/conf)

You have to bounce CM after password change.

If you have any custom file in which you store apps password likle startup shutdown script , change there as well.

Atul

 

You don't need to take the backup before running Autoconfig. Since the tool automatically creates a backup in $APPL_TOP/sid_hostname/out directory with the directory name being a time stamp. Just open that directory and run rollback.sh . This will put the system into a status prior to the current Autoconfig run.

 

Thanks Chandramohan for sharing this information with us.

 

Hi Atul & Chandra,

This is my first comment in this site so I am a new kid for all, but not so new for oracle apps DBA world.

Just seeing the content for apps DBA and would like to add my comments whenever I have time..

The location and name of the file stated here for rollback of autoconfig should be:

$APPL_TOP/admin/sid_hostname/out
/date_time_etc/restore.sh

Please correct me if I am not looking at the right file/directory.

Thanks,

KK

 

KK & Chandra ,
Thanks for your feedback & suggestions .

Here is the actual location

Application
--------------
$INST_TOP/admin/out/[MMDDhhmm]

Database
-----------
$RDBMS ORACLE_HOME
/appsutil/out/$CONTEXT_NAME/[MMDDhhmm]

Regerences : Point 5 Rolling back an AutoConfig session

Metalink Note # 387859.1 Using AutoConfig to Manage System Configurations in Oracle Applications Release 12

 

Hi atul...
This is kiran from Hyderabad. Actually i'm a senior lecturer in Physics. As i got bored off in teaching for 8 years, i have chosen Apps DBA to learn. Before that i have learnt Core DBA, but not upto the mark in the subject. Now i'm learning Apps DBA and can i get job being a novice to this field? Pl suggest me in what way i have to read? I'm unable to remember the file locations in different Tiers. Could you pl help me out? Thankyou...

 

Hi Kiran,
You focus on basics and architecture. Don't worry about files initially as long as you knoiw where to find in documentation. You will remeber these file names & location once you start actually working on issues & supporting apps

 

Hi, Atul:
I am faily new to the apps DBA world, when do we usually run autoconfig?

casey

 

Hi,
Whenever you wish to change configuration of apps or when instucted by patch read me or by oracle support.

 

Hi Atul,

Iam Kumar from hyd.Iam working on production instance,so how can i autoconfig run without stop the applications services.

 

Hi Atul,
We can edit the .xml file? when run the autoconfig,what is the back end processes.how .xml file update and read that time.

 

hi

running a autoconfig is safe or it can create issues . do we need to bring down the apps tier for it . Wat really it does it just creates context files or it really updates the instance as well
regards

 

Autoconfig will configure your system as per entry in context file SID_hostname.xml in APPL_TOP/admin . Autoconfig will make cahnges so if you are not confortable then better take backup before running it. There is option to run autoconfig in precheck mode to see what all files and configurations its going to change. For this option check Autoconfig FAQ in metalink

 

Atul, I need to change the topic a bit and this is a major task. I am a newbee to Oracle Application. We have upgraded our Appliction from 11.5.4 to 11.5.10 as well as the platform from Sun Solaris to Dell Serveers running Linux ES4. Now we are running a number of tests at the moment and I was wondering if you could help with just simple cold backup scripts backing everything to tape. What I am asking is not the Linux commands in backing up but just what your simple approach will be in taking a cold backup to tape.

These are my mount points.......
/
/boot
/dev/shm
/home
/tmp
/usr
/var
/u01
/u02
/u03

Thanks.

 

Shutdown application tier and database.

Identity mount point where your application tier and database tier files including data files exists and copy them to tape using tape libbary commands.

 

Thanks for the expertise

 

going into single user mode also helps... AD

 

Hi
My name is Ram. Am the AppsDba. My concern is one of my instance home page is not opening. All the services are runinng fine. DB and listner also running.Is there any reason why the home page is not opening.
Thanks,
Ram.

 

Hi,
can help in the home page is not opening while all the services are running in both the appsTier and dbTier

 

Hi Atul,

Can u pls tell me why Autoconfig is required before running adpreclone, even if we know that our source system is in its updated form? Is it necessary for cloning?

 

Atul,

This is the first time I am responding to your blog. Just wanted to add on a cooment of changing APPS password without running autoconfig.

New APPS password must be updated in two files
$IAS_ORACLE_HOME/Apache/modplsql/cfg/wdbsvr.app on mid tier
and
$ORACLE_HOME/reports60/server/CGIcmd.dat on admin tier

Also we need to bounce CM and Mid Tier services (Apache/forms) to avoid any issues during runtime.

Thanks
Narender Singh

 

Hi,

Iam new to apps. I have 11.5.9 running on RHEL4.0. Unfortunately i have lost scripts on database tier in messing up with preclone and autocfg. Is there any way to retrieve scripts for database tier.

 

hi i am jaya
how can i find apps services are running or no

 

Hi Jaya ,

Just go to the $COMMON_TOP/admin/scrtips/

and check the status using

adapcctl.sh apps/ status

 

Hi,
I am new to OracleEBS.I have installed OracleEBS11i at Machine1(Hp-ux 64 bit).Then i have migrated the 9i database to Oracle 10g,which is at Machine2(hp-ux 64bit).Nw i need to reconfigure my database tire with 10g database instead of 9i(default).How can i do this..?

 

Hi,
I am new to OracleEBS.I have installed OracleEBS11i at Machine1(Hp-ux 64 bit).Then i have migrated the 9i database to Oracle 10g,which is at Machine2(hp-ux 64bit).Nw i need to reconfigure my database tire with 10g database instead of 9i(default).
How can i do this..?

 

Hi,
Whether we required autoconfig after changing apps password using FNDCPASS?

 

Hi,
Whether we required autoconfig after changing apps password using FNDCPASS?