database.xml

Hi,

I am using dd5.6 i have database.xml for my database connection info.

database.xml
----------------
<?xml version="1.0" encoding="UTF-8"?>
<data-deploy-elements>
<database
name = "DBconn"
db="edr00.lsa.com:1521 Smiley Tongue

sr"
user="IN_TAC"
password="***"
vendor="oracle"/>
</data-deploy-elements>

ptdev.isa.com = (DESCRIPTION=
(ADDRESS=(PROTOCOL=tcp)(HOST=edr00)(PORT=1521))
(CONNECT_DATA=(SID=psr))
)

With above info my iwdd.ipl is working.

Now we have new database info like this

PTQA.isa.com=
(DESCRIPTION =
(ADDRESS_LIST =
(LOAD_BALANCE = ON)
(ADDRESS = (PROTOCOL = TCP)(HOST = edphp063)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = edphp065)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = PTQA.isa.com)
)
)

based on the above info i want to update my database.xml

Here i have two hosts i want to know how to specify two hosts in my database.xml

Thanx in advance

Find more posts tagged with

Comments

Migrateduser

Just add another database section and give a different name for the second instance :
<database
name = "DBconn2"
db="ptqa.lsa.com:1521 Smiley Tongue

sr"
user="userwhatever"
password="***"
vendor="oracle"/>

Migrateduser

Thanx for your reply .

If i create another database section in my database.xml

how i can call second instance in my datadeploy configuration file.

Right now for one iam calling like this

<database use="DBconnec1" update-type="base" >

can i used both ???
<database use="DBconnec2" update-type="base" >

Thanx in advance

Migrateduser

Do you need to deploy to 2 databases at same time??
if so you could have 2 destination sections one going to db1 and the other going to db2.
Or you could use param substitution :
database use=$dbname
and in your invocation specify dbname
iwdd.ipl cfg=.. deployment=... dbname=dbconn1 or dbconn2

Migrateduser

Thanx for your clarification to me. In my case it is going to same database.But for maintance purpose they have it on two hosts .

Migrateduser

Hi,

I used like in datadeploy configuration file

use database=$dbname

and in iwdd.ipl i mention
iwdd.ipl cfg=.. dbname=connect1 or connect2 It is giving error saying some wrong with error.
and i defined two connection in my database.xml.

If i removed dbname=connect1 or connect2 in my iwdd.ipl and if used directly use database="Connect1" it is working.

Thanx in advance

iwovjames

just to confirm. your dd.cfg file has something like this in it?

<database use="$dbname">

and your command has this:
iwdd.ipl cfg="mydd.cfg" dbname="connect1" ...

is that true? Could you post snippets of your actual dd.cfg and command

Migrateduser

Hi,

Thanx for your reply

In my dd.cfg i have like this
<data-deploy-elements filepath="/usr/iw-home/httpd/iw-bin/database.xml"/>

<database use="Connec1" update-type="base" >

in my database.xml i have Connec1 info.
in iwdd.ipl i didn't specify connectinfo. It is working fine for one connection.

Actually now i want to connect to other Host which has info in Connec2. So i tried at in iwdd.ipl dbname="connec1" or "connec2"

and in <database use="$dbname">

when i am trying in second way it is giving me the error

Thanx in advance