Nice as always, i was wondering if you can post something related to High availability on application server (web or forms) server if its doable and how can we get there.

thanks and keep up the good work

fadi hasweh
http://oracle-magic.blogspot.com/
Oracle is not Magic, it just takes years of experience

superb doc.
i had one query. can i use the clone command instead of installing the standby software (infra and mid tier).

If yes then before performing the clone what are the software need to install on standby machine.

regards

falahuddin

falahuddin
Thanks a lot for your compliments .
You can clone Middle Tier on standby site (For Infra Node I need to check if you can clone by AS Guard)

You need to install standalone AS Guard in standby site (under oracle_home, though there won’t be any files in that oracle_home apart from as guard before cloning)

Atul

Hi ,

I am glad to inform that I have done the initial step for configuring the AS Guard.

Further I need some clarification.

Let me give u the following details

linux box1.(primary)

Ip 192.168.1.1 - infra.abc.com - IDM +db is installed
Ip 192.168.1.1 - app.abc.com - midtier is installed
etc/host- entries- the above two and Ip 192.168.1.2 - remoteinfra.abc.com - (IDM +db) of standby server

linux box2.(standby)

Ip 192.168.1.2 - infra.abc.com - IDM +db is installed
Ip 192.168.1.2 - app.abc.com - midtier is installed
etc/host- entries- the above two and Ip 192.168.1.2 - remoteinfra.abc.com - (IDM +db) of primary server

DSA server is started on all the four boxes.

when i start the asgctl.sh on primary box in infra home and executed the following commands

ASGCTL> connect asg infra ias_admin/infra123
Successfully connected to infraha:7890
ASGCTL>
ASGCTL>
ASGCTL> discover topology oidpasswd=infra123

Discovering topology on host “infra” with IP address “192.168.1.1″

ohsarch:7890
Connecting to the OID server on host “infra.abc.com” using SSL port “636″ and username “orcladmin”
Getting the list of databases from OID
Gathering database information for SID “dbinfra” from host ” infra.abc.com”
Getting the list of instances from OID
Gathering instance information for “infra_home.infra.abc.com” from host “infra.abc.com”
Gathering instance information for “app_home.app.abc.com” from host “ohsarch.idc.oracle.com”
********** WARNING **********
app: –>ASG_IAS-15779: Error getting instance information for instance “app_home.app.abc.com” from host “app.abc.com”. This instance will be excluded from the topology.xml file
app: –>ASG_IAS-15632: The home that contains instance “app_home.app.abc.com” could not be found
******** END WARNING ********
The topology has been discovered. A topology.xml file has been written to each home in the topology.

ASGCTL>

SGCTL> verify topology with remoteinfraha
Generating default policy for this operation

app:7890
HA directory exists for instance infra_home.infra.abc.com
HA directory exists for instance infra_home.infra.abc.com
Verifying that the topology is symmetrical in both primary and standby configuration
ASGCTL>

Question 1 :-

1- If we are installing the infra and app on same server, Is it mandatory use Virtual I P for tier
2- what is the reason of getting the two warnings ASG_IAS-15779 - is this normal..
3- can i now start the instantiate command after setting the primary database.

Can suggest some replies to the above query it would be very helpful.

Regards

Falahuddin

Hi,

Thanks for responding very quickly.

All four DSA component on two servers are started the following is the result of the opmnctl status command.
DSA | DSA | 32439 | Alive

Further i would like to know whether the above error is the result of not using the Virtual IP

can u suggest me what should i do further.

thanks

falah

Hi,

i have not use the virtual hostname for midtier.. app.abc.com is the hostname.. regarding the name u r referring that has come by mistake..

hostname = app.abc.com

And i accessed the site by http://app.abc.com:7778..
port for infra = 7890
port for midtier =7891

checked the two log files, but there i cannot find anything related to this.

regards
falah

As i explained u earlier..

The hostname for midtier is app.abc.com while writing u the comment i think i made mistake.

Is the above problem due to orainventory or what .. i am using the same orainventory location for infra and apps.

while executing the Discover command in apps home ..it is not able to find the oracle home for infra.

i checked all log but no use.
All the DSA components are alive.

regards

falah

Thanks,,

my login id is not working for teachmeoracle, that is the reason i am not using the forum

Anyways thanks for help

Regards

falah

Falah,
I’ll get back to you on Forum at http://teachMeOracle.com/forum

SAT,
Yes I have done DR for 10g AS using AS Guard which includes Data Guard but to put it all on net is big tedious (I have all docs & steps but need to put them in right doc)

I’ll try to prepare one by end on this month (31-Jan-07). I’ll update it in posting once done . So stay tuned ….

Hi Atul,

pleaes read my second point as … do we need to use dataguard.

Apologies for typo mistake.

Thanks,

SAT

Hi Atul,

Thanks for update.
Few more questions :-

1.We are on the 10g AS 10.1.2.0.0 , so do we need to update AS to use server guard ?
2.Will there any data difference on primary and standby database i.e. delay in log shipping etc.

Thanks in advance,

SAT

Hi Atul,

Great stuff….

Lastly ,on the standy site we if we are installing infra then by default a database will be created for infra tier, so my query is what to do with this database i mean do we need to remove this datbase or what will happen when AS guard will try to create standy database on ifra tier?

Thanks in advance,

SAT

Cheers Atul,

Thanks for your all effort.
I will raise my issues in proper forum.

Thanks,

SAT