http://onlineAppsDBA.com

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

 

Yes Fadi, It can be achieved by configuring multiple middle tiers front ended by Load balancer .

Atul

 

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

 

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

 

Thanks for quick reply

another query which will be helpful to all.

Does this agctl command we have to run from infra (primay) at the time of setup or from any other home.

Further for sync,agctl utility has to be run from primary site (any home).

thanks..
falah

 

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

 

Falah,
Congratulations !!

1- If we are installing the infra and app on same server, Is it mandatory use Virtual I P for tier

Yes, It is mandatory to use Virtual IP for Infrastructure Tier Installation


2- what is the reason of getting the two warnings ASG_IAS-15779 - is this normal..

No this is not normal, It seems DSA server on Middle Tier is down

start it using

opmnctl startproc ias-component=DSA

Try again & let me know results

3- can i now start the instantiate command after setting the primary database.

Yes, Just start Middle tier DSA using command mentioned above & then set database & then Intantiate

 

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

 

Falah,

You don't have to use Virtual Host on Middle Tier .



What is ohsarch.idc.oracle.com ? (Is this the actual host name of machine on which you installed i.e. 192.168.1.1)

If both Middle Tier & Infra Tier are on same host what is DSA port for middle tier (I suppose it would be 7891 )

Check
"netstat -an | grep $port_no" on middle tier

All check log files at $ORACLE_HOME/dsa/logs/duf_server.log


Please use http://teachMeOracle.com/forum to discuss further & mention all details there

 

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

 

Falah,
Name "ohsarch.idc.oracle.com" cannot come into OID by mistake , Check topology.xml file at $OH/dsa/conf

When you installed services on app.abc.com was there any entry for ohsarch.idc.oracle.com (Oracle Hosted Services Architecture Team ;-) , I used to work in past) in /etc/hosts or for servername ?

execute discover topology again & check in topology.xml at $OH/dsa/conf what all server names its registering ?

 

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

 

Falah,
Your AS Guard is not able to retrieve Middle Tier Instance Information .

You need to enable tracing but I am nit going to explain that here , Please use Forum for Discussing issues .

http://teachMeOracle.com/forum

Atul

 

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

 

Hi,

i had raised my queries at teachmeoracle forum for appilication server - As guard.

Can u pls help in solving the issue.

Regards

falah

 

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

 

Hi Atul,

I am regular reader of your site.
I am planing to install a DR site (standby site)using 10gAS guard and 10g data guard.If you have installed earlier could you publish your notes please.

Thanks,

SAT

 

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,

Thanks for this.
There are few questions in my mind, could you please answers these :-
1.Out production site is up and runing for the last 1 years , so what all we need to set up DR site?
2. What about Infra's database , do we need to use database (i suppose not as you said earlier ).

Regards,

SAT

 

Hi Atul,

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

Apologies for typo mistake.

Thanks,

SAT

 

SAT,
Supported & Certified way of DR for Application Server is AS Guard.

When you configure AS Guard AS gaurd will automatically configure Datagaurd for Infrastructure database (If this is installed as per standrad Installation) . If this database is configured by MRCA or Repca then you have to configure Data Guard for database before configuring AS Guard.

1.Out production site is up and runing for the last 1 years , so what all we need to set up DR site?
You have to create another site (with atleast one Middle Tier Home & 1 Infra Home) and then use asgctl utility to configure AS Guard between them .

 

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

 

In 10.1.2.0.0 AS Guard is Installed by default but not started .

opmnctl startproc ias-component=DSA

(DSA server is called as AS Guard , default port is 7890)

You need to do additional steps for AS Guard apart from simply starting it.

2.Will there any data difference on primary and standby database i.e. delay in log shipping etc.

This you can control depending on your requirement .


For Any Issues / doubts raise it in forum at http://teachmeoracle.com/forum under HA Section in Application Server

 

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

 

SAT,
This is my last reply here for your doubts on AS Guard :) (I love to clear your doubts but right place is Forum for that).

When you Install Infra Tier on DR it will Install database as well.

Once you run Instantiate command to link standby site with primary , AS Guard will covert primary database in Archive mode ; shutdown primary database ; copy datafiles from primary to standby (automatically delete original datafiles from standby site database) ; start primary database ; start standby database in standby mode. So you don't have to do any thing .

I hope this is clear :) If not kindly raise further doubt in Forum at http://teachMeOracle.com/forum & I'll get back to you .

Cheers

 

Cheers Atul,

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

Thanks,

SAT

 

Thanks Atul. This is very useful information.
Atul I'm looking for DR solution for Oracle Weblogic server (10.3).
Please Advice.

Thanks
R

 

Hi Atul,

I'm looking for a DR solution for oracle web logic.Is there any thing available for weblogic as well like AS Guard. Please advice.

Thanks

Roop

 

Hi

I'm looking for DR solution for Oracle WebLogic. Is there any similar like AS Guard in weblogic or any other alternate.

Thanks

 

hi atul i have a question which migh need DSA settings to be changed. need your help:

question is :

when i open my forms application, which is developed in forms 10g
it first opens a browser which will have URL like below given one:

https://app.company_name.com:1234/forms/frmservlet?form=first_form.fmx&otherparams=connectRow%3SAASZgPFFAGAAAgXVAAA

then it opens the application.

when i close the form, this web browser also get closed or vice versa.

again when i open forms application, it opens web browser with below URL which is different from above one and then forms application

https://app.company_name.com:1234/forms/frmservlet?form=first_form.fmx&otherparams=connectRow%3SAASZgPFFAGAAAgXVAAB

you can see difference in AAgXVAAA and AAgXVAAB in the URL

i want to know how this URL is assigned each time i open the application??

FYI - i dont insert id ,password. it directly logs me in using my windows id.

does every application user will get separate URL assigned??

will same URL like AGAAAgXVAAA be assigned to more than one user at a time??

what should i do if i dont want to login as other user??


thanks tibbu